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

Line 56: x_return_status := FND_API.g_ret_sts_success;

52: FROM ENG_CHANGES_EXT_B
53: WHERE change_id = p_change_id;
54:
55: BEGIN
56: x_return_status := FND_API.g_ret_sts_success;
57: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
58: l_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
59:
60: IF(p_change_id IS NOT NULL ) THEN

Line 57: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

53: WHERE change_id = p_change_id;
54:
55: BEGIN
56: x_return_status := FND_API.g_ret_sts_success;
57: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
58: l_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
59:
60: IF(p_change_id IS NOT NULL ) THEN
61:

Line 87: RAISE FND_API.g_exc_error;

83: IF(l_application_id IS NULL ) THEN
84: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');
85: FND_MESSAGE.set_token('COL_VALUE', 'ENG');
86: FND_MSG_PUB.add;
87: RAISE FND_API.g_exc_error;
88: END IF;
89:
90: INV_EBI_ITEM_HELPER.get_uda_attributes(
91: p_classification_id => l_change_order_type_id,

Line 102: IF(l_uda_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN

98: p_pk_data => l_pkdata,
99: x_uda_obj => x_change_uda,
100: x_uda_output_obj => l_uda_output_obj );
101:
102: IF(l_uda_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
103: x_msg_data := l_uda_output_obj.output_status.msg_data ;
104: RAISE FND_API.g_exc_unexpected_error;
105: END IF;
106: END IF;

Line 104: RAISE FND_API.g_exc_unexpected_error;

100: x_uda_output_obj => l_uda_output_obj );
101:
102: IF(l_uda_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
103: x_msg_data := l_uda_output_obj.output_status.msg_data ;
104: RAISE FND_API.g_exc_unexpected_error;
105: END IF;
106: END IF;
107: END IF;
108: EXCEPTION

Line 109: WHEN FND_API.g_exc_unexpected_error THEN

105: END IF;
106: END IF;
107: END IF;
108: EXCEPTION
109: WHEN FND_API.g_exc_unexpected_error THEN
110:
111: IF c_attr_group_id%ISOPEN THEN
112: CLOSE c_attr_group_id;
113: END IF;

Line 115: x_return_status := FND_API.g_ret_sts_unexp_error;

111: IF c_attr_group_id%ISOPEN THEN
112: CLOSE c_attr_group_id;
113: END IF;
114:
115: x_return_status := FND_API.g_ret_sts_unexp_error;
116: IF(x_msg_data IS NULL) THEN
117: fnd_msg_pub.count_and_get(
118: p_encoded => FND_API.g_false
119: ,p_count => x_msg_count

Line 118: p_encoded => FND_API.g_false

114:
115: x_return_status := FND_API.g_ret_sts_unexp_error;
116: IF(x_msg_data IS NULL) THEN
117: fnd_msg_pub.count_and_get(
118: p_encoded => FND_API.g_false
119: ,p_count => x_msg_count
120: ,p_data => x_msg_data
121: );
122: END IF;

Line 129: x_return_status := FND_API.g_ret_sts_unexp_error;

125: IF c_attr_group_id%ISOPEN THEN
126: CLOSE c_attr_group_id;
127: END IF;
128:
129: x_return_status := FND_API.g_ret_sts_unexp_error;
130: IF (x_msg_data IS NOT NULL) THEN
131: x_msg_data := x_msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.get_change_order_uda ';
132: ELSE
133: x_msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.get_change_order_uda ';

Line 184: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;

180: FROM bom_bill_of_materials
181: WHERE
182: assembly_item_id = p_assembly_item_id
183: AND organization_id = p_organization_id
184: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;
185:
186:
187: BEGIN
188: x_return_status := FND_API.g_ret_sts_success;

Line 188: x_return_status := FND_API.g_ret_sts_success;

184: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;
185:
186:
187: BEGIN
188: x_return_status := FND_API.g_ret_sts_success;
189: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
190: l_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
191:
192: IF( p_assembly_item_id IS NOT NULL AND

Line 189: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

185:
186:
187: BEGIN
188: x_return_status := FND_API.g_ret_sts_success;
189: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
190: l_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
191:
192: IF( p_assembly_item_id IS NOT NULL AND
193: p_organization_id IS NOT NULL) THEN

Line 226: RAISE FND_API.g_exc_error;

222:
223: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');
224: FND_MESSAGE.set_token('COL_VALUE', 'BOM');
225: FND_MSG_PUB.add;
226: RAISE FND_API.g_exc_error;
227: END IF;
228:
229: INV_EBI_ITEM_HELPER.get_uda_attributes(
230: p_classification_id => l_structure_type_id,

Line 242: IF(l_uda_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN

238: x_uda_obj => x_structure_header_uda,
239: x_uda_output_obj => l_uda_output_obj
240: );
241:
242: IF(l_uda_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
243: x_msg_data := l_uda_output_obj.output_status.msg_data ;
244: RAISE FND_API.g_exc_unexpected_error;
245: END IF;
246: END IF;

Line 244: RAISE FND_API.g_exc_unexpected_error;

240: );
241:
242: IF(l_uda_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
243: x_msg_data := l_uda_output_obj.output_status.msg_data ;
244: RAISE FND_API.g_exc_unexpected_error;
245: END IF;
246: END IF;
247: CLOSE c_attr_group_id;
248: END IF;

Line 253: WHEN FND_API.g_exc_unexpected_error THEN

249: CLOSE c_bom_count;
250: END IF;
251:
252: EXCEPTION
253: WHEN FND_API.g_exc_unexpected_error THEN
254:
255: IF c_attr_group_id%ISOPEN THEN
256: CLOSE c_attr_group_id;
257: END IF;

Line 263: x_return_status := FND_API.g_ret_sts_unexp_error;

259: IF c_bom_count%ISOPEN THEN
260: CLOSE c_bom_count;
261: END IF;
262:
263: x_return_status := FND_API.g_ret_sts_unexp_error;
264: IF(x_msg_data IS NULL) THEN
265: fnd_msg_pub.count_and_get(
266: p_encoded => FND_API.g_false
267: ,p_count => x_msg_count

Line 266: p_encoded => FND_API.g_false

262:
263: x_return_status := FND_API.g_ret_sts_unexp_error;
264: IF(x_msg_data IS NULL) THEN
265: fnd_msg_pub.count_and_get(
266: p_encoded => FND_API.g_false
267: ,p_count => x_msg_count
268: ,p_data => x_msg_data
269: );
270: END IF;

Line 281: x_return_status := FND_API.g_ret_sts_unexp_error;

277: IF c_bom_count%ISOPEN THEN
278: CLOSE c_bom_count;
279: END IF;
280:
281: x_return_status := FND_API.g_ret_sts_unexp_error;
282: IF (x_msg_data IS NOT NULL) THEN
283: x_msg_data := x_msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.get_structure_header_uda ';
284: ELSE
285: x_msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.get_structure_header_uda ';

Line 340: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;

336: FROM bom_bill_of_materials
337: WHERE
338: assembly_item_id = p_revised_item_id
339: AND organization_id = p_organization_id
340: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;
341:
342: CURSOR c_comp_count(
343: p_bill_sequence_id NUMBER,
344: p_component_item_id NUMBER

Line 354: x_return_status := FND_API.g_ret_sts_success;

350: component_item_id = p_component_item_id AND
351: change_notice = p_eco_name;
352:
353: BEGIN
354: x_return_status := FND_API.g_ret_sts_success;
355: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
356: l_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
357:
358: IF( p_revised_item_id IS NOT NULL AND

Line 355: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

351: change_notice = p_eco_name;
352:
353: BEGIN
354: x_return_status := FND_API.g_ret_sts_success;
355: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
356: l_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
357:
358: IF( p_revised_item_id IS NOT NULL AND
359: p_organization_id IS NOT NULL) THEN

Line 405: RAISE FND_API.g_exc_error;

401: IF(l_application_id IS NULL ) THEN
402: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');
403: FND_MESSAGE.set_token('COL_VALUE', 'BOM');
404: FND_MSG_PUB.add;
405: RAISE FND_API.g_exc_error;
406: END IF;
407:
408: INV_EBI_ITEM_HELPER.get_uda_attributes(
409: p_classification_id => l_structure_type_id,

Line 420: IF(l_uda_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN

416: p_pk_data => l_pkdata,
417: x_uda_obj => x_comp_item_uda,
418: x_uda_output_obj => l_uda_output_obj
419: );
420: IF(l_uda_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
421: x_msg_data := l_uda_output_obj.output_status.msg_data ;
422: RAISE FND_API.g_exc_unexpected_error;
423: END IF;
424: END IF;

Line 422: RAISE FND_API.g_exc_unexpected_error;

418: x_uda_output_obj => l_uda_output_obj
419: );
420: IF(l_uda_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
421: x_msg_data := l_uda_output_obj.output_status.msg_data ;
422: RAISE FND_API.g_exc_unexpected_error;
423: END IF;
424: END IF;
425: CLOSE c_attr_group_id;
426: END IF;

Line 433: WHEN FND_API.g_exc_unexpected_error THEN

429: CLOSE c_bom_count;
430: END IF;
431:
432: EXCEPTION
433: WHEN FND_API.g_exc_unexpected_error THEN
434:
435: IF c_attr_group_id%ISOPEN THEN
436: CLOSE c_attr_group_id;
437: END IF;

Line 447: x_return_status := FND_API.g_ret_sts_unexp_error;

443: IF c_comp_count%ISOPEN THEN
444: CLOSE c_comp_count;
445: END IF;
446:
447: x_return_status := FND_API.g_ret_sts_unexp_error;
448: IF(x_msg_data IS NULL) THEN
449: fnd_msg_pub.count_and_get(
450: p_encoded => FND_API.g_false
451: ,p_count => x_msg_count

Line 450: p_encoded => FND_API.g_false

446:
447: x_return_status := FND_API.g_ret_sts_unexp_error;
448: IF(x_msg_data IS NULL) THEN
449: fnd_msg_pub.count_and_get(
450: p_encoded => FND_API.g_false
451: ,p_count => x_msg_count
452: ,p_data => x_msg_data
453: );
454: END IF;

Line 469: x_return_status := FND_API.g_ret_sts_unexp_error;

465: IF c_comp_count%ISOPEN THEN
466: CLOSE c_comp_count;
467: END IF;
468:
469: x_return_status := FND_API.g_ret_sts_unexp_error;
470: IF (x_msg_data IS NOT NULL) THEN
471: x_msg_data := x_msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.get_component_item_uda ';
472: ELSE
473: x_msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.get_component_item_uda ';

Line 525: ,fnd_api.g_miss_num ,NVL(sc.acd_type,1) ,p_new_substitute_comp.acd_type)) acd_type

521: ,p_substitute_component_name IN VARCHAR2
522: ) IS
523: SELECT
524: DECODE(p_new_substitute_comp ,NULL ,NVL(sc.acd_type,1) ,DECODE(p_new_substitute_comp.acd_type
525: ,fnd_api.g_miss_num ,NVL(sc.acd_type,1) ,p_new_substitute_comp.acd_type)) acd_type
526: ,DECODE(p_new_substitute_comp ,NULL ,sc.substitute_item_quantity ,DECODE(p_new_substitute_comp.substitute_item_quantity
527: ,fnd_api.g_miss_num ,sc.substitute_item_quantity ,p_new_substitute_comp.substitute_item_quantity)) substitute_item_quantity
528: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute_category ,DECODE(p_new_substitute_comp.attribute_category
529: ,fnd_api.g_miss_char ,sc.attribute_category ,p_new_substitute_comp.attribute_category )) attribute_category

Line 527: ,fnd_api.g_miss_num ,sc.substitute_item_quantity ,p_new_substitute_comp.substitute_item_quantity)) substitute_item_quantity

523: SELECT
524: DECODE(p_new_substitute_comp ,NULL ,NVL(sc.acd_type,1) ,DECODE(p_new_substitute_comp.acd_type
525: ,fnd_api.g_miss_num ,NVL(sc.acd_type,1) ,p_new_substitute_comp.acd_type)) acd_type
526: ,DECODE(p_new_substitute_comp ,NULL ,sc.substitute_item_quantity ,DECODE(p_new_substitute_comp.substitute_item_quantity
527: ,fnd_api.g_miss_num ,sc.substitute_item_quantity ,p_new_substitute_comp.substitute_item_quantity)) substitute_item_quantity
528: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute_category ,DECODE(p_new_substitute_comp.attribute_category
529: ,fnd_api.g_miss_char ,sc.attribute_category ,p_new_substitute_comp.attribute_category )) attribute_category
530: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute1 ,DECODE(p_new_substitute_comp.attribute1
531: ,fnd_api.g_miss_char ,sc.attribute1 ,p_new_substitute_comp.attribute1 )) attribute1

Line 529: ,fnd_api.g_miss_char ,sc.attribute_category ,p_new_substitute_comp.attribute_category )) attribute_category

525: ,fnd_api.g_miss_num ,NVL(sc.acd_type,1) ,p_new_substitute_comp.acd_type)) acd_type
526: ,DECODE(p_new_substitute_comp ,NULL ,sc.substitute_item_quantity ,DECODE(p_new_substitute_comp.substitute_item_quantity
527: ,fnd_api.g_miss_num ,sc.substitute_item_quantity ,p_new_substitute_comp.substitute_item_quantity)) substitute_item_quantity
528: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute_category ,DECODE(p_new_substitute_comp.attribute_category
529: ,fnd_api.g_miss_char ,sc.attribute_category ,p_new_substitute_comp.attribute_category )) attribute_category
530: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute1 ,DECODE(p_new_substitute_comp.attribute1
531: ,fnd_api.g_miss_char ,sc.attribute1 ,p_new_substitute_comp.attribute1 )) attribute1
532: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute2 ,DECODE(p_new_substitute_comp.attribute2
533: ,fnd_api.g_miss_char ,sc.attribute2 ,p_new_substitute_comp.attribute2 )) attribute2

Line 531: ,fnd_api.g_miss_char ,sc.attribute1 ,p_new_substitute_comp.attribute1 )) attribute1

527: ,fnd_api.g_miss_num ,sc.substitute_item_quantity ,p_new_substitute_comp.substitute_item_quantity)) substitute_item_quantity
528: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute_category ,DECODE(p_new_substitute_comp.attribute_category
529: ,fnd_api.g_miss_char ,sc.attribute_category ,p_new_substitute_comp.attribute_category )) attribute_category
530: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute1 ,DECODE(p_new_substitute_comp.attribute1
531: ,fnd_api.g_miss_char ,sc.attribute1 ,p_new_substitute_comp.attribute1 )) attribute1
532: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute2 ,DECODE(p_new_substitute_comp.attribute2
533: ,fnd_api.g_miss_char ,sc.attribute2 ,p_new_substitute_comp.attribute2 )) attribute2
534: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute3 ,DECODE(p_new_substitute_comp.attribute3
535: ,fnd_api.g_miss_char ,sc.attribute3 ,p_new_substitute_comp.attribute3 )) attribute3

Line 533: ,fnd_api.g_miss_char ,sc.attribute2 ,p_new_substitute_comp.attribute2 )) attribute2

529: ,fnd_api.g_miss_char ,sc.attribute_category ,p_new_substitute_comp.attribute_category )) attribute_category
530: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute1 ,DECODE(p_new_substitute_comp.attribute1
531: ,fnd_api.g_miss_char ,sc.attribute1 ,p_new_substitute_comp.attribute1 )) attribute1
532: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute2 ,DECODE(p_new_substitute_comp.attribute2
533: ,fnd_api.g_miss_char ,sc.attribute2 ,p_new_substitute_comp.attribute2 )) attribute2
534: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute3 ,DECODE(p_new_substitute_comp.attribute3
535: ,fnd_api.g_miss_char ,sc.attribute3 ,p_new_substitute_comp.attribute3 )) attribute3
536: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute4 ,DECODE(p_new_substitute_comp.attribute4
537: ,fnd_api.g_miss_char ,sc.attribute4 ,p_new_substitute_comp.attribute4 )) attribute4

Line 535: ,fnd_api.g_miss_char ,sc.attribute3 ,p_new_substitute_comp.attribute3 )) attribute3

531: ,fnd_api.g_miss_char ,sc.attribute1 ,p_new_substitute_comp.attribute1 )) attribute1
532: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute2 ,DECODE(p_new_substitute_comp.attribute2
533: ,fnd_api.g_miss_char ,sc.attribute2 ,p_new_substitute_comp.attribute2 )) attribute2
534: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute3 ,DECODE(p_new_substitute_comp.attribute3
535: ,fnd_api.g_miss_char ,sc.attribute3 ,p_new_substitute_comp.attribute3 )) attribute3
536: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute4 ,DECODE(p_new_substitute_comp.attribute4
537: ,fnd_api.g_miss_char ,sc.attribute4 ,p_new_substitute_comp.attribute4 )) attribute4
538: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute5 ,DECODE(p_new_substitute_comp.attribute5
539: ,fnd_api.g_miss_char ,sc.attribute5 ,p_new_substitute_comp.attribute5 )) attribute5

Line 537: ,fnd_api.g_miss_char ,sc.attribute4 ,p_new_substitute_comp.attribute4 )) attribute4

533: ,fnd_api.g_miss_char ,sc.attribute2 ,p_new_substitute_comp.attribute2 )) attribute2
534: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute3 ,DECODE(p_new_substitute_comp.attribute3
535: ,fnd_api.g_miss_char ,sc.attribute3 ,p_new_substitute_comp.attribute3 )) attribute3
536: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute4 ,DECODE(p_new_substitute_comp.attribute4
537: ,fnd_api.g_miss_char ,sc.attribute4 ,p_new_substitute_comp.attribute4 )) attribute4
538: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute5 ,DECODE(p_new_substitute_comp.attribute5
539: ,fnd_api.g_miss_char ,sc.attribute5 ,p_new_substitute_comp.attribute5 )) attribute5
540: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute6 ,DECODE(p_new_substitute_comp.attribute6
541: ,fnd_api.g_miss_char ,sc.attribute6 ,p_new_substitute_comp.attribute6 )) attribute6

Line 539: ,fnd_api.g_miss_char ,sc.attribute5 ,p_new_substitute_comp.attribute5 )) attribute5

535: ,fnd_api.g_miss_char ,sc.attribute3 ,p_new_substitute_comp.attribute3 )) attribute3
536: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute4 ,DECODE(p_new_substitute_comp.attribute4
537: ,fnd_api.g_miss_char ,sc.attribute4 ,p_new_substitute_comp.attribute4 )) attribute4
538: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute5 ,DECODE(p_new_substitute_comp.attribute5
539: ,fnd_api.g_miss_char ,sc.attribute5 ,p_new_substitute_comp.attribute5 )) attribute5
540: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute6 ,DECODE(p_new_substitute_comp.attribute6
541: ,fnd_api.g_miss_char ,sc.attribute6 ,p_new_substitute_comp.attribute6 )) attribute6
542: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute7 ,DECODE(p_new_substitute_comp.attribute7
543: ,fnd_api.g_miss_char ,sc.attribute7 ,p_new_substitute_comp.attribute7 )) attribute7

Line 541: ,fnd_api.g_miss_char ,sc.attribute6 ,p_new_substitute_comp.attribute6 )) attribute6

537: ,fnd_api.g_miss_char ,sc.attribute4 ,p_new_substitute_comp.attribute4 )) attribute4
538: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute5 ,DECODE(p_new_substitute_comp.attribute5
539: ,fnd_api.g_miss_char ,sc.attribute5 ,p_new_substitute_comp.attribute5 )) attribute5
540: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute6 ,DECODE(p_new_substitute_comp.attribute6
541: ,fnd_api.g_miss_char ,sc.attribute6 ,p_new_substitute_comp.attribute6 )) attribute6
542: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute7 ,DECODE(p_new_substitute_comp.attribute7
543: ,fnd_api.g_miss_char ,sc.attribute7 ,p_new_substitute_comp.attribute7 )) attribute7
544: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute8 ,DECODE(p_new_substitute_comp.attribute8
545: ,fnd_api.g_miss_char ,sc.attribute8 ,p_new_substitute_comp.attribute8 )) attribute8

Line 543: ,fnd_api.g_miss_char ,sc.attribute7 ,p_new_substitute_comp.attribute7 )) attribute7

539: ,fnd_api.g_miss_char ,sc.attribute5 ,p_new_substitute_comp.attribute5 )) attribute5
540: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute6 ,DECODE(p_new_substitute_comp.attribute6
541: ,fnd_api.g_miss_char ,sc.attribute6 ,p_new_substitute_comp.attribute6 )) attribute6
542: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute7 ,DECODE(p_new_substitute_comp.attribute7
543: ,fnd_api.g_miss_char ,sc.attribute7 ,p_new_substitute_comp.attribute7 )) attribute7
544: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute8 ,DECODE(p_new_substitute_comp.attribute8
545: ,fnd_api.g_miss_char ,sc.attribute8 ,p_new_substitute_comp.attribute8 )) attribute8
546: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute9 ,DECODE(p_new_substitute_comp.attribute9
547: ,fnd_api.g_miss_char ,sc.attribute9 ,p_new_substitute_comp.attribute9 )) attribute9

Line 545: ,fnd_api.g_miss_char ,sc.attribute8 ,p_new_substitute_comp.attribute8 )) attribute8

541: ,fnd_api.g_miss_char ,sc.attribute6 ,p_new_substitute_comp.attribute6 )) attribute6
542: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute7 ,DECODE(p_new_substitute_comp.attribute7
543: ,fnd_api.g_miss_char ,sc.attribute7 ,p_new_substitute_comp.attribute7 )) attribute7
544: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute8 ,DECODE(p_new_substitute_comp.attribute8
545: ,fnd_api.g_miss_char ,sc.attribute8 ,p_new_substitute_comp.attribute8 )) attribute8
546: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute9 ,DECODE(p_new_substitute_comp.attribute9
547: ,fnd_api.g_miss_char ,sc.attribute9 ,p_new_substitute_comp.attribute9 )) attribute9
548: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute10 ,DECODE(p_new_substitute_comp.attribute10
549: ,fnd_api.g_miss_char ,sc.attribute10 ,p_new_substitute_comp.attribute10 )) attribute10

Line 547: ,fnd_api.g_miss_char ,sc.attribute9 ,p_new_substitute_comp.attribute9 )) attribute9

543: ,fnd_api.g_miss_char ,sc.attribute7 ,p_new_substitute_comp.attribute7 )) attribute7
544: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute8 ,DECODE(p_new_substitute_comp.attribute8
545: ,fnd_api.g_miss_char ,sc.attribute8 ,p_new_substitute_comp.attribute8 )) attribute8
546: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute9 ,DECODE(p_new_substitute_comp.attribute9
547: ,fnd_api.g_miss_char ,sc.attribute9 ,p_new_substitute_comp.attribute9 )) attribute9
548: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute10 ,DECODE(p_new_substitute_comp.attribute10
549: ,fnd_api.g_miss_char ,sc.attribute10 ,p_new_substitute_comp.attribute10 )) attribute10
550: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute11 ,DECODE(p_new_substitute_comp.attribute11
551: ,fnd_api.g_miss_char ,sc.attribute11 ,p_new_substitute_comp.attribute11 )) attribute11

Line 549: ,fnd_api.g_miss_char ,sc.attribute10 ,p_new_substitute_comp.attribute10 )) attribute10

545: ,fnd_api.g_miss_char ,sc.attribute8 ,p_new_substitute_comp.attribute8 )) attribute8
546: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute9 ,DECODE(p_new_substitute_comp.attribute9
547: ,fnd_api.g_miss_char ,sc.attribute9 ,p_new_substitute_comp.attribute9 )) attribute9
548: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute10 ,DECODE(p_new_substitute_comp.attribute10
549: ,fnd_api.g_miss_char ,sc.attribute10 ,p_new_substitute_comp.attribute10 )) attribute10
550: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute11 ,DECODE(p_new_substitute_comp.attribute11
551: ,fnd_api.g_miss_char ,sc.attribute11 ,p_new_substitute_comp.attribute11 )) attribute11
552: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute12 ,DECODE(p_new_substitute_comp.attribute12
553: ,fnd_api.g_miss_char ,sc.attribute12 ,p_new_substitute_comp.attribute12 )) attribute12

Line 551: ,fnd_api.g_miss_char ,sc.attribute11 ,p_new_substitute_comp.attribute11 )) attribute11

547: ,fnd_api.g_miss_char ,sc.attribute9 ,p_new_substitute_comp.attribute9 )) attribute9
548: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute10 ,DECODE(p_new_substitute_comp.attribute10
549: ,fnd_api.g_miss_char ,sc.attribute10 ,p_new_substitute_comp.attribute10 )) attribute10
550: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute11 ,DECODE(p_new_substitute_comp.attribute11
551: ,fnd_api.g_miss_char ,sc.attribute11 ,p_new_substitute_comp.attribute11 )) attribute11
552: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute12 ,DECODE(p_new_substitute_comp.attribute12
553: ,fnd_api.g_miss_char ,sc.attribute12 ,p_new_substitute_comp.attribute12 )) attribute12
554: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute13 ,DECODE(p_new_substitute_comp.attribute13
555: ,fnd_api.g_miss_char ,sc.attribute13 ,p_new_substitute_comp.attribute13 )) attribute13

Line 553: ,fnd_api.g_miss_char ,sc.attribute12 ,p_new_substitute_comp.attribute12 )) attribute12

549: ,fnd_api.g_miss_char ,sc.attribute10 ,p_new_substitute_comp.attribute10 )) attribute10
550: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute11 ,DECODE(p_new_substitute_comp.attribute11
551: ,fnd_api.g_miss_char ,sc.attribute11 ,p_new_substitute_comp.attribute11 )) attribute11
552: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute12 ,DECODE(p_new_substitute_comp.attribute12
553: ,fnd_api.g_miss_char ,sc.attribute12 ,p_new_substitute_comp.attribute12 )) attribute12
554: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute13 ,DECODE(p_new_substitute_comp.attribute13
555: ,fnd_api.g_miss_char ,sc.attribute13 ,p_new_substitute_comp.attribute13 )) attribute13
556: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute14 ,DECODE(p_new_substitute_comp.attribute14
557: ,fnd_api.g_miss_char ,sc.attribute14 ,p_new_substitute_comp.attribute14 )) attribute14

Line 555: ,fnd_api.g_miss_char ,sc.attribute13 ,p_new_substitute_comp.attribute13 )) attribute13

551: ,fnd_api.g_miss_char ,sc.attribute11 ,p_new_substitute_comp.attribute11 )) attribute11
552: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute12 ,DECODE(p_new_substitute_comp.attribute12
553: ,fnd_api.g_miss_char ,sc.attribute12 ,p_new_substitute_comp.attribute12 )) attribute12
554: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute13 ,DECODE(p_new_substitute_comp.attribute13
555: ,fnd_api.g_miss_char ,sc.attribute13 ,p_new_substitute_comp.attribute13 )) attribute13
556: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute14 ,DECODE(p_new_substitute_comp.attribute14
557: ,fnd_api.g_miss_char ,sc.attribute14 ,p_new_substitute_comp.attribute14 )) attribute14
558: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute15 ,DECODE(p_new_substitute_comp.attribute15
559: ,fnd_api.g_miss_char ,sc.attribute15 ,p_new_substitute_comp.attribute15 )) attribute15

Line 557: ,fnd_api.g_miss_char ,sc.attribute14 ,p_new_substitute_comp.attribute14 )) attribute14

553: ,fnd_api.g_miss_char ,sc.attribute12 ,p_new_substitute_comp.attribute12 )) attribute12
554: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute13 ,DECODE(p_new_substitute_comp.attribute13
555: ,fnd_api.g_miss_char ,sc.attribute13 ,p_new_substitute_comp.attribute13 )) attribute13
556: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute14 ,DECODE(p_new_substitute_comp.attribute14
557: ,fnd_api.g_miss_char ,sc.attribute14 ,p_new_substitute_comp.attribute14 )) attribute14
558: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute15 ,DECODE(p_new_substitute_comp.attribute15
559: ,fnd_api.g_miss_char ,sc.attribute15 ,p_new_substitute_comp.attribute15 )) attribute15
560: ,DECODE(p_new_substitute_comp ,NULL ,sc.original_system_reference ,DECODE(p_new_substitute_comp.original_system_reference
561: ,fnd_api.g_miss_char ,sc.original_system_reference ,p_new_substitute_comp.original_system_reference)) original_system_reference

Line 559: ,fnd_api.g_miss_char ,sc.attribute15 ,p_new_substitute_comp.attribute15 )) attribute15

555: ,fnd_api.g_miss_char ,sc.attribute13 ,p_new_substitute_comp.attribute13 )) attribute13
556: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute14 ,DECODE(p_new_substitute_comp.attribute14
557: ,fnd_api.g_miss_char ,sc.attribute14 ,p_new_substitute_comp.attribute14 )) attribute14
558: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute15 ,DECODE(p_new_substitute_comp.attribute15
559: ,fnd_api.g_miss_char ,sc.attribute15 ,p_new_substitute_comp.attribute15 )) attribute15
560: ,DECODE(p_new_substitute_comp ,NULL ,sc.original_system_reference ,DECODE(p_new_substitute_comp.original_system_reference
561: ,fnd_api.g_miss_char ,sc.original_system_reference ,p_new_substitute_comp.original_system_reference)) original_system_reference
562: ,DECODE(p_new_substitute_comp ,NULL ,sc.enforce_int_requirements ,DECODE(p_new_substitute_comp.enforce_int_requirements
563: ,fnd_api.g_miss_num ,sc.enforce_int_requirements ,p_new_substitute_comp.enforce_int_requirements)) enforce_int_requirements

Line 561: ,fnd_api.g_miss_char ,sc.original_system_reference ,p_new_substitute_comp.original_system_reference)) original_system_reference

557: ,fnd_api.g_miss_char ,sc.attribute14 ,p_new_substitute_comp.attribute14 )) attribute14
558: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute15 ,DECODE(p_new_substitute_comp.attribute15
559: ,fnd_api.g_miss_char ,sc.attribute15 ,p_new_substitute_comp.attribute15 )) attribute15
560: ,DECODE(p_new_substitute_comp ,NULL ,sc.original_system_reference ,DECODE(p_new_substitute_comp.original_system_reference
561: ,fnd_api.g_miss_char ,sc.original_system_reference ,p_new_substitute_comp.original_system_reference)) original_system_reference
562: ,DECODE(p_new_substitute_comp ,NULL ,sc.enforce_int_requirements ,DECODE(p_new_substitute_comp.enforce_int_requirements
563: ,fnd_api.g_miss_num ,sc.enforce_int_requirements ,p_new_substitute_comp.enforce_int_requirements)) enforce_int_requirements
564: ,DECODE(p_new_substitute_comp ,NULL ,NULL ,p_new_substitute_comp.start_effective_date) start_effective_date
565: ,DECODE(p_new_substitute_comp ,NULL ,NULL ,p_new_substitute_comp.new_substitute_component_name ) new_substitute_component_name

Line 563: ,fnd_api.g_miss_num ,sc.enforce_int_requirements ,p_new_substitute_comp.enforce_int_requirements)) enforce_int_requirements

559: ,fnd_api.g_miss_char ,sc.attribute15 ,p_new_substitute_comp.attribute15 )) attribute15
560: ,DECODE(p_new_substitute_comp ,NULL ,sc.original_system_reference ,DECODE(p_new_substitute_comp.original_system_reference
561: ,fnd_api.g_miss_char ,sc.original_system_reference ,p_new_substitute_comp.original_system_reference)) original_system_reference
562: ,DECODE(p_new_substitute_comp ,NULL ,sc.enforce_int_requirements ,DECODE(p_new_substitute_comp.enforce_int_requirements
563: ,fnd_api.g_miss_num ,sc.enforce_int_requirements ,p_new_substitute_comp.enforce_int_requirements)) enforce_int_requirements
564: ,DECODE(p_new_substitute_comp ,NULL ,NULL ,p_new_substitute_comp.start_effective_date) start_effective_date
565: ,DECODE(p_new_substitute_comp ,NULL ,NULL ,p_new_substitute_comp.new_substitute_component_name ) new_substitute_component_name
566: ,DECODE(p_new_substitute_comp ,NULL ,NULL ,p_new_substitute_comp.from_end_item_unit_number) from_end_item_unit_number
567: ,DECODE(p_new_substitute_comp ,NULL ,NULL ,p_new_substitute_comp.new_routing_revision) new_routing_revision

Line 590: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

586: l_substitute_comp_tbl inv_ebi_sub_comp_tbl;
587: l_sub_comp_count NUMBER := 1;
588: l_output_status inv_ebi_output_status;
589: BEGIN
590: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
591: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
592: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_substitute_components');
593: OPEN c_comp_sequence_id;
594: FETCH c_comp_sequence_id INTO l_component_sequence_id;

Line 724: WHEN FND_API.g_exc_unexpected_error THEN

720: x_component_item := l_component_item;
721: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_substitute_components');
722:
723: EXCEPTION
724: WHEN FND_API.g_exc_unexpected_error THEN
725: IF c_Merged_Substitute_Comp%ISOPEN THEN
726: CLOSE c_merged_substitute_comp;
727: END IF;
728: IF c_copied_substitute_comps%ISOPEN THEN

Line 731: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

727: END IF;
728: IF c_copied_substitute_comps%ISOPEN THEN
729: CLOSE c_copied_substitute_comps;
730: END IF;
731: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
732: IF(x_out.output_status.msg_data IS NULL) THEN
733: fnd_msg_pub.count_and_get(
734: p_encoded => FND_API.g_false
735: ,p_count => x_out.output_status.msg_count

Line 734: p_encoded => FND_API.g_false

730: END IF;
731: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
732: IF(x_out.output_status.msg_data IS NULL) THEN
733: fnd_msg_pub.count_and_get(
734: p_encoded => FND_API.g_false
735: ,p_count => x_out.output_status.msg_count
736: ,p_data => x_out.output_status.msg_data
737: );
738: END IF;

Line 746: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

742: END IF;
743: IF c_copied_substitute_comps%ISOPEN THEN
744: CLOSE c_copied_substitute_comps;
745: END IF;
746: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
747: IF (x_out.output_status.msg_data IS NOT NULL) THEN
748: x_out.output_status.msg_data := x_out.output_status.msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.prepare_substitute_components ';
749: ELSE
750: x_out.output_status.msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.prepare_substitute_components ';

Line 798: ,fnd_api.g_miss_num ,NVL(acd_type,1) ,p_new_ref_designator.acd_type)) acd_type

794: ,p_ref_designator_name IN VARCHAR2
795: ) IS
796: SELECT
797: DECODE(p_new_ref_designator ,NULL ,NVL(acd_type,1) ,DECODE(p_new_ref_designator.acd_type
798: ,fnd_api.g_miss_num ,NVL(acd_type,1) ,p_new_ref_designator.acd_type)) acd_type
799: ,DECODE(p_new_ref_designator ,NULL ,attribute_category ,DECODE(p_new_ref_designator.attribute_category
800: ,fnd_api.g_miss_char ,attribute_category ,p_new_ref_designator.attribute_category )) attribute_category
801: ,DECODE(p_new_ref_designator ,NULL ,attribute1 ,DECODE(p_new_ref_designator.attribute1
802: ,fnd_api.g_miss_char ,attribute1 ,p_new_ref_designator.attribute1 )) attribute1

Line 800: ,fnd_api.g_miss_char ,attribute_category ,p_new_ref_designator.attribute_category )) attribute_category

796: SELECT
797: DECODE(p_new_ref_designator ,NULL ,NVL(acd_type,1) ,DECODE(p_new_ref_designator.acd_type
798: ,fnd_api.g_miss_num ,NVL(acd_type,1) ,p_new_ref_designator.acd_type)) acd_type
799: ,DECODE(p_new_ref_designator ,NULL ,attribute_category ,DECODE(p_new_ref_designator.attribute_category
800: ,fnd_api.g_miss_char ,attribute_category ,p_new_ref_designator.attribute_category )) attribute_category
801: ,DECODE(p_new_ref_designator ,NULL ,attribute1 ,DECODE(p_new_ref_designator.attribute1
802: ,fnd_api.g_miss_char ,attribute1 ,p_new_ref_designator.attribute1 )) attribute1
803: ,DECODE(p_new_ref_designator ,NULL ,attribute2 ,DECODE(p_new_ref_designator.attribute2
804: ,fnd_api.g_miss_char ,attribute2 ,p_new_ref_designator.attribute2 )) attribute2

Line 802: ,fnd_api.g_miss_char ,attribute1 ,p_new_ref_designator.attribute1 )) attribute1

798: ,fnd_api.g_miss_num ,NVL(acd_type,1) ,p_new_ref_designator.acd_type)) acd_type
799: ,DECODE(p_new_ref_designator ,NULL ,attribute_category ,DECODE(p_new_ref_designator.attribute_category
800: ,fnd_api.g_miss_char ,attribute_category ,p_new_ref_designator.attribute_category )) attribute_category
801: ,DECODE(p_new_ref_designator ,NULL ,attribute1 ,DECODE(p_new_ref_designator.attribute1
802: ,fnd_api.g_miss_char ,attribute1 ,p_new_ref_designator.attribute1 )) attribute1
803: ,DECODE(p_new_ref_designator ,NULL ,attribute2 ,DECODE(p_new_ref_designator.attribute2
804: ,fnd_api.g_miss_char ,attribute2 ,p_new_ref_designator.attribute2 )) attribute2
805: ,DECODE(p_new_ref_designator ,NULL ,attribute3 ,DECODE(p_new_ref_designator.attribute3
806: ,fnd_api.g_miss_char ,attribute3 ,p_new_ref_designator.attribute3 )) attribute3

Line 804: ,fnd_api.g_miss_char ,attribute2 ,p_new_ref_designator.attribute2 )) attribute2

800: ,fnd_api.g_miss_char ,attribute_category ,p_new_ref_designator.attribute_category )) attribute_category
801: ,DECODE(p_new_ref_designator ,NULL ,attribute1 ,DECODE(p_new_ref_designator.attribute1
802: ,fnd_api.g_miss_char ,attribute1 ,p_new_ref_designator.attribute1 )) attribute1
803: ,DECODE(p_new_ref_designator ,NULL ,attribute2 ,DECODE(p_new_ref_designator.attribute2
804: ,fnd_api.g_miss_char ,attribute2 ,p_new_ref_designator.attribute2 )) attribute2
805: ,DECODE(p_new_ref_designator ,NULL ,attribute3 ,DECODE(p_new_ref_designator.attribute3
806: ,fnd_api.g_miss_char ,attribute3 ,p_new_ref_designator.attribute3 )) attribute3
807: ,DECODE(p_new_ref_designator ,NULL ,attribute4 ,DECODE(p_new_ref_designator.attribute4
808: ,fnd_api.g_miss_char ,attribute4 ,p_new_ref_designator.attribute4 )) attribute4

Line 806: ,fnd_api.g_miss_char ,attribute3 ,p_new_ref_designator.attribute3 )) attribute3

802: ,fnd_api.g_miss_char ,attribute1 ,p_new_ref_designator.attribute1 )) attribute1
803: ,DECODE(p_new_ref_designator ,NULL ,attribute2 ,DECODE(p_new_ref_designator.attribute2
804: ,fnd_api.g_miss_char ,attribute2 ,p_new_ref_designator.attribute2 )) attribute2
805: ,DECODE(p_new_ref_designator ,NULL ,attribute3 ,DECODE(p_new_ref_designator.attribute3
806: ,fnd_api.g_miss_char ,attribute3 ,p_new_ref_designator.attribute3 )) attribute3
807: ,DECODE(p_new_ref_designator ,NULL ,attribute4 ,DECODE(p_new_ref_designator.attribute4
808: ,fnd_api.g_miss_char ,attribute4 ,p_new_ref_designator.attribute4 )) attribute4
809: ,DECODE(p_new_ref_designator ,NULL ,attribute5 ,DECODE(p_new_ref_designator.attribute5
810: ,fnd_api.g_miss_char ,attribute5 ,p_new_ref_designator.attribute5 )) attribute5

Line 808: ,fnd_api.g_miss_char ,attribute4 ,p_new_ref_designator.attribute4 )) attribute4

804: ,fnd_api.g_miss_char ,attribute2 ,p_new_ref_designator.attribute2 )) attribute2
805: ,DECODE(p_new_ref_designator ,NULL ,attribute3 ,DECODE(p_new_ref_designator.attribute3
806: ,fnd_api.g_miss_char ,attribute3 ,p_new_ref_designator.attribute3 )) attribute3
807: ,DECODE(p_new_ref_designator ,NULL ,attribute4 ,DECODE(p_new_ref_designator.attribute4
808: ,fnd_api.g_miss_char ,attribute4 ,p_new_ref_designator.attribute4 )) attribute4
809: ,DECODE(p_new_ref_designator ,NULL ,attribute5 ,DECODE(p_new_ref_designator.attribute5
810: ,fnd_api.g_miss_char ,attribute5 ,p_new_ref_designator.attribute5 )) attribute5
811: ,DECODE(p_new_ref_designator ,NULL ,attribute6 ,DECODE(p_new_ref_designator.attribute6
812: ,fnd_api.g_miss_char ,attribute6 ,p_new_ref_designator.attribute6 )) attribute6

Line 810: ,fnd_api.g_miss_char ,attribute5 ,p_new_ref_designator.attribute5 )) attribute5

806: ,fnd_api.g_miss_char ,attribute3 ,p_new_ref_designator.attribute3 )) attribute3
807: ,DECODE(p_new_ref_designator ,NULL ,attribute4 ,DECODE(p_new_ref_designator.attribute4
808: ,fnd_api.g_miss_char ,attribute4 ,p_new_ref_designator.attribute4 )) attribute4
809: ,DECODE(p_new_ref_designator ,NULL ,attribute5 ,DECODE(p_new_ref_designator.attribute5
810: ,fnd_api.g_miss_char ,attribute5 ,p_new_ref_designator.attribute5 )) attribute5
811: ,DECODE(p_new_ref_designator ,NULL ,attribute6 ,DECODE(p_new_ref_designator.attribute6
812: ,fnd_api.g_miss_char ,attribute6 ,p_new_ref_designator.attribute6 )) attribute6
813: ,DECODE(p_new_ref_designator ,NULL ,attribute7 ,DECODE(p_new_ref_designator.attribute7
814: ,fnd_api.g_miss_char ,attribute7 ,p_new_ref_designator.attribute7 )) attribute7

Line 812: ,fnd_api.g_miss_char ,attribute6 ,p_new_ref_designator.attribute6 )) attribute6

808: ,fnd_api.g_miss_char ,attribute4 ,p_new_ref_designator.attribute4 )) attribute4
809: ,DECODE(p_new_ref_designator ,NULL ,attribute5 ,DECODE(p_new_ref_designator.attribute5
810: ,fnd_api.g_miss_char ,attribute5 ,p_new_ref_designator.attribute5 )) attribute5
811: ,DECODE(p_new_ref_designator ,NULL ,attribute6 ,DECODE(p_new_ref_designator.attribute6
812: ,fnd_api.g_miss_char ,attribute6 ,p_new_ref_designator.attribute6 )) attribute6
813: ,DECODE(p_new_ref_designator ,NULL ,attribute7 ,DECODE(p_new_ref_designator.attribute7
814: ,fnd_api.g_miss_char ,attribute7 ,p_new_ref_designator.attribute7 )) attribute7
815: ,DECODE(p_new_ref_designator ,NULL ,attribute8 ,DECODE(p_new_ref_designator.attribute8
816: ,fnd_api.g_miss_char ,attribute8 ,p_new_ref_designator.attribute8 )) attribute8

Line 814: ,fnd_api.g_miss_char ,attribute7 ,p_new_ref_designator.attribute7 )) attribute7

810: ,fnd_api.g_miss_char ,attribute5 ,p_new_ref_designator.attribute5 )) attribute5
811: ,DECODE(p_new_ref_designator ,NULL ,attribute6 ,DECODE(p_new_ref_designator.attribute6
812: ,fnd_api.g_miss_char ,attribute6 ,p_new_ref_designator.attribute6 )) attribute6
813: ,DECODE(p_new_ref_designator ,NULL ,attribute7 ,DECODE(p_new_ref_designator.attribute7
814: ,fnd_api.g_miss_char ,attribute7 ,p_new_ref_designator.attribute7 )) attribute7
815: ,DECODE(p_new_ref_designator ,NULL ,attribute8 ,DECODE(p_new_ref_designator.attribute8
816: ,fnd_api.g_miss_char ,attribute8 ,p_new_ref_designator.attribute8 )) attribute8
817: ,DECODE(p_new_ref_designator ,NULL ,attribute9 ,DECODE(p_new_ref_designator.attribute9
818: ,fnd_api.g_miss_char ,attribute9 ,p_new_ref_designator.attribute9 )) attribute9

Line 816: ,fnd_api.g_miss_char ,attribute8 ,p_new_ref_designator.attribute8 )) attribute8

812: ,fnd_api.g_miss_char ,attribute6 ,p_new_ref_designator.attribute6 )) attribute6
813: ,DECODE(p_new_ref_designator ,NULL ,attribute7 ,DECODE(p_new_ref_designator.attribute7
814: ,fnd_api.g_miss_char ,attribute7 ,p_new_ref_designator.attribute7 )) attribute7
815: ,DECODE(p_new_ref_designator ,NULL ,attribute8 ,DECODE(p_new_ref_designator.attribute8
816: ,fnd_api.g_miss_char ,attribute8 ,p_new_ref_designator.attribute8 )) attribute8
817: ,DECODE(p_new_ref_designator ,NULL ,attribute9 ,DECODE(p_new_ref_designator.attribute9
818: ,fnd_api.g_miss_char ,attribute9 ,p_new_ref_designator.attribute9 )) attribute9
819: ,DECODE(p_new_ref_designator ,NULL ,attribute10 ,DECODE(p_new_ref_designator.attribute10
820: ,fnd_api.g_miss_char ,attribute10 ,p_new_ref_designator.attribute10 )) attribute10

Line 818: ,fnd_api.g_miss_char ,attribute9 ,p_new_ref_designator.attribute9 )) attribute9

814: ,fnd_api.g_miss_char ,attribute7 ,p_new_ref_designator.attribute7 )) attribute7
815: ,DECODE(p_new_ref_designator ,NULL ,attribute8 ,DECODE(p_new_ref_designator.attribute8
816: ,fnd_api.g_miss_char ,attribute8 ,p_new_ref_designator.attribute8 )) attribute8
817: ,DECODE(p_new_ref_designator ,NULL ,attribute9 ,DECODE(p_new_ref_designator.attribute9
818: ,fnd_api.g_miss_char ,attribute9 ,p_new_ref_designator.attribute9 )) attribute9
819: ,DECODE(p_new_ref_designator ,NULL ,attribute10 ,DECODE(p_new_ref_designator.attribute10
820: ,fnd_api.g_miss_char ,attribute10 ,p_new_ref_designator.attribute10 )) attribute10
821: ,DECODE(p_new_ref_designator ,NULL ,attribute11 ,DECODE(p_new_ref_designator.attribute11
822: ,fnd_api.g_miss_char ,attribute11 ,p_new_ref_designator.attribute11 )) attribute11

Line 820: ,fnd_api.g_miss_char ,attribute10 ,p_new_ref_designator.attribute10 )) attribute10

816: ,fnd_api.g_miss_char ,attribute8 ,p_new_ref_designator.attribute8 )) attribute8
817: ,DECODE(p_new_ref_designator ,NULL ,attribute9 ,DECODE(p_new_ref_designator.attribute9
818: ,fnd_api.g_miss_char ,attribute9 ,p_new_ref_designator.attribute9 )) attribute9
819: ,DECODE(p_new_ref_designator ,NULL ,attribute10 ,DECODE(p_new_ref_designator.attribute10
820: ,fnd_api.g_miss_char ,attribute10 ,p_new_ref_designator.attribute10 )) attribute10
821: ,DECODE(p_new_ref_designator ,NULL ,attribute11 ,DECODE(p_new_ref_designator.attribute11
822: ,fnd_api.g_miss_char ,attribute11 ,p_new_ref_designator.attribute11 )) attribute11
823: ,DECODE(p_new_ref_designator ,NULL ,attribute12 ,DECODE(p_new_ref_designator.attribute12
824: ,fnd_api.g_miss_char ,attribute12 ,p_new_ref_designator.attribute12 )) attribute12

Line 822: ,fnd_api.g_miss_char ,attribute11 ,p_new_ref_designator.attribute11 )) attribute11

818: ,fnd_api.g_miss_char ,attribute9 ,p_new_ref_designator.attribute9 )) attribute9
819: ,DECODE(p_new_ref_designator ,NULL ,attribute10 ,DECODE(p_new_ref_designator.attribute10
820: ,fnd_api.g_miss_char ,attribute10 ,p_new_ref_designator.attribute10 )) attribute10
821: ,DECODE(p_new_ref_designator ,NULL ,attribute11 ,DECODE(p_new_ref_designator.attribute11
822: ,fnd_api.g_miss_char ,attribute11 ,p_new_ref_designator.attribute11 )) attribute11
823: ,DECODE(p_new_ref_designator ,NULL ,attribute12 ,DECODE(p_new_ref_designator.attribute12
824: ,fnd_api.g_miss_char ,attribute12 ,p_new_ref_designator.attribute12 )) attribute12
825: ,DECODE(p_new_ref_designator ,NULL ,attribute13 ,DECODE(p_new_ref_designator.attribute13
826: ,fnd_api.g_miss_char ,attribute13 ,p_new_ref_designator.attribute13 )) attribute13

Line 824: ,fnd_api.g_miss_char ,attribute12 ,p_new_ref_designator.attribute12 )) attribute12

820: ,fnd_api.g_miss_char ,attribute10 ,p_new_ref_designator.attribute10 )) attribute10
821: ,DECODE(p_new_ref_designator ,NULL ,attribute11 ,DECODE(p_new_ref_designator.attribute11
822: ,fnd_api.g_miss_char ,attribute11 ,p_new_ref_designator.attribute11 )) attribute11
823: ,DECODE(p_new_ref_designator ,NULL ,attribute12 ,DECODE(p_new_ref_designator.attribute12
824: ,fnd_api.g_miss_char ,attribute12 ,p_new_ref_designator.attribute12 )) attribute12
825: ,DECODE(p_new_ref_designator ,NULL ,attribute13 ,DECODE(p_new_ref_designator.attribute13
826: ,fnd_api.g_miss_char ,attribute13 ,p_new_ref_designator.attribute13 )) attribute13
827: ,DECODE(p_new_ref_designator ,NULL ,attribute14 ,DECODE(p_new_ref_designator.attribute14
828: ,fnd_api.g_miss_char ,attribute14 ,p_new_ref_designator.attribute14 )) attribute14

Line 826: ,fnd_api.g_miss_char ,attribute13 ,p_new_ref_designator.attribute13 )) attribute13

822: ,fnd_api.g_miss_char ,attribute11 ,p_new_ref_designator.attribute11 )) attribute11
823: ,DECODE(p_new_ref_designator ,NULL ,attribute12 ,DECODE(p_new_ref_designator.attribute12
824: ,fnd_api.g_miss_char ,attribute12 ,p_new_ref_designator.attribute12 )) attribute12
825: ,DECODE(p_new_ref_designator ,NULL ,attribute13 ,DECODE(p_new_ref_designator.attribute13
826: ,fnd_api.g_miss_char ,attribute13 ,p_new_ref_designator.attribute13 )) attribute13
827: ,DECODE(p_new_ref_designator ,NULL ,attribute14 ,DECODE(p_new_ref_designator.attribute14
828: ,fnd_api.g_miss_char ,attribute14 ,p_new_ref_designator.attribute14 )) attribute14
829: ,DECODE(p_new_ref_designator ,NULL ,attribute15 ,DECODE(p_new_ref_designator.attribute15
830: ,fnd_api.g_miss_char ,attribute15 ,p_new_ref_designator.attribute15 )) attribute15

Line 828: ,fnd_api.g_miss_char ,attribute14 ,p_new_ref_designator.attribute14 )) attribute14

824: ,fnd_api.g_miss_char ,attribute12 ,p_new_ref_designator.attribute12 )) attribute12
825: ,DECODE(p_new_ref_designator ,NULL ,attribute13 ,DECODE(p_new_ref_designator.attribute13
826: ,fnd_api.g_miss_char ,attribute13 ,p_new_ref_designator.attribute13 )) attribute13
827: ,DECODE(p_new_ref_designator ,NULL ,attribute14 ,DECODE(p_new_ref_designator.attribute14
828: ,fnd_api.g_miss_char ,attribute14 ,p_new_ref_designator.attribute14 )) attribute14
829: ,DECODE(p_new_ref_designator ,NULL ,attribute15 ,DECODE(p_new_ref_designator.attribute15
830: ,fnd_api.g_miss_char ,attribute15 ,p_new_ref_designator.attribute15 )) attribute15
831: ,DECODE(p_new_ref_designator ,NULL ,original_system_reference ,DECODE(p_new_ref_designator.original_system_reference
832: ,fnd_api.g_miss_char ,original_system_reference ,p_new_ref_designator.original_system_reference)) original_system_reference

Line 830: ,fnd_api.g_miss_char ,attribute15 ,p_new_ref_designator.attribute15 )) attribute15

826: ,fnd_api.g_miss_char ,attribute13 ,p_new_ref_designator.attribute13 )) attribute13
827: ,DECODE(p_new_ref_designator ,NULL ,attribute14 ,DECODE(p_new_ref_designator.attribute14
828: ,fnd_api.g_miss_char ,attribute14 ,p_new_ref_designator.attribute14 )) attribute14
829: ,DECODE(p_new_ref_designator ,NULL ,attribute15 ,DECODE(p_new_ref_designator.attribute15
830: ,fnd_api.g_miss_char ,attribute15 ,p_new_ref_designator.attribute15 )) attribute15
831: ,DECODE(p_new_ref_designator ,NULL ,original_system_reference ,DECODE(p_new_ref_designator.original_system_reference
832: ,fnd_api.g_miss_char ,original_system_reference ,p_new_ref_designator.original_system_reference)) original_system_reference
833: ,DECODE(p_new_ref_designator ,NULL ,ref_designator_comment ,DECODE(p_new_ref_designator.ref_designator_comment
834: ,fnd_api.g_miss_char ,ref_designator_comment ,p_new_ref_designator.ref_designator_comment )) ref_designator_comment

Line 832: ,fnd_api.g_miss_char ,original_system_reference ,p_new_ref_designator.original_system_reference)) original_system_reference

828: ,fnd_api.g_miss_char ,attribute14 ,p_new_ref_designator.attribute14 )) attribute14
829: ,DECODE(p_new_ref_designator ,NULL ,attribute15 ,DECODE(p_new_ref_designator.attribute15
830: ,fnd_api.g_miss_char ,attribute15 ,p_new_ref_designator.attribute15 )) attribute15
831: ,DECODE(p_new_ref_designator ,NULL ,original_system_reference ,DECODE(p_new_ref_designator.original_system_reference
832: ,fnd_api.g_miss_char ,original_system_reference ,p_new_ref_designator.original_system_reference)) original_system_reference
833: ,DECODE(p_new_ref_designator ,NULL ,ref_designator_comment ,DECODE(p_new_ref_designator.ref_designator_comment
834: ,fnd_api.g_miss_char ,ref_designator_comment ,p_new_ref_designator.ref_designator_comment )) ref_designator_comment
835: ,DECODE(p_new_ref_designator ,NULL ,NULL ,p_new_ref_designator.start_effective_date) start_effective_date
836: ,DECODE(p_new_ref_designator ,NULL ,NULL ,p_new_ref_designator.new_reference_designator ) new_reference_designator

Line 834: ,fnd_api.g_miss_char ,ref_designator_comment ,p_new_ref_designator.ref_designator_comment )) ref_designator_comment

830: ,fnd_api.g_miss_char ,attribute15 ,p_new_ref_designator.attribute15 )) attribute15
831: ,DECODE(p_new_ref_designator ,NULL ,original_system_reference ,DECODE(p_new_ref_designator.original_system_reference
832: ,fnd_api.g_miss_char ,original_system_reference ,p_new_ref_designator.original_system_reference)) original_system_reference
833: ,DECODE(p_new_ref_designator ,NULL ,ref_designator_comment ,DECODE(p_new_ref_designator.ref_designator_comment
834: ,fnd_api.g_miss_char ,ref_designator_comment ,p_new_ref_designator.ref_designator_comment )) ref_designator_comment
835: ,DECODE(p_new_ref_designator ,NULL ,NULL ,p_new_ref_designator.start_effective_date) start_effective_date
836: ,DECODE(p_new_ref_designator ,NULL ,NULL ,p_new_ref_designator.new_reference_designator ) new_reference_designator
837: ,DECODE(p_new_ref_designator ,NULL ,NULL ,p_new_ref_designator.from_end_item_unit_number) from_end_item_unit_number
838: ,DECODE(p_new_ref_designator ,NULL ,NULL ,p_new_ref_designator.new_routing_revision) new_routing_revision

Line 858: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

854: l_ref_dsgn_count NUMBER := 1;
855: l_output_status inv_ebi_output_status;
856:
857: BEGIN
858: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
859: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
860: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_reference_designators');
861: OPEN c_comp_sequence_id;
862: FETCH c_comp_sequence_id INTO l_component_sequence_id;

Line 983: WHEN FND_API.g_exc_unexpected_error THEN

979: x_component_item := l_component_item;
980: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_reference_designators');
981:
982: EXCEPTION
983: WHEN FND_API.g_exc_unexpected_error THEN
984: IF c_merged_ref_designators%ISOPEN THEN
985: CLOSE c_merged_ref_designators;
986: END IF;
987: IF c_copied_ref_designators%ISOPEN THEN

Line 990: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

986: END IF;
987: IF c_copied_ref_designators%ISOPEN THEN
988: CLOSE c_copied_ref_designators;
989: END IF;
990: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
991: IF(x_out.output_status.msg_data IS NULL) THEN
992: fnd_msg_pub.count_and_get(
993: p_encoded => FND_API.g_false
994: ,p_count => x_out.output_status.msg_count

Line 993: p_encoded => FND_API.g_false

989: END IF;
990: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
991: IF(x_out.output_status.msg_data IS NULL) THEN
992: fnd_msg_pub.count_and_get(
993: p_encoded => FND_API.g_false
994: ,p_count => x_out.output_status.msg_count
995: ,p_data => x_out.output_status.msg_data
996: );
997: END IF;

Line 1005: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

1001: END IF;
1002: IF c_copied_ref_designators%ISOPEN THEN
1003: CLOSE c_copied_ref_designators;
1004: END IF;
1005: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1006: IF (x_out.output_status.msg_data IS NOT NULL) THEN
1007: x_out.output_status.msg_data := x_out.output_status.msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.prepare_reference_designators ';
1008: ELSE
1009: x_out.output_status.msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.prepare_reference_designators ';

Line 1117: ,fnd_api.g_miss_date ,bic.disable_date ,p_new_comp_item.disable_date)) disable_date

1113: ,p_bill_sequence_id IN NUMBER
1114: ) IS
1115: SELECT
1116: DECODE(p_new_comp_item ,NULL ,bic.disable_date ,DECODE(p_new_comp_item.disable_date
1117: ,fnd_api.g_miss_date ,bic.disable_date ,p_new_comp_item.disable_date)) disable_date
1118: ,DECODE(p_new_comp_item ,NULL ,NVL(bic.acd_type,1) ,DECODE(p_new_comp_item.acd_type
1119: ,fnd_api.g_miss_char ,NVL(bic.acd_type,1) ,p_new_comp_item.acd_type)) acd_type
1120: ,DECODE(p_new_comp_item ,NULL ,bic.basis_type ,DECODE(p_new_comp_item.basis_type
1121: ,fnd_api.g_miss_num ,bic.basis_type ,p_new_comp_item.basis_type)) basis_type

Line 1119: ,fnd_api.g_miss_char ,NVL(bic.acd_type,1) ,p_new_comp_item.acd_type)) acd_type

1115: SELECT
1116: DECODE(p_new_comp_item ,NULL ,bic.disable_date ,DECODE(p_new_comp_item.disable_date
1117: ,fnd_api.g_miss_date ,bic.disable_date ,p_new_comp_item.disable_date)) disable_date
1118: ,DECODE(p_new_comp_item ,NULL ,NVL(bic.acd_type,1) ,DECODE(p_new_comp_item.acd_type
1119: ,fnd_api.g_miss_char ,NVL(bic.acd_type,1) ,p_new_comp_item.acd_type)) acd_type
1120: ,DECODE(p_new_comp_item ,NULL ,bic.basis_type ,DECODE(p_new_comp_item.basis_type
1121: ,fnd_api.g_miss_num ,bic.basis_type ,p_new_comp_item.basis_type)) basis_type
1122: ,DECODE(p_new_comp_item ,NULL ,bic.component_quantity ,DECODE(p_new_comp_item.quantity_per_assembly
1123: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.quantity_per_assembly )) quantity_per_assembly

Line 1121: ,fnd_api.g_miss_num ,bic.basis_type ,p_new_comp_item.basis_type)) basis_type

1117: ,fnd_api.g_miss_date ,bic.disable_date ,p_new_comp_item.disable_date)) disable_date
1118: ,DECODE(p_new_comp_item ,NULL ,NVL(bic.acd_type,1) ,DECODE(p_new_comp_item.acd_type
1119: ,fnd_api.g_miss_char ,NVL(bic.acd_type,1) ,p_new_comp_item.acd_type)) acd_type
1120: ,DECODE(p_new_comp_item ,NULL ,bic.basis_type ,DECODE(p_new_comp_item.basis_type
1121: ,fnd_api.g_miss_num ,bic.basis_type ,p_new_comp_item.basis_type)) basis_type
1122: ,DECODE(p_new_comp_item ,NULL ,bic.component_quantity ,DECODE(p_new_comp_item.quantity_per_assembly
1123: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.quantity_per_assembly )) quantity_per_assembly
1124: ,DECODE(p_new_comp_item ,NULL ,bic.component_quantity ,DECODE(p_new_comp_item.inverse_quantity
1125: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.inverse_quantity )) inverse_quantity

Line 1123: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.quantity_per_assembly )) quantity_per_assembly

1119: ,fnd_api.g_miss_char ,NVL(bic.acd_type,1) ,p_new_comp_item.acd_type)) acd_type
1120: ,DECODE(p_new_comp_item ,NULL ,bic.basis_type ,DECODE(p_new_comp_item.basis_type
1121: ,fnd_api.g_miss_num ,bic.basis_type ,p_new_comp_item.basis_type)) basis_type
1122: ,DECODE(p_new_comp_item ,NULL ,bic.component_quantity ,DECODE(p_new_comp_item.quantity_per_assembly
1123: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.quantity_per_assembly )) quantity_per_assembly
1124: ,DECODE(p_new_comp_item ,NULL ,bic.component_quantity ,DECODE(p_new_comp_item.inverse_quantity
1125: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.inverse_quantity )) inverse_quantity
1126: ,DECODE(p_new_comp_item ,NULL ,bic.include_in_cost_rollup ,DECODE(p_new_comp_item.include_in_cost_rollup
1127: ,fnd_api.g_miss_num ,bic.include_in_cost_rollup ,p_new_comp_item.include_in_cost_rollup)) include_in_cost_rollup

Line 1125: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.inverse_quantity )) inverse_quantity

1121: ,fnd_api.g_miss_num ,bic.basis_type ,p_new_comp_item.basis_type)) basis_type
1122: ,DECODE(p_new_comp_item ,NULL ,bic.component_quantity ,DECODE(p_new_comp_item.quantity_per_assembly
1123: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.quantity_per_assembly )) quantity_per_assembly
1124: ,DECODE(p_new_comp_item ,NULL ,bic.component_quantity ,DECODE(p_new_comp_item.inverse_quantity
1125: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.inverse_quantity )) inverse_quantity
1126: ,DECODE(p_new_comp_item ,NULL ,bic.include_in_cost_rollup ,DECODE(p_new_comp_item.include_in_cost_rollup
1127: ,fnd_api.g_miss_num ,bic.include_in_cost_rollup ,p_new_comp_item.include_in_cost_rollup)) include_in_cost_rollup
1128: ,DECODE(p_new_comp_item ,NULL ,bic.wip_supply_type ,DECODE(p_new_comp_item.wip_supply_type
1129: ,fnd_api.g_miss_num ,bic.wip_supply_type ,p_new_comp_item.wip_supply_type)) wip_supply_type

Line 1127: ,fnd_api.g_miss_num ,bic.include_in_cost_rollup ,p_new_comp_item.include_in_cost_rollup)) include_in_cost_rollup

1123: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.quantity_per_assembly )) quantity_per_assembly
1124: ,DECODE(p_new_comp_item ,NULL ,bic.component_quantity ,DECODE(p_new_comp_item.inverse_quantity
1125: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.inverse_quantity )) inverse_quantity
1126: ,DECODE(p_new_comp_item ,NULL ,bic.include_in_cost_rollup ,DECODE(p_new_comp_item.include_in_cost_rollup
1127: ,fnd_api.g_miss_num ,bic.include_in_cost_rollup ,p_new_comp_item.include_in_cost_rollup)) include_in_cost_rollup
1128: ,DECODE(p_new_comp_item ,NULL ,bic.wip_supply_type ,DECODE(p_new_comp_item.wip_supply_type
1129: ,fnd_api.g_miss_num ,bic.wip_supply_type ,p_new_comp_item.wip_supply_type)) wip_supply_type
1130: ,DECODE(p_new_comp_item ,NULL ,bic.so_basis ,DECODE(p_new_comp_item.so_basis
1131: ,fnd_api.g_miss_num ,bic.so_basis ,p_new_comp_item.so_basis)) so_basis

Line 1129: ,fnd_api.g_miss_num ,bic.wip_supply_type ,p_new_comp_item.wip_supply_type)) wip_supply_type

1125: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.inverse_quantity )) inverse_quantity
1126: ,DECODE(p_new_comp_item ,NULL ,bic.include_in_cost_rollup ,DECODE(p_new_comp_item.include_in_cost_rollup
1127: ,fnd_api.g_miss_num ,bic.include_in_cost_rollup ,p_new_comp_item.include_in_cost_rollup)) include_in_cost_rollup
1128: ,DECODE(p_new_comp_item ,NULL ,bic.wip_supply_type ,DECODE(p_new_comp_item.wip_supply_type
1129: ,fnd_api.g_miss_num ,bic.wip_supply_type ,p_new_comp_item.wip_supply_type)) wip_supply_type
1130: ,DECODE(p_new_comp_item ,NULL ,bic.so_basis ,DECODE(p_new_comp_item.so_basis
1131: ,fnd_api.g_miss_num ,bic.so_basis ,p_new_comp_item.so_basis)) so_basis
1132: ,DECODE(p_new_comp_item ,NULL ,bic.optional ,DECODE(p_new_comp_item.optional
1133: ,fnd_api.g_miss_num ,bic.optional ,p_new_comp_item.optional)) optional

Line 1131: ,fnd_api.g_miss_num ,bic.so_basis ,p_new_comp_item.so_basis)) so_basis

1127: ,fnd_api.g_miss_num ,bic.include_in_cost_rollup ,p_new_comp_item.include_in_cost_rollup)) include_in_cost_rollup
1128: ,DECODE(p_new_comp_item ,NULL ,bic.wip_supply_type ,DECODE(p_new_comp_item.wip_supply_type
1129: ,fnd_api.g_miss_num ,bic.wip_supply_type ,p_new_comp_item.wip_supply_type)) wip_supply_type
1130: ,DECODE(p_new_comp_item ,NULL ,bic.so_basis ,DECODE(p_new_comp_item.so_basis
1131: ,fnd_api.g_miss_num ,bic.so_basis ,p_new_comp_item.so_basis)) so_basis
1132: ,DECODE(p_new_comp_item ,NULL ,bic.optional ,DECODE(p_new_comp_item.optional
1133: ,fnd_api.g_miss_num ,bic.optional ,p_new_comp_item.optional)) optional
1134: ,DECODE(p_new_comp_item ,NULL ,bic.mutually_exclusive_options ,DECODE(p_new_comp_item.mutually_exclusive
1135: ,fnd_api.g_miss_num ,bic.mutually_exclusive_options ,p_new_comp_item.mutually_exclusive)) mutually_exclusive

Line 1133: ,fnd_api.g_miss_num ,bic.optional ,p_new_comp_item.optional)) optional

1129: ,fnd_api.g_miss_num ,bic.wip_supply_type ,p_new_comp_item.wip_supply_type)) wip_supply_type
1130: ,DECODE(p_new_comp_item ,NULL ,bic.so_basis ,DECODE(p_new_comp_item.so_basis
1131: ,fnd_api.g_miss_num ,bic.so_basis ,p_new_comp_item.so_basis)) so_basis
1132: ,DECODE(p_new_comp_item ,NULL ,bic.optional ,DECODE(p_new_comp_item.optional
1133: ,fnd_api.g_miss_num ,bic.optional ,p_new_comp_item.optional)) optional
1134: ,DECODE(p_new_comp_item ,NULL ,bic.mutually_exclusive_options ,DECODE(p_new_comp_item.mutually_exclusive
1135: ,fnd_api.g_miss_num ,bic.mutually_exclusive_options ,p_new_comp_item.mutually_exclusive)) mutually_exclusive
1136: ,DECODE(p_new_comp_item ,NULL ,bic.check_atp ,DECODE(p_new_comp_item.check_atp
1137: ,fnd_api.g_miss_num ,bic.check_atp ,p_new_comp_item.check_atp)) check_atp

Line 1135: ,fnd_api.g_miss_num ,bic.mutually_exclusive_options ,p_new_comp_item.mutually_exclusive)) mutually_exclusive

1131: ,fnd_api.g_miss_num ,bic.so_basis ,p_new_comp_item.so_basis)) so_basis
1132: ,DECODE(p_new_comp_item ,NULL ,bic.optional ,DECODE(p_new_comp_item.optional
1133: ,fnd_api.g_miss_num ,bic.optional ,p_new_comp_item.optional)) optional
1134: ,DECODE(p_new_comp_item ,NULL ,bic.mutually_exclusive_options ,DECODE(p_new_comp_item.mutually_exclusive
1135: ,fnd_api.g_miss_num ,bic.mutually_exclusive_options ,p_new_comp_item.mutually_exclusive)) mutually_exclusive
1136: ,DECODE(p_new_comp_item ,NULL ,bic.check_atp ,DECODE(p_new_comp_item.check_atp
1137: ,fnd_api.g_miss_num ,bic.check_atp ,p_new_comp_item.check_atp)) check_atp
1138: ,DECODE(p_new_comp_item ,NULL ,bic.shipping_allowed ,DECODE(p_new_comp_item.shipping_allowed
1139: ,fnd_api.g_miss_num ,bic.shipping_allowed ,p_new_comp_item.shipping_allowed)) shipping_allowed

Line 1137: ,fnd_api.g_miss_num ,bic.check_atp ,p_new_comp_item.check_atp)) check_atp

1133: ,fnd_api.g_miss_num ,bic.optional ,p_new_comp_item.optional)) optional
1134: ,DECODE(p_new_comp_item ,NULL ,bic.mutually_exclusive_options ,DECODE(p_new_comp_item.mutually_exclusive
1135: ,fnd_api.g_miss_num ,bic.mutually_exclusive_options ,p_new_comp_item.mutually_exclusive)) mutually_exclusive
1136: ,DECODE(p_new_comp_item ,NULL ,bic.check_atp ,DECODE(p_new_comp_item.check_atp
1137: ,fnd_api.g_miss_num ,bic.check_atp ,p_new_comp_item.check_atp)) check_atp
1138: ,DECODE(p_new_comp_item ,NULL ,bic.shipping_allowed ,DECODE(p_new_comp_item.shipping_allowed
1139: ,fnd_api.g_miss_num ,bic.shipping_allowed ,p_new_comp_item.shipping_allowed)) shipping_allowed
1140: ,DECODE(p_new_comp_item ,NULL ,bic.required_to_ship ,DECODE(p_new_comp_item.required_to_ship
1141: ,fnd_api.g_miss_num ,bic.required_to_ship ,p_new_comp_item.required_to_ship)) required_to_ship

Line 1139: ,fnd_api.g_miss_num ,bic.shipping_allowed ,p_new_comp_item.shipping_allowed)) shipping_allowed

1135: ,fnd_api.g_miss_num ,bic.mutually_exclusive_options ,p_new_comp_item.mutually_exclusive)) mutually_exclusive
1136: ,DECODE(p_new_comp_item ,NULL ,bic.check_atp ,DECODE(p_new_comp_item.check_atp
1137: ,fnd_api.g_miss_num ,bic.check_atp ,p_new_comp_item.check_atp)) check_atp
1138: ,DECODE(p_new_comp_item ,NULL ,bic.shipping_allowed ,DECODE(p_new_comp_item.shipping_allowed
1139: ,fnd_api.g_miss_num ,bic.shipping_allowed ,p_new_comp_item.shipping_allowed)) shipping_allowed
1140: ,DECODE(p_new_comp_item ,NULL ,bic.required_to_ship ,DECODE(p_new_comp_item.required_to_ship
1141: ,fnd_api.g_miss_num ,bic.required_to_ship ,p_new_comp_item.required_to_ship)) required_to_ship
1142: ,DECODE(p_new_comp_item ,NULL ,bic.required_for_revenue ,DECODE(p_new_comp_item.required_for_revenue
1143: ,fnd_api.g_miss_num ,bic.required_for_revenue ,p_new_comp_item.required_for_revenue)) required_for_revenue

Line 1141: ,fnd_api.g_miss_num ,bic.required_to_ship ,p_new_comp_item.required_to_ship)) required_to_ship

1137: ,fnd_api.g_miss_num ,bic.check_atp ,p_new_comp_item.check_atp)) check_atp
1138: ,DECODE(p_new_comp_item ,NULL ,bic.shipping_allowed ,DECODE(p_new_comp_item.shipping_allowed
1139: ,fnd_api.g_miss_num ,bic.shipping_allowed ,p_new_comp_item.shipping_allowed)) shipping_allowed
1140: ,DECODE(p_new_comp_item ,NULL ,bic.required_to_ship ,DECODE(p_new_comp_item.required_to_ship
1141: ,fnd_api.g_miss_num ,bic.required_to_ship ,p_new_comp_item.required_to_ship)) required_to_ship
1142: ,DECODE(p_new_comp_item ,NULL ,bic.required_for_revenue ,DECODE(p_new_comp_item.required_for_revenue
1143: ,fnd_api.g_miss_num ,bic.required_for_revenue ,p_new_comp_item.required_for_revenue)) required_for_revenue
1144: ,DECODE(p_new_comp_item ,NULL ,bic.include_on_ship_docs ,DECODE(p_new_comp_item.include_on_ship_docs
1145: ,fnd_api.g_miss_num ,bic.include_on_ship_docs ,p_new_comp_item.include_on_ship_docs)) include_on_ship_docs

Line 1143: ,fnd_api.g_miss_num ,bic.required_for_revenue ,p_new_comp_item.required_for_revenue)) required_for_revenue

1139: ,fnd_api.g_miss_num ,bic.shipping_allowed ,p_new_comp_item.shipping_allowed)) shipping_allowed
1140: ,DECODE(p_new_comp_item ,NULL ,bic.required_to_ship ,DECODE(p_new_comp_item.required_to_ship
1141: ,fnd_api.g_miss_num ,bic.required_to_ship ,p_new_comp_item.required_to_ship)) required_to_ship
1142: ,DECODE(p_new_comp_item ,NULL ,bic.required_for_revenue ,DECODE(p_new_comp_item.required_for_revenue
1143: ,fnd_api.g_miss_num ,bic.required_for_revenue ,p_new_comp_item.required_for_revenue)) required_for_revenue
1144: ,DECODE(p_new_comp_item ,NULL ,bic.include_on_ship_docs ,DECODE(p_new_comp_item.include_on_ship_docs
1145: ,fnd_api.g_miss_num ,bic.include_on_ship_docs ,p_new_comp_item.include_on_ship_docs)) include_on_ship_docs
1146: ,DECODE(p_new_comp_item ,NULL ,bic.quantity_related ,DECODE(p_new_comp_item.quantity_related
1147: ,fnd_api.g_miss_num ,bic.quantity_related ,p_new_comp_item.quantity_related)) quantity_related

Line 1145: ,fnd_api.g_miss_num ,bic.include_on_ship_docs ,p_new_comp_item.include_on_ship_docs)) include_on_ship_docs

1141: ,fnd_api.g_miss_num ,bic.required_to_ship ,p_new_comp_item.required_to_ship)) required_to_ship
1142: ,DECODE(p_new_comp_item ,NULL ,bic.required_for_revenue ,DECODE(p_new_comp_item.required_for_revenue
1143: ,fnd_api.g_miss_num ,bic.required_for_revenue ,p_new_comp_item.required_for_revenue)) required_for_revenue
1144: ,DECODE(p_new_comp_item ,NULL ,bic.include_on_ship_docs ,DECODE(p_new_comp_item.include_on_ship_docs
1145: ,fnd_api.g_miss_num ,bic.include_on_ship_docs ,p_new_comp_item.include_on_ship_docs)) include_on_ship_docs
1146: ,DECODE(p_new_comp_item ,NULL ,bic.quantity_related ,DECODE(p_new_comp_item.quantity_related
1147: ,fnd_api.g_miss_num ,bic.quantity_related ,p_new_comp_item.quantity_related)) quantity_related
1148: ,DECODE(p_new_comp_item ,NULL ,bic.supply_subinventory ,DECODE(p_new_comp_item.supply_subinventory
1149: ,fnd_api.g_miss_char ,bic.supply_subinventory ,p_new_comp_item.supply_subinventory)) supply_subinventory

Line 1147: ,fnd_api.g_miss_num ,bic.quantity_related ,p_new_comp_item.quantity_related)) quantity_related

1143: ,fnd_api.g_miss_num ,bic.required_for_revenue ,p_new_comp_item.required_for_revenue)) required_for_revenue
1144: ,DECODE(p_new_comp_item ,NULL ,bic.include_on_ship_docs ,DECODE(p_new_comp_item.include_on_ship_docs
1145: ,fnd_api.g_miss_num ,bic.include_on_ship_docs ,p_new_comp_item.include_on_ship_docs)) include_on_ship_docs
1146: ,DECODE(p_new_comp_item ,NULL ,bic.quantity_related ,DECODE(p_new_comp_item.quantity_related
1147: ,fnd_api.g_miss_num ,bic.quantity_related ,p_new_comp_item.quantity_related)) quantity_related
1148: ,DECODE(p_new_comp_item ,NULL ,bic.supply_subinventory ,DECODE(p_new_comp_item.supply_subinventory
1149: ,fnd_api.g_miss_char ,bic.supply_subinventory ,p_new_comp_item.supply_subinventory)) supply_subinventory
1150: ,DECODE(p_new_comp_item ,NULL ,bic.attribute_category ,DECODE(p_new_comp_item.attribute_category
1151: ,fnd_api.g_miss_char ,bic.attribute_category ,p_new_comp_item.attribute_category)) attribute_category

Line 1149: ,fnd_api.g_miss_char ,bic.supply_subinventory ,p_new_comp_item.supply_subinventory)) supply_subinventory

1145: ,fnd_api.g_miss_num ,bic.include_on_ship_docs ,p_new_comp_item.include_on_ship_docs)) include_on_ship_docs
1146: ,DECODE(p_new_comp_item ,NULL ,bic.quantity_related ,DECODE(p_new_comp_item.quantity_related
1147: ,fnd_api.g_miss_num ,bic.quantity_related ,p_new_comp_item.quantity_related)) quantity_related
1148: ,DECODE(p_new_comp_item ,NULL ,bic.supply_subinventory ,DECODE(p_new_comp_item.supply_subinventory
1149: ,fnd_api.g_miss_char ,bic.supply_subinventory ,p_new_comp_item.supply_subinventory)) supply_subinventory
1150: ,DECODE(p_new_comp_item ,NULL ,bic.attribute_category ,DECODE(p_new_comp_item.attribute_category
1151: ,fnd_api.g_miss_char ,bic.attribute_category ,p_new_comp_item.attribute_category)) attribute_category
1152: ,DECODE(p_new_comp_item ,NULL ,bic.attribute1 ,DECODE(p_new_comp_item.attribute1
1153: ,fnd_api.g_miss_char ,bic.attribute1 ,p_new_comp_item.attribute1)) attribute1

Line 1151: ,fnd_api.g_miss_char ,bic.attribute_category ,p_new_comp_item.attribute_category)) attribute_category

1147: ,fnd_api.g_miss_num ,bic.quantity_related ,p_new_comp_item.quantity_related)) quantity_related
1148: ,DECODE(p_new_comp_item ,NULL ,bic.supply_subinventory ,DECODE(p_new_comp_item.supply_subinventory
1149: ,fnd_api.g_miss_char ,bic.supply_subinventory ,p_new_comp_item.supply_subinventory)) supply_subinventory
1150: ,DECODE(p_new_comp_item ,NULL ,bic.attribute_category ,DECODE(p_new_comp_item.attribute_category
1151: ,fnd_api.g_miss_char ,bic.attribute_category ,p_new_comp_item.attribute_category)) attribute_category
1152: ,DECODE(p_new_comp_item ,NULL ,bic.attribute1 ,DECODE(p_new_comp_item.attribute1
1153: ,fnd_api.g_miss_char ,bic.attribute1 ,p_new_comp_item.attribute1)) attribute1
1154: ,DECODE(p_new_comp_item ,NULL ,bic.attribute2 ,DECODE(p_new_comp_item.attribute2
1155: ,fnd_api.g_miss_char ,bic.attribute2 ,p_new_comp_item.attribute2)) attribute2

Line 1153: ,fnd_api.g_miss_char ,bic.attribute1 ,p_new_comp_item.attribute1)) attribute1

1149: ,fnd_api.g_miss_char ,bic.supply_subinventory ,p_new_comp_item.supply_subinventory)) supply_subinventory
1150: ,DECODE(p_new_comp_item ,NULL ,bic.attribute_category ,DECODE(p_new_comp_item.attribute_category
1151: ,fnd_api.g_miss_char ,bic.attribute_category ,p_new_comp_item.attribute_category)) attribute_category
1152: ,DECODE(p_new_comp_item ,NULL ,bic.attribute1 ,DECODE(p_new_comp_item.attribute1
1153: ,fnd_api.g_miss_char ,bic.attribute1 ,p_new_comp_item.attribute1)) attribute1
1154: ,DECODE(p_new_comp_item ,NULL ,bic.attribute2 ,DECODE(p_new_comp_item.attribute2
1155: ,fnd_api.g_miss_char ,bic.attribute2 ,p_new_comp_item.attribute2)) attribute2
1156: ,DECODE(p_new_comp_item ,NULL ,bic.attribute3 ,DECODE(p_new_comp_item.attribute3
1157: ,fnd_api.g_miss_char ,bic.attribute3 ,p_new_comp_item.attribute3)) attribute3

Line 1155: ,fnd_api.g_miss_char ,bic.attribute2 ,p_new_comp_item.attribute2)) attribute2

1151: ,fnd_api.g_miss_char ,bic.attribute_category ,p_new_comp_item.attribute_category)) attribute_category
1152: ,DECODE(p_new_comp_item ,NULL ,bic.attribute1 ,DECODE(p_new_comp_item.attribute1
1153: ,fnd_api.g_miss_char ,bic.attribute1 ,p_new_comp_item.attribute1)) attribute1
1154: ,DECODE(p_new_comp_item ,NULL ,bic.attribute2 ,DECODE(p_new_comp_item.attribute2
1155: ,fnd_api.g_miss_char ,bic.attribute2 ,p_new_comp_item.attribute2)) attribute2
1156: ,DECODE(p_new_comp_item ,NULL ,bic.attribute3 ,DECODE(p_new_comp_item.attribute3
1157: ,fnd_api.g_miss_char ,bic.attribute3 ,p_new_comp_item.attribute3)) attribute3
1158: ,DECODE(p_new_comp_item ,NULL ,bic.attribute4 ,DECODE(p_new_comp_item.attribute4
1159: ,fnd_api.g_miss_char ,bic.attribute4 ,p_new_comp_item.attribute4)) attribute4

Line 1157: ,fnd_api.g_miss_char ,bic.attribute3 ,p_new_comp_item.attribute3)) attribute3

1153: ,fnd_api.g_miss_char ,bic.attribute1 ,p_new_comp_item.attribute1)) attribute1
1154: ,DECODE(p_new_comp_item ,NULL ,bic.attribute2 ,DECODE(p_new_comp_item.attribute2
1155: ,fnd_api.g_miss_char ,bic.attribute2 ,p_new_comp_item.attribute2)) attribute2
1156: ,DECODE(p_new_comp_item ,NULL ,bic.attribute3 ,DECODE(p_new_comp_item.attribute3
1157: ,fnd_api.g_miss_char ,bic.attribute3 ,p_new_comp_item.attribute3)) attribute3
1158: ,DECODE(p_new_comp_item ,NULL ,bic.attribute4 ,DECODE(p_new_comp_item.attribute4
1159: ,fnd_api.g_miss_char ,bic.attribute4 ,p_new_comp_item.attribute4)) attribute4
1160: ,DECODE(p_new_comp_item ,NULL ,bic.attribute5 ,DECODE(p_new_comp_item.attribute5
1161: ,fnd_api.g_miss_char ,bic.attribute5 ,p_new_comp_item.attribute5)) attribute5

Line 1159: ,fnd_api.g_miss_char ,bic.attribute4 ,p_new_comp_item.attribute4)) attribute4

1155: ,fnd_api.g_miss_char ,bic.attribute2 ,p_new_comp_item.attribute2)) attribute2
1156: ,DECODE(p_new_comp_item ,NULL ,bic.attribute3 ,DECODE(p_new_comp_item.attribute3
1157: ,fnd_api.g_miss_char ,bic.attribute3 ,p_new_comp_item.attribute3)) attribute3
1158: ,DECODE(p_new_comp_item ,NULL ,bic.attribute4 ,DECODE(p_new_comp_item.attribute4
1159: ,fnd_api.g_miss_char ,bic.attribute4 ,p_new_comp_item.attribute4)) attribute4
1160: ,DECODE(p_new_comp_item ,NULL ,bic.attribute5 ,DECODE(p_new_comp_item.attribute5
1161: ,fnd_api.g_miss_char ,bic.attribute5 ,p_new_comp_item.attribute5)) attribute5
1162: ,DECODE(p_new_comp_item ,NULL ,bic.attribute6 ,DECODE(p_new_comp_item.attribute6
1163: ,fnd_api.g_miss_char ,bic.attribute6 ,p_new_comp_item.attribute6)) attribute6

Line 1161: ,fnd_api.g_miss_char ,bic.attribute5 ,p_new_comp_item.attribute5)) attribute5

1157: ,fnd_api.g_miss_char ,bic.attribute3 ,p_new_comp_item.attribute3)) attribute3
1158: ,DECODE(p_new_comp_item ,NULL ,bic.attribute4 ,DECODE(p_new_comp_item.attribute4
1159: ,fnd_api.g_miss_char ,bic.attribute4 ,p_new_comp_item.attribute4)) attribute4
1160: ,DECODE(p_new_comp_item ,NULL ,bic.attribute5 ,DECODE(p_new_comp_item.attribute5
1161: ,fnd_api.g_miss_char ,bic.attribute5 ,p_new_comp_item.attribute5)) attribute5
1162: ,DECODE(p_new_comp_item ,NULL ,bic.attribute6 ,DECODE(p_new_comp_item.attribute6
1163: ,fnd_api.g_miss_char ,bic.attribute6 ,p_new_comp_item.attribute6)) attribute6
1164: ,DECODE(p_new_comp_item ,NULL ,bic.attribute7 ,DECODE(p_new_comp_item.attribute7
1165: ,fnd_api.g_miss_char ,bic.attribute7 ,p_new_comp_item.attribute7)) attribute7

Line 1163: ,fnd_api.g_miss_char ,bic.attribute6 ,p_new_comp_item.attribute6)) attribute6

1159: ,fnd_api.g_miss_char ,bic.attribute4 ,p_new_comp_item.attribute4)) attribute4
1160: ,DECODE(p_new_comp_item ,NULL ,bic.attribute5 ,DECODE(p_new_comp_item.attribute5
1161: ,fnd_api.g_miss_char ,bic.attribute5 ,p_new_comp_item.attribute5)) attribute5
1162: ,DECODE(p_new_comp_item ,NULL ,bic.attribute6 ,DECODE(p_new_comp_item.attribute6
1163: ,fnd_api.g_miss_char ,bic.attribute6 ,p_new_comp_item.attribute6)) attribute6
1164: ,DECODE(p_new_comp_item ,NULL ,bic.attribute7 ,DECODE(p_new_comp_item.attribute7
1165: ,fnd_api.g_miss_char ,bic.attribute7 ,p_new_comp_item.attribute7)) attribute7
1166: ,DECODE(p_new_comp_item ,NULL ,bic.attribute8 ,DECODE(p_new_comp_item.attribute8
1167: ,fnd_api.g_miss_char ,bic.attribute8 ,p_new_comp_item.attribute8)) attribute8

Line 1165: ,fnd_api.g_miss_char ,bic.attribute7 ,p_new_comp_item.attribute7)) attribute7

1161: ,fnd_api.g_miss_char ,bic.attribute5 ,p_new_comp_item.attribute5)) attribute5
1162: ,DECODE(p_new_comp_item ,NULL ,bic.attribute6 ,DECODE(p_new_comp_item.attribute6
1163: ,fnd_api.g_miss_char ,bic.attribute6 ,p_new_comp_item.attribute6)) attribute6
1164: ,DECODE(p_new_comp_item ,NULL ,bic.attribute7 ,DECODE(p_new_comp_item.attribute7
1165: ,fnd_api.g_miss_char ,bic.attribute7 ,p_new_comp_item.attribute7)) attribute7
1166: ,DECODE(p_new_comp_item ,NULL ,bic.attribute8 ,DECODE(p_new_comp_item.attribute8
1167: ,fnd_api.g_miss_char ,bic.attribute8 ,p_new_comp_item.attribute8)) attribute8
1168: ,DECODE(p_new_comp_item ,NULL ,bic.attribute9 ,DECODE(p_new_comp_item.attribute9
1169: ,fnd_api.g_miss_char ,bic.attribute9 ,p_new_comp_item.attribute9)) attribute9

Line 1167: ,fnd_api.g_miss_char ,bic.attribute8 ,p_new_comp_item.attribute8)) attribute8

1163: ,fnd_api.g_miss_char ,bic.attribute6 ,p_new_comp_item.attribute6)) attribute6
1164: ,DECODE(p_new_comp_item ,NULL ,bic.attribute7 ,DECODE(p_new_comp_item.attribute7
1165: ,fnd_api.g_miss_char ,bic.attribute7 ,p_new_comp_item.attribute7)) attribute7
1166: ,DECODE(p_new_comp_item ,NULL ,bic.attribute8 ,DECODE(p_new_comp_item.attribute8
1167: ,fnd_api.g_miss_char ,bic.attribute8 ,p_new_comp_item.attribute8)) attribute8
1168: ,DECODE(p_new_comp_item ,NULL ,bic.attribute9 ,DECODE(p_new_comp_item.attribute9
1169: ,fnd_api.g_miss_char ,bic.attribute9 ,p_new_comp_item.attribute9)) attribute9
1170: ,DECODE(p_new_comp_item ,NULL ,bic.attribute10 ,DECODE(p_new_comp_item.attribute10
1171: ,fnd_api.g_miss_char ,bic.attribute10 ,p_new_comp_item.attribute10)) attribute10

Line 1169: ,fnd_api.g_miss_char ,bic.attribute9 ,p_new_comp_item.attribute9)) attribute9

1165: ,fnd_api.g_miss_char ,bic.attribute7 ,p_new_comp_item.attribute7)) attribute7
1166: ,DECODE(p_new_comp_item ,NULL ,bic.attribute8 ,DECODE(p_new_comp_item.attribute8
1167: ,fnd_api.g_miss_char ,bic.attribute8 ,p_new_comp_item.attribute8)) attribute8
1168: ,DECODE(p_new_comp_item ,NULL ,bic.attribute9 ,DECODE(p_new_comp_item.attribute9
1169: ,fnd_api.g_miss_char ,bic.attribute9 ,p_new_comp_item.attribute9)) attribute9
1170: ,DECODE(p_new_comp_item ,NULL ,bic.attribute10 ,DECODE(p_new_comp_item.attribute10
1171: ,fnd_api.g_miss_char ,bic.attribute10 ,p_new_comp_item.attribute10)) attribute10
1172: ,DECODE(p_new_comp_item ,NULL ,bic.attribute11 ,DECODE(p_new_comp_item.attribute11
1173: ,fnd_api.g_miss_char ,bic.attribute11 ,p_new_comp_item.attribute11)) attribute11

Line 1171: ,fnd_api.g_miss_char ,bic.attribute10 ,p_new_comp_item.attribute10)) attribute10

1167: ,fnd_api.g_miss_char ,bic.attribute8 ,p_new_comp_item.attribute8)) attribute8
1168: ,DECODE(p_new_comp_item ,NULL ,bic.attribute9 ,DECODE(p_new_comp_item.attribute9
1169: ,fnd_api.g_miss_char ,bic.attribute9 ,p_new_comp_item.attribute9)) attribute9
1170: ,DECODE(p_new_comp_item ,NULL ,bic.attribute10 ,DECODE(p_new_comp_item.attribute10
1171: ,fnd_api.g_miss_char ,bic.attribute10 ,p_new_comp_item.attribute10)) attribute10
1172: ,DECODE(p_new_comp_item ,NULL ,bic.attribute11 ,DECODE(p_new_comp_item.attribute11
1173: ,fnd_api.g_miss_char ,bic.attribute11 ,p_new_comp_item.attribute11)) attribute11
1174: ,DECODE(p_new_comp_item ,NULL ,bic.attribute12 ,DECODE(p_new_comp_item.attribute12
1175: ,fnd_api.g_miss_char ,bic.attribute12 ,p_new_comp_item.attribute12)) attribute12

Line 1173: ,fnd_api.g_miss_char ,bic.attribute11 ,p_new_comp_item.attribute11)) attribute11

1169: ,fnd_api.g_miss_char ,bic.attribute9 ,p_new_comp_item.attribute9)) attribute9
1170: ,DECODE(p_new_comp_item ,NULL ,bic.attribute10 ,DECODE(p_new_comp_item.attribute10
1171: ,fnd_api.g_miss_char ,bic.attribute10 ,p_new_comp_item.attribute10)) attribute10
1172: ,DECODE(p_new_comp_item ,NULL ,bic.attribute11 ,DECODE(p_new_comp_item.attribute11
1173: ,fnd_api.g_miss_char ,bic.attribute11 ,p_new_comp_item.attribute11)) attribute11
1174: ,DECODE(p_new_comp_item ,NULL ,bic.attribute12 ,DECODE(p_new_comp_item.attribute12
1175: ,fnd_api.g_miss_char ,bic.attribute12 ,p_new_comp_item.attribute12)) attribute12
1176: ,DECODE(p_new_comp_item ,NULL ,bic.attribute13 ,DECODE(p_new_comp_item.attribute13
1177: ,fnd_api.g_miss_char ,bic.attribute13 ,p_new_comp_item.attribute13)) attribute13

Line 1175: ,fnd_api.g_miss_char ,bic.attribute12 ,p_new_comp_item.attribute12)) attribute12

1171: ,fnd_api.g_miss_char ,bic.attribute10 ,p_new_comp_item.attribute10)) attribute10
1172: ,DECODE(p_new_comp_item ,NULL ,bic.attribute11 ,DECODE(p_new_comp_item.attribute11
1173: ,fnd_api.g_miss_char ,bic.attribute11 ,p_new_comp_item.attribute11)) attribute11
1174: ,DECODE(p_new_comp_item ,NULL ,bic.attribute12 ,DECODE(p_new_comp_item.attribute12
1175: ,fnd_api.g_miss_char ,bic.attribute12 ,p_new_comp_item.attribute12)) attribute12
1176: ,DECODE(p_new_comp_item ,NULL ,bic.attribute13 ,DECODE(p_new_comp_item.attribute13
1177: ,fnd_api.g_miss_char ,bic.attribute13 ,p_new_comp_item.attribute13)) attribute13
1178: ,DECODE(p_new_comp_item ,NULL ,bic.attribute14 ,DECODE(p_new_comp_item.attribute14
1179: ,fnd_api.g_miss_char ,bic.attribute14 ,p_new_comp_item.attribute14)) attribute14

Line 1177: ,fnd_api.g_miss_char ,bic.attribute13 ,p_new_comp_item.attribute13)) attribute13

1173: ,fnd_api.g_miss_char ,bic.attribute11 ,p_new_comp_item.attribute11)) attribute11
1174: ,DECODE(p_new_comp_item ,NULL ,bic.attribute12 ,DECODE(p_new_comp_item.attribute12
1175: ,fnd_api.g_miss_char ,bic.attribute12 ,p_new_comp_item.attribute12)) attribute12
1176: ,DECODE(p_new_comp_item ,NULL ,bic.attribute13 ,DECODE(p_new_comp_item.attribute13
1177: ,fnd_api.g_miss_char ,bic.attribute13 ,p_new_comp_item.attribute13)) attribute13
1178: ,DECODE(p_new_comp_item ,NULL ,bic.attribute14 ,DECODE(p_new_comp_item.attribute14
1179: ,fnd_api.g_miss_char ,bic.attribute14 ,p_new_comp_item.attribute14)) attribute14
1180: ,DECODE(p_new_comp_item ,NULL ,bic.attribute15 ,DECODE(p_new_comp_item.attribute15
1181: ,fnd_api.g_miss_char ,bic.attribute15 ,p_new_comp_item.attribute15)) attribute15

Line 1179: ,fnd_api.g_miss_char ,bic.attribute14 ,p_new_comp_item.attribute14)) attribute14

1175: ,fnd_api.g_miss_char ,bic.attribute12 ,p_new_comp_item.attribute12)) attribute12
1176: ,DECODE(p_new_comp_item ,NULL ,bic.attribute13 ,DECODE(p_new_comp_item.attribute13
1177: ,fnd_api.g_miss_char ,bic.attribute13 ,p_new_comp_item.attribute13)) attribute13
1178: ,DECODE(p_new_comp_item ,NULL ,bic.attribute14 ,DECODE(p_new_comp_item.attribute14
1179: ,fnd_api.g_miss_char ,bic.attribute14 ,p_new_comp_item.attribute14)) attribute14
1180: ,DECODE(p_new_comp_item ,NULL ,bic.attribute15 ,DECODE(p_new_comp_item.attribute15
1181: ,fnd_api.g_miss_char ,bic.attribute15 ,p_new_comp_item.attribute15)) attribute15
1182: ,DECODE(p_new_comp_item ,NULL ,bic.from_end_item_unit_number ,DECODE(p_new_comp_item.from_end_item_unit_number
1183: ,fnd_api.g_miss_char ,bic.from_end_item_unit_number ,p_new_comp_item.from_end_item_unit_number)) from_end_item_unit_number

Line 1181: ,fnd_api.g_miss_char ,bic.attribute15 ,p_new_comp_item.attribute15)) attribute15

1177: ,fnd_api.g_miss_char ,bic.attribute13 ,p_new_comp_item.attribute13)) attribute13
1178: ,DECODE(p_new_comp_item ,NULL ,bic.attribute14 ,DECODE(p_new_comp_item.attribute14
1179: ,fnd_api.g_miss_char ,bic.attribute14 ,p_new_comp_item.attribute14)) attribute14
1180: ,DECODE(p_new_comp_item ,NULL ,bic.attribute15 ,DECODE(p_new_comp_item.attribute15
1181: ,fnd_api.g_miss_char ,bic.attribute15 ,p_new_comp_item.attribute15)) attribute15
1182: ,DECODE(p_new_comp_item ,NULL ,bic.from_end_item_unit_number ,DECODE(p_new_comp_item.from_end_item_unit_number
1183: ,fnd_api.g_miss_char ,bic.from_end_item_unit_number ,p_new_comp_item.from_end_item_unit_number)) from_end_item_unit_number
1184: ,DECODE(p_new_comp_item ,NULL ,bic.to_end_item_unit_number ,DECODE(p_new_comp_item.to_end_item_unit_number
1185: ,fnd_api.g_miss_char ,bic.to_end_item_unit_number ,p_new_comp_item.to_end_item_unit_number)) to_end_item_unit_number

Line 1183: ,fnd_api.g_miss_char ,bic.from_end_item_unit_number ,p_new_comp_item.from_end_item_unit_number)) from_end_item_unit_number

1179: ,fnd_api.g_miss_char ,bic.attribute14 ,p_new_comp_item.attribute14)) attribute14
1180: ,DECODE(p_new_comp_item ,NULL ,bic.attribute15 ,DECODE(p_new_comp_item.attribute15
1181: ,fnd_api.g_miss_char ,bic.attribute15 ,p_new_comp_item.attribute15)) attribute15
1182: ,DECODE(p_new_comp_item ,NULL ,bic.from_end_item_unit_number ,DECODE(p_new_comp_item.from_end_item_unit_number
1183: ,fnd_api.g_miss_char ,bic.from_end_item_unit_number ,p_new_comp_item.from_end_item_unit_number)) from_end_item_unit_number
1184: ,DECODE(p_new_comp_item ,NULL ,bic.to_end_item_unit_number ,DECODE(p_new_comp_item.to_end_item_unit_number
1185: ,fnd_api.g_miss_char ,bic.to_end_item_unit_number ,p_new_comp_item.to_end_item_unit_number)) to_end_item_unit_number
1186: ,DECODE(p_new_comp_item ,NULL ,bic.enforce_int_requirements ,DECODE(p_new_comp_item.enforce_int_requirements
1187: ,fnd_api.g_miss_char ,bic.enforce_int_requirements ,p_new_comp_item.enforce_int_requirements)) enforce_int_requirements

Line 1185: ,fnd_api.g_miss_char ,bic.to_end_item_unit_number ,p_new_comp_item.to_end_item_unit_number)) to_end_item_unit_number

1181: ,fnd_api.g_miss_char ,bic.attribute15 ,p_new_comp_item.attribute15)) attribute15
1182: ,DECODE(p_new_comp_item ,NULL ,bic.from_end_item_unit_number ,DECODE(p_new_comp_item.from_end_item_unit_number
1183: ,fnd_api.g_miss_char ,bic.from_end_item_unit_number ,p_new_comp_item.from_end_item_unit_number)) from_end_item_unit_number
1184: ,DECODE(p_new_comp_item ,NULL ,bic.to_end_item_unit_number ,DECODE(p_new_comp_item.to_end_item_unit_number
1185: ,fnd_api.g_miss_char ,bic.to_end_item_unit_number ,p_new_comp_item.to_end_item_unit_number)) to_end_item_unit_number
1186: ,DECODE(p_new_comp_item ,NULL ,bic.enforce_int_requirements ,DECODE(p_new_comp_item.enforce_int_requirements
1187: ,fnd_api.g_miss_char ,bic.enforce_int_requirements ,p_new_comp_item.enforce_int_requirements)) enforce_int_requirements
1188: ,DECODE(p_new_comp_item ,NULL ,bic.auto_request_material ,DECODE(p_new_comp_item.auto_request_material
1189: ,fnd_api.g_miss_char ,bic.auto_request_material ,p_new_comp_item.auto_request_material)) auto_request_material

Line 1187: ,fnd_api.g_miss_char ,bic.enforce_int_requirements ,p_new_comp_item.enforce_int_requirements)) enforce_int_requirements

1183: ,fnd_api.g_miss_char ,bic.from_end_item_unit_number ,p_new_comp_item.from_end_item_unit_number)) from_end_item_unit_number
1184: ,DECODE(p_new_comp_item ,NULL ,bic.to_end_item_unit_number ,DECODE(p_new_comp_item.to_end_item_unit_number
1185: ,fnd_api.g_miss_char ,bic.to_end_item_unit_number ,p_new_comp_item.to_end_item_unit_number)) to_end_item_unit_number
1186: ,DECODE(p_new_comp_item ,NULL ,bic.enforce_int_requirements ,DECODE(p_new_comp_item.enforce_int_requirements
1187: ,fnd_api.g_miss_char ,bic.enforce_int_requirements ,p_new_comp_item.enforce_int_requirements)) enforce_int_requirements
1188: ,DECODE(p_new_comp_item ,NULL ,bic.auto_request_material ,DECODE(p_new_comp_item.auto_request_material
1189: ,fnd_api.g_miss_char ,bic.auto_request_material ,p_new_comp_item.auto_request_material)) auto_request_material
1190: ,DECODE(p_new_comp_item ,NULL ,bic.suggested_vendor_name ,DECODE(p_new_comp_item.suggested_vendor_name
1191: ,fnd_api.g_miss_char ,bic.suggested_vendor_name ,p_new_comp_item.suggested_vendor_name)) suggested_vendor_name

Line 1189: ,fnd_api.g_miss_char ,bic.auto_request_material ,p_new_comp_item.auto_request_material)) auto_request_material

1185: ,fnd_api.g_miss_char ,bic.to_end_item_unit_number ,p_new_comp_item.to_end_item_unit_number)) to_end_item_unit_number
1186: ,DECODE(p_new_comp_item ,NULL ,bic.enforce_int_requirements ,DECODE(p_new_comp_item.enforce_int_requirements
1187: ,fnd_api.g_miss_char ,bic.enforce_int_requirements ,p_new_comp_item.enforce_int_requirements)) enforce_int_requirements
1188: ,DECODE(p_new_comp_item ,NULL ,bic.auto_request_material ,DECODE(p_new_comp_item.auto_request_material
1189: ,fnd_api.g_miss_char ,bic.auto_request_material ,p_new_comp_item.auto_request_material)) auto_request_material
1190: ,DECODE(p_new_comp_item ,NULL ,bic.suggested_vendor_name ,DECODE(p_new_comp_item.suggested_vendor_name
1191: ,fnd_api.g_miss_char ,bic.suggested_vendor_name ,p_new_comp_item.suggested_vendor_name)) suggested_vendor_name
1192: ,DECODE(p_new_comp_item ,NULL ,bic.unit_price ,DECODE(p_new_comp_item.unit_price
1193: ,fnd_api.g_miss_num ,bic.unit_price ,p_new_comp_item.unit_price)) unit_price

Line 1191: ,fnd_api.g_miss_char ,bic.suggested_vendor_name ,p_new_comp_item.suggested_vendor_name)) suggested_vendor_name

1187: ,fnd_api.g_miss_char ,bic.enforce_int_requirements ,p_new_comp_item.enforce_int_requirements)) enforce_int_requirements
1188: ,DECODE(p_new_comp_item ,NULL ,bic.auto_request_material ,DECODE(p_new_comp_item.auto_request_material
1189: ,fnd_api.g_miss_char ,bic.auto_request_material ,p_new_comp_item.auto_request_material)) auto_request_material
1190: ,DECODE(p_new_comp_item ,NULL ,bic.suggested_vendor_name ,DECODE(p_new_comp_item.suggested_vendor_name
1191: ,fnd_api.g_miss_char ,bic.suggested_vendor_name ,p_new_comp_item.suggested_vendor_name)) suggested_vendor_name
1192: ,DECODE(p_new_comp_item ,NULL ,bic.unit_price ,DECODE(p_new_comp_item.unit_price
1193: ,fnd_api.g_miss_num ,bic.unit_price ,p_new_comp_item.unit_price)) unit_price
1194: ,DECODE(p_new_comp_item ,NULL ,bic.original_system_reference ,DECODE(p_new_comp_item.original_system_reference
1195: ,fnd_api.g_miss_num ,bic.original_system_reference ,p_new_comp_item.original_system_reference)) original_system_reference

Line 1193: ,fnd_api.g_miss_num ,bic.unit_price ,p_new_comp_item.unit_price)) unit_price

1189: ,fnd_api.g_miss_char ,bic.auto_request_material ,p_new_comp_item.auto_request_material)) auto_request_material
1190: ,DECODE(p_new_comp_item ,NULL ,bic.suggested_vendor_name ,DECODE(p_new_comp_item.suggested_vendor_name
1191: ,fnd_api.g_miss_char ,bic.suggested_vendor_name ,p_new_comp_item.suggested_vendor_name)) suggested_vendor_name
1192: ,DECODE(p_new_comp_item ,NULL ,bic.unit_price ,DECODE(p_new_comp_item.unit_price
1193: ,fnd_api.g_miss_num ,bic.unit_price ,p_new_comp_item.unit_price)) unit_price
1194: ,DECODE(p_new_comp_item ,NULL ,bic.original_system_reference ,DECODE(p_new_comp_item.original_system_reference
1195: ,fnd_api.g_miss_num ,bic.original_system_reference ,p_new_comp_item.original_system_reference)) original_system_reference
1196: ,DECODE(p_new_comp_item ,NULL ,SYSDATE ,DECODE(p_new_comp_item.start_effective_date
1197: ,fnd_api.g_miss_date ,bic.effectivity_date ,p_new_comp_item.start_effective_date)) start_effective_date

Line 1195: ,fnd_api.g_miss_num ,bic.original_system_reference ,p_new_comp_item.original_system_reference)) original_system_reference

1191: ,fnd_api.g_miss_char ,bic.suggested_vendor_name ,p_new_comp_item.suggested_vendor_name)) suggested_vendor_name
1192: ,DECODE(p_new_comp_item ,NULL ,bic.unit_price ,DECODE(p_new_comp_item.unit_price
1193: ,fnd_api.g_miss_num ,bic.unit_price ,p_new_comp_item.unit_price)) unit_price
1194: ,DECODE(p_new_comp_item ,NULL ,bic.original_system_reference ,DECODE(p_new_comp_item.original_system_reference
1195: ,fnd_api.g_miss_num ,bic.original_system_reference ,p_new_comp_item.original_system_reference)) original_system_reference
1196: ,DECODE(p_new_comp_item ,NULL ,SYSDATE ,DECODE(p_new_comp_item.start_effective_date
1197: ,fnd_api.g_miss_date ,bic.effectivity_date ,p_new_comp_item.start_effective_date)) start_effective_date
1198: ,DECODE(p_new_comp_item ,NULL ,bic.item_num ,DECODE(p_new_comp_item.item_sequence_number
1199: ,fnd_api.g_miss_num ,bic.item_num ,p_new_comp_item.item_sequence_number)) item_sequence_number

Line 1197: ,fnd_api.g_miss_date ,bic.effectivity_date ,p_new_comp_item.start_effective_date)) start_effective_date

1193: ,fnd_api.g_miss_num ,bic.unit_price ,p_new_comp_item.unit_price)) unit_price
1194: ,DECODE(p_new_comp_item ,NULL ,bic.original_system_reference ,DECODE(p_new_comp_item.original_system_reference
1195: ,fnd_api.g_miss_num ,bic.original_system_reference ,p_new_comp_item.original_system_reference)) original_system_reference
1196: ,DECODE(p_new_comp_item ,NULL ,SYSDATE ,DECODE(p_new_comp_item.start_effective_date
1197: ,fnd_api.g_miss_date ,bic.effectivity_date ,p_new_comp_item.start_effective_date)) start_effective_date
1198: ,DECODE(p_new_comp_item ,NULL ,bic.item_num ,DECODE(p_new_comp_item.item_sequence_number
1199: ,fnd_api.g_miss_num ,bic.item_num ,p_new_comp_item.item_sequence_number)) item_sequence_number
1200: ,DECODE(p_new_comp_item ,NULL ,bic.planning_factor ,DECODE(p_new_comp_item.planning_percent
1201: ,fnd_api.g_miss_num ,bic.planning_factor ,p_new_comp_item.planning_percent)) planning_percent

Line 1199: ,fnd_api.g_miss_num ,bic.item_num ,p_new_comp_item.item_sequence_number)) item_sequence_number

1195: ,fnd_api.g_miss_num ,bic.original_system_reference ,p_new_comp_item.original_system_reference)) original_system_reference
1196: ,DECODE(p_new_comp_item ,NULL ,SYSDATE ,DECODE(p_new_comp_item.start_effective_date
1197: ,fnd_api.g_miss_date ,bic.effectivity_date ,p_new_comp_item.start_effective_date)) start_effective_date
1198: ,DECODE(p_new_comp_item ,NULL ,bic.item_num ,DECODE(p_new_comp_item.item_sequence_number
1199: ,fnd_api.g_miss_num ,bic.item_num ,p_new_comp_item.item_sequence_number)) item_sequence_number
1200: ,DECODE(p_new_comp_item ,NULL ,bic.planning_factor ,DECODE(p_new_comp_item.planning_percent
1201: ,fnd_api.g_miss_num ,bic.planning_factor ,p_new_comp_item.planning_percent)) planning_percent
1202: ,DECODE(p_new_comp_item ,NULL ,bic.component_yield_factor ,DECODE(p_new_comp_item.projected_yield
1203: ,fnd_api.g_miss_num ,bic.component_yield_factor ,p_new_comp_item.projected_yield)) projected_yield

Line 1201: ,fnd_api.g_miss_num ,bic.planning_factor ,p_new_comp_item.planning_percent)) planning_percent

1197: ,fnd_api.g_miss_date ,bic.effectivity_date ,p_new_comp_item.start_effective_date)) start_effective_date
1198: ,DECODE(p_new_comp_item ,NULL ,bic.item_num ,DECODE(p_new_comp_item.item_sequence_number
1199: ,fnd_api.g_miss_num ,bic.item_num ,p_new_comp_item.item_sequence_number)) item_sequence_number
1200: ,DECODE(p_new_comp_item ,NULL ,bic.planning_factor ,DECODE(p_new_comp_item.planning_percent
1201: ,fnd_api.g_miss_num ,bic.planning_factor ,p_new_comp_item.planning_percent)) planning_percent
1202: ,DECODE(p_new_comp_item ,NULL ,bic.component_yield_factor ,DECODE(p_new_comp_item.projected_yield
1203: ,fnd_api.g_miss_num ,bic.component_yield_factor ,p_new_comp_item.projected_yield)) projected_yield
1204: ,DECODE(p_new_comp_item ,NULL ,bic.high_quantity ,DECODE(p_new_comp_item.maximum_allowed_quantity
1205: ,fnd_api.g_miss_num ,bic.high_quantity ,p_new_comp_item.maximum_allowed_quantity)) maximum_allowed_quantity

Line 1203: ,fnd_api.g_miss_num ,bic.component_yield_factor ,p_new_comp_item.projected_yield)) projected_yield

1199: ,fnd_api.g_miss_num ,bic.item_num ,p_new_comp_item.item_sequence_number)) item_sequence_number
1200: ,DECODE(p_new_comp_item ,NULL ,bic.planning_factor ,DECODE(p_new_comp_item.planning_percent
1201: ,fnd_api.g_miss_num ,bic.planning_factor ,p_new_comp_item.planning_percent)) planning_percent
1202: ,DECODE(p_new_comp_item ,NULL ,bic.component_yield_factor ,DECODE(p_new_comp_item.projected_yield
1203: ,fnd_api.g_miss_num ,bic.component_yield_factor ,p_new_comp_item.projected_yield)) projected_yield
1204: ,DECODE(p_new_comp_item ,NULL ,bic.high_quantity ,DECODE(p_new_comp_item.maximum_allowed_quantity
1205: ,fnd_api.g_miss_num ,bic.high_quantity ,p_new_comp_item.maximum_allowed_quantity)) maximum_allowed_quantity
1206: ,DECODE(p_new_comp_item ,NULL ,bic.low_quantity ,DECODE(p_new_comp_item.minimum_allowed_quantity
1207: ,fnd_api.g_miss_num ,bic.low_quantity ,p_new_comp_item.minimum_allowed_quantity)) minimum_allowed_quantity

Line 1205: ,fnd_api.g_miss_num ,bic.high_quantity ,p_new_comp_item.maximum_allowed_quantity)) maximum_allowed_quantity

1201: ,fnd_api.g_miss_num ,bic.planning_factor ,p_new_comp_item.planning_percent)) planning_percent
1202: ,DECODE(p_new_comp_item ,NULL ,bic.component_yield_factor ,DECODE(p_new_comp_item.projected_yield
1203: ,fnd_api.g_miss_num ,bic.component_yield_factor ,p_new_comp_item.projected_yield)) projected_yield
1204: ,DECODE(p_new_comp_item ,NULL ,bic.high_quantity ,DECODE(p_new_comp_item.maximum_allowed_quantity
1205: ,fnd_api.g_miss_num ,bic.high_quantity ,p_new_comp_item.maximum_allowed_quantity)) maximum_allowed_quantity
1206: ,DECODE(p_new_comp_item ,NULL ,bic.low_quantity ,DECODE(p_new_comp_item.minimum_allowed_quantity
1207: ,fnd_api.g_miss_num ,bic.low_quantity ,p_new_comp_item.minimum_allowed_quantity)) minimum_allowed_quantity
1208: ,DECODE(p_new_comp_item ,NULL ,bic.component_remarks ,DECODE(p_new_comp_item.comments
1209: ,fnd_api.g_miss_char ,component_remarks ,p_new_comp_item.comments)) comments

Line 1207: ,fnd_api.g_miss_num ,bic.low_quantity ,p_new_comp_item.minimum_allowed_quantity)) minimum_allowed_quantity

1203: ,fnd_api.g_miss_num ,bic.component_yield_factor ,p_new_comp_item.projected_yield)) projected_yield
1204: ,DECODE(p_new_comp_item ,NULL ,bic.high_quantity ,DECODE(p_new_comp_item.maximum_allowed_quantity
1205: ,fnd_api.g_miss_num ,bic.high_quantity ,p_new_comp_item.maximum_allowed_quantity)) maximum_allowed_quantity
1206: ,DECODE(p_new_comp_item ,NULL ,bic.low_quantity ,DECODE(p_new_comp_item.minimum_allowed_quantity
1207: ,fnd_api.g_miss_num ,bic.low_quantity ,p_new_comp_item.minimum_allowed_quantity)) minimum_allowed_quantity
1208: ,DECODE(p_new_comp_item ,NULL ,bic.component_remarks ,DECODE(p_new_comp_item.comments
1209: ,fnd_api.g_miss_char ,component_remarks ,p_new_comp_item.comments)) comments
1210: ,DECODE(p_new_comp_item ,NULL ,NULL ,p_new_comp_item.new_effectivity_date) new_effectivity_date
1211: ,DECODE(p_new_comp_item ,NULL ,NULL ,p_new_comp_item.old_effectivity_date) old_effectivity_date

Line 1209: ,fnd_api.g_miss_char ,component_remarks ,p_new_comp_item.comments)) comments

1205: ,fnd_api.g_miss_num ,bic.high_quantity ,p_new_comp_item.maximum_allowed_quantity)) maximum_allowed_quantity
1206: ,DECODE(p_new_comp_item ,NULL ,bic.low_quantity ,DECODE(p_new_comp_item.minimum_allowed_quantity
1207: ,fnd_api.g_miss_num ,bic.low_quantity ,p_new_comp_item.minimum_allowed_quantity)) minimum_allowed_quantity
1208: ,DECODE(p_new_comp_item ,NULL ,bic.component_remarks ,DECODE(p_new_comp_item.comments
1209: ,fnd_api.g_miss_char ,component_remarks ,p_new_comp_item.comments)) comments
1210: ,DECODE(p_new_comp_item ,NULL ,NULL ,p_new_comp_item.new_effectivity_date) new_effectivity_date
1211: ,DECODE(p_new_comp_item ,NULL ,NULL ,p_new_comp_item.old_effectivity_date) old_effectivity_date
1212: ,DECODE(p_new_comp_item ,NULL ,1 ,p_new_comp_item.old_operation_sequence_number) old_operation_sequence_number
1213: ,DECODE(p_new_comp_item ,NULL ,1 ,p_new_comp_item.new_operation_sequence_number) new_operation_sequence_number

Line 1238: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

1234: l_revised_comp_tbl inv_ebi_rev_comp_tbl;
1235: l_revised_comp_count NUMBER := 1;
1236: l_output_status inv_ebi_output_status;
1237: BEGIN
1238: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1239: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
1240: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_component_items');
1241: IF (bom_eamutil.enabled = 'Y'
1242: AND bom_eamutil.serial_effective_item (item_id => p_from_item_id,

Line 1474: WHEN FND_API.g_exc_unexpected_error THEN

1470: x_revised_item := l_revised_item;
1471:
1472:
1473: EXCEPTION
1474: WHEN FND_API.g_exc_unexpected_error THEN
1475: IF c_copied_comps%ISOPEN THEN
1476: CLOSE c_copied_comps;
1477: END IF;
1478: IF c_merged_component%ISOPEN THEN

Line 1481: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

1477: END IF;
1478: IF c_merged_component%ISOPEN THEN
1479: CLOSE c_merged_component;
1480: END IF;
1481: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1482: IF(x_out.output_status.msg_data IS NULL) THEN
1483: fnd_msg_pub.count_and_get(
1484: p_encoded => FND_API.g_false
1485: ,p_count => x_out.output_status.msg_count

Line 1484: p_encoded => FND_API.g_false

1480: END IF;
1481: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1482: IF(x_out.output_status.msg_data IS NULL) THEN
1483: fnd_msg_pub.count_and_get(
1484: p_encoded => FND_API.g_false
1485: ,p_count => x_out.output_status.msg_count
1486: ,p_data => x_out.output_status.msg_data
1487: );
1488: END IF;

Line 1496: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

1492: END IF;
1493: IF c_merged_component%ISOPEN THEN
1494: CLOSE c_merged_component;
1495: END IF;
1496: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1497: IF (x_out.output_status.msg_data IS NOT NULL) THEN
1498: x_out.output_status.msg_data := x_out.output_status.msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.prepare_component_items ';
1499: ELSE
1500: x_out.output_status.msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.prepare_component_items ';

Line 1536: RETURN FND_API.g_true;

1532: ((p_alternate_bom_code IS NULL AND bb.alternate_bom_designator IS NULL) OR
1533: (bb.alternate_bom_designator = p_alternate_bom_code));
1534:
1535: IF l_Count = 1 THEN
1536: RETURN FND_API.g_true;
1537: END IF;
1538:
1539: RETURN FND_API.g_false;
1540: EXCEPTION

Line 1539: RETURN FND_API.g_false;

1535: IF l_Count = 1 THEN
1536: RETURN FND_API.g_true;
1537: END IF;
1538:
1539: RETURN FND_API.g_false;
1540: EXCEPTION
1541: WHEN OTHERS THEN
1542: RETURN FND_API.g_false;
1543: END Is_BOM_Exists;

Line 1542: RETURN FND_API.g_false;

1538:
1539: RETURN FND_API.g_false;
1540: EXCEPTION
1541: WHEN OTHERS THEN
1542: RETURN FND_API.g_false;
1543: END Is_BOM_Exists;
1544:
1545: /************************************************************************************
1546: -- API name : is_new_revision_exists

Line 1577: RETURN FND_API.g_true;

1573: msi.concatenated_segments = p_item_number AND
1574: eri.new_item_revision = p_revision ;
1575:
1576: IF l_Count >=1 THEN
1577: RETURN FND_API.g_true;
1578: END IF;
1579:
1580: RETURN FND_API.g_false;
1581: EXCEPTION

Line 1580: RETURN FND_API.g_false;

1576: IF l_Count >=1 THEN
1577: RETURN FND_API.g_true;
1578: END IF;
1579:
1580: RETURN FND_API.g_false;
1581: EXCEPTION
1582: WHEN OTHERS THEN
1583: RETURN FND_API.g_false;
1584: END is_new_revision_exists;

Line 1583: RETURN FND_API.g_false;

1579:
1580: RETURN FND_API.g_false;
1581: EXCEPTION
1582: WHEN OTHERS THEN
1583: RETURN FND_API.g_false;
1584: END is_new_revision_exists;
1585:
1586: /*******************************************************************************
1587: API name : is_child_org

Line 1605: RETURN FND_API.g_true;

1601: FROM mtl_parameters
1602: WHERE organization_id= p_organization_id;
1603:
1604: IF(l_master_org <> p_organization_id) THEN
1605: RETURN FND_API.g_true;
1606: ELSE
1607: RETURN FND_API.g_false;
1608: END IF;
1609:

Line 1607: RETURN FND_API.g_false;

1603:
1604: IF(l_master_org <> p_organization_id) THEN
1605: RETURN FND_API.g_true;
1606: ELSE
1607: RETURN FND_API.g_false;
1608: END IF;
1609:
1610: EXCEPTION
1611: WHEN OTHERS THEN

Line 1639: decode(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code);

1635: WHERE
1636: assembly_item_id = p_assembly_item_id AND
1637: organization_id = p_organization_id AND
1638: NVL(alternate_bom_designator, 'NONE') =
1639: decode(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code);
1640:
1641: RETURN l_bill_sequence_id;
1642:
1643: EXCEPTION

Line 1671: l_context_org_bom_exists VARCHAR2(1) := FND_API.g_false;

1667: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
1668: ) IS
1669: l_revised_item inv_ebi_revised_item_obj;
1670: l_revised_item1 inv_ebi_revised_item_obj;
1671: l_context_org_bom_exists VARCHAR2(1) := FND_API.g_false;
1672: l_ref_org_bom_exists VARCHAR2(1) := FND_API.g_false;
1673: l_context_org_code mtl_parameters.organization_code%TYPE;
1674: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
1675: l_component_item inv_ebi_rev_comp_obj;

Line 1672: l_ref_org_bom_exists VARCHAR2(1) := FND_API.g_false;

1668: ) IS
1669: l_revised_item inv_ebi_revised_item_obj;
1670: l_revised_item1 inv_ebi_revised_item_obj;
1671: l_context_org_bom_exists VARCHAR2(1) := FND_API.g_false;
1672: l_ref_org_bom_exists VARCHAR2(1) := FND_API.g_false;
1673: l_context_org_code mtl_parameters.organization_code%TYPE;
1674: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
1675: l_component_item inv_ebi_rev_comp_obj;
1676: l_component_item1 inv_ebi_rev_comp_obj;

Line 1697: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

1693: l_output_status inv_ebi_output_status;
1694:
1695: BEGIN
1696: SAVEPOINT process_replicate_bom_save_pnt;
1697: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1698: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
1699: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom');
1700: l_context_org_code:= p_eco_obj.eco_change_order_type.organization_code;
1701: l_eco_obj := p_eco_obj;

Line 1722: IF l_from_org_id IS NULL OR l_from_org_id = fnd_api.g_miss_num THEN

1718: l_revised_item.orignal_bom_reference.organization_code IS NOT NULL )) THEN
1719:
1720: l_from_org_id := l_revised_item.orignal_bom_reference.organization_id;
1721: l_reference_org_code := l_revised_item.orignal_bom_reference.organization_code;
1722: IF l_from_org_id IS NULL OR l_from_org_id = fnd_api.g_miss_num THEN
1723: l_from_org_id := INV_EBI_ITEM_HELPER.get_organization_id( p_organization_code => l_reference_org_code);
1724: ELSIF l_reference_org_code IS NULL OR l_reference_org_code = fnd_api.g_miss_char THEN
1725: SELECT
1726: organization_code

Line 1724: ELSIF l_reference_org_code IS NULL OR l_reference_org_code = fnd_api.g_miss_char THEN

1720: l_from_org_id := l_revised_item.orignal_bom_reference.organization_id;
1721: l_reference_org_code := l_revised_item.orignal_bom_reference.organization_code;
1722: IF l_from_org_id IS NULL OR l_from_org_id = fnd_api.g_miss_num THEN
1723: l_from_org_id := INV_EBI_ITEM_HELPER.get_organization_id( p_organization_code => l_reference_org_code);
1724: ELSIF l_reference_org_code IS NULL OR l_reference_org_code = fnd_api.g_miss_char THEN
1725: SELECT
1726: organization_code
1727: INTO
1728: l_reference_org_code

Line 1770: IF (NOT FND_API.To_Boolean(l_context_org_bom_exists)) AND FND_API.To_Boolean(l_ref_org_bom_exists) THEN

1766: p_item_number => l_reference_item_num
1767: ,p_organization_code => l_reference_org_code
1768: ,p_alternate_bom_code => l_revised_item.orignal_bom_reference.alternate_bom_code
1769: );
1770: IF (NOT FND_API.To_Boolean(l_context_org_bom_exists)) AND FND_API.To_Boolean(l_ref_org_bom_exists) THEN
1771: SELECT
1772: bill_sequence_id
1773: INTO
1774: l_from_sequence_id

Line 1783: IF l_view_scope IS NULL OR l_view_scope = fnd_api.g_miss_char THEN

1779: organization_id = l_from_org_id AND
1780: ((l_revised_item.alternate_bom_code IS NULL AND alternate_bom_designator IS NULL) OR
1781: (alternate_bom_designator = l_revised_item.alternate_bom_code));
1782: l_view_scope := l_revised_item.orignal_bom_reference.view_scope;
1783: IF l_view_scope IS NULL OR l_view_scope = fnd_api.g_miss_char THEN
1784: l_view_scope := l_config_view_scope;
1785: END IF;
1786:
1787: l_impl_scope := l_revised_item.orignal_bom_reference.implementation_scope;

Line 1788: IF l_impl_scope IS NULL OR l_impl_scope = fnd_api.g_miss_char THEN

1784: l_view_scope := l_config_view_scope;
1785: END IF;
1786:
1787: l_impl_scope := l_revised_item.orignal_bom_reference.implementation_scope;
1788: IF l_impl_scope IS NULL OR l_impl_scope = fnd_api.g_miss_char THEN
1789: l_impl_scope := l_config_impl_scope;
1790: END IF;
1791:
1792: l_as_of_date := l_revised_item.orignal_bom_reference.as_of_date;

Line 1793: IF l_as_of_date IS NULL OR l_as_of_date = fnd_api.g_miss_date THEN

1789: l_impl_scope := l_config_impl_scope;
1790: END IF;
1791:
1792: l_as_of_date := l_revised_item.orignal_bom_reference.as_of_date;
1793: IF l_as_of_date IS NULL OR l_as_of_date = fnd_api.g_miss_date THEN
1794: l_as_of_date := SYSDATE;
1795: END IF;
1796:
1797: prepare_component_items (

Line 1810: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

1806: ,x_revised_item => l_revised_item
1807: ,x_out => x_out
1808: );
1809:
1810: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
1811: RAISE FND_API.g_exc_unexpected_error;
1812: END IF;
1813:
1814: IF l_revised_item.component_item_tbl IS NOT NULL THEN

Line 1811: RAISE FND_API.g_exc_unexpected_error;

1807: ,x_out => x_out
1808: );
1809:
1810: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
1811: RAISE FND_API.g_exc_unexpected_error;
1812: END IF;
1813:
1814: IF l_revised_item.component_item_tbl IS NOT NULL THEN
1815: FOR j IN 1..l_revised_item.component_item_tbl.COUNT LOOP

Line 1823: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

1819: ,p_reference_org_id => l_from_org_id
1820: ,x_component_item => l_component_item
1821: ,x_out => x_out
1822: );
1823: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
1824: RAISE FND_API.g_exc_unexpected_error;
1825: END IF;
1826:
1827: prepare_reference_designators (

Line 1824: RAISE FND_API.g_exc_unexpected_error;

1820: ,x_component_item => l_component_item
1821: ,x_out => x_out
1822: );
1823: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
1824: RAISE FND_API.g_exc_unexpected_error;
1825: END IF;
1826:
1827: prepare_reference_designators (
1828: p_component_item => l_component_item

Line 1834: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

1830: ,p_reference_org_id => l_from_org_id
1831: ,x_component_item => l_component_item1
1832: ,x_out => x_out
1833: );
1834: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
1835: RAISE FND_API.g_exc_unexpected_error;
1836: END IF;
1837:
1838: l_revised_item.component_item_tbl(j) := l_component_item1;

Line 1835: RAISE FND_API.g_exc_unexpected_error;

1831: ,x_component_item => l_component_item1
1832: ,x_out => x_out
1833: );
1834: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
1835: RAISE FND_API.g_exc_unexpected_error;
1836: END IF;
1837:
1838: l_revised_item.component_item_tbl(j) := l_component_item1;
1839: END LOOP;

Line 1851: WHEN FND_API.g_exc_unexpected_error THEN

1847: x_eco_obj := l_eco_obj;
1848:
1849:
1850: EXCEPTION
1851: WHEN FND_API.g_exc_unexpected_error THEN
1852: ROLLBACK TO process_replicate_bom_save_pnt;
1853: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1854: IF(x_out.output_status.msg_data IS NULL) THEN
1855: fnd_msg_pub.count_and_get(

Line 1853: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

1849:
1850: EXCEPTION
1851: WHEN FND_API.g_exc_unexpected_error THEN
1852: ROLLBACK TO process_replicate_bom_save_pnt;
1853: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1854: IF(x_out.output_status.msg_data IS NULL) THEN
1855: fnd_msg_pub.count_and_get(
1856: p_encoded => FND_API.g_false
1857: ,p_count => x_out.output_status.msg_count

Line 1856: p_encoded => FND_API.g_false

1852: ROLLBACK TO process_replicate_bom_save_pnt;
1853: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1854: IF(x_out.output_status.msg_data IS NULL) THEN
1855: fnd_msg_pub.count_and_get(
1856: p_encoded => FND_API.g_false
1857: ,p_count => x_out.output_status.msg_count
1858: ,p_data => x_out.output_status.msg_data
1859: );
1860: END IF;

Line 1863: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

1859: );
1860: END IF;
1861: WHEN OTHERS THEN
1862: ROLLBACK TO process_replicate_bom_save_pnt;
1863: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1864: IF (x_out.output_status.msg_data IS NOT NULL) THEN
1865: x_out.output_status.msg_data := x_out.output_status.msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom ';
1866: ELSE
1867: x_out.output_status.msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom ';

Line 1878: p_commit IN VARCHAR2 := FND_API.g_false

1874: -- Function :
1875: --
1876: ************************************************************************************/
1877: PROCEDURE process_uda (
1878: p_commit IN VARCHAR2 := FND_API.g_false
1879: ,p_api_version IN NUMBER DEFAULT 1.0
1880: ,p_uda_input_obj IN inv_ebi_uda_input_obj
1881: ,p_object_name IN VARCHAR2
1882: ,p_data_level IN VARCHAR2

Line 1897: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

1893: l_output_status inv_ebi_output_status;
1894: BEGIN
1895: SAVEPOINT inv_ebi_process_uda_save_pnt;
1896: l_uda_out := inv_ebi_uda_output_obj(NULL,NULL);
1897: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1898: x_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,l_uda_out);
1899:
1900: --To convert inv_ebi uda objects to ego uda compatible objects
1901: INV_EBI_UTIL.transform_uda (

Line 1910: IF (x_uda_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN

1906: ,x_msg_count => x_uda_output_obj.output_status.msg_count
1907: ,x_msg_data => x_uda_output_obj.output_status.msg_data
1908: );
1909:
1910: IF (x_uda_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN
1911: RAISE FND_API.g_exc_unexpected_error;
1912: END IF;
1913:
1914: FOR i in 1..l_attributes_row_table.COUNT

Line 1911: RAISE FND_API.g_exc_unexpected_error;

1907: ,x_msg_data => x_uda_output_obj.output_status.msg_data
1908: );
1909:
1910: IF (x_uda_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN
1911: RAISE FND_API.g_exc_unexpected_error;
1912: END IF;
1913:
1914: FOR i in 1..l_attributes_row_table.COUNT
1915: LOOP

Line 1966: IF (x_uda_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN

1962: ,x_msg_count => x_uda_output_obj.output_status.msg_count
1963: ,x_msg_data => x_uda_output_obj.output_status.msg_data
1964: );
1965:
1966: IF (x_uda_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN
1967: RAISE FND_API.g_exc_unexpected_error;
1968: END IF;
1969:
1970: IF FND_API.To_Boolean(p_commit) THEN

Line 1967: RAISE FND_API.g_exc_unexpected_error;

1963: ,x_msg_data => x_uda_output_obj.output_status.msg_data
1964: );
1965:
1966: IF (x_uda_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN
1967: RAISE FND_API.g_exc_unexpected_error;
1968: END IF;
1969:
1970: IF FND_API.To_Boolean(p_commit) THEN
1971: COMMIT;

Line 1970: IF FND_API.To_Boolean(p_commit) THEN

1966: IF (x_uda_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN
1967: RAISE FND_API.g_exc_unexpected_error;
1968: END IF;
1969:
1970: IF FND_API.To_Boolean(p_commit) THEN
1971: COMMIT;
1972: END IF;
1973:
1974: EXCEPTION

Line 1975: WHEN FND_API.g_exc_unexpected_error THEN

1971: COMMIT;
1972: END IF;
1973:
1974: EXCEPTION
1975: WHEN FND_API.g_exc_unexpected_error THEN
1976: ROLLBACK TO inv_ebi_process_uda_save_pnt;
1977: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_error;
1978:
1979: IF(x_uda_output_obj.output_status.msg_data IS NULL) THEN

Line 1977: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_error;

1973:
1974: EXCEPTION
1975: WHEN FND_API.g_exc_unexpected_error THEN
1976: ROLLBACK TO inv_ebi_process_uda_save_pnt;
1977: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_error;
1978:
1979: IF(x_uda_output_obj.output_status.msg_data IS NULL) THEN
1980: fnd_msg_pub.count_and_get(
1981: p_encoded => FND_API.g_false

Line 1981: p_encoded => FND_API.g_false

1977: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_error;
1978:
1979: IF(x_uda_output_obj.output_status.msg_data IS NULL) THEN
1980: fnd_msg_pub.count_and_get(
1981: p_encoded => FND_API.g_false
1982: ,p_count => x_uda_output_obj.output_status.msg_count
1983: ,p_data => x_uda_output_obj.output_status.msg_data
1984: );
1985: END IF;

Line 1989: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_unexp_error;

1985: END IF;
1986:
1987: WHEN OTHERS THEN
1988: ROLLBACK TO inv_ebi_process_uda_save_pnt;
1989: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1990: IF (x_uda_output_obj.output_status.msg_data IS NOT NULL) THEN
1991: x_uda_output_obj.output_status.msg_data := x_uda_output_obj.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_HELPER.process_uda ';
1992: ELSE
1993: x_uda_output_obj.output_status.msg_data := SQLERRM||' at INV_EBI_CHANGE_ORDER_HELPER.process_uda ';

Line 2032: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

2028: BEGIN
2029: SAVEPOINT inv_ebi_chg_order_uda_save_pnt;
2030:
2031: l_uda_out := inv_ebi_uda_output_obj(NULL,NULL);
2032: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2033: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
2034:
2035: Error_Handler.initialize;
2036: IF(p_organization_code IS NOT NULL) THEN

Line 2066: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;

2062: SELECT bill_sequence_id,structure_type_id INTO l_bill_sequence_id,l_structure_type_id
2063: FROM bom_bill_of_materials
2064: WHERE assembly_item_id = l_assembly_item_id
2065: AND organization_id = l_organization_id
2066: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;
2067:
2068: SELECT component_sequence_id INTO l_component_sequence_id
2069: FROM bom_components_b
2070: WHERE bill_sequence_id = l_bill_sequence_id

Line 2092: IF(x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

2088: ,p_class_code_name_value_pairs => l_pkcode
2089: ,x_uda_output_obj => x_out
2090: );
2091:
2092: IF(x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2093: RAISE FND_API.g_exc_unexpected_error;
2094: END IF;
2095: END IF;
2096: END LOOP;

Line 2093: RAISE FND_API.g_exc_unexpected_error;

2089: ,x_uda_output_obj => x_out
2090: );
2091:
2092: IF(x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2093: RAISE FND_API.g_exc_unexpected_error;
2094: END IF;
2095: END IF;
2096: END LOOP;
2097: END IF;

Line 2105: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;

2101: SELECT bill_sequence_id,structure_type_id INTO l_bill_sequence_id,l_structure_type_id
2102: FROM bom_bill_of_materials
2103: WHERE assembly_item_id = l_assembly_item_id
2104: AND organization_id = l_organization_id
2105: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;
2106:
2107: l_pkdata := ego_col_name_value_pair_array();
2108: l_pkdata.extend();
2109: l_pkdata(1) := ego_col_name_value_pair_obj('BILL_SEQUENCE_ID',l_bill_sequence_id);

Line 2124: IF(x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

2120: ,p_class_code_name_value_pairs => l_pkcode
2121: ,x_uda_output_obj => x_out
2122: );
2123:
2124: IF(x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2125: RAISE FND_API.g_exc_unexpected_error;
2126: END IF;
2127: END IF;
2128:

Line 2125: RAISE FND_API.g_exc_unexpected_error;

2121: ,x_uda_output_obj => x_out
2122: );
2123:
2124: IF(x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2125: RAISE FND_API.g_exc_unexpected_error;
2126: END IF;
2127: END IF;
2128:
2129: IF FND_API.To_Boolean(p_commit) THEN

Line 2129: IF FND_API.To_Boolean(p_commit) THEN

2125: RAISE FND_API.g_exc_unexpected_error;
2126: END IF;
2127: END IF;
2128:
2129: IF FND_API.To_Boolean(p_commit) THEN
2130: COMMIT;
2131: END IF;
2132: EXCEPTION
2133: WHEN FND_API.g_exc_unexpected_error THEN

Line 2133: WHEN FND_API.g_exc_unexpected_error THEN

2129: IF FND_API.To_Boolean(p_commit) THEN
2130: COMMIT;
2131: END IF;
2132: EXCEPTION
2133: WHEN FND_API.g_exc_unexpected_error THEN
2134: ROLLBACK TO inv_ebi_chg_order_uda_save_pnt;
2135: x_out.output_status.return_status := FND_API.g_ret_sts_error;
2136: IF(x_out.output_status.msg_data IS NULL) THEN
2137: fnd_msg_pub.count_and_get(

Line 2135: x_out.output_status.return_status := FND_API.g_ret_sts_error;

2131: END IF;
2132: EXCEPTION
2133: WHEN FND_API.g_exc_unexpected_error THEN
2134: ROLLBACK TO inv_ebi_chg_order_uda_save_pnt;
2135: x_out.output_status.return_status := FND_API.g_ret_sts_error;
2136: IF(x_out.output_status.msg_data IS NULL) THEN
2137: fnd_msg_pub.count_and_get(
2138: p_encoded => FND_API.g_false
2139: ,p_count => x_out.output_status.msg_count

Line 2138: p_encoded => FND_API.g_false

2134: ROLLBACK TO inv_ebi_chg_order_uda_save_pnt;
2135: x_out.output_status.return_status := FND_API.g_ret_sts_error;
2136: IF(x_out.output_status.msg_data IS NULL) THEN
2137: fnd_msg_pub.count_and_get(
2138: p_encoded => FND_API.g_false
2139: ,p_count => x_out.output_status.msg_count
2140: ,p_data => x_out.output_status.msg_data
2141: );
2142: END IF;

Line 2145: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

2141: );
2142: END IF;
2143: WHEN OTHERS THEN
2144: ROLLBACK TO inv_ebi_chg_order_uda_save_pnt;
2145: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2146: IF (x_out.output_status.msg_data IS NOT NULL) THEN
2147: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda';
2148: ELSE
2149: x_out.output_status.msg_data := SQLERRM||' at INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda';

Line 2492: x_return_status := FND_API.G_RET_STS_SUCCESS;

2488: l_master_item_rev c_master_item_rev%ROWTYPE;
2489:
2490: BEGIN
2491: SAVEPOINT inv_ebi_assign_item_save_pnt;
2492: x_return_status := FND_API.G_RET_STS_SUCCESS;
2493: l_is_item_exists := INV_EBI_ITEM_HELPER.is_item_exists(
2494: p_organization_id => p_organization_id
2495: ,p_item_number => p_item_name
2496: );

Line 2497: IF (l_is_item_exists = FND_API.g_false) THEN

2493: l_is_item_exists := INV_EBI_ITEM_HELPER.is_item_exists(
2494: p_organization_id => p_organization_id
2495: ,p_item_number => p_item_name
2496: );
2497: IF (l_is_item_exists = FND_API.g_false) THEN
2498:
2499: l_master_org := INV_EBI_UTIL.get_master_organization(
2500: p_organization_id => p_organization_id
2501: );

Line 2511: IF(l_is_item_exists = FND_API.g_true ) THEN

2507: /* If Item does not exist in context org(child org) and it exists in master org
2508: and if it approved in master org and ASSIGN_ITEM_TO_CHILD_ORG is set
2509: to true then item should be assigned to context org */
2510:
2511: IF(l_is_item_exists = FND_API.g_true ) THEN
2512: IF(get_assign_item = FND_API.g_true ) THEN
2513: IF(INV_EBI_UTIL.is_pim_installed) THEN
2514: SELECT item_catalog_group_id, approval_status
2515: INTO l_item_catalog_group_id, l_approval_status

Line 2512: IF(get_assign_item = FND_API.g_true ) THEN

2508: and if it approved in master org and ASSIGN_ITEM_TO_CHILD_ORG is set
2509: to true then item should be assigned to context org */
2510:
2511: IF(l_is_item_exists = FND_API.g_true ) THEN
2512: IF(get_assign_item = FND_API.g_true ) THEN
2513: IF(INV_EBI_UTIL.is_pim_installed) THEN
2514: SELECT item_catalog_group_id, approval_status
2515: INTO l_item_catalog_group_id, l_approval_status
2516: FROM mtl_system_items_kfv

Line 2519: IF (INV_EBI_ITEM_HELPER.is_new_item_request_reqd( l_item_catalog_group_id ) = FND_API.g_true) AND l_approval_status <> 'A'

2515: INTO l_item_catalog_group_id, l_approval_status
2516: FROM mtl_system_items_kfv
2517: WHERE organization_id = l_master_org
2518: AND concatenated_segments = p_item_name;
2519: IF (INV_EBI_ITEM_HELPER.is_new_item_request_reqd( l_item_catalog_group_id ) = FND_API.g_true) AND l_approval_status <> 'A'
2520: THEN
2521: FND_MSG_PUB.initialize();
2522: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_APROVAL_STS');
2523: FND_MESSAGE.set_token('ITEM_NUMBER',p_item_name);

Line 2527: RAISE FND_API.g_exc_unexpected_error;

2523: FND_MESSAGE.set_token('ITEM_NUMBER',p_item_name);
2524: FND_MESSAGE.set_token('ORGANIZATION_ID',l_master_org);
2525: FND_MESSAGE.set_token('CHILD_ORGANIZATION_ID',p_organization_id);
2526: FND_MSG_PUB.add;
2527: RAISE FND_API.g_exc_unexpected_error;
2528: END IF;
2529: END IF;
2530:
2531: EGO_ITEM_PUB.assign_item_to_org(

Line 2533: ,p_commit => FND_API.g_false

2529: END IF;
2530:
2531: EGO_ITEM_PUB.assign_item_to_org(
2532: p_api_version => 1.0
2533: ,p_commit => FND_API.g_false
2534: ,p_Item_Number => p_item_name
2535: ,p_Organization_Id => p_organization_id
2536: ,x_return_status => x_return_status
2537: ,x_msg_count => x_msg_count

Line 2539: IF (x_return_status <> FND_API.g_ret_sts_success) THEN

2535: ,p_Organization_Id => p_organization_id
2536: ,x_return_status => x_return_status
2537: ,x_msg_count => x_msg_count
2538: );
2539: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
2540: RAISE FND_API.g_exc_unexpected_error;
2541: END IF;
2542: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
2543: p_organization_id => l_master_org

Line 2540: RAISE FND_API.g_exc_unexpected_error;

2536: ,x_return_status => x_return_status
2537: ,x_msg_count => x_msg_count
2538: );
2539: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
2540: RAISE FND_API.g_exc_unexpected_error;
2541: END IF;
2542: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
2543: p_organization_id => l_master_org
2544: ,p_item_number => p_item_name

Line 2583: ,p_init_msg_list => FND_API.g_false

2579: l_effectivity_date := l_effectivity_date + 1/86400; -- To keep efectivity date of next rev 1 sec higher than earlier rev
2580:
2581: EGO_ITEM_PUB.Process_Item_Revision(
2582: p_api_version => 1.0
2583: ,p_init_msg_list => FND_API.g_false
2584: ,p_commit => FND_API.g_false
2585: ,p_transaction_type => INV_EBI_ITEM_PUB.g_otype_create
2586: ,p_inventory_item_id => NULL
2587: ,p_item_number => p_item_name

Line 2584: ,p_commit => FND_API.g_false

2580:
2581: EGO_ITEM_PUB.Process_Item_Revision(
2582: p_api_version => 1.0
2583: ,p_init_msg_list => FND_API.g_false
2584: ,p_commit => FND_API.g_false
2585: ,p_transaction_type => INV_EBI_ITEM_PUB.g_otype_create
2586: ,p_inventory_item_id => NULL
2587: ,p_item_number => p_item_name
2588: ,p_organization_id => p_organization_id

Line 2618: IF (x_return_status <> FND_API.g_ret_sts_success) THEN

2614: ,x_msg_count => x_msg_data
2615: ,x_msg_data => x_msg_count
2616: ) ;
2617:
2618: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
2619: RAISE FND_API.g_exc_unexpected_error;
2620: END IF;
2621: END IF;
2622: END IF;

Line 2619: RAISE FND_API.g_exc_unexpected_error;

2615: ,x_msg_data => x_msg_count
2616: ) ;
2617:
2618: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
2619: RAISE FND_API.g_exc_unexpected_error;
2620: END IF;
2621: END IF;
2622: END IF;
2623: ELSE

Line 2627: RAISE FND_API.g_exc_error;

2623: ELSE
2624: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NO_MASTER_ORG');
2625: FND_MESSAGE.set_token('ITEM', p_item_name);
2626: FND_MSG_PUB.add;
2627: RAISE FND_API.g_exc_error;
2628: END IF;
2629: END IF;
2630: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_assign_items');
2631: EXCEPTION

Line 2632: WHEN FND_API.g_exc_unexpected_error THEN

2628: END IF;
2629: END IF;
2630: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_assign_items');
2631: EXCEPTION
2632: WHEN FND_API.g_exc_unexpected_error THEN
2633: ROLLBACK TO inv_ebi_assign_item_save_pnt;
2634: x_return_status := FND_API.g_ret_sts_unexp_error;
2635:
2636: IF c_master_item_rev%ISOPEN THEN

Line 2634: x_return_status := FND_API.g_ret_sts_unexp_error;

2630: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_assign_items');
2631: EXCEPTION
2632: WHEN FND_API.g_exc_unexpected_error THEN
2633: ROLLBACK TO inv_ebi_assign_item_save_pnt;
2634: x_return_status := FND_API.g_ret_sts_unexp_error;
2635:
2636: IF c_master_item_rev%ISOPEN THEN
2637: CLOSE c_master_item_rev;
2638: END IF;

Line 2641: p_encoded => FND_API.g_false

2637: CLOSE c_master_item_rev;
2638: END IF;
2639: IF(x_msg_data IS NULL) THEN
2640: fnd_msg_pub.count_and_get(
2641: p_encoded => FND_API.g_false
2642: ,p_count => x_msg_count
2643: ,p_data => x_msg_data
2644: );
2645: END IF;

Line 2646: WHEN FND_API.g_exc_error THEN

2642: ,p_count => x_msg_count
2643: ,p_data => x_msg_data
2644: );
2645: END IF;
2646: WHEN FND_API.g_exc_error THEN
2647: ROLLBACK TO inv_ebi_assign_item_save_pnt;
2648: x_return_status := FND_API.g_ret_sts_error;
2649:
2650: IF c_master_item_rev%ISOPEN THEN

Line 2648: x_return_status := FND_API.g_ret_sts_error;

2644: );
2645: END IF;
2646: WHEN FND_API.g_exc_error THEN
2647: ROLLBACK TO inv_ebi_assign_item_save_pnt;
2648: x_return_status := FND_API.g_ret_sts_error;
2649:
2650: IF c_master_item_rev%ISOPEN THEN
2651: CLOSE c_master_item_rev;
2652: END IF;

Line 2655: p_encoded => FND_API.g_false

2651: CLOSE c_master_item_rev;
2652: END IF;
2653: IF(x_msg_data IS NULL) THEN
2654: FND_MSG_PUB.count_and_get(
2655: p_encoded => FND_API.g_false
2656: ,p_count => x_msg_count
2657: ,p_data => x_msg_data
2658: );
2659: END IF;

Line 2662: x_return_status := FND_API.g_ret_sts_unexp_error;

2658: );
2659: END IF;
2660: WHEN OTHERS THEN
2661: ROLLBACK TO inv_ebi_assign_item_save_pnt;
2662: x_return_status := FND_API.g_ret_sts_unexp_error;
2663:
2664: IF c_master_item_rev%ISOPEN THEN
2665: CLOSE c_master_item_rev;
2666: END IF;

Line 2733: p_commit IN VARCHAR2 := FND_API.G_FALSE

2729: -- This API is used to create the change order.
2730: --
2731: ************************************************************************************/
2732: PROCEDURE process_eco(
2733: p_commit IN VARCHAR2 := FND_API.G_FALSE
2734: ,p_change_order IN inv_ebi_change_order_obj
2735: ,p_revision_type_tbl IN inv_ebi_eco_revision_tbl
2736: ,p_revised_item_type_tbl IN inv_ebi_revised_item_tbl
2737: ,p_name_val_list IN inv_ebi_name_value_list

Line 2775: l_plm_or_erp VARCHAR2(1):=FND_API.G_TRUE;

2771: l_status_type NUMBER;
2772: l_priority_code VARCHAR2(10);
2773: l_is_wf_Set BOOLEAN;
2774: l_approval_status NUMBER :=0;
2775: l_plm_or_erp VARCHAR2(1):=FND_API.G_TRUE;
2776: l_old_effectivity_date DATE;
2777: l_old_op_sequence_num NUMBER;
2778: l_old_fm_end_item_unit NUMBER;
2779: l_acd_update CONSTANT NUMBER :=2;

Line 2790: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

2786: BEGIN
2787: SAVEPOINT inv_ebi_proc_eco_save_pnt;
2788: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_eco');
2789:
2790: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2791: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
2792:
2793: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
2794: l_pk_col_name_val_pairs.EXTEND(1);

Line 2808: RAISE FND_API.g_exc_unexpected_error;

2804: IF (l_organization_id IS NULL) THEN
2805: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
2806: FND_MESSAGE.set_token('COL_VALUE', p_change_order.organization_code);
2807: FND_MSG_PUB.add;
2808: RAISE FND_API.g_exc_unexpected_error;
2809: END IF;
2810:
2811: -- Code to incorporate the DVM changes
2812: -- ECO_TYPECODE

Line 2901: IF (p_change_order.plm_or_erp_change IS NOT NULL AND p_change_order.plm_or_erp_change <> fnd_api.g_miss_char ) THEN

2897: l_eco_rec.transaction_id := p_change_order.transaction_id;
2898: l_eco_rec.transaction_type := p_change_order.transaction_type ;
2899: l_eco_rec.internal_use_only := p_change_order.internal_use_only ;
2900: l_eco_rec.return_status := p_change_order.return_status ;
2901: IF (p_change_order.plm_or_erp_change IS NOT NULL AND p_change_order.plm_or_erp_change <> fnd_api.g_miss_char ) THEN
2902: l_eco_rec.plm_or_erp_change := p_change_order.plm_or_erp_change ;
2903: ELSE
2904: IF (l_plm_or_erp = FND_API.G_FALSE) THEN
2905: l_eco_rec.plm_or_erp_change := 'PLM';

Line 2904: IF (l_plm_or_erp = FND_API.G_FALSE) THEN

2900: l_eco_rec.return_status := p_change_order.return_status ;
2901: IF (p_change_order.plm_or_erp_change IS NOT NULL AND p_change_order.plm_or_erp_change <> fnd_api.g_miss_char ) THEN
2902: l_eco_rec.plm_or_erp_change := p_change_order.plm_or_erp_change ;
2903: ELSE
2904: IF (l_plm_or_erp = FND_API.G_FALSE) THEN
2905: l_eco_rec.plm_or_erp_change := 'PLM';
2906: ELSE
2907: l_eco_rec.plm_or_erp_change := 'ERP';
2908: END IF;

Line 2978: ) = FND_API.g_true ) THEN

2974: IF (is_new_revision_exists(
2975: p_item_number => l_revised_item_tbl(l_revised_item_tbl_count).revised_item_name,
2976: p_revision => p_revised_item_type_tbl(i).new_revised_item_revision,
2977: p_org_code => l_revised_item_tbl(l_revised_item_tbl_count).organization_code
2978: ) = FND_API.g_true ) THEN
2979: l_revised_item_tbl(l_revised_item_tbl_count).new_revised_item_revision := NULL;
2980: l_revised_item_tbl(l_revised_item_tbl_count).from_item_revision := p_revised_item_type_tbl(i).from_item_revision ;
2981: ELSE
2982: l_revised_item_tbl(l_revised_item_tbl_count).new_revised_item_revision := p_revised_item_type_tbl(i).new_revised_item_revision;

Line 2993: OR p_revised_item_type_tbl(i).start_effective_date = fnd_api.g_miss_date) THEN

2989:
2990: l_revised_item_tbl(l_revised_item_tbl_count).new_revised_item_rev_desc := p_revised_item_type_tbl(i).new_revised_item_rev_desc;
2991: l_revised_item_tbl(l_revised_item_tbl_count).updated_revised_item_revision := p_revised_item_type_tbl(i).upd_revised_item_revision;
2992: IF (p_revised_item_type_tbl(i).start_effective_date IS NULL
2993: OR p_revised_item_type_tbl(i).start_effective_date = fnd_api.g_miss_date) THEN
2994: l_revised_item_tbl(l_revised_item_tbl_count).start_effective_date := l_effectivity_date + 1/86400; -- BUG 7197943 To keep efectivity date of next rev 1 sec higher than earlier rev
2995: ELSE
2996: l_revised_item_tbl(l_revised_item_tbl_count).start_effective_date := p_revised_item_type_tbl(i).start_effective_date;
2997: END IF;

Line 2999: OR p_revised_item_type_tbl(i).new_effective_date = fnd_api.g_miss_date) THEN

2995: ELSE
2996: l_revised_item_tbl(l_revised_item_tbl_count).start_effective_date := p_revised_item_type_tbl(i).start_effective_date;
2997: END IF;
2998: IF (p_revised_item_type_tbl(i).new_effective_date IS NULL
2999: OR p_revised_item_type_tbl(i).new_effective_date = fnd_api.g_miss_date) THEN
3000: l_revised_item_tbl(l_revised_item_tbl_count).new_effective_date := l_effectivity_date + 1/86400; --BUG 7197943 To keep efectivity date of next rev 1 sec higher than earlier rev
3001: ELSE
3002: l_revised_item_tbl(l_revised_item_tbl_count).new_effective_date := p_revised_item_type_tbl(i).new_effective_date ;
3003: END IF;

Line 3093: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

3089: x_return_status => x_out.output_status.return_status ,
3090: x_msg_data => x_out.output_status.msg_data ,
3091: x_msg_count => x_out.output_status.msg_count
3092: );
3093: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
3094: RAISE FND_API.g_exc_unexpected_error;
3095: END IF;
3096:
3097: l_rev_component_tbl(l_rev_component_tbl_count).eco_name := p_change_order.eco_name;

Line 3094: RAISE FND_API.g_exc_unexpected_error;

3090: x_msg_data => x_out.output_status.msg_data ,
3091: x_msg_count => x_out.output_status.msg_count
3092: );
3093: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
3094: RAISE FND_API.g_exc_unexpected_error;
3095: END IF;
3096:
3097: l_rev_component_tbl(l_rev_component_tbl_count).eco_name := p_change_order.eco_name;
3098: l_rev_component_tbl(l_rev_component_tbl_count).organization_code := p_change_order.organization_code ;

Line 3102: OR p_revised_item_type_tbl(i).component_item_tbl(j).start_effective_date = fnd_api.g_miss_date) THEN

3098: l_rev_component_tbl(l_rev_component_tbl_count).organization_code := p_change_order.organization_code ;
3099: l_rev_component_tbl(l_rev_component_tbl_count).revised_item_name := p_revised_item_type_tbl(i).revised_item_name;
3100: l_rev_component_tbl(l_rev_component_tbl_count).new_revised_item_revision := l_revised_item_tbl(l_revised_item_tbl_count).new_revised_item_revision;
3101: IF ( p_revised_item_type_tbl(i).component_item_tbl(j).start_effective_date IS NULL
3102: OR p_revised_item_type_tbl(i).component_item_tbl(j).start_effective_date = fnd_api.g_miss_date) THEN
3103: l_rev_component_tbl(l_rev_component_tbl_count).start_effective_date := l_effectivity_date + 1/86400 ; --BUG 7197943 To keep efectivity date of next rev 1 sec higher than earlier rev
3104: ELSE
3105: l_rev_component_tbl(l_rev_component_tbl_count).start_effective_date := p_revised_item_type_tbl(i).component_item_tbl(j).start_effective_date;
3106: END IF;

Line 3108: OR p_revised_item_type_tbl(i).component_item_tbl(j).new_effectivity_date = fnd_api.g_miss_date) THEN

3104: ELSE
3105: l_rev_component_tbl(l_rev_component_tbl_count).start_effective_date := p_revised_item_type_tbl(i).component_item_tbl(j).start_effective_date;
3106: END IF;
3107: IF (p_revised_item_type_tbl(i).component_item_tbl(j).new_effectivity_date IS NULL
3108: OR p_revised_item_type_tbl(i).component_item_tbl(j).new_effectivity_date = fnd_api.g_miss_date) THEN
3109: l_rev_component_tbl(l_rev_component_tbl_count).new_effectivity_date := l_effectivity_date + 1/86400; --BUG 7197943 To keep efectivity date of next rev 1 sec higher than earlier rev
3110: ELSE
3111: l_rev_component_tbl(l_rev_component_tbl_count).new_effectivity_date := p_revised_item_type_tbl(i).component_item_tbl(j).new_effectivity_date ;
3112: END IF;

Line 3211: OR p_revised_item_type_tbl(i).component_item_tbl(j).reference_designator_tbl(k).start_effective_date =fnd_api.g_miss_date) THEN

3207: l_ref_designator_tbl(l_ref_designator_tbl_count).operation_sequence_number := p_revised_item_type_tbl(i).component_item_tbl(j).operation_sequence_number;
3208: l_ref_designator_tbl(l_ref_designator_tbl_count).component_item_name := p_revised_item_type_tbl(i).component_item_tbl(j).component_item_name ;
3209: l_ref_designator_tbl(l_ref_designator_tbl_count).alternate_bom_code := p_revised_item_type_tbl(i).alternate_bom_code;
3210: IF (p_revised_item_type_tbl(i).component_item_tbl(j).reference_designator_tbl(k).start_effective_date IS NULL
3211: OR p_revised_item_type_tbl(i).component_item_tbl(j).reference_designator_tbl(k).start_effective_date =fnd_api.g_miss_date) THEN
3212: l_ref_designator_tbl(l_ref_designator_tbl_count).start_effective_date := l_effectivity_date + 1/86400; --BUG 7197943 To keep efectivity date of next rev 1 sec higher than earlier rev
3213: ELSE
3214: l_ref_designator_tbl(l_ref_designator_tbl_count).start_effective_date := p_revised_item_type_tbl(i).component_item_tbl(j).reference_designator_tbl(k).start_effective_date;
3215: END IF;

Line 3257: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

3253: x_return_status => x_out.output_status.return_status ,
3254: x_msg_data => x_out.output_status.msg_data ,
3255: x_msg_count => x_out.output_status.msg_count
3256: );
3257: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
3258: RAISE FND_API.g_exc_unexpected_error;
3259: END IF;
3260:
3261: l_sub_component_tbl(l_sub_component_tbl_count).eco_name := p_change_order.eco_name;

Line 3258: RAISE FND_API.g_exc_unexpected_error;

3254: x_msg_data => x_out.output_status.msg_data ,
3255: x_msg_count => x_out.output_status.msg_count
3256: );
3257: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
3258: RAISE FND_API.g_exc_unexpected_error;
3259: END IF;
3260:
3261: l_sub_component_tbl(l_sub_component_tbl_count).eco_name := p_change_order.eco_name;
3262: l_sub_component_tbl(l_sub_component_tbl_count).organization_code := p_change_order.organization_code ;

Line 3269: OR p_revised_item_type_tbl(i).component_item_tbl(j).substitute_component_tbl(k).start_effective_date =fnd_api.g_miss_date) THEN

3265: l_sub_component_tbl(l_sub_component_tbl_count).operation_sequence_number := p_revised_item_type_tbl(i).component_item_tbl(j).operation_sequence_number;
3266: l_sub_component_tbl(l_sub_component_tbl_count).component_item_name := p_revised_item_type_tbl(i).component_item_tbl(j).component_item_name ;
3267: l_sub_component_tbl(l_sub_component_tbl_count).alternate_bom_code := p_revised_item_type_tbl(i).alternate_bom_code;
3268: IF (p_revised_item_type_tbl(i).component_item_tbl(j).substitute_component_tbl(k).start_effective_date IS NULL
3269: OR p_revised_item_type_tbl(i).component_item_tbl(j).substitute_component_tbl(k).start_effective_date =fnd_api.g_miss_date) THEN
3270: l_sub_component_tbl(l_sub_component_tbl_count).start_effective_date := l_effectivity_date + 1/86400;
3271: ELSE
3272: l_sub_component_tbl(l_sub_component_tbl_count).start_effective_date := p_revised_item_type_tbl(i).component_item_tbl(j).substitute_component_tbl(k).start_effective_date;
3273: END IF;

Line 3342: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

3338: ,x_msg_count => x_out.output_status.msg_count
3339: );
3340:
3341: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING ENG_ECO_PUB.process_eco');
3342: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
3343: RAISE FND_API.g_exc_unexpected_error;
3344: END IF;
3345:
3346: SELECT change_id ,change_notice INTO x_out.change_id,x_out.change_notice

Line 3343: RAISE FND_API.g_exc_unexpected_error;

3339: );
3340:
3341: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING ENG_ECO_PUB.process_eco');
3342: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
3343: RAISE FND_API.g_exc_unexpected_error;
3344: END IF;
3345:
3346: SELECT change_id ,change_notice INTO x_out.change_id,x_out.change_notice
3347: FROM eng_engineering_changes

Line 3354: IF FND_API.to_boolean( p_commit ) THEN

3350:
3351: x_out.organization_code := p_change_order.organization_code;
3352: x_out.organization_id := l_organization_id;
3353:
3354: IF FND_API.to_boolean( p_commit ) THEN
3355: COMMIT;
3356: END IF;
3357: INV_EBI_UTIL.debug_line('STEP: 40 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_eco');
3358: EXCEPTION

Line 3359: WHEN FND_API.g_exc_unexpected_error THEN

3355: COMMIT;
3356: END IF;
3357: INV_EBI_UTIL.debug_line('STEP: 40 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_eco');
3358: EXCEPTION
3359: WHEN FND_API.g_exc_unexpected_error THEN
3360: ROLLBACK TO inv_ebi_proc_eco_save_pnt;
3361: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
3362: IF(x_out.output_status.msg_data IS NULL) THEN
3363: fnd_msg_pub.count_and_get(

Line 3361: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

3357: INV_EBI_UTIL.debug_line('STEP: 40 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_eco');
3358: EXCEPTION
3359: WHEN FND_API.g_exc_unexpected_error THEN
3360: ROLLBACK TO inv_ebi_proc_eco_save_pnt;
3361: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
3362: IF(x_out.output_status.msg_data IS NULL) THEN
3363: fnd_msg_pub.count_and_get(
3364: p_encoded => FND_API.g_false
3365: ,p_count => x_out.output_status.msg_count

Line 3364: p_encoded => FND_API.g_false

3360: ROLLBACK TO inv_ebi_proc_eco_save_pnt;
3361: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
3362: IF(x_out.output_status.msg_data IS NULL) THEN
3363: fnd_msg_pub.count_and_get(
3364: p_encoded => FND_API.g_false
3365: ,p_count => x_out.output_status.msg_count
3366: ,p_data => x_out.output_status.msg_data
3367: );
3368: END IF;

Line 3371: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

3367: );
3368: END IF;
3369: WHEN OTHERS THEN
3370: ROLLBACK TO inv_ebi_proc_eco_save_pnt;
3371: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
3372: IF (x_out.output_status.msg_data IS NOT NULL) THEN
3373: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_CHANGE_ORDER_HELPER.process_eco ';
3374: ELSE
3375: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_HELPER.process_eco ';

Line 3546: x_return_status := FND_API.G_RET_STS_SUCCESS;

3542:
3543: l_common_sub_comps c_common_sub_comps%ROWTYPE;
3544: BEGIN
3545: SAVEPOINT inv_ebi_comm_comp_save_pnt;
3546: x_return_status := FND_API.G_RET_STS_SUCCESS;
3547: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_comps');
3548: SELECT
3549: bom_item_type,
3550: base_item_id,

Line 3586: IF (x_return_status <> FND_API.g_ret_sts_success) THEN

3582: x_msg_data => x_msg_data ,
3583: x_msg_count => x_msg_count
3584: );
3585:
3586: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
3587: RAISE FND_API.g_exc_unexpected_error;
3588: END IF;
3589: END LOOP;
3590: CLOSE c_common_comps;

Line 3587: RAISE FND_API.g_exc_unexpected_error;

3583: x_msg_count => x_msg_count
3584: );
3585:
3586: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
3587: RAISE FND_API.g_exc_unexpected_error;
3588: END IF;
3589: END LOOP;
3590: CLOSE c_common_comps;
3591:

Line 3612: IF (x_return_status <> FND_API.g_ret_sts_success) THEN

3608: x_msg_data => x_msg_data ,
3609: x_msg_count => x_msg_count
3610: );
3611:
3612: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
3613: RAISE FND_API.g_exc_unexpected_error;
3614: END IF;
3615: END LOOP;
3616: CLOSE c_common_sub_comps ;

Line 3613: RAISE FND_API.g_exc_unexpected_error;

3609: x_msg_count => x_msg_count
3610: );
3611:
3612: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
3613: RAISE FND_API.g_exc_unexpected_error;
3614: END IF;
3615: END LOOP;
3616: CLOSE c_common_sub_comps ;
3617: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_comps');

Line 3619: WHEN FND_API.g_exc_unexpected_error THEN

3615: END LOOP;
3616: CLOSE c_common_sub_comps ;
3617: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_comps');
3618: EXCEPTION
3619: WHEN FND_API.g_exc_unexpected_error THEN
3620: ROLLBACK TO inv_ebi_comm_comp_save_pnt;
3621: IF (c_common_comps%ISOPEN) THEN
3622: CLOSE c_common_comps;
3623: END IF;

Line 3627: x_return_status := FND_API.g_ret_sts_error;

3623: END IF;
3624: IF (c_common_sub_comps%ISOPEN) THEN
3625: CLOSE c_common_sub_comps;
3626: END IF;
3627: x_return_status := FND_API.g_ret_sts_error;
3628: IF(x_msg_data IS NULL) THEN
3629: fnd_msg_pub.count_and_get(
3630: p_encoded => FND_API.g_false
3631: ,p_count => x_msg_count

Line 3630: p_encoded => FND_API.g_false

3626: END IF;
3627: x_return_status := FND_API.g_ret_sts_error;
3628: IF(x_msg_data IS NULL) THEN
3629: fnd_msg_pub.count_and_get(
3630: p_encoded => FND_API.g_false
3631: ,p_count => x_msg_count
3632: ,p_data => x_msg_data
3633: );
3634: END IF;

Line 3643: x_return_status := FND_API.g_ret_sts_unexp_error;

3639: END IF;
3640: IF (c_common_sub_comps%ISOPEN) THEN
3641: CLOSE c_common_sub_comps;
3642: END IF;
3643: x_return_status := FND_API.g_ret_sts_unexp_error;
3644: IF (x_msg_data IS NOT NULL) THEN
3645: x_msg_data := x_msg_data||' -> INV_EBI_CHANGE_ORDER_HELPER.process_common_comps ';
3646: ELSE
3647: x_msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_HELPER.process_common_comps ';

Line 3681: x_return_status := FND_API.G_RET_STS_SUCCESS;

3677:
3678:
3679: BEGIN
3680: SAVEPOINT inv_ebi_comm_bom_save_pnt;
3681: x_return_status := FND_API.G_RET_STS_SUCCESS;
3682: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_bom');
3683: l_src_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(
3684: p_organization_code => p_common_organization_code
3685: );

Line 3699: RAISE FND_API.g_exc_error;

3695: IF(l_src_bill_sequence_id IS NULL ) THEN
3696: FND_MESSAGE.set_name('INV','INV_EBI_COMMON_BILL_NOT_FOUND');
3697: FND_MESSAGE.set_token('ASSY_ITEM', p_common_assembly_item_name);
3698: FND_MSG_PUB.add;
3699: RAISE FND_API.g_exc_error;
3700: END IF;
3701:
3702: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(
3703: p_organization_code => p_organization_code

Line 3721: IF (x_return_status <> FND_API.g_ret_sts_success) THEN

3717: x_msg_data => x_msg_data,
3718: x_msg_count => x_msg_count
3719: );
3720:
3721: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
3722: RAISE FND_API.g_exc_unexpected_error;
3723: END IF;
3724: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_bom');
3725: EXCEPTION

Line 3722: RAISE FND_API.g_exc_unexpected_error;

3718: x_msg_count => x_msg_count
3719: );
3720:
3721: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
3722: RAISE FND_API.g_exc_unexpected_error;
3723: END IF;
3724: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_bom');
3725: EXCEPTION
3726: WHEN FND_API.g_exc_unexpected_error THEN

Line 3726: WHEN FND_API.g_exc_unexpected_error THEN

3722: RAISE FND_API.g_exc_unexpected_error;
3723: END IF;
3724: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_bom');
3725: EXCEPTION
3726: WHEN FND_API.g_exc_unexpected_error THEN
3727: ROLLBACK TO inv_ebi_comm_bom_save_pnt;
3728: x_return_status := FND_API.g_ret_sts_unexp_error;
3729: IF(x_msg_data IS NULL) THEN
3730: fnd_msg_pub.count_and_get(

Line 3728: x_return_status := FND_API.g_ret_sts_unexp_error;

3724: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_bom');
3725: EXCEPTION
3726: WHEN FND_API.g_exc_unexpected_error THEN
3727: ROLLBACK TO inv_ebi_comm_bom_save_pnt;
3728: x_return_status := FND_API.g_ret_sts_unexp_error;
3729: IF(x_msg_data IS NULL) THEN
3730: fnd_msg_pub.count_and_get(
3731: p_encoded => FND_API.g_false
3732: ,p_count => x_msg_count

Line 3731: p_encoded => FND_API.g_false

3727: ROLLBACK TO inv_ebi_comm_bom_save_pnt;
3728: x_return_status := FND_API.g_ret_sts_unexp_error;
3729: IF(x_msg_data IS NULL) THEN
3730: fnd_msg_pub.count_and_get(
3731: p_encoded => FND_API.g_false
3732: ,p_count => x_msg_count
3733: ,p_data => x_msg_data
3734: );
3735: END IF;

Line 3736: WHEN FND_API.g_exc_error THEN

3732: ,p_count => x_msg_count
3733: ,p_data => x_msg_data
3734: );
3735: END IF;
3736: WHEN FND_API.g_exc_error THEN
3737: ROLLBACK TO inv_ebi_comm_bom_save_pnt;
3738: x_return_status := FND_API.g_ret_sts_error;
3739: IF(x_msg_data IS NULL) THEN
3740: FND_MSG_PUB.count_and_get(

Line 3738: x_return_status := FND_API.g_ret_sts_error;

3734: );
3735: END IF;
3736: WHEN FND_API.g_exc_error THEN
3737: ROLLBACK TO inv_ebi_comm_bom_save_pnt;
3738: x_return_status := FND_API.g_ret_sts_error;
3739: IF(x_msg_data IS NULL) THEN
3740: FND_MSG_PUB.count_and_get(
3741: p_encoded => FND_API.g_false
3742: ,p_count => x_msg_count

Line 3741: p_encoded => FND_API.g_false

3737: ROLLBACK TO inv_ebi_comm_bom_save_pnt;
3738: x_return_status := FND_API.g_ret_sts_error;
3739: IF(x_msg_data IS NULL) THEN
3740: FND_MSG_PUB.count_and_get(
3741: p_encoded => FND_API.g_false
3742: ,p_count => x_msg_count
3743: ,p_data => x_msg_data
3744: );
3745: END IF;

Line 3748: x_return_status := FND_API.g_ret_sts_unexp_error;

3744: );
3745: END IF;
3746: WHEN OTHERS THEN
3747: ROLLBACK TO inv_ebi_comm_bom_save_pnt;
3748: x_return_status := FND_API.g_ret_sts_unexp_error;
3749: IF (x_msg_data IS NOT NULL) THEN
3750: x_msg_data := x_msg_data ||' -> INV_EBI_CHANGE_ORDER_HELPER.process_common_bom ';
3751: ELSE
3752: x_msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_HELPER.process_common_bom ';

Line 3791: x_return_status := FND_API.G_RET_STS_SUCCESS;

3787: common_assembly_item_id = p_common_assy_item_id AND
3788: common_organization_id = p_common_org_id;
3789:
3790: BEGIN
3791: x_return_status := FND_API.G_RET_STS_SUCCESS;
3792: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(
3793: p_organization_code => p_organization_code
3794: );
3795:

Line 3822: x_return_status := FND_API.g_ret_sts_unexp_error;

3818: END LOOP;
3819:
3820: EXCEPTION
3821: WHEN OTHERS THEN
3822: x_return_status := FND_API.g_ret_sts_unexp_error;
3823: IF (x_msg_data IS NOT NULL) THEN
3824: x_msg_data := x_msg_data ||' -> INV_EBI_CHANGE_ORDER_HELPER.get_common_bom_orgs ';
3825: ELSE
3826: x_msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_HELPER.get_common_bom_orgs ';

Line 3849: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

3845: l_output_status inv_ebi_output_status;
3846: l_count NUMBER;
3847: BEGIN
3848: SAVEPOINT inv_ebi_common_orgs_save_pnt;
3849: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
3850: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
3851: l_common_orgs := inv_ebi_org_tbl();
3852:
3853: --Get the list of orgs to which particular bom is commoned

Line 3863: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

3859: x_return_status => x_out.output_status.return_status ,
3860: x_msg_data => x_out.output_status.msg_data ,
3861: x_msg_count => x_out.output_status.msg_count
3862: ) ;
3863: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
3864: RAISE FND_API.g_exc_unexpected_error;
3865: END IF;
3866:
3867: FOR i IN 1..l_common_orgs.COUNT LOOP

Line 3864: RAISE FND_API.g_exc_unexpected_error;

3860: x_msg_data => x_out.output_status.msg_data ,
3861: x_msg_count => x_out.output_status.msg_count
3862: ) ;
3863: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
3864: RAISE FND_API.g_exc_unexpected_error;
3865: END IF;
3866:
3867: FOR i IN 1..l_common_orgs.COUNT LOOP
3868: IF(p_component_item_tbl IS NOT NULL AND p_component_item_tbl.COUNT > 0) THEN

Line 3882: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

3878: x_return_status => x_out.output_status.return_status ,
3879: x_msg_data => x_out.output_status.msg_data ,
3880: x_msg_count => x_out.output_status.msg_count
3881: );
3882: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
3883: RAISE FND_API.g_exc_unexpected_error;
3884: END IF;
3885: END IF;
3886:

Line 3883: RAISE FND_API.g_exc_unexpected_error;

3879: x_msg_data => x_out.output_status.msg_data ,
3880: x_msg_count => x_out.output_status.msg_count
3881: );
3882: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
3883: RAISE FND_API.g_exc_unexpected_error;
3884: END IF;
3885: END IF;
3886:
3887: IF( p_component_item_tbl(j).substitute_component_tbl IS NOT NULL AND

Line 3899: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

3895: x_return_status => x_out.output_status.return_status ,
3896: x_msg_data => x_out.output_status.msg_data ,
3897: x_msg_count => x_out.output_status.msg_count
3898: );
3899: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
3900: RAISE FND_API.g_exc_unexpected_error;
3901: END IF;
3902: END IF;
3903: END LOOP;

Line 3900: RAISE FND_API.g_exc_unexpected_error;

3896: x_msg_data => x_out.output_status.msg_data ,
3897: x_msg_count => x_out.output_status.msg_count
3898: );
3899: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
3900: RAISE FND_API.g_exc_unexpected_error;
3901: END IF;
3902: END IF;
3903: END LOOP;
3904: END IF;

Line 3910: WHEN FND_API.g_exc_unexpected_error THEN

3906: END IF;
3907: END LOOP;
3908:
3909: EXCEPTION
3910: WHEN FND_API.g_exc_unexpected_error THEN
3911: ROLLBACK TO inv_ebi_common_orgs_save_pnt;
3912: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
3913: IF(x_out.output_status.msg_data IS NULL) THEN
3914: fnd_msg_pub.count_and_get(

Line 3912: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

3908:
3909: EXCEPTION
3910: WHEN FND_API.g_exc_unexpected_error THEN
3911: ROLLBACK TO inv_ebi_common_orgs_save_pnt;
3912: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
3913: IF(x_out.output_status.msg_data IS NULL) THEN
3914: fnd_msg_pub.count_and_get(
3915: p_encoded => FND_API.g_false
3916: ,p_count => x_out.output_status.msg_count

Line 3915: p_encoded => FND_API.g_false

3911: ROLLBACK TO inv_ebi_common_orgs_save_pnt;
3912: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
3913: IF(x_out.output_status.msg_data IS NULL) THEN
3914: fnd_msg_pub.count_and_get(
3915: p_encoded => FND_API.g_false
3916: ,p_count => x_out.output_status.msg_count
3917: ,p_data => x_out.output_status.msg_data
3918: );
3919: END IF;

Line 3922: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

3918: );
3919: END IF;
3920: WHEN OTHERS THEN
3921: ROLLBACK TO inv_ebi_common_orgs_save_pnt;
3922: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
3923: IF (x_out.output_status.msg_data IS NOT NULL) THEN
3924: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_CHANGE_ORDER_HELPER.process_common_bom_orgs ';
3925: ELSE
3926: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_HELPER.process_common_bom_orgs ';

Line 3939: p_commit IN VARCHAR2 := FND_API.G_FALSE

3935: -- This API is used to Process bom and common bom.
3936: --
3937: ************************************************************************************/
3938: PROCEDURE process_structure_header(
3939: p_commit IN VARCHAR2 := FND_API.G_FALSE
3940: ,p_organization_code IN VARCHAR2
3941: ,p_assembly_item_name IN VARCHAR2
3942: ,p_alternate_bom_code IN VARCHAR2
3943: ,p_structure_header IN inv_ebi_structure_header_obj

Line 3961: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

3957:
3958: BEGIN
3959: SAVEPOINT inv_ebi_proc_bom_save_pnt;
3960:
3961: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
3962: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
3963: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_structure_header');
3964:
3965: l_is_bom_exists := is_bom_exists(

Line 3971: IF(l_is_bom_exists = fnd_api.g_false ) THEN

3967: p_organization_code => p_organization_code,
3968: p_alternate_bom_code => p_alternate_bom_code
3969: );
3970:
3971: IF(l_is_bom_exists = fnd_api.g_false ) THEN
3972: l_transaction_type := INV_EBI_ITEM_PUB.g_otype_create ;
3973: ELSE
3974: l_transaction_type := INV_EBI_ITEM_PUB.g_otype_update;
3975:

Line 3984: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

3980: p_alternate_bom_code => p_alternate_bom_code,
3981: p_component_item_tbl => p_component_item_tbl,
3982: x_out => x_out
3983: );
3984: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
3985: RAISE FND_API.g_exc_unexpected_error;
3986: END IF;
3987: END IF;
3988:

Line 3985: RAISE FND_API.g_exc_unexpected_error;

3981: p_component_item_tbl => p_component_item_tbl,
3982: x_out => x_out
3983: );
3984: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
3985: RAISE FND_API.g_exc_unexpected_error;
3986: END IF;
3987: END IF;
3988:
3989: IF(p_structure_header.common_assembly_item_name IS NOT NULL AND

Line 3990: p_structure_header.common_assembly_item_name <> fnd_api.g_miss_char AND

3986: END IF;
3987: END IF;
3988:
3989: IF(p_structure_header.common_assembly_item_name IS NOT NULL AND
3990: p_structure_header.common_assembly_item_name <> fnd_api.g_miss_char AND
3991: p_structure_header.common_organization_code IS NOT NULL AND
3992: p_structure_header.common_organization_code <> fnd_api.g_miss_char
3993: ) THEN
3994: --Bug 7127027

Line 3992: p_structure_header.common_organization_code <> fnd_api.g_miss_char

3988:
3989: IF(p_structure_header.common_assembly_item_name IS NOT NULL AND
3990: p_structure_header.common_assembly_item_name <> fnd_api.g_miss_char AND
3991: p_structure_header.common_organization_code IS NOT NULL AND
3992: p_structure_header.common_organization_code <> fnd_api.g_miss_char
3993: ) THEN
3994: --Bug 7127027
3995: process_common_bom(
3996: p_organization_code => p_organization_code

Line 4005: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

4001: ,x_return_status => x_out.output_status.return_status
4002: ,x_msg_data => x_out.output_status.msg_data
4003: ,x_msg_count => x_out.output_status.msg_count
4004: );
4005: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4006: RAISE FND_API.g_exc_unexpected_error;
4007: END IF;
4008: END IF;
4009:

Line 4006: RAISE FND_API.g_exc_unexpected_error;

4002: ,x_msg_data => x_out.output_status.msg_data
4003: ,x_msg_count => x_out.output_status.msg_count
4004: );
4005: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4006: RAISE FND_API.g_exc_unexpected_error;
4007: END IF;
4008: END IF;
4009:
4010: l_bom_header_rec.assembly_item_name := p_assembly_item_name ;

Line 4044: l_bom_header_rec.structure_type_name = fnd_api.g_miss_char )

4040: l_bom_header_rec.enable_attrs_update := p_structure_header.enable_attrs_update ;
4041: l_bom_header_rec.structure_type_name := p_structure_header.structure_type_name ;
4042:
4043: IF(l_bom_header_rec.structure_type_name IS NULL OR
4044: l_bom_header_rec.structure_type_name = fnd_api.g_miss_char )
4045: AND (INV_EBI_UTIL.is_pim_installed) THEN
4046: IF p_name_val_list.name_value_table IS NOT NULL THEN
4047: FOR i in p_name_val_list.name_value_table.FIRST..p_name_val_list.name_value_table.LAST LOOP
4048: IF UPPER(p_name_val_list.name_value_table(i).param_name) = G_DEFAULT_STRUCTURE_TYPE THEN

Line 4072: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

4068: ,x_return_status => x_out.output_status.return_status
4069: ,x_msg_count => x_out.output_status.msg_count
4070: );
4071: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING BOM_BO_PUB.process_bom');
4072: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4073: RAISE FND_API.g_exc_unexpected_error;
4074: END IF;
4075: IF FND_API.to_boolean( p_commit ) THEN
4076: COMMIT;

Line 4073: RAISE FND_API.g_exc_unexpected_error;

4069: ,x_msg_count => x_out.output_status.msg_count
4070: );
4071: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING BOM_BO_PUB.process_bom');
4072: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4073: RAISE FND_API.g_exc_unexpected_error;
4074: END IF;
4075: IF FND_API.to_boolean( p_commit ) THEN
4076: COMMIT;
4077: END IF;

Line 4075: IF FND_API.to_boolean( p_commit ) THEN

4071: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING BOM_BO_PUB.process_bom');
4072: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4073: RAISE FND_API.g_exc_unexpected_error;
4074: END IF;
4075: IF FND_API.to_boolean( p_commit ) THEN
4076: COMMIT;
4077: END IF;
4078: INV_EBI_UTIL.debug_line('STEP: 40 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_structure_header');
4079: EXCEPTION

Line 4080: WHEN FND_API.g_exc_unexpected_error THEN

4076: COMMIT;
4077: END IF;
4078: INV_EBI_UTIL.debug_line('STEP: 40 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_structure_header');
4079: EXCEPTION
4080: WHEN FND_API.g_exc_unexpected_error THEN
4081: ROLLBACK TO inv_ebi_proc_bom_save_pnt;
4082: x_out.output_status.return_status := FND_API.g_ret_sts_error;
4083: IF(x_out.output_status.msg_data IS NULL) THEN
4084: fnd_msg_pub.count_and_get(

Line 4082: x_out.output_status.return_status := FND_API.g_ret_sts_error;

4078: INV_EBI_UTIL.debug_line('STEP: 40 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_structure_header');
4079: EXCEPTION
4080: WHEN FND_API.g_exc_unexpected_error THEN
4081: ROLLBACK TO inv_ebi_proc_bom_save_pnt;
4082: x_out.output_status.return_status := FND_API.g_ret_sts_error;
4083: IF(x_out.output_status.msg_data IS NULL) THEN
4084: fnd_msg_pub.count_and_get(
4085: p_encoded => FND_API.g_false
4086: ,p_count => x_out.output_status.msg_count

Line 4085: p_encoded => FND_API.g_false

4081: ROLLBACK TO inv_ebi_proc_bom_save_pnt;
4082: x_out.output_status.return_status := FND_API.g_ret_sts_error;
4083: IF(x_out.output_status.msg_data IS NULL) THEN
4084: fnd_msg_pub.count_and_get(
4085: p_encoded => FND_API.g_false
4086: ,p_count => x_out.output_status.msg_count
4087: ,p_data => x_out.output_status.msg_data
4088: );
4089: END IF;

Line 4092: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

4088: );
4089: END IF;
4090: WHEN OTHERS THEN
4091: ROLLBACK TO inv_ebi_proc_bom_save_pnt;
4092: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
4093: IF (x_out.output_status.msg_data IS NOT NULL) THEN
4094: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_CHANGE_ORDER_HELPER.process_structure_header ';
4095: ELSE
4096: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_HELPER.process_structure_header ';

Line 4136: l_include_rev_items VARCHAR2(1):= fnd_api.g_true;

4132: l_sub_index NUMBER;
4133: l_ref_index NUMBER;
4134: l_change_id NUMBER := NULL;
4135: l_revised_item_sequence_id NUMBER := NULL;
4136: l_include_rev_items VARCHAR2(1):= fnd_api.g_true;
4137: l_include_comp_items VARCHAR2(1):= fnd_api.g_true;
4138: l_include_sub_comp VARCHAR2(1):= fnd_api.g_true;
4139: l_include_ref_designators VARCHAR2(1):= fnd_api.g_true;
4140: l_item_obj inv_ebi_item_obj;

Line 4137: l_include_comp_items VARCHAR2(1):= fnd_api.g_true;

4133: l_ref_index NUMBER;
4134: l_change_id NUMBER := NULL;
4135: l_revised_item_sequence_id NUMBER := NULL;
4136: l_include_rev_items VARCHAR2(1):= fnd_api.g_true;
4137: l_include_comp_items VARCHAR2(1):= fnd_api.g_true;
4138: l_include_sub_comp VARCHAR2(1):= fnd_api.g_true;
4139: l_include_ref_designators VARCHAR2(1):= fnd_api.g_true;
4140: l_item_obj inv_ebi_item_obj;
4141:

Line 4138: l_include_sub_comp VARCHAR2(1):= fnd_api.g_true;

4134: l_change_id NUMBER := NULL;
4135: l_revised_item_sequence_id NUMBER := NULL;
4136: l_include_rev_items VARCHAR2(1):= fnd_api.g_true;
4137: l_include_comp_items VARCHAR2(1):= fnd_api.g_true;
4138: l_include_sub_comp VARCHAR2(1):= fnd_api.g_true;
4139: l_include_ref_designators VARCHAR2(1):= fnd_api.g_true;
4140: l_item_obj inv_ebi_item_obj;
4141:
4142: CURSOR c_change_order_type(p_change_id IN VARCHAR2) IS

Line 4139: l_include_ref_designators VARCHAR2(1):= fnd_api.g_true;

4135: l_revised_item_sequence_id NUMBER := NULL;
4136: l_include_rev_items VARCHAR2(1):= fnd_api.g_true;
4137: l_include_comp_items VARCHAR2(1):= fnd_api.g_true;
4138: l_include_sub_comp VARCHAR2(1):= fnd_api.g_true;
4139: l_include_ref_designators VARCHAR2(1):= fnd_api.g_true;
4140: l_item_obj inv_ebi_item_obj;
4141:
4142: CURSOR c_change_order_type(p_change_id IN VARCHAR2) IS
4143: SELECT

Line 4494: x_return_status := fnd_api.g_ret_sts_success;

4490: WHERE
4491: revised_item_sequence_id = p_revised_item_sequence_id;
4492:
4493: BEGIN
4494: x_return_status := fnd_api.g_ret_sts_success;
4495: l_change_id := p_change_id ;
4496: l_revised_item_sequence_id := p_revised_item_sequence_id;
4497:
4498: FND_MSG_PUB.initialize();

Line 4502: RAISE FND_API.g_exc_error;

4498: FND_MSG_PUB.initialize();
4499: IF (l_change_id IS NULL AND l_revised_item_sequence_id IS NULL) THEN
4500: FND_MESSAGE.set_name('INV','INV_EBI_CHG_ID_REV_SEQ_NULL');
4501: FND_MSG_PUB.add;
4502: RAISE FND_API.g_exc_error;
4503: END IF;
4504:
4505: IF (l_revised_item_sequence_id IS NOT NULL AND l_change_id IS NULL) THEN
4506: OPEN c_change_id(l_revised_item_sequence_id);

Line 4512: RAISE FND_API.g_exc_error;

4508: IF c_change_id%NOTFOUND THEN
4509: FND_MESSAGE.set_name('INV','INV_EBI_REV_SEQ_ID_INVALID');
4510: FND_MESSAGE.set_token('REV_SEQ_ID',l_revised_item_sequence_id);
4511: FND_MSG_PUB.add;
4512: RAISE FND_API.g_exc_error;
4513: END IF;
4514: CLOSE c_change_id;
4515: END IF;
4516:

Line 4535: l_include_rev_items := fnd_api.g_false;

4531: END LOOP;
4532: END IF;
4533:
4534: IF NVL(p_last_update_status,'Y') = 'N' THEN
4535: l_include_rev_items := fnd_api.g_false;
4536: l_include_comp_items := fnd_api.g_false;
4537: l_include_sub_comp := fnd_api.g_false;
4538: l_include_ref_designators := fnd_api.g_false;
4539: END IF;

Line 4536: l_include_comp_items := fnd_api.g_false;

4532: END IF;
4533:
4534: IF NVL(p_last_update_status,'Y') = 'N' THEN
4535: l_include_rev_items := fnd_api.g_false;
4536: l_include_comp_items := fnd_api.g_false;
4537: l_include_sub_comp := fnd_api.g_false;
4538: l_include_ref_designators := fnd_api.g_false;
4539: END IF;
4540: l_eco_revision_tbl := inv_ebi_eco_revision_tbl();

Line 4537: l_include_sub_comp := fnd_api.g_false;

4533:
4534: IF NVL(p_last_update_status,'Y') = 'N' THEN
4535: l_include_rev_items := fnd_api.g_false;
4536: l_include_comp_items := fnd_api.g_false;
4537: l_include_sub_comp := fnd_api.g_false;
4538: l_include_ref_designators := fnd_api.g_false;
4539: END IF;
4540: l_eco_revision_tbl := inv_ebi_eco_revision_tbl();
4541:

Line 4538: l_include_ref_designators := fnd_api.g_false;

4534: IF NVL(p_last_update_status,'Y') = 'N' THEN
4535: l_include_rev_items := fnd_api.g_false;
4536: l_include_comp_items := fnd_api.g_false;
4537: l_include_sub_comp := fnd_api.g_false;
4538: l_include_ref_designators := fnd_api.g_false;
4539: END IF;
4540: l_eco_revision_tbl := inv_ebi_eco_revision_tbl();
4541:
4542: OPEN c_change_order_type (l_change_id);

Line 4548: RAISE FND_API.g_exc_error;

4544: IF c_change_order_type%NOTFOUND THEN
4545: FND_MESSAGE.set_name('INV','INV_EBI_CHG_ID_INVALID');
4546: FND_MESSAGE.set_token('CHG_ID',l_change_id);
4547: FND_MSG_PUB.add;
4548: RAISE FND_API.g_exc_error;
4549: END IF;
4550: l_eco_change_order_obj := inv_ebi_change_order_obj(
4551: c_eco_header.change_notice
4552: ,l_change_id

Line 4657: IF (l_include_rev_items = fnd_api.g_true) THEN

4653: l_eco_revision_tbl(l_current_index) := l_eco_revision_obj;
4654: l_current_index := l_current_index + 1;
4655: END LOOP;
4656:
4657: IF (l_include_rev_items = fnd_api.g_true) THEN
4658: l_reviseditem_index := 1;
4659: FOR ri IN c_revised_item(l_change_id)
4660: LOOP
4661: OPEN c_structure_header(l_change_id,ri.revised_item_id);

Line 4698: IF (l_include_comp_items = fnd_api.g_true) THEN

4694: );
4695: CLOSE c_structure_header;
4696: l_comp_index := 1;
4697: l_revision_component_tbl := inv_ebi_rev_comp_tbl();
4698: IF (l_include_comp_items = fnd_api.g_true) THEN
4699: FOR rc IN c_revision_component(l_change_id,ri.revised_item_id)
4700: LOOP
4701: l_ref_index := 1;
4702: l_reference_designator_tbl := inv_ebi_ref_desg_tbl();

Line 4703: IF (l_include_ref_designators = fnd_api.g_true) THEN

4699: FOR rc IN c_revision_component(l_change_id,ri.revised_item_id)
4700: LOOP
4701: l_ref_index := 1;
4702: l_reference_designator_tbl := inv_ebi_ref_desg_tbl();
4703: IF (l_include_ref_designators = fnd_api.g_true) THEN
4704: FOR rd IN c_reference_designator(l_change_id,ri.revised_item_id,rc.component_item_id)
4705: LOOP
4706: l_reference_designator_tbl.extend();
4707: l_reference_designator_obj := inv_ebi_ref_desg_obj(

Line 4739: END IF; -- IF (l_include_ref_designators = fnd_api.g_true) THEN

4735: ,NULL);
4736: l_reference_designator_tbl(l_ref_index) := l_reference_designator_obj;
4737: l_ref_index := l_ref_index + 1;
4738: END LOOP;
4739: END IF; -- IF (l_include_ref_designators = fnd_api.g_true) THEN
4740:
4741: l_sub_index :=1;
4742: l_substitute_component_tbl := inv_ebi_sub_comp_tbl();
4743: IF (l_include_sub_comp = fnd_api.g_true) THEN

Line 4743: IF (l_include_sub_comp = fnd_api.g_true) THEN

4739: END IF; -- IF (l_include_ref_designators = fnd_api.g_true) THEN
4740:
4741: l_sub_index :=1;
4742: l_substitute_component_tbl := inv_ebi_sub_comp_tbl();
4743: IF (l_include_sub_comp = fnd_api.g_true) THEN
4744: FOR sc IN c_substitute_component(l_change_id,ri.revised_item_id,rc.component_item_id)
4745: LOOP
4746: l_substitute_component_tbl.extend();
4747: l_substitute_component_obj := inv_ebi_sub_comp_obj(

Line 4782: END IF; -- IF (l_include_sub_comp = fnd_api.g_true) THEN

4778: ,NULL);
4779: l_substitute_component_tbl(l_sub_index) := l_substitute_component_obj;
4780: l_sub_index := l_sub_index + 1;
4781: END LOOP;
4782: END IF; -- IF (l_include_sub_comp = fnd_api.g_true) THEN
4783:
4784: l_revision_component_tbl.extend();
4785: l_revision_component_obj := inv_ebi_rev_comp_obj(
4786: NULL

Line 4857: END IF; -- IF (l_include_comp_items = fnd_api.g_true) THEN

4853: ,NULL);
4854: l_revision_component_tbl(l_comp_index) := l_revision_component_obj;
4855: l_comp_index := l_comp_index + 1;
4856: END LOOP;
4857: END IF; -- IF (l_include_comp_items = fnd_api.g_true) THEN
4858:
4859:
4860: IF (l_revised_item_sequence_id IS NULL
4861: OR ri.revised_item_sequence_id = l_revised_item_sequence_id) THEN

Line 4997: END IF; -- IF (l_include_rev_items = fnd_api.g_true) THEN

4993: l_revised_item_tbl(l_reviseditem_index) := l_revised_item_obj;
4994: l_reviseditem_index := l_reviseditem_index + 1;
4995: END IF;
4996: END LOOP;
4997: END IF; -- IF (l_include_rev_items = fnd_api.g_true) THEN
4998:
4999: --Bug 7240247 To Retrieve Change order Header level Udas if any exists for this change_id
5000: get_change_order_uda(
5001: p_change_id => p_change_id,

Line 5008: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

5004: x_msg_count => x_msg_count,
5005: x_msg_data => x_msg_data
5006: );
5007:
5008: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5009: RAISE FND_API.g_exc_unexpected_error;
5010: END IF;
5011:
5012: --Bug 7240247 To Retrieve Structure Header level Udas if any exists for this change_id

Line 5009: RAISE FND_API.g_exc_unexpected_error;

5005: x_msg_data => x_msg_data
5006: );
5007:
5008: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5009: RAISE FND_API.g_exc_unexpected_error;
5010: END IF;
5011:
5012: --Bug 7240247 To Retrieve Structure Header level Udas if any exists for this change_id
5013: FOR i IN 1..l_revised_item_tbl.COUNT LOOP

Line 5024: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

5020: x_msg_count => x_msg_count,
5021: x_msg_data => x_msg_data
5022: );
5023:
5024: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5025: RAISE FND_API.g_exc_unexpected_error;
5026: END IF;
5027:
5028: --Bug 7240247

Line 5025: RAISE FND_API.g_exc_unexpected_error;

5021: x_msg_data => x_msg_data
5022: );
5023:
5024: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5025: RAISE FND_API.g_exc_unexpected_error;
5026: END IF;
5027:
5028: --Bug 7240247
5029: FOR j IN 1..l_revised_item_tbl(i).component_item_tbl.COUNT LOOP

Line 5042: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

5038: x_msg_count => x_msg_count,
5039: x_msg_data => x_msg_data
5040: );
5041:
5042: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5043: RAISE FND_API.g_exc_unexpected_error;
5044: END IF;
5045: END LOOP;
5046:

Line 5043: RAISE FND_API.g_exc_unexpected_error;

5039: x_msg_data => x_msg_data
5040: );
5041:
5042: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5043: RAISE FND_API.g_exc_unexpected_error;
5044: END IF;
5045: END LOOP;
5046:
5047: END LOOP;

Line 5052: WHEN FND_API.g_exc_error THEN

5048:
5049: x_eco_obj := inv_ebi_eco_obj(l_eco_change_order_obj,l_eco_revision_tbl,l_revised_item_tbl,NULL);
5050:
5051: EXCEPTION
5052: WHEN FND_API.g_exc_error THEN
5053: x_return_status := FND_API.g_ret_sts_error;
5054: IF(x_msg_data IS NULL) THEN
5055: FND_MSG_PUB.count_and_get(
5056: p_encoded => FND_API.g_false

Line 5053: x_return_status := FND_API.g_ret_sts_error;

5049: x_eco_obj := inv_ebi_eco_obj(l_eco_change_order_obj,l_eco_revision_tbl,l_revised_item_tbl,NULL);
5050:
5051: EXCEPTION
5052: WHEN FND_API.g_exc_error THEN
5053: x_return_status := FND_API.g_ret_sts_error;
5054: IF(x_msg_data IS NULL) THEN
5055: FND_MSG_PUB.count_and_get(
5056: p_encoded => FND_API.g_false
5057: ,p_count => x_msg_count

Line 5056: p_encoded => FND_API.g_false

5052: WHEN FND_API.g_exc_error THEN
5053: x_return_status := FND_API.g_ret_sts_error;
5054: IF(x_msg_data IS NULL) THEN
5055: FND_MSG_PUB.count_and_get(
5056: p_encoded => FND_API.g_false
5057: ,p_count => x_msg_count
5058: ,p_data => x_msg_data
5059: );
5060: END IF;

Line 5062: x_return_status := FND_API.g_ret_sts_error;

5058: ,p_data => x_msg_data
5059: );
5060: END IF;
5061: WHEN OTHERS THEN
5062: x_return_status := FND_API.g_ret_sts_error;
5063: IF (x_msg_data IS NOT NULL) THEN
5064: x_msg_data := x_msg_data ||' -> at INV_EBI_CHANGE_ORDER_HELPER.get_eco';
5065: ELSE
5066: x_msg_data := SQLERRM||' at INV_EBI_CHANGE_ORDER_HELPER.get_eco ';

Line 5089: x_return_status := FND_API.g_ret_sts_success;

5085: l_eco_output_tbl inv_ebi_change_id_obj_tbl;
5086: l_counter NUMBER:=0;
5087: l_org_code VARCHAR2(10);
5088: BEGIN
5089: x_return_status := FND_API.g_ret_sts_success;
5090: l_eco_output_tbl := inv_ebi_change_id_obj_tbl();
5091:
5092: IF p_org_codes IS NOT NULL THEN
5093: l_org_tbl := INV_EBI_ITEM_HELPER.parse_input_string(p_org_codes);

Line 5120: x_return_status := FND_API.g_ret_sts_unexp_error;

5116: x_eco_tbl := l_eco_output_tbl;
5117:
5118: EXCEPTION
5119: WHEN OTHERS THEN
5120: x_return_status := FND_API.g_ret_sts_unexp_error;
5121: x_msg_data := SQLERRM ||' at INV_EBI_ITEM_HELPER.filter_ecos_based_on_org';
5122: END filter_ecos_based_on_org;
5123:
5124: /***************************************************************************************************

Line 5157: x_return_status := FND_API.g_ret_sts_success;

5153: SELECT change_id
5154: FROM eng_engineering_changes
5155: WHERE change_notice = p_chg_notice;
5156: BEGIN
5157: x_return_status := FND_API.g_ret_sts_success;
5158: l_eco_output_tbl :=inv_ebi_change_id_obj_tbl();
5159:
5160: IF p_eco_names IS NOT NULL THEN
5161: l_eco_tbl := INV_EBI_ITEM_HELPER.parse_input_string(p_eco_names);

Line 5185: RAISE FND_API.G_EXC_ERROR;

5181: ELSE
5182: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
5183: FND_MESSAGE.set_token('COL_VALUE', l_eco_tbl(i));
5184: FND_MSG_PUB.add;
5185: RAISE FND_API.G_EXC_ERROR;
5186: END IF;
5187: EXCEPTION
5188: WHEN FND_API.G_EXC_ERROR THEN
5189: x_return_status := FND_API.g_ret_sts_error;

Line 5188: WHEN FND_API.G_EXC_ERROR THEN

5184: FND_MSG_PUB.add;
5185: RAISE FND_API.G_EXC_ERROR;
5186: END IF;
5187: EXCEPTION
5188: WHEN FND_API.G_EXC_ERROR THEN
5189: x_return_status := FND_API.g_ret_sts_error;
5190: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
5191: ,p_count => x_msg_count
5192: ,p_data => l_msg_data

Line 5189: x_return_status := FND_API.g_ret_sts_error;

5185: RAISE FND_API.G_EXC_ERROR;
5186: END IF;
5187: EXCEPTION
5188: WHEN FND_API.G_EXC_ERROR THEN
5189: x_return_status := FND_API.g_ret_sts_error;
5190: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
5191: ,p_count => x_msg_count
5192: ,p_data => l_msg_data
5193: );

Line 5190: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

5186: END IF;
5187: EXCEPTION
5188: WHEN FND_API.G_EXC_ERROR THEN
5189: x_return_status := FND_API.g_ret_sts_error;
5190: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
5191: ,p_count => x_msg_count
5192: ,p_data => l_msg_data
5193: );
5194: x_msg_data := x_msg_data || l_msg_data ||' , ' ;

Line 5196: x_return_status := FND_API.g_ret_sts_error;

5192: ,p_data => l_msg_data
5193: );
5194: x_msg_data := x_msg_data || l_msg_data ||' , ' ;
5195: WHEN OTHERS THEN
5196: x_return_status := FND_API.g_ret_sts_error;
5197: x_msg_data := SQLERRM ||' at INV_EBI_CHANGE_ORDER_HELPER.parse_and_get_eco';
5198: END;
5199: END LOOP;
5200: END IF;

Line 5219: RAISE FND_API.G_EXC_ERROR;

5215: ELSE
5216: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
5217: FND_MESSAGE.set_token('COL_VALUE', l_org_tbl(i));
5218: FND_MSG_PUB.add;
5219: RAISE FND_API.G_EXC_ERROR;
5220: END IF;
5221: EXCEPTION
5222: WHEN FND_API.G_EXC_ERROR THEN
5223: x_return_status := FND_API.g_ret_sts_error;

Line 5222: WHEN FND_API.G_EXC_ERROR THEN

5218: FND_MSG_PUB.add;
5219: RAISE FND_API.G_EXC_ERROR;
5220: END IF;
5221: EXCEPTION
5222: WHEN FND_API.G_EXC_ERROR THEN
5223: x_return_status := FND_API.g_ret_sts_error;
5224: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
5225: ,p_count => x_msg_count
5226: ,p_data => l_msg_data

Line 5223: x_return_status := FND_API.g_ret_sts_error;

5219: RAISE FND_API.G_EXC_ERROR;
5220: END IF;
5221: EXCEPTION
5222: WHEN FND_API.G_EXC_ERROR THEN
5223: x_return_status := FND_API.g_ret_sts_error;
5224: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
5225: ,p_count => x_msg_count
5226: ,p_data => l_msg_data
5227: );

Line 5224: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

5220: END IF;
5221: EXCEPTION
5222: WHEN FND_API.G_EXC_ERROR THEN
5223: x_return_status := FND_API.g_ret_sts_error;
5224: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
5225: ,p_count => x_msg_count
5226: ,p_data => l_msg_data
5227: );
5228: x_msg_data := x_msg_data || l_msg_data ||' , ' ;

Line 5230: x_return_status := FND_API.g_ret_sts_error;

5226: ,p_data => l_msg_data
5227: );
5228: x_msg_data := x_msg_data || l_msg_data ||' , ' ;
5229: WHEN OTHERS THEN
5230: x_return_status := FND_API.g_ret_sts_error;
5231: x_msg_data := SQLERRM ||' at INV_EBI_CHANGE_ORDER_HELPER.parse_and_get_eco';
5232: END;
5233: END LOOP;
5234: END IF;

Line 5287: RAISE FND_API.G_EXC_ERROR;

5283: IF l_count = 0 THEN
5284: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_USER_INPUT');
5285: FND_MESSAGE.set_token('USER_INPUT', l_valid_eco_tbl(i));
5286: FND_MSG_PUB.add;
5287: RAISE FND_API.G_EXC_ERROR;
5288: END IF;
5289: EXCEPTION
5290: WHEN FND_API.G_EXC_ERROR THEN
5291: x_return_status := FND_API.g_ret_sts_error;

Line 5290: WHEN FND_API.G_EXC_ERROR THEN

5286: FND_MSG_PUB.add;
5287: RAISE FND_API.G_EXC_ERROR;
5288: END IF;
5289: EXCEPTION
5290: WHEN FND_API.G_EXC_ERROR THEN
5291: x_return_status := FND_API.g_ret_sts_error;
5292: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
5293: ,p_count => x_msg_count
5294: ,p_data => l_msg_data

Line 5291: x_return_status := FND_API.g_ret_sts_error;

5287: RAISE FND_API.G_EXC_ERROR;
5288: END IF;
5289: EXCEPTION
5290: WHEN FND_API.G_EXC_ERROR THEN
5291: x_return_status := FND_API.g_ret_sts_error;
5292: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
5293: ,p_count => x_msg_count
5294: ,p_data => l_msg_data
5295: );

Line 5292: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

5288: END IF;
5289: EXCEPTION
5290: WHEN FND_API.G_EXC_ERROR THEN
5291: x_return_status := FND_API.g_ret_sts_error;
5292: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
5293: ,p_count => x_msg_count
5294: ,p_data => l_msg_data
5295: );
5296: x_msg_data := x_msg_data || l_msg_data ;

Line 5298: x_return_status := FND_API.g_ret_sts_unexp_error;

5294: ,p_data => l_msg_data
5295: );
5296: x_msg_data := x_msg_data || l_msg_data ;
5297: WHEN OTHERS THEN
5298: x_return_status := FND_API.g_ret_sts_unexp_error;
5299: x_msg_data := SQLERRM ||' at INV_EBI_CHANGE_ORDER_HELPER.parse_and_get_eco';
5300: END;
5301: END LOOP;
5302: END IF;

Line 5306: x_return_status := FND_API.g_ret_sts_unexp_error;

5302: END IF;
5303: x_eco_tbl := l_eco_output_tbl;
5304: EXCEPTION
5305: WHEN OTHERS THEN
5306: x_return_status := FND_API.g_ret_sts_unexp_error;
5307: x_msg_data := SQLERRM ||' at INV_EBI_CHANGE_ORDER_HELPER.parse_and_get_eco';
5308: END parse_and_get_eco;
5309:
5310: /************************************************************************************

Line 5368: x_return_status := FND_API.G_RET_STS_SUCCESS;

5364: FROM dual ) c ) geco;
5365: l_ind_val NUMBER :=1;
5366: BEGIN
5367: FND_MSG_PUB.initialize();
5368: x_return_status := FND_API.G_RET_STS_SUCCESS;
5369:
5370: IF (p_name_value_list IS NOT NULL AND p_name_value_list.COUNT > 0) THEN
5371: l_eco_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Change Order Name');
5372: l_org_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Organization Code');

Line 5408: IF (l_return_status <> FND_API.g_ret_sts_success) THEN

5404: ,x_msg_count => l_msg_count
5405: ,x_msg_data => l_msg_data);
5406: END IF;
5407:
5408: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
5409: x_return_status := l_return_status;
5410: IF l_msg_data IS NOT NULL THEN
5411: x_msg_data := l_msg_data;
5412: END IF;

Line 5441: IF (l_return_status = FND_API.g_ret_sts_success) THEN

5437: ,x_return_status => l_return_status
5438: ,x_msg_count => l_msg_count
5439: ,x_msg_data => l_msg_data);
5440:
5441: IF (l_return_status = FND_API.g_ret_sts_success) THEN
5442: x_eco := l_eco_org_output_tbl;
5443: ELSE
5444: x_return_status := l_return_status;
5445: IF x_msg_data IS NOT NULL THEN

Line 5458: x_return_status := FND_API.g_ret_sts_unexp_error;

5454: END IF;
5455:
5456: EXCEPTION
5457: WHEN OTHERS THEN
5458: x_return_status := FND_API.g_ret_sts_unexp_error;
5459: x_msg_data := SQLERRM ||' at INV_EBI_CHANGE_ORDER_HELPER.get_eco_list';
5460: IF (c_get_final_eco_list%ISOPEN) THEN
5461: CLOSE c_get_final_eco_list;
5462: END IF;