DBA Data[Home] [Help]

APPS.BOM_DEFAULT_SUB_COMPONENT dependencies on FND_API

Line 76: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

72: 'Substitute Component Attribute Validation ' ||
73: TO_CHAR(SQLCODE) || ' ' || SUBSTR(SQLERRM, 1, 100)
74: );
75: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
76: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
77:
78: END Get_Substitute_Item_Quantity;
79:
80: PROCEDURE Get_Flex_Sub_Component

Line 86: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN

82: BEGIN
83:
84: -- In the future call Flex APIs for defaults
85:
86: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN
87: g_sub_component_rec.attribute_category := NULL;
88: END IF;
89:
90: IF g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 90: IF g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN

86: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN
87: g_sub_component_rec.attribute_category := NULL;
88: END IF;
89:
90: IF g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN
91: g_sub_component_rec.attribute1 := NULL;
92: END IF;
93:
94: IF g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 94: IF g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN

90: IF g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN
91: g_sub_component_rec.attribute1 := NULL;
92: END IF;
93:
94: IF g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN
95: g_sub_component_rec.attribute2 := NULL;
96: END IF;
97:
98: IF g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 98: IF g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN

94: IF g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN
95: g_sub_component_rec.attribute2 := NULL;
96: END IF;
97:
98: IF g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN
99: g_sub_component_rec.attribute4 := NULL;
100: END IF;
101:
102: IF g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 102: IF g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN

98: IF g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN
99: g_sub_component_rec.attribute4 := NULL;
100: END IF;
101:
102: IF g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN
103: g_sub_component_rec.attribute5 := NULL;
104: END IF;
105:
106: IF g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 106: IF g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN

102: IF g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN
103: g_sub_component_rec.attribute5 := NULL;
104: END IF;
105:
106: IF g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN
107: g_sub_component_rec.attribute6 := NULL;
108: END IF;
109:
110: IF g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 110: IF g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN

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

Line 114: IF g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN

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

Line 118: IF g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN

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

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

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

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

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

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

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

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

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

Line 138: IF g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN

134: IF g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN
135: g_sub_component_rec.attribute15 := NULL;
136: END IF;
137:
138: IF g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN
139: g_sub_component_rec.attribute3 := NULL;
140: END IF;
141:
142: IF g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 142: IF g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN

138: IF g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN
139: g_sub_component_rec.attribute3 := NULL;
140: END IF;
141:
142: IF g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN
143: g_sub_component_rec.attribute7 := NULL;
144: END IF;
145:
146: IF g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 146: IF g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN

142: IF g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN
143: g_sub_component_rec.attribute7 := NULL;
144: END IF;
145:
146: IF g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN
147: g_sub_component_rec.attribute11 := NULL;
148: END IF;
149:
150: END Get_Flex_Sub_Component;

Line 209: x_return_status := FND_API.G_RET_STS_SUCCESS;

205: BEGIN
206:
207: -- Initialize g_sub_component_rec
208:
209: x_return_status := FND_API.G_RET_STS_SUCCESS;
210:
211:
212: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Comp Seq in attrib Defaulting ' || p_Sub_Comp_Unexp_Rec.component_sequence_id); END IF;
213:

Line 224: IF g_sub_component_rec.substitute_item_quantity = FND_API.G_MISS_NUM OR

220: x_sub_comp_unexp_rec.enforce_int_requirements_code := 0;
221: END IF;
222:
223: stmt_num := 2;
224: IF g_sub_component_rec.substitute_item_quantity = FND_API.G_MISS_NUM OR
225: g_sub_component_rec.substitute_item_quantity IS NULL THEN
226:
227: -- Check if Inverse_Quanity value is available. If not default it from component.
228: IF g_sub_component_rec.Inverse_Quantity = FND_API.G_MISS_NUM OR

Line 228: IF g_sub_component_rec.Inverse_Quantity = FND_API.G_MISS_NUM OR

224: IF g_sub_component_rec.substitute_item_quantity = FND_API.G_MISS_NUM OR
225: g_sub_component_rec.substitute_item_quantity IS NULL THEN
226:
227: -- Check if Inverse_Quanity value is available. If not default it from component.
228: IF g_sub_component_rec.Inverse_Quantity = FND_API.G_MISS_NUM OR
229: g_sub_component_rec.Inverse_Quantity IS NULL THEN
230:
231: g_sub_component_rec.substitute_item_quantity :=
232: Get_Substitute_Item_Quantity

Line 240: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

236: );
237: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Quantity Defaulted to : ' || to_char(g_sub_component_rec.substitute_item_quantity)); END IF;
238:
239:
240: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: g_sub_component_rec.substitute_item_quantity := 0;
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
244: ELSE

Line 242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

238:
239:
240: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: g_sub_component_rec.substitute_item_quantity := 0;
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
244: ELSE
245: IF g_sub_component_rec.Inverse_Quantity = 0 THEN
246: g_sub_component_rec.substitute_item_quantity := 0;

Line 253: IF g_sub_component_rec.acd_type = FND_API.G_MISS_NUM THEN

249: END IF;
250: END IF;
251: END IF;
252:
253: IF g_sub_component_rec.acd_type = FND_API.G_MISS_NUM THEN
254: g_sub_component_rec.acd_type := NULL;
255: END IF;
256: /* bug2758790, form defaults the enforce req code to 0 and value to 'none' */
257:

Line 258: IF (g_sub_component_rec.enforce_int_requirements = FND_API.G_MISS_CHAR

254: g_sub_component_rec.acd_type := NULL;
255: END IF;
256: /* bug2758790, form defaults the enforce req code to 0 and value to 'none' */
257:
258: IF (g_sub_component_rec.enforce_int_requirements = FND_API.G_MISS_CHAR
259: or g_sub_component_rec.enforce_int_requirements is NULL )THEN
260: g_sub_component_rec.enforce_int_requirements :=
261: Get_EnforceInteger_Value(p_enforce_integer => 0);
262: END IF;

Line 266: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR

262: END IF;
263:
264:
265: stmt_num :=3;
266: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR
267: OR g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR
268: OR g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR
269: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
270: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR

Line 267: OR g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR

263:
264:
265: stmt_num :=3;
266: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR
267: OR g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR
268: OR g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR
269: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
270: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
271: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR

Line 268: OR g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR

264:
265: stmt_num :=3;
266: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR
267: OR g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR
268: OR g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR
269: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
270: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
271: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
272: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR

Line 269: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR

265: stmt_num :=3;
266: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR
267: OR g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR
268: OR g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR
269: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
270: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
271: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
272: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
273: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR

Line 270: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR

266: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR
267: OR g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR
268: OR g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR
269: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
270: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
271: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
272: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
273: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
274: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR

Line 271: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR

267: OR g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR
268: OR g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR
269: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
270: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
271: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
272: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
273: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
274: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
275: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR

Line 272: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR

268: OR g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR
269: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
270: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
271: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
272: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
273: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
274: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
275: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
276: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR

Line 273: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR

269: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
270: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
271: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
272: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
273: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
274: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
275: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
276: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
277: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR

Line 274: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR

270: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
271: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
272: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
273: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
274: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
275: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
276: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
277: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
278: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR

Line 275: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR

271: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
272: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
273: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
274: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
275: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
276: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
277: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
278: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR
279: OR g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR

Line 276: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR

272: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
273: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
274: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
275: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
276: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
277: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
278: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR
279: OR g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR
280: OR g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR

Line 277: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR

273: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
274: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
275: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
276: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
277: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
278: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR
279: OR g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR
280: OR g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR
281: OR g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR

Line 278: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR

274: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
275: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
276: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
277: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
278: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR
279: OR g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR
280: OR g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR
281: OR g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR
282: THEN

Line 279: OR g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR

275: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
276: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
277: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
278: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR
279: OR g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR
280: OR g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR
281: OR g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR
282: THEN
283:

Line 280: OR g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR

276: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
277: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
278: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR
279: OR g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR
280: OR g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR
281: OR g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR
282: THEN
283:
284: Get_Flex_Sub_Component;

Line 281: OR g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR

277: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
278: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR
279: OR g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR
280: OR g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR
281: OR g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR
282: THEN
283:
284: Get_Flex_Sub_Component;
285:

Line 296: WHEN FND_API.G_EXC_ERROR THEN

292: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Sub Comps Attrib Defaulting Done . . .'); END IF;
293:
294: EXCEPTION
295:
296: WHEN FND_API.G_EXC_ERROR THEN
297: -- dbms_output.put_line('default sub_comp : ' || to_char(stmt_num));
298: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300:

Line 299: x_return_status := FND_API.G_RET_STS_ERROR;

295:
296: WHEN FND_API.G_EXC_ERROR THEN
297: -- dbms_output.put_line('default sub_comp : ' || to_char(stmt_num));
298: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300:
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: -- dbms_output.put_line('default sub_comp : ' || to_char(stmt_num));
303: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;

Line 301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

297: -- dbms_output.put_line('default sub_comp : ' || to_char(stmt_num));
298: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300:
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: -- dbms_output.put_line('default sub_comp : ' || to_char(stmt_num));
303: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305:

Line 304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

300:
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: -- dbms_output.put_line('default sub_comp : ' || to_char(stmt_num));
303: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305:
306: WHEN OTHERS THEN
307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
308: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;

Line 307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

303: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305:
306: WHEN OTHERS THEN
307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
308: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
309: -- dbms_output.put_line('default sub_comp : ' || to_char(stmt_num));
310:
311: END Attribute_Defaulting;

Line 341: IF (l_sub_component_rec.substitute_item_quantity = FND_API.G_MISS_NUM OR

337: l_sub_comp_Unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type :=
338: p_old_sub_comp_Unexp_rec;
339: BEGIN
340:
341: IF (l_sub_component_rec.substitute_item_quantity = FND_API.G_MISS_NUM OR
342: l_sub_component_rec.substitute_item_quantity IS NULL)
343: THEN
344: IF (l_sub_component_rec.Inverse_Quantity = FND_API.G_MISS_NUM OR
345: l_sub_component_rec.Inverse_Quantity IS NULL)

Line 344: IF (l_sub_component_rec.Inverse_Quantity = FND_API.G_MISS_NUM OR

340:
341: IF (l_sub_component_rec.substitute_item_quantity = FND_API.G_MISS_NUM OR
342: l_sub_component_rec.substitute_item_quantity IS NULL)
343: THEN
344: IF (l_sub_component_rec.Inverse_Quantity = FND_API.G_MISS_NUM OR
345: l_sub_component_rec.Inverse_Quantity IS NULL)
346: THEN
347: l_sub_component_rec.substitute_item_quantity :=
348: p_old_sub_component_rec.substitute_item_quantity;

Line 443: IF l_sub_component_rec.enforce_int_requirements = FND_API.G_MISS_CHAR THEN

439: If(p_sub_comp_unexp_rec.new_substitute_component_id is not null) then
440: l_sub_comp_unexp_rec.new_substitute_component_id :=p_sub_comp_unexp_rec.new_substitute_component_id;
441: end if;
442:
443: IF l_sub_component_rec.enforce_int_requirements = FND_API.G_MISS_CHAR THEN
444: l_sub_comp_unexp_rec.enforce_int_requirements_code := NULL;
445: l_sub_component_rec.enforce_int_requirements := NULL;
446: ELSIF l_sub_component_rec.enforce_int_requirements IS NULL THEN
447: l_sub_comp_unexp_rec.enforce_int_requirements_code := p_old_sub_comp_unexp_rec.enforce_int_requirements_code;