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_BOM_REVISION dependencies on BOM_GLOBALS

Line 52: IF p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE

48: --
49: -- Check if the user has entered a revision that is greater than
50: -- the most current revision. If not then it is an error
51: --
52: IF p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE
53: THEN
54: OPEN c_Get_Revision;
55: FETCH c_Get_Revision INTO l_current_rev, l_current_rev_date;
56:

Line 78: IF (Bom_Globals.get_caller_type()= 'MIGRATION' AND

74: x_return_status := FND_API.G_RET_STS_ERROR;
75: END IF;
76:
77:
78: IF (Bom_Globals.get_caller_type()= 'MIGRATION' AND
79: NVL(p_bom_revision_rec.start_effective_date, SYSDATE) < l_current_rev_date AND
80: NVL(p_bom_revision_rec.start_effective_date, SYSDATE) < SYSDATE )
81:
82: THEN

Line 147: IF ( p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE AND

143: -- an error.
144: --Error_Handler.Write_Debug( 'Current '||to_char(p_bom_revision_rec.start_effective_date));
145: --Error_Handler.Write_Debug(' Old '||to_char(p_old_bom_revision_rec.start_effective_date));
146: --Error_Handler.Write_Debug(p_bom_revision_rec.transaction_type );
147: IF ( p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE AND
148: Bom_Globals.get_caller_type()<> 'MIGRATION' AND -- bug 2869453
149: NVL(p_bom_revision_rec.start_effective_date, SYSDATE) < SYSDATE
150: ) OR
151: ( p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_UPDATE AND

Line 148: Bom_Globals.get_caller_type()<> 'MIGRATION' AND -- bug 2869453

144: --Error_Handler.Write_Debug( 'Current '||to_char(p_bom_revision_rec.start_effective_date));
145: --Error_Handler.Write_Debug(' Old '||to_char(p_old_bom_revision_rec.start_effective_date));
146: --Error_Handler.Write_Debug(p_bom_revision_rec.transaction_type );
147: IF ( p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE AND
148: Bom_Globals.get_caller_type()<> 'MIGRATION' AND -- bug 2869453
149: NVL(p_bom_revision_rec.start_effective_date, SYSDATE) < SYSDATE
150: ) OR
151: ( p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_UPDATE AND
152: p_old_bom_revision_Rec.start_effective_date <>

Line 151: ( p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_UPDATE AND

147: IF ( p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE AND
148: Bom_Globals.get_caller_type()<> 'MIGRATION' AND -- bug 2869453
149: NVL(p_bom_revision_rec.start_effective_date, SYSDATE) < SYSDATE
150: ) OR
151: ( p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_UPDATE AND
152: p_old_bom_revision_Rec.start_effective_date <>
153: p_bom_revision_rec.start_effective_date AND
154: ( NVL(p_bom_revision_rec.start_effective_date,SYSDATE) < SYSDATE
155: OR p_old_bom_revision_Rec.start_effective_date < SYSDATE )

Line 232: IF l_return_status = Bom_Globals.G_RECORD_FOUND AND

228: l_token_tbl(1).token_value := p_bom_revision_rec.revision;
229: l_token_tbl(2).token_name := 'ASSEMBLY_ITEM_NAME';
230: l_token_tbl(2).token_value := p_bom_revision_rec.assembly_item_name;
231:
232: IF l_return_status = Bom_Globals.G_RECORD_FOUND AND
233: p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE
234: THEN
235: Error_Handler.Add_Error_Token
236: ( p_message_name => 'BOM_REVISION_ALREADY_EXISTS'

Line 233: p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE

229: l_token_tbl(2).token_name := 'ASSEMBLY_ITEM_NAME';
230: l_token_tbl(2).token_value := p_bom_revision_rec.assembly_item_name;
231:
232: IF l_return_status = Bom_Globals.G_RECORD_FOUND AND
233: p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE
234: THEN
235: Error_Handler.Add_Error_Token
236: ( p_message_name => 'BOM_REVISION_ALREADY_EXISTS'
237: , p_message_text => NULL

Line 243: ELSIF l_return_status = BOM_Globals.G_RECORD_NOT_FOUND AND

239: , p_mesg_token_tbl => l_mesg_token_tbl
240: , x_mesg_token_tbl => l_mesg_token_tbl
241: );
242: x_return_status := FND_API.G_RET_STS_ERROR;
243: ELSIF l_return_status = BOM_Globals.G_RECORD_NOT_FOUND AND
244: p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_UPDATE
245: THEN
246: Error_Handler.Add_Error_Token
247: ( p_message_name => 'BOM_REVISION_DOESNOT_EXIST'

Line 244: p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_UPDATE

240: , x_mesg_token_tbl => l_mesg_token_tbl
241: );
242: x_return_status := FND_API.G_RET_STS_ERROR;
243: ELSIF l_return_status = BOM_Globals.G_RECORD_NOT_FOUND AND
244: p_bom_revision_rec.transaction_type = Bom_Globals.G_OPR_UPDATE
245: THEN
246: Error_Handler.Add_Error_Token
247: ( p_message_name => 'BOM_REVISION_DOESNOT_EXIST'
248: , p_message_text => NULL

Line 273: IF l_return_status = Bom_Globals.G_RECORD_FOUND THEN

269:
270: /* Assign the relevant transaction type for SYNC operations */
271:
272: IF p_bom_revision_rec.transaction_type = 'SYNC' THEN
273: IF l_return_status = Bom_Globals.G_RECORD_FOUND THEN
274: x_old_bom_revision_rec.transaction_type :=
275: Bom_Globals.G_OPR_UPDATE;
276: ELSE
277: x_old_bom_revision_rec.transaction_type :=

Line 275: Bom_Globals.G_OPR_UPDATE;

271:
272: IF p_bom_revision_rec.transaction_type = 'SYNC' THEN
273: IF l_return_status = Bom_Globals.G_RECORD_FOUND THEN
274: x_old_bom_revision_rec.transaction_type :=
275: Bom_Globals.G_OPR_UPDATE;
276: ELSE
277: x_old_bom_revision_rec.transaction_type :=
278: Bom_Globals.G_OPR_CREATE;
279: END IF;

Line 278: Bom_Globals.G_OPR_CREATE;

274: x_old_bom_revision_rec.transaction_type :=
275: Bom_Globals.G_OPR_UPDATE;
276: ELSE
277: x_old_bom_revision_rec.transaction_type :=
278: Bom_Globals.G_OPR_CREATE;
279: END IF;
280: END IF;
281: x_return_status := FND_API.G_RET_STS_SUCCESS;
282: