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.40 2009/10/27 07:23:40 prcheru noship $ */
3:
4: /************************************************************************************
5: -- API name : validate_item

Line 19: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_ITEM_PUB.validate_item');

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;

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

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

Line 39: INV_EBI_UTIL.debug_line('STEP 40: END INSIDE INV_EBI_ITEM_PUB.validate_item STATUS: '|| x_out.output_status.return_status);

35: RAISE FND_API.g_exc_error;
36: END IF;
37: END IF;
38: END IF;
39: INV_EBI_UTIL.debug_line('STEP 40: END INSIDE INV_EBI_ITEM_PUB.validate_item STATUS: '|| x_out.output_status.return_status);
40: EXCEPTION
41: WHEN FND_API.g_exc_error THEN
42: x_out.output_status.return_status := FND_API.g_ret_sts_error;
43: IF(x_out.output_status.msg_data IS NULL) THEN

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

49: END IF;
50: WHEN OTHERS THEN
51: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
52: IF (x_out.output_status.msg_data IS NOT NULL) THEN
53: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_ITEM_PUB.validate_item ';
54: ELSE
55: x_out.output_status.msg_data := SQLERRM||' INV_EBI_ITEM_PUB.validate_item ';
56: END IF;
57: END validate_item;

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

51: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
52: IF (x_out.output_status.msg_data IS NOT NULL) THEN
53: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_ITEM_PUB.validate_item ';
54: ELSE
55: x_out.output_status.msg_data := SQLERRM||' INV_EBI_ITEM_PUB.validate_item ';
56: END IF;
57: END validate_item;
58:
59: /************************************************************************************

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

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||
93: 'Item Number: '||p_item.main_obj_type.item_number
94: );
95: INV_EBI_UTIL.debug_line( ' **************** Apps Context Details ****************' );

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

217: WHEN OTHERS THEN
218: ROLLBACK TO inv_ebi_process_item_save_pnt;
219: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
220: IF (x_out.output_status.msg_data IS NOT NULL) THEN
221: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_ITEM_PUB.process_item ';
222: ELSE
223: x_out.output_status.msg_data := SQLERRM ||' INV_EBI_ITEM_PUB.process_item ';
224: END IF;
225: END process_item;

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

219: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
220: IF (x_out.output_status.msg_data IS NOT NULL) THEN
221: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_ITEM_PUB.process_item ';
222: ELSE
223: x_out.output_status.msg_data := SQLERRM ||' INV_EBI_ITEM_PUB.process_item ';
224: END IF;
225: END process_item;
226:
227: /************************************************************************************

Line 257: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_ITEM_PUB.get_item_balance');

253: x_return_status := FND_API.G_RET_STS_SUCCESS;
254:
255: INV_EBI_UTIL.setup();
256:
257: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_ITEM_PUB.get_item_balance');
258: INV_EBI_UTIL.debug_line( ' **************** Apps Context Details ****************' );
259: INV_EBI_UTIL.debug_line(' User Id: ' || FND_GLOBAL.USER_ID || '; Responsibility Application id: ' ||
260: FND_GLOBAL.RESP_APPL_ID || '; Responsibility Id: ' || FND_GLOBAL.RESP_ID ||
261: '; Security Group id: '|| FND_GLOBAL.SECURITY_GROUP_ID ||'; User Lang: '|| USERENV('LANG') );

Line 317: INV_EBI_UTIL.debug_line('STEP 40: END INSIDE INV_EBI_ITEM_PUB.get_item_balance');

313: RAISE FND_API.g_exc_unexpected_error;
314: END IF;
315: END IF;
316:
317: INV_EBI_UTIL.debug_line('STEP 40: END INSIDE INV_EBI_ITEM_PUB.get_item_balance');
318: INV_EBI_UTIL.wrapup;
319:
320: EXCEPTION
321: WHEN FND_API.g_exc_unexpected_error THEN

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

328: );
329: END IF;
330: WHEN OTHERS THEN
331: x_return_status := FND_API.g_ret_sts_unexp_error;
332: x_msg_data := SQLERRM ||' at INV_EBI_ITEM_PUB.get_item_balance';
333: END get_item_balance;
334: /************************************************************************************
335: -- API name : Convert_date_str
336: -- Type : Public

Line 440: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_ITEM_PUB.get_item_attributes');

436: INV_EBI_ITEM_HELPER.set_server_time_zone;
437:
438: INV_EBI_UTIL.setup();
439:
440: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_ITEM_PUB.get_item_attributes');
441:
442: INV_EBI_UTIL.debug_line( ' **************** Apps Context Details ****************' );
443: INV_EBI_UTIL.debug_line(' User Id: ' || FND_GLOBAL.USER_ID || '; Responsibility Application id: ' ||
444: FND_GLOBAL.RESP_APPL_ID || '; Responsibility Id: ' || FND_GLOBAL.RESP_ID ||

Line 495: INV_EBI_UTIL.debug_line('STEP 40: END INSIDE INV_EBI_ITEM_PUB.get_item_attributes');

491: Convert_date_str(p_item_tbl_obj => l_inv_ebi_item_attr_tbl_obj
492: ,x_item_tbl_obj => x_item_tbl_obj);
493: END IF;
494:
495: INV_EBI_UTIL.debug_line('STEP 40: END INSIDE INV_EBI_ITEM_PUB.get_item_attributes');
496: INV_EBI_UTIL.wrapup;
497:
498: EXCEPTION
499: WHEN FND_API.g_exc_unexpected_error THEN

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

505: ,p_data => x_msg_data);
506: END IF;
507: WHEN OTHERS THEN
508: x_return_status := FND_API.g_ret_sts_unexp_error;
509: x_msg_data := SQLERRM ||' at INV_EBI_ITEM_PUB.get_item_attributes';
510: END get_item_attributes;
511:
512: /************************************************************************************
513: -- API name : process_item_list

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

538: ERROR_HANDLER.Initialize;
539: FND_MSG_PUB.initialize;
540: INV_EBI_UTIL.setup();
541:
542: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_ITEM_PUB.process_item_list');
543:
544: INV_EBI_UTIL.debug_line( ' **************** Apps Context Details ****************' );
545: INV_EBI_UTIL.debug_line(' User Id: ' || FND_GLOBAL.USER_ID || '; Responsibility Application id: ' ||
546: FND_GLOBAL.RESP_APPL_ID || '; Responsibility Id: ' || FND_GLOBAL.RESP_ID ||

Line 564: INV_EBI_UTIL.debug_line('STEP 20: START CALLING INV_EBI_ITEM_PUB.process_item for '|| 'ITEM NUMBER: '|| l_inv_ebi_item_obj.main_obj_type.item_number ||

560: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_code);
561: END IF;
562: l_item_number := l_inv_ebi_item_obj.main_obj_type.item_number;
563: IF(l_is_master_org = fnd_api.g_true ) THEN
564: INV_EBI_UTIL.debug_line('STEP 20: START CALLING INV_EBI_ITEM_PUB.process_item for '|| 'ITEM NUMBER: '|| l_inv_ebi_item_obj.main_obj_type.item_number ||
565: 'ORG CODE: '|| l_inv_ebi_item_obj.main_obj_type.organization_code);
566: INV_EBI_ITEM_PUB.process_item(
567: p_commit => p_commit
568: ,p_operation => p_operation

Line 566: INV_EBI_ITEM_PUB.process_item(

562: l_item_number := l_inv_ebi_item_obj.main_obj_type.item_number;
563: IF(l_is_master_org = fnd_api.g_true ) THEN
564: INV_EBI_UTIL.debug_line('STEP 20: START CALLING INV_EBI_ITEM_PUB.process_item for '|| 'ITEM NUMBER: '|| l_inv_ebi_item_obj.main_obj_type.item_number ||
565: 'ORG CODE: '|| l_inv_ebi_item_obj.main_obj_type.organization_code);
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

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

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;

Line 598: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING INV_EBI_ITEM_PUB.process_item');

594: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_code);
595: END IF;
596: l_item_number := l_inv_ebi_item_obj.main_obj_type.item_number;
597: IF(l_is_master_org = fnd_api.g_false ) THEN
598: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING INV_EBI_ITEM_PUB.process_item');
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

Line 599: INV_EBI_ITEM_PUB.process_item(

595: END IF;
596: l_item_number := l_inv_ebi_item_obj.main_obj_type.item_number;
597: IF(l_is_master_org = fnd_api.g_false ) THEN
598: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING INV_EBI_ITEM_PUB.process_item');
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

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

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

Line 621: INV_EBI_UTIL.debug_line('STEP 60: END INSIDE INV_EBI_ITEM_PUB.process_item_list STATUS : '|| x_return_status);

617: END IF;
618: IF FND_API.to_boolean(p_commit) THEN
619: COMMIT;
620: END IF;
621: INV_EBI_UTIL.debug_line('STEP 60: END INSIDE INV_EBI_ITEM_PUB.process_item_list STATUS : '|| x_return_status);
622: INV_EBI_UTIL.wrapup;
623: EXCEPTION
624: WHEN FND_API.g_exc_unexpected_error THEN
625: ROLLBACK TO inv_ebi_prc_itm_list_save_pnt;

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

625: ROLLBACK TO inv_ebi_prc_itm_list_save_pnt;
626: WHEN OTHERS THEN
627: ROLLBACK TO inv_ebi_prc_itm_list_save_pnt;
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: x_msg_data := SQLERRM|| 'INV_EBI_ITEM_PUB.process_item_list';
630: END process_item_list;
631: END INV_EBI_ITEM_PUB;

Line 631: END INV_EBI_ITEM_PUB;

627: ROLLBACK TO inv_ebi_prc_itm_list_save_pnt;
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: x_msg_data := SQLERRM|| 'INV_EBI_ITEM_PUB.process_item_list';
630: END process_item_list;
631: END INV_EBI_ITEM_PUB;