DBA Data[Home] [Help]

APPS.ENG_DEFAULT_SUB_COMPONENT dependencies on FND_API

Line 57: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

53: 'Substitute Component Attribute Validation ' ||
54: TO_CHAR(SQLCODE) || ' ' || SUBSTR(SQLERRM, 1, 100)
55: );
56: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
57: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
58:
59: END Get_Substitute_Item_Quantity;
60:
61: PROCEDURE Get_Flex_Sub_Component

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

63: BEGIN
64:
65: -- In the future call Flex APIs for defaults
66:
67: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN
68: g_sub_component_rec.attribute_category := NULL;
69: END IF;
70:
71: IF g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN

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

67: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN
68: g_sub_component_rec.attribute_category := NULL;
69: END IF;
70:
71: IF g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN
72: g_sub_component_rec.attribute1 := NULL;
73: END IF;
74:
75: IF g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN

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

71: IF g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN
72: g_sub_component_rec.attribute1 := NULL;
73: END IF;
74:
75: IF g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN
76: g_sub_component_rec.attribute2 := NULL;
77: END IF;
78:
79: IF g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN

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

75: IF g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN
76: g_sub_component_rec.attribute2 := NULL;
77: END IF;
78:
79: IF g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN
80: g_sub_component_rec.attribute4 := NULL;
81: END IF;
82:
83: IF g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN

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

79: IF g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN
80: g_sub_component_rec.attribute4 := NULL;
81: END IF;
82:
83: IF g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN
84: g_sub_component_rec.attribute5 := NULL;
85: END IF;
86:
87: IF g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN

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

83: IF g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN
84: g_sub_component_rec.attribute5 := NULL;
85: END IF;
86:
87: IF g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN
88: g_sub_component_rec.attribute6 := NULL;
89: END IF;
90:
91: IF g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN

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

87: IF g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN
88: g_sub_component_rec.attribute6 := NULL;
89: END IF;
90:
91: IF g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN
92: g_sub_component_rec.attribute8 := NULL;
93: END IF;
94:
95: IF g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN

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

91: IF g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN
92: g_sub_component_rec.attribute8 := NULL;
93: END IF;
94:
95: IF g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN
96: g_sub_component_rec.attribute9 := NULL;
97: END IF;
98:
99: IF g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN

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

95: IF g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN
96: g_sub_component_rec.attribute9 := NULL;
97: END IF;
98:
99: IF g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN
100: g_sub_component_rec.attribute10 := NULL;
101: END IF;
102:
103: IF g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN

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

99: IF g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN
100: g_sub_component_rec.attribute10 := NULL;
101: END IF;
102:
103: IF g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN
104: g_sub_component_rec.attribute12 := NULL;
105: END IF;
106:
107: IF g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN

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

103: IF g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN
104: g_sub_component_rec.attribute12 := NULL;
105: END IF;
106:
107: IF g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN
108: g_sub_component_rec.attribute13 := NULL;
109: END IF;
110:
111: IF g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN

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

107: IF g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN
108: g_sub_component_rec.attribute13 := NULL;
109: END IF;
110:
111: IF g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN
112: g_sub_component_rec.attribute14 := NULL;
113: END IF;
114:
115: IF g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN

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

111: IF g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN
112: g_sub_component_rec.attribute14 := NULL;
113: END IF;
114:
115: IF g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN
116: g_sub_component_rec.attribute15 := NULL;
117: END IF;
118:
119: IF g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN

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

115: IF g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN
116: g_sub_component_rec.attribute15 := NULL;
117: END IF;
118:
119: IF g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN
120: g_sub_component_rec.attribute3 := NULL;
121: END IF;
122:
123: IF g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN

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

119: IF g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN
120: g_sub_component_rec.attribute3 := NULL;
121: END IF;
122:
123: IF g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN
124: g_sub_component_rec.attribute7 := NULL;
125: END IF;
126:
127: IF g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN

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

123: IF g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN
124: g_sub_component_rec.attribute7 := NULL;
125: END IF;
126:
127: IF g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN
128: g_sub_component_rec.attribute11 := NULL;
129: END IF;
130:
131: END Get_Flex_Sub_Component;

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

165: stmt_num := 1;
166: g_sub_component_rec := p_sub_component_rec;
167:
168: stmt_num := 2;
169: IF g_sub_component_rec.substitute_item_quantity = FND_API.G_MISS_NUM OR
170: g_sub_component_rec.substitute_item_quantity IS NULL THEN
171:
172: g_sub_component_rec.substitute_item_quantity :=
173: Get_Substitute_Item_Quantity

Line 182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

178: --dbms_output.put_line('Quantity Defaulted to : ' ||
179: -- to_char(g_sub_component_rec.substitute_item_quantity)
180: -- );
181:
182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
183: g_sub_component_rec.substitute_item_quantity := 0;
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: END IF;
186: END IF;

Line 184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

180: -- );
181:
182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
183: g_sub_component_rec.substitute_item_quantity := 0;
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: END IF;
186: END IF;
187:
188: IF g_sub_component_rec.acd_type = FND_API.G_MISS_NUM THEN

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

184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: END IF;
186: END IF;
187:
188: IF g_sub_component_rec.acd_type = FND_API.G_MISS_NUM THEN
189: g_sub_component_rec.acd_type := NULL;
190: END IF;
191:
192: stmt_num :=3;

Line 193: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR

189: g_sub_component_rec.acd_type := NULL;
190: END IF;
191:
192: stmt_num :=3;
193: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR
194: OR g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR
195: OR g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR
196: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
197: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR

Line 194: OR g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR

190: END IF;
191:
192: stmt_num :=3;
193: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR
194: OR g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR
195: OR g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR
196: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
197: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
198: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR

Line 195: OR g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR

191:
192: stmt_num :=3;
193: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR
194: OR g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR
195: OR g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR
196: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
197: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
198: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
199: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR

Line 196: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR

192: stmt_num :=3;
193: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR
194: OR g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR
195: OR g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR
196: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
197: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
198: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
199: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
200: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR

Line 197: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR

193: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR
194: OR g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR
195: OR g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR
196: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
197: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
198: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
199: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
200: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
201: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR

Line 198: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR

194: OR g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR
195: OR g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR
196: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
197: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
198: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
199: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
200: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
201: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
202: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR

Line 199: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR

195: OR g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR
196: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
197: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
198: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
199: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
200: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
201: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
202: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
203: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR

Line 200: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR

196: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
197: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
198: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
199: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
200: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
201: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
202: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
203: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
204: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR

Line 201: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR

197: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
198: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
199: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
200: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
201: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
202: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
203: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
204: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
205: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR

Line 202: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR

198: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
199: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
200: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
201: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
202: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
203: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
204: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
205: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR
206: OR g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR

Line 203: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR

199: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
200: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
201: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
202: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
203: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
204: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
205: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR
206: OR g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR
207: OR g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR

Line 204: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR

200: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
201: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
202: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
203: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
204: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
205: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR
206: OR g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR
207: OR g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR
208: OR g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR

Line 205: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR

201: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
202: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
203: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
204: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
205: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR
206: OR g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR
207: OR g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR
208: OR g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR
209: THEN

Line 206: OR g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR

202: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
203: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
204: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
205: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR
206: OR g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR
207: OR g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR
208: OR g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR
209: THEN
210:

Line 207: OR g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR

203: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
204: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
205: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR
206: OR g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR
207: OR g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR
208: OR g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR
209: THEN
210:
211: Get_Flex_Sub_Component;

Line 208: OR g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR

204: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
205: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR
206: OR g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR
207: OR g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR
208: OR g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR
209: THEN
210:
211: Get_Flex_Sub_Component;
212:

Line 221: WHEN FND_API.G_EXC_ERROR THEN

217: x_sub_component_rec := g_sub_component_rec;
218: x_Sub_Comp_Unexp_Rec := p_Sub_Comp_Unexp_Rec;
219: EXCEPTION
220:
221: WHEN FND_API.G_EXC_ERROR THEN
222: --dbms_output.put_line('default sub_comp : ' || to_char(stmt_num));
223: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225:

Line 224: x_return_status := FND_API.G_RET_STS_ERROR;

220:
221: WHEN FND_API.G_EXC_ERROR THEN
222: --dbms_output.put_line('default sub_comp : ' || to_char(stmt_num));
223: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225:
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: --dbms_output.put_line('default sub_comp : ' || to_char(stmt_num));
228: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;

Line 226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

222: --dbms_output.put_line('default sub_comp : ' || to_char(stmt_num));
223: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225:
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: --dbms_output.put_line('default sub_comp : ' || to_char(stmt_num));
228: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230:

Line 229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

225:
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: --dbms_output.put_line('default sub_comp : ' || to_char(stmt_num));
228: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230:
231: WHEN OTHERS THEN
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;

Line 232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

228: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230:
231: WHEN OTHERS THEN
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
234: --dbms_output.put_line('default sub_comp : ' || to_char(stmt_num));
235:
236: END Attribute_Defaulting;

Line 264: IF l_sub_component_rec.substitute_item_quantity = FND_API.G_MISS_NUM OR

260: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type :=
261: p_sub_component_rec;
262: BEGIN
263:
264: IF l_sub_component_rec.substitute_item_quantity = FND_API.G_MISS_NUM OR
265: l_sub_component_rec.substitute_item_quantity IS NULL
266: THEN
267: l_sub_component_rec.substitute_item_quantity :=
268: p_old_sub_component_rec.substitute_item_quantity;

Line 271: IF l_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN

267: l_sub_component_rec.substitute_item_quantity :=
268: p_old_sub_component_rec.substitute_item_quantity;
269: END IF;
270:
271: IF l_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN
272: l_sub_component_rec.attribute_category :=
273: p_old_sub_component_rec.attribute_category;
274: END IF;
275:

Line 276: IF l_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN

272: l_sub_component_rec.attribute_category :=
273: p_old_sub_component_rec.attribute_category;
274: END IF;
275:
276: IF l_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN
277: l_sub_component_rec.attribute1 :=
278: p_old_sub_component_rec.attribute1;
279: END IF;
280:

Line 281: IF l_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN

277: l_sub_component_rec.attribute1 :=
278: p_old_sub_component_rec.attribute1;
279: END IF;
280:
281: IF l_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN
282: l_sub_component_rec.attribute2 := p_old_sub_component_rec.attribute2;
283: END IF;
284:
285: IF l_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 285: IF l_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN

281: IF l_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN
282: l_sub_component_rec.attribute2 := p_old_sub_component_rec.attribute2;
283: END IF;
284:
285: IF l_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN
286: l_sub_component_rec.attribute4 := p_old_sub_component_rec.attribute4;
287: END IF;
288:
289: IF l_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 289: IF l_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN

285: IF l_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN
286: l_sub_component_rec.attribute4 := p_old_sub_component_rec.attribute4;
287: END IF;
288:
289: IF l_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN
290: l_sub_component_rec.attribute5 := p_old_sub_component_rec.attribute5;
291: END IF;
292:
293: IF l_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 293: IF l_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN

289: IF l_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN
290: l_sub_component_rec.attribute5 := p_old_sub_component_rec.attribute5;
291: END IF;
292:
293: IF l_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN
294: l_sub_component_rec.attribute6 := p_old_sub_component_rec.attribute6;
295: END IF;
296:
297: IF l_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 297: IF l_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN

293: IF l_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN
294: l_sub_component_rec.attribute6 := p_old_sub_component_rec.attribute6;
295: END IF;
296:
297: IF l_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN
298: l_sub_component_rec.attribute8 := p_old_sub_component_rec.attribute8;
299: END IF;
300:
301: IF l_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 301: IF l_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN

297: IF l_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN
298: l_sub_component_rec.attribute8 := p_old_sub_component_rec.attribute8;
299: END IF;
300:
301: IF l_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN
302: l_sub_component_rec.attribute9 := p_old_sub_component_rec.attribute9;
303: END IF;
304:
305: IF l_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 305: IF l_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN

301: IF l_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN
302: l_sub_component_rec.attribute9 := p_old_sub_component_rec.attribute9;
303: END IF;
304:
305: IF l_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN
306: l_sub_component_rec.attribute10 := p_old_sub_component_rec.attribute10;
307: END IF;
308:
309: IF l_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 309: IF l_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN

305: IF l_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN
306: l_sub_component_rec.attribute10 := p_old_sub_component_rec.attribute10;
307: END IF;
308:
309: IF l_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN
310: l_sub_component_rec.attribute12 := p_old_sub_component_rec.attribute12;
311: END IF;
312:
313: IF l_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 313: IF l_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN

309: IF l_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN
310: l_sub_component_rec.attribute12 := p_old_sub_component_rec.attribute12;
311: END IF;
312:
313: IF l_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN
314: l_sub_component_rec.attribute13 := p_old_sub_component_rec.attribute13;
315: END IF;
316:
317: IF l_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 317: IF l_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN

313: IF l_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN
314: l_sub_component_rec.attribute13 := p_old_sub_component_rec.attribute13;
315: END IF;
316:
317: IF l_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN
318: l_sub_component_rec.attribute14 := p_old_sub_component_rec.attribute14;
319: END IF;
320:
321: IF l_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 321: IF l_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN

317: IF l_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN
318: l_sub_component_rec.attribute14 := p_old_sub_component_rec.attribute14;
319: END IF;
320:
321: IF l_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN
322: l_sub_component_rec.attribute15 := p_old_sub_component_rec.attribute15;
323: END IF;
324:
325: IF l_sub_component_rec.program_id = FND_API.G_MISS_NUM THEN

Line 325: IF l_sub_component_rec.program_id = FND_API.G_MISS_NUM THEN

321: IF l_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN
322: l_sub_component_rec.attribute15 := p_old_sub_component_rec.attribute15;
323: END IF;
324:
325: IF l_sub_component_rec.program_id = FND_API.G_MISS_NUM THEN
326: l_sub_component_rec.program_id := p_old_sub_component_rec.program_id;
327: END IF;
328:
329: IF l_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 329: IF l_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN

325: IF l_sub_component_rec.program_id = FND_API.G_MISS_NUM THEN
326: l_sub_component_rec.program_id := p_old_sub_component_rec.program_id;
327: END IF;
328:
329: IF l_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN
330: l_sub_component_rec.attribute3 := p_old_sub_component_rec.attribute3;
331: END IF;
332:
333: IF l_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 333: IF l_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN

329: IF l_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN
330: l_sub_component_rec.attribute3 := p_old_sub_component_rec.attribute3;
331: END IF;
332:
333: IF l_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN
334: l_sub_component_rec.attribute7 := p_old_sub_component_rec.attribute7;
335: END IF;
336:
337: IF l_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 337: IF l_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN

333: IF l_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN
334: l_sub_component_rec.attribute7 := p_old_sub_component_rec.attribute7;
335: END IF;
336:
337: IF l_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN
338: l_sub_component_rec.attribute11 := p_old_sub_component_rec.attribute11;
339: END IF;
340:
341: x_sub_comp_unexp_rec := p_sub_comp_unexp_rec;