eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_EBI_ITEM_PUB dependencies on INV_EBI_ITEM_OBJ

Line 12: ,p_item IN inv_ebi_item_obj

8: --
9: ************************************************************************************/
10: PROCEDURE validate_item (
11: p_transaction_type IN VARCHAR2
12: ,p_item IN inv_ebi_item_obj
13: ,x_out OUT NOCOPY inv_ebi_item_output_obj
14: ) IS
15: l_master_org_id NUMBER;
16: l_is_master_org VARCHAR2(3) := FND_API.g_false;

Line 108: ,p_item IN inv_ebi_item_obj

104: ************************************************************************************/
105: PROCEDURE process_item(
106: p_commit IN VARCHAR2
107: ,p_operation IN VARCHAR2
108: ,p_item IN inv_ebi_item_obj
109: ,x_out OUT NOCOPY inv_ebi_item_output_obj
110: )
111: IS
112: l_item inv_ebi_item_obj;

Line 112: l_item inv_ebi_item_obj;

108: ,p_item IN inv_ebi_item_obj
109: ,x_out OUT NOCOPY inv_ebi_item_output_obj
110: )
111: IS
112: l_item inv_ebi_item_obj;
113: l_output_status inv_ebi_output_status;
114: l_api_version NUMBER:=1.0;
115: l_out inv_ebi_item_output_obj;
116:

Line 506: ,p_item IN inv_ebi_item_obj_tbl

502: ************************************************************************************/
503: PROCEDURE process_item_list(
504: p_commit IN VARCHAR2
505: ,p_operation IN VARCHAR2
506: ,p_item IN inv_ebi_item_obj_tbl
507: ,x_out OUT NOCOPY inv_ebi_item_output_obj_tbl
508: ,x_return_status OUT NOCOPY VARCHAR2
509: ,x_msg_count OUT NOCOPY NUMBER
510: ,x_msg_data OUT NOCOPY VARCHAR2

Line 513: l_inv_ebi_item_obj inv_ebi_item_obj;

509: ,x_msg_count OUT NOCOPY NUMBER
510: ,x_msg_data OUT NOCOPY VARCHAR2
511: )
512: IS
513: l_inv_ebi_item_obj inv_ebi_item_obj;
514: l_inv_ebi_item_output_obj inv_ebi_item_output_obj;
515:
516: l_part_err_msg VARCHAR2(32000);
517: l_org_code VARCHAR2(3);

Line 532: l_inv_ebi_item_obj := p_item(i);

528: IF (p_item IS NOT NULL AND p_item.count > 0) THEN
529: x_out.extend(p_item.count);
530: FOR i in 1..p_item.count
531: LOOP
532: l_inv_ebi_item_obj := p_item(i);
533: IF l_inv_ebi_item_obj.main_obj_type.organization_id IS NOT NULL THEN
534: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_id);
535: ELSE
536: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_code);

Line 533: IF l_inv_ebi_item_obj.main_obj_type.organization_id IS NOT NULL THEN

529: x_out.extend(p_item.count);
530: FOR i in 1..p_item.count
531: LOOP
532: l_inv_ebi_item_obj := p_item(i);
533: IF l_inv_ebi_item_obj.main_obj_type.organization_id IS NOT NULL THEN
534: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_id);
535: ELSE
536: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_code);
537: END IF;

Line 534: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_id);

530: FOR i in 1..p_item.count
531: LOOP
532: l_inv_ebi_item_obj := p_item(i);
533: IF l_inv_ebi_item_obj.main_obj_type.organization_id IS NOT NULL THEN
534: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_id);
535: ELSE
536: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_code);
537: END IF;
538: l_item_number := l_inv_ebi_item_obj.main_obj_type.item_number;

Line 536: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_code);

532: l_inv_ebi_item_obj := p_item(i);
533: IF l_inv_ebi_item_obj.main_obj_type.organization_id IS NOT NULL THEN
534: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_id);
535: ELSE
536: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_code);
537: END IF;
538: l_item_number := l_inv_ebi_item_obj.main_obj_type.item_number;
539: IF(l_is_master_org = fnd_api.g_true ) THEN
540: INV_EBI_UTIL.debug_line('STEP: 20 START CALLING INV_EBI_ITEM_PUB.process_item for ');

Line 538: l_item_number := l_inv_ebi_item_obj.main_obj_type.item_number;

534: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_id);
535: ELSE
536: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_code);
537: END IF;
538: l_item_number := l_inv_ebi_item_obj.main_obj_type.item_number;
539: IF(l_is_master_org = fnd_api.g_true ) THEN
540: INV_EBI_UTIL.debug_line('STEP: 20 START CALLING INV_EBI_ITEM_PUB.process_item for ');
541: INV_EBI_ITEM_PUB.process_item(
542: p_commit => p_commit

Line 544: ,p_item => l_inv_ebi_item_obj

540: INV_EBI_UTIL.debug_line('STEP: 20 START CALLING INV_EBI_ITEM_PUB.process_item for ');
541: INV_EBI_ITEM_PUB.process_item(
542: p_commit => p_commit
543: ,p_operation => p_operation
544: ,p_item => l_inv_ebi_item_obj
545: ,x_out => l_inv_ebi_item_output_obj
546: );
547: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING INV_EBI_ITEM_PUB.process_item for ');
548:

Line 550: x_out(i).integration_id := l_inv_ebi_item_obj.integration_id;

546: );
547: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING INV_EBI_ITEM_PUB.process_item for ');
548:
549: x_out(i) := l_inv_ebi_item_output_obj;
550: x_out(i).integration_id := l_inv_ebi_item_obj.integration_id;
551: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
552: x_return_status := FND_API.G_RET_STS_ERROR;
553: x_msg_count := x_out(i).output_status.msg_count;
554: x_msg_data := x_msg_data ||'Item Name :' || l_item_number || ' Err Msg: ' || x_out(i).output_status.msg_data;

Line 564: l_inv_ebi_item_obj := p_item(i);

560:
561: IF (p_item IS NOT NULL AND p_item.count > 0) THEN
562: FOR i in 1..p_item.count
563: LOOP
564: l_inv_ebi_item_obj := p_item(i);
565: IF l_inv_ebi_item_obj.main_obj_type.organization_id IS NOT NULL THEN
566: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_id);
567: ELSE
568: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_code);

Line 565: IF l_inv_ebi_item_obj.main_obj_type.organization_id IS NOT NULL THEN

561: IF (p_item IS NOT NULL AND p_item.count > 0) THEN
562: FOR i in 1..p_item.count
563: LOOP
564: l_inv_ebi_item_obj := p_item(i);
565: IF l_inv_ebi_item_obj.main_obj_type.organization_id IS NOT NULL THEN
566: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_id);
567: ELSE
568: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_code);
569: END IF;

Line 566: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_id);

562: FOR i in 1..p_item.count
563: LOOP
564: l_inv_ebi_item_obj := p_item(i);
565: IF l_inv_ebi_item_obj.main_obj_type.organization_id IS NOT NULL THEN
566: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_id);
567: ELSE
568: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_code);
569: END IF;
570: l_item_number := l_inv_ebi_item_obj.main_obj_type.item_number;

Line 568: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_code);

564: l_inv_ebi_item_obj := p_item(i);
565: IF l_inv_ebi_item_obj.main_obj_type.organization_id IS NOT NULL THEN
566: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_id);
567: ELSE
568: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_code);
569: END IF;
570: l_item_number := l_inv_ebi_item_obj.main_obj_type.item_number;
571: IF(l_is_master_org = fnd_api.g_false ) THEN
572: INV_EBI_UTIL.debug_line('STEP: 20 START CALLING INV_EBI_ITEM_PUB.process_item for ');

Line 570: l_item_number := l_inv_ebi_item_obj.main_obj_type.item_number;

566: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_id);
567: ELSE
568: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_code);
569: END IF;
570: l_item_number := l_inv_ebi_item_obj.main_obj_type.item_number;
571: IF(l_is_master_org = fnd_api.g_false ) THEN
572: INV_EBI_UTIL.debug_line('STEP: 20 START CALLING INV_EBI_ITEM_PUB.process_item for ');
573: INV_EBI_ITEM_PUB.process_item(
574: p_commit => p_commit

Line 576: ,p_item => l_inv_ebi_item_obj

572: INV_EBI_UTIL.debug_line('STEP: 20 START CALLING INV_EBI_ITEM_PUB.process_item for ');
573: INV_EBI_ITEM_PUB.process_item(
574: p_commit => p_commit
575: ,p_operation => p_operation
576: ,p_item => l_inv_ebi_item_obj
577: ,x_out => l_inv_ebi_item_output_obj
578: );
579: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING INV_EBI_ITEM_PUB.process_item for ');
580:

Line 582: x_out(i).integration_id := l_inv_ebi_item_obj.integration_id;

578: );
579: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING INV_EBI_ITEM_PUB.process_item for ');
580:
581: x_out(i) := l_inv_ebi_item_output_obj;
582: x_out(i).integration_id := l_inv_ebi_item_obj.integration_id;
583: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
584: x_return_status := FND_API.G_RET_STS_ERROR;
585: x_msg_count := x_out(i).output_status.msg_count;
586: x_msg_data := x_msg_data ||'Item Name :' || l_item_number || ' Err Msg: ' || x_out(i).output_status.msg_data;