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

Line 30: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM

26:
27: -- Procedure Clear_Dependent_Attr
28:
29: PROCEDURE Clear_Dependent_Attr
30: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
31: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
32: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
33: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
34: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type

Line 70: IF l_ref_designator_rec.Reference_Designator_Name = FND_API.G_MISS_CHAR THEN

66: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type :=
67: p_ref_designator_rec;
68: BEGIN
69:
70: IF l_ref_designator_rec.Reference_Designator_Name = FND_API.G_MISS_CHAR THEN
71: l_ref_designator_rec.Reference_Designator_Name := NULL;
72: END IF;
73:
74: IF l_ref_designator_rec.attribute_category = FND_API.G_MISS_CHAR THEN

Line 74: IF l_ref_designator_rec.attribute_category = FND_API.G_MISS_CHAR THEN

70: IF l_ref_designator_rec.Reference_Designator_Name = FND_API.G_MISS_CHAR THEN
71: l_ref_designator_rec.Reference_Designator_Name := NULL;
72: END IF;
73:
74: IF l_ref_designator_rec.attribute_category = FND_API.G_MISS_CHAR THEN
75: l_ref_designator_rec.attribute_category := NULL;
76: END IF;
77:
78: IF l_ref_designator_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 78: IF l_ref_designator_rec.attribute1 = FND_API.G_MISS_CHAR THEN

74: IF l_ref_designator_rec.attribute_category = FND_API.G_MISS_CHAR THEN
75: l_ref_designator_rec.attribute_category := NULL;
76: END IF;
77:
78: IF l_ref_designator_rec.attribute1 = FND_API.G_MISS_CHAR THEN
79: l_ref_designator_rec.attribute1 := NULL;
80: END IF;
81:
82: IF l_ref_designator_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 82: IF l_ref_designator_rec.attribute2 = FND_API.G_MISS_CHAR THEN

78: IF l_ref_designator_rec.attribute1 = FND_API.G_MISS_CHAR THEN
79: l_ref_designator_rec.attribute1 := NULL;
80: END IF;
81:
82: IF l_ref_designator_rec.attribute2 = FND_API.G_MISS_CHAR THEN
83: l_ref_designator_rec.attribute2 := NULL;
84: END IF;
85:
86: IF l_ref_designator_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 86: IF l_ref_designator_rec.attribute3 = FND_API.G_MISS_CHAR THEN

82: IF l_ref_designator_rec.attribute2 = FND_API.G_MISS_CHAR THEN
83: l_ref_designator_rec.attribute2 := NULL;
84: END IF;
85:
86: IF l_ref_designator_rec.attribute3 = FND_API.G_MISS_CHAR THEN
87: l_ref_designator_rec.attribute3 := NULL;
88: END IF;
89:
90: IF l_ref_designator_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 90: IF l_ref_designator_rec.attribute4 = FND_API.G_MISS_CHAR THEN

86: IF l_ref_designator_rec.attribute3 = FND_API.G_MISS_CHAR THEN
87: l_ref_designator_rec.attribute3 := NULL;
88: END IF;
89:
90: IF l_ref_designator_rec.attribute4 = FND_API.G_MISS_CHAR THEN
91: l_ref_designator_rec.attribute4 := NULL;
92: END IF;
93:
94: IF l_ref_designator_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 94: IF l_ref_designator_rec.attribute5 = FND_API.G_MISS_CHAR THEN

90: IF l_ref_designator_rec.attribute4 = FND_API.G_MISS_CHAR THEN
91: l_ref_designator_rec.attribute4 := NULL;
92: END IF;
93:
94: IF l_ref_designator_rec.attribute5 = FND_API.G_MISS_CHAR THEN
95: l_ref_designator_rec.attribute5 := NULL;
96: END IF;
97:
98: IF l_ref_designator_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 98: IF l_ref_designator_rec.attribute6 = FND_API.G_MISS_CHAR THEN

94: IF l_ref_designator_rec.attribute5 = FND_API.G_MISS_CHAR THEN
95: l_ref_designator_rec.attribute5 := NULL;
96: END IF;
97:
98: IF l_ref_designator_rec.attribute6 = FND_API.G_MISS_CHAR THEN
99: l_ref_designator_rec.attribute6 := NULL;
100: END IF;
101:
102: IF l_ref_designator_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 102: IF l_ref_designator_rec.attribute7 = FND_API.G_MISS_CHAR THEN

98: IF l_ref_designator_rec.attribute6 = FND_API.G_MISS_CHAR THEN
99: l_ref_designator_rec.attribute6 := NULL;
100: END IF;
101:
102: IF l_ref_designator_rec.attribute7 = FND_API.G_MISS_CHAR THEN
103: l_ref_designator_rec.attribute7 := NULL;
104: END IF;
105:
106: IF l_ref_designator_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 106: IF l_ref_designator_rec.attribute8 = FND_API.G_MISS_CHAR THEN

102: IF l_ref_designator_rec.attribute7 = FND_API.G_MISS_CHAR THEN
103: l_ref_designator_rec.attribute7 := NULL;
104: END IF;
105:
106: IF l_ref_designator_rec.attribute8 = FND_API.G_MISS_CHAR THEN
107: l_ref_designator_rec.attribute8 := NULL;
108: END IF;
109:
110: IF l_ref_designator_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 110: IF l_ref_designator_rec.attribute9 = FND_API.G_MISS_CHAR THEN

106: IF l_ref_designator_rec.attribute8 = FND_API.G_MISS_CHAR THEN
107: l_ref_designator_rec.attribute8 := NULL;
108: END IF;
109:
110: IF l_ref_designator_rec.attribute9 = FND_API.G_MISS_CHAR THEN
111: l_ref_designator_rec.attribute9 := NULL;
112: END IF;
113:
114: IF l_ref_designator_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 114: IF l_ref_designator_rec.attribute10 = FND_API.G_MISS_CHAR THEN

110: IF l_ref_designator_rec.attribute9 = FND_API.G_MISS_CHAR THEN
111: l_ref_designator_rec.attribute9 := NULL;
112: END IF;
113:
114: IF l_ref_designator_rec.attribute10 = FND_API.G_MISS_CHAR THEN
115: l_ref_designator_rec.attribute10 := NULL;
116: END IF;
117:
118: IF l_ref_designator_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 118: IF l_ref_designator_rec.attribute11 = FND_API.G_MISS_CHAR THEN

114: IF l_ref_designator_rec.attribute10 = FND_API.G_MISS_CHAR THEN
115: l_ref_designator_rec.attribute10 := NULL;
116: END IF;
117:
118: IF l_ref_designator_rec.attribute11 = FND_API.G_MISS_CHAR THEN
119: l_ref_designator_rec.attribute11 := NULL;
120: END IF;
121:
122: IF l_ref_designator_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 122: IF l_ref_designator_rec.attribute12 = FND_API.G_MISS_CHAR THEN

118: IF l_ref_designator_rec.attribute11 = FND_API.G_MISS_CHAR THEN
119: l_ref_designator_rec.attribute11 := NULL;
120: END IF;
121:
122: IF l_ref_designator_rec.attribute12 = FND_API.G_MISS_CHAR THEN
123: l_ref_designator_rec.attribute12 := NULL;
124: END IF;
125:
126: IF l_ref_designator_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 126: IF l_ref_designator_rec.attribute13 = FND_API.G_MISS_CHAR THEN

122: IF l_ref_designator_rec.attribute12 = FND_API.G_MISS_CHAR THEN
123: l_ref_designator_rec.attribute12 := NULL;
124: END IF;
125:
126: IF l_ref_designator_rec.attribute13 = FND_API.G_MISS_CHAR THEN
127: l_ref_designator_rec.attribute13 := NULL;
128: END IF;
129:
130: IF l_ref_designator_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 130: IF l_ref_designator_rec.attribute14 = FND_API.G_MISS_CHAR THEN

126: IF l_ref_designator_rec.attribute13 = FND_API.G_MISS_CHAR THEN
127: l_ref_designator_rec.attribute13 := NULL;
128: END IF;
129:
130: IF l_ref_designator_rec.attribute14 = FND_API.G_MISS_CHAR THEN
131: l_ref_designator_rec.attribute14 := NULL;
132: END IF;
133:
134: IF l_ref_designator_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 134: IF l_ref_designator_rec.attribute15 = FND_API.G_MISS_CHAR THEN

130: IF l_ref_designator_rec.attribute14 = FND_API.G_MISS_CHAR THEN
131: l_ref_designator_rec.attribute14 := NULL;
132: END IF;
133:
134: IF l_ref_designator_rec.attribute15 = FND_API.G_MISS_CHAR THEN
135: l_ref_designator_rec.attribute15 := NULL;
136: END IF;
137:
138: RETURN l_ref_designator_rec;

Line 173: FND_API.G_MISS_CHAR,

169: UPDATE BOM_REFERENCE_DESIGNATORS
170: SET COMPONENT_REFERENCE_DESIGNATOR =
171: DECODE(p_ref_designator_rec.new_reference_designator,
172: NULL,p_ref_designator_rec.Reference_Designator_Name,
173: FND_API.G_MISS_CHAR,
174: p_ref_designator_rec.Reference_Designator_Name,
175: p_ref_designator_rec.new_reference_designator
176: )
177: , LAST_UPDATE_DATE = SYSDATE

Line 182: , FND_API.G_MISS_CHAR

178: , LAST_UPDATED_BY = Bom_Globals.Get_User_Id
179: , LAST_UPDATE_LOGIN = Bom_Globals.Get_User_Id
180: , REF_DESIGNATOR_COMMENT =
181: DECODE( p_ref_designator_rec.ref_designator_comment
182: , FND_API.G_MISS_CHAR
183: , NULL
184: , p_ref_designator_rec.ref_designator_comment
185: )
186: , ATTRIBUTE_CATEGORY = p_ref_designator_rec.attribute_category

Line 229: --x_Return_Status := FND_API.G_RET_STS_SUCCESS;

225: p_ref_designator_rec.Reference_Designator_Name)
226: , p_acd_type => p_Ref_Designator_Rec.acd_type
227: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
228: , x_Return_Status => x_Return_Status);
229: --x_Return_Status := FND_API.G_RET_STS_SUCCESS;
230:
231: EXCEPTION
232: WHEN OTHERS THEN
233:

Line 236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

232: WHEN OTHERS THEN
233:
234: IF G_CONTROL_REC.caller_type = 'FORM'
235: THEN
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: RAISE;
238: END IF;
239:
240: Error_Handler.Add_Error_Token

Line 248: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

244: to_char(SQLCODE)
245: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
246: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl);
247:
248: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
249:
250: END Update_Row;
251:
252: --following function has been added for bug 7713832

Line 349: , FND_API.G_MISS_CHAR

345: , SYSDATE
346: , Bom_Globals.Get_User_Id
347: , Bom_Globals.Get_User_Id
348: , DECODE( p_ref_designator_rec.ref_designator_comment
349: , FND_API.G_MISS_CHAR
350: , NULL
351: , p_ref_designator_rec.ref_designator_comment )
352: , p_ref_designator_rec.Eco_Name
353: , p_Ref_Desg_Unexp_Rec.component_sequence_id

Line 384: --x_return_status := FND_API.G_RET_STS_SUCCESS;

380: , p_ref_desg => p_ref_designator_rec.Reference_Designator_Name
381: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
382: , x_Return_Status => x_return_status);
383: END IF;
384: --x_return_status := FND_API.G_RET_STS_SUCCESS;
385: EXCEPTION
386:
387: WHEN OTHERS THEN
388: IF G_CONTROL_REC.caller_type = 'FORM'

Line 390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

386:
387: WHEN OTHERS THEN
388: IF G_CONTROL_REC.caller_type = 'FORM'
389: THEN
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
391: RAISE;
392: END IF;
393:
394: Error_Handler.Add_Error_Token

Line 405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

401: );
402:
403: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('ERROR in Insert Row (Ref Desgs)' || substr(SQLERRM, 1, 100) || ' ' || to_char(SQLCODE)); END IF;
404:
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406:
407: END Insert_Row;
408:
409: /********************************************************************

Line 448: --x_Return_Status := FND_API.G_RET_STS_SUCCESS;

444: BOMPCMBM.Delete_Related_Ref_Desg(p_src_comp_seq => p_component_sequence_id
445: , p_ref_desg => p_ref_designator
446: , x_return_status => x_return_status);
447:
448: --x_Return_Status := FND_API.G_RET_STS_SUCCESS;
449:
450: EXCEPTION
451: WHEN OTHERS THEN
452:

Line 455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

451: WHEN OTHERS THEN
452:
453: IF G_CONTROL_REC.caller_type = 'FORM'
454: THEN
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
456: RAISE;
457: END IF;
458:
459: Error_Handler.Add_Error_Token

Line 467: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

463: to_char(SQLCODE)
464: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
465: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
466: );
467: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
468:
469: END Delete_Row;
470:
471: /********************************************************************

Line 546: AND NVL(DECODE(ACD_TYPE, FND_API.G_MISS_NUM, null, acd_type), 1) =

542: , l_ref_designator_rec.attribute15
543: FROM BOM_REFERENCE_DESIGNATORS
544: WHERE COMPONENT_REFERENCE_DESIGNATOR = p_ref_designator
545: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
546: AND NVL(DECODE(ACD_TYPE, FND_API.G_MISS_NUM, null, acd_type), 1) =
547: NVL(DECODE(p_acd_type, FND_API.G_MISS_NUM, null, p_acd_type), 1)
548: /* Bug 5726557; The code is modified to modify the refernce designators
549: when implemneted through an ECO */
550: ;

Line 547: NVL(DECODE(p_acd_type, FND_API.G_MISS_NUM, null, p_acd_type), 1)

543: FROM BOM_REFERENCE_DESIGNATORS
544: WHERE COMPONENT_REFERENCE_DESIGNATOR = p_ref_designator
545: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
546: AND NVL(DECODE(ACD_TYPE, FND_API.G_MISS_NUM, null, acd_type), 1) =
547: NVL(DECODE(p_acd_type, FND_API.G_MISS_NUM, null, p_acd_type), 1)
548: /* Bug 5726557; The code is modified to modify the refernce designators
549: when implemneted through an ECO */
550: ;
551:

Line 562: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

558: WHEN NO_DATA_FOUND THEN
559: x_Return_Status := Bom_Globals.G_RECORD_NOT_FOUND;
560:
561: WHEN OTHERS THEN
562: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
563:
564: END Query_Row;
565:
566: PROCEDURE Perform_Writes

Line 578: l_return_status := FND_API.G_RET_STS_SUCCESS;

574: IS
575: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
576: l_return_status VARCHAR2(1);
577: BEGIN
578: l_return_status := FND_API.G_RET_STS_SUCCESS;
579:
580: IF p_ref_designator_rec.transaction_type = Bom_Globals.G_OPR_CREATE
581: THEN
582: Insert_Row( p_ref_designator_rec =>