[Home] [Help]
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:
16: l_output_status inv_ebi_output_status;
17:
18: BEGIN
19: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_ITEM_PUB.validate_item');
20: INV_EBI_UTIL.debug_line('STEP 20: ITEM NAME : ' || p_item.main_obj_type.item_number);
21: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
22: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL,NULL);
23: FND_MSG_PUB.initialize;
24:
25: IF(p_transaction_type = INV_EBI_ITEM_PUB.g_otype_create) THEN
26: IF(p_item.main_obj_type.organization_id IS NULL OR p_item.main_obj_type.organization_id = fnd_api.g_miss_num) THEN
65: PROCEDURE process_item(
66: p_commit IN VARCHAR2
67: ,p_operation IN VARCHAR2
68: ,p_item IN inv_ebi_item_obj
69: ,x_out OUT NOCOPY inv_ebi_item_output_obj
70: )
71: IS
72: l_item inv_ebi_item_obj;
73: l_output_status inv_ebi_output_status;
71: IS
72: l_item inv_ebi_item_obj;
73: l_output_status inv_ebi_output_status;
74: l_api_version NUMBER:=1.0;
75: l_out inv_ebi_item_output_obj;
76: BEGIN
77: -- This Part of the Code to set the Apps Context BUG 8712091
78: /* IF p_item.name_value_tbl IS NOT NULL AND p_item.name_value_tbl.COUNT>0
79: THEN
84: ERROR_HANDLER.initialize;
85: FND_MSG_PUB.initialize;
86:
87: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
88: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL,NULL);
89: INV_EBI_UTIL.SETUP(); --- one time for each process.
90:
91: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_ITEM_PUB.process_item '||
92: 'ORGANIZATION CODE: '||p_item.main_obj_type.organization_code||
519: PROCEDURE process_item_list(
520: p_commit IN VARCHAR2
521: ,p_operation IN VARCHAR2
522: ,p_item IN inv_ebi_item_obj_tbl
523: ,x_out OUT NOCOPY inv_ebi_item_output_obj_tbl
524: ,x_return_status OUT NOCOPY VARCHAR2
525: ,x_msg_count OUT NOCOPY NUMBER
526: ,x_msg_data OUT NOCOPY VARCHAR2
527: )
526: ,x_msg_data OUT NOCOPY VARCHAR2
527: )
528: IS
529: l_inv_ebi_item_obj inv_ebi_item_obj;
530: l_inv_ebi_item_output_obj inv_ebi_item_output_obj;
531:
532: l_part_err_msg VARCHAR2(32000);
533: l_org_code VARCHAR2(3);
534: l_is_master_org VARCHAR2(1);
547: '; Security Group id: '|| FND_GLOBAL.SECURITY_GROUP_ID ||'; User Lang: '|| USERENV('LANG') );
548: INV_EBI_UTIL.debug_line( ' **************** End of Apps Context ****************' );
549:
550: x_return_status := FND_API.G_RET_STS_SUCCESS ;
551: x_out := inv_ebi_item_output_obj_tbl();
552: IF (p_item IS NOT NULL AND p_item.count > 0) THEN
553: x_out.extend(p_item.count);
554: FOR i in 1..p_item.count
555: LOOP
566: INV_EBI_ITEM_PUB.process_item(
567: p_commit => p_commit
568: ,p_operation => p_operation
569: ,p_item => l_inv_ebi_item_obj
570: ,x_out => l_inv_ebi_item_output_obj
571: );
572: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_EBI_ITEM_PUB.process_item STATUS : '|| l_inv_ebi_item_output_obj.output_status.return_status);
573:
574:
568: ,p_operation => p_operation
569: ,p_item => l_inv_ebi_item_obj
570: ,x_out => l_inv_ebi_item_output_obj
571: );
572: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_EBI_ITEM_PUB.process_item STATUS : '|| l_inv_ebi_item_output_obj.output_status.return_status);
573:
574:
575: x_out(i) := l_inv_ebi_item_output_obj;
576: x_out(i).integration_id := l_inv_ebi_item_obj.integration_id;
571: );
572: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_EBI_ITEM_PUB.process_item STATUS : '|| l_inv_ebi_item_output_obj.output_status.return_status);
573:
574:
575: x_out(i) := l_inv_ebi_item_output_obj;
576: x_out(i).integration_id := l_inv_ebi_item_obj.integration_id;
577: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
578: x_return_status := FND_API.G_RET_STS_ERROR;
579: x_msg_count := x_out(i).output_status.msg_count;
599: INV_EBI_ITEM_PUB.process_item(
600: p_commit => p_commit
601: ,p_operation => p_operation
602: ,p_item => l_inv_ebi_item_obj
603: ,x_out => l_inv_ebi_item_output_obj
604: );
605: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING INV_EBI_ITEM_PUB.process_item STATUS : '|| l_inv_ebi_item_output_obj.output_status.return_status);
606:
607: x_out(i) := l_inv_ebi_item_output_obj;
601: ,p_operation => p_operation
602: ,p_item => l_inv_ebi_item_obj
603: ,x_out => l_inv_ebi_item_output_obj
604: );
605: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING INV_EBI_ITEM_PUB.process_item STATUS : '|| l_inv_ebi_item_output_obj.output_status.return_status);
606:
607: x_out(i) := l_inv_ebi_item_output_obj;
608: x_out(i).integration_id := l_inv_ebi_item_obj.integration_id;
609: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
603: ,x_out => l_inv_ebi_item_output_obj
604: );
605: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING INV_EBI_ITEM_PUB.process_item STATUS : '|| l_inv_ebi_item_output_obj.output_status.return_status);
606:
607: x_out(i) := l_inv_ebi_item_output_obj;
608: x_out(i).integration_id := l_inv_ebi_item_obj.integration_id;
609: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
610: x_return_status := FND_API.G_RET_STS_ERROR;
611: x_msg_count := x_out(i).output_status.msg_count;