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.ENG_VALIDATE_SUB_COMPONENT dependencies on FND_API

Line 23: p_sub_component_rec.Revised_Item_Name = FND_API.G_MISS_CHAR OR

19: IS
20: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
21: BEGIN
22: IF p_sub_component_rec.Revised_Item_Name IS NULL OR
23: p_sub_component_rec.Revised_Item_Name = FND_API.G_MISS_CHAR OR
24: p_sub_component_rec.Start_Effective_Date IS NULL OR
25: p_sub_component_rec.Start_Effective_Date = FND_API.G_MISS_DATE OR
26: p_sub_component_rec.New_Revised_Item_Revision IS NULL OR
27: p_sub_component_rec.New_Revised_Item_Revision = FND_API.G_MISS_CHAR OR

Line 25: p_sub_component_rec.Start_Effective_Date = FND_API.G_MISS_DATE OR

21: BEGIN
22: IF p_sub_component_rec.Revised_Item_Name IS NULL OR
23: p_sub_component_rec.Revised_Item_Name = FND_API.G_MISS_CHAR OR
24: p_sub_component_rec.Start_Effective_Date IS NULL OR
25: p_sub_component_rec.Start_Effective_Date = FND_API.G_MISS_DATE OR
26: p_sub_component_rec.New_Revised_Item_Revision IS NULL OR
27: p_sub_component_rec.New_Revised_Item_Revision = FND_API.G_MISS_CHAR OR
28: p_sub_component_rec.Operation_Sequence_Number IS NULL OR
29: p_sub_component_rec.Operation_Sequence_Number = FND_API.G_MISS_NUM OR

Line 27: p_sub_component_rec.New_Revised_Item_Revision = FND_API.G_MISS_CHAR OR

23: p_sub_component_rec.Revised_Item_Name = FND_API.G_MISS_CHAR OR
24: p_sub_component_rec.Start_Effective_Date IS NULL OR
25: p_sub_component_rec.Start_Effective_Date = FND_API.G_MISS_DATE OR
26: p_sub_component_rec.New_Revised_Item_Revision IS NULL OR
27: p_sub_component_rec.New_Revised_Item_Revision = FND_API.G_MISS_CHAR OR
28: p_sub_component_rec.Operation_Sequence_Number IS NULL OR
29: p_sub_component_rec.Operation_Sequence_Number = FND_API.G_MISS_NUM OR
30: p_sub_component_rec.Component_Item_Name IS NULL OR
31: p_sub_component_rec.Component_Item_Name = FND_API.G_MISS_CHAR OR

Line 29: p_sub_component_rec.Operation_Sequence_Number = FND_API.G_MISS_NUM OR

25: p_sub_component_rec.Start_Effective_Date = FND_API.G_MISS_DATE OR
26: p_sub_component_rec.New_Revised_Item_Revision IS NULL OR
27: p_sub_component_rec.New_Revised_Item_Revision = FND_API.G_MISS_CHAR OR
28: p_sub_component_rec.Operation_Sequence_Number IS NULL OR
29: p_sub_component_rec.Operation_Sequence_Number = FND_API.G_MISS_NUM OR
30: p_sub_component_rec.Component_Item_Name IS NULL OR
31: p_sub_component_rec.Component_Item_Name = FND_API.G_MISS_CHAR OR
32: p_sub_component_rec.Alternate_BOM_Code IS NULL OR
33: p_sub_component_rec.Alternate_BOM_Code = FND_API.G_MISS_CHAR OR

Line 31: p_sub_component_rec.Component_Item_Name = FND_API.G_MISS_CHAR OR

27: p_sub_component_rec.New_Revised_Item_Revision = FND_API.G_MISS_CHAR OR
28: p_sub_component_rec.Operation_Sequence_Number IS NULL OR
29: p_sub_component_rec.Operation_Sequence_Number = FND_API.G_MISS_NUM OR
30: p_sub_component_rec.Component_Item_Name IS NULL OR
31: p_sub_component_rec.Component_Item_Name = FND_API.G_MISS_CHAR OR
32: p_sub_component_rec.Alternate_BOM_Code IS NULL OR
33: p_sub_component_rec.Alternate_BOM_Code = FND_API.G_MISS_CHAR OR
34: p_sub_component_rec.Substitute_Component_Name IS NULL OR
35: p_sub_component_rec.Substitute_Component_Name = FND_API.G_MISS_CHAR OR

Line 33: p_sub_component_rec.Alternate_BOM_Code = FND_API.G_MISS_CHAR OR

29: p_sub_component_rec.Operation_Sequence_Number = FND_API.G_MISS_NUM OR
30: p_sub_component_rec.Component_Item_Name IS NULL OR
31: p_sub_component_rec.Component_Item_Name = FND_API.G_MISS_CHAR OR
32: p_sub_component_rec.Alternate_BOM_Code IS NULL OR
33: p_sub_component_rec.Alternate_BOM_Code = FND_API.G_MISS_CHAR OR
34: p_sub_component_rec.Substitute_Component_Name IS NULL OR
35: p_sub_component_rec.Substitute_Component_Name = FND_API.G_MISS_CHAR OR
36: p_sub_component_rec.acd_type IS NULL OR
37: p_sub_component_rec.acd_type = FND_API.G_MISS_NUM

Line 35: p_sub_component_rec.Substitute_Component_Name = FND_API.G_MISS_CHAR OR

31: p_sub_component_rec.Component_Item_Name = FND_API.G_MISS_CHAR OR
32: p_sub_component_rec.Alternate_BOM_Code IS NULL OR
33: p_sub_component_rec.Alternate_BOM_Code = FND_API.G_MISS_CHAR OR
34: p_sub_component_rec.Substitute_Component_Name IS NULL OR
35: p_sub_component_rec.Substitute_Component_Name = FND_API.G_MISS_CHAR OR
36: p_sub_component_rec.acd_type IS NULL OR
37: p_sub_component_rec.acd_type = FND_API.G_MISS_NUM
38: THEN
39: x_return_status := FND_API.G_RET_STS_ERROR;

Line 37: p_sub_component_rec.acd_type = FND_API.G_MISS_NUM

33: p_sub_component_rec.Alternate_BOM_Code = FND_API.G_MISS_CHAR OR
34: p_sub_component_rec.Substitute_Component_Name IS NULL OR
35: p_sub_component_rec.Substitute_Component_Name = FND_API.G_MISS_CHAR OR
36: p_sub_component_rec.acd_type IS NULL OR
37: p_sub_component_rec.acd_type = FND_API.G_MISS_NUM
38: THEN
39: x_return_status := FND_API.G_RET_STS_ERROR;
40: Error_Handler.Add_Error_Token
41: ( x_Mesg_Token_Tbl => x_Mesg_Token_Tbl

Line 39: x_return_status := FND_API.G_RET_STS_ERROR;

35: p_sub_component_rec.Substitute_Component_Name = FND_API.G_MISS_CHAR OR
36: p_sub_component_rec.acd_type IS NULL OR
37: p_sub_component_rec.acd_type = FND_API.G_MISS_NUM
38: THEN
39: x_return_status := FND_API.G_RET_STS_ERROR;
40: Error_Handler.Add_Error_Token
41: ( x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
42: , p_Message_Name => 'ENG_SUB_COMP_REQ'
43: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 50: x_return_status := FND_API.G_RET_STS_SUCCESS;

46: -- missing with scope of 'R'
47: RETURN;
48: END IF;
49:
50: x_return_status := FND_API.G_RET_STS_SUCCESS;
51:
52: END CHECK_REQUIRED;
53:
54: /*******************************************************************

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

68: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
69: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
70: )
71: IS
72: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
73: l_sub_comp_unique VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
74: l_dummy NUMBER :=0;
75: l_dummy2 NUMBER :=0;
76: l_parent_acd_type NUMBER :=0;

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

69: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
70: )
71: IS
72: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
73: l_sub_comp_unique VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
74: l_dummy NUMBER :=0;
75: l_dummy2 NUMBER :=0;
76: l_parent_acd_type NUMBER :=0;
77: l_parent_BIT NUMBER;

Line 149: l_return_status := FND_API.G_RET_STS_ERROR;

145:
146: IF l_rec_bit IN (1, 2, 3)
147: THEN
148: l_err_text := 'ENG_SBC_NON_STD_PARENT';
149: l_return_status := FND_API.G_RET_STS_ERROR;
150: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
151: --dbms_output.put_line
152: -- ('Expected Error. non-standard component . . . ');
153:

Line 165: l_return_status := FND_API.G_RET_STS_ERROR;

161: END IF;
162:
163: IF l_parent_bit = 3 THEN
164: l_Err_text := 'ENG_SBC_PLANNING_BILL';
165: l_return_status := FND_API.G_RET_STS_ERROR;
166:
167: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
168: --dbms_output.put_line
169: -- ('Expected Error. planning parent. . . ');

Line 198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

194: , p_message_text => 'ERROR in Entity validation ' ||
195: substr(SQLERRM, 1, 240) || ' ' ||
196: to_char(SQLCODE)
197: );
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: END;
200:
201: END IF;
202:

Line 250: l_return_status := FND_API.G_RET_STS_ERROR;

246: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
247: , p_message_name => 'ENG_SUB_COMP_NOT_STD'
248: );
249: END IF;
250: l_return_status := FND_API.G_RET_STS_ERROR;
251: END IF;
252:
253: IF l_sbc_bom_enabled_flag <> 'Y'
254: THEN

Line 266: l_return_status := FND_API.G_RET_STS_ERROR;

262: , p_message_name => 'ENG_SUB_COMP_NOT_BOM_ENABLED'
263: , p_token_tbl => l_token_tbl
264: );
265: END IF;
266: l_return_status := FND_API.G_RET_STS_ERROR;
267: END IF;
268:
269: IF ((l_rec_AST = 2) OR (l_rec_AST = 1 AND l_sbc_eng_item_flag = 'Y'))
270: THEN

Line 278: l_return_status := FND_API.G_RET_STS_ERROR;

274: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
275: , p_message_name => 'ENG_SUB_COMP_ASSEMBLY_MFG'
276: );
277: END IF;
278: l_return_status := FND_API.G_RET_STS_ERROR;
279: END IF;
280:
281: EXCEPTION
282: WHEN no_data_found THEN

Line 323: l_return_status := FND_API.G_RET_STS_ERROR;

319: , p_message_name => 'ENG_SBC_COMBILL_DOES_NOT_EXIST'
320: , p_token_tbl => l_token_tbl
321: );
322: END IF;
323: l_return_status := FND_API.G_RET_STS_ERROR;
324: EXCEPTION
325: WHEN no_data_found THEN
326: null;
327: END;

Line 351: l_return_status := FND_API.G_RET_STS_ERROR;

347: , p_message_name => 'ENG_SUBCOMP_SAMEAS_ITEM_COMP'
348: , p_token_tbl => l_token_tbl
349: );
350: END IF;
351: l_return_status := FND_API.G_RET_STS_ERROR;
352: END IF;
353:
354: ------------------------------------------
355: -- Validate attribute dependencies here.|

Line 368: l_return_status := FND_API.G_RET_STS_ERROR;

364: -- child component. |
365: -----------------------------------------------------------------------
366: stmt_num := 11;
367: IF l_parent_acd_type = 3 THEN
368: l_return_status := FND_API.G_RET_STS_ERROR;
369: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
370: Error_Handler.Add_Error_Token
371: ( x_Mesg_Token_tbl => l_Mesg_Token_tbl
372: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 384: l_return_status := FND_API.G_RET_STS_ERROR;

380: -------------------------------------------------------------------
381: stmt_num := 12;
382: IF ((l_parent_acd_type = 1 ) and ( p_Sub_Component_Rec.ACD_Type <> 1))
383: THEN
384: l_return_status := FND_API.G_RET_STS_ERROR;
385: l_token_tbl(1).token_name := 'REVISED_COMPONENT_NAME';
386: l_token_tbl(1).token_value := p_sub_component_rec.component_item_name;
387: Error_Handler.Add_Error_Token
388: ( x_Mesg_Token_tbl => l_Mesg_Token_tbl

Line 453: l_return_status := FND_API.G_RET_STS_ERROR;

449: , p_message_name => 'ENG_DISABLE_SCOMP_NOT_FOUND'
450: , p_token_tbl => l_token_tbl
451: );
452: end if;
453: l_return_status := FND_API.G_RET_STS_ERROR;
454: END;
455: END IF;
456:
457: ---dbms_output.put_line('l_return_status : '|| l_return_status);

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

455: END IF;
456:
457: ---dbms_output.put_line('l_return_status : '|| l_return_status);
458:
459: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: END IF;
462:
463: ----------------------------

Line 460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

456:
457: ---dbms_output.put_line('l_return_status : '|| l_return_status);
458:
459: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: END IF;
462:
463: ----------------------------
464: -- Done validating entity |

Line 471: WHEN FND_API.G_EXC_ERROR THEN

467: x_return_status := l_return_status;
468: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
469:
470: EXCEPTION
471: WHEN FND_API.G_EXC_ERROR THEN
472: --dbms_output.put_line('expected Error : stmt_num -'
473: -- || to_char(stmt_num));
474: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
475: x_return_status := FND_API.G_RET_STS_ERROR;

Line 475: x_return_status := FND_API.G_RET_STS_ERROR;

471: WHEN FND_API.G_EXC_ERROR THEN
472: --dbms_output.put_line('expected Error : stmt_num -'
473: -- || to_char(stmt_num));
474: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
475: x_return_status := FND_API.G_RET_STS_ERROR;
476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
477: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: --dbms_output.put_line('unexpected Error : stmt_num -'

Line 476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

472: --dbms_output.put_line('expected Error : stmt_num -'
473: -- || to_char(stmt_num));
474: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
475: x_return_status := FND_API.G_RET_STS_ERROR;
476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
477: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: --dbms_output.put_line('unexpected Error : stmt_num -'
480: -- || to_char(stmt_num));

Line 478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

474: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
475: x_return_status := FND_API.G_RET_STS_ERROR;
476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
477: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: --dbms_output.put_line('unexpected Error : stmt_num -'
480: -- || to_char(stmt_num));
481: WHEN OTHERS THEN
482: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;

Line 483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

479: --dbms_output.put_line('unexpected Error : stmt_num -'
480: -- || to_char(stmt_num));
481: WHEN OTHERS THEN
482: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: --dbms_output.put_line('other unexpected Error :
485: -- stmt_num -' || to_char(stmt_num));
486: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
487: THEN

Line 523: x_return_status := FND_API.G_RET_STS_SUCCESS;

519: l_token_tbl Error_Handler.Token_Tbl_Type;
520: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
521: BEGIN
522:
523: x_return_status := FND_API.G_RET_STS_SUCCESS;
524:
525: /**************************************************************************
526: With patch to bug 728002, this is not valid now
527:

Line 542: x_return_status := FND_API.G_RET_STS_ERROR;

538: , p_message_name => 'ENG_SUB_COMP_QTY_ZERO'
539: , p_token_tbl => l_token_tbl
540: );
541: END IF;
542: x_return_status := FND_API.G_RET_STS_ERROR;
543:
544: END IF;
545: **************************************************************************/
546:

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

564: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
565: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
566: )
567: IS
568: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
569: l_err_text VARCHAR2(255);
570: l_rec_ID DATE := NULL;
571: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
572: BEGIN

Line 634: l_return_status := FND_API.G_RET_STS_ERROR;

630: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
631: , p_message_name => 'ENG_SUB_COMP_ALREADY_EXISTS'
632: , p_token_tbl => l_token_tbl
633: );
634: l_return_status := FND_API.G_RET_STS_ERROR;
635: ELSIF l_return_status = Bom_Globals.G_RECORD_NOT_FOUND AND
636: p_sub_component_rec.transaction_type IN
637: (Bom_Globals.G_OPR_UPDATE, Bom_Globals.G_OPR_DELETE)
638: THEN

Line 645: l_return_status := FND_API.G_RET_STS_ERROR;

641: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
642: , p_message_name => 'ENG_SUB_COMP_DOESNOT_EXIST'
643: , p_token_tbl => l_token_tbl
644: );
645: l_return_status := FND_API.G_RET_STS_ERROR;
646: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
647: THEN
648: Error_Handler.Add_Error_Token
649: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl

Line 646: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR

642: , p_message_name => 'ENG_SUB_COMP_DOESNOT_EXIST'
643: , p_token_tbl => l_token_tbl
644: );
645: l_return_status := FND_API.G_RET_STS_ERROR;
646: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
647: THEN
648: Error_Handler.Add_Error_Token
649: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
650: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 659: l_return_status := FND_API.G_RET_STS_SUCCESS;

655: p_sub_component_rec.substitute_component_name
656: , p_token_tbl => l_token_tbl
657: );
658: ELSE
659: l_return_status := FND_API.G_RET_STS_SUCCESS;
660: END IF;
661:
662: x_return_status := l_return_status;
663: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;

Line 695: x_return_status := FND_API.G_RET_STS_SUCCESS;

691: AND operation_seq_num = p_sub_component_rec.operation_sequence_number
692: AND effectivity_date = p_sub_component_rec.start_effective_date
693: AND bill_sequence_id = p_sub_comp_unexp_rec.bill_sequence_id;
694: BEGIN
695: x_return_status := FND_API.G_RET_STS_SUCCESS;
696:
697: FOR Component IN c_GetComponent LOOP
698: IF Component.revised_item_sequence_id <>
699: p_sub_comp_unexp_rec.revised_item_sequence_id

Line 720: x_return_status := FND_API.G_RET_STS_ERROR;

716: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
717: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
718: , p_Token_Tbl => l_Token_Tbl
719: );
720: x_return_status := FND_API.G_RET_STS_ERROR;
721: END IF;
722: END LOOP;
723:
724: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;

Line 758: l_return_status := FND_API.G_RET_STS_SUCCESS;

754: WHERE inventory_item_id = p_sub_comp_unexp_rec.substitute_component_id
755: AND organization_id = p_sub_comp_unexp_rec.organization_id;
756:
757: BEGIN
758: l_return_status := FND_API.G_RET_STS_SUCCESS;
759:
760: --
761: -- The calling progrma must make a calls to the parent entities
762: -- Check_Access to make sure that the parent is accessible

Line 802: l_return_status := FND_API.G_RET_STS_ERROR;

798: , p_mesg_token_tbl => l_mesg_token_tbl
799: , x_mesg_token_tbl => l_mesg_token_tbl
800: , p_token_tbl => l_token_tbl
801: );
802: l_return_status := FND_API.G_RET_STS_ERROR;
803: ELSIF SubCompType.bom_item_type NOT IN
804: (NVL(Bom_Globals.Get_MDL_Item_Access,0),
805: NVL(Bom_Globals.Get_OC_Item_Access,0),
806: NVL(Bom_Globals.Get_PLN_Item_Access,0),

Line 837: l_return_status := FND_API.G_RET_STS_ERROR;

833: , x_Mesg_Token_Tbl => l_mesg_token_tbl
834: , p_Token_Tbl => l_token_tbl
835: );
836: l_token_tbl.DELETE(2);
837: l_return_status := FND_API.G_RET_STS_ERROR;
838: END IF;
839: END LOOP;
840: x_return_status := l_return_status;
841: