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 FND_API

Line 56: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

52: )
53: IS
54: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
55: l_bom_head_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
56: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
57: l_dummy varchar2(10);
58: BEGIN
59: SELECT decode(p_alternate_bom_code, FND_API.G_MISS_CHAR,
60: 'Missing', NULL, 'XXXX', p_alternate_bom_code)

Line 59: SELECT decode(p_alternate_bom_code, FND_API.G_MISS_CHAR,

55: l_bom_head_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
56: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
57: l_dummy varchar2(10);
58: BEGIN
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

Line 127: NVL(DECODE( p_alternate_bom_code,FND_API.G_MISS_CHAR,

123: WHERE assembly_item_id = p_assembly_item_id
124: AND organization_id = p_organization_id
125: AND effectivity_control <>4 -- Rev effective structures should be filtered.
126: AND NVL(alternate_bom_designator, 'XXXX') =
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;

Line 141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
142: x_bom_header_rec := l_bom_header_rec;
143: x_bom_head_unexp_rec := l_bom_head_unexp_rec;
144:
145: END Query_Row;

Line 172: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

168: )
169: IS
170: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
171: l_bom_head_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
172: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
173: l_dummy varchar2(10);
174: BEGIN
175: SELECT decode(p_alternate_bom_code, FND_API.G_MISS_CHAR,
176: 'Missing', NULL, 'XXXX', p_alternate_bom_code)

Line 175: SELECT decode(p_alternate_bom_code, FND_API.G_MISS_CHAR,

171: l_bom_head_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
172: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
173: l_dummy varchar2(10);
174: BEGIN
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

Line 240: NVL(DECODE( p_alternate_bom_code,FND_API.G_MISS_CHAR,

236: FROM bom_structures_b
237: WHERE assembly_item_id = p_assembly_item_id
238: AND organization_id = p_organization_id
239: AND NVL(alternate_bom_designator, 'XXXX') =
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;

Line 254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
255: x_bom_header_rec := l_bom_header_rec;
256: x_bom_head_unexp_rec := l_bom_head_unexp_rec;
257:
258: END Query_Table_Row;

Line 343: FND_API.G_MISS_CHAR,

339: VALUES
340: ( p_bom_head_unexp_rec.assembly_item_id
341: , p_bom_head_unexp_rec.organization_id
342: , DECODE(p_bom_header_rec.alternate_bom_code,
343: FND_API.G_MISS_CHAR,
344: NULL,
345: p_bom_header_rec.alternate_bom_code)
346: , DECODE(p_bom_head_unexp_rec.common_bill_sequence_id,
347: FND_API.G_MISS_NUM,

Line 347: FND_API.G_MISS_NUM,

343: FND_API.G_MISS_CHAR,
344: NULL,
345: p_bom_header_rec.alternate_bom_code)
346: , DECODE(p_bom_head_unexp_rec.common_bill_sequence_id,
347: FND_API.G_MISS_NUM,
348: NULL,
349: p_bom_head_unexp_rec.bill_sequence_id,
350: NULL,
351: p_bom_head_unexp_rec.common_assembly_item_id

Line 354: FND_API.G_MISS_NUM,

350: NULL,
351: p_bom_head_unexp_rec.common_assembly_item_id
352: )
353: , DECODE(p_bom_head_unexp_rec.common_bill_sequence_id,
354: FND_API.G_MISS_NUM,
355: NULL,
356: p_bom_head_unexp_rec.bill_sequence_id,
357: NULL,
358: p_bom_head_unexp_rec.common_organization_id

Line 363: FND_API.G_MISS_NUM,

359: )
360: , p_bom_header_rec.Assembly_Type /* Assembly Type */
361: , p_bom_head_unexp_rec.bill_sequence_id
362: , DECODE(p_bom_head_unexp_rec.common_bill_sequence_id,
363: FND_API.G_MISS_NUM,
364: p_bom_head_unexp_rec.bill_sequence_id,
365: NULL,
366: p_bom_head_unexp_rec.bill_sequence_id,
367: p_bom_head_unexp_rec.common_bill_sequence_id

Line 370: FND_API.G_MISS_CHAR,

366: p_bom_head_unexp_rec.bill_sequence_id,
367: p_bom_head_unexp_rec.common_bill_sequence_id
368: )
369: , DECODE(p_bom_header_rec.assembly_comment,
370: FND_API.G_MISS_CHAR,
371: NULL,
372: p_bom_header_rec.assembly_comment)
373: , DECODE(p_bom_header_rec.original_system_reference,
374: FND_API.G_MISS_CHAR,

Line 374: FND_API.G_MISS_CHAR,

370: FND_API.G_MISS_CHAR,
371: NULL,
372: p_bom_header_rec.assembly_comment)
373: , DECODE(p_bom_header_rec.original_system_reference,
374: FND_API.G_MISS_CHAR,
375: NULL,
376: p_bom_header_rec.original_system_reference)
377: , p_bom_header_rec.attribute_category
378: , p_bom_header_rec.attribute1

Line 407: FND_API.G_MISS_NUM,

403: , p_bom_head_unexp_rec.organization_id
404: , decode ( l_preferred_flag, 'N',null,'Y')
405: -- , p_bom_head_unexp_rec.source_bill_sequence_id
406: , DECODE(p_bom_head_unexp_rec.source_bill_sequence_id,
407: FND_API.G_MISS_NUM,
408: p_bom_head_unexp_rec.bill_sequence_id,
409: NULL,
410: p_bom_head_unexp_rec.bill_sequence_id,
411: p_bom_head_unexp_rec.source_bill_sequence_id

Line 419: x_return_status := FND_API.G_RET_STS_SUCCESS;

415: , Fnd_Global.Conc_Program_Id
416: , Fnd_Global.Prog_Appl_Id
417: , sysdate
418: );
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;

Line 433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

429: ' :Inserting Record ' ||
430: SQLERRM
431: , x_mesg_token_Tbl => x_mesg_token_tbl
432: );
433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
434:
435: END Insert_Row;
436:
437: /********************************************************************

Line 491: FND_API.G_MISS_CHAR,

487: IF l_is_common_bom = TRUE THEN
488: UPDATE bom_bill_of_materials
489: SET specific_assembly_comment =
490: DECODE(p_bom_header_rec.assembly_comment,
491: FND_API.G_MISS_CHAR,
492: NULL,
493: p_bom_header_rec.assembly_comment
494: )
495: , original_system_reference =

Line 497: FND_API.G_MISS_CHAR,

493: p_bom_header_rec.assembly_comment
494: )
495: , original_system_reference =
496: DECODE(p_bom_header_rec.original_system_reference,
497: FND_API.G_MISS_CHAR,
498: NULL,
499: p_bom_header_rec.original_system_reference
500: )
501: , last_update_date = SYSDATE

Line 534: FND_API.G_MISS_NUM,

530:
531: UPDATE bom_bill_of_materials
532: SET common_assembly_item_id =
533: DECODE(p_bom_head_unexp_rec.common_assembly_item_id,
534: FND_API.G_MISS_NUM,
535: null,
536: p_bom_head_unexp_rec.common_assembly_item_id
537: )
538: , common_organization_id =

Line 540: FND_API.G_MISS_NUM,

536: p_bom_head_unexp_rec.common_assembly_item_id
537: )
538: , common_organization_id =
539: DECODE(p_bom_head_unexp_rec.common_organization_id,
540: FND_API.G_MISS_NUM,
541: null,
542: p_bom_head_unexp_rec.common_organization_id
543: )
544: , common_bill_sequence_id =

Line 546: FND_API.G_MISS_NUM,

542: p_bom_head_unexp_rec.common_organization_id
543: )
544: , common_bill_sequence_id =
545: DECODE(p_bom_head_unexp_rec.common_bill_sequence_id,
546: FND_API.G_MISS_NUM,
547: p_bom_head_unexp_rec.bill_sequence_id,
548: NULL,
549: p_bom_head_unexp_rec.bill_sequence_id,
550: p_bom_head_unexp_rec.common_bill_sequence_id

Line 554: FND_API.G_MISS_CHAR,

550: p_bom_head_unexp_rec.common_bill_sequence_id
551: )
552: , specific_assembly_comment =
553: DECODE(p_bom_header_rec.assembly_comment,
554: FND_API.G_MISS_CHAR,
555: NULL,
556: p_bom_header_rec.assembly_comment
557: )
558: , original_system_reference =

Line 560: FND_API.G_MISS_CHAR,

556: p_bom_header_rec.assembly_comment
557: )
558: , original_system_reference =
559: DECODE(p_bom_header_rec.original_system_reference,
560: FND_API.G_MISS_CHAR,
561: NULL,
562: p_bom_header_rec.original_system_reference
563: )
564: , source_bill_sequence_id =

Line 566: FND_API.G_MISS_NUM,

562: p_bom_header_rec.original_system_reference
563: )
564: , source_bill_sequence_id =
565: DECODE(p_bom_head_unexp_rec.source_bill_sequence_id,
566: FND_API.G_MISS_NUM,
567: p_bom_head_unexp_rec.bill_sequence_id,
568: NULL,
569: p_bom_head_unexp_rec.bill_sequence_id,
570: p_bom_head_unexp_rec.source_bill_sequence_id

Line 597: FND_API.G_MISS_NUM,

593: , program_application_id = Fnd_Global.Prog_Appl_Id
594: , program_update_date = sysdate
595: , structure_type_id =
596: DECODE(p_bom_head_unexp_rec.structure_type_id,
597: FND_API.G_MISS_NUM,
598: structure_type_id,
599: NULL,
600: structure_type_id,
601: p_bom_head_unexp_rec.structure_type_id

Line 644: x_return_status := FND_API.G_RET_STS_SUCCESS;

640: l_assembly_type NUMBER;
641:
642:
643: BEGIN
644: x_return_status := FND_API.G_RET_STS_SUCCESS;
645:
646: FOR DG IN CheckGroup
647: LOOP
648: IF DG.delete_type <> 2 /* Bill */ then

Line 657: x_return_status := FND_API.G_RET_STS_ERROR;

653: l_mesg_token_Tbl
654: , x_mesg_token_tbl =>
655: l_mesg_token_tbl
656: );
657: x_return_status := FND_API.G_RET_STS_ERROR;
658: x_mesg_token_tbl := l_mesg_token_tbl;
659: RETURN;
660: END IF;
661:

Line 668: IF l_bom_head_unexp_rec.DG_Sequence_Id <> FND_API.G_MISS_NUM

664: l_bom_header_rec.DG_Description := DG.description;
665:
666: END LOOP;
667:
668: IF l_bom_head_unexp_rec.DG_Sequence_Id <> FND_API.G_MISS_NUM
669: THEN
670: l_dg_sequence_id := l_bom_head_unexp_rec.DG_Sequence_Id;
671: ELSE
672: l_dg_sequence_id := NULL;

Line 725: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

721: , x_return_status IN OUT NOCOPY VARCHAR2
722: )
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