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 16: l_is_master_org VARCHAR2(3) := FND_API.g_false;

12: ,p_item IN inv_ebi_item_obj
13: ,x_out OUT NOCOPY inv_ebi_item_output_obj
14: ) IS
15: l_master_org_id NUMBER;
16: l_is_master_org VARCHAR2(3) := FND_API.g_false;
17: l_is_new_item_request_reqd VARCHAR2(3) := FND_API.g_false;
18: l_output_status inv_ebi_output_status;
19: l_item_catalog_group_code VARCHAR2(40);
20: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;

Line 17: l_is_new_item_request_reqd VARCHAR2(3) := FND_API.g_false;

13: ,x_out OUT NOCOPY inv_ebi_item_output_obj
14: ) IS
15: l_master_org_id NUMBER;
16: l_is_master_org VARCHAR2(3) := FND_API.g_false;
17: l_is_new_item_request_reqd VARCHAR2(3) := FND_API.g_false;
18: l_output_status inv_ebi_output_status;
19: l_item_catalog_group_code VARCHAR2(40);
20: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
21: BEGIN

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

18: l_output_status inv_ebi_output_status;
19: l_item_catalog_group_code VARCHAR2(40);
20: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
21: BEGIN
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

Line 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

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

Line 36: RAISE FND_API.g_exc_error;

32:
33: IF x_out.organization_id IS NULL THEN
34: FND_MESSAGE.set_name('INV','INV_EBI_NO_DEFAULT_ORG');
35: FND_MSG_PUB.add;
36: RAISE FND_API.g_exc_error;
37: ELSE
38: l_is_master_org := FND_API.g_true;
39: END IF;
40:

Line 38: l_is_master_org := FND_API.g_true;

34: FND_MESSAGE.set_name('INV','INV_EBI_NO_DEFAULT_ORG');
35: FND_MSG_PUB.add;
36: RAISE FND_API.g_exc_error;
37: ELSE
38: l_is_master_org := FND_API.g_true;
39: END IF;
40:
41: END IF;
42:

Line 44: AND p_item.main_obj_type.organization_id <> FND_API.g_miss_num) THEN

40:
41: END IF;
42:
43: IF(p_item.main_obj_type.organization_id IS NOT NULL
44: AND p_item.main_obj_type.organization_id <> FND_API.g_miss_num) THEN
45: l_is_master_org := INV_EBI_UTIL.is_master_org(
46: p_organization_id => p_item.main_obj_type.organization_id
47: );
48:

Line 51: IF(l_is_master_org = FND_API.g_true) THEN

47: );
48:
49: END IF;
50:
51: IF(l_is_master_org = FND_API.g_true) THEN
52: l_is_new_item_request_reqd := INV_EBI_ITEM_HELPER.is_new_item_request_reqd(
53: p_item_catalog_group_id => p_item.main_obj_type.item_catalog_group_id
54: );
55:

Line 56: IF(l_is_new_item_request_reqd = FND_API.g_true) THEN

52: l_is_new_item_request_reqd := INV_EBI_ITEM_HELPER.is_new_item_request_reqd(
53: p_item_catalog_group_id => p_item.main_obj_type.item_catalog_group_id
54: );
55:
56: IF(l_is_new_item_request_reqd = FND_API.g_true) THEN
57: FND_MESSAGE.set_name('INV','INV_EBI_ICC_CONFG_FOR_NIR');
58: IF p_item.main_obj_type.item_catalog_group_code IS NULL THEN
59: l_pk_col_name_val_pairs.EXTEND(1);
60: l_pk_col_name_val_pairs(1).name := 'item_catalog_group_id';

Line 75: RAISE FND_API.g_exc_error;

71:
72: FND_MESSAGE.set_token('ITEM',p_item.main_obj_type.item_number);
73: FND_MESSAGE.set_token('ITEM_CATALOG', l_item_catalog_group_code);
74: FND_MSG_PUB.add;
75: RAISE FND_API.g_exc_error;
76:
77: END IF;
78: END IF;
79: END IF;

Line 81: WHEN FND_API.g_exc_error THEN

77: END IF;
78: END IF;
79: END IF;
80: EXCEPTION
81: WHEN FND_API.g_exc_error THEN
82: x_out.output_status.return_status := FND_API.g_ret_sts_error;
83: IF(x_out.output_status.msg_data IS NULL) THEN
84: FND_MSG_PUB.count_and_get(
85: p_encoded => FND_API.g_false

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

78: END IF;
79: END IF;
80: EXCEPTION
81: WHEN FND_API.g_exc_error THEN
82: x_out.output_status.return_status := FND_API.g_ret_sts_error;
83: IF(x_out.output_status.msg_data IS NULL) THEN
84: FND_MSG_PUB.count_and_get(
85: p_encoded => FND_API.g_false
86: ,p_count => x_out.output_status.msg_count

Line 85: p_encoded => FND_API.g_false

81: WHEN FND_API.g_exc_error THEN
82: x_out.output_status.return_status := FND_API.g_ret_sts_error;
83: IF(x_out.output_status.msg_data IS NULL) THEN
84: FND_MSG_PUB.count_and_get(
85: p_encoded => FND_API.g_false
86: ,p_count => x_out.output_status.msg_count
87: ,p_data => x_out.output_status.msg_data
88: );
89: END IF;

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

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

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

118: SAVEPOINT inv_ebi_process_item_save_pnt;
119: ERROR_HANDLER.initialize;
120: FND_MSG_PUB.initialize;
121:
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 '||

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

134: ,x_item => l_item
135: );
136: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING INV_EBI_ITEM_HELPER.populate_item_ids ');
137:
138: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
139: RAISE FND_API.g_exc_unexpected_error;
140: END IF;
141:
142: INV_EBI_UTIL.debug_line('STEP: 40 '||'START CALLING validate_item ');

Line 139: RAISE FND_API.g_exc_unexpected_error;

135: );
136: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING INV_EBI_ITEM_HELPER.populate_item_ids ');
137:
138: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
139: RAISE FND_API.g_exc_unexpected_error;
140: END IF;
141:
142: INV_EBI_UTIL.debug_line('STEP: 40 '||'START CALLING validate_item ');
143: validate_item (

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

146: ,x_out => x_out
147: );
148: INV_EBI_UTIL.debug_line('STEP: 50 '||'END CALLING validate_item ');
149:
150: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
151: RAISE FND_API.g_exc_unexpected_error;
152: END IF;
153:
154: 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 151: RAISE FND_API.g_exc_unexpected_error;

147: );
148: INV_EBI_UTIL.debug_line('STEP: 50 '||'END CALLING validate_item ');
149:
150: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
151: RAISE FND_API.g_exc_unexpected_error;
152: END IF;
153:
154: IF(l_item.main_obj_type.organization_id IS NULL OR l_item.main_obj_type.organization_id = FND_API.g_miss_num) THEN
155: l_item.main_obj_type.organization_id := x_out.organization_id;

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

150: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
151: RAISE FND_API.g_exc_unexpected_error;
152: END IF;
153:
154: IF(l_item.main_obj_type.organization_id IS NULL OR l_item.main_obj_type.organization_id = FND_API.g_miss_num) THEN
155: l_item.main_obj_type.organization_id := x_out.organization_id;
156: END IF;
157:
158: IF (l_item.main_obj_type.effectivity_date IS NULL OR

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

155: l_item.main_obj_type.organization_id := x_out.organization_id;
156: END IF;
157:
158: IF (l_item.main_obj_type.effectivity_date IS NULL OR
159: l_item.main_obj_type.effectivity_date = fnd_api.g_miss_date OR
160: l_item.main_obj_type.effectivity_date <= sysdate ) THEN
161: l_item.main_obj_type.effectivity_date := sysdate+(2/(60*60*24));
162: END IF;
163:

Line 168: p_commit => FND_API.g_false

164: --To create Production item
165: INV_EBI_UTIL.debug_line('STEP: 60 '||'START CALLING INV_EBI_ITEM_HELPER.sync_item ');
166:
167: INV_EBI_ITEM_HELPER.sync_item (
168: p_commit => FND_API.g_false
169: ,p_operation => p_operation
170: ,p_item => l_item
171: ,x_out => l_out
172: );

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

171: ,x_out => l_out
172: );
173:
174: INV_EBI_UTIL.debug_line('STEP: 70 '||'END CALLING INV_EBI_ITEM_HELPER.sync_item ');
175: IF (l_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
176: x_out.output_status.msg_data := l_out.output_status.msg_data;
177: RAISE fnd_api.g_exc_unexpected_error;
178: END IF;
179:

Line 177: RAISE fnd_api.g_exc_unexpected_error;

173:
174: INV_EBI_UTIL.debug_line('STEP: 70 '||'END CALLING INV_EBI_ITEM_HELPER.sync_item ');
175: IF (l_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
176: x_out.output_status.msg_data := l_out.output_status.msg_data;
177: RAISE fnd_api.g_exc_unexpected_error;
178: END IF;
179:
180: x_out.inventory_item_id := l_out.inventory_item_id;
181: x_out.organization_id := l_out.organization_id;

Line 199: ,p_commit => fnd_api.g_false

195: ,p_item_catalog_group_id => l_item.main_obj_type.item_catalog_group_id
196: ,p_revision_id => l_item.main_obj_type.revision_id
197: ,p_revision_code => l_item.main_obj_type.revision_code
198: ,p_uda_input_obj => l_item.uda_type
199: ,p_commit => fnd_api.g_false
200: ,x_uda_output_obj => l_out
201: );
202: END IF;
203: END IF;

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

201: );
202: END IF;
203: END IF;
204:
205: IF (l_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
206: RAISE FND_API.g_exc_unexpected_error;
207: END IF;
208:
209: x_out.uda_output := l_out.uda_output;

Line 206: RAISE FND_API.g_exc_unexpected_error;

202: END IF;
203: END IF;
204:
205: IF (l_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
206: RAISE FND_API.g_exc_unexpected_error;
207: END IF;
208:
209: x_out.uda_output := l_out.uda_output;
210:

Line 215: IF FND_API.to_boolean(p_commit) THEN

211: x_out.output_status.error_table := INV_EBI_UTIL.get_error_table();
212:
213: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);
214:
215: IF FND_API.to_boolean(p_commit) THEN
216: COMMIT;
217: END IF;
218: INV_EBI_UTIL.debug_line('STEP: 80 '||'END INSIDE INV_EBI_ITEM_HELPER.process_item '||
219: 'ORGANIZATION CODE: '||p_item.main_obj_type.organization_code||

Line 224: WHEN FND_API.g_exc_error THEN

220: 'Item Number: '||p_item.main_obj_type.item_number
221: );
222: INV_EBI_UTIL.wrapup;
223: EXCEPTION
224: WHEN FND_API.g_exc_error THEN
225: ROLLBACK TO inv_ebi_process_item_save_pnt;
226: x_out.output_status.return_status := FND_API.g_ret_sts_error;
227: IF(x_out.output_status.msg_data IS NULL) THEN
228: FND_MSG_PUB.count_and_get(

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

222: INV_EBI_UTIL.wrapup;
223: EXCEPTION
224: WHEN FND_API.g_exc_error THEN
225: ROLLBACK TO inv_ebi_process_item_save_pnt;
226: x_out.output_status.return_status := FND_API.g_ret_sts_error;
227: IF(x_out.output_status.msg_data IS NULL) THEN
228: FND_MSG_PUB.count_and_get(
229: p_encoded => FND_API.g_false
230: ,p_count => x_out.output_status.msg_count

Line 229: p_encoded => FND_API.g_false

225: ROLLBACK TO inv_ebi_process_item_save_pnt;
226: x_out.output_status.return_status := FND_API.g_ret_sts_error;
227: IF(x_out.output_status.msg_data IS NULL) THEN
228: FND_MSG_PUB.count_and_get(
229: p_encoded => FND_API.g_false
230: ,p_count => x_out.output_status.msg_count
231: ,p_data => x_out.output_status.msg_data
232: );
233: END IF;

Line 234: WHEN FND_API.g_exc_unexpected_error THEN

230: ,p_count => x_out.output_status.msg_count
231: ,p_data => x_out.output_status.msg_data
232: );
233: END IF;
234: WHEN FND_API.g_exc_unexpected_error THEN
235: ROLLBACK TO inv_ebi_process_item_save_pnt;
236: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
237: IF(x_out.output_status.msg_data IS NULL) THEN
238: FND_MSG_PUB.count_and_get(

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

232: );
233: END IF;
234: WHEN FND_API.g_exc_unexpected_error THEN
235: ROLLBACK TO inv_ebi_process_item_save_pnt;
236: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
237: IF(x_out.output_status.msg_data IS NULL) THEN
238: FND_MSG_PUB.count_and_get(
239: p_encoded => FND_API.g_false
240: ,p_count => x_out.output_status.msg_count

Line 239: p_encoded => FND_API.g_false

235: ROLLBACK TO inv_ebi_process_item_save_pnt;
236: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
237: IF(x_out.output_status.msg_data IS NULL) THEN
238: FND_MSG_PUB.count_and_get(
239: p_encoded => FND_API.g_false
240: ,p_count => x_out.output_status.msg_count
241: ,p_data => x_out.output_status.msg_data
242: );
243: END IF;

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

242: );
243: END IF;
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 ';

Line 280: x_return_status := FND_API.G_RET_STS_SUCCESS;

276: BEGIN
277: l_item_bal_input_tbl := inv_ebi_item_bal_input_tbl();
278:
279: l_items := p_items;
280: x_return_status := FND_API.G_RET_STS_SUCCESS;
281:
282: IF (l_items.item_table.COUNT > 0) THEN
283: FOR i IN l_items.item_table.FIRST..l_items.item_table.LAST LOOP
284: l_item_bal_input_tbl.extend();

Line 287: ,fnd_api.g_true

283: FOR i IN l_items.item_table.FIRST..l_items.item_table.LAST LOOP
284: l_item_bal_input_tbl.extend();
285: l_item_bal_input_obj := inv_ebi_item_bal_input_obj(
286: l_api_version
287: ,fnd_api.g_true
288: ,l_items.item_table(i).organization_id
289: ,l_items.item_table(i).inventory_item_id
290: ,inv_quantity_tree_pub.g_transaction_mode
291: ,NULL

Line 309: ,fnd_api.g_true

305: ,NULL
306: ,NULL
307: ,NULL
308: ,NULL
309: ,fnd_api.g_true
310: );
311: l_item_bal_input_tbl(i) := l_item_bal_input_obj;
312: END LOOP;
313:

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

320: ,x_msg_count => x_msg_count
321: ,x_msg_data => x_msg_data
322: );
323:
324: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
325: RAISE FND_API.g_exc_unexpected_error;
326: END IF;
327: END IF;
328:

Line 325: RAISE FND_API.g_exc_unexpected_error;

321: ,x_msg_data => x_msg_data
322: );
323:
324: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
325: RAISE FND_API.g_exc_unexpected_error;
326: END IF;
327: END IF;
328:
329: EXCEPTION

Line 330: WHEN FND_API.g_exc_unexpected_error THEN

326: END IF;
327: END IF;
328:
329: EXCEPTION
330: WHEN FND_API.g_exc_unexpected_error THEN
331: x_return_status := FND_API.g_ret_sts_error;
332: IF (x_msg_data IS NULL) THEN
333: FND_MSG_PUB.count_and_get(
334: p_encoded => FND_API.g_false

Line 331: x_return_status := FND_API.g_ret_sts_error;

327: END IF;
328:
329: EXCEPTION
330: WHEN FND_API.g_exc_unexpected_error THEN
331: x_return_status := FND_API.g_ret_sts_error;
332: IF (x_msg_data IS NULL) THEN
333: FND_MSG_PUB.count_and_get(
334: p_encoded => FND_API.g_false
335: ,p_count => x_msg_count

Line 334: p_encoded => FND_API.g_false

330: WHEN FND_API.g_exc_unexpected_error THEN
331: x_return_status := FND_API.g_ret_sts_error;
332: IF (x_msg_data IS NULL) THEN
333: FND_MSG_PUB.count_and_get(
334: p_encoded => FND_API.g_false
335: ,p_count => x_msg_count
336: ,p_data => x_msg_data
337: );
338: END IF;

Line 340: x_return_status := FND_API.g_ret_sts_unexp_error;

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

Line 436: x_return_status := FND_API.G_RET_STS_SUCCESS;

432: l_inv_ebi_item_attr_tbl_obj inv_ebi_item_attr_tbl_obj;
433: BEGIN
434: l_get_opr_attrs_tbl := inv_ebi_get_opr_attrs_tbl();
435: l_items := p_items;
436: x_return_status := FND_API.G_RET_STS_SUCCESS;
437:
438: INV_EBI_ITEM_HELPER.set_server_time_zone;
439:
440: IF (l_items.item_table.COUNT > 0) THEN

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

461: ,x_msg_count => x_msg_count
462: ,x_msg_data => x_msg_data
463: );
464:
465: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
466: RAISE FND_API.g_exc_unexpected_error;
467: END IF;
468: END IF;
469:

Line 466: RAISE FND_API.g_exc_unexpected_error;

462: ,x_msg_data => x_msg_data
463: );
464:
465: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
466: RAISE FND_API.g_exc_unexpected_error;
467: END IF;
468: END IF;
469:
470: IF(x_item_tbl_obj.item_attr_tbl IS NOT NULL AND x_item_tbl_obj.item_attr_tbl.COUNT>0) THEN

Line 483: WHEN FND_API.g_exc_unexpected_error THEN

479: END IF;
480:
481:
482: EXCEPTION
483: WHEN FND_API.g_exc_unexpected_error THEN
484: x_return_status := FND_API.g_ret_sts_error;
485: IF (x_msg_data IS NULL) THEN
486: FND_MSG_PUB.count_and_get(
487: p_encoded => FND_API.g_false

Line 484: x_return_status := FND_API.g_ret_sts_error;

480:
481:
482: EXCEPTION
483: WHEN FND_API.g_exc_unexpected_error THEN
484: x_return_status := FND_API.g_ret_sts_error;
485: IF (x_msg_data IS NULL) THEN
486: FND_MSG_PUB.count_and_get(
487: p_encoded => FND_API.g_false
488: ,p_count => x_msg_count

Line 487: p_encoded => FND_API.g_false

483: WHEN FND_API.g_exc_unexpected_error THEN
484: x_return_status := FND_API.g_ret_sts_error;
485: IF (x_msg_data IS NULL) THEN
486: FND_MSG_PUB.count_and_get(
487: p_encoded => FND_API.g_false
488: ,p_count => x_msg_count
489: ,p_data => x_msg_data);
490: END IF;
491: WHEN OTHERS THEN

Line 492: x_return_status := FND_API.g_ret_sts_unexp_error;

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

Line 526: x_return_status := FND_API.G_RET_STS_SUCCESS ;

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);
530: FOR i in 1..p_item.count

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

535: ELSE
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

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

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

Line 552: x_return_status := FND_API.G_RET_STS_ERROR;

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
552: x_return_status := FND_API.G_RET_STS_ERROR;
553: x_msg_count := x_out(i).output_status.msg_count;
554: x_msg_data := x_msg_data ||'Item Name :' || l_item_number || ' Err Msg: ' || x_out(i).output_status.msg_data;
555: RAISE FND_API.g_exc_unexpected_error;
556: END IF;

Line 555: RAISE FND_API.g_exc_unexpected_error;

551: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
552: x_return_status := FND_API.G_RET_STS_ERROR;
553: x_msg_count := x_out(i).output_status.msg_count;
554: x_msg_data := x_msg_data ||'Item Name :' || l_item_number || ' Err Msg: ' || x_out(i).output_status.msg_data;
555: RAISE FND_API.g_exc_unexpected_error;
556: END IF;
557: END IF;
558: END LOOP;
559: END IF;

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

567: ELSE
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

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

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

Line 584: x_return_status := FND_API.G_RET_STS_ERROR;

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
584: x_return_status := FND_API.G_RET_STS_ERROR;
585: x_msg_count := x_out(i).output_status.msg_count;
586: x_msg_data := x_msg_data ||'Item Name :' || l_item_number || ' Err Msg: ' || x_out(i).output_status.msg_data;
587: RAISE FND_API.g_exc_unexpected_error;
588: END IF;

Line 587: RAISE FND_API.g_exc_unexpected_error;

583: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
584: x_return_status := FND_API.G_RET_STS_ERROR;
585: x_msg_count := x_out(i).output_status.msg_count;
586: x_msg_data := x_msg_data ||'Item Name :' || l_item_number || ' Err Msg: ' || x_out(i).output_status.msg_data;
587: RAISE FND_API.g_exc_unexpected_error;
588: END IF;
589: END IF;
590: END LOOP;
591: END IF;

Line 592: IF FND_API.to_boolean(p_commit) THEN

588: END IF;
589: END IF;
590: END LOOP;
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;

Line 598: WHEN FND_API.g_exc_unexpected_error THEN

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;
600: WHEN OTHERS THEN
601: ROLLBACK TO inv_ebi_prc_itm_list_save_pnt;
602: x_return_status := FND_API.G_RET_STS_ERROR;

Line 602: x_return_status := FND_API.G_RET_STS_ERROR;

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