[Home] [Help]
256: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
257: l_output_status inv_ebi_output_status;
258: BEGIN
259: x_item := p_item;
260: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
261: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
262: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
263: IF ( (p_item.main_obj_type.organization_id IS NULL OR p_item.main_obj_type.organization_id = fnd_api.g_miss_num)
264: AND p_item.main_obj_type.organization_code IS NOT NULL ) THEN
259: x_item := p_item;
260: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
261: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
262: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
263: IF ( (p_item.main_obj_type.organization_id IS NULL OR p_item.main_obj_type.organization_id = fnd_api.g_miss_num)
264: AND p_item.main_obj_type.organization_code IS NOT NULL ) THEN
265: l_pk_col_name_val_pairs.EXTEND(1);
266: l_pk_col_name_val_pairs(1).name := 'organization_code';
267: l_pk_col_name_val_pairs(1).value := p_Item.main_obj_type.organization_code;
273: IF (x_item.main_obj_type.organization_id IS NULL) THEN
274: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
275: FND_MESSAGE.set_token('COL_VALUE', p_Item.main_obj_type.organization_code);
276: FND_MSG_PUB.add;
277: RAISE FND_API.g_exc_error;
278: END IF;
279: END IF;
280: IF ( (p_item.main_obj_type.inventory_item_id IS NULL OR p_item.main_obj_type.inventory_item_id= fnd_api.g_miss_num)
281: AND p_item.main_obj_type.item_number IS NOT NULL ) THEN
276: FND_MSG_PUB.add;
277: RAISE FND_API.g_exc_error;
278: END IF;
279: END IF;
280: IF ( (p_item.main_obj_type.inventory_item_id IS NULL OR p_item.main_obj_type.inventory_item_id= fnd_api.g_miss_num)
281: AND p_item.main_obj_type.item_number IS NOT NULL ) THEN
282: l_pk_col_name_val_pairs.EXTEND(2);
283: l_pk_col_name_val_pairs(1).name := 'concatenated_segments';
284: l_pk_col_name_val_pairs(1).value := p_item.main_obj_type.item_number;
289: ,p_entity_name => INV_EBI_ITEM_HELPER.G_INVENTORY_ITEM
290: );
291: l_pk_col_name_val_pairs.TRIM(2);
292: END IF;
293: IF ( (p_item.main_obj_type.template_id IS NULL OR p_item.main_obj_type.template_id =fnd_api.g_miss_num)
294: AND p_item.main_obj_type.template_name IS NOT NULL) THEN
295: l_pk_col_name_val_pairs.EXTEND(1);
296: l_pk_col_name_val_pairs(1).name := 'template_name';
297: l_pk_col_name_val_pairs(1).value := p_Item.main_obj_type.template_name;
315: IF (x_item.org_id_obj_type(i).org_id IS NULL) THEN
316: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
317: FND_MESSAGE.set_token('COL_VALUE', p_item.org_id_obj_type(i).org_code);
318: FND_MSG_PUB.add;
319: RAISE FND_API.g_exc_error;
320: END IF;
321: END IF;
322: END LOOP;
323: END IF;
320: END IF;
321: END IF;
322: END LOOP;
323: END IF;
324: IF ( (p_item.main_obj_type.item_catalog_group_id IS NULL OR p_item.main_obj_type.item_catalog_group_id=fnd_api.g_miss_num)
325: AND p_item.main_obj_type.item_catalog_group_code IS NOT NULL
326: AND p_item.main_obj_type.item_catalog_group_code <> fnd_api.g_miss_char) THEN
327: l_pk_col_name_val_pairs.EXTEND(1);
328: l_pk_col_name_val_pairs(1).name := 'concatenated_segments';
322: END LOOP;
323: END IF;
324: IF ( (p_item.main_obj_type.item_catalog_group_id IS NULL OR p_item.main_obj_type.item_catalog_group_id=fnd_api.g_miss_num)
325: AND p_item.main_obj_type.item_catalog_group_code IS NOT NULL
326: AND p_item.main_obj_type.item_catalog_group_code <> fnd_api.g_miss_char) THEN
327: l_pk_col_name_val_pairs.EXTEND(1);
328: l_pk_col_name_val_pairs(1).name := 'concatenated_segments';
329: l_pk_col_name_val_pairs(1).value := p_item.main_obj_type.item_catalog_group_code;
330: x_item.main_obj_type.item_catalog_group_id := INV_EBI_ITEM_HELPER.value_to_id(
335: IF (x_item.main_obj_type.item_catalog_group_id IS NULL ) THEN
336: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
337: FND_MESSAGE.set_token('COL_VALUE',p_item.main_obj_type.item_catalog_group_code);
338: FND_MSG_PUB.add;
339: RAISE FND_API.g_exc_error;
340: END IF;
341: END IF;
342: IF ( (p_item.main_obj_type.lifecycle_id IS NULL OR p_item.main_obj_type.lifecycle_id =fnd_api.g_miss_num)
343: AND p_item.main_obj_type.lifecycle_name IS NOT NULL) THEN
338: FND_MSG_PUB.add;
339: RAISE FND_API.g_exc_error;
340: END IF;
341: END IF;
342: IF ( (p_item.main_obj_type.lifecycle_id IS NULL OR p_item.main_obj_type.lifecycle_id =fnd_api.g_miss_num)
343: AND p_item.main_obj_type.lifecycle_name IS NOT NULL) THEN
344: l_pk_col_name_val_pairs.EXTEND(1);
345: l_pk_col_name_val_pairs(1).name := 'name';
346: l_pk_col_name_val_pairs(1).value := p_item.main_obj_type.lifecycle_name;
349: ,p_entity_name => INV_EBI_ITEM_HELPER.G_LIFECYCLE
350: );
351: l_pk_col_name_val_pairs.TRIM(1);
352: END IF;
353: IF ( (p_item.main_obj_type.current_phase_id IS NULL OR p_item.main_obj_type.current_phase_id=fnd_api.g_miss_num)
354: AND (p_item.main_obj_type.current_phase_name IS NOT NULL AND x_item.main_obj_type.lifecycle_id is NOT NULL)) THEN
355: l_pk_col_name_val_pairs.EXTEND(2);
356: l_pk_col_name_val_pairs(1).name := 'name';
357: l_pk_col_name_val_pairs(1).value := p_item.main_obj_type.current_phase_name;
362: ,p_entity_name => INV_EBI_ITEM_HELPER.G_CURRENT_PHASE
363: );
364: l_pk_col_name_val_pairs.TRIM(2);
365: END IF;
366: IF ( (p_item.main_obj_type.revision_id IS NULL OR p_item.main_obj_type.revision_id= fnd_api.g_miss_num)
367: AND (x_item.main_obj_type.organization_id IS NOT NULL AND x_item.main_obj_type.inventory_item_id IS NOT NULL)
368: ) THEN
369: l_pk_col_name_val_pairs.EXTEND(2);
370: l_pk_col_name_val_pairs(1).name := 'organization_id';
376: ,p_entity_name => INV_EBI_ITEM_HELPER.G_REVISION
377: );
378: l_pk_col_name_val_pairs.TRIM(2);
379: END IF;
380: IF ( (p_item.purchasing_obj_type.hazard_class_id IS NULL OR p_item.purchasing_obj_type.hazard_class_id = fnd_api.g_miss_num)
381: AND p_item.purchasing_obj_type.hazard_class_code IS NOT NULL) THEN
382: l_pk_col_name_val_pairs.EXTEND(1);
383: l_pk_col_name_val_pairs(1).name := 'hazard_class';
384: l_pk_col_name_val_pairs(1).value := p_item.purchasing_obj_type.hazard_class_code ;
387: ,p_entity_name => INV_EBI_ITEM_HELPER.G_HAZARD_CLASS
388: );
389: l_pk_col_name_val_pairs.TRIM(1);
390: END IF;
391: IF ( (p_item.purchasing_obj_type.asset_category_id IS NULL OR p_item.purchasing_obj_type.asset_category_id =fnd_api.g_miss_num)
392: AND p_item.purchasing_obj_type.asset_category_code IS NOT NULL ) THEN
393: l_pk_col_name_val_pairs.EXTEND(1);
394: l_pk_col_name_val_pairs(1).name := 'concatenated_segments';
395: l_pk_col_name_val_pairs(1).value := p_item.purchasing_obj_type.asset_category_code;
398: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ASSET_CATEGORY
399: );
400: l_pk_col_name_val_pairs.TRIM(1);
401: END IF;
402: IF ( (p_item.bom_obj_type.base_item_id IS NULL OR p_item.bom_obj_type.base_item_id= fnd_api.g_miss_num)
403: AND p_item.bom_obj_type.base_item_number IS NOT NULL )THEN
404: l_pk_col_name_val_pairs.EXTEND(2);
405: l_pk_col_name_val_pairs(1).name := 'concatenated_segments';
406: l_pk_col_name_val_pairs(1).value := p_item.bom_obj_type.base_item_number;
413: l_pk_col_name_val_pairs.TRIM(2);
414: END IF;
415: IF ( p_item.part_num_obj_tbl_type IS NOT NULL AND p_item.part_num_obj_tbl_type.COUNT > 0 ) THEN
416: FOR i in 1..p_item.part_num_obj_tbl_type.COUNT LOOP
417: IF ((p_item.part_num_obj_tbl_type(i).manufacturer_id IS NULL OR p_item.part_num_obj_tbl_type(i).manufacturer_id = fnd_api.g_miss_num)
418: AND (p_item.part_num_obj_tbl_type(i).manufacturer_name IS NOT NULL OR p_item.part_num_obj_tbl_type(i).manufacturer_name <> fnd_api.g_miss_char))THEN
419: l_pk_col_name_val_pairs.EXTEND(1);
420: l_pk_col_name_val_pairs(1).name := 'manufacturer_name';
421: l_pk_col_name_val_pairs(1).value := p_item.part_num_obj_tbl_type(i).manufacturer_name;
414: END IF;
415: IF ( p_item.part_num_obj_tbl_type IS NOT NULL AND p_item.part_num_obj_tbl_type.COUNT > 0 ) THEN
416: FOR i in 1..p_item.part_num_obj_tbl_type.COUNT LOOP
417: IF ((p_item.part_num_obj_tbl_type(i).manufacturer_id IS NULL OR p_item.part_num_obj_tbl_type(i).manufacturer_id = fnd_api.g_miss_num)
418: AND (p_item.part_num_obj_tbl_type(i).manufacturer_name IS NOT NULL OR p_item.part_num_obj_tbl_type(i).manufacturer_name <> fnd_api.g_miss_char))THEN
419: l_pk_col_name_val_pairs.EXTEND(1);
420: l_pk_col_name_val_pairs(1).name := 'manufacturer_name';
421: l_pk_col_name_val_pairs(1).value := p_item.part_num_obj_tbl_type(i).manufacturer_name;
422: x_item.part_num_obj_tbl_type(i).manufacturer_id := INV_EBI_ITEM_HELPER.value_to_id (
428: END LOOP;
429: END IF;
430: IF ( p_item.category_id_obj_tbl_type IS NOT NULL AND p_item.category_id_obj_tbl_type.COUNT > 0) THEN
431: FOR i IN 1..p_item.category_id_obj_tbl_type.COUNT LOOP
432: IF ((p_item.category_id_obj_tbl_type(i).cat_set_id IS NULL OR p_item.category_id_obj_tbl_type(i).cat_set_id = fnd_api.g_miss_num)
433: AND (p_item.category_id_obj_tbl_type(i).cat_set_name IS NOT NULL OR p_item.category_id_obj_tbl_type(i).cat_set_name <> fnd_api.g_miss_char) ) THEN
434: l_pk_col_name_val_pairs.EXTEND(1);
435: l_pk_col_name_val_pairs(1).name := 'category_set_name';
436: l_pk_col_name_val_pairs(1).value := p_item.category_id_obj_tbl_type(i).cat_set_name;
429: END IF;
430: IF ( p_item.category_id_obj_tbl_type IS NOT NULL AND p_item.category_id_obj_tbl_type.COUNT > 0) THEN
431: FOR i IN 1..p_item.category_id_obj_tbl_type.COUNT LOOP
432: IF ((p_item.category_id_obj_tbl_type(i).cat_set_id IS NULL OR p_item.category_id_obj_tbl_type(i).cat_set_id = fnd_api.g_miss_num)
433: AND (p_item.category_id_obj_tbl_type(i).cat_set_name IS NOT NULL OR p_item.category_id_obj_tbl_type(i).cat_set_name <> fnd_api.g_miss_char) ) THEN
434: l_pk_col_name_val_pairs.EXTEND(1);
435: l_pk_col_name_val_pairs(1).name := 'category_set_name';
436: l_pk_col_name_val_pairs(1).value := p_item.category_id_obj_tbl_type(i).cat_set_name;
437: x_item.category_id_obj_tbl_type(i).cat_set_id := INV_EBI_ITEM_HELPER.value_to_id(
439: ,p_entity_name => INV_EBI_ITEM_HELPER.G_CATEGORY_SET
440: );
441: l_pk_col_name_val_pairs.TRIM(1);
442: END IF;
443: IF ( (p_item.category_id_obj_tbl_type(i).cat_id IS NULL OR p_item.category_id_obj_tbl_type(i).cat_id =fnd_api.g_miss_num)
444: AND ( p_item.category_id_obj_tbl_type(i).cat_name IS NOT NULL OR p_item.category_id_obj_tbl_type(i).cat_name <> fnd_api.g_miss_char)) THEN
445: l_pk_col_name_val_pairs.EXTEND(1);
446: l_pk_col_name_val_pairs(1).name := 'concatenated_segments';
447: l_pk_col_name_val_pairs(1).value := p_item.category_id_obj_tbl_type(i).cat_name;
440: );
441: l_pk_col_name_val_pairs.TRIM(1);
442: END IF;
443: IF ( (p_item.category_id_obj_tbl_type(i).cat_id IS NULL OR p_item.category_id_obj_tbl_type(i).cat_id =fnd_api.g_miss_num)
444: AND ( p_item.category_id_obj_tbl_type(i).cat_name IS NOT NULL OR p_item.category_id_obj_tbl_type(i).cat_name <> fnd_api.g_miss_char)) THEN
445: l_pk_col_name_val_pairs.EXTEND(1);
446: l_pk_col_name_val_pairs(1).name := 'concatenated_segments';
447: l_pk_col_name_val_pairs(1).value := p_item.category_id_obj_tbl_type(i).cat_name;
448: x_item.category_id_obj_tbl_type(i).cat_id := INV_EBI_ITEM_HELPER.value_to_id (
452: l_pk_col_name_val_pairs.TRIM(1);
453: END IF;
454: END LOOP;
455: END IF;
456: IF ( (p_item.main_obj_type.rev_lifecycle_id IS NULL OR p_item.main_obj_type.rev_lifecycle_id= fnd_api.g_miss_num)
457: AND p_item.main_obj_type.rev_lifecycle_name IS NOT NULL) THEN
458: l_pk_col_name_val_pairs.EXTEND(1);
459: l_pk_col_name_val_pairs(1).name := 'name';
460: l_pk_col_name_val_pairs(1).value := p_item.main_obj_type.rev_lifecycle_name;
463: ,p_entity_name => INV_EBI_ITEM_HELPER.G_LIFECYCLE
464: );
465: l_pk_col_name_val_pairs.TRIM(1);
466: END IF;
467: IF ( (p_item.main_obj_type.rev_current_phase_id IS NULL OR p_item.main_obj_type.rev_current_phase_id= fnd_api.g_miss_num)
468: AND (p_item.main_obj_type.rev_current_phase_name IS NOT NULL AND x_item.main_obj_type.rev_lifecycle_id IS NOT NULL )
469: ) THEN
470: l_pk_col_name_val_pairs.EXTEND(2);
471: l_pk_col_name_val_pairs(1).name := 'name';
478: );
479: l_pk_col_name_val_pairs.TRIM(2);
480: END IF;
481: EXCEPTION
482: WHEN FND_API.g_exc_error THEN
483: x_out.output_status.return_status := FND_API.g_ret_sts_error;
484: IF(x_out.output_status.msg_data IS NULL) THEN
485: fnd_msg_pub.count_and_get(
486: p_encoded => fnd_api.g_false
479: l_pk_col_name_val_pairs.TRIM(2);
480: END IF;
481: EXCEPTION
482: WHEN FND_API.g_exc_error THEN
483: x_out.output_status.return_status := FND_API.g_ret_sts_error;
484: IF(x_out.output_status.msg_data IS NULL) THEN
485: fnd_msg_pub.count_and_get(
486: p_encoded => fnd_api.g_false
487: ,p_count => x_out.output_status.msg_count
482: WHEN FND_API.g_exc_error THEN
483: x_out.output_status.return_status := FND_API.g_ret_sts_error;
484: IF(x_out.output_status.msg_data IS NULL) THEN
485: fnd_msg_pub.count_and_get(
486: p_encoded => fnd_api.g_false
487: ,p_count => x_out.output_status.msg_count
488: ,p_data => x_out.output_status.msg_data
489: );
490: END IF;
488: ,p_data => x_out.output_status.msg_data
489: );
490: END IF;
491: WHEN OTHERS THEN
492: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
493: IF (x_out.output_status.msg_data IS NOT NULL) THEN
494: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_ITEM_PUB.populate_item_ids ';
495: ELSE
496: x_out.output_status.msg_data := SQLERRM||' INV_EBI_ITEM_PUB.populate_item_ids ';
546: IS
547: BEGIN
548: IF (x_item.physical_obj_type IS NULL) THEN
549: x_item.physical_obj_type := inv_ebi_item_physical_obj(
550: fnd_api.g_miss_char,
551: fnd_api.g_miss_num,
552: fnd_api.g_miss_char,
553: fnd_api.g_miss_num,
554: fnd_api.g_miss_char,
547: BEGIN
548: IF (x_item.physical_obj_type IS NULL) THEN
549: x_item.physical_obj_type := inv_ebi_item_physical_obj(
550: fnd_api.g_miss_char,
551: fnd_api.g_miss_num,
552: fnd_api.g_miss_char,
553: fnd_api.g_miss_num,
554: fnd_api.g_miss_char,
555: fnd_api.g_miss_char,
548: IF (x_item.physical_obj_type IS NULL) THEN
549: x_item.physical_obj_type := inv_ebi_item_physical_obj(
550: fnd_api.g_miss_char,
551: fnd_api.g_miss_num,
552: fnd_api.g_miss_char,
553: fnd_api.g_miss_num,
554: fnd_api.g_miss_char,
555: fnd_api.g_miss_char,
556: fnd_api.g_miss_char,
549: x_item.physical_obj_type := inv_ebi_item_physical_obj(
550: fnd_api.g_miss_char,
551: fnd_api.g_miss_num,
552: fnd_api.g_miss_char,
553: fnd_api.g_miss_num,
554: fnd_api.g_miss_char,
555: fnd_api.g_miss_char,
556: fnd_api.g_miss_char,
557: fnd_api.g_miss_num,
550: fnd_api.g_miss_char,
551: fnd_api.g_miss_num,
552: fnd_api.g_miss_char,
553: fnd_api.g_miss_num,
554: fnd_api.g_miss_char,
555: fnd_api.g_miss_char,
556: fnd_api.g_miss_char,
557: fnd_api.g_miss_num,
558: fnd_api.g_miss_num,
551: fnd_api.g_miss_num,
552: fnd_api.g_miss_char,
553: fnd_api.g_miss_num,
554: fnd_api.g_miss_char,
555: fnd_api.g_miss_char,
556: fnd_api.g_miss_char,
557: fnd_api.g_miss_num,
558: fnd_api.g_miss_num,
559: fnd_api.g_miss_num,
552: fnd_api.g_miss_char,
553: fnd_api.g_miss_num,
554: fnd_api.g_miss_char,
555: fnd_api.g_miss_char,
556: fnd_api.g_miss_char,
557: fnd_api.g_miss_num,
558: fnd_api.g_miss_num,
559: fnd_api.g_miss_num,
560: fnd_api.g_miss_num,
553: fnd_api.g_miss_num,
554: fnd_api.g_miss_char,
555: fnd_api.g_miss_char,
556: fnd_api.g_miss_char,
557: fnd_api.g_miss_num,
558: fnd_api.g_miss_num,
559: fnd_api.g_miss_num,
560: fnd_api.g_miss_num,
561: fnd_api.g_miss_char,
554: fnd_api.g_miss_char,
555: fnd_api.g_miss_char,
556: fnd_api.g_miss_char,
557: fnd_api.g_miss_num,
558: fnd_api.g_miss_num,
559: fnd_api.g_miss_num,
560: fnd_api.g_miss_num,
561: fnd_api.g_miss_char,
562: fnd_api.g_miss_char,
555: fnd_api.g_miss_char,
556: fnd_api.g_miss_char,
557: fnd_api.g_miss_num,
558: fnd_api.g_miss_num,
559: fnd_api.g_miss_num,
560: fnd_api.g_miss_num,
561: fnd_api.g_miss_char,
562: fnd_api.g_miss_char,
563: fnd_api.g_miss_char,
556: fnd_api.g_miss_char,
557: fnd_api.g_miss_num,
558: fnd_api.g_miss_num,
559: fnd_api.g_miss_num,
560: fnd_api.g_miss_num,
561: fnd_api.g_miss_char,
562: fnd_api.g_miss_char,
563: fnd_api.g_miss_char,
564: fnd_api.g_miss_char,
557: fnd_api.g_miss_num,
558: fnd_api.g_miss_num,
559: fnd_api.g_miss_num,
560: fnd_api.g_miss_num,
561: fnd_api.g_miss_char,
562: fnd_api.g_miss_char,
563: fnd_api.g_miss_char,
564: fnd_api.g_miss_char,
565: fnd_api.g_miss_char,
558: fnd_api.g_miss_num,
559: fnd_api.g_miss_num,
560: fnd_api.g_miss_num,
561: fnd_api.g_miss_char,
562: fnd_api.g_miss_char,
563: fnd_api.g_miss_char,
564: fnd_api.g_miss_char,
565: fnd_api.g_miss_char,
566: fnd_api.g_miss_num,
559: fnd_api.g_miss_num,
560: fnd_api.g_miss_num,
561: fnd_api.g_miss_char,
562: fnd_api.g_miss_char,
563: fnd_api.g_miss_char,
564: fnd_api.g_miss_char,
565: fnd_api.g_miss_char,
566: fnd_api.g_miss_num,
567: fnd_api.g_miss_num,
560: fnd_api.g_miss_num,
561: fnd_api.g_miss_char,
562: fnd_api.g_miss_char,
563: fnd_api.g_miss_char,
564: fnd_api.g_miss_char,
565: fnd_api.g_miss_char,
566: fnd_api.g_miss_num,
567: fnd_api.g_miss_num,
568: fnd_api.g_miss_num
561: fnd_api.g_miss_char,
562: fnd_api.g_miss_char,
563: fnd_api.g_miss_char,
564: fnd_api.g_miss_char,
565: fnd_api.g_miss_char,
566: fnd_api.g_miss_num,
567: fnd_api.g_miss_num,
568: fnd_api.g_miss_num
569: );
562: fnd_api.g_miss_char,
563: fnd_api.g_miss_char,
564: fnd_api.g_miss_char,
565: fnd_api.g_miss_char,
566: fnd_api.g_miss_num,
567: fnd_api.g_miss_num,
568: fnd_api.g_miss_num
569: );
570: END IF;
563: fnd_api.g_miss_char,
564: fnd_api.g_miss_char,
565: fnd_api.g_miss_char,
566: fnd_api.g_miss_num,
567: fnd_api.g_miss_num,
568: fnd_api.g_miss_num
569: );
570: END IF;
571: IF (x_item.inventory_obj_type IS NULL) THEN
564: fnd_api.g_miss_char,
565: fnd_api.g_miss_char,
566: fnd_api.g_miss_num,
567: fnd_api.g_miss_num,
568: fnd_api.g_miss_num
569: );
570: END IF;
571: IF (x_item.inventory_obj_type IS NULL) THEN
572: x_item.inventory_obj_type := inv_ebi_item_inventory_obj(
569: );
570: END IF;
571: IF (x_item.inventory_obj_type IS NULL) THEN
572: x_item.inventory_obj_type := inv_ebi_item_inventory_obj(
573: fnd_api.g_miss_char,
574: fnd_api.g_miss_char,
575: fnd_api.g_miss_char,
576: fnd_api.g_miss_char,
577: fnd_api.g_miss_num,
570: END IF;
571: IF (x_item.inventory_obj_type IS NULL) THEN
572: x_item.inventory_obj_type := inv_ebi_item_inventory_obj(
573: fnd_api.g_miss_char,
574: fnd_api.g_miss_char,
575: fnd_api.g_miss_char,
576: fnd_api.g_miss_char,
577: fnd_api.g_miss_num,
578: fnd_api.g_miss_num,
571: IF (x_item.inventory_obj_type IS NULL) THEN
572: x_item.inventory_obj_type := inv_ebi_item_inventory_obj(
573: fnd_api.g_miss_char,
574: fnd_api.g_miss_char,
575: fnd_api.g_miss_char,
576: fnd_api.g_miss_char,
577: fnd_api.g_miss_num,
578: fnd_api.g_miss_num,
579: fnd_api.g_miss_num,
572: x_item.inventory_obj_type := inv_ebi_item_inventory_obj(
573: fnd_api.g_miss_char,
574: fnd_api.g_miss_char,
575: fnd_api.g_miss_char,
576: fnd_api.g_miss_char,
577: fnd_api.g_miss_num,
578: fnd_api.g_miss_num,
579: fnd_api.g_miss_num,
580: fnd_api.g_miss_num,
573: fnd_api.g_miss_char,
574: fnd_api.g_miss_char,
575: fnd_api.g_miss_char,
576: fnd_api.g_miss_char,
577: fnd_api.g_miss_num,
578: fnd_api.g_miss_num,
579: fnd_api.g_miss_num,
580: fnd_api.g_miss_num,
581: fnd_api.g_miss_char,
574: fnd_api.g_miss_char,
575: fnd_api.g_miss_char,
576: fnd_api.g_miss_char,
577: fnd_api.g_miss_num,
578: fnd_api.g_miss_num,
579: fnd_api.g_miss_num,
580: fnd_api.g_miss_num,
581: fnd_api.g_miss_char,
582: fnd_api.g_miss_num,
575: fnd_api.g_miss_char,
576: fnd_api.g_miss_char,
577: fnd_api.g_miss_num,
578: fnd_api.g_miss_num,
579: fnd_api.g_miss_num,
580: fnd_api.g_miss_num,
581: fnd_api.g_miss_char,
582: fnd_api.g_miss_num,
583: fnd_api.g_miss_num,
576: fnd_api.g_miss_char,
577: fnd_api.g_miss_num,
578: fnd_api.g_miss_num,
579: fnd_api.g_miss_num,
580: fnd_api.g_miss_num,
581: fnd_api.g_miss_char,
582: fnd_api.g_miss_num,
583: fnd_api.g_miss_num,
584: fnd_api.g_miss_num,
577: fnd_api.g_miss_num,
578: fnd_api.g_miss_num,
579: fnd_api.g_miss_num,
580: fnd_api.g_miss_num,
581: fnd_api.g_miss_char,
582: fnd_api.g_miss_num,
583: fnd_api.g_miss_num,
584: fnd_api.g_miss_num,
585: fnd_api.g_miss_char,
578: fnd_api.g_miss_num,
579: fnd_api.g_miss_num,
580: fnd_api.g_miss_num,
581: fnd_api.g_miss_char,
582: fnd_api.g_miss_num,
583: fnd_api.g_miss_num,
584: fnd_api.g_miss_num,
585: fnd_api.g_miss_char,
586: fnd_api.g_miss_char,
579: fnd_api.g_miss_num,
580: fnd_api.g_miss_num,
581: fnd_api.g_miss_char,
582: fnd_api.g_miss_num,
583: fnd_api.g_miss_num,
584: fnd_api.g_miss_num,
585: fnd_api.g_miss_char,
586: fnd_api.g_miss_char,
587: fnd_api.g_miss_num,
580: fnd_api.g_miss_num,
581: fnd_api.g_miss_char,
582: fnd_api.g_miss_num,
583: fnd_api.g_miss_num,
584: fnd_api.g_miss_num,
585: fnd_api.g_miss_char,
586: fnd_api.g_miss_char,
587: fnd_api.g_miss_num,
588: fnd_api.g_miss_char,
581: fnd_api.g_miss_char,
582: fnd_api.g_miss_num,
583: fnd_api.g_miss_num,
584: fnd_api.g_miss_num,
585: fnd_api.g_miss_char,
586: fnd_api.g_miss_char,
587: fnd_api.g_miss_num,
588: fnd_api.g_miss_char,
589: fnd_api.g_miss_char,
582: fnd_api.g_miss_num,
583: fnd_api.g_miss_num,
584: fnd_api.g_miss_num,
585: fnd_api.g_miss_char,
586: fnd_api.g_miss_char,
587: fnd_api.g_miss_num,
588: fnd_api.g_miss_char,
589: fnd_api.g_miss_char,
590: fnd_api.g_miss_num,
583: fnd_api.g_miss_num,
584: fnd_api.g_miss_num,
585: fnd_api.g_miss_char,
586: fnd_api.g_miss_char,
587: fnd_api.g_miss_num,
588: fnd_api.g_miss_char,
589: fnd_api.g_miss_char,
590: fnd_api.g_miss_num,
591: fnd_api.g_miss_num,
584: fnd_api.g_miss_num,
585: fnd_api.g_miss_char,
586: fnd_api.g_miss_char,
587: fnd_api.g_miss_num,
588: fnd_api.g_miss_char,
589: fnd_api.g_miss_char,
590: fnd_api.g_miss_num,
591: fnd_api.g_miss_num,
592: fnd_api.g_miss_num,
585: fnd_api.g_miss_char,
586: fnd_api.g_miss_char,
587: fnd_api.g_miss_num,
588: fnd_api.g_miss_char,
589: fnd_api.g_miss_char,
590: fnd_api.g_miss_num,
591: fnd_api.g_miss_num,
592: fnd_api.g_miss_num,
593: fnd_api.g_miss_char,
586: fnd_api.g_miss_char,
587: fnd_api.g_miss_num,
588: fnd_api.g_miss_char,
589: fnd_api.g_miss_char,
590: fnd_api.g_miss_num,
591: fnd_api.g_miss_num,
592: fnd_api.g_miss_num,
593: fnd_api.g_miss_char,
594: fnd_api.g_miss_char,
587: fnd_api.g_miss_num,
588: fnd_api.g_miss_char,
589: fnd_api.g_miss_char,
590: fnd_api.g_miss_num,
591: fnd_api.g_miss_num,
592: fnd_api.g_miss_num,
593: fnd_api.g_miss_char,
594: fnd_api.g_miss_char,
595: fnd_api.g_miss_char,
588: fnd_api.g_miss_char,
589: fnd_api.g_miss_char,
590: fnd_api.g_miss_num,
591: fnd_api.g_miss_num,
592: fnd_api.g_miss_num,
593: fnd_api.g_miss_char,
594: fnd_api.g_miss_char,
595: fnd_api.g_miss_char,
596: fnd_api.g_miss_char,
589: fnd_api.g_miss_char,
590: fnd_api.g_miss_num,
591: fnd_api.g_miss_num,
592: fnd_api.g_miss_num,
593: fnd_api.g_miss_char,
594: fnd_api.g_miss_char,
595: fnd_api.g_miss_char,
596: fnd_api.g_miss_char,
597: fnd_api.g_miss_char,
590: fnd_api.g_miss_num,
591: fnd_api.g_miss_num,
592: fnd_api.g_miss_num,
593: fnd_api.g_miss_char,
594: fnd_api.g_miss_char,
595: fnd_api.g_miss_char,
596: fnd_api.g_miss_char,
597: fnd_api.g_miss_char,
598: fnd_api.g_miss_char,
591: fnd_api.g_miss_num,
592: fnd_api.g_miss_num,
593: fnd_api.g_miss_char,
594: fnd_api.g_miss_char,
595: fnd_api.g_miss_char,
596: fnd_api.g_miss_char,
597: fnd_api.g_miss_char,
598: fnd_api.g_miss_char,
599: fnd_api.g_miss_char,
592: fnd_api.g_miss_num,
593: fnd_api.g_miss_char,
594: fnd_api.g_miss_char,
595: fnd_api.g_miss_char,
596: fnd_api.g_miss_char,
597: fnd_api.g_miss_char,
598: fnd_api.g_miss_char,
599: fnd_api.g_miss_char,
600: fnd_api.g_miss_char,
593: fnd_api.g_miss_char,
594: fnd_api.g_miss_char,
595: fnd_api.g_miss_char,
596: fnd_api.g_miss_char,
597: fnd_api.g_miss_char,
598: fnd_api.g_miss_char,
599: fnd_api.g_miss_char,
600: fnd_api.g_miss_char,
601: fnd_api.g_miss_char,
594: fnd_api.g_miss_char,
595: fnd_api.g_miss_char,
596: fnd_api.g_miss_char,
597: fnd_api.g_miss_char,
598: fnd_api.g_miss_char,
599: fnd_api.g_miss_char,
600: fnd_api.g_miss_char,
601: fnd_api.g_miss_char,
602: fnd_api.g_miss_num,
595: fnd_api.g_miss_char,
596: fnd_api.g_miss_char,
597: fnd_api.g_miss_char,
598: fnd_api.g_miss_char,
599: fnd_api.g_miss_char,
600: fnd_api.g_miss_char,
601: fnd_api.g_miss_char,
602: fnd_api.g_miss_num,
603: fnd_api.g_miss_char,
596: fnd_api.g_miss_char,
597: fnd_api.g_miss_char,
598: fnd_api.g_miss_char,
599: fnd_api.g_miss_char,
600: fnd_api.g_miss_char,
601: fnd_api.g_miss_char,
602: fnd_api.g_miss_num,
603: fnd_api.g_miss_char,
604: fnd_api.g_miss_char,
597: fnd_api.g_miss_char,
598: fnd_api.g_miss_char,
599: fnd_api.g_miss_char,
600: fnd_api.g_miss_char,
601: fnd_api.g_miss_char,
602: fnd_api.g_miss_num,
603: fnd_api.g_miss_char,
604: fnd_api.g_miss_char,
605: fnd_api.g_miss_char,
598: fnd_api.g_miss_char,
599: fnd_api.g_miss_char,
600: fnd_api.g_miss_char,
601: fnd_api.g_miss_char,
602: fnd_api.g_miss_num,
603: fnd_api.g_miss_char,
604: fnd_api.g_miss_char,
605: fnd_api.g_miss_char,
606: fnd_api.g_miss_char,
599: fnd_api.g_miss_char,
600: fnd_api.g_miss_char,
601: fnd_api.g_miss_char,
602: fnd_api.g_miss_num,
603: fnd_api.g_miss_char,
604: fnd_api.g_miss_char,
605: fnd_api.g_miss_char,
606: fnd_api.g_miss_char,
607: fnd_api.g_miss_num,
600: fnd_api.g_miss_char,
601: fnd_api.g_miss_char,
602: fnd_api.g_miss_num,
603: fnd_api.g_miss_char,
604: fnd_api.g_miss_char,
605: fnd_api.g_miss_char,
606: fnd_api.g_miss_char,
607: fnd_api.g_miss_num,
608: fnd_api.g_miss_char,
601: fnd_api.g_miss_char,
602: fnd_api.g_miss_num,
603: fnd_api.g_miss_char,
604: fnd_api.g_miss_char,
605: fnd_api.g_miss_char,
606: fnd_api.g_miss_char,
607: fnd_api.g_miss_num,
608: fnd_api.g_miss_char,
609: fnd_api.g_miss_num,
602: fnd_api.g_miss_num,
603: fnd_api.g_miss_char,
604: fnd_api.g_miss_char,
605: fnd_api.g_miss_char,
606: fnd_api.g_miss_char,
607: fnd_api.g_miss_num,
608: fnd_api.g_miss_char,
609: fnd_api.g_miss_num,
610: fnd_api.g_miss_char,
603: fnd_api.g_miss_char,
604: fnd_api.g_miss_char,
605: fnd_api.g_miss_char,
606: fnd_api.g_miss_char,
607: fnd_api.g_miss_num,
608: fnd_api.g_miss_char,
609: fnd_api.g_miss_num,
610: fnd_api.g_miss_char,
611: fnd_api.g_miss_num,
604: fnd_api.g_miss_char,
605: fnd_api.g_miss_char,
606: fnd_api.g_miss_char,
607: fnd_api.g_miss_num,
608: fnd_api.g_miss_char,
609: fnd_api.g_miss_num,
610: fnd_api.g_miss_char,
611: fnd_api.g_miss_num,
612: fnd_api.g_miss_char,
605: fnd_api.g_miss_char,
606: fnd_api.g_miss_char,
607: fnd_api.g_miss_num,
608: fnd_api.g_miss_char,
609: fnd_api.g_miss_num,
610: fnd_api.g_miss_char,
611: fnd_api.g_miss_num,
612: fnd_api.g_miss_char,
613: fnd_api.g_miss_num
606: fnd_api.g_miss_char,
607: fnd_api.g_miss_num,
608: fnd_api.g_miss_char,
609: fnd_api.g_miss_num,
610: fnd_api.g_miss_char,
611: fnd_api.g_miss_num,
612: fnd_api.g_miss_char,
613: fnd_api.g_miss_num
614: );
607: fnd_api.g_miss_num,
608: fnd_api.g_miss_char,
609: fnd_api.g_miss_num,
610: fnd_api.g_miss_char,
611: fnd_api.g_miss_num,
612: fnd_api.g_miss_char,
613: fnd_api.g_miss_num
614: );
615: END IF;
608: fnd_api.g_miss_char,
609: fnd_api.g_miss_num,
610: fnd_api.g_miss_char,
611: fnd_api.g_miss_num,
612: fnd_api.g_miss_char,
613: fnd_api.g_miss_num
614: );
615: END IF;
616: IF (x_item.purchasing_obj_type IS NULL) THEN
609: fnd_api.g_miss_num,
610: fnd_api.g_miss_char,
611: fnd_api.g_miss_num,
612: fnd_api.g_miss_char,
613: fnd_api.g_miss_num
614: );
615: END IF;
616: IF (x_item.purchasing_obj_type IS NULL) THEN
617: x_item.purchasing_obj_type := inv_ebi_item_purchasing_obj(
614: );
615: END IF;
616: IF (x_item.purchasing_obj_type IS NULL) THEN
617: x_item.purchasing_obj_type := inv_ebi_item_purchasing_obj(
618: fnd_api.g_miss_char,
619: fnd_api.g_miss_char,
620: fnd_api.g_miss_char,
621: fnd_api.g_miss_char,
622: fnd_api.g_miss_char,
615: END IF;
616: IF (x_item.purchasing_obj_type IS NULL) THEN
617: x_item.purchasing_obj_type := inv_ebi_item_purchasing_obj(
618: fnd_api.g_miss_char,
619: fnd_api.g_miss_char,
620: fnd_api.g_miss_char,
621: fnd_api.g_miss_char,
622: fnd_api.g_miss_char,
623: fnd_api.g_miss_char,
616: IF (x_item.purchasing_obj_type IS NULL) THEN
617: x_item.purchasing_obj_type := inv_ebi_item_purchasing_obj(
618: fnd_api.g_miss_char,
619: fnd_api.g_miss_char,
620: fnd_api.g_miss_char,
621: fnd_api.g_miss_char,
622: fnd_api.g_miss_char,
623: fnd_api.g_miss_char,
624: fnd_api.g_miss_char,
617: x_item.purchasing_obj_type := inv_ebi_item_purchasing_obj(
618: fnd_api.g_miss_char,
619: fnd_api.g_miss_char,
620: fnd_api.g_miss_char,
621: fnd_api.g_miss_char,
622: fnd_api.g_miss_char,
623: fnd_api.g_miss_char,
624: fnd_api.g_miss_char,
625: fnd_api.g_miss_char,
618: fnd_api.g_miss_char,
619: fnd_api.g_miss_char,
620: fnd_api.g_miss_char,
621: fnd_api.g_miss_char,
622: fnd_api.g_miss_char,
623: fnd_api.g_miss_char,
624: fnd_api.g_miss_char,
625: fnd_api.g_miss_char,
626: fnd_api.g_miss_char,
619: fnd_api.g_miss_char,
620: fnd_api.g_miss_char,
621: fnd_api.g_miss_char,
622: fnd_api.g_miss_char,
623: fnd_api.g_miss_char,
624: fnd_api.g_miss_char,
625: fnd_api.g_miss_char,
626: fnd_api.g_miss_char,
627: fnd_api.g_miss_char,
620: fnd_api.g_miss_char,
621: fnd_api.g_miss_char,
622: fnd_api.g_miss_char,
623: fnd_api.g_miss_char,
624: fnd_api.g_miss_char,
625: fnd_api.g_miss_char,
626: fnd_api.g_miss_char,
627: fnd_api.g_miss_char,
628: fnd_api.g_miss_char,
621: fnd_api.g_miss_char,
622: fnd_api.g_miss_char,
623: fnd_api.g_miss_char,
624: fnd_api.g_miss_char,
625: fnd_api.g_miss_char,
626: fnd_api.g_miss_char,
627: fnd_api.g_miss_char,
628: fnd_api.g_miss_char,
629: fnd_api.g_miss_num,
622: fnd_api.g_miss_char,
623: fnd_api.g_miss_char,
624: fnd_api.g_miss_char,
625: fnd_api.g_miss_char,
626: fnd_api.g_miss_char,
627: fnd_api.g_miss_char,
628: fnd_api.g_miss_char,
629: fnd_api.g_miss_num,
630: fnd_api.g_miss_char,
623: fnd_api.g_miss_char,
624: fnd_api.g_miss_char,
625: fnd_api.g_miss_char,
626: fnd_api.g_miss_char,
627: fnd_api.g_miss_char,
628: fnd_api.g_miss_char,
629: fnd_api.g_miss_num,
630: fnd_api.g_miss_char,
631: fnd_api.g_miss_num,
624: fnd_api.g_miss_char,
625: fnd_api.g_miss_char,
626: fnd_api.g_miss_char,
627: fnd_api.g_miss_char,
628: fnd_api.g_miss_char,
629: fnd_api.g_miss_num,
630: fnd_api.g_miss_char,
631: fnd_api.g_miss_num,
632: fnd_api.g_miss_num,
625: fnd_api.g_miss_char,
626: fnd_api.g_miss_char,
627: fnd_api.g_miss_char,
628: fnd_api.g_miss_char,
629: fnd_api.g_miss_num,
630: fnd_api.g_miss_char,
631: fnd_api.g_miss_num,
632: fnd_api.g_miss_num,
633: fnd_api.g_miss_num,
626: fnd_api.g_miss_char,
627: fnd_api.g_miss_char,
628: fnd_api.g_miss_char,
629: fnd_api.g_miss_num,
630: fnd_api.g_miss_char,
631: fnd_api.g_miss_num,
632: fnd_api.g_miss_num,
633: fnd_api.g_miss_num,
634: fnd_api.g_miss_num,
627: fnd_api.g_miss_char,
628: fnd_api.g_miss_char,
629: fnd_api.g_miss_num,
630: fnd_api.g_miss_char,
631: fnd_api.g_miss_num,
632: fnd_api.g_miss_num,
633: fnd_api.g_miss_num,
634: fnd_api.g_miss_num,
635: fnd_api.g_miss_char,
628: fnd_api.g_miss_char,
629: fnd_api.g_miss_num,
630: fnd_api.g_miss_char,
631: fnd_api.g_miss_num,
632: fnd_api.g_miss_num,
633: fnd_api.g_miss_num,
634: fnd_api.g_miss_num,
635: fnd_api.g_miss_char,
636: fnd_api.g_miss_num,
629: fnd_api.g_miss_num,
630: fnd_api.g_miss_char,
631: fnd_api.g_miss_num,
632: fnd_api.g_miss_num,
633: fnd_api.g_miss_num,
634: fnd_api.g_miss_num,
635: fnd_api.g_miss_char,
636: fnd_api.g_miss_num,
637: fnd_api.g_miss_num,
630: fnd_api.g_miss_char,
631: fnd_api.g_miss_num,
632: fnd_api.g_miss_num,
633: fnd_api.g_miss_num,
634: fnd_api.g_miss_num,
635: fnd_api.g_miss_char,
636: fnd_api.g_miss_num,
637: fnd_api.g_miss_num,
638: fnd_api.g_miss_num,
631: fnd_api.g_miss_num,
632: fnd_api.g_miss_num,
633: fnd_api.g_miss_num,
634: fnd_api.g_miss_num,
635: fnd_api.g_miss_char,
636: fnd_api.g_miss_num,
637: fnd_api.g_miss_num,
638: fnd_api.g_miss_num,
639: fnd_api.g_miss_num,
632: fnd_api.g_miss_num,
633: fnd_api.g_miss_num,
634: fnd_api.g_miss_num,
635: fnd_api.g_miss_char,
636: fnd_api.g_miss_num,
637: fnd_api.g_miss_num,
638: fnd_api.g_miss_num,
639: fnd_api.g_miss_num,
640: fnd_api.g_miss_num,
633: fnd_api.g_miss_num,
634: fnd_api.g_miss_num,
635: fnd_api.g_miss_char,
636: fnd_api.g_miss_num,
637: fnd_api.g_miss_num,
638: fnd_api.g_miss_num,
639: fnd_api.g_miss_num,
640: fnd_api.g_miss_num,
641: fnd_api.g_miss_num,
634: fnd_api.g_miss_num,
635: fnd_api.g_miss_char,
636: fnd_api.g_miss_num,
637: fnd_api.g_miss_num,
638: fnd_api.g_miss_num,
639: fnd_api.g_miss_num,
640: fnd_api.g_miss_num,
641: fnd_api.g_miss_num,
642: fnd_api.g_miss_num,
635: fnd_api.g_miss_char,
636: fnd_api.g_miss_num,
637: fnd_api.g_miss_num,
638: fnd_api.g_miss_num,
639: fnd_api.g_miss_num,
640: fnd_api.g_miss_num,
641: fnd_api.g_miss_num,
642: fnd_api.g_miss_num,
643: fnd_api.g_miss_char,
636: fnd_api.g_miss_num,
637: fnd_api.g_miss_num,
638: fnd_api.g_miss_num,
639: fnd_api.g_miss_num,
640: fnd_api.g_miss_num,
641: fnd_api.g_miss_num,
642: fnd_api.g_miss_num,
643: fnd_api.g_miss_char,
644: fnd_api.g_miss_num
637: fnd_api.g_miss_num,
638: fnd_api.g_miss_num,
639: fnd_api.g_miss_num,
640: fnd_api.g_miss_num,
641: fnd_api.g_miss_num,
642: fnd_api.g_miss_num,
643: fnd_api.g_miss_char,
644: fnd_api.g_miss_num
645: );
638: fnd_api.g_miss_num,
639: fnd_api.g_miss_num,
640: fnd_api.g_miss_num,
641: fnd_api.g_miss_num,
642: fnd_api.g_miss_num,
643: fnd_api.g_miss_char,
644: fnd_api.g_miss_num
645: );
646: END IF;
639: fnd_api.g_miss_num,
640: fnd_api.g_miss_num,
641: fnd_api.g_miss_num,
642: fnd_api.g_miss_num,
643: fnd_api.g_miss_char,
644: fnd_api.g_miss_num
645: );
646: END IF;
647: IF (x_item.receiving_obj_type IS NULL) THEN
640: fnd_api.g_miss_num,
641: fnd_api.g_miss_num,
642: fnd_api.g_miss_num,
643: fnd_api.g_miss_char,
644: fnd_api.g_miss_num
645: );
646: END IF;
647: IF (x_item.receiving_obj_type IS NULL) THEN
648: x_item.receiving_obj_type := inv_ebi_item_receiving_obj(
645: );
646: END IF;
647: IF (x_item.receiving_obj_type IS NULL) THEN
648: x_item.receiving_obj_type := inv_ebi_item_receiving_obj(
649: fnd_api.g_miss_char,
650: fnd_api.g_miss_num,
651: fnd_api.g_miss_num,
652: fnd_api.g_miss_char,
653: fnd_api.g_miss_char,
646: END IF;
647: IF (x_item.receiving_obj_type IS NULL) THEN
648: x_item.receiving_obj_type := inv_ebi_item_receiving_obj(
649: fnd_api.g_miss_char,
650: fnd_api.g_miss_num,
651: fnd_api.g_miss_num,
652: fnd_api.g_miss_char,
653: fnd_api.g_miss_char,
654: fnd_api.g_miss_char,
647: IF (x_item.receiving_obj_type IS NULL) THEN
648: x_item.receiving_obj_type := inv_ebi_item_receiving_obj(
649: fnd_api.g_miss_char,
650: fnd_api.g_miss_num,
651: fnd_api.g_miss_num,
652: fnd_api.g_miss_char,
653: fnd_api.g_miss_char,
654: fnd_api.g_miss_char,
655: fnd_api.g_miss_char,
648: x_item.receiving_obj_type := inv_ebi_item_receiving_obj(
649: fnd_api.g_miss_char,
650: fnd_api.g_miss_num,
651: fnd_api.g_miss_num,
652: fnd_api.g_miss_char,
653: fnd_api.g_miss_char,
654: fnd_api.g_miss_char,
655: fnd_api.g_miss_char,
656: fnd_api.g_miss_num,
649: fnd_api.g_miss_char,
650: fnd_api.g_miss_num,
651: fnd_api.g_miss_num,
652: fnd_api.g_miss_char,
653: fnd_api.g_miss_char,
654: fnd_api.g_miss_char,
655: fnd_api.g_miss_char,
656: fnd_api.g_miss_num,
657: fnd_api.g_miss_num,
650: fnd_api.g_miss_num,
651: fnd_api.g_miss_num,
652: fnd_api.g_miss_char,
653: fnd_api.g_miss_char,
654: fnd_api.g_miss_char,
655: fnd_api.g_miss_char,
656: fnd_api.g_miss_num,
657: fnd_api.g_miss_num,
658: fnd_api.g_miss_char
651: fnd_api.g_miss_num,
652: fnd_api.g_miss_char,
653: fnd_api.g_miss_char,
654: fnd_api.g_miss_char,
655: fnd_api.g_miss_char,
656: fnd_api.g_miss_num,
657: fnd_api.g_miss_num,
658: fnd_api.g_miss_char
659: );
652: fnd_api.g_miss_char,
653: fnd_api.g_miss_char,
654: fnd_api.g_miss_char,
655: fnd_api.g_miss_char,
656: fnd_api.g_miss_num,
657: fnd_api.g_miss_num,
658: fnd_api.g_miss_char
659: );
660: END IF;
653: fnd_api.g_miss_char,
654: fnd_api.g_miss_char,
655: fnd_api.g_miss_char,
656: fnd_api.g_miss_num,
657: fnd_api.g_miss_num,
658: fnd_api.g_miss_char
659: );
660: END IF;
661: IF (x_item.gplanning_obj_type IS NULL) THEN
654: fnd_api.g_miss_char,
655: fnd_api.g_miss_char,
656: fnd_api.g_miss_num,
657: fnd_api.g_miss_num,
658: fnd_api.g_miss_char
659: );
660: END IF;
661: IF (x_item.gplanning_obj_type IS NULL) THEN
662: x_item.gplanning_obj_type := inv_ebi_item_gplanning_obj(
659: );
660: END IF;
661: IF (x_item.gplanning_obj_type IS NULL) THEN
662: x_item.gplanning_obj_type := inv_ebi_item_gplanning_obj(
663: fnd_api.g_miss_num,
664: fnd_api.g_miss_char,
665: fnd_api.g_miss_num,
666: fnd_api.g_miss_num,
667: fnd_api.g_miss_num,
660: END IF;
661: IF (x_item.gplanning_obj_type IS NULL) THEN
662: x_item.gplanning_obj_type := inv_ebi_item_gplanning_obj(
663: fnd_api.g_miss_num,
664: fnd_api.g_miss_char,
665: fnd_api.g_miss_num,
666: fnd_api.g_miss_num,
667: fnd_api.g_miss_num,
668: fnd_api.g_miss_num,
661: IF (x_item.gplanning_obj_type IS NULL) THEN
662: x_item.gplanning_obj_type := inv_ebi_item_gplanning_obj(
663: fnd_api.g_miss_num,
664: fnd_api.g_miss_char,
665: fnd_api.g_miss_num,
666: fnd_api.g_miss_num,
667: fnd_api.g_miss_num,
668: fnd_api.g_miss_num,
669: fnd_api.g_miss_num,
662: x_item.gplanning_obj_type := inv_ebi_item_gplanning_obj(
663: fnd_api.g_miss_num,
664: fnd_api.g_miss_char,
665: fnd_api.g_miss_num,
666: fnd_api.g_miss_num,
667: fnd_api.g_miss_num,
668: fnd_api.g_miss_num,
669: fnd_api.g_miss_num,
670: fnd_api.g_miss_num,
663: fnd_api.g_miss_num,
664: fnd_api.g_miss_char,
665: fnd_api.g_miss_num,
666: fnd_api.g_miss_num,
667: fnd_api.g_miss_num,
668: fnd_api.g_miss_num,
669: fnd_api.g_miss_num,
670: fnd_api.g_miss_num,
671: fnd_api.g_miss_num,
664: fnd_api.g_miss_char,
665: fnd_api.g_miss_num,
666: fnd_api.g_miss_num,
667: fnd_api.g_miss_num,
668: fnd_api.g_miss_num,
669: fnd_api.g_miss_num,
670: fnd_api.g_miss_num,
671: fnd_api.g_miss_num,
672: fnd_api.g_miss_num,
665: fnd_api.g_miss_num,
666: fnd_api.g_miss_num,
667: fnd_api.g_miss_num,
668: fnd_api.g_miss_num,
669: fnd_api.g_miss_num,
670: fnd_api.g_miss_num,
671: fnd_api.g_miss_num,
672: fnd_api.g_miss_num,
673: fnd_api.g_miss_num,
666: fnd_api.g_miss_num,
667: fnd_api.g_miss_num,
668: fnd_api.g_miss_num,
669: fnd_api.g_miss_num,
670: fnd_api.g_miss_num,
671: fnd_api.g_miss_num,
672: fnd_api.g_miss_num,
673: fnd_api.g_miss_num,
674: fnd_api.g_miss_char,
667: fnd_api.g_miss_num,
668: fnd_api.g_miss_num,
669: fnd_api.g_miss_num,
670: fnd_api.g_miss_num,
671: fnd_api.g_miss_num,
672: fnd_api.g_miss_num,
673: fnd_api.g_miss_num,
674: fnd_api.g_miss_char,
675: fnd_api.g_miss_num,
668: fnd_api.g_miss_num,
669: fnd_api.g_miss_num,
670: fnd_api.g_miss_num,
671: fnd_api.g_miss_num,
672: fnd_api.g_miss_num,
673: fnd_api.g_miss_num,
674: fnd_api.g_miss_char,
675: fnd_api.g_miss_num,
676: fnd_api.g_miss_num,
669: fnd_api.g_miss_num,
670: fnd_api.g_miss_num,
671: fnd_api.g_miss_num,
672: fnd_api.g_miss_num,
673: fnd_api.g_miss_num,
674: fnd_api.g_miss_char,
675: fnd_api.g_miss_num,
676: fnd_api.g_miss_num,
677: fnd_api.g_miss_num,
670: fnd_api.g_miss_num,
671: fnd_api.g_miss_num,
672: fnd_api.g_miss_num,
673: fnd_api.g_miss_num,
674: fnd_api.g_miss_char,
675: fnd_api.g_miss_num,
676: fnd_api.g_miss_num,
677: fnd_api.g_miss_num,
678: fnd_api.g_miss_num,
671: fnd_api.g_miss_num,
672: fnd_api.g_miss_num,
673: fnd_api.g_miss_num,
674: fnd_api.g_miss_char,
675: fnd_api.g_miss_num,
676: fnd_api.g_miss_num,
677: fnd_api.g_miss_num,
678: fnd_api.g_miss_num,
679: fnd_api.g_miss_num,
672: fnd_api.g_miss_num,
673: fnd_api.g_miss_num,
674: fnd_api.g_miss_char,
675: fnd_api.g_miss_num,
676: fnd_api.g_miss_num,
677: fnd_api.g_miss_num,
678: fnd_api.g_miss_num,
679: fnd_api.g_miss_num,
680: fnd_api.g_miss_num,
673: fnd_api.g_miss_num,
674: fnd_api.g_miss_char,
675: fnd_api.g_miss_num,
676: fnd_api.g_miss_num,
677: fnd_api.g_miss_num,
678: fnd_api.g_miss_num,
679: fnd_api.g_miss_num,
680: fnd_api.g_miss_num,
681: fnd_api.g_miss_num,
674: fnd_api.g_miss_char,
675: fnd_api.g_miss_num,
676: fnd_api.g_miss_num,
677: fnd_api.g_miss_num,
678: fnd_api.g_miss_num,
679: fnd_api.g_miss_num,
680: fnd_api.g_miss_num,
681: fnd_api.g_miss_num,
682: fnd_api.g_miss_num,
675: fnd_api.g_miss_num,
676: fnd_api.g_miss_num,
677: fnd_api.g_miss_num,
678: fnd_api.g_miss_num,
679: fnd_api.g_miss_num,
680: fnd_api.g_miss_num,
681: fnd_api.g_miss_num,
682: fnd_api.g_miss_num,
683: fnd_api.g_miss_num,
676: fnd_api.g_miss_num,
677: fnd_api.g_miss_num,
678: fnd_api.g_miss_num,
679: fnd_api.g_miss_num,
680: fnd_api.g_miss_num,
681: fnd_api.g_miss_num,
682: fnd_api.g_miss_num,
683: fnd_api.g_miss_num,
684: fnd_api.g_miss_num,
677: fnd_api.g_miss_num,
678: fnd_api.g_miss_num,
679: fnd_api.g_miss_num,
680: fnd_api.g_miss_num,
681: fnd_api.g_miss_num,
682: fnd_api.g_miss_num,
683: fnd_api.g_miss_num,
684: fnd_api.g_miss_num,
685: fnd_api.g_miss_num,
678: fnd_api.g_miss_num,
679: fnd_api.g_miss_num,
680: fnd_api.g_miss_num,
681: fnd_api.g_miss_num,
682: fnd_api.g_miss_num,
683: fnd_api.g_miss_num,
684: fnd_api.g_miss_num,
685: fnd_api.g_miss_num,
686: fnd_api.g_miss_num,
679: fnd_api.g_miss_num,
680: fnd_api.g_miss_num,
681: fnd_api.g_miss_num,
682: fnd_api.g_miss_num,
683: fnd_api.g_miss_num,
684: fnd_api.g_miss_num,
685: fnd_api.g_miss_num,
686: fnd_api.g_miss_num,
687: fnd_api.g_miss_num,
680: fnd_api.g_miss_num,
681: fnd_api.g_miss_num,
682: fnd_api.g_miss_num,
683: fnd_api.g_miss_num,
684: fnd_api.g_miss_num,
685: fnd_api.g_miss_num,
686: fnd_api.g_miss_num,
687: fnd_api.g_miss_num,
688: fnd_api.g_miss_num,
681: fnd_api.g_miss_num,
682: fnd_api.g_miss_num,
683: fnd_api.g_miss_num,
684: fnd_api.g_miss_num,
685: fnd_api.g_miss_num,
686: fnd_api.g_miss_num,
687: fnd_api.g_miss_num,
688: fnd_api.g_miss_num,
689: fnd_api.g_miss_num,
682: fnd_api.g_miss_num,
683: fnd_api.g_miss_num,
684: fnd_api.g_miss_num,
685: fnd_api.g_miss_num,
686: fnd_api.g_miss_num,
687: fnd_api.g_miss_num,
688: fnd_api.g_miss_num,
689: fnd_api.g_miss_num,
690: fnd_api.g_miss_num,
683: fnd_api.g_miss_num,
684: fnd_api.g_miss_num,
685: fnd_api.g_miss_num,
686: fnd_api.g_miss_num,
687: fnd_api.g_miss_num,
688: fnd_api.g_miss_num,
689: fnd_api.g_miss_num,
690: fnd_api.g_miss_num,
691: fnd_api.g_miss_num
684: fnd_api.g_miss_num,
685: fnd_api.g_miss_num,
686: fnd_api.g_miss_num,
687: fnd_api.g_miss_num,
688: fnd_api.g_miss_num,
689: fnd_api.g_miss_num,
690: fnd_api.g_miss_num,
691: fnd_api.g_miss_num
692: );
685: fnd_api.g_miss_num,
686: fnd_api.g_miss_num,
687: fnd_api.g_miss_num,
688: fnd_api.g_miss_num,
689: fnd_api.g_miss_num,
690: fnd_api.g_miss_num,
691: fnd_api.g_miss_num
692: );
693: END IF;
686: fnd_api.g_miss_num,
687: fnd_api.g_miss_num,
688: fnd_api.g_miss_num,
689: fnd_api.g_miss_num,
690: fnd_api.g_miss_num,
691: fnd_api.g_miss_num
692: );
693: END IF;
694: IF (x_item.mrp_obj_type IS NULL) THEN
687: fnd_api.g_miss_num,
688: fnd_api.g_miss_num,
689: fnd_api.g_miss_num,
690: fnd_api.g_miss_num,
691: fnd_api.g_miss_num
692: );
693: END IF;
694: IF (x_item.mrp_obj_type IS NULL) THEN
695: x_item.mrp_obj_type := inv_ebi_item_mrp_obj(
692: );
693: END IF;
694: IF (x_item.mrp_obj_type IS NULL) THEN
695: x_item.mrp_obj_type := inv_ebi_item_mrp_obj(
696: fnd_api.g_miss_num,
697: fnd_api.g_miss_num,
698: fnd_api.g_miss_char,
699: fnd_api.g_miss_char,
700: fnd_api.g_miss_num,
693: END IF;
694: IF (x_item.mrp_obj_type IS NULL) THEN
695: x_item.mrp_obj_type := inv_ebi_item_mrp_obj(
696: fnd_api.g_miss_num,
697: fnd_api.g_miss_num,
698: fnd_api.g_miss_char,
699: fnd_api.g_miss_char,
700: fnd_api.g_miss_num,
701: fnd_api.g_miss_num,
694: IF (x_item.mrp_obj_type IS NULL) THEN
695: x_item.mrp_obj_type := inv_ebi_item_mrp_obj(
696: fnd_api.g_miss_num,
697: fnd_api.g_miss_num,
698: fnd_api.g_miss_char,
699: fnd_api.g_miss_char,
700: fnd_api.g_miss_num,
701: fnd_api.g_miss_num,
702: fnd_api.g_miss_num,
695: x_item.mrp_obj_type := inv_ebi_item_mrp_obj(
696: fnd_api.g_miss_num,
697: fnd_api.g_miss_num,
698: fnd_api.g_miss_char,
699: fnd_api.g_miss_char,
700: fnd_api.g_miss_num,
701: fnd_api.g_miss_num,
702: fnd_api.g_miss_num,
703: fnd_api.g_miss_char,
696: fnd_api.g_miss_num,
697: fnd_api.g_miss_num,
698: fnd_api.g_miss_char,
699: fnd_api.g_miss_char,
700: fnd_api.g_miss_num,
701: fnd_api.g_miss_num,
702: fnd_api.g_miss_num,
703: fnd_api.g_miss_char,
704: fnd_api.g_miss_num,
697: fnd_api.g_miss_num,
698: fnd_api.g_miss_char,
699: fnd_api.g_miss_char,
700: fnd_api.g_miss_num,
701: fnd_api.g_miss_num,
702: fnd_api.g_miss_num,
703: fnd_api.g_miss_char,
704: fnd_api.g_miss_num,
705: fnd_api.g_miss_num,
698: fnd_api.g_miss_char,
699: fnd_api.g_miss_char,
700: fnd_api.g_miss_num,
701: fnd_api.g_miss_num,
702: fnd_api.g_miss_num,
703: fnd_api.g_miss_char,
704: fnd_api.g_miss_num,
705: fnd_api.g_miss_num,
706: fnd_api.g_miss_num,
699: fnd_api.g_miss_char,
700: fnd_api.g_miss_num,
701: fnd_api.g_miss_num,
702: fnd_api.g_miss_num,
703: fnd_api.g_miss_char,
704: fnd_api.g_miss_num,
705: fnd_api.g_miss_num,
706: fnd_api.g_miss_num,
707: fnd_api.g_miss_char,
700: fnd_api.g_miss_num,
701: fnd_api.g_miss_num,
702: fnd_api.g_miss_num,
703: fnd_api.g_miss_char,
704: fnd_api.g_miss_num,
705: fnd_api.g_miss_num,
706: fnd_api.g_miss_num,
707: fnd_api.g_miss_char,
708: fnd_api.g_miss_num,
701: fnd_api.g_miss_num,
702: fnd_api.g_miss_num,
703: fnd_api.g_miss_char,
704: fnd_api.g_miss_num,
705: fnd_api.g_miss_num,
706: fnd_api.g_miss_num,
707: fnd_api.g_miss_char,
708: fnd_api.g_miss_num,
709: fnd_api.g_miss_num,
702: fnd_api.g_miss_num,
703: fnd_api.g_miss_char,
704: fnd_api.g_miss_num,
705: fnd_api.g_miss_num,
706: fnd_api.g_miss_num,
707: fnd_api.g_miss_char,
708: fnd_api.g_miss_num,
709: fnd_api.g_miss_num,
710: fnd_api.g_miss_num,
703: fnd_api.g_miss_char,
704: fnd_api.g_miss_num,
705: fnd_api.g_miss_num,
706: fnd_api.g_miss_num,
707: fnd_api.g_miss_char,
708: fnd_api.g_miss_num,
709: fnd_api.g_miss_num,
710: fnd_api.g_miss_num,
711: fnd_api.g_miss_num,
704: fnd_api.g_miss_num,
705: fnd_api.g_miss_num,
706: fnd_api.g_miss_num,
707: fnd_api.g_miss_char,
708: fnd_api.g_miss_num,
709: fnd_api.g_miss_num,
710: fnd_api.g_miss_num,
711: fnd_api.g_miss_num,
712: fnd_api.g_miss_num,
705: fnd_api.g_miss_num,
706: fnd_api.g_miss_num,
707: fnd_api.g_miss_char,
708: fnd_api.g_miss_num,
709: fnd_api.g_miss_num,
710: fnd_api.g_miss_num,
711: fnd_api.g_miss_num,
712: fnd_api.g_miss_num,
713: fnd_api.g_miss_num,
706: fnd_api.g_miss_num,
707: fnd_api.g_miss_char,
708: fnd_api.g_miss_num,
709: fnd_api.g_miss_num,
710: fnd_api.g_miss_num,
711: fnd_api.g_miss_num,
712: fnd_api.g_miss_num,
713: fnd_api.g_miss_num,
714: fnd_api.g_miss_num,
707: fnd_api.g_miss_char,
708: fnd_api.g_miss_num,
709: fnd_api.g_miss_num,
710: fnd_api.g_miss_num,
711: fnd_api.g_miss_num,
712: fnd_api.g_miss_num,
713: fnd_api.g_miss_num,
714: fnd_api.g_miss_num,
715: fnd_api.g_miss_char,
708: fnd_api.g_miss_num,
709: fnd_api.g_miss_num,
710: fnd_api.g_miss_num,
711: fnd_api.g_miss_num,
712: fnd_api.g_miss_num,
713: fnd_api.g_miss_num,
714: fnd_api.g_miss_num,
715: fnd_api.g_miss_char,
716: fnd_api.g_miss_char,
709: fnd_api.g_miss_num,
710: fnd_api.g_miss_num,
711: fnd_api.g_miss_num,
712: fnd_api.g_miss_num,
713: fnd_api.g_miss_num,
714: fnd_api.g_miss_num,
715: fnd_api.g_miss_char,
716: fnd_api.g_miss_char,
717: fnd_api.g_miss_num,
710: fnd_api.g_miss_num,
711: fnd_api.g_miss_num,
712: fnd_api.g_miss_num,
713: fnd_api.g_miss_num,
714: fnd_api.g_miss_num,
715: fnd_api.g_miss_char,
716: fnd_api.g_miss_char,
717: fnd_api.g_miss_num,
718: fnd_api.g_miss_num,
711: fnd_api.g_miss_num,
712: fnd_api.g_miss_num,
713: fnd_api.g_miss_num,
714: fnd_api.g_miss_num,
715: fnd_api.g_miss_char,
716: fnd_api.g_miss_char,
717: fnd_api.g_miss_num,
718: fnd_api.g_miss_num,
719: fnd_api.g_miss_num,
712: fnd_api.g_miss_num,
713: fnd_api.g_miss_num,
714: fnd_api.g_miss_num,
715: fnd_api.g_miss_char,
716: fnd_api.g_miss_char,
717: fnd_api.g_miss_num,
718: fnd_api.g_miss_num,
719: fnd_api.g_miss_num,
720: fnd_api.g_miss_num,
713: fnd_api.g_miss_num,
714: fnd_api.g_miss_num,
715: fnd_api.g_miss_char,
716: fnd_api.g_miss_char,
717: fnd_api.g_miss_num,
718: fnd_api.g_miss_num,
719: fnd_api.g_miss_num,
720: fnd_api.g_miss_num,
721: fnd_api.g_miss_num,
714: fnd_api.g_miss_num,
715: fnd_api.g_miss_char,
716: fnd_api.g_miss_char,
717: fnd_api.g_miss_num,
718: fnd_api.g_miss_num,
719: fnd_api.g_miss_num,
720: fnd_api.g_miss_num,
721: fnd_api.g_miss_num,
722: fnd_api.g_miss_num,
715: fnd_api.g_miss_char,
716: fnd_api.g_miss_char,
717: fnd_api.g_miss_num,
718: fnd_api.g_miss_num,
719: fnd_api.g_miss_num,
720: fnd_api.g_miss_num,
721: fnd_api.g_miss_num,
722: fnd_api.g_miss_num,
723: fnd_api.g_miss_num,
716: fnd_api.g_miss_char,
717: fnd_api.g_miss_num,
718: fnd_api.g_miss_num,
719: fnd_api.g_miss_num,
720: fnd_api.g_miss_num,
721: fnd_api.g_miss_num,
722: fnd_api.g_miss_num,
723: fnd_api.g_miss_num,
724: fnd_api.g_miss_num,
717: fnd_api.g_miss_num,
718: fnd_api.g_miss_num,
719: fnd_api.g_miss_num,
720: fnd_api.g_miss_num,
721: fnd_api.g_miss_num,
722: fnd_api.g_miss_num,
723: fnd_api.g_miss_num,
724: fnd_api.g_miss_num,
725: fnd_api.g_miss_num,
718: fnd_api.g_miss_num,
719: fnd_api.g_miss_num,
720: fnd_api.g_miss_num,
721: fnd_api.g_miss_num,
722: fnd_api.g_miss_num,
723: fnd_api.g_miss_num,
724: fnd_api.g_miss_num,
725: fnd_api.g_miss_num,
726: fnd_api.g_miss_num,
719: fnd_api.g_miss_num,
720: fnd_api.g_miss_num,
721: fnd_api.g_miss_num,
722: fnd_api.g_miss_num,
723: fnd_api.g_miss_num,
724: fnd_api.g_miss_num,
725: fnd_api.g_miss_num,
726: fnd_api.g_miss_num,
727: fnd_api.g_miss_num,
720: fnd_api.g_miss_num,
721: fnd_api.g_miss_num,
722: fnd_api.g_miss_num,
723: fnd_api.g_miss_num,
724: fnd_api.g_miss_num,
725: fnd_api.g_miss_num,
726: fnd_api.g_miss_num,
727: fnd_api.g_miss_num,
728: fnd_api.g_miss_num,
721: fnd_api.g_miss_num,
722: fnd_api.g_miss_num,
723: fnd_api.g_miss_num,
724: fnd_api.g_miss_num,
725: fnd_api.g_miss_num,
726: fnd_api.g_miss_num,
727: fnd_api.g_miss_num,
728: fnd_api.g_miss_num,
729: fnd_api.g_miss_num,
722: fnd_api.g_miss_num,
723: fnd_api.g_miss_num,
724: fnd_api.g_miss_num,
725: fnd_api.g_miss_num,
726: fnd_api.g_miss_num,
727: fnd_api.g_miss_num,
728: fnd_api.g_miss_num,
729: fnd_api.g_miss_num,
730: fnd_api.g_miss_num,
723: fnd_api.g_miss_num,
724: fnd_api.g_miss_num,
725: fnd_api.g_miss_num,
726: fnd_api.g_miss_num,
727: fnd_api.g_miss_num,
728: fnd_api.g_miss_num,
729: fnd_api.g_miss_num,
730: fnd_api.g_miss_num,
731: fnd_api.g_miss_char,
724: fnd_api.g_miss_num,
725: fnd_api.g_miss_num,
726: fnd_api.g_miss_num,
727: fnd_api.g_miss_num,
728: fnd_api.g_miss_num,
729: fnd_api.g_miss_num,
730: fnd_api.g_miss_num,
731: fnd_api.g_miss_char,
732: fnd_api.g_miss_num
725: fnd_api.g_miss_num,
726: fnd_api.g_miss_num,
727: fnd_api.g_miss_num,
728: fnd_api.g_miss_num,
729: fnd_api.g_miss_num,
730: fnd_api.g_miss_num,
731: fnd_api.g_miss_char,
732: fnd_api.g_miss_num
733: );
726: fnd_api.g_miss_num,
727: fnd_api.g_miss_num,
728: fnd_api.g_miss_num,
729: fnd_api.g_miss_num,
730: fnd_api.g_miss_num,
731: fnd_api.g_miss_char,
732: fnd_api.g_miss_num
733: );
734: END IF;
727: fnd_api.g_miss_num,
728: fnd_api.g_miss_num,
729: fnd_api.g_miss_num,
730: fnd_api.g_miss_num,
731: fnd_api.g_miss_char,
732: fnd_api.g_miss_num
733: );
734: END IF;
735: IF (x_item.order_obj_type IS NULL) THEN
728: fnd_api.g_miss_num,
729: fnd_api.g_miss_num,
730: fnd_api.g_miss_num,
731: fnd_api.g_miss_char,
732: fnd_api.g_miss_num
733: );
734: END IF;
735: IF (x_item.order_obj_type IS NULL) THEN
736: x_item.order_obj_type := inv_ebi_item_order_obj(
733: );
734: END IF;
735: IF (x_item.order_obj_type IS NULL) THEN
736: x_item.order_obj_type := inv_ebi_item_order_obj(
737: fnd_api.g_miss_char,
738: fnd_api.g_miss_char,
739: fnd_api.g_miss_char,
740: fnd_api.g_miss_char,
741: fnd_api.g_miss_char,
734: END IF;
735: IF (x_item.order_obj_type IS NULL) THEN
736: x_item.order_obj_type := inv_ebi_item_order_obj(
737: fnd_api.g_miss_char,
738: fnd_api.g_miss_char,
739: fnd_api.g_miss_char,
740: fnd_api.g_miss_char,
741: fnd_api.g_miss_char,
742: fnd_api.g_miss_char,
735: IF (x_item.order_obj_type IS NULL) THEN
736: x_item.order_obj_type := inv_ebi_item_order_obj(
737: fnd_api.g_miss_char,
738: fnd_api.g_miss_char,
739: fnd_api.g_miss_char,
740: fnd_api.g_miss_char,
741: fnd_api.g_miss_char,
742: fnd_api.g_miss_char,
743: fnd_api.g_miss_char,
736: x_item.order_obj_type := inv_ebi_item_order_obj(
737: fnd_api.g_miss_char,
738: fnd_api.g_miss_char,
739: fnd_api.g_miss_char,
740: fnd_api.g_miss_char,
741: fnd_api.g_miss_char,
742: fnd_api.g_miss_char,
743: fnd_api.g_miss_char,
744: fnd_api.g_miss_char,
737: fnd_api.g_miss_char,
738: fnd_api.g_miss_char,
739: fnd_api.g_miss_char,
740: fnd_api.g_miss_char,
741: fnd_api.g_miss_char,
742: fnd_api.g_miss_char,
743: fnd_api.g_miss_char,
744: fnd_api.g_miss_char,
745: fnd_api.g_miss_char,
738: fnd_api.g_miss_char,
739: fnd_api.g_miss_char,
740: fnd_api.g_miss_char,
741: fnd_api.g_miss_char,
742: fnd_api.g_miss_char,
743: fnd_api.g_miss_char,
744: fnd_api.g_miss_char,
745: fnd_api.g_miss_char,
746: fnd_api.g_miss_num,
739: fnd_api.g_miss_char,
740: fnd_api.g_miss_char,
741: fnd_api.g_miss_char,
742: fnd_api.g_miss_char,
743: fnd_api.g_miss_char,
744: fnd_api.g_miss_char,
745: fnd_api.g_miss_char,
746: fnd_api.g_miss_num,
747: fnd_api.g_miss_char,
740: fnd_api.g_miss_char,
741: fnd_api.g_miss_char,
742: fnd_api.g_miss_char,
743: fnd_api.g_miss_char,
744: fnd_api.g_miss_char,
745: fnd_api.g_miss_char,
746: fnd_api.g_miss_num,
747: fnd_api.g_miss_char,
748: fnd_api.g_miss_char,
741: fnd_api.g_miss_char,
742: fnd_api.g_miss_char,
743: fnd_api.g_miss_char,
744: fnd_api.g_miss_char,
745: fnd_api.g_miss_char,
746: fnd_api.g_miss_num,
747: fnd_api.g_miss_char,
748: fnd_api.g_miss_char,
749: fnd_api.g_miss_num,
742: fnd_api.g_miss_char,
743: fnd_api.g_miss_char,
744: fnd_api.g_miss_char,
745: fnd_api.g_miss_char,
746: fnd_api.g_miss_num,
747: fnd_api.g_miss_char,
748: fnd_api.g_miss_char,
749: fnd_api.g_miss_num,
750: fnd_api.g_miss_char,
743: fnd_api.g_miss_char,
744: fnd_api.g_miss_char,
745: fnd_api.g_miss_char,
746: fnd_api.g_miss_num,
747: fnd_api.g_miss_char,
748: fnd_api.g_miss_char,
749: fnd_api.g_miss_num,
750: fnd_api.g_miss_char,
751: fnd_api.g_miss_num,
744: fnd_api.g_miss_char,
745: fnd_api.g_miss_char,
746: fnd_api.g_miss_num,
747: fnd_api.g_miss_char,
748: fnd_api.g_miss_char,
749: fnd_api.g_miss_num,
750: fnd_api.g_miss_char,
751: fnd_api.g_miss_num,
752: fnd_api.g_miss_char,
745: fnd_api.g_miss_char,
746: fnd_api.g_miss_num,
747: fnd_api.g_miss_char,
748: fnd_api.g_miss_char,
749: fnd_api.g_miss_num,
750: fnd_api.g_miss_char,
751: fnd_api.g_miss_num,
752: fnd_api.g_miss_char,
753: fnd_api.g_miss_num,
746: fnd_api.g_miss_num,
747: fnd_api.g_miss_char,
748: fnd_api.g_miss_char,
749: fnd_api.g_miss_num,
750: fnd_api.g_miss_char,
751: fnd_api.g_miss_num,
752: fnd_api.g_miss_char,
753: fnd_api.g_miss_num,
754: fnd_api.g_miss_num,
747: fnd_api.g_miss_char,
748: fnd_api.g_miss_char,
749: fnd_api.g_miss_num,
750: fnd_api.g_miss_char,
751: fnd_api.g_miss_num,
752: fnd_api.g_miss_char,
753: fnd_api.g_miss_num,
754: fnd_api.g_miss_num,
755: fnd_api.g_miss_num,
748: fnd_api.g_miss_char,
749: fnd_api.g_miss_num,
750: fnd_api.g_miss_char,
751: fnd_api.g_miss_num,
752: fnd_api.g_miss_char,
753: fnd_api.g_miss_num,
754: fnd_api.g_miss_num,
755: fnd_api.g_miss_num,
756: fnd_api.g_miss_num,
749: fnd_api.g_miss_num,
750: fnd_api.g_miss_char,
751: fnd_api.g_miss_num,
752: fnd_api.g_miss_char,
753: fnd_api.g_miss_num,
754: fnd_api.g_miss_num,
755: fnd_api.g_miss_num,
756: fnd_api.g_miss_num,
757: fnd_api.g_miss_num,
750: fnd_api.g_miss_char,
751: fnd_api.g_miss_num,
752: fnd_api.g_miss_char,
753: fnd_api.g_miss_num,
754: fnd_api.g_miss_num,
755: fnd_api.g_miss_num,
756: fnd_api.g_miss_num,
757: fnd_api.g_miss_num,
758: fnd_api.g_miss_char,
751: fnd_api.g_miss_num,
752: fnd_api.g_miss_char,
753: fnd_api.g_miss_num,
754: fnd_api.g_miss_num,
755: fnd_api.g_miss_num,
756: fnd_api.g_miss_num,
757: fnd_api.g_miss_num,
758: fnd_api.g_miss_char,
759: fnd_api.g_miss_char,
752: fnd_api.g_miss_char,
753: fnd_api.g_miss_num,
754: fnd_api.g_miss_num,
755: fnd_api.g_miss_num,
756: fnd_api.g_miss_num,
757: fnd_api.g_miss_num,
758: fnd_api.g_miss_char,
759: fnd_api.g_miss_char,
760: fnd_api.g_miss_char
753: fnd_api.g_miss_num,
754: fnd_api.g_miss_num,
755: fnd_api.g_miss_num,
756: fnd_api.g_miss_num,
757: fnd_api.g_miss_num,
758: fnd_api.g_miss_char,
759: fnd_api.g_miss_char,
760: fnd_api.g_miss_char
761: );
754: fnd_api.g_miss_num,
755: fnd_api.g_miss_num,
756: fnd_api.g_miss_num,
757: fnd_api.g_miss_num,
758: fnd_api.g_miss_char,
759: fnd_api.g_miss_char,
760: fnd_api.g_miss_char
761: );
762: END IF;
755: fnd_api.g_miss_num,
756: fnd_api.g_miss_num,
757: fnd_api.g_miss_num,
758: fnd_api.g_miss_char,
759: fnd_api.g_miss_char,
760: fnd_api.g_miss_char
761: );
762: END IF;
763: IF (x_item.service_obj_type IS NULL) THEN
756: fnd_api.g_miss_num,
757: fnd_api.g_miss_num,
758: fnd_api.g_miss_char,
759: fnd_api.g_miss_char,
760: fnd_api.g_miss_char
761: );
762: END IF;
763: IF (x_item.service_obj_type IS NULL) THEN
764: x_item.service_obj_type := inv_ebi_item_service_obj(
761: );
762: END IF;
763: IF (x_item.service_obj_type IS NULL) THEN
764: x_item.service_obj_type := inv_ebi_item_service_obj(
765: fnd_api.g_miss_num,
766: fnd_api.g_miss_num,
767: fnd_api.g_miss_char,
768: fnd_api.g_miss_char,
769: fnd_api.g_miss_num,
762: END IF;
763: IF (x_item.service_obj_type IS NULL) THEN
764: x_item.service_obj_type := inv_ebi_item_service_obj(
765: fnd_api.g_miss_num,
766: fnd_api.g_miss_num,
767: fnd_api.g_miss_char,
768: fnd_api.g_miss_char,
769: fnd_api.g_miss_num,
770: fnd_api.g_miss_char,
763: IF (x_item.service_obj_type IS NULL) THEN
764: x_item.service_obj_type := inv_ebi_item_service_obj(
765: fnd_api.g_miss_num,
766: fnd_api.g_miss_num,
767: fnd_api.g_miss_char,
768: fnd_api.g_miss_char,
769: fnd_api.g_miss_num,
770: fnd_api.g_miss_char,
771: fnd_api.g_miss_char,
764: x_item.service_obj_type := inv_ebi_item_service_obj(
765: fnd_api.g_miss_num,
766: fnd_api.g_miss_num,
767: fnd_api.g_miss_char,
768: fnd_api.g_miss_char,
769: fnd_api.g_miss_num,
770: fnd_api.g_miss_char,
771: fnd_api.g_miss_char,
772: fnd_api.g_miss_char,
765: fnd_api.g_miss_num,
766: fnd_api.g_miss_num,
767: fnd_api.g_miss_char,
768: fnd_api.g_miss_char,
769: fnd_api.g_miss_num,
770: fnd_api.g_miss_char,
771: fnd_api.g_miss_char,
772: fnd_api.g_miss_char,
773: fnd_api.g_miss_char,
766: fnd_api.g_miss_num,
767: fnd_api.g_miss_char,
768: fnd_api.g_miss_char,
769: fnd_api.g_miss_num,
770: fnd_api.g_miss_char,
771: fnd_api.g_miss_char,
772: fnd_api.g_miss_char,
773: fnd_api.g_miss_char,
774: fnd_api.g_miss_char,
767: fnd_api.g_miss_char,
768: fnd_api.g_miss_char,
769: fnd_api.g_miss_num,
770: fnd_api.g_miss_char,
771: fnd_api.g_miss_char,
772: fnd_api.g_miss_char,
773: fnd_api.g_miss_char,
774: fnd_api.g_miss_char,
775: fnd_api.g_miss_char
768: fnd_api.g_miss_char,
769: fnd_api.g_miss_num,
770: fnd_api.g_miss_char,
771: fnd_api.g_miss_char,
772: fnd_api.g_miss_char,
773: fnd_api.g_miss_char,
774: fnd_api.g_miss_char,
775: fnd_api.g_miss_char
776: );
769: fnd_api.g_miss_num,
770: fnd_api.g_miss_char,
771: fnd_api.g_miss_char,
772: fnd_api.g_miss_char,
773: fnd_api.g_miss_char,
774: fnd_api.g_miss_char,
775: fnd_api.g_miss_char
776: );
777: END IF;
770: fnd_api.g_miss_char,
771: fnd_api.g_miss_char,
772: fnd_api.g_miss_char,
773: fnd_api.g_miss_char,
774: fnd_api.g_miss_char,
775: fnd_api.g_miss_char
776: );
777: END IF;
778: IF (x_item.bom_obj_type IS NULL) THEN
771: fnd_api.g_miss_char,
772: fnd_api.g_miss_char,
773: fnd_api.g_miss_char,
774: fnd_api.g_miss_char,
775: fnd_api.g_miss_char
776: );
777: END IF;
778: IF (x_item.bom_obj_type IS NULL) THEN
779: x_item.bom_obj_type := inv_ebi_item_bom_obj(
776: );
777: END IF;
778: IF (x_item.bom_obj_type IS NULL) THEN
779: x_item.bom_obj_type := inv_ebi_item_bom_obj(
780: fnd_api.g_miss_char,
781: fnd_api.g_miss_num,
782: fnd_api.g_miss_num,
783: fnd_api.g_miss_char,
784: fnd_api.g_miss_num,
777: END IF;
778: IF (x_item.bom_obj_type IS NULL) THEN
779: x_item.bom_obj_type := inv_ebi_item_bom_obj(
780: fnd_api.g_miss_char,
781: fnd_api.g_miss_num,
782: fnd_api.g_miss_num,
783: fnd_api.g_miss_char,
784: fnd_api.g_miss_num,
785: fnd_api.g_miss_char,
778: IF (x_item.bom_obj_type IS NULL) THEN
779: x_item.bom_obj_type := inv_ebi_item_bom_obj(
780: fnd_api.g_miss_char,
781: fnd_api.g_miss_num,
782: fnd_api.g_miss_num,
783: fnd_api.g_miss_char,
784: fnd_api.g_miss_num,
785: fnd_api.g_miss_char,
786: fnd_api.g_miss_char,
779: x_item.bom_obj_type := inv_ebi_item_bom_obj(
780: fnd_api.g_miss_char,
781: fnd_api.g_miss_num,
782: fnd_api.g_miss_num,
783: fnd_api.g_miss_char,
784: fnd_api.g_miss_num,
785: fnd_api.g_miss_char,
786: fnd_api.g_miss_char,
787: fnd_api.g_miss_char,
780: fnd_api.g_miss_char,
781: fnd_api.g_miss_num,
782: fnd_api.g_miss_num,
783: fnd_api.g_miss_char,
784: fnd_api.g_miss_num,
785: fnd_api.g_miss_char,
786: fnd_api.g_miss_char,
787: fnd_api.g_miss_char,
788: fnd_api.g_miss_char,
781: fnd_api.g_miss_num,
782: fnd_api.g_miss_num,
783: fnd_api.g_miss_char,
784: fnd_api.g_miss_num,
785: fnd_api.g_miss_char,
786: fnd_api.g_miss_char,
787: fnd_api.g_miss_char,
788: fnd_api.g_miss_char,
789: fnd_api.g_miss_char
782: fnd_api.g_miss_num,
783: fnd_api.g_miss_char,
784: fnd_api.g_miss_num,
785: fnd_api.g_miss_char,
786: fnd_api.g_miss_char,
787: fnd_api.g_miss_char,
788: fnd_api.g_miss_char,
789: fnd_api.g_miss_char
790: );
783: fnd_api.g_miss_char,
784: fnd_api.g_miss_num,
785: fnd_api.g_miss_char,
786: fnd_api.g_miss_char,
787: fnd_api.g_miss_char,
788: fnd_api.g_miss_char,
789: fnd_api.g_miss_char
790: );
791: END IF;
784: fnd_api.g_miss_num,
785: fnd_api.g_miss_char,
786: fnd_api.g_miss_char,
787: fnd_api.g_miss_char,
788: fnd_api.g_miss_char,
789: fnd_api.g_miss_char
790: );
791: END IF;
792: IF (x_item.costing_obj_type IS NULL) THEN
785: fnd_api.g_miss_char,
786: fnd_api.g_miss_char,
787: fnd_api.g_miss_char,
788: fnd_api.g_miss_char,
789: fnd_api.g_miss_char
790: );
791: END IF;
792: IF (x_item.costing_obj_type IS NULL) THEN
793: x_item.costing_obj_type := inv_ebi_item_costing_obj(
790: );
791: END IF;
792: IF (x_item.costing_obj_type IS NULL) THEN
793: x_item.costing_obj_type := inv_ebi_item_costing_obj(
794: fnd_api.g_miss_char,
795: fnd_api.g_miss_char,
796: fnd_api.g_miss_char,
797: fnd_api.g_miss_num,
798: fnd_api.g_miss_num,
791: END IF;
792: IF (x_item.costing_obj_type IS NULL) THEN
793: x_item.costing_obj_type := inv_ebi_item_costing_obj(
794: fnd_api.g_miss_char,
795: fnd_api.g_miss_char,
796: fnd_api.g_miss_char,
797: fnd_api.g_miss_num,
798: fnd_api.g_miss_num,
799: fnd_api.g_miss_num
792: IF (x_item.costing_obj_type IS NULL) THEN
793: x_item.costing_obj_type := inv_ebi_item_costing_obj(
794: fnd_api.g_miss_char,
795: fnd_api.g_miss_char,
796: fnd_api.g_miss_char,
797: fnd_api.g_miss_num,
798: fnd_api.g_miss_num,
799: fnd_api.g_miss_num
800: );
793: x_item.costing_obj_type := inv_ebi_item_costing_obj(
794: fnd_api.g_miss_char,
795: fnd_api.g_miss_char,
796: fnd_api.g_miss_char,
797: fnd_api.g_miss_num,
798: fnd_api.g_miss_num,
799: fnd_api.g_miss_num
800: );
801: END IF;
794: fnd_api.g_miss_char,
795: fnd_api.g_miss_char,
796: fnd_api.g_miss_char,
797: fnd_api.g_miss_num,
798: fnd_api.g_miss_num,
799: fnd_api.g_miss_num
800: );
801: END IF;
802: IF (x_item.lead_time_obj_type IS NULL) THEN
795: fnd_api.g_miss_char,
796: fnd_api.g_miss_char,
797: fnd_api.g_miss_num,
798: fnd_api.g_miss_num,
799: fnd_api.g_miss_num
800: );
801: END IF;
802: IF (x_item.lead_time_obj_type IS NULL) THEN
803: x_item.lead_time_obj_type := inv_ebi_item_lead_time_obj(
800: );
801: END IF;
802: IF (x_item.lead_time_obj_type IS NULL) THEN
803: x_item.lead_time_obj_type := inv_ebi_item_lead_time_obj(
804: fnd_api.g_miss_num,
805: fnd_api.g_miss_num,
806: fnd_api.g_miss_num,
807: fnd_api.g_miss_num,
808: fnd_api.g_miss_num,
801: END IF;
802: IF (x_item.lead_time_obj_type IS NULL) THEN
803: x_item.lead_time_obj_type := inv_ebi_item_lead_time_obj(
804: fnd_api.g_miss_num,
805: fnd_api.g_miss_num,
806: fnd_api.g_miss_num,
807: fnd_api.g_miss_num,
808: fnd_api.g_miss_num,
809: fnd_api.g_miss_num,
802: IF (x_item.lead_time_obj_type IS NULL) THEN
803: x_item.lead_time_obj_type := inv_ebi_item_lead_time_obj(
804: fnd_api.g_miss_num,
805: fnd_api.g_miss_num,
806: fnd_api.g_miss_num,
807: fnd_api.g_miss_num,
808: fnd_api.g_miss_num,
809: fnd_api.g_miss_num,
810: fnd_api.g_miss_num,
803: x_item.lead_time_obj_type := inv_ebi_item_lead_time_obj(
804: fnd_api.g_miss_num,
805: fnd_api.g_miss_num,
806: fnd_api.g_miss_num,
807: fnd_api.g_miss_num,
808: fnd_api.g_miss_num,
809: fnd_api.g_miss_num,
810: fnd_api.g_miss_num,
811: fnd_api.g_miss_num
804: fnd_api.g_miss_num,
805: fnd_api.g_miss_num,
806: fnd_api.g_miss_num,
807: fnd_api.g_miss_num,
808: fnd_api.g_miss_num,
809: fnd_api.g_miss_num,
810: fnd_api.g_miss_num,
811: fnd_api.g_miss_num
812: );
805: fnd_api.g_miss_num,
806: fnd_api.g_miss_num,
807: fnd_api.g_miss_num,
808: fnd_api.g_miss_num,
809: fnd_api.g_miss_num,
810: fnd_api.g_miss_num,
811: fnd_api.g_miss_num
812: );
813: END IF;
806: fnd_api.g_miss_num,
807: fnd_api.g_miss_num,
808: fnd_api.g_miss_num,
809: fnd_api.g_miss_num,
810: fnd_api.g_miss_num,
811: fnd_api.g_miss_num
812: );
813: END IF;
814: IF (x_item.wip_obj_type IS NULL) THEN
807: fnd_api.g_miss_num,
808: fnd_api.g_miss_num,
809: fnd_api.g_miss_num,
810: fnd_api.g_miss_num,
811: fnd_api.g_miss_num
812: );
813: END IF;
814: IF (x_item.wip_obj_type IS NULL) THEN
815: x_item.wip_obj_type := inv_ebi_item_wip_obj(
812: );
813: END IF;
814: IF (x_item.wip_obj_type IS NULL) THEN
815: x_item.wip_obj_type := inv_ebi_item_wip_obj(
816: fnd_api.g_miss_char,
817: fnd_api.g_miss_num,
818: fnd_api.g_miss_char,
819: fnd_api.g_miss_num,
820: fnd_api.g_miss_num,
813: END IF;
814: IF (x_item.wip_obj_type IS NULL) THEN
815: x_item.wip_obj_type := inv_ebi_item_wip_obj(
816: fnd_api.g_miss_char,
817: fnd_api.g_miss_num,
818: fnd_api.g_miss_char,
819: fnd_api.g_miss_num,
820: fnd_api.g_miss_num,
821: fnd_api.g_miss_num,
814: IF (x_item.wip_obj_type IS NULL) THEN
815: x_item.wip_obj_type := inv_ebi_item_wip_obj(
816: fnd_api.g_miss_char,
817: fnd_api.g_miss_num,
818: fnd_api.g_miss_char,
819: fnd_api.g_miss_num,
820: fnd_api.g_miss_num,
821: fnd_api.g_miss_num,
822: fnd_api.g_miss_num,
815: x_item.wip_obj_type := inv_ebi_item_wip_obj(
816: fnd_api.g_miss_char,
817: fnd_api.g_miss_num,
818: fnd_api.g_miss_char,
819: fnd_api.g_miss_num,
820: fnd_api.g_miss_num,
821: fnd_api.g_miss_num,
822: fnd_api.g_miss_num,
823: fnd_api.g_miss_num
816: fnd_api.g_miss_char,
817: fnd_api.g_miss_num,
818: fnd_api.g_miss_char,
819: fnd_api.g_miss_num,
820: fnd_api.g_miss_num,
821: fnd_api.g_miss_num,
822: fnd_api.g_miss_num,
823: fnd_api.g_miss_num
824: );
817: fnd_api.g_miss_num,
818: fnd_api.g_miss_char,
819: fnd_api.g_miss_num,
820: fnd_api.g_miss_num,
821: fnd_api.g_miss_num,
822: fnd_api.g_miss_num,
823: fnd_api.g_miss_num
824: );
825: END IF;
818: fnd_api.g_miss_char,
819: fnd_api.g_miss_num,
820: fnd_api.g_miss_num,
821: fnd_api.g_miss_num,
822: fnd_api.g_miss_num,
823: fnd_api.g_miss_num
824: );
825: END IF;
826: IF (x_item.invoice_obj_type IS NULL) THEN
819: fnd_api.g_miss_num,
820: fnd_api.g_miss_num,
821: fnd_api.g_miss_num,
822: fnd_api.g_miss_num,
823: fnd_api.g_miss_num
824: );
825: END IF;
826: IF (x_item.invoice_obj_type IS NULL) THEN
827: x_item.invoice_obj_type := inv_ebi_item_invoice_obj(
824: );
825: END IF;
826: IF (x_item.invoice_obj_type IS NULL) THEN
827: x_item.invoice_obj_type := inv_ebi_item_invoice_obj(
828: fnd_api.g_miss_char,
829: fnd_api.g_miss_char,
830: fnd_api.g_miss_num,
831: fnd_api.g_miss_num,
832: fnd_api.g_miss_char,
825: END IF;
826: IF (x_item.invoice_obj_type IS NULL) THEN
827: x_item.invoice_obj_type := inv_ebi_item_invoice_obj(
828: fnd_api.g_miss_char,
829: fnd_api.g_miss_char,
830: fnd_api.g_miss_num,
831: fnd_api.g_miss_num,
832: fnd_api.g_miss_char,
833: fnd_api.g_miss_num,
826: IF (x_item.invoice_obj_type IS NULL) THEN
827: x_item.invoice_obj_type := inv_ebi_item_invoice_obj(
828: fnd_api.g_miss_char,
829: fnd_api.g_miss_char,
830: fnd_api.g_miss_num,
831: fnd_api.g_miss_num,
832: fnd_api.g_miss_char,
833: fnd_api.g_miss_num,
834: fnd_api.g_miss_num
827: x_item.invoice_obj_type := inv_ebi_item_invoice_obj(
828: fnd_api.g_miss_char,
829: fnd_api.g_miss_char,
830: fnd_api.g_miss_num,
831: fnd_api.g_miss_num,
832: fnd_api.g_miss_char,
833: fnd_api.g_miss_num,
834: fnd_api.g_miss_num
835: );
828: fnd_api.g_miss_char,
829: fnd_api.g_miss_char,
830: fnd_api.g_miss_num,
831: fnd_api.g_miss_num,
832: fnd_api.g_miss_char,
833: fnd_api.g_miss_num,
834: fnd_api.g_miss_num
835: );
836: END IF;
829: fnd_api.g_miss_char,
830: fnd_api.g_miss_num,
831: fnd_api.g_miss_num,
832: fnd_api.g_miss_char,
833: fnd_api.g_miss_num,
834: fnd_api.g_miss_num
835: );
836: END IF;
837: IF (x_item.web_option_obj_type IS NULL) THEN
830: fnd_api.g_miss_num,
831: fnd_api.g_miss_num,
832: fnd_api.g_miss_char,
833: fnd_api.g_miss_num,
834: fnd_api.g_miss_num
835: );
836: END IF;
837: IF (x_item.web_option_obj_type IS NULL) THEN
838: x_item.web_option_obj_type := inv_ebi_item_web_option_obj(
835: );
836: END IF;
837: IF (x_item.web_option_obj_type IS NULL) THEN
838: x_item.web_option_obj_type := inv_ebi_item_web_option_obj(
839: fnd_api.g_miss_char,
840: fnd_api.g_miss_char,
841: fnd_api.g_miss_char,
842: fnd_api.g_miss_num
843: );
836: END IF;
837: IF (x_item.web_option_obj_type IS NULL) THEN
838: x_item.web_option_obj_type := inv_ebi_item_web_option_obj(
839: fnd_api.g_miss_char,
840: fnd_api.g_miss_char,
841: fnd_api.g_miss_char,
842: fnd_api.g_miss_num
843: );
844: END IF;
837: IF (x_item.web_option_obj_type IS NULL) THEN
838: x_item.web_option_obj_type := inv_ebi_item_web_option_obj(
839: fnd_api.g_miss_char,
840: fnd_api.g_miss_char,
841: fnd_api.g_miss_char,
842: fnd_api.g_miss_num
843: );
844: END IF;
845: IF (x_item.asset_obj_type IS NULL) THEN
838: x_item.web_option_obj_type := inv_ebi_item_web_option_obj(
839: fnd_api.g_miss_char,
840: fnd_api.g_miss_char,
841: fnd_api.g_miss_char,
842: fnd_api.g_miss_num
843: );
844: END IF;
845: IF (x_item.asset_obj_type IS NULL) THEN
846: x_item.asset_obj_type := inv_ebi_item_asset_obj(
843: );
844: END IF;
845: IF (x_item.asset_obj_type IS NULL) THEN
846: x_item.asset_obj_type := inv_ebi_item_asset_obj(
847: fnd_api.g_miss_num,
848: fnd_api.g_miss_char,
849: fnd_api.g_miss_char,
850: fnd_api.g_miss_char,
851: fnd_api.g_miss_char,
844: END IF;
845: IF (x_item.asset_obj_type IS NULL) THEN
846: x_item.asset_obj_type := inv_ebi_item_asset_obj(
847: fnd_api.g_miss_num,
848: fnd_api.g_miss_char,
849: fnd_api.g_miss_char,
850: fnd_api.g_miss_char,
851: fnd_api.g_miss_char,
852: fnd_api.g_miss_char,
845: IF (x_item.asset_obj_type IS NULL) THEN
846: x_item.asset_obj_type := inv_ebi_item_asset_obj(
847: fnd_api.g_miss_num,
848: fnd_api.g_miss_char,
849: fnd_api.g_miss_char,
850: fnd_api.g_miss_char,
851: fnd_api.g_miss_char,
852: fnd_api.g_miss_char,
853: fnd_api.g_miss_char,
846: x_item.asset_obj_type := inv_ebi_item_asset_obj(
847: fnd_api.g_miss_num,
848: fnd_api.g_miss_char,
849: fnd_api.g_miss_char,
850: fnd_api.g_miss_char,
851: fnd_api.g_miss_char,
852: fnd_api.g_miss_char,
853: fnd_api.g_miss_char,
854: fnd_api.g_miss_char,
847: fnd_api.g_miss_num,
848: fnd_api.g_miss_char,
849: fnd_api.g_miss_char,
850: fnd_api.g_miss_char,
851: fnd_api.g_miss_char,
852: fnd_api.g_miss_char,
853: fnd_api.g_miss_char,
854: fnd_api.g_miss_char,
855: fnd_api.g_miss_char
848: fnd_api.g_miss_char,
849: fnd_api.g_miss_char,
850: fnd_api.g_miss_char,
851: fnd_api.g_miss_char,
852: fnd_api.g_miss_char,
853: fnd_api.g_miss_char,
854: fnd_api.g_miss_char,
855: fnd_api.g_miss_char
856: );
849: fnd_api.g_miss_char,
850: fnd_api.g_miss_char,
851: fnd_api.g_miss_char,
852: fnd_api.g_miss_char,
853: fnd_api.g_miss_char,
854: fnd_api.g_miss_char,
855: fnd_api.g_miss_char
856: );
857: END IF;
850: fnd_api.g_miss_char,
851: fnd_api.g_miss_char,
852: fnd_api.g_miss_char,
853: fnd_api.g_miss_char,
854: fnd_api.g_miss_char,
855: fnd_api.g_miss_char
856: );
857: END IF;
858: IF (x_item.deprecated_obj_type IS NULL) THEN
851: fnd_api.g_miss_char,
852: fnd_api.g_miss_char,
853: fnd_api.g_miss_char,
854: fnd_api.g_miss_char,
855: fnd_api.g_miss_char
856: );
857: END IF;
858: IF (x_item.deprecated_obj_type IS NULL) THEN
859: x_item.deprecated_obj_type := inv_ebi_item_deprecated_obj(
856: );
857: END IF;
858: IF (x_item.deprecated_obj_type IS NULL) THEN
859: x_item.deprecated_obj_type := inv_ebi_item_deprecated_obj(
860: fnd_api.g_miss_char,
861: fnd_api.g_miss_num,
862: fnd_api.g_miss_num,
863: fnd_api.g_miss_char,
864: fnd_api.g_miss_num,
857: END IF;
858: IF (x_item.deprecated_obj_type IS NULL) THEN
859: x_item.deprecated_obj_type := inv_ebi_item_deprecated_obj(
860: fnd_api.g_miss_char,
861: fnd_api.g_miss_num,
862: fnd_api.g_miss_num,
863: fnd_api.g_miss_char,
864: fnd_api.g_miss_num,
865: fnd_api.g_miss_date,
858: IF (x_item.deprecated_obj_type IS NULL) THEN
859: x_item.deprecated_obj_type := inv_ebi_item_deprecated_obj(
860: fnd_api.g_miss_char,
861: fnd_api.g_miss_num,
862: fnd_api.g_miss_num,
863: fnd_api.g_miss_char,
864: fnd_api.g_miss_num,
865: fnd_api.g_miss_date,
866: fnd_api.g_miss_num,
859: x_item.deprecated_obj_type := inv_ebi_item_deprecated_obj(
860: fnd_api.g_miss_char,
861: fnd_api.g_miss_num,
862: fnd_api.g_miss_num,
863: fnd_api.g_miss_char,
864: fnd_api.g_miss_num,
865: fnd_api.g_miss_date,
866: fnd_api.g_miss_num,
867: fnd_api.g_miss_char,
860: fnd_api.g_miss_char,
861: fnd_api.g_miss_num,
862: fnd_api.g_miss_num,
863: fnd_api.g_miss_char,
864: fnd_api.g_miss_num,
865: fnd_api.g_miss_date,
866: fnd_api.g_miss_num,
867: fnd_api.g_miss_char,
868: fnd_api.g_miss_char,
861: fnd_api.g_miss_num,
862: fnd_api.g_miss_num,
863: fnd_api.g_miss_char,
864: fnd_api.g_miss_num,
865: fnd_api.g_miss_date,
866: fnd_api.g_miss_num,
867: fnd_api.g_miss_char,
868: fnd_api.g_miss_char,
869: fnd_api.g_miss_char,
862: fnd_api.g_miss_num,
863: fnd_api.g_miss_char,
864: fnd_api.g_miss_num,
865: fnd_api.g_miss_date,
866: fnd_api.g_miss_num,
867: fnd_api.g_miss_char,
868: fnd_api.g_miss_char,
869: fnd_api.g_miss_char,
870: fnd_api.g_miss_char,
863: fnd_api.g_miss_char,
864: fnd_api.g_miss_num,
865: fnd_api.g_miss_date,
866: fnd_api.g_miss_num,
867: fnd_api.g_miss_char,
868: fnd_api.g_miss_char,
869: fnd_api.g_miss_char,
870: fnd_api.g_miss_char,
871: fnd_api.g_miss_char,
864: fnd_api.g_miss_num,
865: fnd_api.g_miss_date,
866: fnd_api.g_miss_num,
867: fnd_api.g_miss_char,
868: fnd_api.g_miss_char,
869: fnd_api.g_miss_char,
870: fnd_api.g_miss_char,
871: fnd_api.g_miss_char,
872: fnd_api.g_miss_char,
865: fnd_api.g_miss_date,
866: fnd_api.g_miss_num,
867: fnd_api.g_miss_char,
868: fnd_api.g_miss_char,
869: fnd_api.g_miss_char,
870: fnd_api.g_miss_char,
871: fnd_api.g_miss_char,
872: fnd_api.g_miss_char,
873: fnd_api.g_miss_num,
866: fnd_api.g_miss_num,
867: fnd_api.g_miss_char,
868: fnd_api.g_miss_char,
869: fnd_api.g_miss_char,
870: fnd_api.g_miss_char,
871: fnd_api.g_miss_char,
872: fnd_api.g_miss_char,
873: fnd_api.g_miss_num,
874: fnd_api.g_miss_num,
867: fnd_api.g_miss_char,
868: fnd_api.g_miss_char,
869: fnd_api.g_miss_char,
870: fnd_api.g_miss_char,
871: fnd_api.g_miss_char,
872: fnd_api.g_miss_char,
873: fnd_api.g_miss_num,
874: fnd_api.g_miss_num,
875: fnd_api.g_miss_num,
868: fnd_api.g_miss_char,
869: fnd_api.g_miss_char,
870: fnd_api.g_miss_char,
871: fnd_api.g_miss_char,
872: fnd_api.g_miss_char,
873: fnd_api.g_miss_num,
874: fnd_api.g_miss_num,
875: fnd_api.g_miss_num,
876: fnd_api.g_miss_num,
869: fnd_api.g_miss_char,
870: fnd_api.g_miss_char,
871: fnd_api.g_miss_char,
872: fnd_api.g_miss_char,
873: fnd_api.g_miss_num,
874: fnd_api.g_miss_num,
875: fnd_api.g_miss_num,
876: fnd_api.g_miss_num,
877: fnd_api.g_miss_char,
870: fnd_api.g_miss_char,
871: fnd_api.g_miss_char,
872: fnd_api.g_miss_char,
873: fnd_api.g_miss_num,
874: fnd_api.g_miss_num,
875: fnd_api.g_miss_num,
876: fnd_api.g_miss_num,
877: fnd_api.g_miss_char,
878: fnd_api.g_miss_num,
871: fnd_api.g_miss_char,
872: fnd_api.g_miss_char,
873: fnd_api.g_miss_num,
874: fnd_api.g_miss_num,
875: fnd_api.g_miss_num,
876: fnd_api.g_miss_num,
877: fnd_api.g_miss_char,
878: fnd_api.g_miss_num,
879: fnd_api.g_miss_num,
872: fnd_api.g_miss_char,
873: fnd_api.g_miss_num,
874: fnd_api.g_miss_num,
875: fnd_api.g_miss_num,
876: fnd_api.g_miss_num,
877: fnd_api.g_miss_char,
878: fnd_api.g_miss_num,
879: fnd_api.g_miss_num,
880: fnd_api.g_miss_num,
873: fnd_api.g_miss_num,
874: fnd_api.g_miss_num,
875: fnd_api.g_miss_num,
876: fnd_api.g_miss_num,
877: fnd_api.g_miss_char,
878: fnd_api.g_miss_num,
879: fnd_api.g_miss_num,
880: fnd_api.g_miss_num,
881: fnd_api.g_miss_date,
874: fnd_api.g_miss_num,
875: fnd_api.g_miss_num,
876: fnd_api.g_miss_num,
877: fnd_api.g_miss_char,
878: fnd_api.g_miss_num,
879: fnd_api.g_miss_num,
880: fnd_api.g_miss_num,
881: fnd_api.g_miss_date,
882: fnd_api.g_miss_char,
875: fnd_api.g_miss_num,
876: fnd_api.g_miss_num,
877: fnd_api.g_miss_char,
878: fnd_api.g_miss_num,
879: fnd_api.g_miss_num,
880: fnd_api.g_miss_num,
881: fnd_api.g_miss_date,
882: fnd_api.g_miss_char,
883: fnd_api.g_miss_char,
876: fnd_api.g_miss_num,
877: fnd_api.g_miss_char,
878: fnd_api.g_miss_num,
879: fnd_api.g_miss_num,
880: fnd_api.g_miss_num,
881: fnd_api.g_miss_date,
882: fnd_api.g_miss_char,
883: fnd_api.g_miss_char,
884: fnd_api.g_miss_char,
877: fnd_api.g_miss_char,
878: fnd_api.g_miss_num,
879: fnd_api.g_miss_num,
880: fnd_api.g_miss_num,
881: fnd_api.g_miss_date,
882: fnd_api.g_miss_char,
883: fnd_api.g_miss_char,
884: fnd_api.g_miss_char,
885: fnd_api.g_miss_num,
878: fnd_api.g_miss_num,
879: fnd_api.g_miss_num,
880: fnd_api.g_miss_num,
881: fnd_api.g_miss_date,
882: fnd_api.g_miss_char,
883: fnd_api.g_miss_char,
884: fnd_api.g_miss_char,
885: fnd_api.g_miss_num,
886: fnd_api.g_miss_char,
879: fnd_api.g_miss_num,
880: fnd_api.g_miss_num,
881: fnd_api.g_miss_date,
882: fnd_api.g_miss_char,
883: fnd_api.g_miss_char,
884: fnd_api.g_miss_char,
885: fnd_api.g_miss_num,
886: fnd_api.g_miss_char,
887: fnd_api.g_miss_num,
880: fnd_api.g_miss_num,
881: fnd_api.g_miss_date,
882: fnd_api.g_miss_char,
883: fnd_api.g_miss_char,
884: fnd_api.g_miss_char,
885: fnd_api.g_miss_num,
886: fnd_api.g_miss_char,
887: fnd_api.g_miss_num,
888: fnd_api.g_miss_char,
881: fnd_api.g_miss_date,
882: fnd_api.g_miss_char,
883: fnd_api.g_miss_char,
884: fnd_api.g_miss_char,
885: fnd_api.g_miss_num,
886: fnd_api.g_miss_char,
887: fnd_api.g_miss_num,
888: fnd_api.g_miss_char,
889: fnd_api.g_miss_num,
882: fnd_api.g_miss_char,
883: fnd_api.g_miss_char,
884: fnd_api.g_miss_char,
885: fnd_api.g_miss_num,
886: fnd_api.g_miss_char,
887: fnd_api.g_miss_num,
888: fnd_api.g_miss_char,
889: fnd_api.g_miss_num,
890: fnd_api.g_miss_num,
883: fnd_api.g_miss_char,
884: fnd_api.g_miss_char,
885: fnd_api.g_miss_num,
886: fnd_api.g_miss_char,
887: fnd_api.g_miss_num,
888: fnd_api.g_miss_char,
889: fnd_api.g_miss_num,
890: fnd_api.g_miss_num,
891: fnd_api.g_miss_char,
884: fnd_api.g_miss_char,
885: fnd_api.g_miss_num,
886: fnd_api.g_miss_char,
887: fnd_api.g_miss_num,
888: fnd_api.g_miss_char,
889: fnd_api.g_miss_num,
890: fnd_api.g_miss_num,
891: fnd_api.g_miss_char,
892: fnd_api.g_miss_char
885: fnd_api.g_miss_num,
886: fnd_api.g_miss_char,
887: fnd_api.g_miss_num,
888: fnd_api.g_miss_char,
889: fnd_api.g_miss_num,
890: fnd_api.g_miss_num,
891: fnd_api.g_miss_char,
892: fnd_api.g_miss_char
893: );
886: fnd_api.g_miss_char,
887: fnd_api.g_miss_num,
888: fnd_api.g_miss_char,
889: fnd_api.g_miss_num,
890: fnd_api.g_miss_num,
891: fnd_api.g_miss_char,
892: fnd_api.g_miss_char
893: );
894: END IF;
887: fnd_api.g_miss_num,
888: fnd_api.g_miss_char,
889: fnd_api.g_miss_num,
890: fnd_api.g_miss_num,
891: fnd_api.g_miss_char,
892: fnd_api.g_miss_char
893: );
894: END IF;
895: IF (x_item.process_manufacturing_obj IS NULL) THEN
888: fnd_api.g_miss_char,
889: fnd_api.g_miss_num,
890: fnd_api.g_miss_num,
891: fnd_api.g_miss_char,
892: fnd_api.g_miss_char
893: );
894: END IF;
895: IF (x_item.process_manufacturing_obj IS NULL) THEN
896: x_item.process_manufacturing_obj := inv_ebi_item_processmfg_obj(
893: );
894: END IF;
895: IF (x_item.process_manufacturing_obj IS NULL) THEN
896: x_item.process_manufacturing_obj := inv_ebi_item_processmfg_obj(
897: fnd_api.g_miss_char,
898: fnd_api.g_miss_char,
899: fnd_api.g_miss_char,
900: fnd_api.g_miss_char,
901: fnd_api.g_miss_char,
894: END IF;
895: IF (x_item.process_manufacturing_obj IS NULL) THEN
896: x_item.process_manufacturing_obj := inv_ebi_item_processmfg_obj(
897: fnd_api.g_miss_char,
898: fnd_api.g_miss_char,
899: fnd_api.g_miss_char,
900: fnd_api.g_miss_char,
901: fnd_api.g_miss_char,
902: fnd_api.g_miss_num,
895: IF (x_item.process_manufacturing_obj IS NULL) THEN
896: x_item.process_manufacturing_obj := inv_ebi_item_processmfg_obj(
897: fnd_api.g_miss_char,
898: fnd_api.g_miss_char,
899: fnd_api.g_miss_char,
900: fnd_api.g_miss_char,
901: fnd_api.g_miss_char,
902: fnd_api.g_miss_num,
903: fnd_api.g_miss_char,
896: x_item.process_manufacturing_obj := inv_ebi_item_processmfg_obj(
897: fnd_api.g_miss_char,
898: fnd_api.g_miss_char,
899: fnd_api.g_miss_char,
900: fnd_api.g_miss_char,
901: fnd_api.g_miss_char,
902: fnd_api.g_miss_num,
903: fnd_api.g_miss_char,
904: fnd_api.g_miss_num,
897: fnd_api.g_miss_char,
898: fnd_api.g_miss_char,
899: fnd_api.g_miss_char,
900: fnd_api.g_miss_char,
901: fnd_api.g_miss_char,
902: fnd_api.g_miss_num,
903: fnd_api.g_miss_char,
904: fnd_api.g_miss_num,
905: fnd_api.g_miss_char,
898: fnd_api.g_miss_char,
899: fnd_api.g_miss_char,
900: fnd_api.g_miss_char,
901: fnd_api.g_miss_char,
902: fnd_api.g_miss_num,
903: fnd_api.g_miss_char,
904: fnd_api.g_miss_num,
905: fnd_api.g_miss_char,
906: fnd_api.g_miss_char
899: fnd_api.g_miss_char,
900: fnd_api.g_miss_char,
901: fnd_api.g_miss_char,
902: fnd_api.g_miss_num,
903: fnd_api.g_miss_char,
904: fnd_api.g_miss_num,
905: fnd_api.g_miss_char,
906: fnd_api.g_miss_char
907: );
900: fnd_api.g_miss_char,
901: fnd_api.g_miss_char,
902: fnd_api.g_miss_num,
903: fnd_api.g_miss_char,
904: fnd_api.g_miss_num,
905: fnd_api.g_miss_char,
906: fnd_api.g_miss_char
907: );
908: END IF;
901: fnd_api.g_miss_char,
902: fnd_api.g_miss_num,
903: fnd_api.g_miss_char,
904: fnd_api.g_miss_num,
905: fnd_api.g_miss_char,
906: fnd_api.g_miss_char
907: );
908: END IF;
909: END initialize_item;
902: fnd_api.g_miss_num,
903: fnd_api.g_miss_char,
904: fnd_api.g_miss_num,
905: fnd_api.g_miss_char,
906: fnd_api.g_miss_char
907: );
908: END IF;
909: END initialize_item;
910: /************************************************************************************
916: p_item_catalog_group_id IN NUMBER
917: ) RETURN VARCHAR IS
918: l_is_new_item_request_reqd VARCHAR2(3);
919: BEGIN
920: IF (p_item_catalog_group_id IS NOT NULL AND p_item_catalog_group_id <> fnd_api.g_miss_num) THEN
921: SELECT new_item_request_reqd INTO l_is_new_item_request_reqd
922: FROM mtl_item_catalog_groups_vl
923: WHERE item_catalog_group_id = p_item_catalog_group_id;
924: IF(l_is_new_item_request_reqd = 'Y') THEN
921: SELECT new_item_request_reqd INTO l_is_new_item_request_reqd
922: FROM mtl_item_catalog_groups_vl
923: WHERE item_catalog_group_id = p_item_catalog_group_id;
924: IF(l_is_new_item_request_reqd = 'Y') THEN
925: RETURN FND_API.g_true;
926: ELSE
927: RETURN FND_API.g_false;
928: END IF;
929: END IF;
923: WHERE item_catalog_group_id = p_item_catalog_group_id;
924: IF(l_is_new_item_request_reqd = 'Y') THEN
925: RETURN FND_API.g_true;
926: ELSE
927: RETURN FND_API.g_false;
928: END IF;
929: END IF;
930: RETURN FND_API.g_false;
931: EXCEPTION
926: ELSE
927: RETURN FND_API.g_false;
928: END IF;
929: END IF;
930: RETURN FND_API.g_false;
931: EXCEPTION
932: WHEN OTHERS THEN
933: RETURN FND_API.g_false;
934: END is_new_item_request_reqd;
929: END IF;
930: RETURN FND_API.g_false;
931: EXCEPTION
932: WHEN OTHERS THEN
933: RETURN FND_API.g_false;
934: END is_new_item_request_reqd;
935: /************************************************************************************
936: -- API name : get_organization_id
937: -- Type : Public
967: AND organization_id = p_organization_id;
968: RETURN l_inventory_item_id;
969: EXCEPTION
970: WHEN OTHERS THEN
971: RETURN FND_API.g_miss_num;
972: END get_inventory_item_id;
973: /************************************************************************************
974: -- API name : get_item_num
975: -- Type : Private
1000: ,p_segment20 IN VARCHAR2
1001: ) RETURN VARCHAR2 IS
1002: l_item_number VARCHAR2(2000);
1003: BEGIN
1004: SELECT DECODE(p_segment1,fnd_api.g_miss_char,'',NULL,'',p_segment1) ||
1005: DECODE(p_segment2,fnd_api.g_miss_char,'',NULL,'',p_segment2) ||
1006: DECODE(p_segment3,fnd_api.g_miss_char,'',NULL,'',p_segment3) ||
1007: DECODE(p_segment4,fnd_api.g_miss_char,'',NULL,'',p_segment4) ||
1008: DECODE(p_segment5,fnd_api.g_miss_char,'',NULL,'',p_segment5) ||
1001: ) RETURN VARCHAR2 IS
1002: l_item_number VARCHAR2(2000);
1003: BEGIN
1004: SELECT DECODE(p_segment1,fnd_api.g_miss_char,'',NULL,'',p_segment1) ||
1005: DECODE(p_segment2,fnd_api.g_miss_char,'',NULL,'',p_segment2) ||
1006: DECODE(p_segment3,fnd_api.g_miss_char,'',NULL,'',p_segment3) ||
1007: DECODE(p_segment4,fnd_api.g_miss_char,'',NULL,'',p_segment4) ||
1008: DECODE(p_segment5,fnd_api.g_miss_char,'',NULL,'',p_segment5) ||
1009: DECODE(p_segment6,fnd_api.g_miss_char,'',NULL,'',p_segment6) ||
1002: l_item_number VARCHAR2(2000);
1003: BEGIN
1004: SELECT DECODE(p_segment1,fnd_api.g_miss_char,'',NULL,'',p_segment1) ||
1005: DECODE(p_segment2,fnd_api.g_miss_char,'',NULL,'',p_segment2) ||
1006: DECODE(p_segment3,fnd_api.g_miss_char,'',NULL,'',p_segment3) ||
1007: DECODE(p_segment4,fnd_api.g_miss_char,'',NULL,'',p_segment4) ||
1008: DECODE(p_segment5,fnd_api.g_miss_char,'',NULL,'',p_segment5) ||
1009: DECODE(p_segment6,fnd_api.g_miss_char,'',NULL,'',p_segment6) ||
1010: DECODE(p_segment7,fnd_api.g_miss_char,'',NULL,'',p_segment7) ||
1003: BEGIN
1004: SELECT DECODE(p_segment1,fnd_api.g_miss_char,'',NULL,'',p_segment1) ||
1005: DECODE(p_segment2,fnd_api.g_miss_char,'',NULL,'',p_segment2) ||
1006: DECODE(p_segment3,fnd_api.g_miss_char,'',NULL,'',p_segment3) ||
1007: DECODE(p_segment4,fnd_api.g_miss_char,'',NULL,'',p_segment4) ||
1008: DECODE(p_segment5,fnd_api.g_miss_char,'',NULL,'',p_segment5) ||
1009: DECODE(p_segment6,fnd_api.g_miss_char,'',NULL,'',p_segment6) ||
1010: DECODE(p_segment7,fnd_api.g_miss_char,'',NULL,'',p_segment7) ||
1011: DECODE(p_segment8,fnd_api.g_miss_char,'',NULL,'',p_segment8) ||
1004: SELECT DECODE(p_segment1,fnd_api.g_miss_char,'',NULL,'',p_segment1) ||
1005: DECODE(p_segment2,fnd_api.g_miss_char,'',NULL,'',p_segment2) ||
1006: DECODE(p_segment3,fnd_api.g_miss_char,'',NULL,'',p_segment3) ||
1007: DECODE(p_segment4,fnd_api.g_miss_char,'',NULL,'',p_segment4) ||
1008: DECODE(p_segment5,fnd_api.g_miss_char,'',NULL,'',p_segment5) ||
1009: DECODE(p_segment6,fnd_api.g_miss_char,'',NULL,'',p_segment6) ||
1010: DECODE(p_segment7,fnd_api.g_miss_char,'',NULL,'',p_segment7) ||
1011: DECODE(p_segment8,fnd_api.g_miss_char,'',NULL,'',p_segment8) ||
1012: DECODE(p_segment9,fnd_api.g_miss_char,'',NULL,'',p_segment9) ||
1005: DECODE(p_segment2,fnd_api.g_miss_char,'',NULL,'',p_segment2) ||
1006: DECODE(p_segment3,fnd_api.g_miss_char,'',NULL,'',p_segment3) ||
1007: DECODE(p_segment4,fnd_api.g_miss_char,'',NULL,'',p_segment4) ||
1008: DECODE(p_segment5,fnd_api.g_miss_char,'',NULL,'',p_segment5) ||
1009: DECODE(p_segment6,fnd_api.g_miss_char,'',NULL,'',p_segment6) ||
1010: DECODE(p_segment7,fnd_api.g_miss_char,'',NULL,'',p_segment7) ||
1011: DECODE(p_segment8,fnd_api.g_miss_char,'',NULL,'',p_segment8) ||
1012: DECODE(p_segment9,fnd_api.g_miss_char,'',NULL,'',p_segment9) ||
1013: DECODE(p_segment10,fnd_api.g_miss_char,'',NULL,'',p_segment10) ||
1006: DECODE(p_segment3,fnd_api.g_miss_char,'',NULL,'',p_segment3) ||
1007: DECODE(p_segment4,fnd_api.g_miss_char,'',NULL,'',p_segment4) ||
1008: DECODE(p_segment5,fnd_api.g_miss_char,'',NULL,'',p_segment5) ||
1009: DECODE(p_segment6,fnd_api.g_miss_char,'',NULL,'',p_segment6) ||
1010: DECODE(p_segment7,fnd_api.g_miss_char,'',NULL,'',p_segment7) ||
1011: DECODE(p_segment8,fnd_api.g_miss_char,'',NULL,'',p_segment8) ||
1012: DECODE(p_segment9,fnd_api.g_miss_char,'',NULL,'',p_segment9) ||
1013: DECODE(p_segment10,fnd_api.g_miss_char,'',NULL,'',p_segment10) ||
1014: DECODE(p_segment11,fnd_api.g_miss_char,'',NULL,'',p_segment11) ||
1007: DECODE(p_segment4,fnd_api.g_miss_char,'',NULL,'',p_segment4) ||
1008: DECODE(p_segment5,fnd_api.g_miss_char,'',NULL,'',p_segment5) ||
1009: DECODE(p_segment6,fnd_api.g_miss_char,'',NULL,'',p_segment6) ||
1010: DECODE(p_segment7,fnd_api.g_miss_char,'',NULL,'',p_segment7) ||
1011: DECODE(p_segment8,fnd_api.g_miss_char,'',NULL,'',p_segment8) ||
1012: DECODE(p_segment9,fnd_api.g_miss_char,'',NULL,'',p_segment9) ||
1013: DECODE(p_segment10,fnd_api.g_miss_char,'',NULL,'',p_segment10) ||
1014: DECODE(p_segment11,fnd_api.g_miss_char,'',NULL,'',p_segment11) ||
1015: DECODE(p_segment12,fnd_api.g_miss_char,'',NULL,'',p_segment12) ||
1008: DECODE(p_segment5,fnd_api.g_miss_char,'',NULL,'',p_segment5) ||
1009: DECODE(p_segment6,fnd_api.g_miss_char,'',NULL,'',p_segment6) ||
1010: DECODE(p_segment7,fnd_api.g_miss_char,'',NULL,'',p_segment7) ||
1011: DECODE(p_segment8,fnd_api.g_miss_char,'',NULL,'',p_segment8) ||
1012: DECODE(p_segment9,fnd_api.g_miss_char,'',NULL,'',p_segment9) ||
1013: DECODE(p_segment10,fnd_api.g_miss_char,'',NULL,'',p_segment10) ||
1014: DECODE(p_segment11,fnd_api.g_miss_char,'',NULL,'',p_segment11) ||
1015: DECODE(p_segment12,fnd_api.g_miss_char,'',NULL,'',p_segment12) ||
1016: DECODE(p_segment13,fnd_api.g_miss_char,'',NULL,'',p_segment13) ||
1009: DECODE(p_segment6,fnd_api.g_miss_char,'',NULL,'',p_segment6) ||
1010: DECODE(p_segment7,fnd_api.g_miss_char,'',NULL,'',p_segment7) ||
1011: DECODE(p_segment8,fnd_api.g_miss_char,'',NULL,'',p_segment8) ||
1012: DECODE(p_segment9,fnd_api.g_miss_char,'',NULL,'',p_segment9) ||
1013: DECODE(p_segment10,fnd_api.g_miss_char,'',NULL,'',p_segment10) ||
1014: DECODE(p_segment11,fnd_api.g_miss_char,'',NULL,'',p_segment11) ||
1015: DECODE(p_segment12,fnd_api.g_miss_char,'',NULL,'',p_segment12) ||
1016: DECODE(p_segment13,fnd_api.g_miss_char,'',NULL,'',p_segment13) ||
1017: DECODE(p_segment14,fnd_api.g_miss_char,'',NULL,'',p_segment14) ||
1010: DECODE(p_segment7,fnd_api.g_miss_char,'',NULL,'',p_segment7) ||
1011: DECODE(p_segment8,fnd_api.g_miss_char,'',NULL,'',p_segment8) ||
1012: DECODE(p_segment9,fnd_api.g_miss_char,'',NULL,'',p_segment9) ||
1013: DECODE(p_segment10,fnd_api.g_miss_char,'',NULL,'',p_segment10) ||
1014: DECODE(p_segment11,fnd_api.g_miss_char,'',NULL,'',p_segment11) ||
1015: DECODE(p_segment12,fnd_api.g_miss_char,'',NULL,'',p_segment12) ||
1016: DECODE(p_segment13,fnd_api.g_miss_char,'',NULL,'',p_segment13) ||
1017: DECODE(p_segment14,fnd_api.g_miss_char,'',NULL,'',p_segment14) ||
1018: DECODE(p_segment15,fnd_api.g_miss_char,'',NULL,'',p_segment15) ||
1011: DECODE(p_segment8,fnd_api.g_miss_char,'',NULL,'',p_segment8) ||
1012: DECODE(p_segment9,fnd_api.g_miss_char,'',NULL,'',p_segment9) ||
1013: DECODE(p_segment10,fnd_api.g_miss_char,'',NULL,'',p_segment10) ||
1014: DECODE(p_segment11,fnd_api.g_miss_char,'',NULL,'',p_segment11) ||
1015: DECODE(p_segment12,fnd_api.g_miss_char,'',NULL,'',p_segment12) ||
1016: DECODE(p_segment13,fnd_api.g_miss_char,'',NULL,'',p_segment13) ||
1017: DECODE(p_segment14,fnd_api.g_miss_char,'',NULL,'',p_segment14) ||
1018: DECODE(p_segment15,fnd_api.g_miss_char,'',NULL,'',p_segment15) ||
1019: DECODE(p_segment16,fnd_api.g_miss_char,'',NULL,'',p_segment16) ||
1012: DECODE(p_segment9,fnd_api.g_miss_char,'',NULL,'',p_segment9) ||
1013: DECODE(p_segment10,fnd_api.g_miss_char,'',NULL,'',p_segment10) ||
1014: DECODE(p_segment11,fnd_api.g_miss_char,'',NULL,'',p_segment11) ||
1015: DECODE(p_segment12,fnd_api.g_miss_char,'',NULL,'',p_segment12) ||
1016: DECODE(p_segment13,fnd_api.g_miss_char,'',NULL,'',p_segment13) ||
1017: DECODE(p_segment14,fnd_api.g_miss_char,'',NULL,'',p_segment14) ||
1018: DECODE(p_segment15,fnd_api.g_miss_char,'',NULL,'',p_segment15) ||
1019: DECODE(p_segment16,fnd_api.g_miss_char,'',NULL,'',p_segment16) ||
1020: DECODE(p_segment17,fnd_api.g_miss_char,'',NULL,'',p_segment17) ||
1013: DECODE(p_segment10,fnd_api.g_miss_char,'',NULL,'',p_segment10) ||
1014: DECODE(p_segment11,fnd_api.g_miss_char,'',NULL,'',p_segment11) ||
1015: DECODE(p_segment12,fnd_api.g_miss_char,'',NULL,'',p_segment12) ||
1016: DECODE(p_segment13,fnd_api.g_miss_char,'',NULL,'',p_segment13) ||
1017: DECODE(p_segment14,fnd_api.g_miss_char,'',NULL,'',p_segment14) ||
1018: DECODE(p_segment15,fnd_api.g_miss_char,'',NULL,'',p_segment15) ||
1019: DECODE(p_segment16,fnd_api.g_miss_char,'',NULL,'',p_segment16) ||
1020: DECODE(p_segment17,fnd_api.g_miss_char,'',NULL,'',p_segment17) ||
1021: DECODE(p_segment18,fnd_api.g_miss_char,'',NULL,'',p_segment18) ||
1014: DECODE(p_segment11,fnd_api.g_miss_char,'',NULL,'',p_segment11) ||
1015: DECODE(p_segment12,fnd_api.g_miss_char,'',NULL,'',p_segment12) ||
1016: DECODE(p_segment13,fnd_api.g_miss_char,'',NULL,'',p_segment13) ||
1017: DECODE(p_segment14,fnd_api.g_miss_char,'',NULL,'',p_segment14) ||
1018: DECODE(p_segment15,fnd_api.g_miss_char,'',NULL,'',p_segment15) ||
1019: DECODE(p_segment16,fnd_api.g_miss_char,'',NULL,'',p_segment16) ||
1020: DECODE(p_segment17,fnd_api.g_miss_char,'',NULL,'',p_segment17) ||
1021: DECODE(p_segment18,fnd_api.g_miss_char,'',NULL,'',p_segment18) ||
1022: DECODE(p_segment19,fnd_api.g_miss_char,'',NULL,'',p_segment19) ||
1015: DECODE(p_segment12,fnd_api.g_miss_char,'',NULL,'',p_segment12) ||
1016: DECODE(p_segment13,fnd_api.g_miss_char,'',NULL,'',p_segment13) ||
1017: DECODE(p_segment14,fnd_api.g_miss_char,'',NULL,'',p_segment14) ||
1018: DECODE(p_segment15,fnd_api.g_miss_char,'',NULL,'',p_segment15) ||
1019: DECODE(p_segment16,fnd_api.g_miss_char,'',NULL,'',p_segment16) ||
1020: DECODE(p_segment17,fnd_api.g_miss_char,'',NULL,'',p_segment17) ||
1021: DECODE(p_segment18,fnd_api.g_miss_char,'',NULL,'',p_segment18) ||
1022: DECODE(p_segment19,fnd_api.g_miss_char,'',NULL,'',p_segment19) ||
1023: DECODE(p_segment20,fnd_api.g_miss_char,'',NULL,'',p_segment20)
1016: DECODE(p_segment13,fnd_api.g_miss_char,'',NULL,'',p_segment13) ||
1017: DECODE(p_segment14,fnd_api.g_miss_char,'',NULL,'',p_segment14) ||
1018: DECODE(p_segment15,fnd_api.g_miss_char,'',NULL,'',p_segment15) ||
1019: DECODE(p_segment16,fnd_api.g_miss_char,'',NULL,'',p_segment16) ||
1020: DECODE(p_segment17,fnd_api.g_miss_char,'',NULL,'',p_segment17) ||
1021: DECODE(p_segment18,fnd_api.g_miss_char,'',NULL,'',p_segment18) ||
1022: DECODE(p_segment19,fnd_api.g_miss_char,'',NULL,'',p_segment19) ||
1023: DECODE(p_segment20,fnd_api.g_miss_char,'',NULL,'',p_segment20)
1024: INTO l_item_number
1017: DECODE(p_segment14,fnd_api.g_miss_char,'',NULL,'',p_segment14) ||
1018: DECODE(p_segment15,fnd_api.g_miss_char,'',NULL,'',p_segment15) ||
1019: DECODE(p_segment16,fnd_api.g_miss_char,'',NULL,'',p_segment16) ||
1020: DECODE(p_segment17,fnd_api.g_miss_char,'',NULL,'',p_segment17) ||
1021: DECODE(p_segment18,fnd_api.g_miss_char,'',NULL,'',p_segment18) ||
1022: DECODE(p_segment19,fnd_api.g_miss_char,'',NULL,'',p_segment19) ||
1023: DECODE(p_segment20,fnd_api.g_miss_char,'',NULL,'',p_segment20)
1024: INTO l_item_number
1025: FROM DUAL;
1018: DECODE(p_segment15,fnd_api.g_miss_char,'',NULL,'',p_segment15) ||
1019: DECODE(p_segment16,fnd_api.g_miss_char,'',NULL,'',p_segment16) ||
1020: DECODE(p_segment17,fnd_api.g_miss_char,'',NULL,'',p_segment17) ||
1021: DECODE(p_segment18,fnd_api.g_miss_char,'',NULL,'',p_segment18) ||
1022: DECODE(p_segment19,fnd_api.g_miss_char,'',NULL,'',p_segment19) ||
1023: DECODE(p_segment20,fnd_api.g_miss_char,'',NULL,'',p_segment20)
1024: INTO l_item_number
1025: FROM DUAL;
1026: RETURN l_item_number;
1019: DECODE(p_segment16,fnd_api.g_miss_char,'',NULL,'',p_segment16) ||
1020: DECODE(p_segment17,fnd_api.g_miss_char,'',NULL,'',p_segment17) ||
1021: DECODE(p_segment18,fnd_api.g_miss_char,'',NULL,'',p_segment18) ||
1022: DECODE(p_segment19,fnd_api.g_miss_char,'',NULL,'',p_segment19) ||
1023: DECODE(p_segment20,fnd_api.g_miss_char,'',NULL,'',p_segment20)
1024: INTO l_item_number
1025: FROM DUAL;
1026: RETURN l_item_number;
1027: EXCEPTION
1041: l_item_flag VARCHAR2(1);
1042: BEGIN
1043: SELECT eng_item_flag INTO l_item_flag
1044: FROM mtl_system_items_kfv
1045: WHERE concatenated_segments = NVL(p_item_number,FND_API.G_MISS_CHAR)
1046: AND organization_id =p_organization_id;
1047: IF(l_item_flag='Y') THEN
1048: RETURN FND_API.g_true;
1049: ELSE
1044: FROM mtl_system_items_kfv
1045: WHERE concatenated_segments = NVL(p_item_number,FND_API.G_MISS_CHAR)
1046: AND organization_id =p_organization_id;
1047: IF(l_item_flag='Y') THEN
1048: RETURN FND_API.g_true;
1049: ELSE
1050: RETURN FND_API.g_false;
1051: END IF;
1052: EXCEPTION
1046: AND organization_id =p_organization_id;
1047: IF(l_item_flag='Y') THEN
1048: RETURN FND_API.g_true;
1049: ELSE
1050: RETURN FND_API.g_false;
1051: END IF;
1052: EXCEPTION
1053: WHEN OTHERS THEN
1054: RETURN FND_API.g_false;
1050: RETURN FND_API.g_false;
1051: END IF;
1052: EXCEPTION
1053: WHEN OTHERS THEN
1054: RETURN FND_API.g_false;
1055: END is_engineering_item;
1056: /************************************************************************************
1057: -- API name : is_item_exists
1058: -- Type : Public
1072: FROM mtl_system_items_kfv
1073: WHERE concatenated_segments = p_item_number
1074: AND organization_id = p_organization_id;
1075: IF(l_item_count=0) THEN
1076: RETURN FND_API.g_false;
1077: ELSE
1078: RETURN FND_API.g_true;
1079: END IF;
1080: EXCEPTION
1074: AND organization_id = p_organization_id;
1075: IF(l_item_count=0) THEN
1076: RETURN FND_API.g_false;
1077: ELSE
1078: RETURN FND_API.g_true;
1079: END IF;
1080: EXCEPTION
1081: WHEN OTHERS THEN
1082: RETURN FND_API.g_false;
1078: RETURN FND_API.g_true;
1079: END IF;
1080: EXCEPTION
1081: WHEN OTHERS THEN
1082: RETURN FND_API.g_false;
1083: END is_item_exists;
1084:
1085: /************************************************************************************
1086: -- API name : is_revision_exists
1110: msi.organization_id = mir.organization_id AND
1111: mir.revision = p_revision;
1112:
1113: IF(l_count=0) THEN
1114: RETURN FND_API.g_false;
1115: ELSE
1116: RETURN FND_API.g_true;
1117: END IF;
1118: EXCEPTION
1112:
1113: IF(l_count=0) THEN
1114: RETURN FND_API.g_false;
1115: ELSE
1116: RETURN FND_API.g_true;
1117: END IF;
1118: EXCEPTION
1119: WHEN OTHERS THEN
1120: RETURN FND_API.g_false;
1116: RETURN FND_API.g_true;
1117: END IF;
1118: EXCEPTION
1119: WHEN OTHERS THEN
1120: RETURN FND_API.g_false;
1121: END is_revision_exists;
1122:
1123:
1124: /************************************************************************************
1162: -- This API is used to
1163: --
1164: ************************************************************************************/
1165: PROCEDURE process_item_pvt(
1166: p_commit IN VARCHAR2 := FND_API.g_false
1167: ,p_operation IN VARCHAR2
1168: ,p_item IN inv_ebi_item_obj
1169: ,x_out OUT NOCOPY inv_ebi_item_output_obj
1170: )
1198: BEGIN
1199: SAVEPOINT inv_ebi_pvt_item_save_pnt;
1200: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.process_item_pvt ');
1201: l_item := p_item;
1202: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1203: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
1204: l_item_number := l_item.main_obj_type.item_number;
1205: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
1206: IF(l_item_number IS NULL OR l_item_number = fnd_api.g_miss_char) THEN
1202: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1203: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
1204: l_item_number := l_item.main_obj_type.item_number;
1205: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
1206: IF(l_item_number IS NULL OR l_item_number = fnd_api.g_miss_char) THEN
1207: l_item_number := get_item_num(
1208: p_segment1 => l_item.main_obj_type.segment1
1209: ,p_segment2 => l_item.main_obj_type.segment2
1210: ,p_segment3 => l_item.main_obj_type.segment3
1229: END IF;
1230: IF l_item_number IS NULL THEN
1231: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NUM_NULL');
1232: FND_MSG_PUB.add;
1233: RAISE FND_API.g_exc_error;
1234: END IF;
1235: IF p_operation = INV_EBI_ITEM_PUB.g_otype_sync THEN
1236: IF( is_item_exists (
1237: p_organization_id => l_item.main_obj_type.organization_id
1235: IF p_operation = INV_EBI_ITEM_PUB.g_otype_sync THEN
1236: IF( is_item_exists (
1237: p_organization_id => l_item.main_obj_type.organization_id
1238: ,p_item_number => l_item_number
1239: ) = FND_API.g_true ) THEN
1240: l_transaction_type := INV_EBI_ITEM_PUB.g_otype_update;
1241: ELSE
1242: l_transaction_type := INV_EBI_ITEM_PUB.g_otype_create;
1243: l_item.main_obj_type.item_number := l_item_number;
1251: l_validate_revised_itm_rev := INV_EBI_UTIL.get_config_param_value(
1252: p_config_tbl => l_item.name_value_tbl
1253: ,p_config_param_name => 'VALIDATE_REVISED_ITEM_REVISION'
1254: );
1255: IF (l_validate_revised_itm_rev = fnd_api.g_true ) AND (l_item.main_obj_type.revision_code IS NOT NULL)
1256: AND (l_item.main_obj_type.revision_code <> fnd_api.g_miss_char)
1257: AND ( is_item_exists (
1258: p_organization_id => l_item.main_obj_type.organization_id
1259: ,p_item_number => l_item_number
1252: p_config_tbl => l_item.name_value_tbl
1253: ,p_config_param_name => 'VALIDATE_REVISED_ITEM_REVISION'
1254: );
1255: IF (l_validate_revised_itm_rev = fnd_api.g_true ) AND (l_item.main_obj_type.revision_code IS NOT NULL)
1256: AND (l_item.main_obj_type.revision_code <> fnd_api.g_miss_char)
1257: AND ( is_item_exists (
1258: p_organization_id => l_item.main_obj_type.organization_id
1259: ,p_item_number => l_item_number
1260: ) = FND_API.g_true )
1256: AND (l_item.main_obj_type.revision_code <> fnd_api.g_miss_char)
1257: AND ( is_item_exists (
1258: p_organization_id => l_item.main_obj_type.organization_id
1259: ,p_item_number => l_item_number
1260: ) = FND_API.g_true )
1261: THEN
1262: IF( l_item.main_obj_type.inventory_item_id IS NULL) THEN
1263: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
1264: l_pk_col_name_val_pairs.EXTEND(2);
1290: FND_MESSAGE.set_token('ITEM_NUMBER', l_item_number);
1291: FND_MESSAGE.set_token('REVISION_CODE',l_item.main_obj_type.revision_code);
1292: FND_MESSAGE.set_token('ORG_CODE',l_item.main_obj_type.organization_code);
1293: FND_MSG_PUB.add;
1294: RAISE FND_API.g_exc_error;
1295: END IF;
1296: END IF;
1297: IF (l_item.main_obj_type.template_id IS NULL AND l_item.main_obj_type.template_name IS NULL AND
1298: l_item.main_obj_type.item_catalog_group_id IS NOT NULL AND l_item.main_obj_type.item_catalog_group_id <> fnd_api.g_miss_num) THEN
1294: RAISE FND_API.g_exc_error;
1295: END IF;
1296: END IF;
1297: IF (l_item.main_obj_type.template_id IS NULL AND l_item.main_obj_type.template_name IS NULL AND
1298: l_item.main_obj_type.item_catalog_group_id IS NOT NULL AND l_item.main_obj_type.item_catalog_group_id <> fnd_api.g_miss_num) THEN
1299: SELECT default_template_id INTO l_item.main_obj_type.template_id
1300: FROM ego_catalog_groups_v T
1301: WHERE catalog_group_id = l_item.main_obj_type.item_catalog_group_id;
1302: END IF;
1299: SELECT default_template_id INTO l_item.main_obj_type.template_id
1300: FROM ego_catalog_groups_v T
1301: WHERE catalog_group_id = l_item.main_obj_type.item_catalog_group_id;
1302: END IF;
1303: IF ((l_item.main_obj_type.apply_template IS NULL OR l_item.main_obj_type.apply_template = fnd_api.g_miss_char) AND (l_item.main_obj_type.template_id IS NOT NULL OR l_item.main_obj_type.template_name IS NOT NULL)) THEN
1304: l_item.main_obj_type.apply_template :='ALL';
1305: END IF;
1306: IF(l_transaction_type = INV_EBI_ITEM_PUB.g_otype_create AND l_item.main_obj_type.description IS NULL OR l_item.main_obj_type.description = fnd_api.g_miss_char) THEN
1307: IF(l_item.main_obj_type.item_catalog_group_id IS NOT NULL AND l_item.main_obj_type.item_catalog_group_id <> fnd_api.g_miss_num) THEN
1302: END IF;
1303: IF ((l_item.main_obj_type.apply_template IS NULL OR l_item.main_obj_type.apply_template = fnd_api.g_miss_char) AND (l_item.main_obj_type.template_id IS NOT NULL OR l_item.main_obj_type.template_name IS NOT NULL)) THEN
1304: l_item.main_obj_type.apply_template :='ALL';
1305: END IF;
1306: IF(l_transaction_type = INV_EBI_ITEM_PUB.g_otype_create AND l_item.main_obj_type.description IS NULL OR l_item.main_obj_type.description = fnd_api.g_miss_char) THEN
1307: IF(l_item.main_obj_type.item_catalog_group_id IS NOT NULL AND l_item.main_obj_type.item_catalog_group_id <> fnd_api.g_miss_num) THEN
1308: l_item_desc_gen_method := get_desc_gen_method(l_item.main_obj_type.item_catalog_group_id);
1309: END IF;
1310: IF(l_item_desc_gen_method = 'U' OR l_item_desc_gen_method IS NULL OR l_item.main_obj_type.item_catalog_group_id IS NULL OR l_item.main_obj_type.item_catalog_group_id = fnd_api.g_miss_num) THEN
1303: IF ((l_item.main_obj_type.apply_template IS NULL OR l_item.main_obj_type.apply_template = fnd_api.g_miss_char) AND (l_item.main_obj_type.template_id IS NOT NULL OR l_item.main_obj_type.template_name IS NOT NULL)) THEN
1304: l_item.main_obj_type.apply_template :='ALL';
1305: END IF;
1306: IF(l_transaction_type = INV_EBI_ITEM_PUB.g_otype_create AND l_item.main_obj_type.description IS NULL OR l_item.main_obj_type.description = fnd_api.g_miss_char) THEN
1307: IF(l_item.main_obj_type.item_catalog_group_id IS NOT NULL AND l_item.main_obj_type.item_catalog_group_id <> fnd_api.g_miss_num) THEN
1308: l_item_desc_gen_method := get_desc_gen_method(l_item.main_obj_type.item_catalog_group_id);
1309: END IF;
1310: IF(l_item_desc_gen_method = 'U' OR l_item_desc_gen_method IS NULL OR l_item.main_obj_type.item_catalog_group_id IS NULL OR l_item.main_obj_type.item_catalog_group_id = fnd_api.g_miss_num) THEN
1311: l_is_master_org := INV_EBI_UTIL.is_master_org(l_item.main_obj_type.organization_id);
1306: IF(l_transaction_type = INV_EBI_ITEM_PUB.g_otype_create AND l_item.main_obj_type.description IS NULL OR l_item.main_obj_type.description = fnd_api.g_miss_char) THEN
1307: IF(l_item.main_obj_type.item_catalog_group_id IS NOT NULL AND l_item.main_obj_type.item_catalog_group_id <> fnd_api.g_miss_num) THEN
1308: l_item_desc_gen_method := get_desc_gen_method(l_item.main_obj_type.item_catalog_group_id);
1309: END IF;
1310: IF(l_item_desc_gen_method = 'U' OR l_item_desc_gen_method IS NULL OR l_item.main_obj_type.item_catalog_group_id IS NULL OR l_item.main_obj_type.item_catalog_group_id = fnd_api.g_miss_num) THEN
1311: l_is_master_org := INV_EBI_UTIL.is_master_org(l_item.main_obj_type.organization_id);
1312: IF(l_is_master_org = fnd_api.g_true) THEN
1313: l_item.main_obj_type.description := l_item_number;
1314: ELSE
1308: l_item_desc_gen_method := get_desc_gen_method(l_item.main_obj_type.item_catalog_group_id);
1309: END IF;
1310: IF(l_item_desc_gen_method = 'U' OR l_item_desc_gen_method IS NULL OR l_item.main_obj_type.item_catalog_group_id IS NULL OR l_item.main_obj_type.item_catalog_group_id = fnd_api.g_miss_num) THEN
1311: l_is_master_org := INV_EBI_UTIL.is_master_org(l_item.main_obj_type.organization_id);
1312: IF(l_is_master_org = fnd_api.g_true) THEN
1313: l_item.main_obj_type.description := l_item_number;
1314: ELSE
1315: l_master_org := INV_EBI_UTIL.get_master_organization(
1316: p_organization_id => l_item.main_obj_type.organization_id
1323: IF(c_item_description%NOTFOUND) THEN
1324: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NO_MASTER_ORG');
1325: FND_MESSAGE.set_token('ITEM_NUMBER', l_item_number);
1326: FND_MSG_PUB.add;
1327: RAISE FND_API.g_exc_error;
1328: END IF;
1329: l_item.main_obj_type.description := l_description;
1330: CLOSE c_item_description;
1331: END IF;
1329: l_item.main_obj_type.description := l_description;
1330: CLOSE c_item_description;
1331: END IF;
1332: END IF;
1333: IF(l_item.bom_obj_type.eng_item_flag = fnd_api.g_miss_char OR l_item.bom_obj_type.eng_item_flag IS NULL ) THEN
1334: l_is_new_item_request_reqd := is_new_item_request_reqd(
1335: p_item_catalog_group_id => l_item.main_obj_type.item_catalog_group_id
1336: );
1337: IF(l_is_new_item_request_reqd = fnd_api.g_false) THEN
1333: IF(l_item.bom_obj_type.eng_item_flag = fnd_api.g_miss_char OR l_item.bom_obj_type.eng_item_flag IS NULL ) THEN
1334: l_is_new_item_request_reqd := is_new_item_request_reqd(
1335: p_item_catalog_group_id => l_item.main_obj_type.item_catalog_group_id
1336: );
1337: IF(l_is_new_item_request_reqd = fnd_api.g_false) THEN
1338: l_item.bom_obj_type.eng_item_flag := 'N';
1339: END IF;
1340: END IF;
1341: END IF;
1346: l_apply_template_update := INV_EBI_UTIL.get_config_param_value(
1347: p_config_tbl => l_item.name_value_tbl
1348: ,p_config_param_name => 'TEMPLATE_FOR_ITEM_UPDATE_ALLOWED'
1349: );
1350: IF( UPPER(l_apply_template_update ) = fnd_api.g_false ) THEN
1351: l_item.main_obj_type.template_id := fnd_api.g_miss_num;
1352: l_item.main_obj_type.template_name := fnd_api.g_miss_char;
1353: END IF;
1354:
1347: p_config_tbl => l_item.name_value_tbl
1348: ,p_config_param_name => 'TEMPLATE_FOR_ITEM_UPDATE_ALLOWED'
1349: );
1350: IF( UPPER(l_apply_template_update ) = fnd_api.g_false ) THEN
1351: l_item.main_obj_type.template_id := fnd_api.g_miss_num;
1352: l_item.main_obj_type.template_name := fnd_api.g_miss_char;
1353: END IF;
1354:
1355: --Bug 7601514 : To create new revision coming in while updating item only if incoming revision is not null
1348: ,p_config_param_name => 'TEMPLATE_FOR_ITEM_UPDATE_ALLOWED'
1349: );
1350: IF( UPPER(l_apply_template_update ) = fnd_api.g_false ) THEN
1351: l_item.main_obj_type.template_id := fnd_api.g_miss_num;
1352: l_item.main_obj_type.template_name := fnd_api.g_miss_char;
1353: END IF;
1354:
1355: --Bug 7601514 : To create new revision coming in while updating item only if incoming revision is not null
1356: IF(l_item.main_obj_type.revision_code IS NOT NULL AND l_item.main_obj_type.revision_code <> fnd_api.g_miss_char) THEN
1352: l_item.main_obj_type.template_name := fnd_api.g_miss_char;
1353: END IF;
1354:
1355: --Bug 7601514 : To create new revision coming in while updating item only if incoming revision is not null
1356: IF(l_item.main_obj_type.revision_code IS NOT NULL AND l_item.main_obj_type.revision_code <> fnd_api.g_miss_char) THEN
1357: --Bug 7412466 : To create new revision coming in while updating item
1358: IF( is_revision_exists (p_organization_id => l_item.main_obj_type.organization_id
1359: ,p_item_number => l_item.main_obj_type.item_number
1360: ,p_revision => l_item.main_obj_type.revision_code
1357: --Bug 7412466 : To create new revision coming in while updating item
1358: IF( is_revision_exists (p_organization_id => l_item.main_obj_type.organization_id
1359: ,p_item_number => l_item.main_obj_type.item_number
1360: ,p_revision => l_item.main_obj_type.revision_code
1361: ) = FND_API.g_false ) THEN
1362: IF( l_item.main_obj_type.effectivity_date IS NULL OR
1363: l_item.main_obj_type.effectivity_date = fnd_api.g_miss_date ) THEN
1364: l_effectivity_date := SYSDATE;
1365: ELSE
1359: ,p_item_number => l_item.main_obj_type.item_number
1360: ,p_revision => l_item.main_obj_type.revision_code
1361: ) = FND_API.g_false ) THEN
1362: IF( l_item.main_obj_type.effectivity_date IS NULL OR
1363: l_item.main_obj_type.effectivity_date = fnd_api.g_miss_date ) THEN
1364: l_effectivity_date := SYSDATE;
1365: ELSE
1366: l_effectivity_date := l_item.main_obj_type.effectivity_date;
1367: END IF;
1366: l_effectivity_date := l_item.main_obj_type.effectivity_date;
1367: END IF;
1368: EGO_ITEM_PUB.Process_Item_Revision(
1369: p_api_version => 1.0
1370: ,p_init_msg_list => FND_API.g_false
1371: ,p_commit => FND_API.g_false
1372: ,p_transaction_type => INV_EBI_ITEM_PUB.g_otype_create
1373: ,p_inventory_item_id => l_item.main_obj_type.inventory_item_id
1374: ,p_item_number => l_item.main_obj_type.item_number
1367: END IF;
1368: EGO_ITEM_PUB.Process_Item_Revision(
1369: p_api_version => 1.0
1370: ,p_init_msg_list => FND_API.g_false
1371: ,p_commit => FND_API.g_false
1372: ,p_transaction_type => INV_EBI_ITEM_PUB.g_otype_create
1373: ,p_inventory_item_id => l_item.main_obj_type.inventory_item_id
1374: ,p_item_number => l_item.main_obj_type.item_number
1375: ,p_organization_id => l_item.main_obj_type.organization_id
1402: ,x_return_status => x_out.output_status.return_status
1403: ,x_msg_count => x_out.output_status.msg_count
1404: ,x_msg_data => x_out.output_status.msg_data
1405: );
1406: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
1407: RAISE FND_API.g_exc_unexpected_error;
1408: END IF;
1409: END IF; -- Bug 7412466
1410: END IF; -- End of Bug 7601514
1403: ,x_msg_count => x_out.output_status.msg_count
1404: ,x_msg_data => x_out.output_status.msg_data
1405: );
1406: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
1407: RAISE FND_API.g_exc_unexpected_error;
1408: END IF;
1409: END IF; -- Bug 7412466
1410: END IF; -- End of Bug 7601514
1411: END IF;
1413: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING EGO_ITEM_PUB.process_item ');
1414: EGO_ITEM_PUB.process_item(
1415: p_api_version => 1.0
1416: ,p_init_msg_list => l_item.main_obj_type.init_msg_list
1417: ,p_commit => FND_API.g_false
1418: ,p_transaction_type => l_transaction_type
1419: ,p_language_code => l_item.main_obj_type.language_code
1420: ,p_template_id => l_item.main_obj_type.template_id
1421: ,p_template_name => l_item.main_obj_type.template_name
1834: ,p_outsourced_assembly => l_item.purchasing_obj_type.outsourced_assembly
1835: );
1836: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING EGO_ITEM_PUB.process_item ');
1837:
1838: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
1839: RAISE FND_API.g_exc_unexpected_error;
1840: END IF;
1841: l_pk_col_name_val_pairs.EXTEND(1);
1842: l_pk_col_name_val_pairs(1).name := 'organization_id';
1835: );
1836: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING EGO_ITEM_PUB.process_item ');
1837:
1838: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
1839: RAISE FND_API.g_exc_unexpected_error;
1840: END IF;
1841: l_pk_col_name_val_pairs.EXTEND(1);
1842: l_pk_col_name_val_pairs(1).name := 'organization_id';
1843: l_pk_col_name_val_pairs(1).value := l_item.main_obj_type.organization_id;
1898: p_program_id => NULL,
1899: p_program_update_date => SYSDATE,
1900: x_cross_reference_id => l_xref_id);
1901: END IF;
1902: IF FND_API.to_boolean( p_commit ) THEN
1903: COMMIT;
1904: END IF;
1905: INV_EBI_UTIL.debug_line('STEP: 40 '||'END INSIDE INV_EBI_ITEM_HELPER.process_item_pvt ');
1906: EXCEPTION
1903: COMMIT;
1904: END IF;
1905: INV_EBI_UTIL.debug_line('STEP: 40 '||'END INSIDE INV_EBI_ITEM_HELPER.process_item_pvt ');
1906: EXCEPTION
1907: WHEN FND_API.g_exc_error THEN
1908: ROLLBACK TO inv_ebi_pvt_item_save_pnt;
1909: x_out.output_status.return_status := FND_API.g_ret_sts_error;
1910: IF(x_out.output_status.msg_data IS NULL) THEN
1911: fnd_msg_pub.count_and_get(
1905: INV_EBI_UTIL.debug_line('STEP: 40 '||'END INSIDE INV_EBI_ITEM_HELPER.process_item_pvt ');
1906: EXCEPTION
1907: WHEN FND_API.g_exc_error THEN
1908: ROLLBACK TO inv_ebi_pvt_item_save_pnt;
1909: x_out.output_status.return_status := FND_API.g_ret_sts_error;
1910: IF(x_out.output_status.msg_data IS NULL) THEN
1911: fnd_msg_pub.count_and_get(
1912: p_encoded => fnd_api.g_false
1913: ,p_count => x_out.output_status.msg_count
1908: ROLLBACK TO inv_ebi_pvt_item_save_pnt;
1909: x_out.output_status.return_status := FND_API.g_ret_sts_error;
1910: IF(x_out.output_status.msg_data IS NULL) THEN
1911: fnd_msg_pub.count_and_get(
1912: p_encoded => fnd_api.g_false
1913: ,p_count => x_out.output_status.msg_count
1914: ,p_data => x_out.output_status.msg_data
1915: );
1916: END IF;
1913: ,p_count => x_out.output_status.msg_count
1914: ,p_data => x_out.output_status.msg_data
1915: );
1916: END IF;
1917: WHEN FND_API.g_exc_unexpected_error THEN
1918: ROLLBACK TO inv_ebi_pvt_item_save_pnt;
1919: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1920: IF(x_out.output_status.msg_data IS NULL) THEN
1921: fnd_msg_pub.count_and_get(
1915: );
1916: END IF;
1917: WHEN FND_API.g_exc_unexpected_error THEN
1918: ROLLBACK TO inv_ebi_pvt_item_save_pnt;
1919: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1920: IF(x_out.output_status.msg_data IS NULL) THEN
1921: fnd_msg_pub.count_and_get(
1922: p_encoded => fnd_api.g_false
1923: ,p_count => x_out.output_status.msg_count
1918: ROLLBACK TO inv_ebi_pvt_item_save_pnt;
1919: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1920: IF(x_out.output_status.msg_data IS NULL) THEN
1921: fnd_msg_pub.count_and_get(
1922: p_encoded => fnd_api.g_false
1923: ,p_count => x_out.output_status.msg_count
1924: ,p_data => x_out.output_status.msg_data
1925: );
1926: END IF;
1925: );
1926: END IF;
1927: WHEN OTHERS THEN
1928: ROLLBACK TO inv_ebi_pvt_item_save_pnt;
1929: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1930: IF (x_out.output_status.msg_data IS NOT NULL) THEN
1931: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_ITEM_HELPER.process_item_pvt ';
1932: ELSE
1933: x_out.output_status.msg_data := SQLERRM||' INV_EBI_ITEM_HELPER.process_item_pvt ';
1946: ,p_item_catalog_group_id IN NUMBER DEFAULT NULL
1947: ,p_revision_id IN NUMBER DEFAULT NULL
1948: ,p_revision_code IN VARCHAR2 DEFAULT NULL
1949: ,p_uda_input_obj IN inv_ebi_uda_input_obj
1950: ,p_commit IN VARCHAR2 := fnd_api.g_false
1951: ,x_uda_output_obj OUT NOCOPY inv_ebi_item_output_obj
1952: )
1953: IS
1954: l_uda_out inv_ebi_uda_output_obj;
1961: l_output_status inv_ebi_output_status;
1962: BEGIN
1963: SAVEPOINT inv_ebi_item_uda_save_pnt;
1964: l_uda_out := inv_ebi_uda_output_obj(NULL,NULL);
1965: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1966: x_uda_output_obj := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,l_uda_out,NULL,NULL,NULL,NULL);
1967: INV_EBI_UTIL.transform_uda (
1968: p_uda_input_obj => p_uda_input_obj
1969: ,x_attributes_row_table => l_attributes_row_table
1972: ,x_msg_count => x_uda_output_obj.output_status.msg_count
1973: ,x_msg_data => x_uda_output_obj.output_status.msg_data
1974: );
1975:
1976: IF (x_uda_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN
1977: RAISE FND_API.g_exc_unexpected_error;
1978: END IF;
1979: FOR i in 1..l_attributes_row_table.COUNT
1980: LOOP
1973: ,x_msg_data => x_uda_output_obj.output_status.msg_data
1974: );
1975:
1976: IF (x_uda_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN
1977: RAISE FND_API.g_exc_unexpected_error;
1978: END IF;
1979: FOR i in 1..l_attributes_row_table.COUNT
1980: LOOP
1981: l_attributes_row_obj := l_attributes_row_table(i);
1986: AND classification_code = TO_CHAR(p_item_catalog_group_id);
1987: END IF;
1988: IF (l_data_level = INV_EBI_ITEM_PUB.g_data_level_item_rev ) THEN
1989:
1990: IF p_revision_code IS NOT NULL AND p_revision_code <> fnd_api.g_miss_char THEN
1991: SELECT revision_id INTO l_revision_id
1992: FROM mtl_item_revisions
1993: WHERE inventory_item_id = p_inventory_item_id
1994: AND organization_id = p_organization_id
1995: AND revision = p_revision_code;
1996: ELSE
1997: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_REVISION_CODE_NULL');
1998: FND_MSG_PUB.add;
1999: RAISE FND_API.g_exc_error;
2000: END IF;
2001: ELSE
2002: l_revision_id := l_attributes_row_obj.data_level_1;
2003: END IF;
2036: ,p_write_to_concurrent_log => p_uda_input_obj.write_to_concurrent_log
2037: ,p_init_fnd_msg_list => p_uda_input_obj.init_fnd_msg_list
2038: ,p_log_errors => p_uda_input_obj.log_errors
2039: ,p_add_errors_to_fnd_stack => p_uda_input_obj.add_errors_to_fnd_stack
2040: ,p_commit => FND_API.g_false
2041: ,x_failed_row_id_list => x_uda_output_obj.uda_output.failed_row_id_list
2042: ,x_return_status => x_uda_output_obj.output_status.return_status
2043: ,x_errorcode => x_uda_output_obj.uda_output.errorcode
2044: ,x_msg_count => x_uda_output_obj.output_status.msg_count
2044: ,x_msg_count => x_uda_output_obj.output_status.msg_count
2045: ,x_msg_data => x_uda_output_obj.output_status.msg_data
2046: );
2047:
2048: IF (x_uda_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2049: RAISE FND_API.g_exc_unexpected_error;
2050: END IF;
2051: IF FND_API.to_boolean(p_commit) THEN
2052: COMMIT;
2045: ,x_msg_data => x_uda_output_obj.output_status.msg_data
2046: );
2047:
2048: IF (x_uda_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2049: RAISE FND_API.g_exc_unexpected_error;
2050: END IF;
2051: IF FND_API.to_boolean(p_commit) THEN
2052: COMMIT;
2053: END IF;
2047:
2048: IF (x_uda_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2049: RAISE FND_API.g_exc_unexpected_error;
2050: END IF;
2051: IF FND_API.to_boolean(p_commit) THEN
2052: COMMIT;
2053: END IF;
2054: EXCEPTION
2055: WHEN FND_API.g_exc_error THEN
2051: IF FND_API.to_boolean(p_commit) THEN
2052: COMMIT;
2053: END IF;
2054: EXCEPTION
2055: WHEN FND_API.g_exc_error THEN
2056: ROLLBACK TO inv_ebi_item_uda_save_pnt;
2057: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_error;
2058: IF(x_uda_output_obj.output_status.msg_data IS NULL) THEN
2059: FND_MSG_PUB.count_and_get(
2053: END IF;
2054: EXCEPTION
2055: WHEN FND_API.g_exc_error THEN
2056: ROLLBACK TO inv_ebi_item_uda_save_pnt;
2057: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_error;
2058: IF(x_uda_output_obj.output_status.msg_data IS NULL) THEN
2059: FND_MSG_PUB.count_and_get(
2060: p_encoded => FND_API.g_false
2061: ,p_count => x_uda_output_obj.output_status.msg_count
2056: ROLLBACK TO inv_ebi_item_uda_save_pnt;
2057: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_error;
2058: IF(x_uda_output_obj.output_status.msg_data IS NULL) THEN
2059: FND_MSG_PUB.count_and_get(
2060: p_encoded => FND_API.g_false
2061: ,p_count => x_uda_output_obj.output_status.msg_count
2062: ,p_data => x_uda_output_obj.output_status.msg_data
2063: );
2064: END IF;
2061: ,p_count => x_uda_output_obj.output_status.msg_count
2062: ,p_data => x_uda_output_obj.output_status.msg_data
2063: );
2064: END IF;
2065: WHEN FND_API.g_exc_unexpected_error THEN
2066: ROLLBACK TO inv_ebi_item_uda_save_pnt;
2067: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2068: IF(x_uda_output_obj.output_status.msg_data IS NULL) THEN
2069: FND_MSG_PUB.count_and_get(
2063: );
2064: END IF;
2065: WHEN FND_API.g_exc_unexpected_error THEN
2066: ROLLBACK TO inv_ebi_item_uda_save_pnt;
2067: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2068: IF(x_uda_output_obj.output_status.msg_data IS NULL) THEN
2069: FND_MSG_PUB.count_and_get(
2070: p_encoded => FND_API.g_false
2071: ,p_count => x_uda_output_obj.output_status.msg_count
2066: ROLLBACK TO inv_ebi_item_uda_save_pnt;
2067: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2068: IF(x_uda_output_obj.output_status.msg_data IS NULL) THEN
2069: FND_MSG_PUB.count_and_get(
2070: p_encoded => FND_API.g_false
2071: ,p_count => x_uda_output_obj.output_status.msg_count
2072: ,p_data => x_uda_output_obj.output_status.msg_data
2073: );
2074: END IF;
2073: );
2074: END IF;
2075: WHEN OTHERS THEN
2076: ROLLBACK TO inv_ebi_item_uda_save_pnt;
2077: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2078: IF (x_uda_output_obj.output_status.msg_data IS NOT NULL) THEN
2079: x_uda_output_obj.output_status.msg_data := x_uda_output_obj.output_status.msg_data ||' -> INV_EBI_ITEM_HELPER.process_item_uda ';
2080: ELSE
2081: x_uda_output_obj.output_status.msg_data := SQLERRM||' at INV_EBI_ITEM_HELPER.process_item_uda ';
2087: -- Function :
2088: -- ************************************************************************************/
2089: PROCEDURE process_org_id_assignments(
2090: p_init_msg_list IN VARCHAR2
2091: ,p_commit IN VARCHAR2 := fnd_api.g_false
2092: ,p_inventory_item_id IN NUMBER
2093: ,p_item_number IN VARCHAR2
2094: ,p_org_id_tbl IN inv_ebi_org_tbl
2095: ,x_out OUT NOCOPY inv_ebi_item_output_obj
2102: l_item_org_tbl_count NUMBER := 1;
2103: BEGIN
2104: SAVEPOINT inv_ebi_org_id_save_pnt;
2105: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.process_org_id_assignments ');
2106: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2107: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
2108: IF p_org_id_tbl.COUNT > 0 THEN
2109: FOR i IN 1..p_org_id_tbl.COUNT LOOP
2110: l_item_org_assignment_rec.inventory_item_id := p_inventory_item_id;
2115: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING EGO_ITEM_PUB.process_item_org_assignments ');
2116: EGO_ITEM_PUB.process_item_org_assignments(
2117: p_api_version => l_api_version --don't pass as of now
2118: ,p_init_msg_list => p_init_msg_list
2119: ,p_commit => FND_API.g_false
2120: ,p_item_org_assignment_tbl => l_item_org_assignment_tbl
2121: ,x_return_status => x_out.output_status.return_status
2122: ,x_msg_count => x_out.output_status.msg_count
2123: );
2121: ,x_return_status => x_out.output_status.return_status
2122: ,x_msg_count => x_out.output_status.msg_count
2123: );
2124: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING EGO_ITEM_PUB.process_item_org_assignments ');
2125: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2126: RAISE FND_API.g_exc_unexpected_error;
2127: END IF;
2128: END IF;
2129: IF FND_API.to_boolean( p_commit ) THEN
2122: ,x_msg_count => x_out.output_status.msg_count
2123: );
2124: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING EGO_ITEM_PUB.process_item_org_assignments ');
2125: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2126: RAISE FND_API.g_exc_unexpected_error;
2127: END IF;
2128: END IF;
2129: IF FND_API.to_boolean( p_commit ) THEN
2130: COMMIT;
2125: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2126: RAISE FND_API.g_exc_unexpected_error;
2127: END IF;
2128: END IF;
2129: IF FND_API.to_boolean( p_commit ) THEN
2130: COMMIT;
2131: END IF;
2132: INV_EBI_UTIL.debug_line('STEP: 40 '||'END INSIDE INV_EBI_ITEM_HELPER.process_org_id_assignments ');
2133: EXCEPTION
2130: COMMIT;
2131: END IF;
2132: INV_EBI_UTIL.debug_line('STEP: 40 '||'END INSIDE INV_EBI_ITEM_HELPER.process_org_id_assignments ');
2133: EXCEPTION
2134: WHEN FND_API.g_exc_unexpected_error THEN
2135: ROLLBACK TO inv_ebi_org_id_save_pnt;
2136: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2137: IF(x_out.output_status.msg_data IS NULL) THEN
2138: FND_MSG_PUB.count_and_get(
2132: INV_EBI_UTIL.debug_line('STEP: 40 '||'END INSIDE INV_EBI_ITEM_HELPER.process_org_id_assignments ');
2133: EXCEPTION
2134: WHEN FND_API.g_exc_unexpected_error THEN
2135: ROLLBACK TO inv_ebi_org_id_save_pnt;
2136: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2137: IF(x_out.output_status.msg_data IS NULL) THEN
2138: FND_MSG_PUB.count_and_get(
2139: p_encoded => FND_API.g_false
2140: ,p_count => x_out.output_status.msg_count
2135: ROLLBACK TO inv_ebi_org_id_save_pnt;
2136: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2137: IF(x_out.output_status.msg_data IS NULL) THEN
2138: FND_MSG_PUB.count_and_get(
2139: p_encoded => FND_API.g_false
2140: ,p_count => x_out.output_status.msg_count
2141: ,p_data => x_out.output_status.msg_data
2142: );
2143: END IF;
2142: );
2143: END IF;
2144: WHEN OTHERS THEN
2145: ROLLBACK TO inv_ebi_org_id_save_pnt;
2146: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2147: IF (x_out.output_status.msg_data IS NOT NULL) THEN
2148: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_ITEM_HELPER.process_org_id_assignments ';
2149: ELSE
2150: x_out.output_status.msg_data := SQLERRM||' INV_EBI_ITEM_HELPER.process_org_id_assignments ';
2158: ************************************************************************************/
2159: PROCEDURE process_category_assignments(
2160: p_api_version IN NUMBER DEFAULT 1.0
2161: ,p_init_msg_list IN VARCHAR2
2162: ,p_commit IN VARCHAR2 := fnd_api.g_false
2163: ,p_inventory_item_id IN NUMBER
2164: ,p_organization_id IN NUMBER
2165: ,p_category_id_tbl IN inv_ebi_category_obj_tbl_type
2166: ,x_out OUT NOCOPY inv_ebi_item_output_obj
2172: BEGIN
2173: SAVEPOINT inv_ebi_cat_id_save_pnt;
2174: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.process_category_assignments ');
2175: l_category_output := inv_ebi_category_output_obj(NULL);
2176: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2177: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,l_category_output,NULL,NULL,NULL);
2178: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING EGO_ITEM_PUB.process_item_cat_assignment ');
2179: FOR i IN 1..p_category_id_tbl.COUNT LOOP
2180: EGO_ITEM_PUB.process_item_cat_assignment(
2179: FOR i IN 1..p_category_id_tbl.COUNT LOOP
2180: EGO_ITEM_PUB.process_item_cat_assignment(
2181: p_api_version => p_api_version
2182: ,p_init_msg_list => p_init_msg_list
2183: ,p_commit => FND_API.g_false
2184: ,p_category_id => p_category_id_tbl(i).cat_id
2185: ,p_category_set_id => p_category_id_tbl(i).cat_set_id
2186: ,p_inventory_item_id => p_inventory_item_id
2187: ,p_organization_id => p_organization_id
2192: ,x_msg_data => x_out.output_status.msg_data
2193: );
2194: END LOOP;
2195: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING EGO_ITEM_PUB.process_item_cat_assignment ');
2196: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2197: RAISE FND_API.g_exc_unexpected_error;
2198: END IF;
2199: IF FND_API.to_boolean( p_commit ) THEN
2200: COMMIT;
2193: );
2194: END LOOP;
2195: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING EGO_ITEM_PUB.process_item_cat_assignment ');
2196: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2197: RAISE FND_API.g_exc_unexpected_error;
2198: END IF;
2199: IF FND_API.to_boolean( p_commit ) THEN
2200: COMMIT;
2201: END IF;
2195: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING EGO_ITEM_PUB.process_item_cat_assignment ');
2196: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2197: RAISE FND_API.g_exc_unexpected_error;
2198: END IF;
2199: IF FND_API.to_boolean( p_commit ) THEN
2200: COMMIT;
2201: END IF;
2202: INV_EBI_UTIL.debug_line('STEP: 40 '||'END INSIDE INV_EBI_ITEM_HELPER.process_category_assignments ');
2203: EXCEPTION
2200: COMMIT;
2201: END IF;
2202: INV_EBI_UTIL.debug_line('STEP: 40 '||'END INSIDE INV_EBI_ITEM_HELPER.process_category_assignments ');
2203: EXCEPTION
2204: WHEN FND_API.g_exc_unexpected_error THEN
2205: ROLLBACK TO inv_ebi_cat_id_save_pnt;
2206: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2207: IF(x_out.output_status.msg_data IS NULL) THEN
2208: FND_MSG_PUB.count_and_get(
2202: INV_EBI_UTIL.debug_line('STEP: 40 '||'END INSIDE INV_EBI_ITEM_HELPER.process_category_assignments ');
2203: EXCEPTION
2204: WHEN FND_API.g_exc_unexpected_error THEN
2205: ROLLBACK TO inv_ebi_cat_id_save_pnt;
2206: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2207: IF(x_out.output_status.msg_data IS NULL) THEN
2208: FND_MSG_PUB.count_and_get(
2209: p_encoded => FND_API.g_false
2210: ,p_count => x_out.output_status.msg_count
2205: ROLLBACK TO inv_ebi_cat_id_save_pnt;
2206: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2207: IF(x_out.output_status.msg_data IS NULL) THEN
2208: FND_MSG_PUB.count_and_get(
2209: p_encoded => FND_API.g_false
2210: ,p_count => x_out.output_status.msg_count
2211: ,p_data => x_out.output_status.msg_data
2212: );
2213: END IF;
2212: );
2213: END IF;
2214: WHEN OTHERS THEN
2215: ROLLBACK TO inv_ebi_cat_id_save_pnt;
2216: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2217: IF (x_out.output_status.msg_data IS NOT NULL) THEN
2218: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_ITEM_HELPER.process_category_assignments ';
2219: ELSE
2220: x_out.output_status.msg_data := SQLERRM||' INV_EBI_ITEM_HELPER.process_category_assignments ';
2227: -- This API is used to
2228: --
2229: ************************************************************************************/
2230: PROCEDURE process_part_num_association(
2231: p_commit IN VARCHAR2 := fnd_api.g_false
2232: ,p_organization_id IN NUMBER
2233: ,p_inventory_item_id IN NUMBER
2234: ,p_mfg_part_obj IN inv_ebi_manufacturer_part_obj
2235: ,x_out OUT NOCOPY inv_ebi_item_output_obj
2295: AND inventory_item_id = p_inventory_item_id;
2296: BEGIN
2297: SAVEPOINT inv_ebi_part_num_save_pnt;
2298: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.process_part_num_association ');
2299: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2300: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
2301: IF p_mfg_part_obj.mfg_part_num IS NOT NULL THEN
2302: OPEN c_mfg_part_num(
2303: p_manufacturer_id => p_mfg_part_obj.manufacturer_id
2327: ,l_attribute12
2328: ,l_attribute13
2329: ,l_attribute14
2330: ,l_attribute15 ;
2331: IF (p_inventory_item_id <> FND_API.G_MISS_NUM ) THEN
2332: l_inventory_item_id := p_inventory_item_id;
2333: END IF;
2334: IF (p_organization_id <> FND_API.G_MISS_NUM ) THEN
2335: l_organization_id := p_organization_id;
2330: ,l_attribute15 ;
2331: IF (p_inventory_item_id <> FND_API.G_MISS_NUM ) THEN
2332: l_inventory_item_id := p_inventory_item_id;
2333: END IF;
2334: IF (p_organization_id <> FND_API.G_MISS_NUM ) THEN
2335: l_organization_id := p_organization_id;
2336: END IF;
2337: IF (p_mfg_part_obj.description <> FND_API.G_MISS_CHAR) THEN
2338: l_description := p_mfg_part_obj.description;
2333: END IF;
2334: IF (p_organization_id <> FND_API.G_MISS_NUM ) THEN
2335: l_organization_id := p_organization_id;
2336: END IF;
2337: IF (p_mfg_part_obj.description <> FND_API.G_MISS_CHAR) THEN
2338: l_description := p_mfg_part_obj.description;
2339: END IF;
2340: IF (p_mfg_part_obj.attribute_category <> FND_API.G_MISS_CHAR) THEN
2341: l_attribute_category := p_mfg_part_obj.attribute_category;
2336: END IF;
2337: IF (p_mfg_part_obj.description <> FND_API.G_MISS_CHAR) THEN
2338: l_description := p_mfg_part_obj.description;
2339: END IF;
2340: IF (p_mfg_part_obj.attribute_category <> FND_API.G_MISS_CHAR) THEN
2341: l_attribute_category := p_mfg_part_obj.attribute_category;
2342: END IF;
2343: IF (p_mfg_part_obj.attribute1 <> FND_API.G_MISS_CHAR) THEN
2344: l_attribute1 := p_mfg_part_obj.attribute1;
2339: END IF;
2340: IF (p_mfg_part_obj.attribute_category <> FND_API.G_MISS_CHAR) THEN
2341: l_attribute_category := p_mfg_part_obj.attribute_category;
2342: END IF;
2343: IF (p_mfg_part_obj.attribute1 <> FND_API.G_MISS_CHAR) THEN
2344: l_attribute1 := p_mfg_part_obj.attribute1;
2345: END IF;
2346: IF (p_mfg_part_obj.attribute2 <> FND_API.G_MISS_CHAR) THEN
2347: l_attribute2 := p_mfg_part_obj.attribute2;
2342: END IF;
2343: IF (p_mfg_part_obj.attribute1 <> FND_API.G_MISS_CHAR) THEN
2344: l_attribute1 := p_mfg_part_obj.attribute1;
2345: END IF;
2346: IF (p_mfg_part_obj.attribute2 <> FND_API.G_MISS_CHAR) THEN
2347: l_attribute2 := p_mfg_part_obj.attribute2;
2348: END IF;
2349: IF (p_mfg_part_obj.attribute3 <> FND_API.G_MISS_CHAR ) THEN
2350: l_attribute3 := p_mfg_part_obj.attribute3;
2345: END IF;
2346: IF (p_mfg_part_obj.attribute2 <> FND_API.G_MISS_CHAR) THEN
2347: l_attribute2 := p_mfg_part_obj.attribute2;
2348: END IF;
2349: IF (p_mfg_part_obj.attribute3 <> FND_API.G_MISS_CHAR ) THEN
2350: l_attribute3 := p_mfg_part_obj.attribute3;
2351: END IF;
2352: IF (p_mfg_part_obj.attribute4 <> FND_API.G_MISS_CHAR) THEN
2353: l_attribute4 := p_mfg_part_obj.attribute4;
2348: END IF;
2349: IF (p_mfg_part_obj.attribute3 <> FND_API.G_MISS_CHAR ) THEN
2350: l_attribute3 := p_mfg_part_obj.attribute3;
2351: END IF;
2352: IF (p_mfg_part_obj.attribute4 <> FND_API.G_MISS_CHAR) THEN
2353: l_attribute4 := p_mfg_part_obj.attribute4;
2354: END IF;
2355: IF (p_mfg_part_obj.attribute5 <> FND_API.G_MISS_CHAR) THEN
2356: l_attribute5 := p_mfg_part_obj.attribute5;
2351: END IF;
2352: IF (p_mfg_part_obj.attribute4 <> FND_API.G_MISS_CHAR) THEN
2353: l_attribute4 := p_mfg_part_obj.attribute4;
2354: END IF;
2355: IF (p_mfg_part_obj.attribute5 <> FND_API.G_MISS_CHAR) THEN
2356: l_attribute5 := p_mfg_part_obj.attribute5;
2357: END IF;
2358: IF (p_mfg_part_obj.attribute6 <> FND_API.G_MISS_CHAR) THEN
2359: l_attribute6 := p_mfg_part_obj.attribute6;
2354: END IF;
2355: IF (p_mfg_part_obj.attribute5 <> FND_API.G_MISS_CHAR) THEN
2356: l_attribute5 := p_mfg_part_obj.attribute5;
2357: END IF;
2358: IF (p_mfg_part_obj.attribute6 <> FND_API.G_MISS_CHAR) THEN
2359: l_attribute6 := p_mfg_part_obj.attribute6;
2360: END IF;
2361: IF (p_mfg_part_obj.attribute7 <> FND_API.G_MISS_CHAR) THEN
2362: l_attribute7 := p_mfg_part_obj.attribute7;
2357: END IF;
2358: IF (p_mfg_part_obj.attribute6 <> FND_API.G_MISS_CHAR) THEN
2359: l_attribute6 := p_mfg_part_obj.attribute6;
2360: END IF;
2361: IF (p_mfg_part_obj.attribute7 <> FND_API.G_MISS_CHAR) THEN
2362: l_attribute7 := p_mfg_part_obj.attribute7;
2363: END IF;
2364: IF (p_mfg_part_obj.attribute8 <> FND_API.G_MISS_CHAR) THEN
2365: l_attribute8 := p_mfg_part_obj.attribute8;
2360: END IF;
2361: IF (p_mfg_part_obj.attribute7 <> FND_API.G_MISS_CHAR) THEN
2362: l_attribute7 := p_mfg_part_obj.attribute7;
2363: END IF;
2364: IF (p_mfg_part_obj.attribute8 <> FND_API.G_MISS_CHAR) THEN
2365: l_attribute8 := p_mfg_part_obj.attribute8;
2366: END IF;
2367: IF (p_mfg_part_obj.attribute9 <> FND_API.G_MISS_CHAR) THEN
2368: l_attribute9 := p_mfg_part_obj.attribute9;
2363: END IF;
2364: IF (p_mfg_part_obj.attribute8 <> FND_API.G_MISS_CHAR) THEN
2365: l_attribute8 := p_mfg_part_obj.attribute8;
2366: END IF;
2367: IF (p_mfg_part_obj.attribute9 <> FND_API.G_MISS_CHAR) THEN
2368: l_attribute9 := p_mfg_part_obj.attribute9;
2369: END IF;
2370: IF (p_mfg_part_obj.attribute10 <> FND_API.G_MISS_CHAR) THEN
2371: l_attribute10 := p_mfg_part_obj.attribute10;
2366: END IF;
2367: IF (p_mfg_part_obj.attribute9 <> FND_API.G_MISS_CHAR) THEN
2368: l_attribute9 := p_mfg_part_obj.attribute9;
2369: END IF;
2370: IF (p_mfg_part_obj.attribute10 <> FND_API.G_MISS_CHAR) THEN
2371: l_attribute10 := p_mfg_part_obj.attribute10;
2372: END IF;
2373: IF (p_mfg_part_obj.attribute11 <> FND_API.G_MISS_CHAR) THEN
2374: l_attribute11 := p_mfg_part_obj.attribute11;
2369: END IF;
2370: IF (p_mfg_part_obj.attribute10 <> FND_API.G_MISS_CHAR) THEN
2371: l_attribute10 := p_mfg_part_obj.attribute10;
2372: END IF;
2373: IF (p_mfg_part_obj.attribute11 <> FND_API.G_MISS_CHAR) THEN
2374: l_attribute11 := p_mfg_part_obj.attribute11;
2375: END IF;
2376: IF (p_mfg_part_obj.attribute12 <> FND_API.G_MISS_CHAR ) THEN
2377: l_attribute12 := p_mfg_part_obj.attribute12;
2372: END IF;
2373: IF (p_mfg_part_obj.attribute11 <> FND_API.G_MISS_CHAR) THEN
2374: l_attribute11 := p_mfg_part_obj.attribute11;
2375: END IF;
2376: IF (p_mfg_part_obj.attribute12 <> FND_API.G_MISS_CHAR ) THEN
2377: l_attribute12 := p_mfg_part_obj.attribute12;
2378: END IF;
2379: IF (p_mfg_part_obj.attribute13 <> FND_API.G_MISS_CHAR) THEN
2380: l_attribute13 := p_mfg_part_obj.attribute13;
2375: END IF;
2376: IF (p_mfg_part_obj.attribute12 <> FND_API.G_MISS_CHAR ) THEN
2377: l_attribute12 := p_mfg_part_obj.attribute12;
2378: END IF;
2379: IF (p_mfg_part_obj.attribute13 <> FND_API.G_MISS_CHAR) THEN
2380: l_attribute13 := p_mfg_part_obj.attribute13;
2381: END IF;
2382: IF (p_mfg_part_obj.attribute14 <> FND_API.G_MISS_CHAR) THEN
2383: l_attribute14 := p_mfg_part_obj.attribute14;
2378: END IF;
2379: IF (p_mfg_part_obj.attribute13 <> FND_API.G_MISS_CHAR) THEN
2380: l_attribute13 := p_mfg_part_obj.attribute13;
2381: END IF;
2382: IF (p_mfg_part_obj.attribute14 <> FND_API.G_MISS_CHAR) THEN
2383: l_attribute14 := p_mfg_part_obj.attribute14;
2384: END IF;
2385: IF (p_mfg_part_obj.attribute15 <> FND_API.G_MISS_CHAR) THEN
2386: l_attribute15 := p_mfg_part_obj.attribute15;
2381: END IF;
2382: IF (p_mfg_part_obj.attribute14 <> FND_API.G_MISS_CHAR) THEN
2383: l_attribute14 := p_mfg_part_obj.attribute14;
2384: END IF;
2385: IF (p_mfg_part_obj.attribute15 <> FND_API.G_MISS_CHAR) THEN
2386: l_attribute15 := p_mfg_part_obj.attribute15;
2387: END IF;
2388:
2389: IF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_CREATE THEN
2521: ELSE
2522: FND_MESSAGE.set_name('INV_EBI','INV_EBI_PART_NUM_NULL');
2523: FND_MESSAGE.set_token('PART_NUM', p_mfg_part_obj.mfg_part_num);
2524: FND_MSG_PUB.add;
2525: RAISE FND_API.g_exc_error;
2526: END IF;
2527: IF FND_API.to_boolean( p_commit ) THEN
2528: COMMIT;
2529: END IF;
2523: FND_MESSAGE.set_token('PART_NUM', p_mfg_part_obj.mfg_part_num);
2524: FND_MSG_PUB.add;
2525: RAISE FND_API.g_exc_error;
2526: END IF;
2527: IF FND_API.to_boolean( p_commit ) THEN
2528: COMMIT;
2529: END IF;
2530: INV_EBI_UTIL.debug_line('STEP: 120 '||'END INSIDE INV_EBI_ITEM_HELPER.process_part_num_association ');
2531: EXCEPTION
2528: COMMIT;
2529: END IF;
2530: INV_EBI_UTIL.debug_line('STEP: 120 '||'END INSIDE INV_EBI_ITEM_HELPER.process_part_num_association ');
2531: EXCEPTION
2532: WHEN FND_API.g_exc_error THEN
2533: ROLLBACK TO inv_ebi_part_num_save_pnt;
2534: x_out.output_status.return_status := FND_API.g_ret_sts_error;
2535: IF(x_out.output_status.msg_data IS NULL) THEN
2536: FND_MSG_PUB.count_and_get(
2530: INV_EBI_UTIL.debug_line('STEP: 120 '||'END INSIDE INV_EBI_ITEM_HELPER.process_part_num_association ');
2531: EXCEPTION
2532: WHEN FND_API.g_exc_error THEN
2533: ROLLBACK TO inv_ebi_part_num_save_pnt;
2534: x_out.output_status.return_status := FND_API.g_ret_sts_error;
2535: IF(x_out.output_status.msg_data IS NULL) THEN
2536: FND_MSG_PUB.count_and_get(
2537: p_encoded => FND_API.g_false
2538: ,p_count => x_out.output_status.msg_count
2533: ROLLBACK TO inv_ebi_part_num_save_pnt;
2534: x_out.output_status.return_status := FND_API.g_ret_sts_error;
2535: IF(x_out.output_status.msg_data IS NULL) THEN
2536: FND_MSG_PUB.count_and_get(
2537: p_encoded => FND_API.g_false
2538: ,p_count => x_out.output_status.msg_count
2539: ,p_data => x_out.output_status.msg_data
2540: );
2541: END IF;
2538: ,p_count => x_out.output_status.msg_count
2539: ,p_data => x_out.output_status.msg_data
2540: );
2541: END IF;
2542: WHEN FND_API.g_exc_unexpected_error THEN
2543: ROLLBACK TO inv_ebi_part_num_save_pnt;
2544: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2545: IF(x_out.output_status.msg_data IS NULL) THEN
2546: FND_MSG_PUB.count_and_get(
2540: );
2541: END IF;
2542: WHEN FND_API.g_exc_unexpected_error THEN
2543: ROLLBACK TO inv_ebi_part_num_save_pnt;
2544: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2545: IF(x_out.output_status.msg_data IS NULL) THEN
2546: FND_MSG_PUB.count_and_get(
2547: p_encoded => FND_API.g_false
2548: ,p_count => x_out.output_status.msg_count
2543: ROLLBACK TO inv_ebi_part_num_save_pnt;
2544: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2545: IF(x_out.output_status.msg_data IS NULL) THEN
2546: FND_MSG_PUB.count_and_get(
2547: p_encoded => FND_API.g_false
2548: ,p_count => x_out.output_status.msg_count
2549: ,p_data => x_out.output_status.msg_data
2550: );
2551: END IF;
2550: );
2551: END IF;
2552: WHEN OTHERS THEN
2553: ROLLBACK TO inv_ebi_part_num_save_pnt;
2554: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2555: IF (x_out.output_status.msg_data IS NOT NULL) THEN
2556: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_ITEM_HELPER.process_part_num_association ';
2557: ELSE
2558: x_out.output_status.msg_data := SQLERRM||' INV_EBI_ITEM_HELPER.process_part_num_association ';
2568: --Template Ids??
2569: --Check if Organization Ids are there and how assignments to multiple orgs have to be handled
2570: ************************************************************************************/
2571: Procedure sync_item (
2572: p_commit IN VARCHAR2 := FND_API.g_false
2573: ,p_operation IN VARCHAR2
2574: ,p_item IN inv_ebi_item_obj
2575: ,x_out OUT NOCOPY inv_ebi_item_output_obj
2576: ) IS
2590: l_operating_unit VARCHAR2(240);
2591: l_operating_unit_id NUMBER;
2592: BEGIN
2593: SAVEPOINT inv_ebi_sync_item_save_pnt;
2594: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2595: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
2596: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
2597:
2598: --Create or update item
2603: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING INV_EBI_ITEM_HELPER.process_item_pvt ');
2604: process_item_pvt (
2605: p_item => p_item
2606: ,p_operation => p_operation
2607: ,p_commit => FND_API.g_false
2608: ,x_out => l_out
2609: );
2610: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING INV_EBI_ITEM_HELPER.process_item_pvt ');
2611: IF (l_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
2607: ,p_commit => FND_API.g_false
2608: ,x_out => l_out
2609: );
2610: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING INV_EBI_ITEM_HELPER.process_item_pvt ');
2611: IF (l_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
2612: x_out.output_status.msg_data := l_out.output_status.msg_data;
2613: RAISE fnd_api.g_exc_unexpected_error;
2614: END IF;
2615: l_inventory_item_id := l_out.inventory_item_id;
2609: );
2610: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING INV_EBI_ITEM_HELPER.process_item_pvt ');
2611: IF (l_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
2612: x_out.output_status.msg_data := l_out.output_status.msg_data;
2613: RAISE fnd_api.g_exc_unexpected_error;
2614: END IF;
2615: l_inventory_item_id := l_out.inventory_item_id;
2616: l_organization_id := l_out.organization_id;
2617: l_organization_code := l_out.organization_code;
2622: IF (p_item.org_id_obj_type IS NOT NULL AND p_item.org_id_obj_type.COUNT > 0) THEN
2623: INV_EBI_UTIL.debug_line('STEP: 40 '||'START CALLING INV_EBI_ITEM_HELPER.process_org_id_assignments ');
2624: process_org_id_assignments(
2625: p_init_msg_list => p_item.main_obj_type.init_msg_list
2626: ,p_commit => fnd_api.g_false
2627: ,p_inventory_item_id => l_inventory_item_id
2628: ,p_item_number => p_item.main_obj_type.item_number
2629: ,p_org_id_tbl => p_item.org_id_obj_type
2630: ,x_out => l_out
2630: ,x_out => l_out
2631: );
2632: INV_EBI_UTIL.debug_line('STEP: 40 '||'END CALLING INV_EBI_ITEM_HELPER.process_org_id_assignments ');
2633: END IF;
2634: IF (l_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2635: x_out.output_status.msg_data := l_out.output_status.msg_data;
2636: RAISE fnd_api.g_exc_unexpected_error;
2637: END IF;
2638: --Catalog Category assignment
2632: INV_EBI_UTIL.debug_line('STEP: 40 '||'END CALLING INV_EBI_ITEM_HELPER.process_org_id_assignments ');
2633: END IF;
2634: IF (l_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2635: x_out.output_status.msg_data := l_out.output_status.msg_data;
2636: RAISE fnd_api.g_exc_unexpected_error;
2637: END IF;
2638: --Catalog Category assignment
2639: IF (p_item.category_id_obj_tbl_type IS NOT NULL AND p_item.category_id_obj_tbl_type.COUNT > 0) THEN
2640: INV_EBI_UTIL.debug_line('STEP: 50 '||'START CALLING INV_EBI_ITEM_HELPER.process_category_assignments ');
2640: INV_EBI_UTIL.debug_line('STEP: 50 '||'START CALLING INV_EBI_ITEM_HELPER.process_category_assignments ');
2641: process_category_assignments(
2642: p_api_version => l_api_version
2643: ,p_init_msg_list => p_item.main_obj_type.init_msg_list
2644: ,p_commit => fnd_api.g_false
2645: ,p_inventory_item_id => l_inventory_item_id
2646: ,p_organization_id => p_item.main_obj_type.organization_id
2647: ,p_category_id_tbl => p_item.category_id_obj_tbl_type
2648: ,x_out => l_out
2648: ,x_out => l_out
2649: );
2650: INV_EBI_UTIL.debug_line('STEP: 60 '||'END CALLING INV_EBI_ITEM_HELPER.process_category_assignments ');
2651: END IF;
2652: IF (l_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2653: x_out.output_status.msg_data := l_out.output_status.msg_data;
2654: RAISE fnd_api.g_exc_unexpected_error;
2655: END IF;
2656: l_category_output := inv_ebi_category_output_obj(l_out.category_output.error_code);
2650: INV_EBI_UTIL.debug_line('STEP: 60 '||'END CALLING INV_EBI_ITEM_HELPER.process_category_assignments ');
2651: END IF;
2652: IF (l_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2653: x_out.output_status.msg_data := l_out.output_status.msg_data;
2654: RAISE fnd_api.g_exc_unexpected_error;
2655: END IF;
2656: l_category_output := inv_ebi_category_output_obj(l_out.category_output.error_code);
2657: l_master_org_id := INV_EBI_UTIL.get_master_organization(
2658: p_organization_id => p_item.main_obj_type.organization_id
2664: INV_EBI_UTIL.debug_line('STEP: 70 '||'START CALLING INV_EBI_ITEM_HELPER.process_part_num_association');
2665: FOR i IN p_item.part_num_obj_tbl_type.FIRST..p_item.part_num_obj_tbl_type.LAST
2666: LOOP
2667: l_mfg_part_num_obj := p_item.part_num_obj_tbl_type(i);
2668: IF(l_mfg_part_num_obj.manufacturer_id IS NOT NULL AND l_mfg_part_num_obj.manufacturer_id <> fnd_api.g_miss_num) THEN
2669: SELECT COUNT(1) INTO l_manufacturer_count
2670: FROM mtl_manufacturers
2671: WHERE manufacturer_id = l_mfg_part_num_obj.manufacturer_id;
2672: END IF;
2671: WHERE manufacturer_id = l_mfg_part_num_obj.manufacturer_id;
2672: END IF;
2673: IF(l_manufacturer_count > 0 ) THEN
2674: process_part_num_association(
2675: p_commit => FND_API.g_false
2676: ,p_organization_id => p_item.main_obj_type.organization_id
2677: ,p_inventory_item_id => l_inventory_item_id
2678: ,p_mfg_part_obj => l_mfg_part_num_obj
2679: ,x_out => l_out
2693: l_pk_col_name_val_pairs.TRIM(1);
2694: END IF;
2695: FND_MESSAGE.set_token('MFG_NAME', l_mfg_part_num_obj.manufacturer_name);
2696: FND_MSG_PUB.add;
2697: RAISE FND_API.g_exc_error;
2698: END IF;
2699: IF (l_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2700: x_out.output_status.msg_data := l_out.output_status.msg_data ;
2701: RAISE FND_API.g_exc_unexpected_error;
2695: FND_MESSAGE.set_token('MFG_NAME', l_mfg_part_num_obj.manufacturer_name);
2696: FND_MSG_PUB.add;
2697: RAISE FND_API.g_exc_error;
2698: END IF;
2699: IF (l_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2700: x_out.output_status.msg_data := l_out.output_status.msg_data ;
2701: RAISE FND_API.g_exc_unexpected_error;
2702: END IF;
2703: END LOOP;
2697: RAISE FND_API.g_exc_error;
2698: END IF;
2699: IF (l_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2700: x_out.output_status.msg_data := l_out.output_status.msg_data ;
2701: RAISE FND_API.g_exc_unexpected_error;
2702: END IF;
2703: END LOOP;
2704: INV_EBI_UTIL.debug_line('STEP: 80 '||'END CALLING INV_EBI_ITEM_HELPER.process_part_num_association');
2705: END IF;
2707: x_out := inv_ebi_item_output_obj(l_inventory_item_id,l_organization_id,l_organization_code,l_item_number,l_out.output_status,NULL,l_category_output,NULL,l_operating_unit,l_operating_unit_id);
2708:
2709:
2710:
2711: IF fnd_api.to_boolean(p_commit) THEN
2712: COMMIT;
2713: END IF;
2714: INV_EBI_UTIL.debug_line('STEP: 90 '||'END INSIDE INV_EBI_ITEM_HELPER.sync_item '||
2715: 'ORGANIZATION CODE: '||p_item.main_obj_type.organization_code||
2715: 'ORGANIZATION CODE: '||p_item.main_obj_type.organization_code||
2716: 'Item Number: '||p_item.main_obj_type.item_number
2717: );
2718: EXCEPTION
2719: WHEN FND_API.g_exc_error THEN
2720: ROLLBACK TO inv_ebi_sync_item_save_pnt;
2721: x_out.output_status.return_status := FND_API.g_ret_sts_error;
2722: IF(x_out.output_status.msg_data IS NULL) THEN
2723: FND_MSG_PUB.count_and_get(
2717: );
2718: EXCEPTION
2719: WHEN FND_API.g_exc_error THEN
2720: ROLLBACK TO inv_ebi_sync_item_save_pnt;
2721: x_out.output_status.return_status := FND_API.g_ret_sts_error;
2722: IF(x_out.output_status.msg_data IS NULL) THEN
2723: FND_MSG_PUB.count_and_get(
2724: p_encoded => FND_API.g_false
2725: ,p_count => x_out.output_status.msg_count
2720: ROLLBACK TO inv_ebi_sync_item_save_pnt;
2721: x_out.output_status.return_status := FND_API.g_ret_sts_error;
2722: IF(x_out.output_status.msg_data IS NULL) THEN
2723: FND_MSG_PUB.count_and_get(
2724: p_encoded => FND_API.g_false
2725: ,p_count => x_out.output_status.msg_count
2726: ,p_data => x_out.output_status.msg_data
2727: );
2728: END IF;
2725: ,p_count => x_out.output_status.msg_count
2726: ,p_data => x_out.output_status.msg_data
2727: );
2728: END IF;
2729: WHEN FND_API.g_exc_unexpected_error THEN
2730: ROLLBACK TO inv_ebi_sync_item_save_pnt;
2731: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2732: IF(x_out.output_status.msg_data IS NULL) THEN
2733: FND_MSG_PUB.count_and_get(
2727: );
2728: END IF;
2729: WHEN FND_API.g_exc_unexpected_error THEN
2730: ROLLBACK TO inv_ebi_sync_item_save_pnt;
2731: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2732: IF(x_out.output_status.msg_data IS NULL) THEN
2733: FND_MSG_PUB.count_and_get(
2734: p_encoded => FND_API.g_false
2735: ,p_count => x_out.output_status.msg_count
2730: ROLLBACK TO inv_ebi_sync_item_save_pnt;
2731: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2732: IF(x_out.output_status.msg_data IS NULL) THEN
2733: FND_MSG_PUB.count_and_get(
2734: p_encoded => FND_API.g_false
2735: ,p_count => x_out.output_status.msg_count
2736: ,p_data => x_out.output_status.msg_data
2737: );
2738: END IF;
2737: );
2738: END IF;
2739: WHEN OTHERS THEN
2740: ROLLBACK TO inv_ebi_sync_item_save_pnt;
2741: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2742: IF (x_out.output_status.msg_data IS NOT NULL) THEN
2743: x_out.output_status.msg_data := l_out.output_status.msg_data ||' -> INV_EBI_ITEM_HELPER.sync_item ';
2744: ELSE
2745: x_out.output_status.msg_data := SQLERRM||' INV_EBI_ITEM_HELPER.sync_item ';
2799: organization_id = p_organization_id AND
2800: (revision IS NOT NULL OR (revision = p_revision)) AND
2801: (subinventory_code IS NOT NULL OR (subinventory_code = p_subinventory_code));
2802: BEGIN
2803: x_return_status := fnd_api.g_ret_sts_success;
2804: l_item_balance_output_tbl := inv_ebi_item_bal_output_tbl();
2805: Inv_Quantity_Tree_Pub.clear_quantity_cache;
2806: IF p_item_balance_input.item_input_table IS NOT NULL THEN
2807: FOR i IN p_item_balance_input.item_input_table.FIRST..p_item_balance_input.item_input_table.LAST LOOP
2806: IF p_item_balance_input.item_input_table IS NOT NULL THEN
2807: FOR i IN p_item_balance_input.item_input_table.FIRST..p_item_balance_input.item_input_table.LAST LOOP
2808: BEGIN
2809: l_item_balance_output_tbl.EXTEND();
2810: IF p_item_balance_input.item_input_table(i).is_revision_control = FND_API.G_TRUE THEN
2811: l_is_revision_control := TRUE;
2812: ELSE
2813: l_is_revision_control := FALSE;
2814: END IF;
2811: l_is_revision_control := TRUE;
2812: ELSE
2813: l_is_revision_control := FALSE;
2814: END IF;
2815: IF p_item_balance_input.item_input_table(i).is_lot_control = FND_API.G_TRUE THEN
2816: l_is_lot_control := TRUE;
2817: ELSE
2818: l_is_lot_control := FALSE;
2819: END IF;
2816: l_is_lot_control := TRUE;
2817: ELSE
2818: l_is_lot_control := FALSE;
2819: END IF;
2820: IF p_item_balance_input.item_input_table(i).is_serial_control = FND_API.G_TRUE THEN
2821: l_is_serial_control := TRUE;
2822: ELSE
2823: l_is_serial_control := FALSE;
2824: END IF;
2919: ,NULL
2920: ,NULL
2921: ,NULL);
2922: l_item_balance_output_tbl(i) := l_item_balance_output_obj;
2923: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2924: RAISE FND_API.g_exc_unexpected_error;
2925: END IF;
2926: --If Locator Information is required then get the item balance based on location
2927: IF p_item_balance_input.item_input_table(i).is_loc_info_required = fnd_api.g_true THEN
2920: ,NULL
2921: ,NULL);
2922: l_item_balance_output_tbl(i) := l_item_balance_output_obj;
2923: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2924: RAISE FND_API.g_exc_unexpected_error;
2925: END IF;
2926: --If Locator Information is required then get the item balance based on location
2927: IF p_item_balance_input.item_input_table(i).is_loc_info_required = fnd_api.g_true THEN
2928: l_item_balance_loc_tbl :=inv_ebi_item_bal_loc_tbl();
2923: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2924: RAISE FND_API.g_exc_unexpected_error;
2925: END IF;
2926: --If Locator Information is required then get the item balance based on location
2927: IF p_item_balance_input.item_input_table(i).is_loc_info_required = fnd_api.g_true THEN
2928: l_item_balance_loc_tbl :=inv_ebi_item_bal_loc_tbl();
2929: l_cur_index :=1;
2930: FOR cer IN c_locator_id(p_item_balance_input.item_input_table(i).inventory_item_id
2931: ,p_item_balance_input.item_input_table(i).organization_id
2973: ,x_return_status => l_return_status
2974: ,x_msg_count => l_msg_count
2975: ,x_msg_data => l_msg_data
2976: );
2977: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2978: RAISE FND_API.g_exc_unexpected_error;
2979: END IF;
2980: l_item_bal_output := inv_ebi_item_balance_obj(
2981: l_return_status
2974: ,x_msg_count => l_msg_count
2975: ,x_msg_data => l_msg_data
2976: );
2977: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2978: RAISE FND_API.g_exc_unexpected_error;
2979: END IF;
2980: l_item_bal_output := inv_ebi_item_balance_obj(
2981: l_return_status
2982: ,l_msg_count
3005: ,x_operating_unit => l_item_balance_output_tbl(i).operating_unit
3006: ,x_ouid => l_item_balance_output_tbl(i).operating_unit_id
3007: );
3008: EXCEPTION
3009: WHEN FND_API.g_exc_unexpected_error THEN
3010: x_return_status := FND_API.g_ret_sts_error;
3011: IF l_msg_data IS NULL THEN
3012: FND_MSG_PUB.count_and_get(
3013: p_encoded => FND_API.g_false
3006: ,x_ouid => l_item_balance_output_tbl(i).operating_unit_id
3007: );
3008: EXCEPTION
3009: WHEN FND_API.g_exc_unexpected_error THEN
3010: x_return_status := FND_API.g_ret_sts_error;
3011: IF l_msg_data IS NULL THEN
3012: FND_MSG_PUB.count_and_get(
3013: p_encoded => FND_API.g_false
3014: ,p_count => l_item_balance_output_tbl(i).item_balance_output.msg_count
3009: WHEN FND_API.g_exc_unexpected_error THEN
3010: x_return_status := FND_API.g_ret_sts_error;
3011: IF l_msg_data IS NULL THEN
3012: FND_MSG_PUB.count_and_get(
3013: p_encoded => FND_API.g_false
3014: ,p_count => l_item_balance_output_tbl(i).item_balance_output.msg_count
3015: ,p_data => l_item_balance_output_tbl(i).item_balance_output.msg_data
3016: );
3017: END IF;
3022: ,p_part_err_msg => l_item_balance_output_tbl(i).item_balance_output.msg_data
3023: ,x_err_msg => x_msg_data
3024: );
3025: WHEN OTHERS THEN
3026: x_return_status := FND_API.g_ret_sts_error;
3027: populate_err_msg(p_orgid => p_item_balance_input.item_input_table(i).organization_id
3028: ,p_invid => p_item_balance_input.item_input_table(i).inventory_item_id
3029: ,p_org_code => l_organization_code
3030: ,p_item_name => l_item_name
3037: x_item_balance_output :=inv_ebi_item_bal_output_list(l_item_balance_output_tbl);
3038: END IF; --p_item_balance_input IS NOT NULL
3039: EXCEPTION
3040: WHEN OTHERS THEN
3041: x_return_status := FND_API.g_ret_sts_error;
3042: IF (x_msg_data IS NOT NULL) THEN
3043: x_msg_data := x_msg_data ||' -> at INV_EBI_ITEM_HELPER.get_item_balance';
3044: ELSE
3045: x_msg_data := SQLERRM||' at INV_EBI_ITEM_HELPER.get_item_balance ';
3064: IF((p_get_opr_attrs_rec.item_id IS NULL) AND
3065: (p_get_opr_attrs_rec.item_name IS NULL)) THEN
3066: FND_MESSAGE.set_name('INV','INV_EBI_NO_ITEM_ID_NAME');
3067: FND_MSG_PUB.add;
3068: RAISE FND_API.G_EXC_ERROR;
3069: ELSIF((p_get_opr_attrs_rec.organization_id IS NULL) AND
3070: (p_get_opr_attrs_rec.organization_code IS NULL))THEN
3071: FND_MESSAGE.set_name('INV','INV_EBI_NO_ORGID_ORGCODE');
3072: FND_MSG_PUB.add;
3069: ELSIF((p_get_opr_attrs_rec.organization_id IS NULL) AND
3070: (p_get_opr_attrs_rec.organization_code IS NULL))THEN
3071: FND_MESSAGE.set_name('INV','INV_EBI_NO_ORGID_ORGCODE');
3072: FND_MSG_PUB.add;
3073: RAISE FND_API.G_EXC_ERROR;
3074: ELSE
3075: x_status := FND_API.G_RET_STS_SUCCESS;
3076: END IF;
3077: EXCEPTION
3071: FND_MESSAGE.set_name('INV','INV_EBI_NO_ORGID_ORGCODE');
3072: FND_MSG_PUB.add;
3073: RAISE FND_API.G_EXC_ERROR;
3074: ELSE
3075: x_status := FND_API.G_RET_STS_SUCCESS;
3076: END IF;
3077: EXCEPTION
3078: WHEN FND_API.G_EXC_ERROR THEN
3079: x_status := FND_API.G_RET_STS_ERROR;
3074: ELSE
3075: x_status := FND_API.G_RET_STS_SUCCESS;
3076: END IF;
3077: EXCEPTION
3078: WHEN FND_API.G_EXC_ERROR THEN
3079: x_status := FND_API.G_RET_STS_ERROR;
3080: FND_MSG_PUB.count_and_get(
3081: p_encoded => FND_API.g_false
3082: ,p_count => x_msg_count
3075: x_status := FND_API.G_RET_STS_SUCCESS;
3076: END IF;
3077: EXCEPTION
3078: WHEN FND_API.G_EXC_ERROR THEN
3079: x_status := FND_API.G_RET_STS_ERROR;
3080: FND_MSG_PUB.count_and_get(
3081: p_encoded => FND_API.g_false
3082: ,p_count => x_msg_count
3083: ,p_data => x_msg_data
3077: EXCEPTION
3078: WHEN FND_API.G_EXC_ERROR THEN
3079: x_status := FND_API.G_RET_STS_ERROR;
3080: FND_MSG_PUB.count_and_get(
3081: p_encoded => FND_API.g_false
3082: ,p_count => x_msg_count
3083: ,p_data => x_msg_data
3084: );
3085: WHEN OTHERS THEN
3082: ,p_count => x_msg_count
3083: ,p_data => x_msg_data
3084: );
3085: WHEN OTHERS THEN
3086: x_status := FND_API.G_RET_STS_ERROR;
3087: IF (x_msg_data IS NOT NULL) THEN
3088: x_msg_data := x_msg_data||' -> INV_EBI_ITEM_HELPER.validate_get_item_request ';
3089: ELSE
3090: x_msg_data := SQLERRM||' INV_EBI_ITEM_HELPER.validate_get_item_request ';
3113: l_attr_grp_req_obj ego_attr_group_request_obj;
3114: l_attr_grp ego_user_attr_row_table;
3115: l_attr ego_user_attr_data_table;
3116: l_count NUMBER := 0;
3117: l_new_attr_in_tbl VARCHAR2(1) := fnd_api.g_false;
3118: l_uda_out inv_ebi_uda_output_obj;
3119: l_output_status inv_ebi_output_status;
3120: l_attr_group_name VARCHAR2(30);
3121: l_data_level VARCHAR2(20) := NULL;
3145: AND ass.data_level_int_name = p_data_level_int_name;
3146:
3147: BEGIN
3148: l_uda_out := inv_ebi_uda_output_obj(NULL,NULL);
3149: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
3150: x_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,l_uda_out);
3151:
3152: l_attr_grp_req_tbl := EGO_ATTR_GROUP_REQUEST_TABLE();
3153:
3184: p_attr_group_name => l_attr_group_name,
3185: p_data_level_int_name => l_data_level
3186: )
3187: LOOP
3188: l_new_attr_in_tbl := FND_API.G_FALSE;
3189:
3190: IF(l_count <>1 ) THEN
3191: FOR ctr1 IN l_attr_grp_req_tbl.FIRST..l_attr_grp_req_tbl.LAST LOOP
3192: IF (l_attr_grp_req_tbl(ctr1).attr_group_id = attr_cursor.attr_group_id AND
3191: FOR ctr1 IN l_attr_grp_req_tbl.FIRST..l_attr_grp_req_tbl.LAST LOOP
3192: IF (l_attr_grp_req_tbl(ctr1).attr_group_id = attr_cursor.attr_group_id AND
3193: l_attr_grp_req_tbl(ctr1).data_level = attr_cursor.data_level_int_name ) THEN
3194: l_attr_grp_req_tbl(ctr1).ATTR_NAME_LIST := l_attr_grp_req_tbl(ctr1).ATTR_NAME_LIST || ',' || attr_cursor.attr_name;
3195: l_new_attr_in_tbl := FND_API.G_TRUE;
3196: END IF;
3197: END LOOP;
3198: END IF;
3199:
3196: END IF;
3197: END LOOP;
3198: END IF;
3199:
3200: IF l_new_attr_in_tbl <> FND_API.G_TRUE THEN
3201:
3202: l_attr_grp_req_tbl.extend();
3203:
3204: IF(attr_cursor.data_level_int_name = INV_EBI_ITEM_PUB.g_data_level_item_rev) THEN
3236: ,x_msg_count => x_uda_output_obj.output_status.msg_count
3237: ,x_msg_data => x_uda_output_obj.output_status.msg_data
3238: );
3239:
3240: IF(x_uda_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3241: RAISE FND_API.g_exc_unexpected_error;
3242: END IF;
3243:
3244: INV_EBI_UTIL.transform_attr_rowdata_uda(
3237: ,x_msg_data => x_uda_output_obj.output_status.msg_data
3238: );
3239:
3240: IF(x_uda_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3241: RAISE FND_API.g_exc_unexpected_error;
3242: END IF;
3243:
3244: INV_EBI_UTIL.transform_attr_rowdata_uda(
3245: p_attributes_row_table => l_attr_grp
3250: ,x_msg_data => x_uda_output_obj.output_status.msg_data
3251:
3252: );
3253:
3254: IF(x_uda_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3255: RAISE FND_API.g_exc_unexpected_error;
3256: END IF;
3257:
3258:
3251:
3252: );
3253:
3254: IF(x_uda_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3255: RAISE FND_API.g_exc_unexpected_error;
3256: END IF;
3257:
3258:
3259: EXCEPTION
3256: END IF;
3257:
3258:
3259: EXCEPTION
3260: WHEN FND_API.g_exc_unexpected_error THEN
3261:
3262: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_unexp_error;
3263:
3264: IF(x_uda_output_obj.output_status.msg_data IS NULL) THEN
3258:
3259: EXCEPTION
3260: WHEN FND_API.g_exc_unexpected_error THEN
3261:
3262: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_unexp_error;
3263:
3264: IF(x_uda_output_obj.output_status.msg_data IS NULL) THEN
3265: fnd_msg_pub.count_and_get(
3266: p_encoded => FND_API.g_false
3262: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_unexp_error;
3263:
3264: IF(x_uda_output_obj.output_status.msg_data IS NULL) THEN
3265: fnd_msg_pub.count_and_get(
3266: p_encoded => FND_API.g_false
3267: ,p_count => x_uda_output_obj.output_status.msg_count
3268: ,p_data => x_uda_output_obj.output_status.msg_data
3269: );
3270: END IF;
3270: END IF;
3271:
3272: WHEN OTHERS THEN
3273:
3274: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_unexp_error;
3275: IF (x_uda_output_obj.output_status.msg_data IS NOT NULL) THEN
3276: x_uda_output_obj.output_status.msg_data := x_uda_output_obj.output_status.msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.get_uda_attributes ';
3277: ELSE
3278: x_uda_output_obj.output_status.msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.get_uda_attributes ';
3320: ems.attr_group_id = ass.attr_group_id;
3321:
3322: BEGIN
3323:
3324: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
3325: l_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
3326:
3327:
3328: IF( p_inventory_item_id IS NOT NULL AND
3364:
3365: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');
3366: FND_MESSAGE.set_token('COL_VALUE', 'EGO');
3367: FND_MSG_PUB.add;
3368: RAISE FND_API.g_exc_error;
3369: END IF;
3370:
3371: get_uda_attributes(
3372: p_classification_id => p_item_classification_id,
3380: x_uda_obj => x_item_uda,
3381: x_uda_output_obj => l_uda_output_obj
3382: );
3383:
3384: IF(l_uda_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3385: x_msg_data := l_uda_output_obj.output_status.msg_data ;
3386: RAISE FND_API.g_exc_unexpected_error;
3387: END IF;
3388: END IF;
3382: );
3383:
3384: IF(l_uda_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3385: x_msg_data := l_uda_output_obj.output_status.msg_data ;
3386: RAISE FND_API.g_exc_unexpected_error;
3387: END IF;
3388: END IF;
3389: END IF;
3390:
3388: END IF;
3389: END IF;
3390:
3391: EXCEPTION
3392: WHEN FND_API.g_exc_unexpected_error THEN
3393:
3394: IF c_attr_group_id%ISOPEN THEN
3395: CLOSE c_attr_group_id;
3396: END IF;
3394: IF c_attr_group_id%ISOPEN THEN
3395: CLOSE c_attr_group_id;
3396: END IF;
3397:
3398: x_return_status := FND_API.g_ret_sts_unexp_error;
3399: IF(x_msg_data IS NULL) THEN
3400: fnd_msg_pub.count_and_get(
3401: p_encoded => FND_API.g_false
3402: ,p_count => x_msg_count
3397:
3398: x_return_status := FND_API.g_ret_sts_unexp_error;
3399: IF(x_msg_data IS NULL) THEN
3400: fnd_msg_pub.count_and_get(
3401: p_encoded => FND_API.g_false
3402: ,p_count => x_msg_count
3403: ,p_data => x_msg_data
3404: );
3405: END IF;
3408: IF c_attr_group_id%ISOPEN THEN
3409: CLOSE c_attr_group_id;
3410: END IF;
3411:
3412: x_return_status := FND_API.g_ret_sts_unexp_error;
3413: IF (x_msg_data IS NOT NULL) THEN
3414: x_msg_data := x_msg_data||' ->INV_EBI_ITEM_HELPER.get_item_uda ';
3415: ELSE
3416: x_msg_data := SQLERRM||'INV_EBI_ITEM_HELPER.get_item_uda';
3451: l_item_core_obj inv_ebi_item_main_obj;
3452: l_item_custom_obj inv_ebi_item_custom_obj;
3453: l_uda_obj inv_ebi_uda_input_obj;
3454: l_item_obj inv_ebi_item_obj;
3455: l_getassetmgmtattrs VARCHAR2(1) := FND_API.G_FALSE;
3456: l_getbomattrs VARCHAR2(1) := FND_API.G_FALSE;
3457: l_getcostingattrs VARCHAR2(1) := FND_API.G_FALSE;
3458: l_getgeneralplanningattrs VARCHAR2(1) := FND_API.G_FALSE;
3459: l_getinventoryattrs VARCHAR2(1) := FND_API.G_FALSE;
3452: l_item_custom_obj inv_ebi_item_custom_obj;
3453: l_uda_obj inv_ebi_uda_input_obj;
3454: l_item_obj inv_ebi_item_obj;
3455: l_getassetmgmtattrs VARCHAR2(1) := FND_API.G_FALSE;
3456: l_getbomattrs VARCHAR2(1) := FND_API.G_FALSE;
3457: l_getcostingattrs VARCHAR2(1) := FND_API.G_FALSE;
3458: l_getgeneralplanningattrs VARCHAR2(1) := FND_API.G_FALSE;
3459: l_getinventoryattrs VARCHAR2(1) := FND_API.G_FALSE;
3460: l_getinvoicingattrs VARCHAR2(1) := FND_API.G_FALSE;
3453: l_uda_obj inv_ebi_uda_input_obj;
3454: l_item_obj inv_ebi_item_obj;
3455: l_getassetmgmtattrs VARCHAR2(1) := FND_API.G_FALSE;
3456: l_getbomattrs VARCHAR2(1) := FND_API.G_FALSE;
3457: l_getcostingattrs VARCHAR2(1) := FND_API.G_FALSE;
3458: l_getgeneralplanningattrs VARCHAR2(1) := FND_API.G_FALSE;
3459: l_getinventoryattrs VARCHAR2(1) := FND_API.G_FALSE;
3460: l_getinvoicingattrs VARCHAR2(1) := FND_API.G_FALSE;
3461: l_getleadtimeattrs VARCHAR2(1) := FND_API.G_FALSE;
3454: l_item_obj inv_ebi_item_obj;
3455: l_getassetmgmtattrs VARCHAR2(1) := FND_API.G_FALSE;
3456: l_getbomattrs VARCHAR2(1) := FND_API.G_FALSE;
3457: l_getcostingattrs VARCHAR2(1) := FND_API.G_FALSE;
3458: l_getgeneralplanningattrs VARCHAR2(1) := FND_API.G_FALSE;
3459: l_getinventoryattrs VARCHAR2(1) := FND_API.G_FALSE;
3460: l_getinvoicingattrs VARCHAR2(1) := FND_API.G_FALSE;
3461: l_getleadtimeattrs VARCHAR2(1) := FND_API.G_FALSE;
3462: l_getmpsmrpplanningattrs VARCHAR2(1) := FND_API.G_FALSE;
3455: l_getassetmgmtattrs VARCHAR2(1) := FND_API.G_FALSE;
3456: l_getbomattrs VARCHAR2(1) := FND_API.G_FALSE;
3457: l_getcostingattrs VARCHAR2(1) := FND_API.G_FALSE;
3458: l_getgeneralplanningattrs VARCHAR2(1) := FND_API.G_FALSE;
3459: l_getinventoryattrs VARCHAR2(1) := FND_API.G_FALSE;
3460: l_getinvoicingattrs VARCHAR2(1) := FND_API.G_FALSE;
3461: l_getleadtimeattrs VARCHAR2(1) := FND_API.G_FALSE;
3462: l_getmpsmrpplanningattrs VARCHAR2(1) := FND_API.G_FALSE;
3463: l_getorderattrs VARCHAR2(1) := FND_API.G_FALSE;
3456: l_getbomattrs VARCHAR2(1) := FND_API.G_FALSE;
3457: l_getcostingattrs VARCHAR2(1) := FND_API.G_FALSE;
3458: l_getgeneralplanningattrs VARCHAR2(1) := FND_API.G_FALSE;
3459: l_getinventoryattrs VARCHAR2(1) := FND_API.G_FALSE;
3460: l_getinvoicingattrs VARCHAR2(1) := FND_API.G_FALSE;
3461: l_getleadtimeattrs VARCHAR2(1) := FND_API.G_FALSE;
3462: l_getmpsmrpplanningattrs VARCHAR2(1) := FND_API.G_FALSE;
3463: l_getorderattrs VARCHAR2(1) := FND_API.G_FALSE;
3464: l_getphysicalattrs VARCHAR2(1) := FND_API.G_FALSE;
3457: l_getcostingattrs VARCHAR2(1) := FND_API.G_FALSE;
3458: l_getgeneralplanningattrs VARCHAR2(1) := FND_API.G_FALSE;
3459: l_getinventoryattrs VARCHAR2(1) := FND_API.G_FALSE;
3460: l_getinvoicingattrs VARCHAR2(1) := FND_API.G_FALSE;
3461: l_getleadtimeattrs VARCHAR2(1) := FND_API.G_FALSE;
3462: l_getmpsmrpplanningattrs VARCHAR2(1) := FND_API.G_FALSE;
3463: l_getorderattrs VARCHAR2(1) := FND_API.G_FALSE;
3464: l_getphysicalattrs VARCHAR2(1) := FND_API.G_FALSE;
3465: l_getprocessattrs VARCHAR2(1) := FND_API.G_FALSE;
3458: l_getgeneralplanningattrs VARCHAR2(1) := FND_API.G_FALSE;
3459: l_getinventoryattrs VARCHAR2(1) := FND_API.G_FALSE;
3460: l_getinvoicingattrs VARCHAR2(1) := FND_API.G_FALSE;
3461: l_getleadtimeattrs VARCHAR2(1) := FND_API.G_FALSE;
3462: l_getmpsmrpplanningattrs VARCHAR2(1) := FND_API.G_FALSE;
3463: l_getorderattrs VARCHAR2(1) := FND_API.G_FALSE;
3464: l_getphysicalattrs VARCHAR2(1) := FND_API.G_FALSE;
3465: l_getprocessattrs VARCHAR2(1) := FND_API.G_FALSE;
3466: l_getpurchasingattrs VARCHAR2(1) := FND_API.G_FALSE;
3459: l_getinventoryattrs VARCHAR2(1) := FND_API.G_FALSE;
3460: l_getinvoicingattrs VARCHAR2(1) := FND_API.G_FALSE;
3461: l_getleadtimeattrs VARCHAR2(1) := FND_API.G_FALSE;
3462: l_getmpsmrpplanningattrs VARCHAR2(1) := FND_API.G_FALSE;
3463: l_getorderattrs VARCHAR2(1) := FND_API.G_FALSE;
3464: l_getphysicalattrs VARCHAR2(1) := FND_API.G_FALSE;
3465: l_getprocessattrs VARCHAR2(1) := FND_API.G_FALSE;
3466: l_getpurchasingattrs VARCHAR2(1) := FND_API.G_FALSE;
3467: l_getrecevingattrs VARCHAR2(1) := FND_API.G_FALSE;
3460: l_getinvoicingattrs VARCHAR2(1) := FND_API.G_FALSE;
3461: l_getleadtimeattrs VARCHAR2(1) := FND_API.G_FALSE;
3462: l_getmpsmrpplanningattrs VARCHAR2(1) := FND_API.G_FALSE;
3463: l_getorderattrs VARCHAR2(1) := FND_API.G_FALSE;
3464: l_getphysicalattrs VARCHAR2(1) := FND_API.G_FALSE;
3465: l_getprocessattrs VARCHAR2(1) := FND_API.G_FALSE;
3466: l_getpurchasingattrs VARCHAR2(1) := FND_API.G_FALSE;
3467: l_getrecevingattrs VARCHAR2(1) := FND_API.G_FALSE;
3468: l_getserviceattrs VARCHAR2(1) := FND_API.G_FALSE;
3461: l_getleadtimeattrs VARCHAR2(1) := FND_API.G_FALSE;
3462: l_getmpsmrpplanningattrs VARCHAR2(1) := FND_API.G_FALSE;
3463: l_getorderattrs VARCHAR2(1) := FND_API.G_FALSE;
3464: l_getphysicalattrs VARCHAR2(1) := FND_API.G_FALSE;
3465: l_getprocessattrs VARCHAR2(1) := FND_API.G_FALSE;
3466: l_getpurchasingattrs VARCHAR2(1) := FND_API.G_FALSE;
3467: l_getrecevingattrs VARCHAR2(1) := FND_API.G_FALSE;
3468: l_getserviceattrs VARCHAR2(1) := FND_API.G_FALSE;
3469: l_getweboptionattrs VARCHAR2(1) := FND_API.G_FALSE;
3462: l_getmpsmrpplanningattrs VARCHAR2(1) := FND_API.G_FALSE;
3463: l_getorderattrs VARCHAR2(1) := FND_API.G_FALSE;
3464: l_getphysicalattrs VARCHAR2(1) := FND_API.G_FALSE;
3465: l_getprocessattrs VARCHAR2(1) := FND_API.G_FALSE;
3466: l_getpurchasingattrs VARCHAR2(1) := FND_API.G_FALSE;
3467: l_getrecevingattrs VARCHAR2(1) := FND_API.G_FALSE;
3468: l_getserviceattrs VARCHAR2(1) := FND_API.G_FALSE;
3469: l_getweboptionattrs VARCHAR2(1) := FND_API.G_FALSE;
3470: l_getwipattrs VARCHAR2(1) := FND_API.G_FALSE;
3463: l_getorderattrs VARCHAR2(1) := FND_API.G_FALSE;
3464: l_getphysicalattrs VARCHAR2(1) := FND_API.G_FALSE;
3465: l_getprocessattrs VARCHAR2(1) := FND_API.G_FALSE;
3466: l_getpurchasingattrs VARCHAR2(1) := FND_API.G_FALSE;
3467: l_getrecevingattrs VARCHAR2(1) := FND_API.G_FALSE;
3468: l_getserviceattrs VARCHAR2(1) := FND_API.G_FALSE;
3469: l_getweboptionattrs VARCHAR2(1) := FND_API.G_FALSE;
3470: l_getwipattrs VARCHAR2(1) := FND_API.G_FALSE;
3471: l_getitemoprattrs VARCHAR2(1) := FND_API.G_FALSE;
3464: l_getphysicalattrs VARCHAR2(1) := FND_API.G_FALSE;
3465: l_getprocessattrs VARCHAR2(1) := FND_API.G_FALSE;
3466: l_getpurchasingattrs VARCHAR2(1) := FND_API.G_FALSE;
3467: l_getrecevingattrs VARCHAR2(1) := FND_API.G_FALSE;
3468: l_getserviceattrs VARCHAR2(1) := FND_API.G_FALSE;
3469: l_getweboptionattrs VARCHAR2(1) := FND_API.G_FALSE;
3470: l_getwipattrs VARCHAR2(1) := FND_API.G_FALSE;
3471: l_getitemoprattrs VARCHAR2(1) := FND_API.G_FALSE;
3472: l_org_id NUMBER;
3465: l_getprocessattrs VARCHAR2(1) := FND_API.G_FALSE;
3466: l_getpurchasingattrs VARCHAR2(1) := FND_API.G_FALSE;
3467: l_getrecevingattrs VARCHAR2(1) := FND_API.G_FALSE;
3468: l_getserviceattrs VARCHAR2(1) := FND_API.G_FALSE;
3469: l_getweboptionattrs VARCHAR2(1) := FND_API.G_FALSE;
3470: l_getwipattrs VARCHAR2(1) := FND_API.G_FALSE;
3471: l_getitemoprattrs VARCHAR2(1) := FND_API.G_FALSE;
3472: l_org_id NUMBER;
3473: l_item_id NUMBER;
3466: l_getpurchasingattrs VARCHAR2(1) := FND_API.G_FALSE;
3467: l_getrecevingattrs VARCHAR2(1) := FND_API.G_FALSE;
3468: l_getserviceattrs VARCHAR2(1) := FND_API.G_FALSE;
3469: l_getweboptionattrs VARCHAR2(1) := FND_API.G_FALSE;
3470: l_getwipattrs VARCHAR2(1) := FND_API.G_FALSE;
3471: l_getitemoprattrs VARCHAR2(1) := FND_API.G_FALSE;
3472: l_org_id NUMBER;
3473: l_item_id NUMBER;
3474: l_msg_data VARCHAR2(100);
3467: l_getrecevingattrs VARCHAR2(1) := FND_API.G_FALSE;
3468: l_getserviceattrs VARCHAR2(1) := FND_API.G_FALSE;
3469: l_getweboptionattrs VARCHAR2(1) := FND_API.G_FALSE;
3470: l_getwipattrs VARCHAR2(1) := FND_API.G_FALSE;
3471: l_getitemoprattrs VARCHAR2(1) := FND_API.G_FALSE;
3472: l_org_id NUMBER;
3473: l_item_id NUMBER;
3474: l_msg_data VARCHAR2(100);
3475: l_msg_count NUMBER;
3490: WHERE inventory_item_id = p_item_id AND organization_id=p_org_id;
3491:
3492: BEGIN
3493: l_item_attr_tbl := inv_ebi_item_attr_tbl();
3494: x_return_status := FND_API.G_RET_STS_SUCCESS;
3495: IF p_get_item_inp_obj.p_config_flags IS NULL THEN
3496: l_getitemoprattrs := FND_API.G_TRUE;
3497: ELSE
3498: FOR i IN p_get_item_inp_obj.p_config_flags.FIRST..p_get_item_inp_obj.p_config_flags.LAST
3492: BEGIN
3493: l_item_attr_tbl := inv_ebi_item_attr_tbl();
3494: x_return_status := FND_API.G_RET_STS_SUCCESS;
3495: IF p_get_item_inp_obj.p_config_flags IS NULL THEN
3496: l_getitemoprattrs := FND_API.G_TRUE;
3497: ELSE
3498: FOR i IN p_get_item_inp_obj.p_config_flags.FIRST..p_get_item_inp_obj.p_config_flags.LAST
3499: LOOP
3500: CASE p_get_item_inp_obj.p_config_flags(i).param_name
3543: LOOP
3544: BEGIN
3545: l_item_attr_tbl.extend();
3546: l_mfr_part_table := inv_ebi_mfg_part_obj_tbl_type();
3547: l_item_attr_tbl(i) := inv_ebi_get_item_output_obj(NULL,FND_API.G_RET_STS_SUCCESS,NULL,NULL);
3548: l_item_core_obj := inv_ebi_item_main_obj(
3549: NULL,NULL,NULL,NULL,NULL,NULL,
3550: NULL,NULL,NULL,NULL,NULL,NULL,
3551: NULL,NULL,NULL,NULL,NULL,NULL,
3637: ,x_msg_data => l_item_attr_tbl(i).msg_data
3638: );
3639: l_org_id := p_get_item_inp_obj.p_get_opr_attrs_tbl_type(i).organization_id;
3640: l_item_id := p_get_item_inp_obj.p_get_opr_attrs_tbl_type(i).item_id;
3641: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3642: RAISE FND_API.G_EXC_ERROR;
3643: END IF;
3644: IF((l_org_id IS NULL) )THEN
3645: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
3638: );
3639: l_org_id := p_get_item_inp_obj.p_get_opr_attrs_tbl_type(i).organization_id;
3640: l_item_id := p_get_item_inp_obj.p_get_opr_attrs_tbl_type(i).item_id;
3641: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3642: RAISE FND_API.G_EXC_ERROR;
3643: END IF;
3644: IF((l_org_id IS NULL) )THEN
3645: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
3646: l_pk_col_name_val_pairs.EXTEND(1);
3653: IF (l_org_id IS NULL) THEN
3654: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
3655: FND_MESSAGE.set_token('COL_VALUE', p_get_item_inp_obj.p_get_opr_attrs_tbl_type(i).organization_code);
3656: FND_MSG_PUB.add;
3657: RAISE FND_API.G_EXC_ERROR;
3658: END IF;
3659: END IF;
3660: IF( l_item_id IS NULL) THEN
3661: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
3671: IF (l_item_id IS NULL ) THEN
3672: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
3673: FND_MESSAGE.set_token('COL_VALUE', p_get_item_inp_obj.p_get_opr_attrs_tbl_type(i).item_name);
3674: FND_MSG_PUB.add;
3675: RAISE FND_API.G_EXC_ERROR;
3676: END IF;
3677: END IF;
3678: SELECT inventory_item_id
3679: ,organization_id
4261: ,l_item_custom_obj.GLOBAL_ATTRIBUTE10
4262: FROM mtl_system_items_b
4263: WHERE inventory_item_id=l_item_id AND organization_id=l_org_id;
4264:
4265: IF ( (l_item_core_obj.revision_id IS NULL OR l_item_core_obj.revision_id= fnd_api.g_miss_num)
4266: AND (l_org_id IS NOT NULL AND l_item_id IS NOT NULL)
4267: ) THEN
4268: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
4269: l_pk_col_name_val_pairs.EXTEND(2);
4307: x_return_status => l_return_status,
4308: x_msg_count => l_msg_count,
4309: x_msg_data => l_msg_data
4310: );
4311: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4312: l_item_attr_tbl(i).msg_data := l_msg_data;
4313: RAISE FND_API.G_EXC_ERROR;
4314: END IF;
4315:
4309: x_msg_data => l_msg_data
4310: );
4311: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4312: l_item_attr_tbl(i).msg_data := l_msg_data;
4313: RAISE FND_API.G_EXC_ERROR;
4314: END IF;
4315:
4316: -- To populate unit_cost of l_item_costing_obj
4317: l_item_costing_obj.unit_cost := CST_COST_API.get_item_cost (
4439: l_item_core_obj.master_organization_code := INV_EBI_ITEM_HELPER.id_to_value(
4440: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
4441: ,p_entity_name=> INV_EBI_ITEM_HELPER.G_ORGANIZATION
4442: );
4443: IF(NOT (l_getassetmgmtattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4444: l_item_asset_obj := NULL;
4445: END IF;
4446: IF(NOT(l_getbomattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4447: l_item_bom_obj := NULL;
4442: );
4443: IF(NOT (l_getassetmgmtattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4444: l_item_asset_obj := NULL;
4445: END IF;
4446: IF(NOT(l_getbomattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4447: l_item_bom_obj := NULL;
4448: END IF;
4449: IF(NOT(l_getcostingattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4450: l_item_costing_obj := NULL;
4445: END IF;
4446: IF(NOT(l_getbomattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4447: l_item_bom_obj := NULL;
4448: END IF;
4449: IF(NOT(l_getcostingattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4450: l_item_costing_obj := NULL;
4451: END IF;
4452: IF(NOT(l_getgeneralplanningattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE ))THEN
4453: l_item_gplan_obj := NULL;
4448: END IF;
4449: IF(NOT(l_getcostingattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4450: l_item_costing_obj := NULL;
4451: END IF;
4452: IF(NOT(l_getgeneralplanningattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE ))THEN
4453: l_item_gplan_obj := NULL;
4454: END IF;
4455: IF(NOT(l_getinventoryattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4456: l_item_inv_obj := NULL;
4451: END IF;
4452: IF(NOT(l_getgeneralplanningattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE ))THEN
4453: l_item_gplan_obj := NULL;
4454: END IF;
4455: IF(NOT(l_getinventoryattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4456: l_item_inv_obj := NULL;
4457: END IF;
4458: IF(NOT(l_getinvoicingattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4459: l_item_invoice_obj := NULL;
4454: END IF;
4455: IF(NOT(l_getinventoryattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4456: l_item_inv_obj := NULL;
4457: END IF;
4458: IF(NOT(l_getinvoicingattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4459: l_item_invoice_obj := NULL;
4460: END IF;
4461: IF(NOT(l_getleadtimeattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4462: l_item_lead_time_obj := NULL;
4457: END IF;
4458: IF(NOT(l_getinvoicingattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4459: l_item_invoice_obj := NULL;
4460: END IF;
4461: IF(NOT(l_getleadtimeattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4462: l_item_lead_time_obj := NULL;
4463: END IF;
4464: IF(NOT(l_getmpsmrpplanningattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4465: l_item_mrp_obj := NULL;
4460: END IF;
4461: IF(NOT(l_getleadtimeattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4462: l_item_lead_time_obj := NULL;
4463: END IF;
4464: IF(NOT(l_getmpsmrpplanningattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4465: l_item_mrp_obj := NULL;
4466: END IF;
4467: IF(NOT(l_getorderattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4468: l_item_order_obj := NULL;
4463: END IF;
4464: IF(NOT(l_getmpsmrpplanningattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4465: l_item_mrp_obj := NULL;
4466: END IF;
4467: IF(NOT(l_getorderattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4468: l_item_order_obj := NULL;
4469: END IF;
4470: IF(NOT(l_getphysicalattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4471: l_item_phy_obj := NULL;
4466: END IF;
4467: IF(NOT(l_getorderattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4468: l_item_order_obj := NULL;
4469: END IF;
4470: IF(NOT(l_getphysicalattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4471: l_item_phy_obj := NULL;
4472: END IF;
4473: IF(NOT(l_getprocessattrs=FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4474: l_item_process_obj := NULL;
4469: END IF;
4470: IF(NOT(l_getphysicalattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4471: l_item_phy_obj := NULL;
4472: END IF;
4473: IF(NOT(l_getprocessattrs=FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4474: l_item_process_obj := NULL;
4475: END IF;
4476: IF(NOT(l_getpurchasingattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4477: l_item_pur_obj := NULL;
4472: END IF;
4473: IF(NOT(l_getprocessattrs=FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4474: l_item_process_obj := NULL;
4475: END IF;
4476: IF(NOT(l_getpurchasingattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4477: l_item_pur_obj := NULL;
4478: END IF;
4479: IF(NOT(l_getrecevingattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE ))THEN
4480: l_item_recving_obj := NULL;
4475: END IF;
4476: IF(NOT(l_getpurchasingattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE )) THEN
4477: l_item_pur_obj := NULL;
4478: END IF;
4479: IF(NOT(l_getrecevingattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE ))THEN
4480: l_item_recving_obj := NULL;
4481: END IF;
4482: IF(NOT(l_getserviceattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE ))THEN
4483: l_item_service_obj := NULL;
4478: END IF;
4479: IF(NOT(l_getrecevingattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE ))THEN
4480: l_item_recving_obj := NULL;
4481: END IF;
4482: IF(NOT(l_getserviceattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE ))THEN
4483: l_item_service_obj := NULL;
4484: END IF;
4485: IF(NOT(l_getweboptionattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE ))THEN
4486: l_item_web_opiton := NULL;
4481: END IF;
4482: IF(NOT(l_getserviceattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE ))THEN
4483: l_item_service_obj := NULL;
4484: END IF;
4485: IF(NOT(l_getweboptionattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE ))THEN
4486: l_item_web_opiton := NULL;
4487: END IF;
4488: IF(NOT(l_getwipattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE ))THEN
4489: l_item_wip_obj := NULL;
4484: END IF;
4485: IF(NOT(l_getweboptionattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE ))THEN
4486: l_item_web_opiton := NULL;
4487: END IF;
4488: IF(NOT(l_getwipattrs = FND_API.G_TRUE) AND NOT(l_getitemoprattrs = FND_API.G_TRUE ))THEN
4489: l_item_wip_obj := NULL;
4490: END IF;
4491: l_item_obj := inv_ebi_item_obj(l_item_core_obj
4492: ,l_item_phy_obj
4522: ,x_ouid => l_item_obj.operating_unit_id
4523: );
4524: l_item_attr_tbl(i).item_obj := l_item_obj;
4525: EXCEPTION
4526: WHEN FND_API.G_EXC_ERROR THEN
4527: x_return_status := FND_API.G_RET_STS_ERROR;
4528: l_item_attr_tbl(i).return_status := FND_API.G_RET_STS_ERROR;
4529: IF l_item_attr_tbl(i).msg_data IS NOT NULL THEN
4530: FND_MSG_PUB.count_and_get(
4523: );
4524: l_item_attr_tbl(i).item_obj := l_item_obj;
4525: EXCEPTION
4526: WHEN FND_API.G_EXC_ERROR THEN
4527: x_return_status := FND_API.G_RET_STS_ERROR;
4528: l_item_attr_tbl(i).return_status := FND_API.G_RET_STS_ERROR;
4529: IF l_item_attr_tbl(i).msg_data IS NOT NULL THEN
4530: FND_MSG_PUB.count_and_get(
4531: p_encoded => FND_API.g_false
4524: l_item_attr_tbl(i).item_obj := l_item_obj;
4525: EXCEPTION
4526: WHEN FND_API.G_EXC_ERROR THEN
4527: x_return_status := FND_API.G_RET_STS_ERROR;
4528: l_item_attr_tbl(i).return_status := FND_API.G_RET_STS_ERROR;
4529: IF l_item_attr_tbl(i).msg_data IS NOT NULL THEN
4530: FND_MSG_PUB.count_and_get(
4531: p_encoded => FND_API.g_false
4532: ,p_count => l_item_attr_tbl(i).msg_count
4527: x_return_status := FND_API.G_RET_STS_ERROR;
4528: l_item_attr_tbl(i).return_status := FND_API.G_RET_STS_ERROR;
4529: IF l_item_attr_tbl(i).msg_data IS NOT NULL THEN
4530: FND_MSG_PUB.count_and_get(
4531: p_encoded => FND_API.g_false
4532: ,p_count => l_item_attr_tbl(i).msg_count
4533: ,p_data => l_item_attr_tbl(i).msg_data
4534: );
4535: END IF;
4540: ,p_part_err_msg => l_item_attr_tbl(i).msg_data
4541: ,x_err_msg => x_msg_data
4542: );
4543: WHEN OTHERS THEN
4544: x_return_status := FND_API.G_RET_STS_ERROR;
4545: l_item_attr_tbl(i).return_status := FND_API.G_RET_STS_ERROR;
4546: populate_err_msg(p_orgid => l_org_id
4547: ,p_invid => l_item_id
4548: ,p_org_code => p_get_item_inp_obj.p_get_opr_attrs_tbl_type(i).organization_code
4541: ,x_err_msg => x_msg_data
4542: );
4543: WHEN OTHERS THEN
4544: x_return_status := FND_API.G_RET_STS_ERROR;
4545: l_item_attr_tbl(i).return_status := FND_API.G_RET_STS_ERROR;
4546: populate_err_msg(p_orgid => l_org_id
4547: ,p_invid => l_item_id
4548: ,p_org_code => p_get_item_inp_obj.p_get_opr_attrs_tbl_type(i).organization_code
4549: ,p_item_name => p_get_item_inp_obj.p_get_opr_attrs_tbl_type(i).item_name
4554: END LOOP;
4555: x_item_tbl_obj:=inv_ebi_item_attr_tbl_obj(l_item_attr_tbl);
4556: EXCEPTION
4557: WHEN OTHERS THEN
4558: x_return_status := FND_API.G_RET_STS_ERROR;
4559: IF (x_msg_data IS NOT NULL) THEN
4560: x_msg_data := x_msg_data ||' -> at INV_EBI_ITEM_HELPER.get_item_attributes';
4561: ELSE
4562: x_msg_data := SQLERRM||' at INV_EBI_ITEM_HELPER.get_item_attributes';
4683: l_org_tbl FND_TABLE_OF_VARCHAR2_255;
4684: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;
4685: l_counter NUMBER:=0;
4686: BEGIN
4687: x_return_status := FND_API.g_ret_sts_success;
4688: l_item_output_tbl := inv_ebi_get_opr_attrs_tbl();
4689:
4690: IF p_org_codes IS NOT NULL THEN
4691: l_org_tbl := parse_input_string(p_org_codes);
4709: x_item_tbl := l_item_output_tbl;
4710:
4711: EXCEPTION
4712: WHEN OTHERS THEN
4713: x_return_status := FND_API.g_ret_sts_unexp_error;
4714: x_msg_data := SQLERRM ||' at INV_EBI_ITEM_HELPER.filter_items_based_on_org';
4715: END filter_items_based_on_org;
4716:
4717: /************************************************************************************
4747: FROM mtl_system_items_kfv msik,mtl_parameters mp
4748: WHERE msik.concatenated_segments = p_item_name
4749: AND msik.organization_id = mp.organization_id;
4750: BEGIN
4751: x_return_status := FND_API.g_ret_sts_success;
4752: l_item_output_tbl := inv_ebi_get_opr_attrs_tbl();
4753:
4754: IF p_item_names IS NOT NULL THEN
4755: l_item_tbl := parse_input_string(p_item_names);
4774: ELSE
4775: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
4776: FND_MESSAGE.set_token('COL_VALUE', l_item_tbl(i));
4777: FND_MSG_PUB.add;
4778: RAISE FND_API.G_EXC_ERROR;
4779: END IF;
4780: EXCEPTION
4781: WHEN FND_API.G_EXC_ERROR THEN
4782: x_return_status := FND_API.g_ret_sts_error;
4777: FND_MSG_PUB.add;
4778: RAISE FND_API.G_EXC_ERROR;
4779: END IF;
4780: EXCEPTION
4781: WHEN FND_API.G_EXC_ERROR THEN
4782: x_return_status := FND_API.g_ret_sts_error;
4783: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4784: ,p_count => x_msg_count
4785: ,p_data => l_msg_data
4778: RAISE FND_API.G_EXC_ERROR;
4779: END IF;
4780: EXCEPTION
4781: WHEN FND_API.G_EXC_ERROR THEN
4782: x_return_status := FND_API.g_ret_sts_error;
4783: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4784: ,p_count => x_msg_count
4785: ,p_data => l_msg_data
4786: );
4779: END IF;
4780: EXCEPTION
4781: WHEN FND_API.G_EXC_ERROR THEN
4782: x_return_status := FND_API.g_ret_sts_error;
4783: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4784: ,p_count => x_msg_count
4785: ,p_data => l_msg_data
4786: );
4787: x_msg_data := x_msg_data || l_msg_data ||' , ' ;
4785: ,p_data => l_msg_data
4786: );
4787: x_msg_data := x_msg_data || l_msg_data ||' , ' ;
4788: WHEN OTHERS THEN
4789: x_return_status := FND_API.g_ret_sts_error;
4790: x_msg_data := SQLERRM ||' at INV_EBI_ITEM_HELPER.parse_and_get_item';
4791: END;
4792: END LOOP;
4793: END IF;
4807: ELSE
4808: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
4809: FND_MESSAGE.set_token('COL_VALUE', l_org_tbl(i));
4810: FND_MSG_PUB.add;
4811: RAISE FND_API.G_EXC_ERROR;
4812: END IF;
4813: EXCEPTION
4814: WHEN FND_API.G_EXC_ERROR THEN
4815: x_return_status := FND_API.g_ret_sts_error;
4810: FND_MSG_PUB.add;
4811: RAISE FND_API.G_EXC_ERROR;
4812: END IF;
4813: EXCEPTION
4814: WHEN FND_API.G_EXC_ERROR THEN
4815: x_return_status := FND_API.g_ret_sts_error;
4816: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4817: ,p_count => x_msg_count
4818: ,p_data => l_msg_data
4811: RAISE FND_API.G_EXC_ERROR;
4812: END IF;
4813: EXCEPTION
4814: WHEN FND_API.G_EXC_ERROR THEN
4815: x_return_status := FND_API.g_ret_sts_error;
4816: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4817: ,p_count => x_msg_count
4818: ,p_data => l_msg_data
4819: );
4812: END IF;
4813: EXCEPTION
4814: WHEN FND_API.G_EXC_ERROR THEN
4815: x_return_status := FND_API.g_ret_sts_error;
4816: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4817: ,p_count => x_msg_count
4818: ,p_data => l_msg_data
4819: );
4820: x_msg_data := x_msg_data || l_msg_data ||' , ' ;
4818: ,p_data => l_msg_data
4819: );
4820: x_msg_data := x_msg_data || l_msg_data ||' , ' ;
4821: WHEN OTHERS THEN
4822: x_return_status := FND_API.g_ret_sts_error;
4823: x_msg_data := SQLERRM ||' at INV_EBI_ITEM_HELPER.parse_and_get_item';
4824: END;
4825: END LOOP;
4826: END IF;
4871: IF l_count = 0 THEN
4872: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_USER_INPUT');
4873: FND_MESSAGE.set_token('USER_INPUT', l_valid_item_tbl(i));
4874: FND_MSG_PUB.add;
4875: RAISE FND_API.G_EXC_ERROR;
4876: END IF;
4877: EXCEPTION
4878: WHEN FND_API.G_EXC_ERROR THEN
4879: x_return_status := FND_API.g_ret_sts_error;
4874: FND_MSG_PUB.add;
4875: RAISE FND_API.G_EXC_ERROR;
4876: END IF;
4877: EXCEPTION
4878: WHEN FND_API.G_EXC_ERROR THEN
4879: x_return_status := FND_API.g_ret_sts_error;
4880: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4881: ,p_count => x_msg_count
4882: ,p_data => l_msg_data
4875: RAISE FND_API.G_EXC_ERROR;
4876: END IF;
4877: EXCEPTION
4878: WHEN FND_API.G_EXC_ERROR THEN
4879: x_return_status := FND_API.g_ret_sts_error;
4880: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4881: ,p_count => x_msg_count
4882: ,p_data => l_msg_data
4883: );
4876: END IF;
4877: EXCEPTION
4878: WHEN FND_API.G_EXC_ERROR THEN
4879: x_return_status := FND_API.g_ret_sts_error;
4880: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4881: ,p_count => x_msg_count
4882: ,p_data => l_msg_data
4883: );
4884: x_msg_data := x_msg_data || l_msg_data ;
4882: ,p_data => l_msg_data
4883: );
4884: x_msg_data := x_msg_data || l_msg_data ;
4885: WHEN OTHERS THEN
4886: x_return_status := FND_API.g_ret_sts_unexp_error;
4887: x_msg_data := SQLERRM ||' at INV_EBI_ITEM_HELPER.parse_and_get_item';
4888: END;
4889: END LOOP;
4890: END IF;
4890: END IF;
4891: x_item_tbl := l_item_output_tbl;
4892: EXCEPTION
4893: WHEN OTHERS THEN
4894: x_return_status := FND_API.g_ret_sts_unexp_error;
4895: x_msg_data := SQLERRM ||' at INV_EBI_ITEM_HELPER.parse_and_get_item';
4896: END parse_and_get_item;
4897:
4898: /************************************************************************************
5004: FROM dual ) b
5005: ) item_flst;
5006: BEGIN
5007: FND_MSG_PUB.initialize();
5008: x_return_status := FND_API.g_ret_sts_success;
5009:
5010: --Getting the values for the parameters passed from CP
5011: IF (p_name_value_list IS NOT NULL AND p_name_value_list.COUNT > 0) THEN
5012: l_item_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Item Name');
5052: ,x_msg_data => l_msg_data);
5053: END IF;
5054:
5055:
5056: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
5057: x_return_status := l_return_status;
5058: IF l_msg_data IS NOT NULL THEN
5059: x_msg_data := l_msg_data;
5060: END IF;
5085: ,x_item_tbl => l_item_org_output_tbl
5086: ,x_return_status => l_return_status
5087: ,x_msg_count => l_msg_count
5088: ,x_msg_data => l_msg_data);
5089: IF (l_return_status = FND_API.g_ret_sts_success) THEN
5090: x_items := l_item_org_output_tbl;
5091: ELSE
5092: x_return_status := l_return_status;
5093: IF l_msg_data IS NOT NULL THEN
5109: END LOOP;
5110: END IF;
5111: EXCEPTION
5112: WHEN OTHERS THEN
5113: x_return_status := FND_API.g_ret_sts_unexp_error;
5114: x_msg_data := SQLERRM ||' at INV_EBI_ITEM_HELPER.get_item_attributes_list';
5115: IF (c_get_item_flist%ISOPEN) THEN
5116: CLOSE c_get_item_flist;
5117: END IF;
5188: FROM dual ) b ) gibf;
5189:
5190: BEGIN
5191: FND_MSG_PUB.initialize();
5192: x_return_status := FND_API.g_ret_sts_success;
5193:
5194: IF (p_name_value_list IS NOT NULL AND p_name_value_list.COUNT > 0) THEN
5195: l_item_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Item Name');
5196: l_org_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Organization Code');
5231: ,x_msg_count => l_msg_count
5232: ,x_msg_data => l_msg_data);
5233: END IF;
5234:
5235: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
5236: x_return_status := l_return_status;
5237: IF l_msg_data IS NOT NULL THEN
5238: x_msg_data := l_msg_data;
5239: END IF;
5262: ,x_item_tbl => l_item_org_output_tbl
5263: ,x_return_status => l_return_status
5264: ,x_msg_count => l_msg_count
5265: ,x_msg_data => l_msg_data);
5266: IF (l_return_status = FND_API.g_ret_sts_success) THEN
5267: x_items := l_item_org_output_tbl;
5268: ELSE
5269: x_return_status := l_return_status;
5270: IF x_msg_data IS NOT NULL THEN
5289: END LOOP;
5290: END IF;
5291: EXCEPTION
5292: WHEN OTHERS THEN
5293: x_return_status := FND_API.g_ret_sts_unexp_error;
5294: x_msg_data := SQLERRM ||' at INV_EBI_ITEM_HELPER.get_item_balance_list';
5295: IF (c_get_bal_item_flst%ISOPEN) THEN
5296: CLOSE c_get_bal_item_flst;
5297: END IF;
5369: RETURN VARCHAR2
5370: IS
5371: l_ret_tz VARCHAR2(50);
5372: BEGIN
5373: IF(p_datetime IS NOT NULL AND p_datetime<>FND_API.G_MISS_DATE) THEN
5374: l_ret_tz := SUBSTR(TO_CHAR(p_datetime,'YYYY-MM-DD"T"HH24:MI:SS')||INV_EBI_ITEM_HELPER.G_TIME_ZONE_OFFSET,1,25);
5375: END IF;
5376: RETURN l_ret_tz;
5377: EXCEPTION