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 FND_API

Line 21: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

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:
25: IF(p_transaction_type = INV_EBI_ITEM_PUB.g_otype_create) THEN

Line 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

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
30: );

Line 35: RAISE FND_API.g_exc_error;

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

Line 41: WHEN FND_API.g_exc_error THEN

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
44: FND_MSG_PUB.count_and_get(
45: p_encoded => FND_API.g_false

Line 42: x_out.output_status.return_status := FND_API.g_ret_sts_error;

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
44: FND_MSG_PUB.count_and_get(
45: p_encoded => FND_API.g_false
46: ,p_count => x_out.output_status.msg_count

Line 45: p_encoded => FND_API.g_false

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
44: FND_MSG_PUB.count_and_get(
45: p_encoded => FND_API.g_false
46: ,p_count => x_out.output_status.msg_count
47: ,p_data => x_out.output_status.msg_data
48: );
49: END IF;

Line 51: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

47: ,p_data => x_out.output_status.msg_data
48: );
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 ';

Line 87: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

83: SAVEPOINT inv_ebi_process_item_save_pnt;
84: ERROR_HANDLER.initialize;
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 '||

Line 109: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

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;
112:
113: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING validate_item '||'ITEM NUMBER: '|| l_item.main_obj_type.item_number||

Line 110: RAISE FND_API.g_exc_unexpected_error;

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

Line 122: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

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;
125:
126: IF(l_item.main_obj_type.organization_id IS NULL OR l_item.main_obj_type.organization_id = FND_API.g_miss_num) THEN

Line 123: RAISE FND_API.g_exc_unexpected_error;

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;
125:
126: IF(l_item.main_obj_type.organization_id IS NULL OR l_item.main_obj_type.organization_id = FND_API.g_miss_num) THEN
127: l_item.main_obj_type.organization_id := x_out.organization_id;

Line 126: IF(l_item.main_obj_type.organization_id IS NULL OR l_item.main_obj_type.organization_id = FND_API.g_miss_num) THEN

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;
125:
126: IF(l_item.main_obj_type.organization_id IS NULL OR l_item.main_obj_type.organization_id = FND_API.g_miss_num) THEN
127: l_item.main_obj_type.organization_id := x_out.organization_id;
128: END IF;
129:
130: IF (l_item.main_obj_type.effectivity_date IS NULL OR

Line 131: l_item.main_obj_type.effectivity_date = fnd_api.g_miss_date OR

127: l_item.main_obj_type.organization_id := x_out.organization_id;
128: END IF;
129:
130: IF (l_item.main_obj_type.effectivity_date IS NULL OR
131: l_item.main_obj_type.effectivity_date = fnd_api.g_miss_date OR
132: l_item.main_obj_type.effectivity_date <= sysdate ) THEN
133: l_item.main_obj_type.effectivity_date := sysdate+(2/(60*60*24));
134: END IF;
135:

Line 140: p_commit => FND_API.g_false

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
142: ,p_item => l_item
143: ,x_out => l_out
144: );

Line 147: IF (l_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN

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

Line 149: RAISE fnd_api.g_exc_unexpected_error;

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;
151:
152: x_out.inventory_item_id := l_out.inventory_item_id;
153: x_out.organization_id := l_out.organization_id;

Line 174: ,p_commit => fnd_api.g_false

170: ,p_item_catalog_group_id => l_item.main_obj_type.item_catalog_group_id
171: ,p_revision_id => l_item.main_obj_type.revision_id
172: ,p_revision_code => l_item.main_obj_type.revision_code
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;

Line 181: IF (l_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN

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
182: RAISE FND_API.g_exc_unexpected_error;
183: END IF;
184:
185: x_out.uda_output := l_out.uda_output;

Line 182: RAISE FND_API.g_exc_unexpected_error;

178: END IF;
179: END IF;
180:
181: IF (l_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
182: RAISE FND_API.g_exc_unexpected_error;
183: END IF;
184:
185: x_out.uda_output := l_out.uda_output;
186:

Line 187: IF FND_API.to_boolean(p_commit) THEN

183: END IF;
184:
185: x_out.uda_output := l_out.uda_output;
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;

Line 193: WHEN FND_API.g_exc_error THEN

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;
196: IF(x_out.output_status.msg_data IS NULL) THEN
197: FND_MSG_PUB.count_and_get(

Line 195: x_out.output_status.return_status := FND_API.g_ret_sts_error;

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;
196: IF(x_out.output_status.msg_data IS NULL) THEN
197: FND_MSG_PUB.count_and_get(
198: p_encoded => FND_API.g_false
199: ,p_count => x_out.output_status.msg_count

Line 198: p_encoded => FND_API.g_false

194: ROLLBACK TO inv_ebi_process_item_save_pnt;
195: x_out.output_status.return_status := FND_API.g_ret_sts_error;
196: IF(x_out.output_status.msg_data IS NULL) THEN
197: FND_MSG_PUB.count_and_get(
198: p_encoded => FND_API.g_false
199: ,p_count => x_out.output_status.msg_count
200: ,p_data => x_out.output_status.msg_data
201: );
202: END IF;

Line 203: WHEN FND_API.g_exc_unexpected_error THEN

199: ,p_count => x_out.output_status.msg_count
200: ,p_data => x_out.output_status.msg_data
201: );
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

Line 205: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

201: );
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

Line 211: p_encoded => FND_API.g_false

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
213: ,p_data => x_out.output_status.msg_data
214: );
215: END IF;

Line 219: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

215: END IF;
216: END IF;
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 ';

Line 253: x_return_status := FND_API.G_RET_STS_SUCCESS;

249: BEGIN
250: l_item_bal_input_tbl := inv_ebi_item_bal_input_tbl();
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');

Line 269: ,fnd_api.g_true

265: FOR i IN l_items.item_table.FIRST..l_items.item_table.LAST LOOP
266: l_item_bal_input_tbl.extend();
267: l_item_bal_input_obj := inv_ebi_item_bal_input_obj(
268: l_api_version
269: ,fnd_api.g_true
270: ,l_items.item_table(i).organization_id
271: ,l_items.item_table(i).inventory_item_id
272: ,inv_quantity_tree_pub.g_transaction_mode
273: ,NULL

Line 291: ,fnd_api.g_true

287: ,NULL
288: ,NULL
289: ,NULL
290: ,NULL
291: ,fnd_api.g_true
292: );
293: l_item_bal_input_tbl(i) := l_item_bal_input_obj;
294: END LOOP;
295:

Line 312: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;
314: END IF;
315: END IF;
316:

Line 313: RAISE FND_API.g_exc_unexpected_error;

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;
314: END IF;
315: END IF;
316:
317: INV_EBI_UTIL.debug_line('STEP 40: END INSIDE INV_EBI_ITEM_PUB.get_item_balance');

Line 321: WHEN FND_API.g_exc_unexpected_error THEN

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;
323: IF (x_msg_data IS NULL) THEN
324: FND_MSG_PUB.count_and_get(
325: p_encoded => FND_API.g_false

Line 322: x_return_status := FND_API.g_ret_sts_error;

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;
323: IF (x_msg_data IS NULL) THEN
324: FND_MSG_PUB.count_and_get(
325: p_encoded => FND_API.g_false
326: ,p_count => x_msg_count

Line 325: p_encoded => FND_API.g_false

321: WHEN FND_API.g_exc_unexpected_error THEN
322: x_return_status := FND_API.g_ret_sts_error;
323: IF (x_msg_data IS NULL) THEN
324: FND_MSG_PUB.count_and_get(
325: p_encoded => FND_API.g_false
326: ,p_count => x_msg_count
327: ,p_data => x_msg_data
328: );
329: END IF;

Line 331: x_return_status := FND_API.g_ret_sts_unexp_error;

327: ,p_data => x_msg_data
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

Line 434: x_return_status := FND_API.G_RET_STS_SUCCESS;

430: END IF;
431: */
432: l_get_opr_attrs_tbl := inv_ebi_get_opr_attrs_tbl();
433: l_items := p_items;
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();

Line 479: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;
482: END IF;
483:

Line 480: RAISE FND_API.g_exc_unexpected_error;

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;
482: END IF;
483:
484: IF(x_item_tbl_obj.item_attr_tbl IS NOT NULL AND x_item_tbl_obj.item_attr_tbl.COUNT>0) THEN

Line 499: WHEN FND_API.g_exc_unexpected_error THEN

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;
501: IF (x_msg_data IS NULL) THEN
502: FND_MSG_PUB.count_and_get(
503: p_encoded => FND_API.g_false

Line 500: x_return_status := FND_API.g_ret_sts_error;

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;
501: IF (x_msg_data IS NULL) THEN
502: FND_MSG_PUB.count_and_get(
503: p_encoded => FND_API.g_false
504: ,p_count => x_msg_count

Line 503: p_encoded => FND_API.g_false

499: WHEN FND_API.g_exc_unexpected_error THEN
500: x_return_status := FND_API.g_ret_sts_error;
501: IF (x_msg_data IS NULL) THEN
502: FND_MSG_PUB.count_and_get(
503: p_encoded => FND_API.g_false
504: ,p_count => x_msg_count
505: ,p_data => x_msg_data);
506: END IF;
507: WHEN OTHERS THEN

Line 508: x_return_status := FND_API.g_ret_sts_unexp_error;

504: ,p_count => x_msg_count
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: /************************************************************************************

Line 550: x_return_status := FND_API.G_RET_STS_SUCCESS ;

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
553: x_out.extend(p_item.count);
554: FOR i in 1..p_item.count

Line 563: IF(l_is_master_org = fnd_api.g_true ) THEN

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

Line 577: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN

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;
577: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
578: x_return_status := FND_API.G_RET_STS_ERROR;
579: x_msg_count := x_out(i).output_status.msg_count;
580: x_msg_data := x_msg_data ||'Item Name :' || l_item_number || ' Err Msg: ' || x_out(i).output_status.msg_data;
581: RAISE FND_API.g_exc_unexpected_error;

Line 578: x_return_status := FND_API.G_RET_STS_ERROR;

574:
575: x_out(i) := l_inv_ebi_item_output_obj;
576: x_out(i).integration_id := l_inv_ebi_item_obj.integration_id;
577: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
578: x_return_status := FND_API.G_RET_STS_ERROR;
579: x_msg_count := x_out(i).output_status.msg_count;
580: x_msg_data := x_msg_data ||'Item Name :' || l_item_number || ' Err Msg: ' || x_out(i).output_status.msg_data;
581: RAISE FND_API.g_exc_unexpected_error;
582: END IF;

Line 581: RAISE FND_API.g_exc_unexpected_error;

577: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
578: x_return_status := FND_API.G_RET_STS_ERROR;
579: x_msg_count := x_out(i).output_status.msg_count;
580: x_msg_data := x_msg_data ||'Item Name :' || l_item_number || ' Err Msg: ' || x_out(i).output_status.msg_data;
581: RAISE FND_API.g_exc_unexpected_error;
582: END IF;
583: END IF;
584: END LOOP;
585: END IF;

Line 597: IF(l_is_master_org = fnd_api.g_false ) THEN

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');
599: INV_EBI_ITEM_PUB.process_item(
600: p_commit => p_commit
601: ,p_operation => p_operation

Line 609: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN

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
610: x_return_status := FND_API.G_RET_STS_ERROR;
611: x_msg_count := x_out(i).output_status.msg_count;
612: x_msg_data := x_msg_data ||'Item Name :' || l_item_number || ' Err Msg: ' || x_out(i).output_status.msg_data;
613: RAISE FND_API.g_exc_unexpected_error;

Line 610: x_return_status := FND_API.G_RET_STS_ERROR;

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
610: x_return_status := FND_API.G_RET_STS_ERROR;
611: x_msg_count := x_out(i).output_status.msg_count;
612: x_msg_data := x_msg_data ||'Item Name :' || l_item_number || ' Err Msg: ' || x_out(i).output_status.msg_data;
613: RAISE FND_API.g_exc_unexpected_error;
614: END IF;

Line 613: RAISE FND_API.g_exc_unexpected_error;

609: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
610: x_return_status := FND_API.G_RET_STS_ERROR;
611: x_msg_count := x_out(i).output_status.msg_count;
612: x_msg_data := x_msg_data ||'Item Name :' || l_item_number || ' Err Msg: ' || x_out(i).output_status.msg_data;
613: RAISE FND_API.g_exc_unexpected_error;
614: END IF;
615: END IF;
616: END LOOP;
617: END IF;

Line 618: IF FND_API.to_boolean(p_commit) THEN

614: END IF;
615: END IF;
616: END LOOP;
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;

Line 624: WHEN FND_API.g_exc_unexpected_error THEN

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
627: ROLLBACK TO inv_ebi_prc_itm_list_save_pnt;
628: x_return_status := FND_API.G_RET_STS_ERROR;

Line 628: x_return_status := FND_API.G_RET_STS_ERROR;

624: WHEN FND_API.g_exc_unexpected_error THEN
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;