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 466: FND_API.G_MISS_NUM,

462:
463: UPDATE bom_bill_of_materials
464: SET common_assembly_item_id =
465: DECODE(p_bom_head_unexp_rec.common_assembly_item_id,
466: FND_API.G_MISS_NUM,
467: null,
468: p_bom_head_unexp_rec.common_assembly_item_id
469: )
470: , common_organization_id =

Line 472: FND_API.G_MISS_NUM,

468: p_bom_head_unexp_rec.common_assembly_item_id
469: )
470: , common_organization_id =
471: DECODE(p_bom_head_unexp_rec.common_organization_id,
472: FND_API.G_MISS_NUM,
473: null,
474: p_bom_head_unexp_rec.common_organization_id
475: )
476: , common_bill_sequence_id =

Line 478: FND_API.G_MISS_NUM,

474: p_bom_head_unexp_rec.common_organization_id
475: )
476: , common_bill_sequence_id =
477: DECODE(p_bom_head_unexp_rec.common_bill_sequence_id,
478: FND_API.G_MISS_NUM,
479: p_bom_head_unexp_rec.bill_sequence_id,
480: NULL,
481: p_bom_head_unexp_rec.bill_sequence_id,
482: p_bom_head_unexp_rec.common_bill_sequence_id

Line 486: FND_API.G_MISS_CHAR,

482: p_bom_head_unexp_rec.common_bill_sequence_id
483: )
484: , specific_assembly_comment =
485: DECODE(p_bom_header_rec.assembly_comment,
486: FND_API.G_MISS_CHAR,
487: NULL,
488: p_bom_header_rec.assembly_comment
489: )
490: , original_system_reference =

Line 492: FND_API.G_MISS_CHAR,

488: p_bom_header_rec.assembly_comment
489: )
490: , original_system_reference =
491: DECODE(p_bom_header_rec.original_system_reference,
492: FND_API.G_MISS_CHAR,
493: NULL,
494: p_bom_header_rec.original_system_reference
495: )
496: , source_bill_sequence_id =

Line 498: FND_API.G_MISS_NUM,

494: p_bom_header_rec.original_system_reference
495: )
496: , source_bill_sequence_id =
497: DECODE(p_bom_head_unexp_rec.source_bill_sequence_id,
498: FND_API.G_MISS_NUM,
499: p_bom_head_unexp_rec.bill_sequence_id,
500: NULL,
501: p_bom_head_unexp_rec.bill_sequence_id,
502: p_bom_head_unexp_rec.source_bill_sequence_id

Line 529: FND_API.G_MISS_NUM,

525: , program_application_id = Fnd_Global.Prog_Appl_Id
526: , program_update_date = sysdate
527: , structure_type_id =
528: DECODE(p_bom_head_unexp_rec.structure_type_id,
529: FND_API.G_MISS_NUM,
530: structure_type_id,
531: NULL,
532: structure_type_id,
533: p_bom_head_unexp_rec.structure_type_id

Line 574: x_return_status := FND_API.G_RET_STS_SUCCESS;

570: l_assembly_type NUMBER;
571:
572:
573: BEGIN
574: x_return_status := FND_API.G_RET_STS_SUCCESS;
575:
576: FOR DG IN CheckGroup
577: LOOP
578: IF DG.delete_type <> 2 /* Bill */ then

Line 587: x_return_status := FND_API.G_RET_STS_ERROR;

583: l_mesg_token_Tbl
584: , x_mesg_token_tbl =>
585: l_mesg_token_tbl
586: );
587: x_return_status := FND_API.G_RET_STS_ERROR;
588: x_mesg_token_tbl := l_mesg_token_tbl;
589: RETURN;
590: END IF;
591:

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

594: l_bom_header_rec.DG_Description := DG.description;
595:
596: END LOOP;
597:
598: IF l_bom_head_unexp_rec.DG_Sequence_Id <> FND_API.G_MISS_NUM
599: THEN
600: l_dg_sequence_id := l_bom_head_unexp_rec.DG_Sequence_Id;
601: ELSE
602: l_dg_sequence_id := NULL;

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

651: , x_return_status IN OUT NOCOPY VARCHAR2
652: )
653: IS
654: l_Mesg_Token_tbl Error_Handler.Mesg_Token_Tbl_Type;
655: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
656: BEGIN
657: IF p_bom_header_rec.transaction_type = BOM_GLOBALS.G_OPR_CREATE
658: THEN
659: Insert_Row