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_RTG_REVISION_UTIL dependencies on BOM_RTG_GLOBALS

Line 53: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN

49: l_rtg_rev_unexp_rec Bom_Rtg_Pub.Rtg_rev_Unexposed_Rec_Type;
50: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
51: l_dummy varchar2(10);
52: BEGIN
53: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
54: Error_Handler.Write_Debug('Revision: ' ||
55: l_rtg_revision_rec.revision );
56: END IF;
57:

Line 104: x_return_status := BOM_Rtg_Globals.G_RECORD_FOUND;

100: WHERE inventory_item_id = p_assembly_item_id
101: AND organization_id = p_organization_id
102: AND process_revision = p_revision;
103:
104: x_return_status := BOM_Rtg_Globals.G_RECORD_FOUND;
105: x_rtg_revision_rec := l_rtg_revision_rec;
106: x_rtg_rev_unexp_rec := l_rtg_rev_unexp_rec;
107:
108: EXCEPTION

Line 110: x_return_status := BOM_Rtg_Globals.G_RECORD_NOT_FOUND;

106: x_rtg_rev_unexp_rec := l_rtg_rev_unexp_rec;
107:
108: EXCEPTION
109: WHEN NO_DATA_FOUND THEN
110: x_return_status := BOM_Rtg_Globals.G_RECORD_NOT_FOUND;
111: x_rtg_revision_rec := l_rtg_revision_rec;
112: x_rtg_rev_unexp_rec := l_rtg_rev_unexp_rec;
113: WHEN OTHERS THEN
114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 148: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN

144: = trunc(sysdate) THEN
145: l_start_effectivity_date :=
146: to_date(to_char(sysdate,'DD-MON-YY-HH24:MI:SS'),
147: 'DD-MON-YY-HH24:MI:SS');
148: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
149: Error_Handler.Write_Debug('start_effective_date :'||
150: to_char(l_start_effectivity_date,'DD-MON-YY-HH24:MI:SS'));
151: END IF;
152: ELSIF

Line 162: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN

158: END IF; */
159:
160: l_start_effectivity_date := p_rtg_revision_rec.start_effective_date; -- Bug 5970070
161:
162: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
163: Error_Handler.Write_Debug('Writing rtg Revisioner rec for '
164: || p_rtg_revision_rec.assembly_item_name);
165: END IF;
166:

Line 223: , BOM_Rtg_Globals.Get_User_Id

219: , p_rtg_revision_rec.attribute13
220: , p_rtg_revision_rec.attribute14
221: , p_rtg_revision_rec.attribute15
222: , SYSDATE
223: , BOM_Rtg_Globals.Get_User_Id
224: , SYSDATE
225: , BOM_Rtg_Globals.Get_User_Id
226: , BOM_Rtg_Globals.Get_User_Id
227: , Fnd_Global.Conc_Request_Id

Line 225: , BOM_Rtg_Globals.Get_User_Id

221: , p_rtg_revision_rec.attribute15
222: , SYSDATE
223: , BOM_Rtg_Globals.Get_User_Id
224: , SYSDATE
225: , BOM_Rtg_Globals.Get_User_Id
226: , BOM_Rtg_Globals.Get_User_Id
227: , Fnd_Global.Conc_Request_Id
228: , Fnd_Global.Conc_Program_Id
229: , Fnd_Global.Prog_Appl_Id

Line 226: , BOM_Rtg_Globals.Get_User_Id

222: , SYSDATE
223: , BOM_Rtg_Globals.Get_User_Id
224: , SYSDATE
225: , BOM_Rtg_Globals.Get_User_Id
226: , BOM_Rtg_Globals.Get_User_Id
227: , Fnd_Global.Conc_Request_Id
228: , Fnd_Global.Conc_Program_Id
229: , Fnd_Global.Prog_Appl_Id
230: , SYSDATE

Line 272: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN

268: -- The only fields that are updateable in RTG Revisioner are the
269: -- CTP, Priority, completion subinventory, completion_locator,
270: --
271: --
272: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
273: Error_Handler.Write_Debug('Updating routing revision '
274: || p_rtg_revision_rec.revision);
275: END IF;
276:

Line 283: , last_updated_by = BOM_Rtg_Globals.Get_User_Id

279: p_rtg_revision_rec.start_effective_date
280: , implementation_date =
281: p_rtg_revision_rec.start_effective_date
282: , last_update_date = SYSDATE
283: , last_updated_by = BOM_Rtg_Globals.Get_User_Id
284: , last_update_login = BOM_Rtg_Globals.Get_User_Id
285: , attribute_category =p_rtg_revision_rec.attribute_category , attribute1 = p_rtg_revision_rec.attribute1
286: , attribute2 = p_rtg_revision_rec.attribute2
287: , attribute3 = p_rtg_revision_rec.attribute3

Line 284: , last_update_login = BOM_Rtg_Globals.Get_User_Id

280: , implementation_date =
281: p_rtg_revision_rec.start_effective_date
282: , last_update_date = SYSDATE
283: , last_updated_by = BOM_Rtg_Globals.Get_User_Id
284: , last_update_login = BOM_Rtg_Globals.Get_User_Id
285: , attribute_category =p_rtg_revision_rec.attribute_category , attribute1 = p_rtg_revision_rec.attribute1
286: , attribute2 = p_rtg_revision_rec.attribute2
287: , attribute3 = p_rtg_revision_rec.attribute3
288: , attribute4 = p_rtg_revision_rec.attribute4

Line 335: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN

331:
332: BEGIN
333: x_return_status := FND_API.G_RET_STS_SUCCESS;
334:
335: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
336: Error_Handler.Write_Debug('Delete routing revision '
337: || p_rtg_revision_rec.revision);
338: END IF;
339:

Line 381: BOM_Rtg_Globals.G_OPR_CREATE THEN

377: l_Mesg_Token_tbl Error_Handler.Mesg_Token_Tbl_Type;
378: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
379: BEGIN
380: IF p_rtg_revision_rec.transaction_type =
381: BOM_Rtg_Globals.G_OPR_CREATE THEN
382: Insert_Row
383: ( p_rtg_revision_rec => p_rtg_revision_rec
384: , p_rtg_rev_unexp_rec => p_rtg_rev_unexp_rec
385: , x_mesg_token_Tbl => l_mesg_token_tbl

Line 389: BOM_Rtg_Globals.G_OPR_UPDATE THEN

385: , x_mesg_token_Tbl => l_mesg_token_tbl
386: , x_return_Status => l_return_status
387: );
388: ELSIF p_rtg_revision_rec.transaction_type =
389: BOM_Rtg_Globals.G_OPR_UPDATE THEN
390: Update_Row
391: ( p_rtg_revision_rec => p_rtg_revision_rec
392: , p_rtg_rev_unexp_rec => p_rtg_rev_unexp_rec
393: , x_mesg_token_Tbl => l_mesg_token_tbl

Line 398: BOM_Rtg_Globals.G_OPR_DELETE THEN

394: , x_return_Status => l_return_status
395: );
396:
397: ELSIF p_rtg_revision_rec.transaction_type =
398: BOM_Rtg_Globals.G_OPR_DELETE THEN
399: Delete_Row
400: ( p_rtg_revision_rec => p_rtg_revision_rec
401: , p_rtg_rev_unexp_rec => p_rtg_rev_unexp_rec
402: , x_mesg_token_Tbl => l_mesg_token_tbl