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_SUB_COMPONENT dependencies on FND_API

Line 41: p_sub_component_rec.Revised_Item_Name = FND_API.G_MISS_CHAR OR

37: IS
38: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
39: BEGIN
40: IF p_sub_component_rec.Revised_Item_Name IS NULL OR
41: p_sub_component_rec.Revised_Item_Name = FND_API.G_MISS_CHAR OR
42: p_sub_component_rec.Start_Effective_Date IS NULL OR
43: p_sub_component_rec.Start_Effective_Date = FND_API.G_MISS_DATE OR
44: p_sub_component_rec.Operation_Sequence_Number IS NULL OR
45: p_sub_component_rec.Operation_Sequence_Number = FND_API.G_MISS_NUM OR

Line 43: p_sub_component_rec.Start_Effective_Date = FND_API.G_MISS_DATE OR

39: BEGIN
40: IF p_sub_component_rec.Revised_Item_Name IS NULL OR
41: p_sub_component_rec.Revised_Item_Name = FND_API.G_MISS_CHAR OR
42: p_sub_component_rec.Start_Effective_Date IS NULL OR
43: p_sub_component_rec.Start_Effective_Date = FND_API.G_MISS_DATE OR
44: p_sub_component_rec.Operation_Sequence_Number IS NULL OR
45: p_sub_component_rec.Operation_Sequence_Number = FND_API.G_MISS_NUM OR
46: p_sub_component_rec.Component_Item_Name IS NULL OR
47: p_sub_component_rec.Component_Item_Name = FND_API.G_MISS_CHAR OR

Line 45: p_sub_component_rec.Operation_Sequence_Number = FND_API.G_MISS_NUM OR

41: p_sub_component_rec.Revised_Item_Name = FND_API.G_MISS_CHAR OR
42: p_sub_component_rec.Start_Effective_Date IS NULL OR
43: p_sub_component_rec.Start_Effective_Date = FND_API.G_MISS_DATE OR
44: p_sub_component_rec.Operation_Sequence_Number IS NULL OR
45: p_sub_component_rec.Operation_Sequence_Number = FND_API.G_MISS_NUM OR
46: p_sub_component_rec.Component_Item_Name IS NULL OR
47: p_sub_component_rec.Component_Item_Name = FND_API.G_MISS_CHAR OR
48: p_sub_component_rec.Alternate_BOM_Code IS NULL OR
49: p_sub_component_rec.Alternate_BOM_Code = FND_API.G_MISS_CHAR OR

Line 47: p_sub_component_rec.Component_Item_Name = FND_API.G_MISS_CHAR OR

43: p_sub_component_rec.Start_Effective_Date = FND_API.G_MISS_DATE OR
44: p_sub_component_rec.Operation_Sequence_Number IS NULL OR
45: p_sub_component_rec.Operation_Sequence_Number = FND_API.G_MISS_NUM OR
46: p_sub_component_rec.Component_Item_Name IS NULL OR
47: p_sub_component_rec.Component_Item_Name = FND_API.G_MISS_CHAR OR
48: p_sub_component_rec.Alternate_BOM_Code IS NULL OR
49: p_sub_component_rec.Alternate_BOM_Code = FND_API.G_MISS_CHAR OR
50: p_sub_component_rec.Substitute_Component_Name IS NULL OR
51: p_sub_component_rec.Substitute_Component_Name = FND_API.G_MISS_CHAR OR

Line 49: p_sub_component_rec.Alternate_BOM_Code = FND_API.G_MISS_CHAR OR

45: p_sub_component_rec.Operation_Sequence_Number = FND_API.G_MISS_NUM OR
46: p_sub_component_rec.Component_Item_Name IS NULL OR
47: p_sub_component_rec.Component_Item_Name = FND_API.G_MISS_CHAR OR
48: p_sub_component_rec.Alternate_BOM_Code IS NULL OR
49: p_sub_component_rec.Alternate_BOM_Code = FND_API.G_MISS_CHAR OR
50: p_sub_component_rec.Substitute_Component_Name IS NULL OR
51: p_sub_component_rec.Substitute_Component_Name = FND_API.G_MISS_CHAR OR
52: ( ( p_sub_component_rec.acd_type IS NULL OR
53: p_sub_component_rec.acd_type = FND_API.G_MISS_NUM OR

Line 51: p_sub_component_rec.Substitute_Component_Name = FND_API.G_MISS_CHAR OR

47: p_sub_component_rec.Component_Item_Name = FND_API.G_MISS_CHAR OR
48: p_sub_component_rec.Alternate_BOM_Code IS NULL OR
49: p_sub_component_rec.Alternate_BOM_Code = FND_API.G_MISS_CHAR OR
50: p_sub_component_rec.Substitute_Component_Name IS NULL OR
51: p_sub_component_rec.Substitute_Component_Name = FND_API.G_MISS_CHAR OR
52: ( ( p_sub_component_rec.acd_type IS NULL OR
53: p_sub_component_rec.acd_type = FND_API.G_MISS_NUM OR
54: p_sub_component_rec.New_Revised_Item_Revision IS NULL OR
55: p_sub_component_rec.New_Revised_Item_Revision =

Line 53: p_sub_component_rec.acd_type = FND_API.G_MISS_NUM OR

49: p_sub_component_rec.Alternate_BOM_Code = FND_API.G_MISS_CHAR OR
50: p_sub_component_rec.Substitute_Component_Name IS NULL OR
51: p_sub_component_rec.Substitute_Component_Name = FND_API.G_MISS_CHAR OR
52: ( ( p_sub_component_rec.acd_type IS NULL OR
53: p_sub_component_rec.acd_type = FND_API.G_MISS_NUM OR
54: p_sub_component_rec.New_Revised_Item_Revision IS NULL OR
55: p_sub_component_rec.New_Revised_Item_Revision =
56: FND_API.G_MISS_CHAR
57: ) AND

Line 56: FND_API.G_MISS_CHAR

52: ( ( p_sub_component_rec.acd_type IS NULL OR
53: p_sub_component_rec.acd_type = FND_API.G_MISS_NUM OR
54: p_sub_component_rec.New_Revised_Item_Revision IS NULL OR
55: p_sub_component_rec.New_Revised_Item_Revision =
56: FND_API.G_MISS_CHAR
57: ) AND
58: Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO
59: )
60: THEN

Line 61: x_return_status := FND_API.G_RET_STS_ERROR;

57: ) AND
58: Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO
59: )
60: THEN
61: x_return_status := FND_API.G_RET_STS_ERROR;
62: Error_Handler.Add_Error_Token
63: ( x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
64: , p_Message_Name => 'BOM_SUB_COMP_REQ'
65: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 72: x_return_status := FND_API.G_RET_STS_SUCCESS;

68: -- missing with scope of 'R'
69: RETURN;
70: END IF;
71:
72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73:
74: END CHECK_REQUIRED;
75:
76: /*******************************************************************

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

93: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
94: )
95: IS
96: l_temp_var NUMBER :=0;
97: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
98: l_sub_comp_unique VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
99: l_dummy NUMBER :=0;
100: l_dummy2 NUMBER :=0;
101: l_parent_acd_type NUMBER :=0;

Line 98: l_sub_comp_unique VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

94: )
95: IS
96: l_temp_var NUMBER :=0;
97: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
98: l_sub_comp_unique VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
99: l_dummy NUMBER :=0;
100: l_dummy2 NUMBER :=0;
101: l_parent_acd_type NUMBER :=0;
102: l_parent_BIT NUMBER;

Line 176: l_Return_Status := FND_API.G_RET_STS_ERROR;

172: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
173: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
174: , p_Token_Tbl => l_Token_Tbl
175: );
176: l_Return_Status := FND_API.G_RET_STS_ERROR;
177: END;
178:
179: SELECT msi.bom_enabled_flag
180: INTO l_assy_bom_enabled

Line 202: l_return_status := FND_API.G_RET_STS_ERROR;

198: , p_message_name => 'BOM_REV_ITEM_BOM_NOT_ENABLED'
199: , p_token_tbl => l_token_tbl
200: );
201: END IF;
202: l_return_status := FND_API.G_RET_STS_ERROR;
203: END IF;
204:
205: IF p_control_rec.caller_type <> 'FORM'
206: THEN

Line 223: l_return_status := FND_API.G_RET_STS_ERROR;

219:
220: IF l_rec_bit IN (1, 2, 3, 5)
221: THEN
222: l_err_text := 'BOM_SBC_NON_STD_PARENT';
223: l_return_status := FND_API.G_RET_STS_ERROR;
224: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
225: -- dbms_output.put_line
226: -- ('Expected Error. non-standard component . . . ');
227:

Line 239: l_return_status := FND_API.G_RET_STS_ERROR;

235: END IF;
236:
237: IF l_parent_bit = 3 THEN
238: l_Err_text := 'BOM_SBC_PLANNING_BILL';
239: l_return_status := FND_API.G_RET_STS_ERROR;
240:
241: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
242: -- dbms_output.put_line
243: -- ('Expected Error. planning parent. . . ');

Line 272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

268: , p_message_text => 'ERROR in Entity validation ' ||
269: substr(SQLERRM, 1, 240) || ' ' ||
270: to_char(SQLCODE)
271: );
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END;
274:
275: END IF;
276:

Line 318: FND_API.G_MISS_NUM,

314: WHERE organization_id = p_Sub_Comp_Unexp_Rec.Organization_Id
315: AND inventory_item_id = decode(p_Sub_Comp_Unexp_Rec.new_substitute_component_id,
316: NULL,
317: p_Sub_Comp_Unexp_Rec.substitute_component_id,
318: FND_API.G_MISS_NUM,
319: p_Sub_Comp_Unexp_Rec.substitute_component_id,
320: p_Sub_Comp_Unexp_Rec.new_substitute_component_id
321: );
322:

Line 332: l_return_status := FND_API.G_RET_STS_ERROR;

328: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
329: , p_message_name => 'BOM_SUB_COMP_NOT_STD'
330: );
331: END IF;
332: l_return_status := FND_API.G_RET_STS_ERROR;
333: END IF;
334: /* Validations for OPM Convergence Project
335: Dual UOM controlled items should not be allowed*/
336:

Line 343: l_return_status := FND_API.G_RET_STS_ERROR;

339: ( p_Message_name => 'BOM_DUAL_UOM_ITEMS'
340: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
341: , x_mesg_token_tbl => l_mesg_token_tbl
342: );
343: l_return_status := FND_API.G_RET_STS_ERROR;
344: END IF;
345:
346: /* IF l_sbc_bom_enabled_flag <> 'Y'
347: THEN

Line 359: l_return_status := FND_API.G_RET_STS_ERROR;

355: , p_message_name => 'BOM_SUB_COMP_NOT_BOM_ENABLED'
356: , p_token_tbl => l_token_tbl
357: );
358: END IF;
359: l_return_status := FND_API.G_RET_STS_ERROR;
360: END IF; */ -- Commented as part of bug 3420657.
361:
362: -- IF ((l_rec_AST = 2) OR (l_rec_AST = 1 AND l_sbc_eng_item_flag = 'Y')) -- Bug No: 3561608
363: IF (l_rec_AST = 1 AND l_sbc_eng_item_flag = 'Y')

Line 372: l_return_status := FND_API.G_RET_STS_ERROR;

368: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
369: , p_message_name => 'BOM_SUB_COMP_ASSEMBLY_MFG'
370: );
371: END IF;
372: l_return_status := FND_API.G_RET_STS_ERROR;
373: END IF;
374:
375: EXCEPTION
376: WHEN no_data_found THEN

Line 404: FND_API.G_MISS_NUM,

400: AND msi.inventory_item_id =
401: decode(p_Sub_Comp_Unexp_Rec.new_substitute_component_id,
402: NULL,
403: p_Sub_Comp_Unexp_Rec.substitute_component_id,
404: FND_API.G_MISS_NUM,
405: p_Sub_Comp_Unexp_Rec.substitute_component_id,
406: p_Sub_Comp_Unexp_Rec.new_substitute_component_id
407: )
408: AND msi.bom_enabled_flag = 'Y'

Line 425: l_return_status := FND_API.G_RET_STS_ERROR;

421: , p_message_name => 'BOM_SBC_COMBILL_DOES_NOT_EXIST'
422: , p_token_tbl => l_token_tbl
423: );
424: END IF;
425: l_return_status := FND_API.G_RET_STS_ERROR;
426: EXCEPTION
427: WHEN no_data_found THEN
428: null;
429: END;

Line 456: l_return_status := FND_API.G_RET_STS_ERROR;

452: , p_message_name => 'BOM_SUBCOMP_SAMEAS_ITEM_COMP'
453: , p_token_tbl => l_token_tbl
454: );
455: END IF;
456: l_return_status := FND_API.G_RET_STS_ERROR;
457: END IF;
458:
459: ------------------------------------------
460: -- Validate attribute dependencies here.|

Line 479: l_return_status := FND_API.G_RET_STS_ERROR;

475: --
476: IF Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO
477: THEN
478: IF l_parent_acd_type = 3 THEN
479: l_return_status := FND_API.G_RET_STS_ERROR;
480: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
481: Error_Handler.Add_Error_Token
482: ( x_Mesg_Token_tbl => l_Mesg_Token_tbl
483: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 495: l_return_status := FND_API.G_RET_STS_ERROR;

491: -------------------------------------------------------------------
492: stmt_num := 12;
493: IF ((l_parent_acd_type = 1 ) and ( p_Sub_Component_Rec.ACD_Type <> 1))
494: THEN
495: l_return_status := FND_API.G_RET_STS_ERROR;
496: l_token_tbl(1).token_name := 'REVISED_COMPONENT_NAME';
497: l_token_tbl(1).token_value := p_sub_component_rec.component_item_name;
498: Error_Handler.Add_Error_Token
499: ( x_Mesg_Token_tbl => l_Mesg_Token_tbl

Line 566: l_return_status := FND_API.G_RET_STS_ERROR;

562: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
563: , p_message_name => 'BOM_DISABLE_SCOMP_NOT_FOUND'
564: , p_token_tbl => l_token_tbl
565: );
566: l_return_status := FND_API.G_RET_STS_ERROR;
567: END IF;
568: END;
569: END IF;
570: END IF; -- ECO BO only validations ends

Line 576: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

572: END IF; -- end of code that executes when ECO form has not called package.
573:
574: -- dbms_output.put_line('l_return_status : '|| l_return_status);
575:
576: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
578: END IF;
579:
580: ----------------------------

Line 577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

573:
574: -- dbms_output.put_line('l_return_status : '|| l_return_status);
575:
576: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
578: END IF;
579:
580: ----------------------------
581: -- Done validating entity |

Line 591: and p_Sub_Comp_Unexp_Rec.new_substitute_component_id <> FND_API.G_MISS_NUM

587: /* When the Substitute component is updated with new Substitute Component, It should be checked that the
588: New Substitute Component does not exists already */
589:
590: IF ( p_Sub_Comp_Unexp_Rec.new_substitute_component_id is not null
591: and p_Sub_Comp_Unexp_Rec.new_substitute_component_id <> FND_API.G_MISS_NUM
592: and p_sub_component_rec.transaction_type = Bom_Globals.G_OPR_UPDATE) THEN
593:
594: select count(*) into l_temp_var
595: FROM BOM_SUBSTITUTE_COMPONENTS

Line 598: AND NVL(DECODE(ACD_TYPE, FND_API.G_MISS_NUM, null, acd_type), 0) =

594: select count(*) into l_temp_var
595: FROM BOM_SUBSTITUTE_COMPONENTS
596: WHERE substitute_component_id = p_Sub_Comp_Unexp_Rec.new_substitute_component_id
597: AND COMPONENT_SEQUENCE_ID = p_Sub_Comp_Unexp_Rec.component_sequence_id
598: AND NVL(DECODE(ACD_TYPE, FND_API.G_MISS_NUM, null, acd_type), 0) =
599: NVL(DECODE(p_sub_component_rec.acd_type, FND_API.G_MISS_NUM, null, p_sub_component_rec.acd_type), 0) ;
600:
601: IF (l_temp_var <>0) then
602:

Line 599: NVL(DECODE(p_sub_component_rec.acd_type, FND_API.G_MISS_NUM, null, p_sub_component_rec.acd_type), 0) ;

595: FROM BOM_SUBSTITUTE_COMPONENTS
596: WHERE substitute_component_id = p_Sub_Comp_Unexp_Rec.new_substitute_component_id
597: AND COMPONENT_SEQUENCE_ID = p_Sub_Comp_Unexp_Rec.component_sequence_id
598: AND NVL(DECODE(ACD_TYPE, FND_API.G_MISS_NUM, null, acd_type), 0) =
599: NVL(DECODE(p_sub_component_rec.acd_type, FND_API.G_MISS_NUM, null, p_sub_component_rec.acd_type), 0) ;
600:
601: IF (l_temp_var <>0) then
602:
603: l_Token_Tbl(1).Token_Name := 'SUBSTITUTE_ITEM_NAME';

Line 615: RAISE FND_API.G_EXC_ERROR;

611: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
612: , p_message_name => 'BOM_SUB_COMP_ALREADY_EXISTS'
613: , p_token_tbl => l_token_tbl
614: );
615: RAISE FND_API.G_EXC_ERROR;
616: END IF;
617: END IF;
618:
619: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verified New Substitute Component ...'); END IF;

Line 624: WHEN FND_API.G_EXC_ERROR THEN

620:
621:
622:
623: EXCEPTION
624: WHEN FND_API.G_EXC_ERROR THEN
625: -- dbms_output.put_line('expected Error : stmt_num -'
626: -- || to_char(stmt_num));
627: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
628: x_return_status := FND_API.G_RET_STS_ERROR;

Line 628: x_return_status := FND_API.G_RET_STS_ERROR;

624: WHEN FND_API.G_EXC_ERROR THEN
625: -- dbms_output.put_line('expected Error : stmt_num -'
626: -- || to_char(stmt_num));
627: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
630: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
632: -- dbms_output.put_line('unexpected Error : stmt_num -'

Line 629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

625: -- dbms_output.put_line('expected Error : stmt_num -'
626: -- || to_char(stmt_num));
627: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
630: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
632: -- dbms_output.put_line('unexpected Error : stmt_num -'
633: -- || to_char(stmt_num));

Line 631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

627: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
630: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
632: -- dbms_output.put_line('unexpected Error : stmt_num -'
633: -- || to_char(stmt_num));
634: WHEN OTHERS THEN
635: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;

Line 636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

632: -- dbms_output.put_line('unexpected Error : stmt_num -'
633: -- || to_char(stmt_num));
634: WHEN OTHERS THEN
635: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
637: -- dbms_output.put_line('other unexpected Error :
638: -- stmt_num -' || to_char(stmt_num));
639: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
640: THEN

Line 679: l_return_status := FND_API.G_RET_STS_SUCCESS;

675: l_token_tbl Error_Handler.Token_Tbl_Type;
676: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
677: BEGIN
678:
679: l_return_status := FND_API.G_RET_STS_SUCCESS;
680:
681: /**************************************************************************
682: With patch to bug 728002, this is not valid now
683:

Line 698: x_return_status := FND_API.G_RET_STS_ERROR;

694: , p_message_name => 'BOM_SUB_COMP_QTY_ZERO'
695: , p_token_tbl => l_token_tbl
696: );
697: END IF;
698: x_return_status := FND_API.G_RET_STS_ERROR;
699:
700: END IF;
701: **************************************************************************/
702:

Line 724: l_return_status := FND_API.G_RET_STS_ERROR;

720: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
721: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
722: , p_Token_Tbl => l_Token_Tbl
723: );
724: l_return_status := FND_API.G_RET_STS_ERROR;
725:
726: WHEN OTHERS THEN
727:
728: Error_Handler.Add_Error_Token

Line 737: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

733: to_char(SQLCODE)
734: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
735: , p_Mesg_Token_Tbl => l_Mesg_token_Tbl
736: );
737: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
738: END;
739:
740: x_return_status := l_return_status;
741: x_mesg_token_tbl := l_mesg_token_tbl;

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

761: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
762: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
763: )
764: IS
765: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
766: l_err_text VARCHAR2(255);
767: l_rec_ID DATE := NULL;
768: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
769: BEGIN

Line 825: ELSIF p_sub_component_rec.transaction_type = FND_API.G_MISS_CHAR THEN

821: );
822:
823: IF p_sub_component_rec.transaction_type IS NULL THEN
824: Error_Handler.Write_Debug ('In SCOMP Check Exist ...is NULL');
825: ELSIF p_sub_component_rec.transaction_type = FND_API.G_MISS_CHAR THEN
826: Error_Handler.Write_Debug ('In SCOMP Check Exist ...is MISSING');
827: ELSE
828: Error_Handler.Write_Debug('In SCOMP Check Exist...'||p_sub_component_rec.transaction_type);
829: END IF;

Line 840: l_return_status := FND_API.G_RET_STS_ERROR;

836: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
837: , p_message_name => 'BOM_SUB_COMP_ALREADY_EXISTS'
838: , p_token_tbl => l_token_tbl
839: );
840: l_return_status := FND_API.G_RET_STS_ERROR;
841: ELSIF l_return_status = Bom_Globals.G_RECORD_NOT_FOUND AND
842: p_sub_component_rec.transaction_type IN
843: (Bom_Globals.G_OPR_UPDATE, Bom_Globals.G_OPR_DELETE)
844: THEN

Line 851: l_return_status := FND_API.G_RET_STS_ERROR;

847: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
848: , p_message_name => 'BOM_SUB_COMP_DOESNOT_EXIST'
849: , p_token_tbl => l_token_tbl
850: );
851: l_return_status := FND_API.G_RET_STS_ERROR;
852: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
853: THEN
854: Error_Handler.Add_Error_Token
855: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl

Line 852: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR

848: , p_message_name => 'BOM_SUB_COMP_DOESNOT_EXIST'
849: , p_token_tbl => l_token_tbl
850: );
851: l_return_status := FND_API.G_RET_STS_ERROR;
852: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
853: THEN
854: Error_Handler.Add_Error_Token
855: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
856: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 877: l_return_status := FND_API.G_RET_STS_SUCCESS;

873: x_old_sub_component_rec.transaction_type :=
874: Bom_Globals.G_OPR_CREATE;
875: END IF;
876: END IF;
877: l_return_status := FND_API.G_RET_STS_SUCCESS;
878: END IF;
879:
880: x_return_status := l_return_status;
881: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;

Line 913: x_return_status := FND_API.G_RET_STS_SUCCESS;

909: AND operation_seq_num = p_sub_component_rec.operation_sequence_number
910: AND effectivity_date = p_sub_component_rec.start_effective_date
911: AND bill_sequence_id = p_sub_comp_unexp_rec.bill_sequence_id;
912: BEGIN
913: x_return_status := FND_API.G_RET_STS_SUCCESS;
914:
915: FOR Component IN c_GetComponent LOOP
916: IF NVL(Component.revised_item_sequence_id, 0) <>
917: NVL(p_sub_comp_unexp_rec.revised_item_sequence_id, 0)

Line 938: x_return_status := FND_API.G_RET_STS_ERROR;

934: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
935: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
936: , p_Token_Tbl => l_Token_Tbl
937: );
938: x_return_status := FND_API.G_RET_STS_ERROR;
939: END IF;
940: END LOOP;
941:
942: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;

Line 977: l_return_status := FND_API.G_RET_STS_SUCCESS;

973: WHERE inventory_item_id = p_sub_comp_unexp_rec.substitute_component_id
974: AND organization_id = p_sub_comp_unexp_rec.organization_id;
975:
976: BEGIN
977: l_return_status := FND_API.G_RET_STS_SUCCESS;
978:
979: SELECT process_enabled_flag
980: INTO l_OPM_org
981: FROM mtl_parameters

Line 997: l_return_status := FND_API.G_RET_STS_ERROR;

993: ( p_Message_name => 'BOM_OPM_ORG_MODEL_OC'
994: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
995: , x_mesg_token_tbl => l_mesg_token_tbl
996: );
997: l_return_status := FND_API.G_RET_STS_ERROR;
998: ELSIF SubCompType.bom_item_type = Bom_Globals.G_PRODUCT_FAMILY
999: THEN
1000: Error_Handler.Add_Error_Token
1001: ( p_Message_Name => 'BOM_SUB_COMP_PF'

Line 1006: l_return_status := FND_API.G_RET_STS_ERROR;

1002: , p_mesg_token_tbl => l_mesg_token_tbl
1003: , x_mesg_token_tbl => l_mesg_token_tbl
1004: , p_token_tbl => l_token_tbl
1005: );
1006: l_return_status := FND_API.G_RET_STS_ERROR;
1007: ELSIF SubCompType.bom_item_type NOT IN
1008: (NVL(Bom_Globals.Get_MDL_Item_Access,0),
1009: NVL(Bom_Globals.Get_OC_Item_Access,0),
1010: NVL(Bom_Globals.Get_PLN_Item_Access,0),

Line 1041: l_return_status := FND_API.G_RET_STS_ERROR;

1037: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1038: , p_Token_Tbl => l_token_tbl
1039: );
1040: l_token_tbl.DELETE(2);
1041: l_return_status := FND_API.G_RET_STS_ERROR;
1042: END IF;
1043: END LOOP;
1044: x_return_status := l_return_status;
1045: