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: /********************************************************************

Line 316: , FND_API.G_MISS_CHAR

312: , SYSDATE
313: , Bom_Globals.Get_User_Id
314: , Bom_Globals.Get_User_Id
315: , DECODE( p_ref_designator_rec.ref_designator_comment
316: , FND_API.G_MISS_CHAR
317: , NULL
318: , p_ref_designator_rec.ref_designator_comment )
319: , p_ref_designator_rec.Eco_Name
320: , p_Ref_Desg_Unexp_Rec.component_sequence_id

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

344: BOMPCMBM.Insert_Related_Ref_Desg(p_component_sequence_id => p_Ref_Desg_Unexp_Rec.component_sequence_id
345: , p_ref_desg => p_ref_designator_rec.Reference_Designator_Name
346: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
347: , x_Return_Status => x_return_status);
348: --x_return_status := FND_API.G_RET_STS_SUCCESS;
349: EXCEPTION
350:
351: WHEN OTHERS THEN
352: IF G_CONTROL_REC.caller_type = 'FORM'

Line 354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

350:
351: WHEN OTHERS THEN
352: IF G_CONTROL_REC.caller_type = 'FORM'
353: THEN
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
355: RAISE;
356: END IF;
357:
358: Error_Handler.Add_Error_Token

Line 369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

365: );
366:
367: 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;
368:
369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
370:
371: END Insert_Row;
372:
373: /********************************************************************

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

408: BOMPCMBM.Delete_Related_Ref_Desg(p_src_comp_seq => p_component_sequence_id
409: , p_ref_desg => p_ref_designator
410: , x_return_status => x_return_status);
411:
412: --x_Return_Status := FND_API.G_RET_STS_SUCCESS;
413:
414: EXCEPTION
415: WHEN OTHERS THEN
416:

Line 419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

415: WHEN OTHERS THEN
416:
417: IF G_CONTROL_REC.caller_type = 'FORM'
418: THEN
419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
420: RAISE;
421: END IF;
422:
423: Error_Handler.Add_Error_Token

Line 431: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

427: to_char(SQLCODE)
428: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
429: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
430: );
431: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
432:
433: END Delete_Row;
434:
435: /********************************************************************

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

506: , l_ref_designator_rec.attribute15
507: FROM BOM_REFERENCE_DESIGNATORS
508: WHERE COMPONENT_REFERENCE_DESIGNATOR = p_ref_designator
509: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
510: AND NVL(DECODE(ACD_TYPE, FND_API.G_MISS_NUM, null, acd_type), 1) =
511: NVL(DECODE(p_acd_type, FND_API.G_MISS_NUM, null, p_acd_type), 1)
512: /* Bug 5726557; The code is modified to modify the refernce designators
513: when implemneted through an ECO */
514: ;

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

507: FROM BOM_REFERENCE_DESIGNATORS
508: WHERE COMPONENT_REFERENCE_DESIGNATOR = p_ref_designator
509: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
510: AND NVL(DECODE(ACD_TYPE, FND_API.G_MISS_NUM, null, acd_type), 1) =
511: NVL(DECODE(p_acd_type, FND_API.G_MISS_NUM, null, p_acd_type), 1)
512: /* Bug 5726557; The code is modified to modify the refernce designators
513: when implemneted through an ECO */
514: ;
515:

Line 526: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

522: WHEN NO_DATA_FOUND THEN
523: x_Return_Status := Bom_Globals.G_RECORD_NOT_FOUND;
524:
525: WHEN OTHERS THEN
526: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
527:
528: END Query_Row;
529:
530: PROCEDURE Perform_Writes

Line 542: l_return_status := FND_API.G_RET_STS_SUCCESS;

538: IS
539: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
540: l_return_status VARCHAR2(1);
541: BEGIN
542: l_return_status := FND_API.G_RET_STS_SUCCESS;
543:
544: IF p_ref_designator_rec.transaction_type = Bom_Globals.G_OPR_CREATE
545: THEN
546: Insert_Row( p_ref_designator_rec =>