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_PUB

Line 1: PACKAGE BODY INV_EBI_ITEM_PUB AS

1: PACKAGE BODY INV_EBI_ITEM_PUB AS
2: /* $Header: INVEIPITB.pls 120.24.12010000.7 2009/02/19 11:21:36 prepatel ship $ */
3:
4: /************************************************************************************
5: -- API name : validate_item

Line 26: IF(p_transaction_type = INV_EBI_ITEM_PUB.g_otype_create) THEN

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
28:
29: x_out.organization_id := INV_EBI_ITEM_HELPER.get_default_master_org(
30: p_config => p_item.name_value_tbl

Line 93: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_ITEM_PUB.validate_item ';

89: END IF;
90: WHEN OTHERS THEN
91: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
92: IF (x_out.output_status.msg_data IS NOT NULL) THEN
93: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_ITEM_PUB.validate_item ';
94: ELSE
95: x_out.output_status.msg_data := SQLERRM||' INV_EBI_ITEM_PUB.validate_item ';
96: END IF;
97: END validate_item;

Line 95: x_out.output_status.msg_data := SQLERRM||' INV_EBI_ITEM_PUB.validate_item ';

91: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
92: IF (x_out.output_status.msg_data IS NOT NULL) THEN
93: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_ITEM_PUB.validate_item ';
94: ELSE
95: x_out.output_status.msg_data := SQLERRM||' INV_EBI_ITEM_PUB.validate_item ';
96: END IF;
97: END validate_item;
98:
99: /************************************************************************************

Line 126: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_PUB.process_item '||

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||
128: 'Item Number: '||p_item.main_obj_type.item_number
129: );
130: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING INV_EBI_ITEM_HELPER.populate_item_ids ');

Line 248: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_ITEM_PUB.process_item ';

244: WHEN OTHERS THEN
245: ROLLBACK TO inv_ebi_process_item_save_pnt;
246: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
247: IF (x_out.output_status.msg_data IS NOT NULL) THEN
248: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_ITEM_PUB.process_item ';
249: ELSE
250: x_out.output_status.msg_data := SQLERRM ||' INV_EBI_ITEM_PUB.process_item ';
251: END IF;
252: END process_item;

Line 250: x_out.output_status.msg_data := SQLERRM ||' INV_EBI_ITEM_PUB.process_item ';

246: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
247: IF (x_out.output_status.msg_data IS NOT NULL) THEN
248: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_ITEM_PUB.process_item ';
249: ELSE
250: x_out.output_status.msg_data := SQLERRM ||' INV_EBI_ITEM_PUB.process_item ';
251: END IF;
252: END process_item;
253:
254: /************************************************************************************

Line 341: x_msg_data := SQLERRM ||' at INV_EBI_ITEM_PUB.get_item_balance';

337: );
338: END IF;
339: WHEN OTHERS THEN
340: x_return_status := FND_API.g_ret_sts_unexp_error;
341: x_msg_data := SQLERRM ||' at INV_EBI_ITEM_PUB.get_item_balance';
342: END get_item_balance;
343: /************************************************************************************
344: -- API name : Convert_date_str
345: -- Type : Public

Line 493: x_msg_data := SQLERRM ||' at INV_EBI_ITEM_PUB.get_item_attributes';

489: ,p_data => x_msg_data);
490: END IF;
491: WHEN OTHERS THEN
492: x_return_status := FND_API.g_ret_sts_unexp_error;
493: x_msg_data := SQLERRM ||' at INV_EBI_ITEM_PUB.get_item_attributes';
494: END get_item_attributes;
495:
496: /************************************************************************************
497: -- API name : process_item_list

Line 525: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_ITEM_PUB.process_item_list');

521: SAVEPOINT inv_ebi_prc_itm_list_save_pnt;
522: ERROR_HANDLER.Initialize;
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);

Line 540: INV_EBI_UTIL.debug_line('STEP: 20 START CALLING INV_EBI_ITEM_PUB.process_item for ');

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
543: ,p_operation => p_operation
544: ,p_item => l_inv_ebi_item_obj

Line 541: INV_EBI_ITEM_PUB.process_item(

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
543: ,p_operation => p_operation
544: ,p_item => l_inv_ebi_item_obj
545: ,x_out => l_inv_ebi_item_output_obj

Line 547: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING INV_EBI_ITEM_PUB.process_item for ');

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;
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

Line 572: INV_EBI_UTIL.debug_line('STEP: 20 START CALLING INV_EBI_ITEM_PUB.process_item for ');

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
575: ,p_operation => p_operation
576: ,p_item => l_inv_ebi_item_obj

Line 573: INV_EBI_ITEM_PUB.process_item(

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
575: ,p_operation => p_operation
576: ,p_item => l_inv_ebi_item_obj
577: ,x_out => l_inv_ebi_item_output_obj

Line 579: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING INV_EBI_ITEM_PUB.process_item for ');

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;
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

Line 595: INV_EBI_UTIL.debug_line('STEP: 40 END INSIDE INV_EBI_ITEM_PUB.process_item_list');

591: END IF;
592: IF FND_API.to_boolean(p_commit) THEN
593: COMMIT;
594: END IF;
595: INV_EBI_UTIL.debug_line('STEP: 40 END INSIDE INV_EBI_ITEM_PUB.process_item_list');
596: INV_EBI_UTIL.wrapup;
597: EXCEPTION
598: WHEN FND_API.g_exc_unexpected_error THEN
599: ROLLBACK TO inv_ebi_prc_itm_list_save_pnt;

Line 603: x_msg_data := SQLERRM|| 'INV_EBI_ITEM_PUB.process_item_list';

599: ROLLBACK TO inv_ebi_prc_itm_list_save_pnt;
600: WHEN OTHERS THEN
601: ROLLBACK TO inv_ebi_prc_itm_list_save_pnt;
602: x_return_status := FND_API.G_RET_STS_ERROR;
603: x_msg_data := SQLERRM|| 'INV_EBI_ITEM_PUB.process_item_list';
604: END process_item_list;
605: END INV_EBI_ITEM_PUB;

Line 605: END INV_EBI_ITEM_PUB;

601: ROLLBACK TO inv_ebi_prc_itm_list_save_pnt;
602: x_return_status := FND_API.G_RET_STS_ERROR;
603: x_msg_data := SQLERRM|| 'INV_EBI_ITEM_PUB.process_item_list';
604: END process_item_list;
605: END INV_EBI_ITEM_PUB;