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_UTIL

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 20: INV_EBI_UTIL.debug_line('STEP 20: ITEM NAME : ' || p_item.main_obj_type.item_number);

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:

Line 31: INV_EBI_UTIL.debug_line('STEP 30: ORG ID : '|| x_out.organization_id);

27:
28: x_out.organization_id := INV_EBI_ITEM_HELPER.get_default_master_org(
29: p_config => p_item.name_value_tbl
30: );
31: INV_EBI_UTIL.debug_line('STEP 30: ORG ID : '|| x_out.organization_id);
32: IF x_out.organization_id IS NULL THEN
33: FND_MESSAGE.set_name('INV','INV_EBI_NO_DEFAULT_ORG');
34: FND_MSG_PUB.add;
35: RAISE FND_API.g_exc_error;

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 80: INV_EBI_UTIL.set_apps_context(p_item.name_value_tbl);

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
80: INV_EBI_UTIL.set_apps_context(p_item.name_value_tbl);
81: END IF;
82: */
83: SAVEPOINT inv_ebi_process_item_save_pnt;
84: ERROR_HANDLER.initialize;

Line 89: INV_EBI_UTIL.SETUP(); --- one time for each process.

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||
93: 'Item Number: '||p_item.main_obj_type.item_number

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 95: INV_EBI_UTIL.debug_line( ' Apps Context Details ' );

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 ****************' );
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 ****************' );

Line 96: INV_EBI_UTIL.debug_line(' User Id: ' || FND_GLOBAL.USER_ID || '; Responsibility Application id: ' ||

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:

Line 99: INV_EBI_UTIL.debug_line( ' End of Apps Context ' );

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(
103: p_item => p_item

Line 101: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING INV_EBI_ITEM_HELPER.populate_item_ids ');

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(
103: p_item => p_item
104: ,x_out => x_out
105: ,x_item => l_item

Line 107: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_EBI_ITEM_HELPER.populate_item_ids RETURN STATUS: '|| x_out.output_status.return_status);

103: p_item => p_item
104: ,x_out => x_out
105: ,x_item => l_item
106: );
107: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_EBI_ITEM_HELPER.populate_item_ids RETURN STATUS: '|| x_out.output_status.return_status);
108:
109: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
110: RAISE FND_API.g_exc_unexpected_error;
111: END IF;

Line 113: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING validate_item '||'ITEM NUMBER: '|| l_item.main_obj_type.item_number||

109: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
110: RAISE FND_API.g_exc_unexpected_error;
111: END IF;
112:
113: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING validate_item '||'ITEM NUMBER: '|| l_item.main_obj_type.item_number||
114: 'ORG CODE: '||l_item.main_obj_type.organization_code);
115: validate_item (
116: p_transaction_type => p_operation
117: ,p_item => l_item

Line 120: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING validate_item RETURN STATUS: '|| x_out.output_status.return_status);

116: p_transaction_type => p_operation
117: ,p_item => l_item
118: ,x_out => x_out
119: );
120: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING validate_item RETURN STATUS: '|| x_out.output_status.return_status);
121:
122: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
123: RAISE FND_API.g_exc_unexpected_error;
124: END IF;

Line 137: INV_EBI_UTIL.debug_line('STEP 60: BEFORE CALLING INV_EBI_ITEM_HELPER.sync_item');

133: l_item.main_obj_type.effectivity_date := sysdate+(2/(60*60*24));
134: END IF;
135:
136: --To create Production item
137: INV_EBI_UTIL.debug_line('STEP 60: BEFORE CALLING INV_EBI_ITEM_HELPER.sync_item');
138:
139: INV_EBI_ITEM_HELPER.sync_item (
140: p_commit => FND_API.g_false
141: ,p_operation => p_operation

Line 146: INV_EBI_UTIL.debug_line('STEP 70: AFTER CALLING INV_EBI_ITEM_HELPER.sync_item STATUS : '|| l_out.output_status.return_status);

142: ,p_item => l_item
143: ,x_out => l_out
144: );
145:
146: INV_EBI_UTIL.debug_line('STEP 70: AFTER CALLING INV_EBI_ITEM_HELPER.sync_item STATUS : '|| l_out.output_status.return_status);
147: IF (l_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
148: x_out.output_status.msg_data := l_out.output_status.msg_data;
149: RAISE fnd_api.g_exc_unexpected_error;
150: END IF;

Line 162: IF (INV_EBI_UTIL.is_pim_installed AND l_item.main_obj_type.item_catalog_group_id IS NOT NULL ) THEN

158: x_out.operating_unit_id := l_out.operating_unit_id;
159: x_out.description := l_out.description;
160:
161: -- To process Udas
162: IF (INV_EBI_UTIL.is_pim_installed AND l_item.main_obj_type.item_catalog_group_id IS NOT NULL ) THEN
163: IF (l_item.uda_type IS NOT NULL AND l_item.uda_type.attribute_group_tbl.COUNT > 0) THEN
164: INV_EBI_UTIL.debug_line('STEP 80: BEFORE CALLING INV_EBI_ITEM_HELPER.process_item_uda INV ITEMID: '|| x_out.inventory_item_id ||
165: 'ORG ID: '|| x_out.organization_id || 'CATALOG GRP ID: ' || l_item.main_obj_type.item_catalog_group_id );
166: INV_EBI_ITEM_HELPER.process_item_uda(

Line 164: INV_EBI_UTIL.debug_line('STEP 80: BEFORE CALLING INV_EBI_ITEM_HELPER.process_item_uda INV ITEMID: '|| x_out.inventory_item_id ||

160:
161: -- To process Udas
162: IF (INV_EBI_UTIL.is_pim_installed AND l_item.main_obj_type.item_catalog_group_id IS NOT NULL ) THEN
163: IF (l_item.uda_type IS NOT NULL AND l_item.uda_type.attribute_group_tbl.COUNT > 0) THEN
164: INV_EBI_UTIL.debug_line('STEP 80: BEFORE CALLING INV_EBI_ITEM_HELPER.process_item_uda INV ITEMID: '|| x_out.inventory_item_id ||
165: 'ORG ID: '|| x_out.organization_id || 'CATALOG GRP ID: ' || l_item.main_obj_type.item_catalog_group_id );
166: INV_EBI_ITEM_HELPER.process_item_uda(
167: p_api_version => l_api_version
168: ,p_inventory_item_id => x_out.inventory_item_id

Line 177: INV_EBI_UTIL.debug_line('STEP 90: AFTER CALLING INV_EBI_ITEM_HELPER.process_item_uda STATUS: '|| l_out.output_status.return_status);

173: ,p_uda_input_obj => l_item.uda_type
174: ,p_commit => fnd_api.g_false
175: ,x_uda_output_obj => l_out
176: );
177: INV_EBI_UTIL.debug_line('STEP 90: AFTER CALLING INV_EBI_ITEM_HELPER.process_item_uda STATUS: '|| l_out.output_status.return_status);
178: END IF;
179: END IF;
180:
181: IF (l_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN

Line 190: INV_EBI_UTIL.debug_line('STEP 100: END INSIDE INV_EBI_ITEM_HELPER.process_item STATUS : '|| x_out.output_status.return_status );

186:
187: IF FND_API.to_boolean(p_commit) THEN
188: COMMIT;
189: END IF;
190: INV_EBI_UTIL.debug_line('STEP 100: END INSIDE INV_EBI_ITEM_HELPER.process_item STATUS : '|| x_out.output_status.return_status );
191: INV_EBI_UTIL.wrapup;
192: EXCEPTION
193: WHEN FND_API.g_exc_error THEN
194: ROLLBACK TO inv_ebi_process_item_save_pnt;

Line 191: INV_EBI_UTIL.wrapup;

187: IF FND_API.to_boolean(p_commit) THEN
188: COMMIT;
189: END IF;
190: INV_EBI_UTIL.debug_line('STEP 100: END INSIDE INV_EBI_ITEM_HELPER.process_item STATUS : '|| x_out.output_status.return_status );
191: INV_EBI_UTIL.wrapup;
192: EXCEPTION
193: WHEN FND_API.g_exc_error THEN
194: ROLLBACK TO inv_ebi_process_item_save_pnt;
195: x_out.output_status.return_status := FND_API.g_ret_sts_error;

Line 206: x_out.output_status.error_table := INV_EBI_UTIL.get_error_table();

202: END IF;
203: WHEN FND_API.g_exc_unexpected_error THEN
204: ROLLBACK TO inv_ebi_process_item_save_pnt;
205: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
206: x_out.output_status.error_table := INV_EBI_UTIL.get_error_table();
207: IF (x_out.output_status.error_table IS NOT NULL AND x_out.output_status.error_table.COUNT > 0) THEN
208: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);
209: IF(x_out.output_status.msg_data IS NULL) THEN
210: FND_MSG_PUB.count_and_get(

Line 208: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);

204: ROLLBACK TO inv_ebi_process_item_save_pnt;
205: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
206: x_out.output_status.error_table := INV_EBI_UTIL.get_error_table();
207: IF (x_out.output_status.error_table IS NOT NULL AND x_out.output_status.error_table.COUNT > 0) THEN
208: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);
209: IF(x_out.output_status.msg_data IS NULL) THEN
210: FND_MSG_PUB.count_and_get(
211: p_encoded => FND_API.g_false
212: ,p_count => x_out.output_status.msg_count

Line 255: INV_EBI_UTIL.setup();

251:
252: l_items := p_items;
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: ' ||

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 258: INV_EBI_UTIL.debug_line( ' Apps Context Details ' );

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') );
262: INV_EBI_UTIL.debug_line( ' **************** End of Apps Context ****************' );

Line 259: INV_EBI_UTIL.debug_line(' User Id: ' || FND_GLOBAL.USER_ID || '; Responsibility Application id: ' ||

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:

Line 262: INV_EBI_UTIL.debug_line( ' End of Apps Context ' );

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
266: l_item_bal_input_tbl.extend();

Line 299: INV_EBI_UTIL.debug_line('STEP 20: START CALLING INV_EBI_ITEM_HELPER.get_item_balance');

295:
296: l_item_balance_input := inv_ebi_item_bal_input_list(l_item_bal_input_tbl);
297:
298:
299: INV_EBI_UTIL.debug_line('STEP 20: START CALLING INV_EBI_ITEM_HELPER.get_item_balance');
300:
301: INV_EBI_ITEM_HELPER.get_item_balance(
302: p_item_balance_input => l_item_balance_input
303: ,x_item_balance_output => x_item_balance_output

Line 309: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_EBI_ITEM_HELPER.get_item_balance STATUS: '|| x_return_status);

305: ,x_msg_count => x_msg_count
306: ,x_msg_data => x_msg_data
307: );
308:
309: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_EBI_ITEM_HELPER.get_item_balance STATUS: '|| x_return_status);
310:
311:
312: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
313: RAISE FND_API.g_exc_unexpected_error;

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 318: INV_EBI_UTIL.wrapup;

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
322: x_return_status := FND_API.g_ret_sts_error;

Line 429: INV_EBI_UTIL.set_apps_context(p_name_val_list.name_value_table);

425:
426: -- This Part of Code to set the APPS Context --BUG 8712091
427: /* IF p_name_val_list.name_value_table IS NOT NULL AND p_name_val_list.name_value_table.COUNT>0
428: THEN
429: INV_EBI_UTIL.set_apps_context(p_name_val_list.name_value_table);
430: END IF;
431: */
432: l_get_opr_attrs_tbl := inv_ebi_get_opr_attrs_tbl();
433: l_items := p_items;

Line 438: INV_EBI_UTIL.setup();

434: x_return_status := FND_API.G_RET_STS_SUCCESS;
435:
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 ****************' );

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 442: INV_EBI_UTIL.debug_line( ' Apps Context Details ' );

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 ||
445: '; Security Group id: '|| FND_GLOBAL.SECURITY_GROUP_ID ||'; User Lang: '|| USERENV('LANG') );
446: INV_EBI_UTIL.debug_line( ' **************** End of Apps Context ****************' );

Line 443: INV_EBI_UTIL.debug_line(' User Id: ' || FND_GLOBAL.USER_ID || '; Responsibility Application id: ' ||

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:

Line 446: INV_EBI_UTIL.debug_line( ' End of Apps Context ' );

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
450: l_get_opr_attrs_tbl.extend();

Line 467: INV_EBI_UTIL.debug_line('STEP 20: START CALLING INV_EBI_ITEM_HELPER.get_item_attributes');

463: l_get_item_inp_obj := inv_ebi_get_item_input(l_get_opr_attrs_tbl,p_name_val_list.name_value_table);
464:
465:
466:
467: INV_EBI_UTIL.debug_line('STEP 20: START CALLING INV_EBI_ITEM_HELPER.get_item_attributes');
468:
469: INV_EBI_ITEM_HELPER.get_item_attributes(
470: p_get_item_inp_obj => l_get_item_inp_obj
471: ,x_item_tbl_obj => x_item_tbl_obj

Line 477: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_EBI_ITEM_HELPER.get_item_attributes STATU S: '|| x_return_status);

473: ,x_msg_count => x_msg_count
474: ,x_msg_data => x_msg_data
475: );
476:
477: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_EBI_ITEM_HELPER.get_item_attributes STATU S: '|| x_return_status);
478:
479: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
480: RAISE FND_API.g_exc_unexpected_error;
481: END IF;

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 496: INV_EBI_UTIL.wrapup;

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
500: x_return_status := FND_API.g_ret_sts_error;

Line 540: INV_EBI_UTIL.setup();

536: BEGIN
537: SAVEPOINT inv_ebi_prc_itm_list_save_pnt;
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 ****************' );

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 544: INV_EBI_UTIL.debug_line( ' Apps Context Details ' );

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 ||
547: '; Security Group id: '|| FND_GLOBAL.SECURITY_GROUP_ID ||'; User Lang: '|| USERENV('LANG') );
548: INV_EBI_UTIL.debug_line( ' **************** End of Apps Context ****************' );

Line 545: INV_EBI_UTIL.debug_line(' User Id: ' || FND_GLOBAL.USER_ID || '; Responsibility Application id: ' ||

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:

Line 548: INV_EBI_UTIL.debug_line( ' End of Apps Context ' );

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();
552: IF (p_item IS NOT NULL AND p_item.count > 0) THEN

Line 558: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_id);

554: FOR i in 1..p_item.count
555: LOOP
556: l_inv_ebi_item_obj := p_item(i);
557: IF l_inv_ebi_item_obj.main_obj_type.organization_id IS NOT NULL THEN
558: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_id);
559: ELSE
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;

Line 560: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_code);

556: l_inv_ebi_item_obj := p_item(i);
557: IF l_inv_ebi_item_obj.main_obj_type.organization_id IS NOT NULL THEN
558: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_id);
559: ELSE
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 ||

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 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 592: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_id);

588: FOR i in 1..p_item.count
589: LOOP
590: l_inv_ebi_item_obj := p_item(i);
591: IF l_inv_ebi_item_obj.main_obj_type.organization_id IS NOT NULL THEN
592: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_id);
593: ELSE
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;

Line 594: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_code);

590: l_inv_ebi_item_obj := p_item(i);
591: IF l_inv_ebi_item_obj.main_obj_type.organization_id IS NOT NULL THEN
592: l_is_master_org := INV_EBI_UTIL.is_master_org(l_inv_ebi_item_obj.main_obj_type.organization_id);
593: ELSE
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');

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 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 622: INV_EBI_UTIL.wrapup;

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;
626: WHEN OTHERS THEN