DBA Data[Home] [Help]

APPS.INV_EBI_UTIL dependencies on FND_API

Line 64: RETURN FND_API.g_true;

60: FROM mtl_parameters
61: WHERE organization_id = p_organization_id;
62:
63: IF(l_master_org = p_organization_id) THEN
64: RETURN FND_API.g_true;
65: ELSE
66: RETURN FND_API.g_false;
67: END IF;
68: EXCEPTION

Line 66: RETURN FND_API.g_false;

62:
63: IF(l_master_org = p_organization_id) THEN
64: RETURN FND_API.g_true;
65: ELSE
66: RETURN FND_API.g_false;
67: END IF;
68: EXCEPTION
69: WHEN OTHERS THEN
70: RETURN FND_API.g_false;

Line 70: RETURN FND_API.g_false;

66: RETURN FND_API.g_false;
67: END IF;
68: EXCEPTION
69: WHEN OTHERS THEN
70: RETURN FND_API.g_false;
71: END is_master_org;
72:
73: /************************************************************************************
74: -- API name : is_master_org

Line 89: RETURN FND_API.g_true;

85: WHERE organization_id = master_organization_id
86: AND organization_code = p_organization_code;
87:
88: IF(l_master_org > 0) THEN
89: RETURN FND_API.g_true;
90: ELSE
91: RETURN FND_API.g_false;
92: END IF;
93: EXCEPTION

Line 91: RETURN FND_API.g_false;

87:
88: IF(l_master_org > 0) THEN
89: RETURN FND_API.g_true;
90: ELSE
91: RETURN FND_API.g_false;
92: END IF;
93: EXCEPTION
94: WHEN OTHERS THEN
95: RETURN FND_API.g_false;

Line 95: RETURN FND_API.g_false;

91: RETURN FND_API.g_false;
92: END IF;
93: EXCEPTION
94: WHEN OTHERS THEN
95: RETURN FND_API.g_false;
96: END is_master_org;
97:
98: /************************************************************************************
99: -- API name : get_master_organization

Line 270: x_return_status := FND_API.G_RET_STS_SUCCESS;

266: l_attribute_group_obj inv_ebi_uda_attr_grp_obj;
267: l_attribute_obj inv_ebi_uda_attr_obj;
268: l_attr_count NUMBER := 0;
269: BEGIN
270: x_return_status := FND_API.G_RET_STS_SUCCESS;
271: IF (p_uda_input_obj IS NOT NULL AND p_uda_input_obj.attribute_group_tbl IS NOT NULL AND
272: p_uda_input_obj.attribute_group_tbl.COUNT > 0 ) THEN
273: l_attributes_row_table := ego_user_attr_row_table();
274: l_attributes_data_table := ego_user_attr_data_table();

Line 289: RAISE FND_API.g_exc_error;

285: IF(l_attribute_group_obj.attr_group_app_id IS NULL ) THEN
286: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');
287: FND_MESSAGE.set_token('COL_VALUE', l_attribute_group_obj.application_short_name);
288: FND_MSG_PUB.add;
289: RAISE FND_API.g_exc_error;
290: END IF;
291: --End Bug 7240247
292:
293: END IF;

Line 307: RAISE FND_API.g_exc_error;

303: IF(l_attribute_group_obj.attr_group_id IS NULL ) THEN
304: FND_MESSAGE.set_name('INV','INV_EBI_ATTR_GROUP_INVALID');
305: FND_MESSAGE.set_token('COL_VALUE', l_attribute_group_obj.attr_group_short_name);
306: FND_MSG_PUB.add;
307: RAISE FND_API.g_exc_error;
308: END IF;
309: --End Bug 7240247
310:
311: END IF;

Line 356: WHEN FND_API.g_exc_error THEN

352: x_attributes_row_table := l_attributes_row_table;
353: x_attributes_data_table := l_attributes_data_table;
354:
355: EXCEPTION
356: WHEN FND_API.g_exc_error THEN
357:
358: x_return_status := FND_API.g_ret_sts_error;
359: IF(x_msg_data IS NULL) THEN
360: fnd_msg_pub.count_and_get(

Line 358: x_return_status := FND_API.g_ret_sts_error;

354:
355: EXCEPTION
356: WHEN FND_API.g_exc_error THEN
357:
358: x_return_status := FND_API.g_ret_sts_error;
359: IF(x_msg_data IS NULL) THEN
360: fnd_msg_pub.count_and_get(
361: p_encoded => FND_API.g_false
362: ,p_count => x_msg_count

Line 361: p_encoded => FND_API.g_false

357:
358: x_return_status := FND_API.g_ret_sts_error;
359: IF(x_msg_data IS NULL) THEN
360: fnd_msg_pub.count_and_get(
361: p_encoded => FND_API.g_false
362: ,p_count => x_msg_count
363: ,p_data => x_msg_data
364: );
365: END IF;

Line 368: x_return_status := FND_API.g_ret_sts_unexp_error;

364: );
365: END IF;
366: WHEN OTHERS THEN
367:
368: x_return_status := FND_API.g_ret_sts_unexp_error;
369: IF (x_msg_data IS NOT NULL) THEN
370: x_msg_data := x_msg_data||' ->INV_EBI_UTIL.transform_uda ';
371: ELSE
372: x_msg_data := SQLERRM||'INV_EBI_UTIL.transform_uda ';

Line 397: x_return_status := FND_API.G_RET_STS_SUCCESS;

393: l_attr_grp_obj inv_ebi_uda_attr_grp_obj;
394: l_attr_grp_tbl inv_ebi_uda_attr_grp_tbl;
395: l_count NUMBER := 0;
396: BEGIN
397: x_return_status := FND_API.G_RET_STS_SUCCESS;
398: IF ( p_attributes_row_table IS NOT NULL AND p_attributes_row_table.COUNT > 0
399: AND p_attributes_data_table IS NOT NULL AND p_attributes_data_table.COUNT >0 ) THEN
400:
401: l_attr_grp_tbl := inv_ebi_uda_attr_grp_tbl();

Line 461: x_return_status := FND_API.g_ret_sts_unexp_error;

457:
458: END IF;
459: EXCEPTION
460: WHEN OTHERS THEN
461: x_return_status := FND_API.g_ret_sts_unexp_error;
462: IF (x_msg_data IS NOT NULL) THEN
463: x_msg_data := x_msg_data||' ->INV_EBI_UTIL.transform_attr_rowdata_uda ';
464: ELSE
465: x_msg_data := SQLERRM||'INV_EBI_UTIL.transform_attr_rowdata_uda ';