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.AK_OBJECT_GRP dependencies on FND_API

Line 23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

19: -- Version Initial version number = 1.0
20: -- History Current version number = 1.0
21: --=======================================================
22: procedure CREATE_ATTRIBUTE (
23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: p_api_version_number IN NUMBER,
25: p_init_msg_tbl IN BOOLEAN := FALSE,
26: p_msg_count OUT NOCOPY NUMBER,
27: p_msg_data OUT NOCOPY VARCHAR2,

Line 32: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

28: p_return_status OUT NOCOPY VARCHAR2,
29: p_database_object_name IN VARCHAR2,
30: p_attribute_application_id IN NUMBER,
31: p_attribute_code IN VARCHAR2,
32: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_attribute_label_length IN NUMBER,
34: p_display_value_length IN NUMBER,
35: p_bold IN VARCHAR2,
36: p_italic IN VARCHAR2,

Line 40: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

36: p_italic IN VARCHAR2,
37: p_vertical_alignment IN VARCHAR2,
38: p_horizontal_alignment IN VARCHAR2,
39: p_data_source_type IN VARCHAR2,
40: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_required_flag IN VARCHAR2,
44: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 41: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

37: p_vertical_alignment IN VARCHAR2,
38: p_horizontal_alignment IN VARCHAR2,
39: p_data_source_type IN VARCHAR2,
40: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_required_flag IN VARCHAR2,
44: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,

Line 42: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

38: p_horizontal_alignment IN VARCHAR2,
39: p_data_source_type IN VARCHAR2,
40: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_required_flag IN VARCHAR2,
44: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
46: p_default_value_date IN DATE := FND_API.G_MISS_DATE,

Line 44: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

40: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_required_flag IN VARCHAR2,
44: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
46: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
47: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
48: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 45: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,

41: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_required_flag IN VARCHAR2,
44: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
46: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
47: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
48: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 46: p_default_value_date IN DATE := FND_API.G_MISS_DATE,

42: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_required_flag IN VARCHAR2,
44: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
46: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
47: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
48: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 47: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

43: p_required_flag IN VARCHAR2,
44: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
46: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
47: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
48: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
51: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 48: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

44: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
46: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
47: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
48: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
51: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 49: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

45: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
46: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
47: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
48: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
51: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 50: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,

46: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
47: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
48: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
51: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 51: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

47: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
48: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
51: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 52: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

48: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
51: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 53: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

49: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
51: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 54: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

50: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
51: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 55: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

51: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
59: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 56: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,

52: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
59: p_creation_date IN DATE := FND_API.G_MISS_DATE,
60: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 57: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,

53: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
59: p_creation_date IN DATE := FND_API.G_MISS_DATE,
60: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
61: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 58: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

54: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
59: p_creation_date IN DATE := FND_API.G_MISS_DATE,
60: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
61: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
62: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

Line 59: p_creation_date IN DATE := FND_API.G_MISS_DATE,

55: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
59: p_creation_date IN DATE := FND_API.G_MISS_DATE,
60: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
61: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
62: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
63: ) is

Line 60: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

56: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
59: p_creation_date IN DATE := FND_API.G_MISS_DATE,
60: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
61: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
62: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
63: ) is
64: l_api_version_number CONSTANT number := 1.0;

Line 61: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

57: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
59: p_creation_date IN DATE := FND_API.G_MISS_DATE,
60: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
61: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
62: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
63: ) is
64: l_api_version_number CONSTANT number := 1.0;
65: l_api_name CONSTANT varchar2(30) := 'Create_Attribute';

Line 62: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

58: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
59: p_creation_date IN DATE := FND_API.G_MISS_DATE,
60: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
61: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
62: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
63: ) is
64: l_api_version_number CONSTANT number := 1.0;
65: l_api_name CONSTANT varchar2(30) := 'Create_Attribute';
66: l_return_status VARCHAR2(1);

Line 71: IF NOT FND_API.Compatible_API_Call (

67: l_pass NUMBER := 2;
68: l_copy_redo_flag BOOLEAN := FALSE;
69: begin
70: -- Check API version number
71: IF NOT FND_API.Compatible_API_Call (
72: l_api_version_number, p_api_version_number, l_api_name,
73: G_PKG_NAME) then
74: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75: return;

Line 74: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

70: -- Check API version number
71: IF NOT FND_API.Compatible_API_Call (
72: l_api_version_number, p_api_version_number, l_api_name,
73: G_PKG_NAME) then
74: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75: return;
76: END IF;
77:
78: -- Initialize the message table if requested.

Line 132: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

128: p_copy_redo_flag => l_copy_redo_flag
129: );
130:
131: -- If API call returns with an error status...
132: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
133: (l_return_status = FND_API.G_RET_STS_ERROR) then
134: -- dbms_output.put_line(l_api_name || ' Create_Attribute failed');
135: RAISE FND_API.G_EXC_ERROR;
136: end if;

Line 133: (l_return_status = FND_API.G_RET_STS_ERROR) then

129: );
130:
131: -- If API call returns with an error status...
132: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
133: (l_return_status = FND_API.G_RET_STS_ERROR) then
134: -- dbms_output.put_line(l_api_name || ' Create_Attribute failed');
135: RAISE FND_API.G_EXC_ERROR;
136: end if;
137:

Line 135: RAISE FND_API.G_EXC_ERROR;

131: -- If API call returns with an error status...
132: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
133: (l_return_status = FND_API.G_RET_STS_ERROR) then
134: -- dbms_output.put_line(l_api_name || ' Create_Attribute failed');
135: RAISE FND_API.G_EXC_ERROR;
136: end if;
137:
138: p_return_status := FND_API.G_RET_STS_SUCCESS;
139:

Line 138: p_return_status := FND_API.G_RET_STS_SUCCESS;

134: -- dbms_output.put_line(l_api_name || ' Create_Attribute failed');
135: RAISE FND_API.G_EXC_ERROR;
136: end if;
137:
138: p_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: EXCEPTION
141: WHEN FND_API.G_EXC_ERROR THEN
142: p_return_status := FND_API.G_RET_STS_ERROR;

Line 141: WHEN FND_API.G_EXC_ERROR THEN

137:
138: p_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: EXCEPTION
141: WHEN FND_API.G_EXC_ERROR THEN
142: p_return_status := FND_API.G_RET_STS_ERROR;
143: rollback to start_create_attribute;
144: WHEN OTHERS THEN
145: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 142: p_return_status := FND_API.G_RET_STS_ERROR;

138: p_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: EXCEPTION
141: WHEN FND_API.G_EXC_ERROR THEN
142: p_return_status := FND_API.G_RET_STS_ERROR;
143: rollback to start_create_attribute;
144: WHEN OTHERS THEN
145: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 145: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

141: WHEN FND_API.G_EXC_ERROR THEN
142: p_return_status := FND_API.G_RET_STS_ERROR;
143: rollback to start_create_attribute;
144: WHEN OTHERS THEN
145: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
147: SUBSTR (SQLERRM, 1, 240) );
148: FND_MSG_PUB.Add;
149: rollback to start_create_attribute;

Line 172: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

168: -- Version Initial version number = 1.0
169: -- History Current version number = 1.0
170: --=======================================================
171: procedure CREATE_ATTRIBUTE_NAVIGATION (
172: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173: p_api_version_number IN NUMBER,
174: p_init_msg_tbl IN BOOLEAN := FALSE,
175: p_msg_count OUT NOCOPY NUMBER,
176: p_msg_data OUT NOCOPY VARCHAR2,

Line 181: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

177: p_return_status OUT NOCOPY VARCHAR2,
178: p_database_object_name IN VARCHAR2,
179: p_attribute_application_id IN NUMBER,
180: p_attribute_code IN VARCHAR2,
181: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_value_date IN DATE ,
183: p_value_number IN NUMBER,
184: p_to_region_appl_id IN NUMBER,
185: p_to_region_code IN VARCHAR2,

Line 186: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

182: p_value_date IN DATE ,
183: p_value_number IN NUMBER,
184: p_to_region_appl_id IN NUMBER,
185: p_to_region_code IN VARCHAR2,
186: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
187: p_creation_date IN DATE := FND_API.G_MISS_DATE,
188: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
189: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
190: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

Line 187: p_creation_date IN DATE := FND_API.G_MISS_DATE,

183: p_value_number IN NUMBER,
184: p_to_region_appl_id IN NUMBER,
185: p_to_region_code IN VARCHAR2,
186: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
187: p_creation_date IN DATE := FND_API.G_MISS_DATE,
188: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
189: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
190: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
191: ) is

Line 188: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

184: p_to_region_appl_id IN NUMBER,
185: p_to_region_code IN VARCHAR2,
186: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
187: p_creation_date IN DATE := FND_API.G_MISS_DATE,
188: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
189: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
190: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
191: ) is
192: l_api_version_number CONSTANT number := 1.0;

Line 189: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

185: p_to_region_code IN VARCHAR2,
186: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
187: p_creation_date IN DATE := FND_API.G_MISS_DATE,
188: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
189: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
190: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
191: ) is
192: l_api_version_number CONSTANT number := 1.0;
193: l_api_name CONSTANT varchar2(30) := 'Create_Attribute_Navigation';

Line 190: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

186: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
187: p_creation_date IN DATE := FND_API.G_MISS_DATE,
188: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
189: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
190: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
191: ) is
192: l_api_version_number CONSTANT number := 1.0;
193: l_api_name CONSTANT varchar2(30) := 'Create_Attribute_Navigation';
194: l_return_status VARCHAR2(1);

Line 199: IF NOT FND_API.Compatible_API_Call (

195: l_pass NUMBER := 2;
196: l_copy_redo_flag BOOLEAN := FALSE;
197: begin
198: -- Check API version number
199: IF NOT FND_API.Compatible_API_Call (
200: l_api_version_number, p_api_version_number, l_api_name,
201: G_PKG_NAME) then
202: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: return;

Line 202: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

198: -- Check API version number
199: IF NOT FND_API.Compatible_API_Call (
200: l_api_version_number, p_api_version_number, l_api_name,
201: G_PKG_NAME) then
202: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: return;
204: END IF;
205:
206: -- Initialize the message table if requested.

Line 239: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

235: p_copy_redo_flag => l_copy_redo_flag
236: );
237:
238: -- If API call returns with an error status...
239: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
240: (l_return_status = FND_API.G_RET_STS_ERROR) then
241: --dbms_output.put_line(l_api_name || ' Create_Attribute_Navigation failed');
242: RAISE FND_API.G_EXC_ERROR;
243: end if;

Line 240: (l_return_status = FND_API.G_RET_STS_ERROR) then

236: );
237:
238: -- If API call returns with an error status...
239: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
240: (l_return_status = FND_API.G_RET_STS_ERROR) then
241: --dbms_output.put_line(l_api_name || ' Create_Attribute_Navigation failed');
242: RAISE FND_API.G_EXC_ERROR;
243: end if;
244:

Line 242: RAISE FND_API.G_EXC_ERROR;

238: -- If API call returns with an error status...
239: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
240: (l_return_status = FND_API.G_RET_STS_ERROR) then
241: --dbms_output.put_line(l_api_name || ' Create_Attribute_Navigation failed');
242: RAISE FND_API.G_EXC_ERROR;
243: end if;
244:
245: p_return_status := FND_API.G_RET_STS_SUCCESS;
246:

Line 245: p_return_status := FND_API.G_RET_STS_SUCCESS;

241: --dbms_output.put_line(l_api_name || ' Create_Attribute_Navigation failed');
242: RAISE FND_API.G_EXC_ERROR;
243: end if;
244:
245: p_return_status := FND_API.G_RET_STS_SUCCESS;
246:
247: EXCEPTION
248: WHEN FND_API.G_EXC_ERROR THEN
249: p_return_status := FND_API.G_RET_STS_ERROR;

Line 248: WHEN FND_API.G_EXC_ERROR THEN

244:
245: p_return_status := FND_API.G_RET_STS_SUCCESS;
246:
247: EXCEPTION
248: WHEN FND_API.G_EXC_ERROR THEN
249: p_return_status := FND_API.G_RET_STS_ERROR;
250: rollback to start_create_navigation;
251: WHEN OTHERS THEN
252: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 249: p_return_status := FND_API.G_RET_STS_ERROR;

245: p_return_status := FND_API.G_RET_STS_SUCCESS;
246:
247: EXCEPTION
248: WHEN FND_API.G_EXC_ERROR THEN
249: p_return_status := FND_API.G_RET_STS_ERROR;
250: rollback to start_create_navigation;
251: WHEN OTHERS THEN
252: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
253: rollback to start_create_navigation;

Line 252: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

248: WHEN FND_API.G_EXC_ERROR THEN
249: p_return_status := FND_API.G_RET_STS_ERROR;
250: rollback to start_create_navigation;
251: WHEN OTHERS THEN
252: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
253: rollback to start_create_navigation;
254: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
255: SUBSTR (SQLERRM, 1, 240) );
256: FND_MSG_PUB.Add;

Line 279: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

275: -- Version Initial version number = 1.0
276: -- History Current version number = 1.0
277: --=======================================================
278: procedure CREATE_ATTRIBUTE_VALUE (
279: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
280: p_api_version_number IN NUMBER,
281: p_init_msg_tbl IN BOOLEAN := FALSE,
282: p_msg_count OUT NOCOPY NUMBER,
283: p_msg_data OUT NOCOPY VARCHAR2,

Line 289: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

285: p_database_object_name IN VARCHAR2,
286: p_attribute_application_id IN NUMBER,
287: p_attribute_code IN VARCHAR2,
288: p_key_value1 IN VARCHAR2,
289: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 290: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

286: p_attribute_application_id IN NUMBER,
287: p_attribute_code IN VARCHAR2,
288: p_key_value1 IN VARCHAR2,
289: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 291: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

287: p_attribute_code IN VARCHAR2,
288: p_key_value1 IN VARCHAR2,
289: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 292: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

288: p_key_value1 IN VARCHAR2,
289: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 293: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

289: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 294: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

290: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 295: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

291: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_value_date IN DATE := FND_API.G_MISS_DATE,

Line 296: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

292: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_value_date IN DATE := FND_API.G_MISS_DATE,
300: p_value_number IN NUMBER := FND_API.G_MISS_NUM,

Line 297: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

293: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_value_date IN DATE := FND_API.G_MISS_DATE,
300: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
301: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 298: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

294: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_value_date IN DATE := FND_API.G_MISS_DATE,
300: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
301: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
302: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 299: p_value_date IN DATE := FND_API.G_MISS_DATE,

295: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_value_date IN DATE := FND_API.G_MISS_DATE,
300: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
301: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
302: p_creation_date IN DATE := FND_API.G_MISS_DATE,
303: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 300: p_value_number IN NUMBER := FND_API.G_MISS_NUM,

296: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_value_date IN DATE := FND_API.G_MISS_DATE,
300: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
301: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
302: p_creation_date IN DATE := FND_API.G_MISS_DATE,
303: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
304: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 301: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

297: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_value_date IN DATE := FND_API.G_MISS_DATE,
300: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
301: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
302: p_creation_date IN DATE := FND_API.G_MISS_DATE,
303: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
304: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
305: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

Line 302: p_creation_date IN DATE := FND_API.G_MISS_DATE,

298: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_value_date IN DATE := FND_API.G_MISS_DATE,
300: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
301: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
302: p_creation_date IN DATE := FND_API.G_MISS_DATE,
303: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
304: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
305: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
306: ) is

Line 303: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

299: p_value_date IN DATE := FND_API.G_MISS_DATE,
300: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
301: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
302: p_creation_date IN DATE := FND_API.G_MISS_DATE,
303: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
304: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
305: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
306: ) is
307: l_api_version_number CONSTANT number := 1.0;

Line 304: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

300: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
301: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
302: p_creation_date IN DATE := FND_API.G_MISS_DATE,
303: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
304: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
305: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
306: ) is
307: l_api_version_number CONSTANT number := 1.0;
308: l_api_name CONSTANT varchar2(30) := 'Create_Attribute_Value';

Line 305: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

301: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
302: p_creation_date IN DATE := FND_API.G_MISS_DATE,
303: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
304: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
305: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
306: ) is
307: l_api_version_number CONSTANT number := 1.0;
308: l_api_name CONSTANT varchar2(30) := 'Create_Attribute_Value';
309: l_return_status VARCHAR2(1);

Line 312: IF NOT FND_API.Compatible_API_Call (

308: l_api_name CONSTANT varchar2(30) := 'Create_Attribute_Value';
309: l_return_status VARCHAR2(1);
310: begin
311: -- Check API version number
312: IF NOT FND_API.Compatible_API_Call (
313: l_api_version_number, p_api_version_number, l_api_name,
314: G_PKG_NAME) then
315: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
316: return;

Line 315: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

311: -- Check API version number
312: IF NOT FND_API.Compatible_API_Call (
313: l_api_version_number, p_api_version_number, l_api_name,
314: G_PKG_NAME) then
315: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
316: return;
317: END IF;
318:
319: -- Initialize the message table if requested.

Line 358: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

354: p_last_update_login => p_lasT_update_login
355: );
356:
357: -- If API call returns with an error status...
358: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
359: (l_return_status = FND_API.G_RET_STS_ERROR) then
360: --dbms_output.put_line(l_api_name || ' Create_Attribute_Value failed');
361: RAISE FND_API.G_EXC_ERROR;
362: end if;

Line 359: (l_return_status = FND_API.G_RET_STS_ERROR) then

355: );
356:
357: -- If API call returns with an error status...
358: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
359: (l_return_status = FND_API.G_RET_STS_ERROR) then
360: --dbms_output.put_line(l_api_name || ' Create_Attribute_Value failed');
361: RAISE FND_API.G_EXC_ERROR;
362: end if;
363:

Line 361: RAISE FND_API.G_EXC_ERROR;

357: -- If API call returns with an error status...
358: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
359: (l_return_status = FND_API.G_RET_STS_ERROR) then
360: --dbms_output.put_line(l_api_name || ' Create_Attribute_Value failed');
361: RAISE FND_API.G_EXC_ERROR;
362: end if;
363:
364: p_return_status := FND_API.G_RET_STS_SUCCESS;
365:

Line 364: p_return_status := FND_API.G_RET_STS_SUCCESS;

360: --dbms_output.put_line(l_api_name || ' Create_Attribute_Value failed');
361: RAISE FND_API.G_EXC_ERROR;
362: end if;
363:
364: p_return_status := FND_API.G_RET_STS_SUCCESS;
365:
366: EXCEPTION
367: WHEN FND_API.G_EXC_ERROR THEN
368: p_return_status := FND_API.G_RET_STS_ERROR;

Line 367: WHEN FND_API.G_EXC_ERROR THEN

363:
364: p_return_status := FND_API.G_RET_STS_SUCCESS;
365:
366: EXCEPTION
367: WHEN FND_API.G_EXC_ERROR THEN
368: p_return_status := FND_API.G_RET_STS_ERROR;
369: rollback to start_create_value;
370: WHEN OTHERS THEN
371: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 368: p_return_status := FND_API.G_RET_STS_ERROR;

364: p_return_status := FND_API.G_RET_STS_SUCCESS;
365:
366: EXCEPTION
367: WHEN FND_API.G_EXC_ERROR THEN
368: p_return_status := FND_API.G_RET_STS_ERROR;
369: rollback to start_create_value;
370: WHEN OTHERS THEN
371: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
372: rollback to start_create_value;

Line 371: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

367: WHEN FND_API.G_EXC_ERROR THEN
368: p_return_status := FND_API.G_RET_STS_ERROR;
369: rollback to start_create_value;
370: WHEN OTHERS THEN
371: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
372: rollback to start_create_value;
373: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
374: SUBSTR (SQLERRM, 1, 240) );
375: FND_MSG_PUB.Add;

Line 396: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

392: -- Version Initial version number = 1.0
393: -- History Current version number = 1.0
394: --=======================================================
395: procedure CREATE_OBJECT (
396: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
397: p_api_version_number IN NUMBER,
398: p_init_msg_tbl IN BOOLEAN := FALSE,
399: p_msg_count OUT NOCOPY NUMBER,
400: p_msg_data OUT NOCOPY VARCHAR2,

Line 403: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

399: p_msg_count OUT NOCOPY NUMBER,
400: p_msg_data OUT NOCOPY VARCHAR2,
401: p_return_status OUT NOCOPY VARCHAR2,
402: p_database_object_name IN VARCHAR2,
403: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
404: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
405: p_application_id IN NUMBER,
406: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
407: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 404: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

400: p_msg_data OUT NOCOPY VARCHAR2,
401: p_return_status OUT NOCOPY VARCHAR2,
402: p_database_object_name IN VARCHAR2,
403: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
404: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
405: p_application_id IN NUMBER,
406: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
407: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
408: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 406: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

402: p_database_object_name IN VARCHAR2,
403: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
404: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
405: p_application_id IN NUMBER,
406: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
407: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
408: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
409: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
410: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 407: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

403: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
404: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
405: p_application_id IN NUMBER,
406: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
407: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
408: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
409: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
410: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
411: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 408: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

404: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
405: p_application_id IN NUMBER,
406: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
407: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
408: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
409: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
410: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
411: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
412: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 409: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

405: p_application_id IN NUMBER,
406: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
407: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
408: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
409: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
410: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
411: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
412: p_creation_date IN DATE := FND_API.G_MISS_DATE,
413: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 410: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

406: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
407: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
408: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
409: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
410: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
411: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
412: p_creation_date IN DATE := FND_API.G_MISS_DATE,
413: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
414: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 411: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

407: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
408: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
409: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
410: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
411: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
412: p_creation_date IN DATE := FND_API.G_MISS_DATE,
413: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
414: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
415: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

Line 412: p_creation_date IN DATE := FND_API.G_MISS_DATE,

408: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
409: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
410: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
411: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
412: p_creation_date IN DATE := FND_API.G_MISS_DATE,
413: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
414: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
415: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
416: ) is

Line 413: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

409: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
410: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
411: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
412: p_creation_date IN DATE := FND_API.G_MISS_DATE,
413: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
414: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
415: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
416: ) is
417: l_api_version_number CONSTANT number := 1.0;

Line 414: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

410: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
411: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
412: p_creation_date IN DATE := FND_API.G_MISS_DATE,
413: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
414: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
415: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
416: ) is
417: l_api_version_number CONSTANT number := 1.0;
418: l_api_name CONSTANT varchar2(30) := 'Create_Object';

Line 415: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

411: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
412: p_creation_date IN DATE := FND_API.G_MISS_DATE,
413: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
414: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
415: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
416: ) is
417: l_api_version_number CONSTANT number := 1.0;
418: l_api_name CONSTANT varchar2(30) := 'Create_Object';
419: l_return_status VARCHAR2(1);

Line 424: IF NOT FND_API.Compatible_API_Call (

420: l_pass NUMBER := 2;
421: l_copy_redo_flag BOOLEAN := FALSE;
422: begin
423: -- Check API version number
424: IF NOT FND_API.Compatible_API_Call (
425: l_api_version_number, p_api_version_number, l_api_name,
426: G_PKG_NAME) then
427: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: return;

Line 427: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

423: -- Check API version number
424: IF NOT FND_API.Compatible_API_Call (
425: l_api_version_number, p_api_version_number, l_api_name,
426: G_PKG_NAME) then
427: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: return;
429: END IF;
430:
431: -- Initialize the message table if requested.

Line 465: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

461: p_copy_redo_flag => l_copy_redo_flag
462: );
463:
464: -- If API call returns with an error status...
465: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
466: (l_return_status = FND_API.G_RET_STS_ERROR) then
467: --dbms_output.put_line(l_api_name || ' Create_Object failed');
468: RAISE FND_API.G_EXC_ERROR;
469: end if;

Line 466: (l_return_status = FND_API.G_RET_STS_ERROR) then

462: );
463:
464: -- If API call returns with an error status...
465: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
466: (l_return_status = FND_API.G_RET_STS_ERROR) then
467: --dbms_output.put_line(l_api_name || ' Create_Object failed');
468: RAISE FND_API.G_EXC_ERROR;
469: end if;
470:

Line 468: RAISE FND_API.G_EXC_ERROR;

464: -- If API call returns with an error status...
465: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
466: (l_return_status = FND_API.G_RET_STS_ERROR) then
467: --dbms_output.put_line(l_api_name || ' Create_Object failed');
468: RAISE FND_API.G_EXC_ERROR;
469: end if;
470:
471: p_return_status := FND_API.G_RET_STS_SUCCESS;
472:

Line 471: p_return_status := FND_API.G_RET_STS_SUCCESS;

467: --dbms_output.put_line(l_api_name || ' Create_Object failed');
468: RAISE FND_API.G_EXC_ERROR;
469: end if;
470:
471: p_return_status := FND_API.G_RET_STS_SUCCESS;
472:
473: EXCEPTION
474: WHEN FND_API.G_EXC_ERROR THEN
475: p_return_status := FND_API.G_RET_STS_ERROR;

Line 474: WHEN FND_API.G_EXC_ERROR THEN

470:
471: p_return_status := FND_API.G_RET_STS_SUCCESS;
472:
473: EXCEPTION
474: WHEN FND_API.G_EXC_ERROR THEN
475: p_return_status := FND_API.G_RET_STS_ERROR;
476: rollback to start_create_object;
477: WHEN OTHERS THEN
478: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 475: p_return_status := FND_API.G_RET_STS_ERROR;

471: p_return_status := FND_API.G_RET_STS_SUCCESS;
472:
473: EXCEPTION
474: WHEN FND_API.G_EXC_ERROR THEN
475: p_return_status := FND_API.G_RET_STS_ERROR;
476: rollback to start_create_object;
477: WHEN OTHERS THEN
478: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 478: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

474: WHEN FND_API.G_EXC_ERROR THEN
475: p_return_status := FND_API.G_RET_STS_ERROR;
476: rollback to start_create_object;
477: WHEN OTHERS THEN
478: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
480: SUBSTR (SQLERRM, 1, 240) );
481: FND_MSG_PUB.Add;
482: rollback to start_create_object;

Line 512: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

508: -- Version Initial version number = 1.0
509: -- History Current version number = 1.0
510: --=======================================================
511: procedure DELETE_ATTRIBUTE (
512: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
513: p_api_version_number IN NUMBER,
514: p_init_msg_tbl IN BOOLEAN := FALSE,
515: p_msg_count OUT NOCOPY NUMBER,
516: p_msg_data OUT NOCOPY VARCHAR2,

Line 528: IF NOT FND_API.Compatible_API_Call (

524: l_api_name CONSTANT varchar2(30) := 'Delete_Attribute';
525: l_return_status VARCHAR2(1);
526: begin
527: -- Check API version number
528: IF NOT FND_API.Compatible_API_Call (
529: l_api_version_number, p_api_version_number, l_api_name,
530: G_PKG_NAME) then
531: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: return;

Line 531: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

527: -- Check API version number
528: IF NOT FND_API.Compatible_API_Call (
529: l_api_version_number, p_api_version_number, l_api_name,
530: G_PKG_NAME) then
531: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: return;
533: END IF;
534:
535: -- Initialize the message table if requested.

Line 557: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

553: p_delete_cascade => p_delete_cascade
554: );
555:
556: -- If API call returns with an error status...
557: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
558: (l_return_status = FND_API.G_RET_STS_ERROR) then
559: RAISE FND_API.G_EXC_ERROR;
560: end if;
561:

Line 558: (l_return_status = FND_API.G_RET_STS_ERROR) then

554: );
555:
556: -- If API call returns with an error status...
557: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
558: (l_return_status = FND_API.G_RET_STS_ERROR) then
559: RAISE FND_API.G_EXC_ERROR;
560: end if;
561:
562: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 559: RAISE FND_API.G_EXC_ERROR;

555:
556: -- If API call returns with an error status...
557: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
558: (l_return_status = FND_API.G_RET_STS_ERROR) then
559: RAISE FND_API.G_EXC_ERROR;
560: end if;
561:
562: p_return_status := FND_API.G_RET_STS_SUCCESS;
563:

Line 562: p_return_status := FND_API.G_RET_STS_SUCCESS;

558: (l_return_status = FND_API.G_RET_STS_ERROR) then
559: RAISE FND_API.G_EXC_ERROR;
560: end if;
561:
562: p_return_status := FND_API.G_RET_STS_SUCCESS;
563:
564: EXCEPTION
565: WHEN FND_API.G_EXC_ERROR THEN
566: p_return_status := FND_API.G_RET_STS_ERROR;

Line 565: WHEN FND_API.G_EXC_ERROR THEN

561:
562: p_return_status := FND_API.G_RET_STS_SUCCESS;
563:
564: EXCEPTION
565: WHEN FND_API.G_EXC_ERROR THEN
566: p_return_status := FND_API.G_RET_STS_ERROR;
567: rollback to start_delete_attribute;
568: WHEN OTHERS THEN
569: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 566: p_return_status := FND_API.G_RET_STS_ERROR;

562: p_return_status := FND_API.G_RET_STS_SUCCESS;
563:
564: EXCEPTION
565: WHEN FND_API.G_EXC_ERROR THEN
566: p_return_status := FND_API.G_RET_STS_ERROR;
567: rollback to start_delete_attribute;
568: WHEN OTHERS THEN
569: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 569: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

565: WHEN FND_API.G_EXC_ERROR THEN
566: p_return_status := FND_API.G_RET_STS_ERROR;
567: rollback to start_delete_attribute;
568: WHEN OTHERS THEN
569: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
571: SUBSTR (SQLERRM, 1, 240) );
572: FND_MSG_PUB.Add;
573: rollback to start_delete_attribute;

Line 608: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

604: -- Version Initial version number = 1.0
605: -- History Current version number = 1.0
606: --=======================================================
607: procedure DELETE_ATTRIBUTE_NAVIGATION (
608: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
609: p_api_version_number IN NUMBER,
610: p_init_msg_tbl IN BOOLEAN := FALSE,
611: p_msg_count OUT NOCOPY NUMBER,
612: p_msg_data OUT NOCOPY VARCHAR2,

Line 627: IF NOT FND_API.Compatible_API_Call (

623: l_api_name CONSTANT varchar2(30) := 'Delete_Attribute_Navigation';
624: l_return_status VARCHAR2(1);
625: begin
626: -- Check API version number
627: IF NOT FND_API.Compatible_API_Call (
628: l_api_version_number, p_api_version_number, l_api_name,
629: G_PKG_NAME) then
630: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: return;

Line 630: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

626: -- Check API version number
627: IF NOT FND_API.Compatible_API_Call (
628: l_api_version_number, p_api_version_number, l_api_name,
629: G_PKG_NAME) then
630: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: return;
632: END IF;
633:
634: -- Initialize the message table if requested.

Line 659: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

655: p_delete_cascade => p_delete_cascade
656: );
657:
658: -- If API call returns with an error status...
659: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
660: (l_return_status = FND_API.G_RET_STS_ERROR) then
661: RAISE FND_API.G_EXC_ERROR;
662: end if;
663:

Line 660: (l_return_status = FND_API.G_RET_STS_ERROR) then

656: );
657:
658: -- If API call returns with an error status...
659: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
660: (l_return_status = FND_API.G_RET_STS_ERROR) then
661: RAISE FND_API.G_EXC_ERROR;
662: end if;
663:
664: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 661: RAISE FND_API.G_EXC_ERROR;

657:
658: -- If API call returns with an error status...
659: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
660: (l_return_status = FND_API.G_RET_STS_ERROR) then
661: RAISE FND_API.G_EXC_ERROR;
662: end if;
663:
664: p_return_status := FND_API.G_RET_STS_SUCCESS;
665:

Line 664: p_return_status := FND_API.G_RET_STS_SUCCESS;

660: (l_return_status = FND_API.G_RET_STS_ERROR) then
661: RAISE FND_API.G_EXC_ERROR;
662: end if;
663:
664: p_return_status := FND_API.G_RET_STS_SUCCESS;
665:
666: EXCEPTION
667: WHEN FND_API.G_EXC_ERROR THEN
668: p_return_status := FND_API.G_RET_STS_ERROR;

Line 667: WHEN FND_API.G_EXC_ERROR THEN

663:
664: p_return_status := FND_API.G_RET_STS_SUCCESS;
665:
666: EXCEPTION
667: WHEN FND_API.G_EXC_ERROR THEN
668: p_return_status := FND_API.G_RET_STS_ERROR;
669: rollback to start_delete_navigation;
670: WHEN OTHERS THEN
671: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 668: p_return_status := FND_API.G_RET_STS_ERROR;

664: p_return_status := FND_API.G_RET_STS_SUCCESS;
665:
666: EXCEPTION
667: WHEN FND_API.G_EXC_ERROR THEN
668: p_return_status := FND_API.G_RET_STS_ERROR;
669: rollback to start_delete_navigation;
670: WHEN OTHERS THEN
671: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 671: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

667: WHEN FND_API.G_EXC_ERROR THEN
668: p_return_status := FND_API.G_RET_STS_ERROR;
669: rollback to start_delete_navigation;
670: WHEN OTHERS THEN
671: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
673: SUBSTR (SQLERRM, 1, 240) );
674: FND_MSG_PUB.Add;
675: rollback to start_delete_navigation;

Line 709: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

705: -- Version Initial version number = 1.0
706: -- History Current version number = 1.0
707: --=======================================================
708: procedure DELETE_ATTRIBUTE_VALUE (
709: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
710: p_api_version_number IN NUMBER,
711: p_init_msg_tbl IN BOOLEAN := FALSE,
712: p_msg_count OUT NOCOPY NUMBER,
713: p_msg_data OUT NOCOPY VARCHAR2,

Line 719: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

715: p_database_object_name IN VARCHAR2,
716: p_attribute_application_id IN NUMBER,
717: p_attribute_code IN VARCHAR2,
718: p_key_value1 IN VARCHAR2,
719: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
720: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
721: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
722: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
723: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 720: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

716: p_attribute_application_id IN NUMBER,
717: p_attribute_code IN VARCHAR2,
718: p_key_value1 IN VARCHAR2,
719: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
720: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
721: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
722: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
723: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
724: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 721: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

717: p_attribute_code IN VARCHAR2,
718: p_key_value1 IN VARCHAR2,
719: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
720: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
721: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
722: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
723: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
724: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
725: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 722: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

718: p_key_value1 IN VARCHAR2,
719: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
720: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
721: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
722: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
723: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
724: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
725: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
726: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 723: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

719: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
720: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
721: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
722: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
723: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
724: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
725: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
726: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
727: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 724: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

720: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
721: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
722: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
723: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
724: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
725: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
726: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
727: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
728: p_delete_cascade IN VARCHAR2 := 'N'

Line 725: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

721: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
722: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
723: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
724: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
725: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
726: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
727: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
728: p_delete_cascade IN VARCHAR2 := 'N'
729: ) is

Line 726: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

722: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
723: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
724: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
725: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
726: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
727: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
728: p_delete_cascade IN VARCHAR2 := 'N'
729: ) is
730: l_api_version_number CONSTANT number := 1.0;

Line 727: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

723: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
724: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
725: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
726: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
727: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
728: p_delete_cascade IN VARCHAR2 := 'N'
729: ) is
730: l_api_version_number CONSTANT number := 1.0;
731: l_api_name CONSTANT varchar2(30) := 'Delete_Attribute_Value';

Line 735: IF NOT FND_API.Compatible_API_Call (

731: l_api_name CONSTANT varchar2(30) := 'Delete_Attribute_Value';
732: l_return_status VARCHAR2(1);
733: begin
734: -- Check API version number
735: IF NOT FND_API.Compatible_API_Call (
736: l_api_version_number, p_api_version_number, l_api_name,
737: G_PKG_NAME) then
738: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
739: return;

Line 738: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

734: -- Check API version number
735: IF NOT FND_API.Compatible_API_Call (
736: l_api_version_number, p_api_version_number, l_api_name,
737: G_PKG_NAME) then
738: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
739: return;
740: END IF;
741:
742: -- Initialize the message table if requested.

Line 774: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

770: p_delete_cascade => p_delete_cascade
771: );
772:
773: -- If API call returns with an error status...
774: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
775: (l_return_status = FND_API.G_RET_STS_ERROR) then
776: RAISE FND_API.G_EXC_ERROR;
777: end if;
778:

Line 775: (l_return_status = FND_API.G_RET_STS_ERROR) then

771: );
772:
773: -- If API call returns with an error status...
774: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
775: (l_return_status = FND_API.G_RET_STS_ERROR) then
776: RAISE FND_API.G_EXC_ERROR;
777: end if;
778:
779: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 776: RAISE FND_API.G_EXC_ERROR;

772:
773: -- If API call returns with an error status...
774: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
775: (l_return_status = FND_API.G_RET_STS_ERROR) then
776: RAISE FND_API.G_EXC_ERROR;
777: end if;
778:
779: p_return_status := FND_API.G_RET_STS_SUCCESS;
780:

Line 779: p_return_status := FND_API.G_RET_STS_SUCCESS;

775: (l_return_status = FND_API.G_RET_STS_ERROR) then
776: RAISE FND_API.G_EXC_ERROR;
777: end if;
778:
779: p_return_status := FND_API.G_RET_STS_SUCCESS;
780:
781: EXCEPTION
782: WHEN FND_API.G_EXC_ERROR THEN
783: p_return_status := FND_API.G_RET_STS_ERROR;

Line 782: WHEN FND_API.G_EXC_ERROR THEN

778:
779: p_return_status := FND_API.G_RET_STS_SUCCESS;
780:
781: EXCEPTION
782: WHEN FND_API.G_EXC_ERROR THEN
783: p_return_status := FND_API.G_RET_STS_ERROR;
784: rollback to start_delete_value;
785: WHEN OTHERS THEN
786: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 783: p_return_status := FND_API.G_RET_STS_ERROR;

779: p_return_status := FND_API.G_RET_STS_SUCCESS;
780:
781: EXCEPTION
782: WHEN FND_API.G_EXC_ERROR THEN
783: p_return_status := FND_API.G_RET_STS_ERROR;
784: rollback to start_delete_value;
785: WHEN OTHERS THEN
786: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 786: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

782: WHEN FND_API.G_EXC_ERROR THEN
783: p_return_status := FND_API.G_RET_STS_ERROR;
784: rollback to start_delete_value;
785: WHEN OTHERS THEN
786: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
788: SUBSTR (SQLERRM, 1, 240) );
789: FND_MSG_PUB.Add;
790: rollback to start_delete_value;

Line 818: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

814: -- Version Initial version number = 1.0
815: -- History Current version number = 1.0
816: --=======================================================
817: procedure DELETE_OBJECT (
818: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
819: p_api_version_number IN NUMBER,
820: p_init_msg_tbl IN BOOLEAN := FALSE,
821: p_msg_count OUT NOCOPY NUMBER,
822: p_msg_data OUT NOCOPY VARCHAR2,

Line 832: IF NOT FND_API.Compatible_API_Call (

828: l_api_name CONSTANT varchar2(30) := 'Delete_Object';
829: l_return_status VARCHAR2(1);
830: begin
831: -- Check API version number
832: IF NOT FND_API.Compatible_API_Call (
833: l_api_version_number, p_api_version_number, l_api_name,
834: G_PKG_NAME) then
835: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836: return;

Line 835: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

831: -- Check API version number
832: IF NOT FND_API.Compatible_API_Call (
833: l_api_version_number, p_api_version_number, l_api_name,
834: G_PKG_NAME) then
835: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836: return;
837: END IF;
838:
839: -- Initialize the message table if requested.

Line 859: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

855: p_delete_cascade => p_delete_cascade
856: );
857:
858: -- If API call returns with an error status...
859: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
860: (l_return_status = FND_API.G_RET_STS_ERROR) then
861: RAISE FND_API.G_EXC_ERROR;
862: end if;
863:

Line 860: (l_return_status = FND_API.G_RET_STS_ERROR) then

856: );
857:
858: -- If API call returns with an error status...
859: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
860: (l_return_status = FND_API.G_RET_STS_ERROR) then
861: RAISE FND_API.G_EXC_ERROR;
862: end if;
863:
864: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 861: RAISE FND_API.G_EXC_ERROR;

857:
858: -- If API call returns with an error status...
859: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
860: (l_return_status = FND_API.G_RET_STS_ERROR) then
861: RAISE FND_API.G_EXC_ERROR;
862: end if;
863:
864: p_return_status := FND_API.G_RET_STS_SUCCESS;
865:

Line 864: p_return_status := FND_API.G_RET_STS_SUCCESS;

860: (l_return_status = FND_API.G_RET_STS_ERROR) then
861: RAISE FND_API.G_EXC_ERROR;
862: end if;
863:
864: p_return_status := FND_API.G_RET_STS_SUCCESS;
865:
866: EXCEPTION
867: WHEN FND_API.G_EXC_ERROR THEN
868: p_return_status := FND_API.G_RET_STS_ERROR;

Line 867: WHEN FND_API.G_EXC_ERROR THEN

863:
864: p_return_status := FND_API.G_RET_STS_SUCCESS;
865:
866: EXCEPTION
867: WHEN FND_API.G_EXC_ERROR THEN
868: p_return_status := FND_API.G_RET_STS_ERROR;
869: rollback to start_delete_object;
870: WHEN OTHERS THEN
871: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 868: p_return_status := FND_API.G_RET_STS_ERROR;

864: p_return_status := FND_API.G_RET_STS_SUCCESS;
865:
866: EXCEPTION
867: WHEN FND_API.G_EXC_ERROR THEN
868: p_return_status := FND_API.G_RET_STS_ERROR;
869: rollback to start_delete_object;
870: WHEN OTHERS THEN
871: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
872: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 871: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

867: WHEN FND_API.G_EXC_ERROR THEN
868: p_return_status := FND_API.G_RET_STS_ERROR;
869: rollback to start_delete_object;
870: WHEN OTHERS THEN
871: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
872: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
873: SUBSTR (SQLERRM, 1, 240) );
874: FND_MSG_PUB.Add;
875: rollback to start_delete_object;

Line 924: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

920: -- Version Initial version number = 1.0
921: -- History Current version number = 1.0
922: --===========================================================
923: procedure DOWNLOAD_OBJECT (
924: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
925: p_api_version_number IN NUMBER,
926: p_init_msg_tbl IN BOOLEAN := FALSE,
927: p_msg_count OUT NOCOPY NUMBER,
928: p_msg_data OUT NOCOPY VARCHAR2,

Line 930: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,

926: p_init_msg_tbl IN BOOLEAN := FALSE,
927: p_msg_count OUT NOCOPY NUMBER,
928: p_msg_data OUT NOCOPY VARCHAR2,
929: p_return_status OUT NOCOPY VARCHAR2,
930: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
931: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
932: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
933: p_object_pk_tbl IN AK_OBJECT_PUB.Object_PK_Tbl_Type
934: := AK_OBJECT_PUB.G_MISS_OBJECT_PK_TBL

Line 931: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

927: p_msg_count OUT NOCOPY NUMBER,
928: p_msg_data OUT NOCOPY VARCHAR2,
929: p_return_status OUT NOCOPY VARCHAR2,
930: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
931: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
932: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
933: p_object_pk_tbl IN AK_OBJECT_PUB.Object_PK_Tbl_Type
934: := AK_OBJECT_PUB.G_MISS_OBJECT_PK_TBL
935: ) is

Line 932: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

928: p_msg_data OUT NOCOPY VARCHAR2,
929: p_return_status OUT NOCOPY VARCHAR2,
930: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
931: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
932: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
933: p_object_pk_tbl IN AK_OBJECT_PUB.Object_PK_Tbl_Type
934: := AK_OBJECT_PUB.G_MISS_OBJECT_PK_TBL
935: ) is
936: l_api_version_number CONSTANT number := 1.0;

Line 947: IF NOT FND_API.Compatible_API_Call (

943: l_return_status varchar2(1);
944: begin
945:
946: -- Check verion number
947: IF NOT FND_API.Compatible_API_Call (
948: l_api_version_number, p_api_version_number, l_api_name,
949: G_PKG_NAME) then
950: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
951: return;

Line 950: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

946: -- Check verion number
947: IF NOT FND_API.Compatible_API_Call (
948: l_api_version_number, p_api_version_number, l_api_name,
949: G_PKG_NAME) then
950: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
951: return;
952: END IF;
953:
954: -- Initialize the message table if requested.

Line 986: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

982:
983: end if;
984:
985: -- If API call returns with an error status...
986: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
987: (l_return_status = FND_API.G_RET_STS_ERROR) then
988: -- dbms_output.put_line(G_PKG_NAME || ' download_header failed');
989: RAISE FND_API.G_EXC_ERROR;
990: end if;

Line 987: (l_return_status = FND_API.G_RET_STS_ERROR) then

983: end if;
984:
985: -- If API call returns with an error status...
986: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
987: (l_return_status = FND_API.G_RET_STS_ERROR) then
988: -- dbms_output.put_line(G_PKG_NAME || ' download_header failed');
989: RAISE FND_API.G_EXC_ERROR;
990: end if;
991:

Line 989: RAISE FND_API.G_EXC_ERROR;

985: -- If API call returns with an error status...
986: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
987: (l_return_status = FND_API.G_RET_STS_ERROR) then
988: -- dbms_output.put_line(G_PKG_NAME || ' download_header failed');
989: RAISE FND_API.G_EXC_ERROR;
990: end if;
991:
992: -- dbms_output.put_line('about to call download_object: ' ||
993: -- to_char(sysdate, 'MON-DD HH24:MI:SS'));

Line 1011: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

1007: -- to_char(sysdate, 'MON-DD HH24:MI:SS'));
1008:
1009: -- If download call returns with an error status or
1010: -- download failed to retrieve any information from the database..
1011: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1012: (l_return_status = FND_API.G_RET_STS_ERROR) then
1013: -- dbms_output.put_line(G_PKG_NAME || 'download failed');
1014: RAISE FND_API.G_EXC_ERROR;
1015: end if;

Line 1012: (l_return_status = FND_API.G_RET_STS_ERROR) then

1008:
1009: -- If download call returns with an error status or
1010: -- download failed to retrieve any information from the database..
1011: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1012: (l_return_status = FND_API.G_RET_STS_ERROR) then
1013: -- dbms_output.put_line(G_PKG_NAME || 'download failed');
1014: RAISE FND_API.G_EXC_ERROR;
1015: end if;
1016:

Line 1014: RAISE FND_API.G_EXC_ERROR;

1010: -- download failed to retrieve any information from the database..
1011: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1012: (l_return_status = FND_API.G_RET_STS_ERROR) then
1013: -- dbms_output.put_line(G_PKG_NAME || 'download failed');
1014: RAISE FND_API.G_EXC_ERROR;
1015: end if;
1016:
1017: --dbms_output.put_line('got ' || to_char(l_buffer_tbl.count) || ' lines');
1018:

Line 1019: p_return_status := FND_API.G_RET_STS_SUCCESS;

1015: end if;
1016:
1017: --dbms_output.put_line('got ' || to_char(l_buffer_tbl.count) || ' lines');
1018:
1019: p_return_status := FND_API.G_RET_STS_SUCCESS;
1020:
1021: FND_MSG_PUB.Count_And_Get (
1022: p_count => p_msg_count,
1023: p_data => p_msg_data);

Line 1026: WHEN FND_API.G_EXC_ERROR THEN

1022: p_count => p_msg_count,
1023: p_data => p_msg_data);
1024:
1025: EXCEPTION
1026: WHEN FND_API.G_EXC_ERROR THEN
1027: -- dbms_output.put_line('Procedure DOWNLOAD_OBJECT EXCEPTION FND_API.G_EXC_ERROR');
1028: -- rollback to Start_download;
1029: p_return_status := FND_API.G_RET_STS_ERROR;
1030: FND_MSG_PUB.Count_And_Get (

Line 1027: -- dbms_output.put_line('Procedure DOWNLOAD_OBJECT EXCEPTION FND_API.G_EXC_ERROR');

1023: p_data => p_msg_data);
1024:
1025: EXCEPTION
1026: WHEN FND_API.G_EXC_ERROR THEN
1027: -- dbms_output.put_line('Procedure DOWNLOAD_OBJECT EXCEPTION FND_API.G_EXC_ERROR');
1028: -- rollback to Start_download;
1029: p_return_status := FND_API.G_RET_STS_ERROR;
1030: FND_MSG_PUB.Count_And_Get (
1031: p_count => p_msg_count,

Line 1029: p_return_status := FND_API.G_RET_STS_ERROR;

1025: EXCEPTION
1026: WHEN FND_API.G_EXC_ERROR THEN
1027: -- dbms_output.put_line('Procedure DOWNLOAD_OBJECT EXCEPTION FND_API.G_EXC_ERROR');
1028: -- rollback to Start_download;
1029: p_return_status := FND_API.G_RET_STS_ERROR;
1030: FND_MSG_PUB.Count_And_Get (
1031: p_count => p_msg_count,
1032: p_data => p_msg_data);
1033:

Line 1035: -- dbms_output.put_line('Procedure DOWNLOAD_OBJECT EXCEPTION FND_API.G_EXC_ERROR');

1031: p_count => p_msg_count,
1032: p_data => p_msg_data);
1033:
1034: WHEN OTHERS THEN
1035: -- dbms_output.put_line('Procedure DOWNLOAD_OBJECT EXCEPTION FND_API.G_EXC_ERROR');
1036: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1037: -- rollback to Start_download;
1038: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1039: SUBSTR (SQLERRM, 1, 240) );

Line 1036: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1032: p_data => p_msg_data);
1033:
1034: WHEN OTHERS THEN
1035: -- dbms_output.put_line('Procedure DOWNLOAD_OBJECT EXCEPTION FND_API.G_EXC_ERROR');
1036: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1037: -- rollback to Start_download;
1038: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1039: SUBSTR (SQLERRM, 1, 240) );
1040: FND_MSG_PUB.Add;

Line 1066: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1062: -- Version Initial version number = 1.0
1063: -- History Current version number = 1.0
1064: --=======================================================
1065: procedure UPDATE_ATTRIBUTE (
1066: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1067: p_api_version_number IN NUMBER,
1068: p_init_msg_tbl IN BOOLEAN := FALSE,
1069: p_msg_count OUT NOCOPY NUMBER,
1070: p_msg_data OUT NOCOPY VARCHAR2,

Line 1075: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

1071: p_return_status OUT NOCOPY VARCHAR2,
1072: p_database_object_name IN VARCHAR2,
1073: p_attribute_application_id IN NUMBER,
1074: p_attribute_code IN VARCHAR2,
1075: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1076: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
1077: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
1078: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
1079: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1076: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,

1072: p_database_object_name IN VARCHAR2,
1073: p_attribute_application_id IN NUMBER,
1074: p_attribute_code IN VARCHAR2,
1075: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1076: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
1077: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
1078: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
1079: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
1080: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1077: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,

1073: p_attribute_application_id IN NUMBER,
1074: p_attribute_code IN VARCHAR2,
1075: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1076: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
1077: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
1078: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
1079: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
1080: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
1081: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1078: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,

1074: p_attribute_code IN VARCHAR2,
1075: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1076: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
1077: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
1078: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
1079: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
1080: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
1081: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
1082: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1079: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,

1075: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1076: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
1077: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
1078: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
1079: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
1080: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
1081: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
1082: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1083: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1080: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

1076: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
1077: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
1078: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
1079: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
1080: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
1081: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
1082: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1083: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1084: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1081: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

1077: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
1078: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
1079: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
1080: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
1081: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
1082: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1083: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1084: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1085: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1082: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

1078: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
1079: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
1080: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
1081: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
1082: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1083: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1084: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1085: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1086: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1083: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

1079: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
1080: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
1081: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
1082: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1083: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1084: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1085: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1086: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1087: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1084: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

1080: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
1081: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
1082: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1083: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1084: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1085: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1086: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1087: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1088: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,

Line 1085: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

1081: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
1082: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1083: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1084: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1085: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1086: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1087: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1088: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
1089: p_default_value_date IN DATE := FND_API.G_MISS_DATE,

Line 1086: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

1082: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1083: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1084: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1085: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1086: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1087: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1088: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
1089: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
1090: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 1087: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1083: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1084: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1085: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1086: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1087: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1088: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
1089: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
1090: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
1091: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1088: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,

1084: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1085: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1086: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1087: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1088: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
1089: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
1090: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
1091: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1092: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1089: p_default_value_date IN DATE := FND_API.G_MISS_DATE,

1085: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1086: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1087: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1088: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
1089: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
1090: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
1091: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1092: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1093: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 1090: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

1086: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1087: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1088: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
1089: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
1090: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
1091: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1092: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1093: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
1094: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1091: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

1087: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1088: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
1089: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
1090: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
1091: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1092: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1093: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
1094: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1095: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1092: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

1088: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
1089: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
1090: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
1091: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1092: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1093: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
1094: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1095: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1096: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1093: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,

1089: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
1090: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
1091: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1092: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1093: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
1094: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1095: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1096: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1097: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1094: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

1090: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
1091: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1092: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1093: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
1094: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1095: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1096: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1097: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1098: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1095: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

1091: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1092: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1093: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
1094: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1095: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1096: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1097: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1098: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1099: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,

Line 1096: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

1092: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1093: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
1094: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1095: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1096: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1097: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1098: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1099: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
1100: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1097: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

1093: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
1094: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1095: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1096: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1097: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1098: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1099: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
1100: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
1101: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1098: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

1094: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1095: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1096: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1097: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1098: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1099: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
1100: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
1101: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
1102: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 1099: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,

1095: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1096: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1097: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1098: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1099: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
1100: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
1101: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
1102: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1103: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 1100: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,

1096: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1097: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1098: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1099: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
1100: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
1101: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
1102: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1103: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1104: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 1101: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,

1097: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1098: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1099: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
1100: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
1101: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
1102: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1103: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1104: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1105: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 1102: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

1098: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1099: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
1100: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
1101: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
1102: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1103: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1104: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1105: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1106: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

Line 1103: p_creation_date IN DATE := FND_API.G_MISS_DATE,

1099: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
1100: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
1101: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
1102: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1103: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1104: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1105: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1106: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1107: ) is

Line 1104: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

1100: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
1101: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
1102: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1103: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1104: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1105: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1106: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1107: ) is
1108: l_api_version_number CONSTANT number := 1.0;

Line 1105: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

1101: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
1102: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1103: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1104: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1105: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1106: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1107: ) is
1108: l_api_version_number CONSTANT number := 1.0;
1109: l_api_name CONSTANT varchar2(30) := 'Update_Attribute';

Line 1106: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

1102: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1103: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1104: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1105: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1106: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1107: ) is
1108: l_api_version_number CONSTANT number := 1.0;
1109: l_api_name CONSTANT varchar2(30) := 'Update_Attribute';
1110: l_return_status VARCHAR2(1);

Line 1115: IF NOT FND_API.Compatible_API_Call (

1111: l_pass NUMBER := 2;
1112: l_copy_redo_flag BOOLEAN := FALSE;
1113: begin
1114: -- Check API version number
1115: IF NOT FND_API.Compatible_API_Call (
1116: l_api_version_number, p_api_version_number, l_api_name,
1117: G_PKG_NAME) then
1118: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1119: return;

Line 1118: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1114: -- Check API version number
1115: IF NOT FND_API.Compatible_API_Call (
1116: l_api_version_number, p_api_version_number, l_api_name,
1117: G_PKG_NAME) then
1118: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1119: return;
1120: END IF;
1121:
1122: -- Initialize the message table if requested.

Line 1176: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

1172: p_copy_redo_flag => l_copy_redo_flag
1173: );
1174:
1175: -- If API call returns with an error status...
1176: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1177: (l_return_status = FND_API.G_RET_STS_ERROR) then
1178: --dbms_output.put_line(l_api_name || ' Update_Attribute failed');
1179: RAISE FND_API.G_EXC_ERROR;
1180: end if;

Line 1177: (l_return_status = FND_API.G_RET_STS_ERROR) then

1173: );
1174:
1175: -- If API call returns with an error status...
1176: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1177: (l_return_status = FND_API.G_RET_STS_ERROR) then
1178: --dbms_output.put_line(l_api_name || ' Update_Attribute failed');
1179: RAISE FND_API.G_EXC_ERROR;
1180: end if;
1181:

Line 1179: RAISE FND_API.G_EXC_ERROR;

1175: -- If API call returns with an error status...
1176: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1177: (l_return_status = FND_API.G_RET_STS_ERROR) then
1178: --dbms_output.put_line(l_api_name || ' Update_Attribute failed');
1179: RAISE FND_API.G_EXC_ERROR;
1180: end if;
1181:
1182: p_return_status := FND_API.G_RET_STS_SUCCESS;
1183:

Line 1182: p_return_status := FND_API.G_RET_STS_SUCCESS;

1178: --dbms_output.put_line(l_api_name || ' Update_Attribute failed');
1179: RAISE FND_API.G_EXC_ERROR;
1180: end if;
1181:
1182: p_return_status := FND_API.G_RET_STS_SUCCESS;
1183:
1184: EXCEPTION
1185: WHEN FND_API.G_EXC_ERROR THEN
1186: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1185: WHEN FND_API.G_EXC_ERROR THEN

1181:
1182: p_return_status := FND_API.G_RET_STS_SUCCESS;
1183:
1184: EXCEPTION
1185: WHEN FND_API.G_EXC_ERROR THEN
1186: p_return_status := FND_API.G_RET_STS_ERROR;
1187: rollback to start_update_attribute;
1188: WHEN OTHERS THEN
1189: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1186: p_return_status := FND_API.G_RET_STS_ERROR;

1182: p_return_status := FND_API.G_RET_STS_SUCCESS;
1183:
1184: EXCEPTION
1185: WHEN FND_API.G_EXC_ERROR THEN
1186: p_return_status := FND_API.G_RET_STS_ERROR;
1187: rollback to start_update_attribute;
1188: WHEN OTHERS THEN
1189: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1190: rollback to start_update_attribute;

Line 1189: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1185: WHEN FND_API.G_EXC_ERROR THEN
1186: p_return_status := FND_API.G_RET_STS_ERROR;
1187: rollback to start_update_attribute;
1188: WHEN OTHERS THEN
1189: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1190: rollback to start_update_attribute;
1191: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1192: SUBSTR (SQLERRM, 1, 240) );
1193: FND_MSG_PUB.Add;

Line 1216: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1212: -- Version Initial version number = 1.0
1213: -- History Current version number = 1.0
1214: --=======================================================
1215: procedure UPDATE_ATTRIBUTE_NAVIGATION (
1216: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1217: p_api_version_number IN NUMBER,
1218: p_init_msg_tbl IN BOOLEAN := FALSE,
1219: p_msg_count OUT NOCOPY NUMBER,
1220: p_msg_data OUT NOCOPY VARCHAR2,

Line 1228: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,

1224: p_attribute_code IN VARCHAR2,
1225: p_value_varchar2 IN VARCHAR2,
1226: p_value_date IN DATE,
1227: p_value_number IN NUMBER,
1228: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1229: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1230: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1231: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1232: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 1229: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

1225: p_value_varchar2 IN VARCHAR2,
1226: p_value_date IN DATE,
1227: p_value_number IN NUMBER,
1228: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1229: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1230: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1231: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1232: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1233: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 1230: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

1226: p_value_date IN DATE,
1227: p_value_number IN NUMBER,
1228: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1229: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1230: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1231: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1232: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1233: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1234: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

Line 1231: p_creation_date IN DATE := FND_API.G_MISS_DATE,

1227: p_value_number IN NUMBER,
1228: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1229: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1230: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1231: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1232: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1233: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1234: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1235: ) is

Line 1232: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

1228: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1229: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1230: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1231: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1232: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1233: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1234: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1235: ) is
1236: l_api_version_number CONSTANT number := 1.0;

Line 1233: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

1229: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1230: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1231: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1232: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1233: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1234: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1235: ) is
1236: l_api_version_number CONSTANT number := 1.0;
1237: l_api_name CONSTANT varchar2(30) := 'Update_Attribute_Navigation';

Line 1234: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

1230: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1231: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1232: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1233: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1234: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1235: ) is
1236: l_api_version_number CONSTANT number := 1.0;
1237: l_api_name CONSTANT varchar2(30) := 'Update_Attribute_Navigation';
1238: l_return_status VARCHAR2(1);

Line 1243: IF NOT FND_API.Compatible_API_Call (

1239: l_pass NUMBER := 2;
1240: l_copy_redo_flag BOOLEAN := FALSE;
1241: begin
1242: -- Check API version number
1243: IF NOT FND_API.Compatible_API_Call (
1244: l_api_version_number, p_api_version_number, l_api_name,
1245: G_PKG_NAME) then
1246: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1247: return;

Line 1246: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1242: -- Check API version number
1243: IF NOT FND_API.Compatible_API_Call (
1244: l_api_version_number, p_api_version_number, l_api_name,
1245: G_PKG_NAME) then
1246: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1247: return;
1248: END IF;
1249:
1250: -- Initialize the message table if requested.

Line 1283: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

1279: p_copy_redo_flag => l_copy_redo_flag
1280: );
1281:
1282: -- If API call returns with an error status...
1283: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1284: (l_return_status = FND_API.G_RET_STS_ERROR) then
1285: --dbms_output.put_line(l_api_name || ' Update_Attribute_Navigation failed');
1286: RAISE FND_API.G_EXC_ERROR;
1287: end if;

Line 1284: (l_return_status = FND_API.G_RET_STS_ERROR) then

1280: );
1281:
1282: -- If API call returns with an error status...
1283: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1284: (l_return_status = FND_API.G_RET_STS_ERROR) then
1285: --dbms_output.put_line(l_api_name || ' Update_Attribute_Navigation failed');
1286: RAISE FND_API.G_EXC_ERROR;
1287: end if;
1288:

Line 1286: RAISE FND_API.G_EXC_ERROR;

1282: -- If API call returns with an error status...
1283: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1284: (l_return_status = FND_API.G_RET_STS_ERROR) then
1285: --dbms_output.put_line(l_api_name || ' Update_Attribute_Navigation failed');
1286: RAISE FND_API.G_EXC_ERROR;
1287: end if;
1288:
1289: p_return_status := FND_API.G_RET_STS_SUCCESS;
1290:

Line 1289: p_return_status := FND_API.G_RET_STS_SUCCESS;

1285: --dbms_output.put_line(l_api_name || ' Update_Attribute_Navigation failed');
1286: RAISE FND_API.G_EXC_ERROR;
1287: end if;
1288:
1289: p_return_status := FND_API.G_RET_STS_SUCCESS;
1290:
1291: EXCEPTION
1292: WHEN FND_API.G_EXC_ERROR THEN
1293: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1292: WHEN FND_API.G_EXC_ERROR THEN

1288:
1289: p_return_status := FND_API.G_RET_STS_SUCCESS;
1290:
1291: EXCEPTION
1292: WHEN FND_API.G_EXC_ERROR THEN
1293: p_return_status := FND_API.G_RET_STS_ERROR;
1294: rollback to start_update_navigation;
1295: WHEN OTHERS THEN
1296: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1293: p_return_status := FND_API.G_RET_STS_ERROR;

1289: p_return_status := FND_API.G_RET_STS_SUCCESS;
1290:
1291: EXCEPTION
1292: WHEN FND_API.G_EXC_ERROR THEN
1293: p_return_status := FND_API.G_RET_STS_ERROR;
1294: rollback to start_update_navigation;
1295: WHEN OTHERS THEN
1296: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1297: rollback to start_update_navigation;

Line 1296: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1292: WHEN FND_API.G_EXC_ERROR THEN
1293: p_return_status := FND_API.G_RET_STS_ERROR;
1294: rollback to start_update_navigation;
1295: WHEN OTHERS THEN
1296: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1297: rollback to start_update_navigation;
1298: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1299: SUBSTR (SQLERRM, 1, 240) );
1300: FND_MSG_PUB.Add;

Line 1323: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1319: -- Version Initial version number = 1.0
1320: -- History Current version number = 1.0
1321: --=======================================================
1322: procedure UPDATE_ATTRIBUTE_VALUE (
1323: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1324: p_api_version_number IN NUMBER,
1325: p_init_msg_tbl IN BOOLEAN := FALSE,
1326: p_msg_count OUT NOCOPY NUMBER,
1327: p_msg_data OUT NOCOPY VARCHAR2,

Line 1333: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1329: p_database_object_name IN VARCHAR2,
1330: p_attribute_application_id IN NUMBER,
1331: p_attribute_code IN VARCHAR2,
1332: p_key_value1 IN VARCHAR2,
1333: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1334: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1335: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1336: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1337: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1334: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1330: p_attribute_application_id IN NUMBER,
1331: p_attribute_code IN VARCHAR2,
1332: p_key_value1 IN VARCHAR2,
1333: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1334: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1335: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1336: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1337: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1338: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1335: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1331: p_attribute_code IN VARCHAR2,
1332: p_key_value1 IN VARCHAR2,
1333: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1334: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1335: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1336: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1337: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1338: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1339: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1336: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1332: p_key_value1 IN VARCHAR2,
1333: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1334: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1335: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1336: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1337: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1338: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1339: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1340: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1337: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1333: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1334: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1335: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1336: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1337: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1338: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1339: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1340: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1341: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1338: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1334: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1335: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1336: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1337: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1338: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1339: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1340: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1341: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1342: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1339: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1335: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1336: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1337: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1338: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1339: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1340: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1341: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1342: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1343: p_value_date IN DATE := FND_API.G_MISS_DATE,

Line 1340: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1336: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1337: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1338: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1339: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1340: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1341: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1342: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1343: p_value_date IN DATE := FND_API.G_MISS_DATE,
1344: p_value_number IN NUMBER := FND_API.G_MISS_NUM,

Line 1341: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1337: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1338: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1339: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1340: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1341: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1342: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1343: p_value_date IN DATE := FND_API.G_MISS_DATE,
1344: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
1345: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 1342: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1338: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1339: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1340: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1341: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1342: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1343: p_value_date IN DATE := FND_API.G_MISS_DATE,
1344: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
1345: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1346: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 1343: p_value_date IN DATE := FND_API.G_MISS_DATE,

1339: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1340: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1341: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1342: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1343: p_value_date IN DATE := FND_API.G_MISS_DATE,
1344: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
1345: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1346: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1347: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 1344: p_value_number IN NUMBER := FND_API.G_MISS_NUM,

1340: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1341: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1342: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1343: p_value_date IN DATE := FND_API.G_MISS_DATE,
1344: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
1345: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1346: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1347: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1348: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 1345: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

1341: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1342: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1343: p_value_date IN DATE := FND_API.G_MISS_DATE,
1344: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
1345: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1346: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1347: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1348: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1349: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

Line 1346: p_creation_date IN DATE := FND_API.G_MISS_DATE,

1342: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1343: p_value_date IN DATE := FND_API.G_MISS_DATE,
1344: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
1345: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1346: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1347: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1348: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1349: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1350: ) is

Line 1347: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

1343: p_value_date IN DATE := FND_API.G_MISS_DATE,
1344: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
1345: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1346: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1347: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1348: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1349: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1350: ) is
1351: l_api_version_number CONSTANT number := 1.0;

Line 1348: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

1344: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
1345: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1346: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1347: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1348: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1349: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1350: ) is
1351: l_api_version_number CONSTANT number := 1.0;
1352: l_api_name CONSTANT varchar2(30) := 'Update_Attribute_Value';

Line 1349: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

1345: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1346: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1347: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1348: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1349: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1350: ) is
1351: l_api_version_number CONSTANT number := 1.0;
1352: l_api_name CONSTANT varchar2(30) := 'Update_Attribute_Value';
1353: l_return_status VARCHAR2(1);

Line 1356: IF NOT FND_API.Compatible_API_Call (

1352: l_api_name CONSTANT varchar2(30) := 'Update_Attribute_Value';
1353: l_return_status VARCHAR2(1);
1354: begin
1355: -- Check API version number
1356: IF NOT FND_API.Compatible_API_Call (
1357: l_api_version_number, p_api_version_number, l_api_name,
1358: G_PKG_NAME) then
1359: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1360: return;

Line 1359: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1355: -- Check API version number
1356: IF NOT FND_API.Compatible_API_Call (
1357: l_api_version_number, p_api_version_number, l_api_name,
1358: G_PKG_NAME) then
1359: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1360: return;
1361: END IF;
1362:
1363: -- Initialize the message table if requested.

Line 1402: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

1398: p_last_update_login => p_lasT_update_login
1399: );
1400:
1401: -- If API call returns with an error status...
1402: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1403: (l_return_status = FND_API.G_RET_STS_ERROR) then
1404: --dbms_output.put_line(l_api_name || ' Update_Attribute_Value failed');
1405: RAISE FND_API.G_EXC_ERROR;
1406: end if;

Line 1403: (l_return_status = FND_API.G_RET_STS_ERROR) then

1399: );
1400:
1401: -- If API call returns with an error status...
1402: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1403: (l_return_status = FND_API.G_RET_STS_ERROR) then
1404: --dbms_output.put_line(l_api_name || ' Update_Attribute_Value failed');
1405: RAISE FND_API.G_EXC_ERROR;
1406: end if;
1407:

Line 1405: RAISE FND_API.G_EXC_ERROR;

1401: -- If API call returns with an error status...
1402: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1403: (l_return_status = FND_API.G_RET_STS_ERROR) then
1404: --dbms_output.put_line(l_api_name || ' Update_Attribute_Value failed');
1405: RAISE FND_API.G_EXC_ERROR;
1406: end if;
1407:
1408: p_return_status := FND_API.G_RET_STS_SUCCESS;
1409:

Line 1408: p_return_status := FND_API.G_RET_STS_SUCCESS;

1404: --dbms_output.put_line(l_api_name || ' Update_Attribute_Value failed');
1405: RAISE FND_API.G_EXC_ERROR;
1406: end if;
1407:
1408: p_return_status := FND_API.G_RET_STS_SUCCESS;
1409:
1410: EXCEPTION
1411: WHEN FND_API.G_EXC_ERROR THEN
1412: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1411: WHEN FND_API.G_EXC_ERROR THEN

1407:
1408: p_return_status := FND_API.G_RET_STS_SUCCESS;
1409:
1410: EXCEPTION
1411: WHEN FND_API.G_EXC_ERROR THEN
1412: p_return_status := FND_API.G_RET_STS_ERROR;
1413: rollback to start_update_value;
1414: WHEN OTHERS THEN
1415: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1412: p_return_status := FND_API.G_RET_STS_ERROR;

1408: p_return_status := FND_API.G_RET_STS_SUCCESS;
1409:
1410: EXCEPTION
1411: WHEN FND_API.G_EXC_ERROR THEN
1412: p_return_status := FND_API.G_RET_STS_ERROR;
1413: rollback to start_update_value;
1414: WHEN OTHERS THEN
1415: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1416: rollback to start_update_value;

Line 1415: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1411: WHEN FND_API.G_EXC_ERROR THEN
1412: p_return_status := FND_API.G_RET_STS_ERROR;
1413: rollback to start_update_value;
1414: WHEN OTHERS THEN
1415: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1416: rollback to start_update_value;
1417: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1418: SUBSTR (SQLERRM, 1, 240) );
1419: FND_MSG_PUB.Add;

Line 1441: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1437: -- Version Initial version number = 1.0
1438: -- History Current version number = 1.0
1439: --=======================================================
1440: procedure UPDATE_OBJECT (
1441: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1442: p_api_version_number IN NUMBER,
1443: p_init_msg_tbl IN BOOLEAN := FALSE,
1444: p_msg_count OUT NOCOPY NUMBER,
1445: p_msg_data OUT NOCOPY VARCHAR2,

Line 1448: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

1444: p_msg_count OUT NOCOPY NUMBER,
1445: p_msg_data OUT NOCOPY VARCHAR2,
1446: p_return_status OUT NOCOPY VARCHAR2,
1447: p_database_object_name IN VARCHAR2,
1448: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1449: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1450: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1451: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1452: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1449: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

1445: p_msg_data OUT NOCOPY VARCHAR2,
1446: p_return_status OUT NOCOPY VARCHAR2,
1447: p_database_object_name IN VARCHAR2,
1448: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1449: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1450: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1451: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1452: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1453: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1450: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

1446: p_return_status OUT NOCOPY VARCHAR2,
1447: p_database_object_name IN VARCHAR2,
1448: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1449: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1450: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1451: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1452: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1453: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1454: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1451: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

1447: p_database_object_name IN VARCHAR2,
1448: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1449: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1450: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1451: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1452: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1453: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1454: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1455: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1452: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

1448: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1449: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1450: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1451: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1452: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1453: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1454: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1455: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1456: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 1453: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

1449: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1450: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1451: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1452: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1453: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1454: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1455: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1456: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1457: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 1454: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

1450: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1451: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1452: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1453: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1454: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1455: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1456: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1457: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1458: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 1455: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

1451: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1452: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1453: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1454: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1455: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1456: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1457: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1458: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1459: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 1456: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

1452: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1453: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1454: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1455: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1456: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1457: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1458: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1459: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1460: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

Line 1457: p_creation_date IN DATE := FND_API.G_MISS_DATE,

1453: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1454: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1455: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1456: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1457: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1458: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1459: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1460: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1461: ) is

Line 1458: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

1454: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
1455: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1456: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1457: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1458: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1459: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1460: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1461: ) is
1462: l_api_version_number CONSTANT number := 1.0;

Line 1459: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

1455: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1456: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1457: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1458: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1459: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1460: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1461: ) is
1462: l_api_version_number CONSTANT number := 1.0;
1463: l_api_name CONSTANT varchar2(30) := 'Update_Object';

Line 1460: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

1456: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1457: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1458: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1459: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1460: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1461: ) is
1462: l_api_version_number CONSTANT number := 1.0;
1463: l_api_name CONSTANT varchar2(30) := 'Update_Object';
1464: l_return_status VARCHAR2(1);

Line 1469: IF NOT FND_API.Compatible_API_Call (

1465: l_pass NUMBER := 2;
1466: l_copy_redo_flag BOOLEAN := FALSE;
1467: begin
1468: -- Check API version number
1469: IF NOT FND_API.Compatible_API_Call (
1470: l_api_version_number, p_api_version_number, l_api_name,
1471: G_PKG_NAME) then
1472: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1473: return;

Line 1472: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1468: -- Check API version number
1469: IF NOT FND_API.Compatible_API_Call (
1470: l_api_version_number, p_api_version_number, l_api_name,
1471: G_PKG_NAME) then
1472: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1473: return;
1474: END IF;
1475:
1476: -- Initialize the message table if requested.

Line 1510: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

1506: p_copy_redo_flag => l_copy_redo_flag
1507: );
1508:
1509: -- If API call returns with an error status...
1510: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1511: (l_return_status = FND_API.G_RET_STS_ERROR) then
1512: --dbms_output.put_line(l_api_name || ' Update_Object failed');
1513: RAISE FND_API.G_EXC_ERROR;
1514: end if;

Line 1511: (l_return_status = FND_API.G_RET_STS_ERROR) then

1507: );
1508:
1509: -- If API call returns with an error status...
1510: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1511: (l_return_status = FND_API.G_RET_STS_ERROR) then
1512: --dbms_output.put_line(l_api_name || ' Update_Object failed');
1513: RAISE FND_API.G_EXC_ERROR;
1514: end if;
1515:

Line 1513: RAISE FND_API.G_EXC_ERROR;

1509: -- If API call returns with an error status...
1510: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1511: (l_return_status = FND_API.G_RET_STS_ERROR) then
1512: --dbms_output.put_line(l_api_name || ' Update_Object failed');
1513: RAISE FND_API.G_EXC_ERROR;
1514: end if;
1515:
1516: p_return_status := FND_API.G_RET_STS_SUCCESS;
1517:

Line 1516: p_return_status := FND_API.G_RET_STS_SUCCESS;

1512: --dbms_output.put_line(l_api_name || ' Update_Object failed');
1513: RAISE FND_API.G_EXC_ERROR;
1514: end if;
1515:
1516: p_return_status := FND_API.G_RET_STS_SUCCESS;
1517:
1518: EXCEPTION
1519: WHEN FND_API.G_EXC_ERROR THEN
1520: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1519: WHEN FND_API.G_EXC_ERROR THEN

1515:
1516: p_return_status := FND_API.G_RET_STS_SUCCESS;
1517:
1518: EXCEPTION
1519: WHEN FND_API.G_EXC_ERROR THEN
1520: p_return_status := FND_API.G_RET_STS_ERROR;
1521: rollback to start_update_object;
1522: WHEN OTHERS THEN
1523: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1520: p_return_status := FND_API.G_RET_STS_ERROR;

1516: p_return_status := FND_API.G_RET_STS_SUCCESS;
1517:
1518: EXCEPTION
1519: WHEN FND_API.G_EXC_ERROR THEN
1520: p_return_status := FND_API.G_RET_STS_ERROR;
1521: rollback to start_update_object;
1522: WHEN OTHERS THEN
1523: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1524: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 1523: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1519: WHEN FND_API.G_EXC_ERROR THEN
1520: p_return_status := FND_API.G_RET_STS_ERROR;
1521: rollback to start_update_object;
1522: WHEN OTHERS THEN
1523: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1524: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1525: SUBSTR (SQLERRM, 1, 240) );
1526: FND_MSG_PUB.Add;
1527: rollback to start_update_object;