DBA Data[Home] [Help]

APPS.INV_EBI_ITEM_PUB dependencies on INV_EBI_ITEM_OUTPUT_OBJ

Line 13: ,x_out OUT NOCOPY inv_ebi_item_output_obj

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;
17: l_is_new_item_request_reqd VARCHAR2(3) := FND_API.g_false;

Line 23: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);

19: l_item_catalog_group_code VARCHAR2(40);
20: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
21: BEGIN
22: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
23: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
24: FND_MSG_PUB.initialize;
25: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
26: IF(p_transaction_type = INV_EBI_ITEM_PUB.g_otype_create) THEN
27: IF(p_item.main_obj_type.organization_id IS NULL OR p_item.main_obj_type.organization_id = fnd_api.g_miss_num) THEN

Line 109: ,x_out OUT NOCOPY inv_ebi_item_output_obj

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;
113: l_output_status inv_ebi_output_status;

Line 115: l_out inv_ebi_item_output_obj;

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:
117: BEGIN
118: SAVEPOINT inv_ebi_process_item_save_pnt;
119: ERROR_HANDLER.initialize;

Line 123: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);

119: ERROR_HANDLER.initialize;
120: FND_MSG_PUB.initialize;
121:
122: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
123: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
124: INV_EBI_UTIL.SETUP(); --- one time for each process.
125:
126: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_PUB.process_item '||
127: 'ORGANIZATION CODE: '||p_item.main_obj_type.organization_code||

Line 507: ,x_out OUT NOCOPY inv_ebi_item_output_obj_tbl

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
511: )

Line 514: l_inv_ebi_item_output_obj inv_ebi_item_output_obj;

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);
518: l_is_master_org VARCHAR2(1);

Line 527: x_out := inv_ebi_item_output_obj_tbl();

523: FND_MSG_PUB.initialize;
524: INV_EBI_UTIL.setup();
525: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_ITEM_PUB.process_item_list');
526: x_return_status := FND_API.G_RET_STS_SUCCESS ;
527: x_out := inv_ebi_item_output_obj_tbl();
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

Line 545: ,x_out => l_inv_ebi_item_output_obj

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:
549: x_out(i) := l_inv_ebi_item_output_obj;

Line 549: x_out(i) := l_inv_ebi_item_output_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:
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;

Line 577: ,x_out => l_inv_ebi_item_output_obj

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:
581: x_out(i) := l_inv_ebi_item_output_obj;

Line 581: x_out(i) := l_inv_ebi_item_output_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:
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;