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

Line 166: l_BO_Id VARCHAR2(3) := Bom_Globals.Get_Bo_Identifier;

162: l_return_status varchar2(80);
163: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
164: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;
165: l_Token_Tbl Error_Handler.Token_Tbl_Type;
166: l_BO_Id VARCHAR2(3) := Bom_Globals.Get_Bo_Identifier;
167: BEGIN
168: --bug:3254815 Update request id, prog id, prog appl id and prog update date.
169: UPDATE BOM_REFERENCE_DESIGNATORS
170: SET COMPONENT_REFERENCE_DESIGNATOR =

Line 178: , LAST_UPDATED_BY = Bom_Globals.Get_User_Id

174: p_ref_designator_rec.Reference_Designator_Name,
175: p_ref_designator_rec.new_reference_designator
176: )
177: , LAST_UPDATE_DATE = SYSDATE
178: , LAST_UPDATED_BY = Bom_Globals.Get_User_Id
179: , LAST_UPDATE_LOGIN = Bom_Globals.Get_User_Id
180: , REF_DESIGNATOR_COMMENT =
181: DECODE( p_ref_designator_rec.ref_designator_comment
182: , FND_API.G_MISS_CHAR

Line 179: , LAST_UPDATE_LOGIN = Bom_Globals.Get_User_Id

175: p_ref_designator_rec.new_reference_designator
176: )
177: , LAST_UPDATE_DATE = SYSDATE
178: , LAST_UPDATED_BY = Bom_Globals.Get_User_Id
179: , LAST_UPDATE_LOGIN = Bom_Globals.Get_User_Id
180: , REF_DESIGNATOR_COMMENT =
181: DECODE( p_ref_designator_rec.ref_designator_comment
182: , FND_API.G_MISS_CHAR
183: , NULL

Line 212: AND ( ( l_BO_Id = Bom_Globals.G_ECO_BO AND

208: WHERE COMPONENT_REFERENCE_DESIGNATOR =
209: p_ref_designator_rec.Reference_Designator_Name
210: AND COMPONENT_SEQUENCE_ID =
211: p_Ref_Desg_Unexp_Rec.component_sequence_id
212: AND ( ( l_BO_Id = Bom_Globals.G_ECO_BO AND
213: ACD_TYPE = p_Ref_Designator_Rec.acd_type
214: ) OR
215: ( l_BO_Id = Bom_Globals.G_BOM_BO AND
216: (acd_type IS NULL or acd_type = 1)

Line 215: ( l_BO_Id = Bom_Globals.G_BOM_BO AND

211: p_Ref_Desg_Unexp_Rec.component_sequence_id
212: AND ( ( l_BO_Id = Bom_Globals.G_ECO_BO AND
213: ACD_TYPE = p_Ref_Designator_Rec.acd_type
214: ) OR
215: ( l_BO_Id = Bom_Globals.G_BOM_BO AND
216: (acd_type IS NULL or acd_type = 1)
217: /* Bug 5726557; The code is modified to modify the refernce designators
218: when implemneted through an ECO */
219: )

Line 302: IF Bom_Globals.Get_Caller_Type = 'MIGRATION' THEN

298: l_src_comp_seq_id NUMBER := NULL; --bug 7713832
299: BEGIN
300:
301: --Bug 7712832 changes start
302: IF Bom_Globals.Get_Caller_Type = 'MIGRATION' THEN
303: l_src_comp_seq_id := Common_CompSeqIdRD( p_comp_seq_id => p_Ref_Desg_Unexp_Rec.component_sequence_id
304: );
305: END IF;
306: --Bug 7712832 changes end

Line 344: , Bom_Globals.Get_User_Id

340: )
341: VALUES
342: ( p_ref_designator_rec.Reference_Designator_Name
343: , SYSDATE
344: , Bom_Globals.Get_User_Id
345: , SYSDATE
346: , Bom_Globals.Get_User_Id
347: , Bom_Globals.Get_User_Id
348: , DECODE( p_ref_designator_rec.ref_designator_comment

Line 346: , Bom_Globals.Get_User_Id

342: ( p_ref_designator_rec.Reference_Designator_Name
343: , SYSDATE
344: , Bom_Globals.Get_User_Id
345: , SYSDATE
346: , Bom_Globals.Get_User_Id
347: , Bom_Globals.Get_User_Id
348: , DECODE( p_ref_designator_rec.ref_designator_comment
349: , FND_API.G_MISS_CHAR
350: , NULL

Line 347: , Bom_Globals.Get_User_Id

343: , SYSDATE
344: , Bom_Globals.Get_User_Id
345: , SYSDATE
346: , Bom_Globals.Get_User_Id
347: , Bom_Globals.Get_User_Id
348: , DECODE( p_ref_designator_rec.ref_designator_comment
349: , FND_API.G_MISS_CHAR
350: , NULL
351: , p_ref_designator_rec.ref_designator_comment )

Line 356: , Bom_Globals.Get_Prog_AppId

352: , p_ref_designator_rec.Eco_Name
353: , p_Ref_Desg_Unexp_Rec.component_sequence_id
354: , p_ref_designator_rec.acd_type
355: , Fnd_Global.Conc_Request_Id /* Request Id */
356: , Bom_Globals.Get_Prog_AppId
357: , Bom_Globals.Get_Prog_Id
358: , SYSDATE
359: , p_ref_designator_rec.attribute_category
360: , p_ref_designator_rec.attribute1

Line 357: , Bom_Globals.Get_Prog_Id

353: , p_Ref_Desg_Unexp_Rec.component_sequence_id
354: , p_ref_designator_rec.acd_type
355: , Fnd_Global.Conc_Request_Id /* Request Id */
356: , Bom_Globals.Get_Prog_AppId
357: , Bom_Globals.Get_Prog_Id
358: , SYSDATE
359: , p_ref_designator_rec.attribute_category
360: , p_ref_designator_rec.attribute1
361: , p_ref_designator_rec.attribute2

Line 378: IF Bom_Globals.Get_Caller_Type <> 'MIGRATION' THEN --Bug 7713832

374: , p_ref_designator_rec.attribute15
375: , p_ref_designator_rec.Original_System_Reference
376: , l_src_comp_seq_id --bug 7713832
377: );
378: IF Bom_Globals.Get_Caller_Type <> 'MIGRATION' THEN --Bug 7713832
379: BOMPCMBM.Insert_Related_Ref_Desg(p_component_sequence_id => p_Ref_Desg_Unexp_Rec.component_sequence_id
380: , p_ref_desg => p_ref_designator_rec.Reference_Designator_Name
381: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
382: , x_Return_Status => x_return_status);

Line 403: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('ERROR in Insert Row (Ref Desgs)' || substr(SQLERRM, 1, 100) || ' ' || to_char(SQLCODE)); END IF;

399: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
400: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
401: );
402:
403: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('ERROR in Insert Row (Ref Desgs)' || substr(SQLERRM, 1, 100) || ' ' || to_char(SQLCODE)); END IF;
404:
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406:
407: END Insert_Row;

Line 430: l_BO_Id VARCHAR2(3) := Bom_Globals.Get_Bo_Identifier;

426: , x_Return_Status IN OUT NOCOPY VARCHAR2
427: )
428: IS
429: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
430: l_BO_Id VARCHAR2(3) := Bom_Globals.Get_Bo_Identifier;
431:
432: BEGIN
433:
434: DELETE FROM BOM_REFERENCE_DESIGNATORS

Line 437: AND ( ( l_BO_Id = Bom_Globals.G_ECO_BO AND

433:
434: DELETE FROM BOM_REFERENCE_DESIGNATORS
435: WHERE COMPONENT_REFERENCE_DESIGNATOR = p_ref_designator
436: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
437: AND ( ( l_BO_Id = Bom_Globals.G_ECO_BO AND
438: ACD_TYPE = p_acd_type
439: ) OR
440: ( l_BO_Id = Bom_Globals.G_BOM_BO AND
441: acd_type IS NULL

Line 440: ( l_BO_Id = Bom_Globals.G_BOM_BO AND

436: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
437: AND ( ( l_BO_Id = Bom_Globals.G_ECO_BO AND
438: ACD_TYPE = p_acd_type
439: ) OR
440: ( l_BO_Id = Bom_Globals.G_BOM_BO AND
441: acd_type IS NULL
442: )
443: );
444: BOMPCMBM.Delete_Related_Ref_Desg(p_src_comp_seq => p_component_sequence_id

Line 554: x_Return_Status := Bom_Globals.G_RECORD_FOUND;

550: ;
551:
552: x_Ref_Designator_Rec := l_ref_designator_rec;
553: x_Ref_Desg_Unexp_Rec := l_Ref_Desg_Unexp_Rec;
554: x_Return_Status := Bom_Globals.G_RECORD_FOUND;
555:
556: EXCEPTION
557:
558: WHEN NO_DATA_FOUND THEN

Line 559: x_Return_Status := Bom_Globals.G_RECORD_NOT_FOUND;

555:
556: EXCEPTION
557:
558: WHEN NO_DATA_FOUND THEN
559: x_Return_Status := Bom_Globals.G_RECORD_NOT_FOUND;
560:
561: WHEN OTHERS THEN
562: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
563:

Line 580: IF p_ref_designator_rec.transaction_type = Bom_Globals.G_OPR_CREATE

576: l_return_status VARCHAR2(1);
577: BEGIN
578: l_return_status := FND_API.G_RET_STS_SUCCESS;
579:
580: IF p_ref_designator_rec.transaction_type = Bom_Globals.G_OPR_CREATE
581: THEN
582: Insert_Row( p_ref_designator_rec =>
583: p_ref_designator_rec
584: , p_ref_desg_unexp_rec =>

Line 589: ELSIF p_ref_designator_rec.transaction_type = Bom_Globals.G_OPR_UPDATE

585: p_ref_desg_unexp_rec
586: , x_mesg_token_tbl => l_mesg_token_tbl
587: , x_return_status => l_return_status
588: );
589: ELSIF p_ref_designator_rec.transaction_type = Bom_Globals.G_OPR_UPDATE
590: THEN
591: Update_Row( p_ref_designator_rec =>
592: p_ref_designator_rec
593: , p_ref_desg_unexp_rec =>

Line 600: ELSIF p_ref_designator_rec.transaction_type = Bom_Globals.G_OPR_DELETE

596: l_mesg_token_tbl
597: , x_return_status =>
598: l_return_status
599: );
600: ELSIF p_ref_designator_rec.transaction_type = Bom_Globals.G_OPR_DELETE
601: THEN
602: Delete_Row
603: ( p_ref_designator =>
604: p_ref_designator_rec.reference_designator_name