31: record_count := p_eco_revision_tbl.COUNT;
32:
33: FOR table_index IN 1..record_count
34: LOOP
35: IF NVL(p_eco_revision_tbl(table_index).ECO_name, FND_API.G_MISS_CHAR) <>
36: NVL(p_change_notice, FND_API.G_MISS_CHAR)
37: OR
38: NVL(p_eco_revision_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
39: NVL(p_organization_code, FND_API.G_MISS_CHAR)
32:
33: FOR table_index IN 1..record_count
34: LOOP
35: IF NVL(p_eco_revision_tbl(table_index).ECO_name, FND_API.G_MISS_CHAR) <>
36: NVL(p_change_notice, FND_API.G_MISS_CHAR)
37: OR
38: NVL(p_eco_revision_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
39: NVL(p_organization_code, FND_API.G_MISS_CHAR)
40: THEN
34: LOOP
35: IF NVL(p_eco_revision_tbl(table_index).ECO_name, FND_API.G_MISS_CHAR) <>
36: NVL(p_change_notice, FND_API.G_MISS_CHAR)
37: OR
38: NVL(p_eco_revision_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
39: NVL(p_organization_code, FND_API.G_MISS_CHAR)
40: THEN
41: RETURN FALSE;
42: END IF;
35: IF NVL(p_eco_revision_tbl(table_index).ECO_name, FND_API.G_MISS_CHAR) <>
36: NVL(p_change_notice, FND_API.G_MISS_CHAR)
37: OR
38: NVL(p_eco_revision_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
39: NVL(p_organization_code, FND_API.G_MISS_CHAR)
40: THEN
41: RETURN FALSE;
42: END IF;
43: END LOOP;
59: record_count := p_revised_item_tbl.COUNT;
60:
61: FOR table_index IN 1..record_count
62: LOOP
63: IF NVL(p_revised_item_tbl(table_index).ECO_name, FND_API.G_MISS_CHAR) <>
64: NVL(p_change_notice, FND_API.G_MISS_CHAR)
65: OR
66: NVL(p_revised_item_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
67: NVL(p_organization_code, FND_API.G_MISS_CHAR)
60:
61: FOR table_index IN 1..record_count
62: LOOP
63: IF NVL(p_revised_item_tbl(table_index).ECO_name, FND_API.G_MISS_CHAR) <>
64: NVL(p_change_notice, FND_API.G_MISS_CHAR)
65: OR
66: NVL(p_revised_item_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
67: NVL(p_organization_code, FND_API.G_MISS_CHAR)
68: THEN
62: LOOP
63: IF NVL(p_revised_item_tbl(table_index).ECO_name, FND_API.G_MISS_CHAR) <>
64: NVL(p_change_notice, FND_API.G_MISS_CHAR)
65: OR
66: NVL(p_revised_item_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
67: NVL(p_organization_code, FND_API.G_MISS_CHAR)
68: THEN
69: RETURN FALSE;
70: END IF;
63: IF NVL(p_revised_item_tbl(table_index).ECO_name, FND_API.G_MISS_CHAR) <>
64: NVL(p_change_notice, FND_API.G_MISS_CHAR)
65: OR
66: NVL(p_revised_item_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
67: NVL(p_organization_code, FND_API.G_MISS_CHAR)
68: THEN
69: RETURN FALSE;
70: END IF;
71: END LOOP;
87: record_count := p_rev_component_tbl.COUNT;
88:
89: FOR table_index IN 1..record_count
90: LOOP
91: IF NVL(p_rev_component_tbl(table_index).ECO_name, FND_API.G_MISS_CHAR) <>
92: NVL(p_change_notice, FND_API.G_MISS_CHAR)
93: OR
94: NVL(p_rev_component_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
95: NVL(p_organization_code, FND_API.G_MISS_CHAR)
88:
89: FOR table_index IN 1..record_count
90: LOOP
91: IF NVL(p_rev_component_tbl(table_index).ECO_name, FND_API.G_MISS_CHAR) <>
92: NVL(p_change_notice, FND_API.G_MISS_CHAR)
93: OR
94: NVL(p_rev_component_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
95: NVL(p_organization_code, FND_API.G_MISS_CHAR)
96: THEN
90: LOOP
91: IF NVL(p_rev_component_tbl(table_index).ECO_name, FND_API.G_MISS_CHAR) <>
92: NVL(p_change_notice, FND_API.G_MISS_CHAR)
93: OR
94: NVL(p_rev_component_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
95: NVL(p_organization_code, FND_API.G_MISS_CHAR)
96: THEN
97: RETURN FALSE;
98: END IF;
91: IF NVL(p_rev_component_tbl(table_index).ECO_name, FND_API.G_MISS_CHAR) <>
92: NVL(p_change_notice, FND_API.G_MISS_CHAR)
93: OR
94: NVL(p_rev_component_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
95: NVL(p_organization_code, FND_API.G_MISS_CHAR)
96: THEN
97: RETURN FALSE;
98: END IF;
99: END LOOP;
115: record_count := p_ref_designator_tbl.COUNT;
116:
117: FOR table_index IN 1..record_count
118: LOOP
119: IF NVL(p_ref_designator_tbl(table_index).ECO_name, FND_API.G_MISS_CHAR) <>
120: NVL(p_change_notice, FND_API.G_MISS_CHAR)
121: OR
122: NVL(p_ref_designator_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
123: NVL(p_organization_code, FND_API.G_MISS_CHAR)
116:
117: FOR table_index IN 1..record_count
118: LOOP
119: IF NVL(p_ref_designator_tbl(table_index).ECO_name, FND_API.G_MISS_CHAR) <>
120: NVL(p_change_notice, FND_API.G_MISS_CHAR)
121: OR
122: NVL(p_ref_designator_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
123: NVL(p_organization_code, FND_API.G_MISS_CHAR)
124: THEN
118: LOOP
119: IF NVL(p_ref_designator_tbl(table_index).ECO_name, FND_API.G_MISS_CHAR) <>
120: NVL(p_change_notice, FND_API.G_MISS_CHAR)
121: OR
122: NVL(p_ref_designator_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
123: NVL(p_organization_code, FND_API.G_MISS_CHAR)
124: THEN
125: RETURN FALSE;
126: END IF;
119: IF NVL(p_ref_designator_tbl(table_index).ECO_name, FND_API.G_MISS_CHAR) <>
120: NVL(p_change_notice, FND_API.G_MISS_CHAR)
121: OR
122: NVL(p_ref_designator_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
123: NVL(p_organization_code, FND_API.G_MISS_CHAR)
124: THEN
125: RETURN FALSE;
126: END IF;
127: END LOOP;
143: record_count := p_sub_component_tbl.COUNT;
144:
145: FOR table_index IN 1..record_count
146: LOOP
147: IF NVL(p_sub_component_tbl(table_index).ECO_name, FND_API.G_MISS_CHAR) <>
148: NVL(p_change_notice, FND_API.G_MISS_CHAR)
149: OR
150: NVL(p_sub_component_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
151: NVL(p_organization_code, FND_API.G_MISS_CHAR)
144:
145: FOR table_index IN 1..record_count
146: LOOP
147: IF NVL(p_sub_component_tbl(table_index).ECO_name, FND_API.G_MISS_CHAR) <>
148: NVL(p_change_notice, FND_API.G_MISS_CHAR)
149: OR
150: NVL(p_sub_component_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
151: NVL(p_organization_code, FND_API.G_MISS_CHAR)
152: THEN
146: LOOP
147: IF NVL(p_sub_component_tbl(table_index).ECO_name, FND_API.G_MISS_CHAR) <>
148: NVL(p_change_notice, FND_API.G_MISS_CHAR)
149: OR
150: NVL(p_sub_component_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
151: NVL(p_organization_code, FND_API.G_MISS_CHAR)
152: THEN
153: RETURN FALSE;
154: END IF;
147: IF NVL(p_sub_component_tbl(table_index).ECO_name, FND_API.G_MISS_CHAR) <>
148: NVL(p_change_notice, FND_API.G_MISS_CHAR)
149: OR
150: NVL(p_sub_component_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
151: NVL(p_organization_code, FND_API.G_MISS_CHAR)
152: THEN
153: RETURN FALSE;
154: END IF;
155: END LOOP;
178: record_count := p_rev_operation_tbl.COUNT;
179:
180: FOR table_index IN 1..record_count
181: LOOP
182: IF NVL(p_rev_operation_tbl(table_index).ECO_name, FND_API.G_MISS_CHAR) <>
183: NVL(p_change_notice, FND_API.G_MISS_CHAR)
184: OR
185: NVL(p_rev_operation_tbl(table_index).organization_code,
186: FND_API.G_MISS_CHAR) <>
179:
180: FOR table_index IN 1..record_count
181: LOOP
182: IF NVL(p_rev_operation_tbl(table_index).ECO_name, FND_API.G_MISS_CHAR) <>
183: NVL(p_change_notice, FND_API.G_MISS_CHAR)
184: OR
185: NVL(p_rev_operation_tbl(table_index).organization_code,
186: FND_API.G_MISS_CHAR) <>
187: NVL(p_organization_code, FND_API.G_MISS_CHAR)
182: IF NVL(p_rev_operation_tbl(table_index).ECO_name, FND_API.G_MISS_CHAR) <>
183: NVL(p_change_notice, FND_API.G_MISS_CHAR)
184: OR
185: NVL(p_rev_operation_tbl(table_index).organization_code,
186: FND_API.G_MISS_CHAR) <>
187: NVL(p_organization_code, FND_API.G_MISS_CHAR)
188:
189: THEN
190: RETURN FALSE;
183: NVL(p_change_notice, FND_API.G_MISS_CHAR)
184: OR
185: NVL(p_rev_operation_tbl(table_index).organization_code,
186: FND_API.G_MISS_CHAR) <>
187: NVL(p_organization_code, FND_API.G_MISS_CHAR)
188:
189: THEN
190: RETURN FALSE;
191: END IF;
215:
216: FOR table_index IN 1..record_count
217: LOOP
218: IF NVL(p_rev_op_resource_tbl(table_index).ECO_name,
219: FND_API.G_MISS_CHAR) <>
220: NVL(p_change_notice, FND_API.G_MISS_CHAR)
221: OR
222: NVL(p_rev_op_resource_tbl(table_index).organization_code,
223: FND_API.G_MISS_CHAR) <>
216: FOR table_index IN 1..record_count
217: LOOP
218: IF NVL(p_rev_op_resource_tbl(table_index).ECO_name,
219: FND_API.G_MISS_CHAR) <>
220: NVL(p_change_notice, FND_API.G_MISS_CHAR)
221: OR
222: NVL(p_rev_op_resource_tbl(table_index).organization_code,
223: FND_API.G_MISS_CHAR) <>
224: NVL(p_organization_code, FND_API.G_MISS_CHAR)
219: FND_API.G_MISS_CHAR) <>
220: NVL(p_change_notice, FND_API.G_MISS_CHAR)
221: OR
222: NVL(p_rev_op_resource_tbl(table_index).organization_code,
223: FND_API.G_MISS_CHAR) <>
224: NVL(p_organization_code, FND_API.G_MISS_CHAR)
225: THEN
226: RETURN FALSE;
227: END IF;
220: NVL(p_change_notice, FND_API.G_MISS_CHAR)
221: OR
222: NVL(p_rev_op_resource_tbl(table_index).organization_code,
223: FND_API.G_MISS_CHAR) <>
224: NVL(p_organization_code, FND_API.G_MISS_CHAR)
225: THEN
226: RETURN FALSE;
227: END IF;
228: END LOOP;
251:
252: FOR table_index IN 1..record_count
253: LOOP
254: IF NVL(p_rev_sub_resource_tbl(table_index).ECO_name,
255: FND_API.G_MISS_CHAR) <>
256: NVL(p_change_notice, FND_API.G_MISS_CHAR)
257: OR
258: NVL(p_rev_sub_resource_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
259: NVL(p_organization_code, FND_API.G_MISS_CHAR)
252: FOR table_index IN 1..record_count
253: LOOP
254: IF NVL(p_rev_sub_resource_tbl(table_index).ECO_name,
255: FND_API.G_MISS_CHAR) <>
256: NVL(p_change_notice, FND_API.G_MISS_CHAR)
257: OR
258: NVL(p_rev_sub_resource_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
259: NVL(p_organization_code, FND_API.G_MISS_CHAR)
260: THEN
254: IF NVL(p_rev_sub_resource_tbl(table_index).ECO_name,
255: FND_API.G_MISS_CHAR) <>
256: NVL(p_change_notice, FND_API.G_MISS_CHAR)
257: OR
258: NVL(p_rev_sub_resource_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
259: NVL(p_organization_code, FND_API.G_MISS_CHAR)
260: THEN
261: RETURN FALSE;
262: END IF;
255: FND_API.G_MISS_CHAR) <>
256: NVL(p_change_notice, FND_API.G_MISS_CHAR)
257: OR
258: NVL(p_rev_sub_resource_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
259: NVL(p_organization_code, FND_API.G_MISS_CHAR)
260: THEN
261: RETURN FALSE;
262: END IF;
263: END LOOP;
289: record_count := p_change_line_tbl.COUNT;
290:
291: FOR table_index IN 1..record_count
292: LOOP
293: IF NVL(p_change_line_tbl(table_index).ECO_name ,FND_API.G_MISS_CHAR) <>
294: NVL(p_change_notice, FND_API.G_MISS_CHAR)
295: OR
296: NVL(p_change_line_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
297: NVL(p_organization_code, FND_API.G_MISS_CHAR)
290:
291: FOR table_index IN 1..record_count
292: LOOP
293: IF NVL(p_change_line_tbl(table_index).ECO_name ,FND_API.G_MISS_CHAR) <>
294: NVL(p_change_notice, FND_API.G_MISS_CHAR)
295: OR
296: NVL(p_change_line_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
297: NVL(p_organization_code, FND_API.G_MISS_CHAR)
298: THEN
292: LOOP
293: IF NVL(p_change_line_tbl(table_index).ECO_name ,FND_API.G_MISS_CHAR) <>
294: NVL(p_change_notice, FND_API.G_MISS_CHAR)
295: OR
296: NVL(p_change_line_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
297: NVL(p_organization_code, FND_API.G_MISS_CHAR)
298: THEN
299: RETURN FALSE;
300: END IF;
293: IF NVL(p_change_line_tbl(table_index).ECO_name ,FND_API.G_MISS_CHAR) <>
294: NVL(p_change_notice, FND_API.G_MISS_CHAR)
295: OR
296: NVL(p_change_line_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
297: NVL(p_organization_code, FND_API.G_MISS_CHAR)
298: THEN
299: RETURN FALSE;
300: END IF;
301: END LOOP;
325: l_organization_code VARCHAR2(3);
326: l_change_notice VARCHAR2(10);
327: BEGIN
328: IF (p_ECO_rec.ECO_name IS NOT NULL AND
329: p_ECO_rec.ECO_name <> FND_API.G_MISS_CHAR)
330: OR
331: (p_ECO_rec.organization_code IS NOT NULL AND
332: p_ECO_rec.organization_code <> FND_API.G_MISS_CHAR)
333: THEN
328: IF (p_ECO_rec.ECO_name IS NOT NULL AND
329: p_ECO_rec.ECO_name <> FND_API.G_MISS_CHAR)
330: OR
331: (p_ECO_rec.organization_code IS NOT NULL AND
332: p_ECO_rec.organization_code <> FND_API.G_MISS_CHAR)
333: THEN
334: l_change_notice := p_ECO_rec.ECO_name;
335: l_organization_code := p_ECO_rec.organization_code;
336: x_change_notice := p_ECO_rec.ECO_name;
1281: l_p_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
1282: l_p_change_line_tbl Change_Line_Tbl_Type;
1283:
1284: BEGIN
1285: x_return_status := FND_API.G_RET_STS_SUCCESS;
1286:
1287: l_p_ECO_rec := p_eco_rec;
1288: l_p_eco_revision_tbl := p_eco_revision_tbl;
1289: l_p_revised_item_tbl := p_revised_item_tbl;
1310: , p_mesg_token_tbl => l_mesg_token_tbl
1311: , x_mesg_token_tbl => l_mesg_token_tbl
1312: );
1313:
1314: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1315: THEN
1316: BOM_Globals.Set_Debug('N');
1317: BOM_Rtg_Globals.Set_Debug('N'); -- Added by MK on 11/08/00
1318: END IF;
1337: THEN
1338: --Generate the change_notice
1339: l_p_ECO_rec.Eco_Name := Autogen_Change_Number(l_p_ECO_rec.Change_Management_Type, l_p_ECO_rec.Change_Type_Code);
1340: --For PLM change_name is mandatory
1341: IF (l_p_ECO_rec.Change_Name IS NULL OR l_p_ECO_rec.change_name = FND_API.G_MISS_CHAR)
1342: THEN
1343: l_p_ECO_rec.Change_Name := l_p_ECO_rec.Eco_Name;
1344: END IF;
1345: -- Populate the other BO tables if eco_name is not null
1381: RAISE G_EXC_SEV_QUIT_OBJECT;
1382: END IF;
1383:
1384: IF (l_change_notice IS NULL OR
1385: l_change_notice = FND_API.G_MISS_CHAR)
1386: OR
1387: (l_organization_code IS NULL OR
1388: l_organization_code = FND_API.G_MISS_CHAR)
1389: THEN
1384: IF (l_change_notice IS NULL OR
1385: l_change_notice = FND_API.G_MISS_CHAR)
1386: OR
1387: (l_organization_code IS NULL OR
1388: l_organization_code = FND_API.G_MISS_CHAR)
1389: THEN
1390: l_other_message := 'ENG_CHG_NOT_ORG_MISSING';
1391: RAISE G_EXC_SEV_QUIT_OBJECT;
1392: END IF;
1405: l_token_tbl(1).token_name := 'ORG_CODE';
1406: l_token_tbl(1).token_value := l_organization_code;
1407: RAISE G_EXC_SEV_QUIT_OBJECT;
1408:
1409: ELSIF l_organization_id = FND_API.G_MISS_NUM
1410: THEN
1411: l_other_message := 'ENG_UNEXP_ORG_INVALID';
1412: RAISE G_EXC_UNEXP_SKIP_OBJECT;
1413: END IF;
1583: By AS 11/11/98
1584:
1585: PROCEDURE Lock_Eco
1586: ( p_api_version_number IN NUMBER
1587: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1588: , x_return_status OUT NOCOPY VARCHAR2
1589: , x_msg_count OUT NOCOPY NUMBER
1590: , x_msg_data OUT NOCOPY VARCHAR2
1591: , p_ECO_rec IN Eco_Rec_Type :=