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

Line 63: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Alt: ' || l_dummy

59: SELECT decode(p_alternate_bom_code, FND_API.G_MISS_CHAR,
60: 'Missing', NULL, 'XXXX', p_alternate_bom_code)
61: INTO l_dummy
62: from sys.dual;
63: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Alt: ' || l_dummy
64: ); END IF;
65:
66: SELECT assembly_item_id
67: , organization_id

Line 131: x_return_status := BOM_Globals.G_RECORD_FOUND;

127: NVL(DECODE( p_alternate_bom_code,FND_API.G_MISS_CHAR,
128: NULL, p_alternate_bom_code
129: ), 'XXXX');
130:
131: x_return_status := BOM_Globals.G_RECORD_FOUND;
132: x_bom_header_rec := l_bom_header_rec;
133: x_bom_head_unexp_rec := l_bom_head_unexp_rec;
134:
135: EXCEPTION

Line 137: x_return_status := BOM_Globals.G_RECORD_NOT_FOUND;

133: x_bom_head_unexp_rec := l_bom_head_unexp_rec;
134:
135: EXCEPTION
136: WHEN NO_DATA_FOUND THEN
137: x_return_status := BOM_Globals.G_RECORD_NOT_FOUND;
138: x_bom_header_rec := l_bom_header_rec;
139: x_bom_head_unexp_rec := l_bom_head_unexp_rec;
140: WHEN OTHERS THEN
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 179: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Alt: ' || l_dummy

175: SELECT decode(p_alternate_bom_code, FND_API.G_MISS_CHAR,
176: 'Missing', NULL, 'XXXX', p_alternate_bom_code)
177: INTO l_dummy
178: from sys.dual;
179: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Alt: ' || l_dummy
180: ); END IF;
181:
182: SELECT assembly_item_id
183: , organization_id

Line 244: x_return_status := BOM_Globals.G_RECORD_FOUND;

240: NVL(DECODE( p_alternate_bom_code,FND_API.G_MISS_CHAR,
241: NULL, p_alternate_bom_code
242: ), 'XXXX');
243:
244: x_return_status := BOM_Globals.G_RECORD_FOUND;
245: x_bom_header_rec := l_bom_header_rec;
246: x_bom_head_unexp_rec := l_bom_head_unexp_rec;
247:
248: EXCEPTION

Line 250: x_return_status := BOM_Globals.G_RECORD_NOT_FOUND;

246: x_bom_head_unexp_rec := l_bom_head_unexp_rec;
247:
248: EXCEPTION
249: WHEN NO_DATA_FOUND THEN
250: x_return_status := BOM_Globals.G_RECORD_NOT_FOUND;
251: x_bom_header_rec := l_bom_header_rec;
252: x_bom_head_unexp_rec := l_bom_head_unexp_rec;
253: WHEN OTHERS THEN
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 282: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Writing Bom Header rec for ' || p_bom_header_rec.assembly_item_name); END IF;

278: l_effectivity_control NUMBER;
279: x_err_text varchar2(2000);
280: BEGIN
281:
282: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Writing Bom Header rec for ' || p_bom_header_rec.assembly_item_name); END IF;
283:
284: l_effectivity_control := get_effectivity_control
285: (p_bom_head_unexp_rec.assembly_item_id,
286: p_bom_head_unexp_rec.organization_id);

Line 394: , BOM_Globals.Get_User_Id

390: , p_bom_header_rec.attribute13
391: , p_bom_header_rec.attribute14
392: , p_bom_header_rec.attribute15
393: , SYSDATE
394: , BOM_Globals.Get_User_Id
395: , SYSDATE
396: , BOM_Globals.Get_User_Id
397: , BOM_Globals.Get_User_Id
398: , p_bom_head_unexp_rec.structure_type_id

Line 396: , BOM_Globals.Get_User_Id

392: , p_bom_header_rec.attribute15
393: , SYSDATE
394: , BOM_Globals.Get_User_Id
395: , SYSDATE
396: , BOM_Globals.Get_User_Id
397: , BOM_Globals.Get_User_Id
398: , p_bom_head_unexp_rec.structure_type_id
399: , p_bom_header_rec.bom_implementation_date
400: , l_effectivity_control

Line 397: , BOM_Globals.Get_User_Id

393: , SYSDATE
394: , BOM_Globals.Get_User_Id
395: , SYSDATE
396: , BOM_Globals.Get_User_Id
397: , BOM_Globals.Get_User_Id
398: , p_bom_head_unexp_rec.structure_type_id
399: , p_bom_header_rec.bom_implementation_date
400: , l_effectivity_control
401: , NULL

Line 423: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Oracle Error in Writing Bom Header rec ' || to_char(sqlcode)||'/'||sqlerrm); END IF;

419: x_return_status := FND_API.G_RET_STS_SUCCESS;
420:
421: EXCEPTION
422: WHEN OTHERS THEN
423: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Oracle Error in Writing Bom Header rec ' || to_char(sqlcode)||'/'||sqlerrm); END IF;
424: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('The mandatory values are, Assembly_item_id : ' ||to_char(p_bom_head_unexp_rec.assembly_item_id)); END IF;
425: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Bill_Sequence_Id : '||to_char(p_bom_head_unexp_rec.bill_sequence_id)||'. User Id : '||to_char(Bom_Globals.Get_User_Id)); END IF;
426: Error_Handler.Add_Error_Token
427: ( p_message_name => NULL

Line 424: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('The mandatory values are, Assembly_item_id : ' ||to_char(p_bom_head_unexp_rec.assembly_item_id)); END IF;

420:
421: EXCEPTION
422: WHEN OTHERS THEN
423: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Oracle Error in Writing Bom Header rec ' || to_char(sqlcode)||'/'||sqlerrm); END IF;
424: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('The mandatory values are, Assembly_item_id : ' ||to_char(p_bom_head_unexp_rec.assembly_item_id)); END IF;
425: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Bill_Sequence_Id : '||to_char(p_bom_head_unexp_rec.bill_sequence_id)||'. User Id : '||to_char(Bom_Globals.Get_User_Id)); END IF;
426: Error_Handler.Add_Error_Token
427: ( p_message_name => NULL
428: , p_message_text => G_PKG_NAME ||

Line 425: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Bill_Sequence_Id : '||to_char(p_bom_head_unexp_rec.bill_sequence_id)||'. User Id : '||to_char(Bom_Globals.Get_User_Id)); END IF;

421: EXCEPTION
422: WHEN OTHERS THEN
423: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Oracle Error in Writing Bom Header rec ' || to_char(sqlcode)||'/'||sqlerrm); END IF;
424: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('The mandatory values are, Assembly_item_id : ' ||to_char(p_bom_head_unexp_rec.assembly_item_id)); END IF;
425: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Bill_Sequence_Id : '||to_char(p_bom_head_unexp_rec.bill_sequence_id)||'. User Id : '||to_char(Bom_Globals.Get_User_Id)); END IF;
426: Error_Handler.Add_Error_Token
427: ( p_message_name => NULL
428: , p_message_text => G_PKG_NAME ||
429: ' :Inserting Record ' ||

Line 470: IF Bom_Globals.Get_Debug = 'Y' THEN

466: --
467: -- The only fields that are updateable in BOM Header is the
468: -- common bill information
469: --
470: IF Bom_Globals.Get_Debug = 'Y' THEN
471: Error_Handler.Write_Debug('Updating bill seq ' || p_bom_head_unexp_rec.bill_sequence_id);
472: END IF;
473:
474: -- Added for bug 8208327

Line 502: , last_updated_by = BOM_Globals.Get_User_Id

498: NULL,
499: p_bom_header_rec.original_system_reference
500: )
501: , last_update_date = SYSDATE
502: , last_updated_by = BOM_Globals.Get_User_Id
503: , last_update_login = BOM_Globals.Get_User_Id
504: , attribute_category = p_bom_header_rec.attribute_category
505: , attribute1 = p_bom_header_rec.attribute1
506: , attribute2 = p_bom_header_rec.attribute2

Line 503: , last_update_login = BOM_Globals.Get_User_Id

499: p_bom_header_rec.original_system_reference
500: )
501: , last_update_date = SYSDATE
502: , last_updated_by = BOM_Globals.Get_User_Id
503: , last_update_login = BOM_Globals.Get_User_Id
504: , attribute_category = p_bom_header_rec.attribute_category
505: , attribute1 = p_bom_header_rec.attribute1
506: , attribute2 = p_bom_header_rec.attribute2
507: , attribute3 = p_bom_header_rec.attribute3

Line 573: , last_updated_by = BOM_Globals.Get_User_Id

569: p_bom_head_unexp_rec.bill_sequence_id,
570: p_bom_head_unexp_rec.source_bill_sequence_id
571: )
572: , last_update_date = SYSDATE
573: , last_updated_by = BOM_Globals.Get_User_Id
574: , last_update_login = BOM_Globals.Get_User_Id
575: , attribute_category = p_bom_header_rec.attribute_category
576: , attribute1 = p_bom_header_rec.attribute1
577: , attribute2 = p_bom_header_rec.attribute2

Line 574: , last_update_login = BOM_Globals.Get_User_Id

570: p_bom_head_unexp_rec.source_bill_sequence_id
571: )
572: , last_update_date = SYSDATE
573: , last_updated_by = BOM_Globals.Get_User_Id
574: , last_update_login = BOM_Globals.Get_User_Id
575: , attribute_category = p_bom_header_rec.attribute_category
576: , attribute1 = p_bom_header_rec.attribute1
577: , attribute2 = p_bom_header_rec.attribute2
578: , attribute3 = p_bom_header_rec.attribute3

Line 700: user_id => BOM_Globals.Get_User_Id

696: ent_inv_item_id => l_bom_head_unexp_rec.assembly_item_id,
697: ent_alt_designator => l_bom_header_rec.alternate_bom_code,
698: ent_comp_seq_id => NULL,
699: ent_op_seq_id => NULL,
700: user_id => BOM_Globals.Get_User_Id
701: );
702:
703: x_mesg_token_tbl := l_mesg_token_tbl;
704:

Line 727: IF p_bom_header_rec.transaction_type = BOM_GLOBALS.G_OPR_CREATE

723: IS
724: l_Mesg_Token_tbl Error_Handler.Mesg_Token_Tbl_Type;
725: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
726: BEGIN
727: IF p_bom_header_rec.transaction_type = BOM_GLOBALS.G_OPR_CREATE
728: THEN
729: Insert_Row
730: ( p_bom_header_rec => p_bom_header_rec
731: , p_bom_head_unexp_rec => p_bom_head_unexp_rec

Line 736: BOM_GLOBALS.G_OPR_UPDATE

732: , x_mesg_token_Tbl => l_mesg_token_tbl
733: , x_return_Status => l_return_status
734: );
735: ELSIF p_bom_header_rec.transaction_type =
736: BOM_GLOBALS.G_OPR_UPDATE
737: THEN
738: Update_Row
739: ( p_bom_header_rec => p_bom_header_rec
740: , p_bom_head_unexp_rec => p_bom_head_unexp_rec

Line 746: BOM_GLOBALS.G_OPR_DELETE

742: , x_return_Status => l_return_status
743: );
744:
745: ELSIF p_bom_header_rec.transaction_type =
746: BOM_GLOBALS.G_OPR_DELETE
747: THEN
748: Delete_Row
749: ( p_bom_header_rec => p_bom_header_rec
750: , p_bom_head_unexp_rec => p_bom_head_unexp_rec