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 ****************' );
96: INV_EBI_UTIL.debug_line(' User Id: ' || FND_GLOBAL.USER_ID || '; Responsibility Application id: ' ||
97: FND_GLOBAL.RESP_APPL_ID || '; Responsibility Id: ' || FND_GLOBAL.RESP_ID ||
98: '; Security Group id: '|| FND_GLOBAL.SECURITY_GROUP_ID ||'; User Lang: '|| USERENV('LANG') );
99: INV_EBI_UTIL.debug_line( ' **************** End of Apps Context ****************' );
100:
93: 'Item Number: '||p_item.main_obj_type.item_number
94: );
95: INV_EBI_UTIL.debug_line( ' **************** Apps Context Details ****************' );
96: INV_EBI_UTIL.debug_line(' User Id: ' || FND_GLOBAL.USER_ID || '; Responsibility Application id: ' ||
97: FND_GLOBAL.RESP_APPL_ID || '; Responsibility Id: ' || FND_GLOBAL.RESP_ID ||
98: '; Security Group id: '|| FND_GLOBAL.SECURITY_GROUP_ID ||'; User Lang: '|| USERENV('LANG') );
99: INV_EBI_UTIL.debug_line( ' **************** End of Apps Context ****************' );
100:
101: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING INV_EBI_ITEM_HELPER.populate_item_ids ');
94: );
95: INV_EBI_UTIL.debug_line( ' **************** Apps Context Details ****************' );
96: INV_EBI_UTIL.debug_line(' User Id: ' || FND_GLOBAL.USER_ID || '; Responsibility Application id: ' ||
97: FND_GLOBAL.RESP_APPL_ID || '; Responsibility Id: ' || FND_GLOBAL.RESP_ID ||
98: '; Security Group id: '|| FND_GLOBAL.SECURITY_GROUP_ID ||'; User Lang: '|| USERENV('LANG') );
99: INV_EBI_UTIL.debug_line( ' **************** End of Apps Context ****************' );
100:
101: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING INV_EBI_ITEM_HELPER.populate_item_ids ');
102: INV_EBI_ITEM_HELPER.populate_item_ids(
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') );
262: INV_EBI_UTIL.debug_line( ' **************** End of Apps Context ****************' );
263:
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') );
262: INV_EBI_UTIL.debug_line( ' **************** End of Apps Context ****************' );
263:
264: IF (l_items.item_table.COUNT > 0) THEN
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') );
262: INV_EBI_UTIL.debug_line( ' **************** End of Apps Context ****************' );
263:
264: IF (l_items.item_table.COUNT > 0) THEN
265: FOR i IN l_items.item_table.FIRST..l_items.item_table.LAST LOOP
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 ||
445: '; Security Group id: '|| FND_GLOBAL.SECURITY_GROUP_ID ||'; User Lang: '|| USERENV('LANG') );
446: INV_EBI_UTIL.debug_line( ' **************** End of Apps Context ****************' );
447:
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 ||
445: '; Security Group id: '|| FND_GLOBAL.SECURITY_GROUP_ID ||'; User Lang: '|| USERENV('LANG') );
446: INV_EBI_UTIL.debug_line( ' **************** End of Apps Context ****************' );
447:
448: IF (l_items.item_table.COUNT > 0) THEN
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 ||
445: '; Security Group id: '|| FND_GLOBAL.SECURITY_GROUP_ID ||'; User Lang: '|| USERENV('LANG') );
446: INV_EBI_UTIL.debug_line( ' **************** End of Apps Context ****************' );
447:
448: IF (l_items.item_table.COUNT > 0) THEN
449: FOR i IN l_items.item_table.FIRST..l_items.item_table.LAST LOOP
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 ||
547: '; Security Group id: '|| FND_GLOBAL.SECURITY_GROUP_ID ||'; User Lang: '|| USERENV('LANG') );
548: INV_EBI_UTIL.debug_line( ' **************** End of Apps Context ****************' );
549:
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 ||
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 ;
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 ||
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();