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.ENG_ECO_PVT dependencies on FND_API

Line 132: x_rev_sub_resource_tbl(I).return_status = FND_API.G_MISS_CHAR)

128:
129: FOR I IN 1..x_rev_sub_resource_tbl.COUNT LOOP
130: -- Processing records for which the return status is null
131: IF (x_rev_sub_resource_tbl(I).return_status IS NULL OR
132: x_rev_sub_resource_tbl(I).return_status = FND_API.G_MISS_CHAR)
133: THEN
134: BEGIN
135:
136: -- Load local records

Line 176: -- l_rev_sub_resource_rec.return_status = FND_API.G_MISS_CHAR)

172: -- that it is the child of the parent that called this procedure
173: --
174:
175: IF --(l_rev_sub_resource_rec.return_status IS NULL OR
176: -- l_rev_sub_resource_rec.return_status = FND_API.G_MISS_CHAR)
177: --AND
178: (
179: -- Did Op_Seq call this procedure, that is,
180: -- if revised operation(operation sequence) exists, then is this record a child ?

Line 185: NVL(l_rev_sub_resource_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )

181: ( l_op_parent_exists AND
182: l_rev_sub_resource_rec.ECO_name = p_change_notice AND
183: l_rev_sub_res_unexp_rec.organization_id
184: = p_organization_id AND
185: NVL(l_rev_sub_resource_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
186: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
187: l_rev_sub_resource_rec.revised_item_name
188: = p_revised_item_name AND
189: NVL(l_rev_sub_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )

Line 186: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND

182: l_rev_sub_resource_rec.ECO_name = p_change_notice AND
183: l_rev_sub_res_unexp_rec.organization_id
184: = p_organization_id AND
185: NVL(l_rev_sub_resource_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
186: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
187: l_rev_sub_resource_rec.revised_item_name
188: = p_revised_item_name AND
189: NVL(l_rev_sub_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
190: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND -- Added for bug 13440461

Line 189: NVL(l_rev_sub_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )

185: NVL(l_rev_sub_resource_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
186: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
187: l_rev_sub_resource_rec.revised_item_name
188: = p_revised_item_name AND
189: NVL(l_rev_sub_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
190: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND -- Added for bug 13440461
191: l_rev_sub_resource_rec.operation_sequence_number
192: = p_operation_seq_num AND
193: NVL(l_rev_sub_resource_rec.new_routing_revision,FND_API.G_MISS_CHAR )

Line 190: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND -- Added for bug 13440461

186: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
187: l_rev_sub_resource_rec.revised_item_name
188: = p_revised_item_name AND
189: NVL(l_rev_sub_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
190: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND -- Added for bug 13440461
191: l_rev_sub_resource_rec.operation_sequence_number
192: = p_operation_seq_num AND
193: NVL(l_rev_sub_resource_rec.new_routing_revision,FND_API.G_MISS_CHAR )
194: = NVL(p_routing_revision,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

Line 193: NVL(l_rev_sub_resource_rec.new_routing_revision,FND_API.G_MISS_CHAR )

189: NVL(l_rev_sub_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
190: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND -- Added for bug 13440461
191: l_rev_sub_resource_rec.operation_sequence_number
192: = p_operation_seq_num AND
193: NVL(l_rev_sub_resource_rec.new_routing_revision,FND_API.G_MISS_CHAR )
194: = NVL(p_routing_revision,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
195: NVL(l_rev_sub_resource_rec.from_end_item_unit_number,FND_API.G_MISS_CHAR )
196: = NVL(p_from_end_item_number,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
197: l_rev_sub_resource_rec.op_start_effective_date

Line 194: = NVL(p_routing_revision,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

190: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND -- Added for bug 13440461
191: l_rev_sub_resource_rec.operation_sequence_number
192: = p_operation_seq_num AND
193: NVL(l_rev_sub_resource_rec.new_routing_revision,FND_API.G_MISS_CHAR )
194: = NVL(p_routing_revision,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
195: NVL(l_rev_sub_resource_rec.from_end_item_unit_number,FND_API.G_MISS_CHAR )
196: = NVL(p_from_end_item_number,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
197: l_rev_sub_resource_rec.op_start_effective_date
198: = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) -- Bug 6657209

Line 195: NVL(l_rev_sub_resource_rec.from_end_item_unit_number,FND_API.G_MISS_CHAR )

191: l_rev_sub_resource_rec.operation_sequence_number
192: = p_operation_seq_num AND
193: NVL(l_rev_sub_resource_rec.new_routing_revision,FND_API.G_MISS_CHAR )
194: = NVL(p_routing_revision,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
195: NVL(l_rev_sub_resource_rec.from_end_item_unit_number,FND_API.G_MISS_CHAR )
196: = NVL(p_from_end_item_number,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
197: l_rev_sub_resource_rec.op_start_effective_date
198: = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) -- Bug 6657209
199: -- NVL(l_rev_sub_resource_rec.operation_type, 1)

Line 196: = NVL(p_from_end_item_number,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

192: = p_operation_seq_num AND
193: NVL(l_rev_sub_resource_rec.new_routing_revision,FND_API.G_MISS_CHAR )
194: = NVL(p_routing_revision,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
195: NVL(l_rev_sub_resource_rec.from_end_item_unit_number,FND_API.G_MISS_CHAR )
196: = NVL(p_from_end_item_number,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
197: l_rev_sub_resource_rec.op_start_effective_date
198: = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) -- Bug 6657209
199: -- NVL(l_rev_sub_resource_rec.operation_type, 1)
200: -- = NVL(p_operation_type, 1)

Line 210: NVL(l_rev_sub_resource_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )

206: ( l_rtg_parent_exists AND
207: l_rev_sub_resource_rec.ECO_name = p_change_notice AND
208: l_rev_sub_res_unexp_rec.organization_id
209: = p_organization_id AND
210: NVL(l_rev_sub_resource_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
211: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
212: l_rev_sub_resource_rec.revised_item_name
213: = p_revised_item_name AND
214: NVL(l_rev_sub_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )

Line 211: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND

207: l_rev_sub_resource_rec.ECO_name = p_change_notice AND
208: l_rev_sub_res_unexp_rec.organization_id
209: = p_organization_id AND
210: NVL(l_rev_sub_resource_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
211: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
212: l_rev_sub_resource_rec.revised_item_name
213: = p_revised_item_name AND
214: NVL(l_rev_sub_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
215: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND -- Added for bug 13440461

Line 214: NVL(l_rev_sub_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )

210: NVL(l_rev_sub_resource_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
211: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
212: l_rev_sub_resource_rec.revised_item_name
213: = p_revised_item_name AND
214: NVL(l_rev_sub_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
215: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND -- Added for bug 13440461
216: NVL(l_rev_sub_resource_rec.new_routing_revision,FND_API.G_MISS_CHAR )
217: = NVL(p_routing_revision,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
218: NVL(l_rev_sub_resource_rec.from_end_item_unit_number,FND_API.G_MISS_CHAR )

Line 215: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND -- Added for bug 13440461

211: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
212: l_rev_sub_resource_rec.revised_item_name
213: = p_revised_item_name AND
214: NVL(l_rev_sub_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
215: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND -- Added for bug 13440461
216: NVL(l_rev_sub_resource_rec.new_routing_revision,FND_API.G_MISS_CHAR )
217: = NVL(p_routing_revision,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
218: NVL(l_rev_sub_resource_rec.from_end_item_unit_number,FND_API.G_MISS_CHAR )
219: = NVL(p_from_end_item_number,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

Line 216: NVL(l_rev_sub_resource_rec.new_routing_revision,FND_API.G_MISS_CHAR )

212: l_rev_sub_resource_rec.revised_item_name
213: = p_revised_item_name AND
214: NVL(l_rev_sub_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
215: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND -- Added for bug 13440461
216: NVL(l_rev_sub_resource_rec.new_routing_revision,FND_API.G_MISS_CHAR )
217: = NVL(p_routing_revision,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
218: NVL(l_rev_sub_resource_rec.from_end_item_unit_number,FND_API.G_MISS_CHAR )
219: = NVL(p_from_end_item_number,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
220: l_rev_sub_resource_rec.op_start_effective_date

Line 217: = NVL(p_routing_revision,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

213: = p_revised_item_name AND
214: NVL(l_rev_sub_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
215: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND -- Added for bug 13440461
216: NVL(l_rev_sub_resource_rec.new_routing_revision,FND_API.G_MISS_CHAR )
217: = NVL(p_routing_revision,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
218: NVL(l_rev_sub_resource_rec.from_end_item_unit_number,FND_API.G_MISS_CHAR )
219: = NVL(p_from_end_item_number,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
220: l_rev_sub_resource_rec.op_start_effective_date
221: = p_effectivity_date

Line 218: NVL(l_rev_sub_resource_rec.from_end_item_unit_number,FND_API.G_MISS_CHAR )

214: NVL(l_rev_sub_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
215: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND -- Added for bug 13440461
216: NVL(l_rev_sub_resource_rec.new_routing_revision,FND_API.G_MISS_CHAR )
217: = NVL(p_routing_revision,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
218: NVL(l_rev_sub_resource_rec.from_end_item_unit_number,FND_API.G_MISS_CHAR )
219: = NVL(p_from_end_item_number,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
220: l_rev_sub_resource_rec.op_start_effective_date
221: = p_effectivity_date
222: -- NVL(l_rev_sub_resource_rec.alternate_routing_code, 'P')

Line 219: = NVL(p_from_end_item_number,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

215: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND -- Added for bug 13440461
216: NVL(l_rev_sub_resource_rec.new_routing_revision,FND_API.G_MISS_CHAR )
217: = NVL(p_routing_revision,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
218: NVL(l_rev_sub_resource_rec.from_end_item_unit_number,FND_API.G_MISS_CHAR )
219: = NVL(p_from_end_item_number,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
220: l_rev_sub_resource_rec.op_start_effective_date
221: = p_effectivity_date
222: -- NVL(l_rev_sub_resource_rec.alternate_routing_code, 'P')
223: -- = NVL(p_alternate_routing_code, 'P')

Line 230: l_return_status := FND_API.G_RET_STS_SUCCESS;

226: OR
227: (NOT l_rtg_parent_exists AND NOT l_op_parent_exists)
228: )
229: THEN
230: l_return_status := FND_API.G_RET_STS_SUCCESS;
231: l_rev_sub_resource_rec.return_status := FND_API.G_RET_STS_SUCCESS;
232:
233: -- Bug 6657209
234: IF (l_op_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null) THEN

Line 231: l_rev_sub_resource_rec.return_status := FND_API.G_RET_STS_SUCCESS;

227: (NOT l_rtg_parent_exists AND NOT l_op_parent_exists)
228: )
229: THEN
230: l_return_status := FND_API.G_RET_STS_SUCCESS;
231: l_rev_sub_resource_rec.return_status := FND_API.G_RET_STS_SUCCESS;
232:
233: -- Bug 6657209
234: IF (l_op_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null) THEN
235: l_rev_sub_resource_rec.op_start_effective_date := p_effectivity_date;

Line 1169: , p_error_status => FND_API.G_RET_STS_ERROR

1165: WHEN EXC_SEV_QUIT_RECORD THEN
1166: ECO_Error_Handler.Log_Error
1167: ( p_rev_sub_resource_tbl => x_rev_sub_resource_tbl
1168: , p_mesg_token_tbl => l_mesg_token_tbl
1169: , p_error_status => FND_API.G_RET_STS_ERROR
1170: , p_error_scope => Error_Handler.G_SCOPE_RECORD
1171: , p_error_level => ECO_Error_Handler.G_SR_LEVEL
1172: , p_entity_index => I
1173: , x_ECO_rec => l_ECO_rec

Line 1512: x_rev_op_resource_tbl(I).return_status = FND_API.G_MISS_CHAR) THEN

1508:
1509: FOR I IN 1..x_rev_op_resource_tbl.COUNT LOOP
1510: -- Processing records for which the return status is null
1511: IF (x_rev_op_resource_tbl(I).return_status IS NULL OR
1512: x_rev_op_resource_tbl(I).return_status = FND_API.G_MISS_CHAR) THEN
1513: BEGIN
1514:
1515: -- Load local records
1516: l_rev_op_resource_rec := x_rev_op_resource_tbl(I) ;

Line 1567: --l_rev_op_resource_rec.return_status = FND_API.G_MISS_CHAR)

1563: ' Op. Seq: ' || p_operation_seq_num); END IF;
1564:
1565:
1566: IF --(l_rev_op_resource_rec.return_status IS NULL OR
1567: --l_rev_op_resource_rec.return_status = FND_API.G_MISS_CHAR)
1568: --AND
1569: (
1570: -- Did Op_Seq call this procedure, that is,
1571: -- if revised operation(operation sequence) exists, then is this record a child ?

Line 1579: NVL(l_rev_op_resource_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )

1575: l_rev_op_res_unexp_rec.organization_id
1576: = p_organization_id AND
1577: l_rev_op_resource_rec.op_start_effective_date
1578: = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
1579: NVL(l_rev_op_resource_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
1580: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
1581: l_rev_op_resource_rec.revised_item_name
1582: = p_revised_item_name AND
1583: NVL(l_rev_op_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )

Line 1580: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND

1576: = p_organization_id AND
1577: l_rev_op_resource_rec.op_start_effective_date
1578: = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
1579: NVL(l_rev_op_resource_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
1580: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
1581: l_rev_op_resource_rec.revised_item_name
1582: = p_revised_item_name AND
1583: NVL(l_rev_op_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
1584: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND --Added for bug 13440461

Line 1583: NVL(l_rev_op_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )

1579: NVL(l_rev_op_resource_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
1580: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
1581: l_rev_op_resource_rec.revised_item_name
1582: = p_revised_item_name AND
1583: NVL(l_rev_op_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
1584: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND --Added for bug 13440461
1585: NVL(l_rev_op_resource_rec.new_routing_revision, FND_API.G_MISS_CHAR )
1586: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
1587: NVL(l_rev_op_resource_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )

Line 1584: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND --Added for bug 13440461

1580: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
1581: l_rev_op_resource_rec.revised_item_name
1582: = p_revised_item_name AND
1583: NVL(l_rev_op_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
1584: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND --Added for bug 13440461
1585: NVL(l_rev_op_resource_rec.new_routing_revision, FND_API.G_MISS_CHAR )
1586: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
1587: NVL(l_rev_op_resource_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
1588: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

Line 1585: NVL(l_rev_op_resource_rec.new_routing_revision, FND_API.G_MISS_CHAR )

1581: l_rev_op_resource_rec.revised_item_name
1582: = p_revised_item_name AND
1583: NVL(l_rev_op_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
1584: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND --Added for bug 13440461
1585: NVL(l_rev_op_resource_rec.new_routing_revision, FND_API.G_MISS_CHAR )
1586: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
1587: NVL(l_rev_op_resource_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
1588: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
1589: l_rev_op_resource_rec.operation_sequence_number

Line 1586: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

1582: = p_revised_item_name AND
1583: NVL(l_rev_op_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
1584: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND --Added for bug 13440461
1585: NVL(l_rev_op_resource_rec.new_routing_revision, FND_API.G_MISS_CHAR )
1586: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
1587: NVL(l_rev_op_resource_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
1588: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
1589: l_rev_op_resource_rec.operation_sequence_number
1590: = p_operation_seq_num AND

Line 1587: NVL(l_rev_op_resource_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )

1583: NVL(l_rev_op_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
1584: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND --Added for bug 13440461
1585: NVL(l_rev_op_resource_rec.new_routing_revision, FND_API.G_MISS_CHAR )
1586: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
1587: NVL(l_rev_op_resource_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
1588: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
1589: l_rev_op_resource_rec.operation_sequence_number
1590: = p_operation_seq_num AND
1591: NVL(l_rev_op_resource_rec.operation_type, 1)

Line 1588: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

1584: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND --Added for bug 13440461
1585: NVL(l_rev_op_resource_rec.new_routing_revision, FND_API.G_MISS_CHAR )
1586: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
1587: NVL(l_rev_op_resource_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
1588: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
1589: l_rev_op_resource_rec.operation_sequence_number
1590: = p_operation_seq_num AND
1591: NVL(l_rev_op_resource_rec.operation_type, 1)
1592: = NVL(p_operation_type, 1)

Line 1606: NVL(l_rev_op_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )

1602: l_rev_op_res_unexp_rec.organization_id
1603: = p_organization_id AND
1604: l_rev_op_resource_rec.revised_item_name
1605: = p_revised_item_name AND
1606: NVL(l_rev_op_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
1607: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND --Added for bug 13440461
1608: l_rev_op_resource_rec.op_start_effective_date
1609: = p_effectivity_date AND
1610: NVL(l_rev_op_resource_rec.new_routing_revision, FND_API.G_MISS_CHAR )

Line 1607: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND --Added for bug 13440461

1603: = p_organization_id AND
1604: l_rev_op_resource_rec.revised_item_name
1605: = p_revised_item_name AND
1606: NVL(l_rev_op_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
1607: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND --Added for bug 13440461
1608: l_rev_op_resource_rec.op_start_effective_date
1609: = p_effectivity_date AND
1610: NVL(l_rev_op_resource_rec.new_routing_revision, FND_API.G_MISS_CHAR )
1611: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

Line 1610: NVL(l_rev_op_resource_rec.new_routing_revision, FND_API.G_MISS_CHAR )

1606: NVL(l_rev_op_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
1607: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND --Added for bug 13440461
1608: l_rev_op_resource_rec.op_start_effective_date
1609: = p_effectivity_date AND
1610: NVL(l_rev_op_resource_rec.new_routing_revision, FND_API.G_MISS_CHAR )
1611: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
1612: NVL(l_rev_op_resource_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
1613: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
1614: NVL(l_rev_op_resource_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )

Line 1611: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

1607: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND --Added for bug 13440461
1608: l_rev_op_resource_rec.op_start_effective_date
1609: = p_effectivity_date AND
1610: NVL(l_rev_op_resource_rec.new_routing_revision, FND_API.G_MISS_CHAR )
1611: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
1612: NVL(l_rev_op_resource_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
1613: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
1614: NVL(l_rev_op_resource_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
1615: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) )

Line 1612: NVL(l_rev_op_resource_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )

1608: l_rev_op_resource_rec.op_start_effective_date
1609: = p_effectivity_date AND
1610: NVL(l_rev_op_resource_rec.new_routing_revision, FND_API.G_MISS_CHAR )
1611: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
1612: NVL(l_rev_op_resource_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
1613: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
1614: NVL(l_rev_op_resource_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
1615: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) )
1616: )

Line 1613: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

1609: = p_effectivity_date AND
1610: NVL(l_rev_op_resource_rec.new_routing_revision, FND_API.G_MISS_CHAR )
1611: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
1612: NVL(l_rev_op_resource_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
1613: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
1614: NVL(l_rev_op_resource_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
1615: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) )
1616: )
1617:

Line 1614: NVL(l_rev_op_resource_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )

1610: NVL(l_rev_op_resource_rec.new_routing_revision, FND_API.G_MISS_CHAR )
1611: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
1612: NVL(l_rev_op_resource_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
1613: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
1614: NVL(l_rev_op_resource_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
1615: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) )
1616: )
1617:
1618: OR

Line 1615: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) )

1611: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
1612: NVL(l_rev_op_resource_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
1613: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
1614: NVL(l_rev_op_resource_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
1615: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) )
1616: )
1617:
1618: OR
1619:

Line 1625: l_return_status := FND_API.G_RET_STS_SUCCESS;

1621: NOT l_op_parent_exists)
1622: )
1623:
1624: THEN
1625: l_return_status := FND_API.G_RET_STS_SUCCESS;
1626: l_rev_op_resource_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1627:
1628: -- Bug 6657209
1629: IF (l_op_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null) THEN

Line 1626: l_rev_op_resource_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1622: )
1623:
1624: THEN
1625: l_return_status := FND_API.G_RET_STS_SUCCESS;
1626: l_rev_op_resource_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1627:
1628: -- Bug 6657209
1629: IF (l_op_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null) THEN
1630: l_rev_op_resource_rec.op_start_effective_date := p_effectivity_date;

Line 2210: , p_acd_type => FND_API.G_MISS_NUM

2206:
2207: Bom_Op_Res_Util.Query_Row
2208: ( p_resource_sequence_number => l_rev_op_resource_rec.resource_sequence_number
2209: , p_operation_sequence_id => l_rev_op_res_unexp_rec.operation_sequence_id
2210: , p_acd_type => FND_API.G_MISS_NUM
2211: , p_mesg_token_tbl => l_mesg_token_tbl
2212: , x_rev_op_resource_rec => l_old_rev_op_resource_rec
2213: , x_rev_op_res_unexp_rec => l_old_rev_op_res_unexp_rec
2214: , x_mesg_token_tbl => l_mesg_token_tbl

Line 2533: , p_error_status => FND_API.G_RET_STS_ERROR

2529: WHEN EXC_SEV_QUIT_RECORD THEN
2530: ECO_Error_Handler.Log_Error
2531: ( p_rev_op_resource_tbl => x_rev_op_resource_tbl
2532: , p_mesg_token_tbl => l_mesg_token_tbl
2533: , p_error_status => FND_API.G_RET_STS_ERROR
2534: , p_error_scope => Error_Handler.G_SCOPE_RECORD
2535: , p_error_level => Error_Handler.G_RES_LEVEL
2536: , p_entity_index => I
2537: , x_ECO_rec => l_ECO_rec

Line 2860: l_return_status := FND_API.G_RET_STS_SUCCESS ;

2856:
2857: BEGIN
2858:
2859: -- Init local table variables.
2860: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2861: l_bo_return_status := FND_API.G_RET_STS_SUCCESS ;
2862: x_return_status := FND_API.G_RET_STS_SUCCESS; -- Bug 7606951
2863: x_rev_operation_tbl := p_rev_operation_tbl ;
2864: x_rev_op_resource_tbl := p_rev_op_resource_tbl ;

Line 2861: l_bo_return_status := FND_API.G_RET_STS_SUCCESS ;

2857: BEGIN
2858:
2859: -- Init local table variables.
2860: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2861: l_bo_return_status := FND_API.G_RET_STS_SUCCESS ;
2862: x_return_status := FND_API.G_RET_STS_SUCCESS; -- Bug 7606951
2863: x_rev_operation_tbl := p_rev_operation_tbl ;
2864: x_rev_op_resource_tbl := p_rev_op_resource_tbl ;
2865: x_rev_sub_resource_tbl := p_rev_sub_resource_tbl ;

Line 2862: x_return_status := FND_API.G_RET_STS_SUCCESS; -- Bug 7606951

2858:
2859: -- Init local table variables.
2860: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2861: l_bo_return_status := FND_API.G_RET_STS_SUCCESS ;
2862: x_return_status := FND_API.G_RET_STS_SUCCESS; -- Bug 7606951
2863: x_rev_operation_tbl := p_rev_operation_tbl ;
2864: x_rev_op_resource_tbl := p_rev_op_resource_tbl ;
2865: x_rev_sub_resource_tbl := p_rev_sub_resource_tbl ;
2866:

Line 2873: x_rev_operation_tbl(I).return_status = FND_API.G_MISS_CHAR) THEN

2869:
2870: FOR I IN 1..x_rev_operation_tbl.COUNT LOOP
2871:
2872: IF (x_rev_operation_tbl(I).return_status IS NULL OR
2873: x_rev_operation_tbl(I).return_status = FND_API.G_MISS_CHAR) THEN
2874:
2875: BEGIN
2876:
2877: -- Load local records.

Line 2915: --l_rev_operation_rec.return_status = FND_API.G_MISS_CHAR)

2911: -- that it is the child of the parent that called this procedure
2912: --
2913:
2914: IF --(l_rev_operation_rec.return_status IS NULL OR
2915: --l_rev_operation_rec.return_status = FND_API.G_MISS_CHAR)
2916: --AND
2917:
2918: -- Did Rev_Items call this procedure, that is,
2919: -- if revised item exists, then is this record a child ?

Line 2927: NVL(l_rev_operation_rec.alternate_routing_code, FND_API.G_MISS_CHAR )

2923: (l_item_parent_exists AND
2924: (l_rev_operation_rec.ECO_Name = p_change_notice AND
2925: l_rev_op_unexp_rec.organization_id = p_organization_id AND
2926: l_rev_operation_rec.revised_item_name = p_revised_item_name AND
2927: NVL(l_rev_operation_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
2928: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR ) AND -- Added for bug 13440461
2929: l_rev_operation_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
2930: NVL(l_rev_operation_rec.new_routing_revision, FND_API.G_MISS_CHAR )
2931: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

Line 2928: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR ) AND -- Added for bug 13440461

2924: (l_rev_operation_rec.ECO_Name = p_change_notice AND
2925: l_rev_op_unexp_rec.organization_id = p_organization_id AND
2926: l_rev_operation_rec.revised_item_name = p_revised_item_name AND
2927: NVL(l_rev_operation_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
2928: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR ) AND -- Added for bug 13440461
2929: l_rev_operation_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
2930: NVL(l_rev_operation_rec.new_routing_revision, FND_API.G_MISS_CHAR )
2931: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
2932: NVL(l_rev_operation_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )

Line 2930: NVL(l_rev_operation_rec.new_routing_revision, FND_API.G_MISS_CHAR )

2926: l_rev_operation_rec.revised_item_name = p_revised_item_name AND
2927: NVL(l_rev_operation_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
2928: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR ) AND -- Added for bug 13440461
2929: l_rev_operation_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
2930: NVL(l_rev_operation_rec.new_routing_revision, FND_API.G_MISS_CHAR )
2931: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
2932: NVL(l_rev_operation_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
2933: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
2934: NVL(l_rev_operation_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )

Line 2931: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

2927: NVL(l_rev_operation_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
2928: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR ) AND -- Added for bug 13440461
2929: l_rev_operation_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
2930: NVL(l_rev_operation_rec.new_routing_revision, FND_API.G_MISS_CHAR )
2931: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
2932: NVL(l_rev_operation_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
2933: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
2934: NVL(l_rev_operation_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
2935: = NVL(p_item_revision, FND_API.G_MISS_CHAR) ))

Line 2932: NVL(l_rev_operation_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )

2928: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR ) AND -- Added for bug 13440461
2929: l_rev_operation_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
2930: NVL(l_rev_operation_rec.new_routing_revision, FND_API.G_MISS_CHAR )
2931: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
2932: NVL(l_rev_operation_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
2933: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
2934: NVL(l_rev_operation_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
2935: = NVL(p_item_revision, FND_API.G_MISS_CHAR) ))
2936: )

Line 2933: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

2929: l_rev_operation_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
2930: NVL(l_rev_operation_rec.new_routing_revision, FND_API.G_MISS_CHAR )
2931: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
2932: NVL(l_rev_operation_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
2933: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
2934: NVL(l_rev_operation_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
2935: = NVL(p_item_revision, FND_API.G_MISS_CHAR) ))
2936: )
2937: THEN

Line 2934: NVL(l_rev_operation_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )

2930: NVL(l_rev_operation_rec.new_routing_revision, FND_API.G_MISS_CHAR )
2931: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
2932: NVL(l_rev_operation_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
2933: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
2934: NVL(l_rev_operation_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
2935: = NVL(p_item_revision, FND_API.G_MISS_CHAR) ))
2936: )
2937: THEN
2938:

Line 2935: = NVL(p_item_revision, FND_API.G_MISS_CHAR) ))

2931: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
2932: NVL(l_rev_operation_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
2933: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
2934: NVL(l_rev_operation_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
2935: = NVL(p_item_revision, FND_API.G_MISS_CHAR) ))
2936: )
2937: THEN
2938:
2939: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2939: l_return_status := FND_API.G_RET_STS_SUCCESS;

2935: = NVL(p_item_revision, FND_API.G_MISS_CHAR) ))
2936: )
2937: THEN
2938:
2939: l_return_status := FND_API.G_RET_STS_SUCCESS;
2940: l_rev_operation_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2941:
2942: -- Bug 6657209
2943: IF (l_item_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null) THEN

Line 2940: l_rev_operation_rec.return_status := FND_API.G_RET_STS_SUCCESS;

2936: )
2937: THEN
2938:
2939: l_return_status := FND_API.G_RET_STS_SUCCESS;
2940: l_rev_operation_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2941:
2942: -- Bug 6657209
2943: IF (l_item_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null) THEN
2944: l_rev_operation_rec.start_effective_date := p_effectivity_date;

Line 3094: l_return_status := FND_API.G_RET_STS_ERROR;

3090: -- by model unit effectivity
3091: --
3092: --
3093: IF Bom_Rtg_Globals.Get_Unit_Controlled_Item THEN
3094: l_return_status := FND_API.G_RET_STS_ERROR;
3095: l_token_tbl(1).token_name := 'OP_SEQ_NUMBER';
3096: l_token_tbl(1).token_value := l_rev_operation_rec.operation_sequence_number ;
3097: l_token_tbl(2).token_name := 'REVISED_ITEM_NAME';
3098: l_token_tbl(2).token_value := l_rev_operation_rec.revised_item_name ;

Line 3613: l_rev_operation_rec.old_operation_sequence_number = FND_API.G_MISS_NUM

3609: AND l_rev_operation_rec.acd_type IN (2 ,3) ) -- ACD Type: Change or Disable
3610: THEN
3611:
3612: IF l_rev_operation_rec.old_operation_sequence_number IS NULL OR
3613: l_rev_operation_rec.old_operation_sequence_number = FND_API.G_MISS_NUM
3614: THEN
3615: l_rev_operation_rec.old_operation_sequence_number
3616: := l_rev_operation_rec.operation_sequence_number ;
3617: END IF ;

Line 4094: , p_error_status => FND_API.G_RET_STS_ERROR

4090: ( p_rev_operation_tbl => x_rev_operation_tbl
4091: , p_rev_op_resource_tbl => x_rev_op_resource_tbl
4092: , p_rev_sub_resource_tbl => x_rev_sub_resource_tbl
4093: , p_mesg_token_tbl => l_mesg_token_tbl
4094: , p_error_status => FND_API.G_RET_STS_ERROR
4095: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4096: , p_error_level => Error_Handler.G_OP_LEVEL
4097: , p_entity_index => I
4098: , x_eco_rec => l_eco_rec

Line 4131: , p_error_status => FND_API.G_RET_STS_ERROR

4127: ( p_rev_operation_tbl => x_rev_operation_tbl
4128: , p_rev_op_resource_tbl => x_rev_op_resource_tbl
4129: , p_rev_sub_resource_tbl => x_rev_sub_resource_tbl
4130: , p_mesg_token_tbl => l_mesg_token_tbl
4131: , p_error_status => FND_API.G_RET_STS_ERROR
4132: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4133: , p_error_level => Error_Handler.G_OP_LEVEL
4134: , p_entity_index => I
4135: , x_eco_rec => l_eco_rec

Line 4167: , p_error_status => FND_API.G_RET_STS_ERROR

4163: ( p_rev_operation_tbl => x_rev_operation_tbl
4164: , p_rev_op_resource_tbl => x_rev_op_resource_tbl
4165: , p_rev_sub_resource_tbl => x_rev_sub_resource_tbl
4166: , p_mesg_token_tbl => l_mesg_token_tbl
4167: , p_error_status => FND_API.G_RET_STS_ERROR
4168: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4169: , p_error_level => Error_Handler.G_OP_LEVEL
4170: , p_entity_index => I
4171: , x_eco_rec => l_eco_rec

Line 4202: , p_error_status => FND_API.G_RET_STS_ERROR

4198: ( p_rev_operation_tbl => x_rev_operation_tbl
4199: , p_rev_op_resource_tbl => x_rev_op_resource_tbl
4200: , p_rev_sub_resource_tbl => x_rev_sub_resource_tbl
4201: , p_mesg_token_tbl => l_mesg_token_tbl
4202: , p_error_status => FND_API.G_RET_STS_ERROR
4203: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4204: , p_error_level => Error_Handler.G_OP_LEVEL
4205: , p_entity_index => I
4206: , x_eco_rec => l_eco_rec

Line 4239: , p_error_status => FND_API.G_RET_STS_ERROR

4235: ( p_rev_operation_tbl => x_rev_operation_tbl
4236: , p_rev_op_resource_tbl => x_rev_op_resource_tbl
4237: , p_rev_sub_resource_tbl => x_rev_sub_resource_tbl
4238: , p_mesg_token_tbl => l_mesg_token_tbl
4239: , p_error_status => FND_API.G_RET_STS_ERROR
4240: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4241: , p_error_level => Error_Handler.G_OP_LEVEL
4242: , p_entity_index => I
4243: , x_eco_rec => l_eco_rec

Line 4270: , p_error_status => FND_API.G_RET_STS_ERROR

4266: ( p_rev_operation_tbl => x_rev_operation_tbl
4267: , p_rev_op_resource_tbl => x_rev_op_resource_tbl
4268: , p_rev_sub_resource_tbl => x_rev_sub_resource_tbl
4269: , p_mesg_token_tbl => l_mesg_token_tbl
4270: , p_error_status => FND_API.G_RET_STS_ERROR
4271: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4272: , p_error_level => Error_Handler.G_OP_LEVEL
4273: , p_entity_index => I
4274: , x_eco_rec => l_eco_rec

Line 4301: , p_error_status => FND_API.G_RET_STS_ERROR

4297: ( p_rev_operation_tbl => x_rev_operation_tbl
4298: , p_rev_op_resource_tbl => x_rev_op_resource_tbl
4299: , p_rev_sub_resource_tbl => x_rev_sub_resource_tbl
4300: , p_mesg_token_tbl => l_mesg_token_tbl
4301: , p_error_status => FND_API.G_RET_STS_ERROR
4302: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4303: , p_error_level => Error_Handler.G_OP_LEVEL
4304: , p_entity_index => I
4305: , x_eco_rec => l_eco_rec

Line 4396: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

4392: , x_return_status => l_return_status
4393: ) ;
4394:
4395: -- Bug 7606951. Populate l_bo_return_status if l_return_status is not S
4396: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
4397: THEN
4398: l_bo_return_status := l_return_status;
4399: END IF;
4400: -- Process Substitute Operation Resources that are direct children of this

Line 4430: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

4426: , x_return_status => l_return_status
4427: ) ;
4428:
4429: -- Bug 7606951. Populate l_bo_return_status if l_return_status is not S
4430: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
4431: THEN
4432: l_bo_return_status := l_return_status;
4433: END IF;
4434:

Line 4530: x_sub_component_tbl(I).return_status = FND_API.G_MISS_CHAR) THEN

4526:
4527: FOR I IN 1..x_sub_component_tbl.COUNT LOOP
4528:
4529: IF (x_sub_component_tbl(I).return_status IS NULL OR
4530: x_sub_component_tbl(I).return_status = FND_API.G_MISS_CHAR) THEN
4531:
4532: BEGIN
4533:
4534: -- Load local records.

Line 4567: --l_sub_component_rec.return_status = FND_API.G_MISS_CHAR)

4563: -- that it is the child of the parent that called this procedure
4564: --
4565:
4566: IF --(l_sub_component_rec.return_status IS NULL OR
4567: --l_sub_component_rec.return_status = FND_API.G_MISS_CHAR)
4568: --AND
4569:
4570: -- Did Rev_Comps call this procedure, that is,
4571: -- if revised comp exists, then is this record a child ?

Line 4577: NVL(l_sub_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )

4573: ((l_comp_parent_exists AND
4574: (l_sub_component_rec.ECO_Name = p_change_notice AND
4575: l_sub_comp_unexp_rec.organization_id = p_organization_id AND
4576: l_sub_component_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
4577: NVL(l_sub_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
4578: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
4579: l_sub_component_rec.revised_item_name = p_revised_item_name AND
4580: NVL(l_sub_component_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND -- Bug 3991176
4581: NVL(l_sub_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )

Line 4578: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND

4574: (l_sub_component_rec.ECO_Name = p_change_notice AND
4575: l_sub_comp_unexp_rec.organization_id = p_organization_id AND
4576: l_sub_component_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
4577: NVL(l_sub_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
4578: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
4579: l_sub_component_rec.revised_item_name = p_revised_item_name AND
4580: NVL(l_sub_component_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND -- Bug 3991176
4581: NVL(l_sub_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
4582: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

Line 4581: NVL(l_sub_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )

4577: NVL(l_sub_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
4578: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
4579: l_sub_component_rec.revised_item_name = p_revised_item_name AND
4580: NVL(l_sub_component_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND -- Bug 3991176
4581: NVL(l_sub_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
4582: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
4583: NVL(l_sub_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
4584: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
4585: l_sub_component_rec.component_item_name = p_component_item_name AND

Line 4582: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

4578: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
4579: l_sub_component_rec.revised_item_name = p_revised_item_name AND
4580: NVL(l_sub_component_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND -- Bug 3991176
4581: NVL(l_sub_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
4582: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
4583: NVL(l_sub_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
4584: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
4585: l_sub_component_rec.component_item_name = p_component_item_name AND
4586: l_sub_component_rec.operation_sequence_number = p_operation_seq_num))

Line 4583: NVL(l_sub_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )

4579: l_sub_component_rec.revised_item_name = p_revised_item_name AND
4580: NVL(l_sub_component_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND -- Bug 3991176
4581: NVL(l_sub_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
4582: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
4583: NVL(l_sub_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
4584: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
4585: l_sub_component_rec.component_item_name = p_component_item_name AND
4586: l_sub_component_rec.operation_sequence_number = p_operation_seq_num))
4587:

Line 4584: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

4580: NVL(l_sub_component_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND -- Bug 3991176
4581: NVL(l_sub_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
4582: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
4583: NVL(l_sub_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
4584: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
4585: l_sub_component_rec.component_item_name = p_component_item_name AND
4586: l_sub_component_rec.operation_sequence_number = p_operation_seq_num))
4587:
4588: OR

Line 4599: NVL(l_sub_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )

4595: l_sub_comp_unexp_rec.organization_id = p_organization_id AND
4596: l_sub_component_rec.revised_item_name = p_revised_item_name AND
4597: NVL(l_sub_component_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND -- Bug 3991176
4598: l_sub_component_rec.start_effective_date = p_effectivity_date AND
4599: NVL(l_sub_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
4600: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
4601: NVL(l_sub_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
4602: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/0
4603: NVL(l_sub_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )

Line 4600: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

4596: l_sub_component_rec.revised_item_name = p_revised_item_name AND
4597: NVL(l_sub_component_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND -- Bug 3991176
4598: l_sub_component_rec.start_effective_date = p_effectivity_date AND
4599: NVL(l_sub_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
4600: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
4601: NVL(l_sub_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
4602: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/0
4603: NVL(l_sub_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
4604: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) ))

Line 4601: NVL(l_sub_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )

4597: NVL(l_sub_component_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND -- Bug 3991176
4598: l_sub_component_rec.start_effective_date = p_effectivity_date AND
4599: NVL(l_sub_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
4600: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
4601: NVL(l_sub_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
4602: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/0
4603: NVL(l_sub_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
4604: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) ))
4605:

Line 4602: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/0

4598: l_sub_component_rec.start_effective_date = p_effectivity_date AND
4599: NVL(l_sub_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
4600: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
4601: NVL(l_sub_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
4602: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/0
4603: NVL(l_sub_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
4604: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) ))
4605:
4606: OR

Line 4603: NVL(l_sub_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )

4599: NVL(l_sub_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
4600: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
4601: NVL(l_sub_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
4602: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/0
4603: NVL(l_sub_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
4604: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) ))
4605:
4606: OR
4607:

Line 4604: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) ))

4600: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
4601: NVL(l_sub_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
4602: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/0
4603: NVL(l_sub_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
4604: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) ))
4605:
4606: OR
4607:
4608: (NOT l_comp_parent_exists AND

Line 4612: l_return_status := FND_API.G_RET_STS_SUCCESS;

4608: (NOT l_comp_parent_exists AND
4609: NOT l_item_parent_exists))
4610: THEN
4611:
4612: l_return_status := FND_API.G_RET_STS_SUCCESS;
4613:
4614: l_sub_component_rec.return_status := FND_API.G_RET_STS_SUCCESS;
4615:
4616: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Processing substitite component: ' || l_sub_component_rec.substitute_component_name); END IF;

Line 4614: l_sub_component_rec.return_status := FND_API.G_RET_STS_SUCCESS;

4610: THEN
4611:
4612: l_return_status := FND_API.G_RET_STS_SUCCESS;
4613:
4614: l_sub_component_rec.return_status := FND_API.G_RET_STS_SUCCESS;
4615:
4616: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Processing substitite component: ' || l_sub_component_rec.substitute_component_name); END IF;
4617:
4618: -- Bug 6657209

Line 5437: x_ref_designator_tbl(I).return_status = FND_API.G_MISS_CHAR) THEN

5433:
5434:
5435: FOR I IN 1..x_ref_designator_tbl.COUNT LOOP
5436: IF (x_ref_designator_tbl(I).return_status IS NULL OR
5437: x_ref_designator_tbl(I).return_status = FND_API.G_MISS_CHAR) THEN
5438:
5439: BEGIN
5440:
5441: -- Load local records.

Line 5490: --l_ref_designator_rec.return_status = FND_API.G_MISS_CHAR)

5486: ' Rev Comp: ' || p_component_item_name ||
5487: ' Op. Seq : ' || p_operation_seq_num); END IF;
5488:
5489: IF --(l_ref_designator_rec.return_status IS NULL OR
5490: --l_ref_designator_rec.return_status = FND_API.G_MISS_CHAR)
5491: --AND
5492:
5493: -- Did Rev_Comps call this procedure, that is,
5494: -- if revised comp exists, then is this record a child ?

Line 5500: NVL(l_ref_designator_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )

5496: ((l_comp_parent_exists AND
5497: (l_ref_designator_rec.ECO_Name = p_change_notice AND
5498: l_ref_desg_unexp_rec.organization_id = p_organization_id AND
5499: l_ref_designator_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- bug 6657209
5500: NVL(l_ref_designator_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
5501: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
5502: NVL(l_ref_designator_rec.new_routing_revision, FND_API.G_MISS_CHAR )
5503: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
5504: NVL(l_ref_designator_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )

Line 5501: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND

5497: (l_ref_designator_rec.ECO_Name = p_change_notice AND
5498: l_ref_desg_unexp_rec.organization_id = p_organization_id AND
5499: l_ref_designator_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- bug 6657209
5500: NVL(l_ref_designator_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
5501: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
5502: NVL(l_ref_designator_rec.new_routing_revision, FND_API.G_MISS_CHAR )
5503: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
5504: NVL(l_ref_designator_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
5505: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

Line 5502: NVL(l_ref_designator_rec.new_routing_revision, FND_API.G_MISS_CHAR )

5498: l_ref_desg_unexp_rec.organization_id = p_organization_id AND
5499: l_ref_designator_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- bug 6657209
5500: NVL(l_ref_designator_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
5501: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
5502: NVL(l_ref_designator_rec.new_routing_revision, FND_API.G_MISS_CHAR )
5503: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
5504: NVL(l_ref_designator_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
5505: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
5506: l_ref_designator_rec.revised_item_name = p_revised_item_name AND

Line 5503: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

5499: l_ref_designator_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- bug 6657209
5500: NVL(l_ref_designator_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
5501: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
5502: NVL(l_ref_designator_rec.new_routing_revision, FND_API.G_MISS_CHAR )
5503: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
5504: NVL(l_ref_designator_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
5505: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
5506: l_ref_designator_rec.revised_item_name = p_revised_item_name AND
5507: NVL(l_ref_designator_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND -- Bug 3991176

Line 5504: NVL(l_ref_designator_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )

5500: NVL(l_ref_designator_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
5501: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
5502: NVL(l_ref_designator_rec.new_routing_revision, FND_API.G_MISS_CHAR )
5503: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
5504: NVL(l_ref_designator_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
5505: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
5506: l_ref_designator_rec.revised_item_name = p_revised_item_name AND
5507: NVL(l_ref_designator_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND -- Bug 3991176
5508: l_ref_designator_rec.component_item_name = p_component_item_name AND

Line 5505: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

5501: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
5502: NVL(l_ref_designator_rec.new_routing_revision, FND_API.G_MISS_CHAR )
5503: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
5504: NVL(l_ref_designator_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
5505: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
5506: l_ref_designator_rec.revised_item_name = p_revised_item_name AND
5507: NVL(l_ref_designator_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND -- Bug 3991176
5508: l_ref_designator_rec.component_item_name = p_component_item_name AND
5509: l_ref_designator_rec.operation_sequence_number = p_operation_seq_num))

Line 5522: NVL(l_ref_designator_rec.new_routing_revision, FND_API.G_MISS_CHAR )

5518: l_ref_desg_unexp_rec.organization_id = p_organization_id AND
5519: l_ref_designator_rec.revised_item_name = p_revised_item_name AND
5520: NVL(l_ref_designator_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND -- Bug 3991176
5521: l_ref_designator_rec.start_effective_date = p_effectivity_date AND
5522: NVL(l_ref_designator_rec.new_routing_revision, FND_API.G_MISS_CHAR )
5523: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
5524: NVL(l_ref_designator_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
5525: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
5526: NVL(l_ref_designator_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )

Line 5523: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

5519: l_ref_designator_rec.revised_item_name = p_revised_item_name AND
5520: NVL(l_ref_designator_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND -- Bug 3991176
5521: l_ref_designator_rec.start_effective_date = p_effectivity_date AND
5522: NVL(l_ref_designator_rec.new_routing_revision, FND_API.G_MISS_CHAR )
5523: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
5524: NVL(l_ref_designator_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
5525: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
5526: NVL(l_ref_designator_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
5527: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) ))

Line 5524: NVL(l_ref_designator_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )

5520: NVL(l_ref_designator_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND -- Bug 3991176
5521: l_ref_designator_rec.start_effective_date = p_effectivity_date AND
5522: NVL(l_ref_designator_rec.new_routing_revision, FND_API.G_MISS_CHAR )
5523: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
5524: NVL(l_ref_designator_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
5525: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
5526: NVL(l_ref_designator_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
5527: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) ))
5528:

Line 5525: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

5521: l_ref_designator_rec.start_effective_date = p_effectivity_date AND
5522: NVL(l_ref_designator_rec.new_routing_revision, FND_API.G_MISS_CHAR )
5523: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
5524: NVL(l_ref_designator_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
5525: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
5526: NVL(l_ref_designator_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
5527: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) ))
5528:
5529: OR

Line 5526: NVL(l_ref_designator_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )

5522: NVL(l_ref_designator_rec.new_routing_revision, FND_API.G_MISS_CHAR )
5523: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
5524: NVL(l_ref_designator_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
5525: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
5526: NVL(l_ref_designator_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
5527: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) ))
5528:
5529: OR
5530:

Line 5527: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) ))

5523: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
5524: NVL(l_ref_designator_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
5525: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
5526: NVL(l_ref_designator_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
5527: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) ))
5528:
5529: OR
5530:
5531: (NOT l_item_parent_exists AND

Line 5535: l_return_status := FND_API.G_RET_STS_SUCCESS;

5531: (NOT l_item_parent_exists AND
5532: NOT l_comp_parent_exists))
5533: THEN
5534:
5535: l_return_status := FND_API.G_RET_STS_SUCCESS;
5536:
5537: l_ref_designator_rec.return_status := FND_API.G_RET_STS_SUCCESS;
5538:
5539: -- Bug 6657209

Line 5537: l_ref_designator_rec.return_status := FND_API.G_RET_STS_SUCCESS;

5533: THEN
5534:
5535: l_return_status := FND_API.G_RET_STS_SUCCESS;
5536:
5537: l_ref_designator_rec.return_status := FND_API.G_RET_STS_SUCCESS;
5538:
5539: -- Bug 6657209
5540: IF (l_comp_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null) THEN
5541: l_ref_designator_rec.start_effective_date := p_effectivity_date;

Line 6252: l_return_status := FND_API.G_RET_STS_SUCCESS;

6248: EXC_UNEXP_SKIP_OBJECT EXCEPTION;
6249:
6250: BEGIN
6251:
6252: l_return_status := FND_API.G_RET_STS_SUCCESS;
6253: l_bo_return_status := FND_API.G_RET_STS_SUCCESS;
6254: x_return_status := FND_API.G_RET_STS_SUCCESS;
6255: x_ref_designator_tbl := p_ref_designator_tbl;
6256: x_sub_component_tbl := p_sub_component_tbl;

Line 6253: l_bo_return_status := FND_API.G_RET_STS_SUCCESS;

6249:
6250: BEGIN
6251:
6252: l_return_status := FND_API.G_RET_STS_SUCCESS;
6253: l_bo_return_status := FND_API.G_RET_STS_SUCCESS;
6254: x_return_status := FND_API.G_RET_STS_SUCCESS;
6255: x_ref_designator_tbl := p_ref_designator_tbl;
6256: x_sub_component_tbl := p_sub_component_tbl;
6257: l_rev_comp_unexp_rec.organization_id := ENG_GLOBALS.Get_org_id;

Line 6254: x_return_status := FND_API.G_RET_STS_SUCCESS;

6250: BEGIN
6251:
6252: l_return_status := FND_API.G_RET_STS_SUCCESS;
6253: l_bo_return_status := FND_API.G_RET_STS_SUCCESS;
6254: x_return_status := FND_API.G_RET_STS_SUCCESS;
6255: x_ref_designator_tbl := p_ref_designator_tbl;
6256: x_sub_component_tbl := p_sub_component_tbl;
6257: l_rev_comp_unexp_rec.organization_id := ENG_GLOBALS.Get_org_id;
6258:

Line 6316: --l_rev_component_rec.return_status = FND_API.G_MISS_CHAR)

6312: -- that it is the child of the parent that called this procedure
6313: --
6314:
6315: IF --(l_rev_component_rec.return_status IS NULL OR
6316: --l_rev_component_rec.return_status = FND_API.G_MISS_CHAR)
6317: --AND
6318:
6319: -- Did Rev_Items call this procedure, that is,
6320: -- if revised item exists, then is this record a child ?

Line 6331: NVL(l_rev_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )

6327: l_rev_component_rec.revised_item_name = p_revised_item_name AND
6328: NVL(l_rev_component_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND
6329: -- Bug 2429272 Change 4
6330: l_rev_component_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
6331: NVL(l_rev_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
6332: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
6333: NVL(l_rev_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
6334: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
6335: NVL(l_rev_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )

Line 6332: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

6328: NVL(l_rev_component_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND
6329: -- Bug 2429272 Change 4
6330: l_rev_component_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
6331: NVL(l_rev_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
6332: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
6333: NVL(l_rev_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
6334: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
6335: NVL(l_rev_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
6336: = NVL(p_item_revision, FND_API.G_MISS_CHAR) )))

Line 6333: NVL(l_rev_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )

6329: -- Bug 2429272 Change 4
6330: l_rev_component_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
6331: NVL(l_rev_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
6332: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
6333: NVL(l_rev_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
6334: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
6335: NVL(l_rev_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
6336: = NVL(p_item_revision, FND_API.G_MISS_CHAR) )))
6337:

Line 6334: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

6330: l_rev_component_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
6331: NVL(l_rev_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
6332: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
6333: NVL(l_rev_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
6334: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
6335: NVL(l_rev_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
6336: = NVL(p_item_revision, FND_API.G_MISS_CHAR) )))
6337:
6338: THEN

Line 6335: NVL(l_rev_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )

6331: NVL(l_rev_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
6332: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
6333: NVL(l_rev_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
6334: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
6335: NVL(l_rev_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
6336: = NVL(p_item_revision, FND_API.G_MISS_CHAR) )))
6337:
6338: THEN
6339:

Line 6336: = NVL(p_item_revision, FND_API.G_MISS_CHAR) )))

6332: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
6333: NVL(l_rev_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
6334: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
6335: NVL(l_rev_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
6336: = NVL(p_item_revision, FND_API.G_MISS_CHAR) )))
6337:
6338: THEN
6339:
6340: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6340: l_return_status := FND_API.G_RET_STS_SUCCESS;

6336: = NVL(p_item_revision, FND_API.G_MISS_CHAR) )))
6337:
6338: THEN
6339:
6340: l_return_status := FND_API.G_RET_STS_SUCCESS;
6341:
6342: l_rev_component_rec.return_status := FND_API.G_RET_STS_SUCCESS;
6343:
6344: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Processing component: ' || l_rev_component_rec.component_item_name); END IF;

Line 6342: l_rev_component_rec.return_status := FND_API.G_RET_STS_SUCCESS;

6338: THEN
6339:
6340: l_return_status := FND_API.G_RET_STS_SUCCESS;
6341:
6342: l_rev_component_rec.return_status := FND_API.G_RET_STS_SUCCESS;
6343:
6344: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Processing component: ' || l_rev_component_rec.component_item_name); END IF;
6345: -- Check if transaction_type is valid
6346: --

Line 7158: , p_error_status => FND_API.G_RET_STS_ERROR

7154: ( p_rev_component_tbl => x_rev_component_tbl
7155: , p_ref_designator_tbl => x_ref_designator_tbl
7156: , p_sub_component_tbl => x_sub_component_tbl
7157: , p_mesg_token_tbl => l_mesg_token_tbl
7158: , p_error_status => FND_API.G_RET_STS_ERROR
7159: , p_error_scope => Error_Handler.G_SCOPE_RECORD
7160: , p_error_level => 4
7161: , p_entity_index => I
7162: , x_eco_rec => l_eco_rec

Line 7482: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

7478: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
7479: , x_return_status => l_return_status
7480: );
7481:
7482: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
7483: THEN
7484: l_bo_return_status := l_return_status;
7485: END IF;
7486:

Line 7513: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

7509: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
7510: , x_return_status => l_return_status
7511: );
7512:
7513: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
7514: THEN
7515: l_bo_return_status := l_return_status;
7516: END IF;
7517:

Line 7594: l_return_status := FND_API.G_RET_STS_SUCCESS;

7590: BEGIN
7591:
7592: -- Init local table variables.
7593:
7594: l_return_status := FND_API.G_RET_STS_SUCCESS;
7595: l_bo_return_status := FND_API.G_RET_STS_SUCCESS;
7596:
7597: x_return_status := FND_API.G_RET_STS_SUCCESS;
7598:

Line 7595: l_bo_return_status := FND_API.G_RET_STS_SUCCESS;

7591:
7592: -- Init local table variables.
7593:
7594: l_return_status := FND_API.G_RET_STS_SUCCESS;
7595: l_bo_return_status := FND_API.G_RET_STS_SUCCESS;
7596:
7597: x_return_status := FND_API.G_RET_STS_SUCCESS;
7598:
7599: --l_rev_component_tbl := p_rev_component_tbl;

Line 7597: x_return_status := FND_API.G_RET_STS_SUCCESS;

7593:
7594: l_return_status := FND_API.G_RET_STS_SUCCESS;
7595: l_bo_return_status := FND_API.G_RET_STS_SUCCESS;
7596:
7597: x_return_status := FND_API.G_RET_STS_SUCCESS;
7598:
7599: --l_rev_component_tbl := p_rev_component_tbl;
7600: x_rev_component_tbl := p_rev_component_tbl;
7601: x_ref_designator_tbl := p_ref_designator_tbl;

Line 7608: x_rev_component_tbl(I).return_status = FND_API.G_MISS_CHAR) THEN

7604: l_rev_comp_unexp_rec.organization_id := ENG_GLOBALS.Get_org_id;
7605:
7606: FOR I IN 1..x_rev_component_tbl.COUNT LOOP
7607: IF (x_rev_component_tbl(I).return_status IS NULL OR
7608: x_rev_component_tbl(I).return_status = FND_API.G_MISS_CHAR) THEN
7609:
7610: BEGIN
7611:
7612: --

Line 7667: --l_rev_component_rec.return_status = FND_API.G_MISS_CHAR)

7663: -- that it is the child of the parent that called this procedure
7664: --
7665:
7666: IF --(l_rev_component_rec.return_status IS NULL OR
7667: --l_rev_component_rec.return_status = FND_API.G_MISS_CHAR)
7668: --AND
7669:
7670: -- Did Rev_Items call this procedure, that is,
7671: -- if revised item exists, then is this record a child ?

Line 7682: NVL(l_rev_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )

7678: l_rev_component_rec.revised_item_name = p_revised_item_name AND
7679: NVL(l_rev_component_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND
7680: -- Bug 2429272 Change 4
7681: l_rev_component_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
7682: NVL(l_rev_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
7683: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
7684: NVL(l_rev_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
7685: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
7686: NVL(l_rev_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )

Line 7683: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

7679: NVL(l_rev_component_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND
7680: -- Bug 2429272 Change 4
7681: l_rev_component_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
7682: NVL(l_rev_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
7683: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
7684: NVL(l_rev_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
7685: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
7686: NVL(l_rev_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
7687: = NVL(p_item_revision, FND_API.G_MISS_CHAR) )))

Line 7684: NVL(l_rev_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )

7680: -- Bug 2429272 Change 4
7681: l_rev_component_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
7682: NVL(l_rev_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
7683: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
7684: NVL(l_rev_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
7685: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
7686: NVL(l_rev_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
7687: = NVL(p_item_revision, FND_API.G_MISS_CHAR) )))
7688:

Line 7685: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

7681: l_rev_component_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
7682: NVL(l_rev_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
7683: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
7684: NVL(l_rev_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
7685: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
7686: NVL(l_rev_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
7687: = NVL(p_item_revision, FND_API.G_MISS_CHAR) )))
7688:
7689: THEN

Line 7686: NVL(l_rev_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )

7682: NVL(l_rev_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
7683: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
7684: NVL(l_rev_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
7685: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
7686: NVL(l_rev_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
7687: = NVL(p_item_revision, FND_API.G_MISS_CHAR) )))
7688:
7689: THEN
7690:

Line 7687: = NVL(p_item_revision, FND_API.G_MISS_CHAR) )))

7683: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
7684: NVL(l_rev_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
7685: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
7686: NVL(l_rev_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
7687: = NVL(p_item_revision, FND_API.G_MISS_CHAR) )))
7688:
7689: THEN
7690:
7691: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7691: l_return_status := FND_API.G_RET_STS_SUCCESS;

7687: = NVL(p_item_revision, FND_API.G_MISS_CHAR) )))
7688:
7689: THEN
7690:
7691: l_return_status := FND_API.G_RET_STS_SUCCESS;
7692:
7693: l_rev_component_rec.return_status := FND_API.G_RET_STS_SUCCESS;
7694:
7695: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Processing component: ' || l_rev_component_rec.component_item_name); END IF;

Line 7693: l_rev_component_rec.return_status := FND_API.G_RET_STS_SUCCESS;

7689: THEN
7690:
7691: l_return_status := FND_API.G_RET_STS_SUCCESS;
7692:
7693: l_rev_component_rec.return_status := FND_API.G_RET_STS_SUCCESS;
7694:
7695: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Processing component: ' || l_rev_component_rec.component_item_name); END IF;
7696: -- Check if transaction_type is valid
7697: --

Line 8507: , p_error_status => FND_API.G_RET_STS_ERROR

8503: ( p_rev_component_tbl => x_rev_component_tbl
8504: , p_ref_designator_tbl => x_ref_designator_tbl
8505: , p_sub_component_tbl => x_sub_component_tbl
8506: , p_mesg_token_tbl => l_mesg_token_tbl
8507: , p_error_status => FND_API.G_RET_STS_ERROR
8508: , p_error_scope => Error_Handler.G_SCOPE_RECORD
8509: , p_error_level => 4
8510: , p_entity_index => I
8511: , x_eco_rec => l_eco_rec

Line 8822: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

8818: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
8819: , x_return_status => l_return_status
8820: );
8821:
8822: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
8823: THEN
8824: l_bo_return_status := l_return_status;
8825: END IF;
8826:

Line 8853: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

8849: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
8850: , x_return_status => l_return_status
8851: );
8852:
8853: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
8854: THEN
8855: l_bo_return_status := l_return_status;
8856: END IF;
8857:

Line 8954: l_return_status := FND_API.G_RET_STS_SUCCESS;

8950:
8951: -- End Changes
8952:
8953: BEGIN
8954: l_return_status := FND_API.G_RET_STS_SUCCESS;
8955: l_bo_return_status := FND_API.G_RET_STS_SUCCESS;
8956: x_return_status := FND_API.G_RET_STS_SUCCESS;
8957:
8958: x_rev_component_tbl := p_rev_component_tbl;

Line 8955: l_bo_return_status := FND_API.G_RET_STS_SUCCESS;

8951: -- End Changes
8952:
8953: BEGIN
8954: l_return_status := FND_API.G_RET_STS_SUCCESS;
8955: l_bo_return_status := FND_API.G_RET_STS_SUCCESS;
8956: x_return_status := FND_API.G_RET_STS_SUCCESS;
8957:
8958: x_rev_component_tbl := p_rev_component_tbl;
8959: x_ref_designator_tbl := p_ref_designator_tbl;

Line 8956: x_return_status := FND_API.G_RET_STS_SUCCESS;

8952:
8953: BEGIN
8954: l_return_status := FND_API.G_RET_STS_SUCCESS;
8955: l_bo_return_status := FND_API.G_RET_STS_SUCCESS;
8956: x_return_status := FND_API.G_RET_STS_SUCCESS;
8957:
8958: x_rev_component_tbl := p_rev_component_tbl;
8959: x_ref_designator_tbl := p_ref_designator_tbl;
8960: x_sub_component_tbl := p_sub_component_tbl;

Line 9000: --l_revised_item_rec.return_status = FND_API.G_MISS_CHAR)

8996:
8997: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Processing Revised Item . . . ' || l_revised_item_rec.revised_item_name); END IF;
8998:
8999: IF --(l_revised_item_rec.return_status IS NULL OR
9000: --l_revised_item_rec.return_status = FND_API.G_MISS_CHAR)
9001: --AND
9002: (NOT l_eco_parent_exists
9003: OR
9004: (l_eco_parent_exists AND

Line 9009: l_return_status := FND_API.G_RET_STS_SUCCESS;

9005: (l_revised_item_rec.ECO_Name = p_change_notice AND
9006: l_rev_item_unexp_rec.organization_id = p_organization_id)))
9007: THEN
9008:
9009: l_return_status := FND_API.G_RET_STS_SUCCESS;
9010:
9011: l_revised_item_rec.return_status := FND_API.G_RET_STS_SUCCESS;
9012:
9013: -- Check if transaction_type is valid

Line 9011: l_revised_item_rec.return_status := FND_API.G_RET_STS_SUCCESS;

9007: THEN
9008:
9009: l_return_status := FND_API.G_RET_STS_SUCCESS;
9010:
9011: l_revised_item_rec.return_status := FND_API.G_RET_STS_SUCCESS;
9012:
9013: -- Check if transaction_type is valid
9014: --
9015:

Line 9758: , p_error_status => FND_API.G_RET_STS_ERROR

9754: , p_rev_operation_tbl => x_rev_operation_tbl --L1
9755: , p_rev_op_resource_tbl => x_rev_op_resource_tbl --L1
9756: , p_rev_sub_resource_tbl => x_rev_sub_resource_tbl --L1
9757: , p_mesg_token_tbl => l_mesg_token_tbl
9758: , p_error_status => FND_API.G_RET_STS_ERROR
9759: , p_error_scope => Error_Handler.G_SCOPE_RECORD
9760: , p_error_level => 3
9761: , p_entity_index => I
9762: , x_eco_rec => l_eco_rec

Line 10130: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

10126: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
10127: , x_return_status => l_return_status
10128: );
10129:
10130: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
10131: THEN
10132: l_bo_return_status := l_return_status;
10133: END IF;
10134:

Line 10161: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

10157: , x_rev_sub_resource_tbl => x_rev_sub_resource_tbl
10158: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
10159: , x_return_status => l_return_status
10160: );
10161: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
10162: THEN
10163: l_bo_return_status := l_return_status;
10164: END IF;
10165:

Line 10188: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

10184: , x_rev_sub_resource_tbl => x_rev_sub_resource_tbl
10185: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
10186: , x_return_status => l_return_status
10187: );
10188: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
10189: THEN
10190: l_bo_return_status := l_return_status;
10191: END IF;
10192:

Line 10228: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

10224: );
10225:
10226: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Rev_Comps return status ' || l_return_status); END IF;
10227:
10228: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
10229: THEN
10230:
10231: IF Bom_Globals.Get_Debug = 'Y' THEN
10232: Error_Handler.Write_Debug('Rev_Comps returned in Rev_Items . . .BO Status: ' || l_return_status);

Line 10270: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

10266: -- Process Substitute Components that are orphans
10267: -- (without immediate revised component parents) but are
10268: -- indirect children of this item
10269:
10270: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
10271: THEN
10272: l_bo_return_status := l_return_status;
10273: END IF;
10274:

Line 10296: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

10292: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
10293: , x_return_status => l_return_status
10294: );
10295:
10296: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
10297: THEN
10298: l_bo_return_status := l_return_status;
10299: END IF;
10300:

Line 10385: l_return_status := FND_API.G_RET_STS_SUCCESS;

10381: BEGIN
10382:
10383: -- Init local table variables.
10384:
10385: l_return_status := FND_API.G_RET_STS_SUCCESS;
10386: l_bo_return_status := FND_API.G_RET_STS_SUCCESS;
10387: x_return_status := FND_API.G_RET_STS_SUCCESS;
10388:
10389: x_revised_item_tbl := p_revised_item_tbl;

Line 10386: l_bo_return_status := FND_API.G_RET_STS_SUCCESS;

10382:
10383: -- Init local table variables.
10384:
10385: l_return_status := FND_API.G_RET_STS_SUCCESS;
10386: l_bo_return_status := FND_API.G_RET_STS_SUCCESS;
10387: x_return_status := FND_API.G_RET_STS_SUCCESS;
10388:
10389: x_revised_item_tbl := p_revised_item_tbl;
10390: x_rev_component_tbl := p_rev_component_tbl;

Line 10387: x_return_status := FND_API.G_RET_STS_SUCCESS;

10383: -- Init local table variables.
10384:
10385: l_return_status := FND_API.G_RET_STS_SUCCESS;
10386: l_bo_return_status := FND_API.G_RET_STS_SUCCESS;
10387: x_return_status := FND_API.G_RET_STS_SUCCESS;
10388:
10389: x_revised_item_tbl := p_revised_item_tbl;
10390: x_rev_component_tbl := p_rev_component_tbl;
10391: x_ref_designator_tbl := p_ref_designator_tbl;

Line 10401: x_revised_item_tbl(I).return_status = FND_API.G_MISS_CHAR) THEN

10397: -- l_Rev_Item_Unexp_Rec.organization_id := ENG_GLOBALS.Get_org_id;
10398:
10399: FOR I IN 1..x_revised_item_tbl.COUNT LOOP
10400: IF (x_revised_item_tbl(I).return_status IS NULL OR
10401: x_revised_item_tbl(I).return_status = FND_API.G_MISS_CHAR) THEN
10402:
10403: BEGIN
10404:
10405: -- Load local records.

Line 10440: --l_revised_item_rec.return_status = FND_API.G_MISS_CHAR)

10436:
10437: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Processing Revised Item . . . ' || l_revised_item_rec.revised_item_name); END IF;
10438:
10439: IF --(l_revised_item_rec.return_status IS NULL OR
10440: --l_revised_item_rec.return_status = FND_API.G_MISS_CHAR)
10441: --AND
10442: (NOT l_eco_parent_exists
10443: OR
10444: (l_eco_parent_exists AND

Line 10449: l_return_status := FND_API.G_RET_STS_SUCCESS;

10445: (l_revised_item_rec.ECO_Name = p_change_notice AND
10446: l_rev_item_unexp_rec.organization_id = p_organization_id)))
10447: THEN
10448:
10449: l_return_status := FND_API.G_RET_STS_SUCCESS;
10450:
10451: l_revised_item_rec.return_status := FND_API.G_RET_STS_SUCCESS;
10452:
10453: -- Check if transaction_type is valid

Line 10451: l_revised_item_rec.return_status := FND_API.G_RET_STS_SUCCESS;

10447: THEN
10448:
10449: l_return_status := FND_API.G_RET_STS_SUCCESS;
10450:
10451: l_revised_item_rec.return_status := FND_API.G_RET_STS_SUCCESS;
10452:
10453: -- Check if transaction_type is valid
10454: --
10455:

Line 11211: AND NVL(x_rev_component_tbl(rev_comp_index).new_revised_item_revision, FND_API.G_MISS_CHAR) = NVL(x_revised_item_tbl(I).new_revised_item_revision, FND_API.G_MISS_CHAR) -- Bug: 13451729

11207: FOR rev_comp_index IN 1..x_rev_component_tbl.COUNT LOOP
11208: IF (x_rev_component_tbl(rev_comp_index).eco_name = x_revised_item_tbl(I).eco_name
11209: AND x_rev_component_tbl(rev_comp_index).organization_code = x_revised_item_tbl(I).organization_code
11210: AND x_rev_component_tbl(rev_comp_index).revised_item_name = x_revised_item_tbl(I).revised_item_name
11211: AND NVL(x_rev_component_tbl(rev_comp_index).new_revised_item_revision, FND_API.G_MISS_CHAR) = NVL(x_revised_item_tbl(I).new_revised_item_revision, FND_API.G_MISS_CHAR) -- Bug: 13451729
11212: AND (x_rev_component_tbl(rev_comp_index).component_item_name is not NULL
11213: or x_rev_component_tbl(rev_comp_index).component_item_name <> FND_API.G_MISS_CHAR)
11214: ) THEN
11215: l_rev_comp_flag := 'Y';

Line 11213: or x_rev_component_tbl(rev_comp_index).component_item_name <> FND_API.G_MISS_CHAR)

11209: AND x_rev_component_tbl(rev_comp_index).organization_code = x_revised_item_tbl(I).organization_code
11210: AND x_rev_component_tbl(rev_comp_index).revised_item_name = x_revised_item_tbl(I).revised_item_name
11211: AND NVL(x_rev_component_tbl(rev_comp_index).new_revised_item_revision, FND_API.G_MISS_CHAR) = NVL(x_revised_item_tbl(I).new_revised_item_revision, FND_API.G_MISS_CHAR) -- Bug: 13451729
11212: AND (x_rev_component_tbl(rev_comp_index).component_item_name is not NULL
11213: or x_rev_component_tbl(rev_comp_index).component_item_name <> FND_API.G_MISS_CHAR)
11214: ) THEN
11215: l_rev_comp_flag := 'Y';
11216: EXIT;
11217: END IF;

Line 11310: , p_error_status => FND_API.G_RET_STS_ERROR

11306: , p_rev_operation_tbl => x_rev_operation_tbl --L1
11307: , p_rev_op_resource_tbl => x_rev_op_resource_tbl --L1
11308: , p_rev_sub_resource_tbl => x_rev_sub_resource_tbl --L1
11309: , p_mesg_token_tbl => l_mesg_token_tbl
11310: , p_error_status => FND_API.G_RET_STS_ERROR
11311: , p_error_scope => Error_Handler.G_SCOPE_RECORD
11312: , p_error_level => 3
11313: , p_entity_index => I
11314: , x_eco_rec => l_eco_rec

Line 11682: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

11678: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
11679: , x_return_status => l_return_status
11680: );
11681:
11682: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
11683: THEN
11684: l_bo_return_status := l_return_status;
11685: END IF;
11686:

Line 11713: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

11709: , x_rev_sub_resource_tbl => x_rev_sub_resource_tbl
11710: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
11711: , x_return_status => l_return_status
11712: );
11713: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
11714: THEN
11715: l_bo_return_status := l_return_status;
11716: END IF;
11717:

Line 11740: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

11736: , x_rev_sub_resource_tbl => x_rev_sub_resource_tbl
11737: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
11738: , x_return_status => l_return_status
11739: );
11740: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
11741: THEN
11742: l_bo_return_status := l_return_status;
11743: END IF;
11744:

Line 11780: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

11776: );
11777:
11778: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Rev_Comps return status ' || l_return_status); END IF;
11779:
11780: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
11781: THEN
11782:
11783: IF Bom_Globals.Get_Debug = 'Y' THEN
11784: Error_Handler.Write_Debug('Rev_Comps returned in Rev_Items . . .BO Status: ' || l_return_status);

Line 11822: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

11818: -- Process Substitute Components that are orphans
11819: -- (without immediate revised component parents) but are
11820: -- indirect children of this item
11821:
11822: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
11823: THEN
11824: l_bo_return_status := l_return_status;
11825: END IF;
11826:

Line 11848: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

11844: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
11845: , x_return_status => l_return_status
11846: );
11847:
11848: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
11849: THEN
11850: l_bo_return_status := l_return_status;
11851: END IF;
11852:

Line 11954: l_return_status := FND_API.G_RET_STS_SUCCESS ;

11950: BEGIN
11951:
11952:
11953: -- Init local table variables.
11954: l_return_status := FND_API.G_RET_STS_SUCCESS ;
11955: l_bo_return_status := FND_API.G_RET_STS_SUCCESS ;
11956: --l_change_line_tbl := p_change_line_tbl ;
11957: x_change_line_tbl := p_change_line_tbl;
11958: x_revised_item_tbl := p_revised_item_tbl;

Line 11955: l_bo_return_status := FND_API.G_RET_STS_SUCCESS ;

11951:
11952:
11953: -- Init local table variables.
11954: l_return_status := FND_API.G_RET_STS_SUCCESS ;
11955: l_bo_return_status := FND_API.G_RET_STS_SUCCESS ;
11956: --l_change_line_tbl := p_change_line_tbl ;
11957: x_change_line_tbl := p_change_line_tbl;
11958: x_revised_item_tbl := p_revised_item_tbl;
11959: x_rev_component_tbl := p_rev_component_tbl;

Line 11974: x_change_line_tbl(I).return_status = FND_API.G_MISS_CHAR)

11970: -- Process Flow Step 2: Check if record has not yet been processed and
11971: -- that it is the child of the parent that called this procedure
11972: --
11973: IF (x_change_line_tbl(I).return_status IS NULL OR
11974: x_change_line_tbl(I).return_status = FND_API.G_MISS_CHAR)
11975: THEN
11976:
11977: BEGIN
11978:

Line 12021: --l_change_line_rec.return_status = FND_API.G_MISS_CHAR)

12017:
12018: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Processing Change Line . . . ' || l_change_line_rec.name); END IF;
12019:
12020: --IF (l_change_line_rec.return_status IS NULL OR
12021: --l_change_line_rec.return_status = FND_API.G_MISS_CHAR)
12022: --THEN
12023:
12024: l_return_status := FND_API.G_RET_STS_SUCCESS;
12025: l_change_line_rec.return_status := FND_API.G_RET_STS_SUCCESS;

Line 12024: l_return_status := FND_API.G_RET_STS_SUCCESS;

12020: --IF (l_change_line_rec.return_status IS NULL OR
12021: --l_change_line_rec.return_status = FND_API.G_MISS_CHAR)
12022: --THEN
12023:
12024: l_return_status := FND_API.G_RET_STS_SUCCESS;
12025: l_change_line_rec.return_status := FND_API.G_RET_STS_SUCCESS;
12026:
12027: -- Check if transaction_type is valid
12028: --

Line 12025: l_change_line_rec.return_status := FND_API.G_RET_STS_SUCCESS;

12021: --l_change_line_rec.return_status = FND_API.G_MISS_CHAR)
12022: --THEN
12023:
12024: l_return_status := FND_API.G_RET_STS_SUCCESS;
12025: l_change_line_rec.return_status := FND_API.G_RET_STS_SUCCESS;
12026:
12027: -- Check if transaction_type is valid
12028: --
12029:

Line 12829: , p_error_status => FND_API.G_RET_STS_ERROR

12825: , p_rev_operation_tbl => x_rev_operation_tbl --L1
12826: , p_rev_op_resource_tbl => x_rev_op_resource_tbl --L1
12827: , p_rev_sub_resource_tbl=> x_rev_sub_resource_tbl --L1
12828: , p_mesg_token_tbl => l_mesg_token_tbl
12829: , p_error_status => FND_API.G_RET_STS_ERROR
12830: , p_error_scope => Error_Handler.G_SCOPE_RECORD
12831: , p_error_level => ECO_Error_Handler.G_CL_LEVEL
12832: , p_entity_index => I
12833: , x_ECO_rec => l_ECO_rec

Line 13178: x_eco_revision_tbl(I).return_status = FND_API.G_MISS_CHAR) THEN

13174: l_eco_rev_unexp_rec.organization_id := ENG_GLOBALS.Get_org_id;
13175:
13176: FOR I IN 1..x_eco_revision_tbl.COUNT LOOP
13177: IF (x_eco_revision_tbl(I).return_status IS NULL OR
13178: x_eco_revision_tbl(I).return_status = FND_API.G_MISS_CHAR) THEN
13179:
13180: BEGIN
13181:
13182: -- Load local records.

Line 13200: --l_eco_revision_rec.return_status = FND_API.G_MISS_CHAR)

13196: -- that it is the child of the parent that called this procedure
13197: --
13198:
13199: IF --(l_eco_revision_rec.return_status IS NULL OR
13200: --l_eco_revision_rec.return_status = FND_API.G_MISS_CHAR)
13201: --AND
13202: (NOT l_eco_parent_exists
13203: OR
13204: (l_eco_parent_exists AND

Line 13209: l_return_status := FND_API.G_RET_STS_SUCCESS;

13205: (l_eco_revision_rec.ECO_Name = p_change_notice AND
13206: l_eco_rev_unexp_rec.organization_id = p_organization_id)))
13207: THEN
13208:
13209: l_return_status := FND_API.G_RET_STS_SUCCESS;
13210:
13211: l_eco_revision_rec.return_status := FND_API.G_RET_STS_SUCCESS;
13212:
13213: -- Check if transaction_type is valid

Line 13211: l_eco_revision_rec.return_status := FND_API.G_RET_STS_SUCCESS;

13207: THEN
13208:
13209: l_return_status := FND_API.G_RET_STS_SUCCESS;
13210:
13211: l_eco_revision_rec.return_status := FND_API.G_RET_STS_SUCCESS;
13212:
13213: -- Check if transaction_type is valid
13214: --
13215:

Line 13590: , p_error_status => FND_API.G_RET_STS_ERROR

13586: , p_rev_operation_tbl => x_rev_operation_tbl --L1
13587: , p_rev_op_resource_tbl => x_rev_op_resource_tbl --L1
13588: , p_rev_sub_resource_tbl => x_rev_sub_resource_tbl --L1
13589: , p_mesg_token_tbl => l_mesg_token_tbl
13590: , p_error_status => FND_API.G_RET_STS_ERROR
13591: , p_error_scope => Error_Handler.G_SCOPE_RECORD
13592: , p_error_level => 2
13593: , p_entity_index => I
13594: , x_eco_rec => l_eco_rec

Line 13983: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

13979: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type;
13980: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
13981: l_dest_change_id NUMBER;
13982: l_msg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
13983: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
13984: l_sql_stmt VARCHAR2(1000);
13985:
13986: BEGIN
13987:

Line 14145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

14141: ) ;
14142: END IF ;
14143:
14144: -- Return the status and message table.
14145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
14146: x_mesg_token_tbl := l_mesg_token_tbl ;
14147:
14148: end Create_Relation;
14149:

Line 14195: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

14191: l_other_token_tbl Error_Handler.Token_Tbl_Type;
14192: l_other_message VARCHAR2(50);
14193: l_err_text VARCHAR2(2000);
14194: l_valid BOOLEAN := TRUE;
14195: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
14196: l_bo_return_status VARCHAR2(1) := 'S';
14197: l_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type;
14198: l_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_Type;
14199: l_Old_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type := NULL;

Line 14272: l_ECO_rec.return_status <> FND_API.G_MISS_CHAR

14268: -- Process Flow Step 2: Check if record has not yet been processed
14269: --
14270:
14271: IF l_ECO_rec.return_status IS NOT NULL AND
14272: l_ECO_rec.return_status <> FND_API.G_MISS_CHAR
14273: THEN
14274: x_return_status := l_return_status;
14275: x_ECO_rec := l_ECO_rec;
14276: x_eco_revision_tbl := l_eco_revision_tbl;

Line 14289: l_return_status := FND_API.G_RET_STS_SUCCESS;

14285:
14286: RETURN;
14287: END IF;
14288:
14289: l_return_status := FND_API.G_RET_STS_SUCCESS;
14290: l_eco_rec.return_status := FND_API.G_RET_STS_SUCCESS;
14291:
14292: -- Check if transaction_type is valid
14293: --

Line 14290: l_eco_rec.return_status := FND_API.G_RET_STS_SUCCESS;

14286: RETURN;
14287: END IF;
14288:
14289: l_return_status := FND_API.G_RET_STS_SUCCESS;
14290: l_eco_rec.return_status := FND_API.G_RET_STS_SUCCESS;
14291:
14292: -- Check if transaction_type is valid
14293: --
14294:

Line 15175: , p_error_status => FND_API.G_RET_STS_ERROR

15171: , p_rev_operation_tbl => l_rev_operation_tbl --L1
15172: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --L1
15173: , p_rev_sub_resource_tbl=> l_rev_sub_resource_tbl --L1
15174: , p_mesg_token_tbl => l_mesg_token_tbl
15175: , p_error_status => FND_API.G_RET_STS_ERROR
15176: , p_error_scope => Error_Handler.G_SCOPE_RECORD
15177: , p_error_level => 1
15178: , x_ECO_rec => l_ECO_rec
15179: , x_eco_revision_tbl => l_eco_revision_tbl

Line 15648: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

15644: -- End of Comments
15645:
15646: PROCEDURE Process_Eco
15647: ( p_api_version_number IN NUMBER
15648: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
15649: , p_control_rec IN ENG_GLOBALS.Control_Rec_Type :=
15650: ENG_GLOBALS.G_MISS_CONTROL_REC
15651: , x_return_status OUT NOCOPY VARCHAR2
15652: , x_msg_count OUT NOCOPY NUMBER

Line 15753: IF NOT FND_API.Compatible_API_Call

15749:
15750: /*------------------------------------
15751: -- Not used
15752:
15753: IF NOT FND_API.Compatible_API_Call
15754: ( l_api_version_number
15755: , p_api_version_number
15756: , l_api_name
15757: , G_PKG_NAME

Line 15808: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

15804: BOM_Globals.Set_Unit_Effectivity (FALSE);
15805: ENG_Globals.Set_Unit_Effectivity (FALSE);
15806: END IF;
15807:
15808: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
15809: THEN
15810: RAISE EXC_ERR_PVT_API_MAIN;
15811: END IF;
15812: -- Eco

Line 15813: IF (l_ECO_rec.ECO_Name <> FND_API.G_MISS_CHAR

15809: THEN
15810: RAISE EXC_ERR_PVT_API_MAIN;
15811: END IF;
15812: -- Eco
15813: IF (l_ECO_rec.ECO_Name <> FND_API.G_MISS_CHAR
15814: AND l_ECO_rec.ECO_Name IS NOT NULL)
15815: THEN
15816: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug(' '); END IF;
15817: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('PVT API: Calling ECO_Header'); END IF;

Line 16304: , p_error_status => FND_API.G_RET_STS_UNEXP_ERROR

16300: , p_rev_operation_tbl => l_rev_operation_tbl --L1
16301: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --L1
16302: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --L1
16303: , p_mesg_token_tbl => l_mesg_token_tbl
16304: , p_error_status => FND_API.G_RET_STS_UNEXP_ERROR
16305: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
16306: , p_other_message => l_other_message
16307: , p_other_token_tbl => l_other_token_tbl
16308: , p_error_level => 0

Line 16391: , p_error_status => FND_API.G_RET_STS_UNEXP_ERROR

16387: , p_rev_operation_tbl => l_rev_operation_tbl --L1
16388: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --L1
16389: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --L1
16390: , p_mesg_token_tbl => l_mesg_token_tbl
16391: , p_error_status => FND_API.G_RET_STS_UNEXP_ERROR
16392: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
16393: , p_other_message => l_other_message
16394: , p_other_token_tbl => l_other_token_tbl
16395: , p_error_level => 0

Line 16451: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

16447: -- End of Comments
16448:
16449: PROCEDURE Lock_Eco
16450: ( p_api_version_number IN NUMBER
16451: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
16452: , x_return_status OUT NOCOPY VARCHAR2
16453: , x_msg_count OUT NOCOPY NUMBER
16454: , x_msg_data OUT NOCOPY VARCHAR2
16455: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=

Line 16478: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

16474: )
16475: IS
16476: l_api_version_number CONSTANT NUMBER := 1.0;
16477: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Eco';
16478: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
16479: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
16480: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
16481: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
16482: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;

Line 16492: IF NOT FND_API.Compatible_API_Call

16488: NULL;
16489:
16490: /*********************** Temporarily commented *****************************
16491:
16492: IF NOT FND_API.Compatible_API_Call
16493: ( l_api_version_number
16494: , p_api_version_number
16495: , l_api_name
16496: , G_PKG_NAME

Line 16499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

16495: , l_api_name
16496: , G_PKG_NAME
16497: )
16498: THEN
16499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16500: END IF;
16501:
16502: -- Initialize message list.
16503:

Line 16504: IF FND_API.to_Boolean(p_init_msg_list) THEN

16500: END IF;
16501:
16502: -- Initialize message list.
16503:
16504: IF FND_API.to_Boolean(p_init_msg_list) THEN
16505: FND_MSG_PUB.initialize;
16506: END IF;
16507:
16508: -- Set Savepoint

Line 16523: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

16519: , x_return_status => l_return_status
16520: , x_err_text => x_err_text
16521: );
16522:
16523: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16525: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16526: RAISE FND_API.G_EXC_ERROR;
16527: END IF;

Line 16524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

16520: , x_err_text => x_err_text
16521: );
16522:
16523: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16525: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16526: RAISE FND_API.G_EXC_ERROR;
16527: END IF;
16528:

Line 16525: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

16521: );
16522:
16523: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16525: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16526: RAISE FND_API.G_EXC_ERROR;
16527: END IF;
16528:
16529:

Line 16526: RAISE FND_API.G_EXC_ERROR;

16522:
16523: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16525: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16526: RAISE FND_API.G_EXC_ERROR;
16527: END IF;
16528:
16529:
16530: END IF;

Line 16545: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

16541: , x_return_status => l_return_status
16542: , x_err_text => x_err_text
16543: );
16544:
16545: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16547: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16548: RAISE FND_API.G_EXC_ERROR;
16549: END IF;

Line 16546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

16542: , x_err_text => x_err_text
16543: );
16544:
16545: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16547: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16548: RAISE FND_API.G_EXC_ERROR;
16549: END IF;
16550:

Line 16547: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

16543: );
16544:
16545: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16547: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16548: RAISE FND_API.G_EXC_ERROR;
16549: END IF;
16550:
16551: x_eco_revision_tbl(I) := l_eco_revision_rec;

Line 16548: RAISE FND_API.G_EXC_ERROR;

16544:
16545: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16547: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16548: RAISE FND_API.G_EXC_ERROR;
16549: END IF;
16550:
16551: x_eco_revision_tbl(I) := l_eco_revision_rec;
16552:

Line 16570: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

16566: , x_return_status => l_return_status
16567: , x_err_text => x_err_text
16568: );
16569:
16570: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16572: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16573: RAISE FND_API.G_EXC_ERROR;
16574: END IF;

Line 16571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

16567: , x_err_text => x_err_text
16568: );
16569:
16570: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16572: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16573: RAISE FND_API.G_EXC_ERROR;
16574: END IF;
16575:

Line 16572: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

16568: );
16569:
16570: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16572: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16573: RAISE FND_API.G_EXC_ERROR;
16574: END IF;
16575:
16576: x_revised_item_tbl(I) := l_revised_item_rec;

Line 16573: RAISE FND_API.G_EXC_ERROR;

16569:
16570: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16572: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16573: RAISE FND_API.G_EXC_ERROR;
16574: END IF;
16575:
16576: x_revised_item_tbl(I) := l_revised_item_rec;
16577:

Line 16595: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

16591: , x_return_status => l_return_status
16592: , x_err_text => x_err_text
16593: );
16594:
16595: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16597: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16598: RAISE FND_API.G_EXC_ERROR;
16599: END IF;

Line 16596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

16592: , x_err_text => x_err_text
16593: );
16594:
16595: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16597: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16598: RAISE FND_API.G_EXC_ERROR;
16599: END IF;
16600:

Line 16597: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

16593: );
16594:
16595: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16597: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16598: RAISE FND_API.G_EXC_ERROR;
16599: END IF;
16600:
16601: x_rev_component_tbl(I) := l_rev_component_rec;

Line 16598: RAISE FND_API.G_EXC_ERROR;

16594:
16595: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16597: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16598: RAISE FND_API.G_EXC_ERROR;
16599: END IF;
16600:
16601: x_rev_component_tbl(I) := l_rev_component_rec;
16602:

Line 16620: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

16616: , x_return_status => l_return_status
16617: , x_err_text => x_err_text
16618: );
16619:
16620: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16622: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16623: RAISE FND_API.G_EXC_ERROR;
16624: END IF;

Line 16621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

16617: , x_err_text => x_err_text
16618: );
16619:
16620: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16622: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16623: RAISE FND_API.G_EXC_ERROR;
16624: END IF;
16625:

Line 16622: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

16618: );
16619:
16620: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16622: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16623: RAISE FND_API.G_EXC_ERROR;
16624: END IF;
16625:
16626: x_ref_designator_tbl(I) := l_ref_designator_rec;

Line 16623: RAISE FND_API.G_EXC_ERROR;

16619:
16620: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16622: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16623: RAISE FND_API.G_EXC_ERROR;
16624: END IF;
16625:
16626: x_ref_designator_tbl(I) := l_ref_designator_rec;
16627:

Line 16645: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

16641: , x_return_status => l_return_status
16642: , x_err_text => x_err_text
16643: );
16644:
16645: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16647: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16648: RAISE FND_API.G_EXC_ERROR;
16649: END IF;

Line 16646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

16642: , x_err_text => x_err_text
16643: );
16644:
16645: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16647: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16648: RAISE FND_API.G_EXC_ERROR;
16649: END IF;
16650:

Line 16647: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

16643: );
16644:
16645: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16647: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16648: RAISE FND_API.G_EXC_ERROR;
16649: END IF;
16650:
16651: x_sub_component_tbl(I) := l_sub_component_rec;

Line 16648: RAISE FND_API.G_EXC_ERROR;

16644:
16645: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
16646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16647: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
16648: RAISE FND_API.G_EXC_ERROR;
16649: END IF;
16650:
16651: x_sub_component_tbl(I) := l_sub_component_rec;
16652:

Line 16659: x_return_status := FND_API.G_RET_STS_SUCCESS;

16655: END LOOP;
16656:
16657: -- Set return status
16658:
16659: x_return_status := FND_API.G_RET_STS_SUCCESS;
16660:
16661: -- Get message count and data
16662:
16663: FND_MSG_PUB.Count_And_Get

Line 16671: WHEN FND_API.G_EXC_ERROR THEN

16667:
16668:
16669: EXCEPTION
16670:
16671: WHEN FND_API.G_EXC_ERROR THEN
16672:
16673: x_return_status := FND_API.G_RET_STS_ERROR;
16674:
16675: -- Get message count and data

Line 16673: x_return_status := FND_API.G_RET_STS_ERROR;

16669: EXCEPTION
16670:
16671: WHEN FND_API.G_EXC_ERROR THEN
16672:
16673: x_return_status := FND_API.G_RET_STS_ERROR;
16674:
16675: -- Get message count and data
16676:
16677: FND_MSG_PUB.Count_And_Get

Line 16686: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

16682: -- Rollback
16683:
16684: ROLLBACK TO Lock_Eco_PVT;
16685:
16686: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
16687:
16688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
16689:
16690: -- Get message count and data

Line 16688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

16684: ROLLBACK TO Lock_Eco_PVT;
16685:
16686: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
16687:
16688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
16689:
16690: -- Get message count and data
16691:
16692: FND_MSG_PUB.Count_And_Get

Line 16703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

16699: ROLLBACK TO Lock_Eco_PVT;
16700:
16701: WHEN OTHERS THEN
16702:
16703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
16704:
16705: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16706: THEN
16707: FND_MSG_PUB.Add_Exc_Msg

Line 18284: p_init_msg_list => FND_API.G_TRUE,

18280: AND organization_id = p_org_id;
18281:
18282: ENG_CHANGE_LIFECYCLE_UTIL.Init_Lifecycle(
18283: p_api_version => 1.0,
18284: p_init_msg_list => FND_API.G_TRUE,
18285: p_commit => FND_API.G_FALSE,
18286: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
18287: p_debug => FND_API.G_FALSE,
18288: p_output_dir => null,

Line 18285: p_commit => FND_API.G_FALSE,

18281:
18282: ENG_CHANGE_LIFECYCLE_UTIL.Init_Lifecycle(
18283: p_api_version => 1.0,
18284: p_init_msg_list => FND_API.G_TRUE,
18285: p_commit => FND_API.G_FALSE,
18286: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
18287: p_debug => FND_API.G_FALSE,
18288: p_output_dir => null,
18289: p_debug_filename => null,

Line 18286: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

18282: ENG_CHANGE_LIFECYCLE_UTIL.Init_Lifecycle(
18283: p_api_version => 1.0,
18284: p_init_msg_list => FND_API.G_TRUE,
18285: p_commit => FND_API.G_FALSE,
18286: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
18287: p_debug => FND_API.G_FALSE,
18288: p_output_dir => null,
18289: p_debug_filename => null,
18290: x_return_status => l_return_status,

Line 18287: p_debug => FND_API.G_FALSE,

18283: p_api_version => 1.0,
18284: p_init_msg_list => FND_API.G_TRUE,
18285: p_commit => FND_API.G_FALSE,
18286: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
18287: p_debug => FND_API.G_FALSE,
18288: p_output_dir => null,
18289: p_debug_filename => null,
18290: x_return_status => l_return_status,
18291: x_msg_count => l_msg_count,

Line 18310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

18306: ,p_Message_Text => 'Error in ENG_ECO_PVT.Explode_WF_Routing: '|| SUBSTR(SQLERRM, 1, 30) || ' ' ||to_char(SQLCODE)
18307: ,x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
18308: , p_Mesg_Token_Tbl => x_Mesg_Token_Tbl
18309: );
18310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
18311:
18312: END Explode_WF_Routing;
18313:
18314: END ENG_Eco_PVT;