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_CUSTOM_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_CUSTOM (
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 33: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,

29: p_custom_appl_id IN NUMBER,
30: p_custom_code IN VARCHAR2,
31: p_region_appl_id IN NUMBER,
32: p_region_code IN VARCHAR2,
33: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
36: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
37: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,

Line 34: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

30: p_custom_code IN VARCHAR2,
31: p_region_appl_id IN NUMBER,
32: p_region_code IN VARCHAR2,
33: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
36: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
37: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
38: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,

Line 35: p_org_id IN NUMBER := FND_API.G_MISS_NUM,

31: p_region_appl_id IN NUMBER,
32: p_region_code IN VARCHAR2,
33: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
36: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
37: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
38: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
39: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 36: p_site_id IN NUMBER := FND_API.G_MISS_NUM,

32: p_region_code IN VARCHAR2,
33: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
36: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
37: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
38: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
39: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,

Line 37: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,

33: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
36: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
37: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
38: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
39: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
41: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 38: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,

34: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
36: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
37: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
38: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
39: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
41: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 39: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

35: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
36: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
37: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
38: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
39: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
41: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 40: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,

36: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
37: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
38: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
39: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
41: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_start_date_active IN DATE := FND_API.G_MISS_DATE,

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

37: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
38: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
39: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
41: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
45: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

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

38: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
39: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
41: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
45: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
46: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 43: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

39: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
41: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
45: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
46: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 44: p_start_date_active IN DATE := FND_API.G_MISS_DATE,

40: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
41: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
45: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
46: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 45: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

41: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
45: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
46: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
49: p_creation_date IN DATE := FND_API.G_MISS_DATE,

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

42: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
45: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
46: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
49: p_creation_date IN DATE := FND_API.G_MISS_DATE,
50: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

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

43: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
45: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
46: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
49: p_creation_date IN DATE := FND_API.G_MISS_DATE,
50: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
51: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

44: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
45: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
46: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
49: p_creation_date IN DATE := FND_API.G_MISS_DATE,
50: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
51: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
52: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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

45: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
46: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
49: p_creation_date IN DATE := FND_API.G_MISS_DATE,
50: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
51: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
52: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
53: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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

46: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
49: p_creation_date IN DATE := FND_API.G_MISS_DATE,
50: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
51: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
52: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
53: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
54: p_pass IN NUMBER,

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

47: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
49: p_creation_date IN DATE := FND_API.G_MISS_DATE,
50: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
51: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
52: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
53: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
54: p_pass IN NUMBER,
55: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

Line 52: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

48: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
49: p_creation_date IN DATE := FND_API.G_MISS_DATE,
50: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
51: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
52: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
53: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
54: p_pass IN NUMBER,
55: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
56: ) is

Line 53: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

49: p_creation_date IN DATE := FND_API.G_MISS_DATE,
50: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
51: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
52: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
53: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
54: p_pass IN NUMBER,
55: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
56: ) is
57: l_api_version_number CONSTANT number := 1.0;

Line 64: IF NOT FND_API.Compatible_API_Call (

60: l_pass NUMBER := 2;
61: l_copy_redo_flag BOOLEAN := FALSE;
62: begin
63: -- Check API version number
64: IF NOT FND_API.Compatible_API_Call (
65: l_api_version_number, p_api_version_number, l_api_name,
66: G_PKG_NAME) then
67: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
68: return;

Line 67: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

63: -- Check API version number
64: IF NOT FND_API.Compatible_API_Call (
65: l_api_version_number, p_api_version_number, l_api_name,
66: G_PKG_NAME) then
67: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
68: return;
69: END IF;
70:
71: -- Initialize the message table if requested.

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

112: p_copy_redo_flag => l_copy_redo_flag
113: );
114:
115: -- If API call returns with an error status...
116: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
117: (l_return_status = FND_API.G_RET_STS_ERROR) then
118: --dbms_output.put_line(l_api_name || ' Create_Custom failed');
119: RAISE FND_API.G_EXC_ERROR;
120: end if;

Line 117: (l_return_status = FND_API.G_RET_STS_ERROR) then

113: );
114:
115: -- If API call returns with an error status...
116: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
117: (l_return_status = FND_API.G_RET_STS_ERROR) then
118: --dbms_output.put_line(l_api_name || ' Create_Custom failed');
119: RAISE FND_API.G_EXC_ERROR;
120: end if;
121:

Line 119: RAISE FND_API.G_EXC_ERROR;

115: -- If API call returns with an error status...
116: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
117: (l_return_status = FND_API.G_RET_STS_ERROR) then
118: --dbms_output.put_line(l_api_name || ' Create_Custom failed');
119: RAISE FND_API.G_EXC_ERROR;
120: end if;
121:
122: p_return_status := FND_API.G_RET_STS_SUCCESS;
123:

Line 122: p_return_status := FND_API.G_RET_STS_SUCCESS;

118: --dbms_output.put_line(l_api_name || ' Create_Custom failed');
119: RAISE FND_API.G_EXC_ERROR;
120: end if;
121:
122: p_return_status := FND_API.G_RET_STS_SUCCESS;
123:
124: EXCEPTION
125: WHEN FND_API.G_EXC_ERROR THEN
126: p_return_status := FND_API.G_RET_STS_ERROR;

Line 125: WHEN FND_API.G_EXC_ERROR THEN

121:
122: p_return_status := FND_API.G_RET_STS_SUCCESS;
123:
124: EXCEPTION
125: WHEN FND_API.G_EXC_ERROR THEN
126: p_return_status := FND_API.G_RET_STS_ERROR;
127: rollback to start_create_custom;
128: WHEN OTHERS THEN
129: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 126: p_return_status := FND_API.G_RET_STS_ERROR;

122: p_return_status := FND_API.G_RET_STS_SUCCESS;
123:
124: EXCEPTION
125: WHEN FND_API.G_EXC_ERROR THEN
126: p_return_status := FND_API.G_RET_STS_ERROR;
127: rollback to start_create_custom;
128: WHEN OTHERS THEN
129: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130: rollback to start_create_custom;

Line 129: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

125: WHEN FND_API.G_EXC_ERROR THEN
126: p_return_status := FND_API.G_RET_STS_ERROR;
127: rollback to start_create_custom;
128: WHEN OTHERS THEN
129: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130: rollback to start_create_custom;
131: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
132: SUBSTR (SQLERRM, 1, 240) );
133: FND_MSG_PUB.Add;

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

151: -- Version Initial version number = 1.0
152: -- History Current version number = 1.0
153: --=======================================================
154: procedure CREATE_CUST_REGION (
155: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
156: p_api_version_number IN NUMBER,
157: p_init_msg_tbl IN BOOLEAN := FALSE,
158: p_msg_count OUT NOCOPY NUMBER,
159: p_msg_data OUT NOCOPY VARCHAR2,

Line 166: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

162: p_custom_code IN VARCHAR2,
163: p_region_appl_id IN NUMBER,
164: p_region_code IN VARCHAR2,
165: p_property_name IN VARCHAR2,
166: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
168: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 167: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,

163: p_region_appl_id IN NUMBER,
164: p_region_code IN VARCHAR2,
165: p_property_name IN VARCHAR2,
166: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
168: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
171: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 168: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,

164: p_region_code IN VARCHAR2,
165: p_property_name IN VARCHAR2,
166: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
168: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
171: p_creation_date IN DATE := FND_API.G_MISS_DATE,
172: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 169: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,

165: p_property_name IN VARCHAR2,
166: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
168: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
171: p_creation_date IN DATE := FND_API.G_MISS_DATE,
172: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
173: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

166: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
168: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
171: p_creation_date IN DATE := FND_API.G_MISS_DATE,
172: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
173: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
174: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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

167: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
168: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
171: p_creation_date IN DATE := FND_API.G_MISS_DATE,
172: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
173: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
174: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
175: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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

168: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
171: p_creation_date IN DATE := FND_API.G_MISS_DATE,
172: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
173: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
174: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
175: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
176: p_pass IN NUMBER,

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

169: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
171: p_creation_date IN DATE := FND_API.G_MISS_DATE,
172: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
173: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
174: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
175: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
176: p_pass IN NUMBER,
177: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

Line 174: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

170: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
171: p_creation_date IN DATE := FND_API.G_MISS_DATE,
172: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
173: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
174: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
175: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
176: p_pass IN NUMBER,
177: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
178: ) is

Line 175: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

171: p_creation_date IN DATE := FND_API.G_MISS_DATE,
172: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
173: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
174: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
175: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
176: p_pass IN NUMBER,
177: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
178: ) is
179: l_api_version_number CONSTANT number := 1.0;

Line 186: IF NOT FND_API.Compatible_API_Call (

182: l_pass NUMBER := 2;
183: l_copy_redo_flag BOOLEAN := FALSE;
184: begin
185: -- Check API version number
186: IF NOT FND_API.Compatible_API_Call (
187: l_api_version_number, p_api_version_number, l_api_name,
188: G_PKG_NAME) then
189: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
190: return;

Line 189: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

185: -- Check API version number
186: IF NOT FND_API.Compatible_API_Call (
187: l_api_version_number, p_api_version_number, l_api_name,
188: G_PKG_NAME) then
189: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
190: return;
191: END IF;
192:
193: -- Initialize the message table if requested.

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

224: p_copy_redo_flag => l_copy_redo_flag
225: );
226:
227: -- If API call returns with an error status...
228: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
229: (l_return_status = FND_API.G_RET_STS_ERROR) then
230: --dbms_output.put_line(l_api_name || ' Create_Cust_Region failed');
231: RAISE FND_API.G_EXC_ERROR;
232: end if;

Line 229: (l_return_status = FND_API.G_RET_STS_ERROR) then

225: );
226:
227: -- If API call returns with an error status...
228: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
229: (l_return_status = FND_API.G_RET_STS_ERROR) then
230: --dbms_output.put_line(l_api_name || ' Create_Cust_Region failed');
231: RAISE FND_API.G_EXC_ERROR;
232: end if;
233:

Line 231: RAISE FND_API.G_EXC_ERROR;

227: -- If API call returns with an error status...
228: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
229: (l_return_status = FND_API.G_RET_STS_ERROR) then
230: --dbms_output.put_line(l_api_name || ' Create_Cust_Region failed');
231: RAISE FND_API.G_EXC_ERROR;
232: end if;
233:
234: p_return_status := FND_API.G_RET_STS_SUCCESS;
235:

Line 234: p_return_status := FND_API.G_RET_STS_SUCCESS;

230: --dbms_output.put_line(l_api_name || ' Create_Cust_Region failed');
231: RAISE FND_API.G_EXC_ERROR;
232: end if;
233:
234: p_return_status := FND_API.G_RET_STS_SUCCESS;
235:
236: EXCEPTION
237: WHEN FND_API.G_EXC_ERROR THEN
238: p_return_status := FND_API.G_RET_STS_ERROR;

Line 237: WHEN FND_API.G_EXC_ERROR THEN

233:
234: p_return_status := FND_API.G_RET_STS_SUCCESS;
235:
236: EXCEPTION
237: WHEN FND_API.G_EXC_ERROR THEN
238: p_return_status := FND_API.G_RET_STS_ERROR;
239: rollback to start_create_cust_region;
240: WHEN OTHERS THEN
241: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 238: p_return_status := FND_API.G_RET_STS_ERROR;

234: p_return_status := FND_API.G_RET_STS_SUCCESS;
235:
236: EXCEPTION
237: WHEN FND_API.G_EXC_ERROR THEN
238: p_return_status := FND_API.G_RET_STS_ERROR;
239: rollback to start_create_cust_region;
240: WHEN OTHERS THEN
241: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: rollback to start_create_cust_region;

Line 241: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

237: WHEN FND_API.G_EXC_ERROR THEN
238: p_return_status := FND_API.G_RET_STS_ERROR;
239: rollback to start_create_cust_region;
240: WHEN OTHERS THEN
241: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: rollback to start_create_cust_region;
243: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
244: SUBSTR (SQLERRM, 1, 240) );
245: FND_MSG_PUB.Add;

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

263: -- Version Initial version number = 1.0
264: -- History Current version number = 1.0
265: --=======================================================
266: procedure CREATE_CUST_REG_ITEM (
267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
268: p_api_version_number IN NUMBER,
269: p_init_msg_tbl IN BOOLEAN := FALSE,
270: p_msg_count OUT NOCOPY NUMBER,
271: p_msg_data OUT NOCOPY VARCHAR2,

Line 280: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

276: p_region_code IN VARCHAR2,
277: p_attr_appl_id IN NUMBER,
278: p_attr_code IN VARCHAR2,
279: p_property_name IN VARCHAR2,
280: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
281: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
282: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 281: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,

277: p_attr_appl_id IN NUMBER,
278: p_attr_code IN VARCHAR2,
279: p_property_name IN VARCHAR2,
280: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
281: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
282: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
285: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 282: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

278: p_attr_code IN VARCHAR2,
279: p_property_name IN VARCHAR2,
280: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
281: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
282: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
285: p_creation_date IN DATE := FND_API.G_MISS_DATE,
286: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 283: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,

279: p_property_name IN VARCHAR2,
280: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
281: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
282: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
285: p_creation_date IN DATE := FND_API.G_MISS_DATE,
286: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
287: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

280: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
281: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
282: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
285: p_creation_date IN DATE := FND_API.G_MISS_DATE,
286: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
287: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
288: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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

281: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
282: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
285: p_creation_date IN DATE := FND_API.G_MISS_DATE,
286: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
287: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
288: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
289: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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

282: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
285: p_creation_date IN DATE := FND_API.G_MISS_DATE,
286: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
287: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
288: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
289: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
290: p_pass IN NUMBER,

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

283: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
285: p_creation_date IN DATE := FND_API.G_MISS_DATE,
286: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
287: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
288: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
289: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
290: p_pass IN NUMBER,
291: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

Line 288: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

284: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
285: p_creation_date IN DATE := FND_API.G_MISS_DATE,
286: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
287: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
288: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
289: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
290: p_pass IN NUMBER,
291: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
292: ) is

Line 289: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

285: p_creation_date IN DATE := FND_API.G_MISS_DATE,
286: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
287: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
288: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
289: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
290: p_pass IN NUMBER,
291: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
292: ) is
293: l_api_version_number CONSTANT number := 1.0;

Line 300: IF NOT FND_API.Compatible_API_Call (

296: l_pass NUMBER := 2;
297: l_copy_redo_flag BOOLEAN := FALSE;
298: begin
299: -- Check API version number
300: IF NOT FND_API.Compatible_API_Call (
301: l_api_version_number, p_api_version_number, l_api_name,
302: G_PKG_NAME) then
303: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: return;

Line 303: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

299: -- Check API version number
300: IF NOT FND_API.Compatible_API_Call (
301: l_api_version_number, p_api_version_number, l_api_name,
302: G_PKG_NAME) then
303: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: return;
305: END IF;
306:
307: -- Initialize the message table if requested.

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

340: p_copy_redo_flag => l_copy_redo_flag
341: );
342:
343: -- If API call returns with an error status...
344: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
345: (l_return_status = FND_API.G_RET_STS_ERROR) then
346: --dbms_output.put_line(l_api_name || ' Create_Cust_Reg_Item failed');
347: RAISE FND_API.G_EXC_ERROR;
348: end if;

Line 345: (l_return_status = FND_API.G_RET_STS_ERROR) then

341: );
342:
343: -- If API call returns with an error status...
344: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
345: (l_return_status = FND_API.G_RET_STS_ERROR) then
346: --dbms_output.put_line(l_api_name || ' Create_Cust_Reg_Item failed');
347: RAISE FND_API.G_EXC_ERROR;
348: end if;
349:

Line 347: RAISE FND_API.G_EXC_ERROR;

343: -- If API call returns with an error status...
344: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
345: (l_return_status = FND_API.G_RET_STS_ERROR) then
346: --dbms_output.put_line(l_api_name || ' Create_Cust_Reg_Item failed');
347: RAISE FND_API.G_EXC_ERROR;
348: end if;
349:
350: p_return_status := FND_API.G_RET_STS_SUCCESS;
351:

Line 350: p_return_status := FND_API.G_RET_STS_SUCCESS;

346: --dbms_output.put_line(l_api_name || ' Create_Cust_Reg_Item failed');
347: RAISE FND_API.G_EXC_ERROR;
348: end if;
349:
350: p_return_status := FND_API.G_RET_STS_SUCCESS;
351:
352: EXCEPTION
353: WHEN FND_API.G_EXC_ERROR THEN
354: p_return_status := FND_API.G_RET_STS_ERROR;

Line 353: WHEN FND_API.G_EXC_ERROR THEN

349:
350: p_return_status := FND_API.G_RET_STS_SUCCESS;
351:
352: EXCEPTION
353: WHEN FND_API.G_EXC_ERROR THEN
354: p_return_status := FND_API.G_RET_STS_ERROR;
355: rollback to start_create_cust_reg_item;
356: WHEN OTHERS THEN
357: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 354: p_return_status := FND_API.G_RET_STS_ERROR;

350: p_return_status := FND_API.G_RET_STS_SUCCESS;
351:
352: EXCEPTION
353: WHEN FND_API.G_EXC_ERROR THEN
354: p_return_status := FND_API.G_RET_STS_ERROR;
355: rollback to start_create_cust_reg_item;
356: WHEN OTHERS THEN
357: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: rollback to start_create_cust_reg_item;

Line 357: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

353: WHEN FND_API.G_EXC_ERROR THEN
354: p_return_status := FND_API.G_RET_STS_ERROR;
355: rollback to start_create_cust_reg_item;
356: WHEN OTHERS THEN
357: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: rollback to start_create_cust_reg_item;
359: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
360: SUBSTR (SQLERRM, 1, 240) );
361: FND_MSG_PUB.Add;

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

379: -- Version Initial version number = 1.0
380: -- History Current version number = 1.0
381: --=======================================================
382: procedure CREATE_CRITERIA (
383: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
384: p_api_version_number IN NUMBER,
385: p_init_msg_tbl IN BOOLEAN := FALSE,
386: p_msg_count OUT NOCOPY NUMBER,
387: p_msg_data OUT NOCOPY VARCHAR2,

Line 396: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,

392: p_region_code IN VARCHAR2,
393: p_attr_appl_id IN NUMBER,
394: p_attr_code IN VARCHAR2,
395: p_sequence_number IN NUMBER,
396: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
397: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
398: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
399: p_value_date IN DATE := FND_API.G_MISS_DATE,
400: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,

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

393: p_attr_appl_id IN NUMBER,
394: p_attr_code IN VARCHAR2,
395: p_sequence_number IN NUMBER,
396: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
397: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
398: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
399: p_value_date IN DATE := FND_API.G_MISS_DATE,
400: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
401: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

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

394: p_attr_code IN VARCHAR2,
395: p_sequence_number IN NUMBER,
396: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
397: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
398: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
399: p_value_date IN DATE := FND_API.G_MISS_DATE,
400: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
401: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
402: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

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

395: p_sequence_number IN NUMBER,
396: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
397: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
398: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
399: p_value_date IN DATE := FND_API.G_MISS_DATE,
400: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
401: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
402: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
403: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 400: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,

396: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
397: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
398: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
399: p_value_date IN DATE := FND_API.G_MISS_DATE,
400: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
401: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
402: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
403: p_creation_date IN DATE := FND_API.G_MISS_DATE,
404: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 401: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

397: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
398: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
399: p_value_date IN DATE := FND_API.G_MISS_DATE,
400: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
401: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
402: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
403: p_creation_date IN DATE := FND_API.G_MISS_DATE,
404: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
405: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

398: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
399: p_value_date IN DATE := FND_API.G_MISS_DATE,
400: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
401: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
402: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
403: p_creation_date IN DATE := FND_API.G_MISS_DATE,
404: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
405: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
406: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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

399: p_value_date IN DATE := FND_API.G_MISS_DATE,
400: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
401: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
402: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
403: p_creation_date IN DATE := FND_API.G_MISS_DATE,
404: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
405: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
406: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
407: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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

400: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
401: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
402: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
403: p_creation_date IN DATE := FND_API.G_MISS_DATE,
404: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
405: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
406: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
407: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
408: p_pass IN NUMBER,

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

401: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
402: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
403: p_creation_date IN DATE := FND_API.G_MISS_DATE,
404: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
405: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
406: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
407: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
408: p_pass IN NUMBER,
409: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

Line 406: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

402: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
403: p_creation_date IN DATE := FND_API.G_MISS_DATE,
404: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
405: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
406: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
407: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
408: p_pass IN NUMBER,
409: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
410: ) is

Line 407: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

403: p_creation_date IN DATE := FND_API.G_MISS_DATE,
404: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
405: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
406: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
407: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
408: p_pass IN NUMBER,
409: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
410: ) is
411: l_api_version_number CONSTANT number := 1.0;

Line 418: IF NOT FND_API.Compatible_API_Call (

414: l_pass NUMBER := 2;
415: l_copy_redo_flag BOOLEAN := FALSE;
416: begin
417: -- Check API version number
418: IF NOT FND_API.Compatible_API_Call (
419: l_api_version_number, p_api_version_number, l_api_name,
420: G_PKG_NAME) then
421: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: return;

Line 421: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

417: -- Check API version number
418: IF NOT FND_API.Compatible_API_Call (
419: l_api_version_number, p_api_version_number, l_api_name,
420: G_PKG_NAME) then
421: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: return;
423: END IF;
424:
425: -- Initialize the message table if requested.

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

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

Line 465: (l_return_status = FND_API.G_RET_STS_ERROR) then

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

Line 467: RAISE FND_API.G_EXC_ERROR;

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

Line 470: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 473: WHEN FND_API.G_EXC_ERROR THEN

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

Line 474: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 477: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

524: -- Version Initial version number = 1.0
525: -- History Current version number = 1.0
526: --=======================================================
527: procedure DOWNLOAD_CUSTOM (
528: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
529: p_api_version_number IN NUMBER,
530: p_init_msg_tbl IN BOOLEAN := FALSE,
531: p_msg_count OUT NOCOPY NUMBER,
532: p_msg_data OUT NOCOPY VARCHAR2,

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

530: p_init_msg_tbl IN BOOLEAN := FALSE,
531: p_msg_count OUT NOCOPY NUMBER,
532: p_msg_data OUT NOCOPY VARCHAR2,
533: p_return_status OUT NOCOPY VARCHAR2,
534: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
535: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
536: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
537: p_custom_pk_tbl IN AK_CUSTOM_PUB.Custom_PK_Tbl_Type := AK_CUSTOM_PUB.G_MISS_CUSTOM_PK_TBL,
538: p_level IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

531: p_msg_count OUT NOCOPY NUMBER,
532: p_msg_data OUT NOCOPY VARCHAR2,
533: p_return_status OUT NOCOPY VARCHAR2,
534: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
535: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
536: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
537: p_custom_pk_tbl IN AK_CUSTOM_PUB.Custom_PK_Tbl_Type := AK_CUSTOM_PUB.G_MISS_CUSTOM_PK_TBL,
538: p_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
539: p_levelpk IN VARCHAR2 := FND_API.G_MISS_CHAR

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

532: p_msg_data OUT NOCOPY VARCHAR2,
533: p_return_status OUT NOCOPY VARCHAR2,
534: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
535: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
536: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
537: p_custom_pk_tbl IN AK_CUSTOM_PUB.Custom_PK_Tbl_Type := AK_CUSTOM_PUB.G_MISS_CUSTOM_PK_TBL,
538: p_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
539: p_levelpk IN VARCHAR2 := FND_API.G_MISS_CHAR
540: ) is

Line 538: p_level IN VARCHAR2 := FND_API.G_MISS_CHAR,

534: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
535: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
536: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
537: p_custom_pk_tbl IN AK_CUSTOM_PUB.Custom_PK_Tbl_Type := AK_CUSTOM_PUB.G_MISS_CUSTOM_PK_TBL,
538: p_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
539: p_levelpk IN VARCHAR2 := FND_API.G_MISS_CHAR
540: ) is
541: l_api_version_number CONSTANT number := 1.0;
542: l_api_name CONSTANT varchar2(30) := 'Download_Custom';

Line 539: p_levelpk IN VARCHAR2 := FND_API.G_MISS_CHAR

535: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
536: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
537: p_custom_pk_tbl IN AK_CUSTOM_PUB.Custom_PK_Tbl_Type := AK_CUSTOM_PUB.G_MISS_CUSTOM_PK_TBL,
538: p_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
539: p_levelpk IN VARCHAR2 := FND_API.G_MISS_CHAR
540: ) is
541: l_api_version_number CONSTANT number := 1.0;
542: l_api_name CONSTANT varchar2(30) := 'Download_Custom';
543: l_application_id number;

Line 552: IF NOT FND_API.Compatible_API_Call (

548: l_return_status varchar2(1);
549: begin
550:
551: -- Check verion number
552: IF NOT FND_API.Compatible_API_Call (
553: l_api_version_number, p_api_version_number, l_api_name,
554: G_PKG_NAME) then
555: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: return;

Line 555: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

551: -- Check verion number
552: IF NOT FND_API.Compatible_API_Call (
553: l_api_version_number, p_api_version_number, l_api_name,
554: G_PKG_NAME) then
555: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: return;
557: END IF;
558:
559: -- Initialize the message table if requested.

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

586: from dual;
587: end if;
588:
589: -- If API call returns with an error status...
590: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
591: (l_return_status = FND_API.G_RET_STS_ERROR) then
592: --dbms_output.put_line(G_PKG_NAME || ' download_header failed');
593: RAISE FND_API.G_EXC_ERROR;
594: end if;

Line 591: (l_return_status = FND_API.G_RET_STS_ERROR) then

587: end if;
588:
589: -- If API call returns with an error status...
590: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
591: (l_return_status = FND_API.G_RET_STS_ERROR) then
592: --dbms_output.put_line(G_PKG_NAME || ' download_header failed');
593: RAISE FND_API.G_EXC_ERROR;
594: end if;
595:

Line 593: RAISE FND_API.G_EXC_ERROR;

589: -- If API call returns with an error status...
590: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
591: (l_return_status = FND_API.G_RET_STS_ERROR) then
592: --dbms_output.put_line(G_PKG_NAME || ' download_header failed');
593: RAISE FND_API.G_EXC_ERROR;
594: end if;
595:
596: -- - call the download procedure for regions to retrieve the
597: -- selected regions and their referenced objects and attributes

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

609: );
610:
611: -- If download call returns with an error status or
612: -- download failed to retrieve any information from the database..
613: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
614: (l_return_status = FND_API.G_RET_STS_ERROR) then
615: --dbms_output.put_line(G_PKG_NAME || 'download failed');
616: RAISE FND_API.G_EXC_ERROR;
617: end if;

Line 614: (l_return_status = FND_API.G_RET_STS_ERROR) then

610:
611: -- If download call returns with an error status or
612: -- download failed to retrieve any information from the database..
613: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
614: (l_return_status = FND_API.G_RET_STS_ERROR) then
615: --dbms_output.put_line(G_PKG_NAME || 'download failed');
616: RAISE FND_API.G_EXC_ERROR;
617: end if;
618:

Line 616: RAISE FND_API.G_EXC_ERROR;

612: -- download failed to retrieve any information from the database..
613: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
614: (l_return_status = FND_API.G_RET_STS_ERROR) then
615: --dbms_output.put_line(G_PKG_NAME || 'download failed');
616: RAISE FND_API.G_EXC_ERROR;
617: end if;
618:
619: --dbms_output.put_line('got ' || to_char(l_buffer_tbl.count) || ' lines');
620:

Line 621: p_return_status := FND_API.G_RET_STS_SUCCESS;

617: end if;
618:
619: --dbms_output.put_line('got ' || to_char(l_buffer_tbl.count) || ' lines');
620:
621: p_return_status := FND_API.G_RET_STS_SUCCESS;
622:
623: FND_MSG_PUB.Count_And_Get (
624: p_count => p_msg_count,
625: p_data => p_msg_data);

Line 628: WHEN FND_API.G_EXC_ERROR THEN

624: p_count => p_msg_count,
625: p_data => p_msg_data);
626:
627: EXCEPTION
628: WHEN FND_API.G_EXC_ERROR THEN
629: rollback to Start_Custom_download;
630: p_return_status := FND_API.G_RET_STS_ERROR;
631: FND_MSG_PUB.Count_And_Get (
632: p_count => p_msg_count,

Line 630: p_return_status := FND_API.G_RET_STS_ERROR;

626:
627: EXCEPTION
628: WHEN FND_API.G_EXC_ERROR THEN
629: rollback to Start_Custom_download;
630: p_return_status := FND_API.G_RET_STS_ERROR;
631: FND_MSG_PUB.Count_And_Get (
632: p_count => p_msg_count,
633: p_data => p_msg_data);
634: WHEN OTHERS THEN

Line 635: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

631: FND_MSG_PUB.Count_And_Get (
632: p_count => p_msg_count,
633: p_data => p_msg_data);
634: WHEN OTHERS THEN
635: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: rollback to Start_Custom_download;
637: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
638: SUBSTR (SQLERRM, 1, 240) );
639: FND_MSG_PUB.Add;

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

661: -- Version Initial version number = 1.0
662: -- History Current version number = 1.0
663: --=======================================================
664: procedure UPDATE_CUSTOM (
665: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
666: p_api_version_number IN NUMBER,
667: p_init_msg_tbl IN BOOLEAN := FALSE,
668: p_msg_count OUT NOCOPY NUMBER,
669: p_msg_data OUT NOCOPY VARCHAR2,

Line 675: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,

671: p_custom_appl_id IN NUMBER,
672: p_custom_appl_code IN VARCHAR2,
673: p_region_application_id IN NUMBER,
674: p_region_code IN VARCHAR2,
675: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
676: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
677: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
678: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
679: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,

Line 676: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

672: p_custom_appl_code IN VARCHAR2,
673: p_region_application_id IN NUMBER,
674: p_region_code IN VARCHAR2,
675: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
676: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
677: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
678: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
679: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
680: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,

Line 677: p_org_id IN NUMBER := FND_API.G_MISS_NUM,

673: p_region_application_id IN NUMBER,
674: p_region_code IN VARCHAR2,
675: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
676: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
677: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
678: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
679: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
680: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
681: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 678: p_site_id IN NUMBER := FND_API.G_MISS_NUM,

674: p_region_code IN VARCHAR2,
675: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
676: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
677: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
678: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
679: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
680: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
681: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
682: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,

Line 679: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,

675: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
676: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
677: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
678: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
679: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
680: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
681: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
682: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
683: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 680: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,

676: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
677: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
678: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
679: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
680: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
681: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
682: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
683: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
684: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 681: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

677: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
678: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
679: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
680: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
681: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
682: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
683: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
684: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
685: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 682: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,

678: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
679: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
680: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
681: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
682: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
683: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
684: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
685: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
686: p_start_date_active IN DATE := FND_API.G_MISS_DATE,

Line 683: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,

679: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
680: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
681: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
682: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
683: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
684: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
685: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
686: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
687: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

Line 684: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,

680: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
681: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
682: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
683: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
684: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
685: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
686: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
687: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
688: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 685: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

681: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
682: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
683: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
684: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
685: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
686: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
687: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
688: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
689: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 686: p_start_date_active IN DATE := FND_API.G_MISS_DATE,

682: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
683: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
684: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
685: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
686: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
687: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
688: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
689: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
690: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 687: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

683: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
684: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
685: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
686: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
687: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
688: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
689: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
690: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
691: p_creation_date IN DATE := FND_API.G_MISS_DATE,

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

684: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
685: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
686: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
687: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
688: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
689: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
690: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
691: p_creation_date IN DATE := FND_API.G_MISS_DATE,
692: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

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

685: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
686: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
687: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
688: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
689: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
690: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
691: p_creation_date IN DATE := FND_API.G_MISS_DATE,
692: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
693: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

686: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
687: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
688: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
689: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
690: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
691: p_creation_date IN DATE := FND_API.G_MISS_DATE,
692: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
693: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
694: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

687: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
688: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
689: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
690: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
691: p_creation_date IN DATE := FND_API.G_MISS_DATE,
692: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
693: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
694: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
695: ) is

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

688: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
689: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
690: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
691: p_creation_date IN DATE := FND_API.G_MISS_DATE,
692: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
693: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
694: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
695: ) is
696: l_api_version_number CONSTANT number := 1.0;

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

689: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
690: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
691: p_creation_date IN DATE := FND_API.G_MISS_DATE,
692: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
693: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
694: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
695: ) is
696: l_api_version_number CONSTANT number := 1.0;
697: l_api_name CONSTANT varchar2(30) := 'Update_Custom';

Line 694: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

690: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
691: p_creation_date IN DATE := FND_API.G_MISS_DATE,
692: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
693: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
694: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
695: ) is
696: l_api_version_number CONSTANT number := 1.0;
697: l_api_name CONSTANT varchar2(30) := 'Update_Custom';
698: l_return_status VARCHAR2(1);

Line 703: IF NOT FND_API.Compatible_API_Call (

699: l_pass NUMBER := 2;
700: l_copy_redo_flag BOOLEAN := FALSE;
701: begin
702: -- Check API version number
703: IF NOT FND_API.Compatible_API_Call (
704: l_api_version_number, p_api_version_number, l_api_name,
705: G_PKG_NAME) then
706: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707: return;

Line 706: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

702: -- Check API version number
703: IF NOT FND_API.Compatible_API_Call (
704: l_api_version_number, p_api_version_number, l_api_name,
705: G_PKG_NAME) then
706: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707: return;
708: END IF;
709:
710: -- Initialize the message table if requested.

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

750: p_copy_redo_flag => l_copy_redo_flag
751: );
752:
753: -- If API call returns with an error status...
754: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
755: (l_return_status = FND_API.G_RET_STS_ERROR) then
756: --dbms_output.put_line(l_api_name || ' Update_Custom failed');
757: RAISE FND_API.G_EXC_ERROR;
758: end if;

Line 755: (l_return_status = FND_API.G_RET_STS_ERROR) then

751: );
752:
753: -- If API call returns with an error status...
754: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
755: (l_return_status = FND_API.G_RET_STS_ERROR) then
756: --dbms_output.put_line(l_api_name || ' Update_Custom failed');
757: RAISE FND_API.G_EXC_ERROR;
758: end if;
759:

Line 757: RAISE FND_API.G_EXC_ERROR;

753: -- If API call returns with an error status...
754: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
755: (l_return_status = FND_API.G_RET_STS_ERROR) then
756: --dbms_output.put_line(l_api_name || ' Update_Custom failed');
757: RAISE FND_API.G_EXC_ERROR;
758: end if;
759:
760: p_return_status := FND_API.G_RET_STS_SUCCESS;
761:

Line 760: p_return_status := FND_API.G_RET_STS_SUCCESS;

756: --dbms_output.put_line(l_api_name || ' Update_Custom failed');
757: RAISE FND_API.G_EXC_ERROR;
758: end if;
759:
760: p_return_status := FND_API.G_RET_STS_SUCCESS;
761:
762: EXCEPTION
763: WHEN FND_API.G_EXC_ERROR THEN
764: p_return_status := FND_API.G_RET_STS_ERROR;

Line 763: WHEN FND_API.G_EXC_ERROR THEN

759:
760: p_return_status := FND_API.G_RET_STS_SUCCESS;
761:
762: EXCEPTION
763: WHEN FND_API.G_EXC_ERROR THEN
764: p_return_status := FND_API.G_RET_STS_ERROR;
765: rollback to start_update_custom;
766: WHEN OTHERS THEN
767: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 764: p_return_status := FND_API.G_RET_STS_ERROR;

760: p_return_status := FND_API.G_RET_STS_SUCCESS;
761:
762: EXCEPTION
763: WHEN FND_API.G_EXC_ERROR THEN
764: p_return_status := FND_API.G_RET_STS_ERROR;
765: rollback to start_update_custom;
766: WHEN OTHERS THEN
767: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
768: rollback to start_update_custom;

Line 767: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

763: WHEN FND_API.G_EXC_ERROR THEN
764: p_return_status := FND_API.G_RET_STS_ERROR;
765: rollback to start_update_custom;
766: WHEN OTHERS THEN
767: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
768: rollback to start_update_custom;
769: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
770: SUBSTR (SQLERRM, 1, 240) );
771: FND_MSG_PUB.Add;

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

789: -- Version Initial version number = 1.0
790: -- History Current version number = 1.0
791: --=======================================================
792: procedure UPDATE_CUST_REGION (
793: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
794: p_api_version_number IN NUMBER,
795: p_init_msg_tbl IN BOOLEAN := FALSE,
796: p_msg_count OUT NOCOPY NUMBER,
797: p_msg_data OUT NOCOPY VARCHAR2,

Line 804: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

800: p_custom_appl_code IN VARCHAR2,
801: p_region_application_id IN NUMBER,
802: p_region_code IN VARCHAR2,
803: p_property_name IN VARCHAR2,
804: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
806: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 805: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,

801: p_region_application_id IN NUMBER,
802: p_region_code IN VARCHAR2,
803: p_property_name IN VARCHAR2,
804: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
806: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
809: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 806: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,

802: p_region_code IN VARCHAR2,
803: p_property_name IN VARCHAR2,
804: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
806: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
809: p_creation_date IN DATE := FND_API.G_MISS_DATE,
810: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 807: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,

803: p_property_name IN VARCHAR2,
804: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
806: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
809: p_creation_date IN DATE := FND_API.G_MISS_DATE,
810: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
811: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

804: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
806: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
809: p_creation_date IN DATE := FND_API.G_MISS_DATE,
810: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
811: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
812: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

805: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
806: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
809: p_creation_date IN DATE := FND_API.G_MISS_DATE,
810: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
811: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
812: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
813: ) is

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

806: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
809: p_creation_date IN DATE := FND_API.G_MISS_DATE,
810: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
811: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
812: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
813: ) is
814: l_api_version_number CONSTANT number := 1.0;

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

807: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
809: p_creation_date IN DATE := FND_API.G_MISS_DATE,
810: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
811: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
812: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
813: ) is
814: l_api_version_number CONSTANT number := 1.0;
815: l_api_name CONSTANT varchar2(30) := 'Update_Cust_Region';

Line 812: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

808: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
809: p_creation_date IN DATE := FND_API.G_MISS_DATE,
810: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
811: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
812: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
813: ) is
814: l_api_version_number CONSTANT number := 1.0;
815: l_api_name CONSTANT varchar2(30) := 'Update_Cust_Region';
816: l_return_status VARCHAR2(1);

Line 821: IF NOT FND_API.Compatible_API_Call (

817: l_pass NUMBER := 2;
818: l_copy_redo_flag BOOLEAN := FALSE;
819: begin
820: -- Check API version number
821: IF NOT FND_API.Compatible_API_Call (
822: l_api_version_number, p_api_version_number, l_api_name,
823: G_PKG_NAME) then
824: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
825: return;

Line 824: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

820: -- Check API version number
821: IF NOT FND_API.Compatible_API_Call (
822: l_api_version_number, p_api_version_number, l_api_name,
823: G_PKG_NAME) then
824: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
825: return;
826: END IF;
827:
828: -- Initialize the message table if requested.

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

858: p_copy_redo_flag => l_copy_redo_flag
859: );
860:
861: -- If API call returns with an error status...
862: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
863: (l_return_status = FND_API.G_RET_STS_ERROR) then
864: --dbms_output.put_line(l_api_name || ' Update_Cust_Region failed');
865: RAISE FND_API.G_EXC_ERROR;
866: end if;

Line 863: (l_return_status = FND_API.G_RET_STS_ERROR) then

859: );
860:
861: -- If API call returns with an error status...
862: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
863: (l_return_status = FND_API.G_RET_STS_ERROR) then
864: --dbms_output.put_line(l_api_name || ' Update_Cust_Region failed');
865: RAISE FND_API.G_EXC_ERROR;
866: end if;
867:

Line 865: RAISE FND_API.G_EXC_ERROR;

861: -- If API call returns with an error status...
862: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
863: (l_return_status = FND_API.G_RET_STS_ERROR) then
864: --dbms_output.put_line(l_api_name || ' Update_Cust_Region failed');
865: RAISE FND_API.G_EXC_ERROR;
866: end if;
867:
868: p_return_status := FND_API.G_RET_STS_SUCCESS;
869:

Line 868: p_return_status := FND_API.G_RET_STS_SUCCESS;

864: --dbms_output.put_line(l_api_name || ' Update_Cust_Region failed');
865: RAISE FND_API.G_EXC_ERROR;
866: end if;
867:
868: p_return_status := FND_API.G_RET_STS_SUCCESS;
869:
870: EXCEPTION
871: WHEN FND_API.G_EXC_ERROR THEN
872: p_return_status := FND_API.G_RET_STS_ERROR;

Line 871: WHEN FND_API.G_EXC_ERROR THEN

867:
868: p_return_status := FND_API.G_RET_STS_SUCCESS;
869:
870: EXCEPTION
871: WHEN FND_API.G_EXC_ERROR THEN
872: p_return_status := FND_API.G_RET_STS_ERROR;
873: rollback to start_update_cust_region;
874: WHEN OTHERS THEN
875: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 872: p_return_status := FND_API.G_RET_STS_ERROR;

868: p_return_status := FND_API.G_RET_STS_SUCCESS;
869:
870: EXCEPTION
871: WHEN FND_API.G_EXC_ERROR THEN
872: p_return_status := FND_API.G_RET_STS_ERROR;
873: rollback to start_update_cust_region;
874: WHEN OTHERS THEN
875: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
876: rollback to start_update_cust_region;

Line 875: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

871: WHEN FND_API.G_EXC_ERROR THEN
872: p_return_status := FND_API.G_RET_STS_ERROR;
873: rollback to start_update_cust_region;
874: WHEN OTHERS THEN
875: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
876: rollback to start_update_cust_region;
877: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
878: SUBSTR (SQLERRM, 1, 240) );
879: FND_MSG_PUB.Add;

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

897: -- Version Initial version number = 1.0
898: -- History Current version number = 1.0
899: --=======================================================
900: procedure UPDATE_CUST_REG_ITEM (
901: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
902: p_api_version_number IN NUMBER,
903: p_init_msg_tbl IN BOOLEAN := FALSE,
904: p_msg_count OUT NOCOPY NUMBER,
905: p_msg_data OUT NOCOPY VARCHAR2,

Line 914: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

910: p_region_code IN VARCHAR2,
911: p_attribute_appl_id IN NUMBER,
912: p_attribute_code IN VARCHAR2,
913: p_property_name IN VARCHAR2,
914: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
915: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
916: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
917: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
918: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 915: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,

911: p_attribute_appl_id IN NUMBER,
912: p_attribute_code IN VARCHAR2,
913: p_property_name IN VARCHAR2,
914: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
915: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
916: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
917: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
918: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
919: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 916: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

912: p_attribute_code IN VARCHAR2,
913: p_property_name IN VARCHAR2,
914: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
915: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
916: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
917: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
918: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
919: p_creation_date IN DATE := FND_API.G_MISS_DATE,
920: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 917: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,

913: p_property_name IN VARCHAR2,
914: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
915: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
916: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
917: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
918: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
919: p_creation_date IN DATE := FND_API.G_MISS_DATE,
920: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
921: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

914: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
915: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
916: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
917: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
918: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
919: p_creation_date IN DATE := FND_API.G_MISS_DATE,
920: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
921: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
922: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

915: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
916: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
917: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
918: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
919: p_creation_date IN DATE := FND_API.G_MISS_DATE,
920: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
921: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
922: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
923: ) is

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

916: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
917: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
918: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
919: p_creation_date IN DATE := FND_API.G_MISS_DATE,
920: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
921: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
922: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
923: ) is
924: l_api_version_number CONSTANT number := 1.0;

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

917: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
918: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
919: p_creation_date IN DATE := FND_API.G_MISS_DATE,
920: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
921: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
922: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
923: ) is
924: l_api_version_number CONSTANT number := 1.0;
925: l_api_name CONSTANT varchar2(30) := 'Update_Cust_Reg_Item';

Line 922: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

918: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
919: p_creation_date IN DATE := FND_API.G_MISS_DATE,
920: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
921: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
922: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
923: ) is
924: l_api_version_number CONSTANT number := 1.0;
925: l_api_name CONSTANT varchar2(30) := 'Update_Cust_Reg_Item';
926: l_return_status VARCHAR2(1);

Line 931: IF NOT FND_API.Compatible_API_Call (

927: l_pass NUMBER := 2;
928: l_copy_redo_flag BOOLEAN := FALSE;
929: begin
930: -- Check API version number
931: IF NOT FND_API.Compatible_API_Call (
932: l_api_version_number, p_api_version_number, l_api_name,
933: G_PKG_NAME) then
934: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
935: return;

Line 934: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

930: -- Check API version number
931: IF NOT FND_API.Compatible_API_Call (
932: l_api_version_number, p_api_version_number, l_api_name,
933: G_PKG_NAME) then
934: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
935: return;
936: END IF;
937:
938: -- Initialize the message table if requested.

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

970: p_copy_redo_flag => l_copy_redo_flag
971: );
972:
973: -- If API call returns with an error status...
974: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
975: (l_return_status = FND_API.G_RET_STS_ERROR) then
976: --dbms_output.put_line(l_api_name || ' Update_Cust_Reg_Item failed');
977: RAISE FND_API.G_EXC_ERROR;
978: end if;

Line 975: (l_return_status = FND_API.G_RET_STS_ERROR) then

971: );
972:
973: -- If API call returns with an error status...
974: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
975: (l_return_status = FND_API.G_RET_STS_ERROR) then
976: --dbms_output.put_line(l_api_name || ' Update_Cust_Reg_Item failed');
977: RAISE FND_API.G_EXC_ERROR;
978: end if;
979:

Line 977: RAISE FND_API.G_EXC_ERROR;

973: -- If API call returns with an error status...
974: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
975: (l_return_status = FND_API.G_RET_STS_ERROR) then
976: --dbms_output.put_line(l_api_name || ' Update_Cust_Reg_Item failed');
977: RAISE FND_API.G_EXC_ERROR;
978: end if;
979:
980: p_return_status := FND_API.G_RET_STS_SUCCESS;
981:

Line 980: p_return_status := FND_API.G_RET_STS_SUCCESS;

976: --dbms_output.put_line(l_api_name || ' Update_Cust_Reg_Item failed');
977: RAISE FND_API.G_EXC_ERROR;
978: end if;
979:
980: p_return_status := FND_API.G_RET_STS_SUCCESS;
981:
982: EXCEPTION
983: WHEN FND_API.G_EXC_ERROR THEN
984: p_return_status := FND_API.G_RET_STS_ERROR;

Line 983: WHEN FND_API.G_EXC_ERROR THEN

979:
980: p_return_status := FND_API.G_RET_STS_SUCCESS;
981:
982: EXCEPTION
983: WHEN FND_API.G_EXC_ERROR THEN
984: p_return_status := FND_API.G_RET_STS_ERROR;
985: rollback to start_update_cust_reg_item;
986: WHEN OTHERS THEN
987: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 984: p_return_status := FND_API.G_RET_STS_ERROR;

980: p_return_status := FND_API.G_RET_STS_SUCCESS;
981:
982: EXCEPTION
983: WHEN FND_API.G_EXC_ERROR THEN
984: p_return_status := FND_API.G_RET_STS_ERROR;
985: rollback to start_update_cust_reg_item;
986: WHEN OTHERS THEN
987: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
988: rollback to start_update_cust_reg_item;

Line 987: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

983: WHEN FND_API.G_EXC_ERROR THEN
984: p_return_status := FND_API.G_RET_STS_ERROR;
985: rollback to start_update_cust_reg_item;
986: WHEN OTHERS THEN
987: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
988: rollback to start_update_cust_reg_item;
989: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
990: SUBSTR (SQLERRM, 1, 240) );
991: FND_MSG_PUB.Add;

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

1009: -- Version Initial version number = 1.0
1010: -- History Current version number = 1.0
1011: --=======================================================
1012: procedure UPDATE_CRITERIA (
1013: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1014: p_api_version_number IN NUMBER,
1015: p_init_msg_tbl IN BOOLEAN := FALSE,
1016: p_msg_count OUT NOCOPY NUMBER,
1017: p_msg_data OUT NOCOPY VARCHAR2,

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

1023: p_attribute_appl_id IN NUMBER,
1024: p_attribute_code IN VARCHAR2,
1025: p_sequence_number IN NUMBER,
1026: p_operation IN VARCHAR2,
1027: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1028: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
1029: p_value_date IN DATE := FND_API.G_MISS_DATE,
1030: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
1031: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

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

1024: p_attribute_code IN VARCHAR2,
1025: p_sequence_number IN NUMBER,
1026: p_operation IN VARCHAR2,
1027: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1028: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
1029: p_value_date IN DATE := FND_API.G_MISS_DATE,
1030: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
1031: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
1032: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

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

1025: p_sequence_number IN NUMBER,
1026: p_operation IN VARCHAR2,
1027: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1028: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
1029: p_value_date IN DATE := FND_API.G_MISS_DATE,
1030: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
1031: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
1032: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1033: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 1030: p_start_date_active IN DATE := FND_API.G_MISS_DATE,

1026: p_operation IN VARCHAR2,
1027: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1028: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
1029: p_value_date IN DATE := FND_API.G_MISS_DATE,
1030: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
1031: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
1032: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1033: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1034: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 1031: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

1027: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1028: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
1029: p_value_date IN DATE := FND_API.G_MISS_DATE,
1030: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
1031: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
1032: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1033: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1034: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1035: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

1028: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
1029: p_value_date IN DATE := FND_API.G_MISS_DATE,
1030: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
1031: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
1032: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1033: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1034: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1035: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1036: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

1029: p_value_date IN DATE := FND_API.G_MISS_DATE,
1030: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
1031: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
1032: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1033: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1034: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1035: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1036: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1037: ) is

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

1030: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
1031: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
1032: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1033: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1034: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1035: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1036: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1037: ) is
1038: l_api_version_number CONSTANT number := 1.0;

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

1031: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
1032: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1033: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1034: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1035: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1036: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1037: ) is
1038: l_api_version_number CONSTANT number := 1.0;
1039: l_api_name CONSTANT varchar2(30) := 'Update_Criteria';

Line 1036: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

1032: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1033: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1034: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1035: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1036: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1037: ) is
1038: l_api_version_number CONSTANT number := 1.0;
1039: l_api_name CONSTANT varchar2(30) := 'Update_Criteria';
1040: l_return_status VARCHAR2(1);

Line 1045: IF NOT FND_API.Compatible_API_Call (

1041: l_pass NUMBER := 2;
1042: l_copy_redo_flag BOOLEAN := FALSE;
1043: begin
1044: -- Check API version number
1045: IF NOT FND_API.Compatible_API_Call (
1046: l_api_version_number, p_api_version_number, l_api_name,
1047: G_PKG_NAME) then
1048: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1049: return;

Line 1048: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1044: -- Check API version number
1045: IF NOT FND_API.Compatible_API_Call (
1046: l_api_version_number, p_api_version_number, l_api_name,
1047: G_PKG_NAME) then
1048: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1049: return;
1050: END IF;
1051:
1052: -- Initialize the message table if requested.

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

1086: p_copy_redo_flag => l_copy_redo_flag
1087: );
1088:
1089: -- If API call returns with an error status...
1090: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1091: (l_return_status = FND_API.G_RET_STS_ERROR) then
1092: --dbms_output.put_line(l_api_name || ' Update_Criteria failed');
1093: RAISE FND_API.G_EXC_ERROR;
1094: end if;

Line 1091: (l_return_status = FND_API.G_RET_STS_ERROR) then

1087: );
1088:
1089: -- If API call returns with an error status...
1090: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1091: (l_return_status = FND_API.G_RET_STS_ERROR) then
1092: --dbms_output.put_line(l_api_name || ' Update_Criteria failed');
1093: RAISE FND_API.G_EXC_ERROR;
1094: end if;
1095:

Line 1093: RAISE FND_API.G_EXC_ERROR;

1089: -- If API call returns with an error status...
1090: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1091: (l_return_status = FND_API.G_RET_STS_ERROR) then
1092: --dbms_output.put_line(l_api_name || ' Update_Criteria failed');
1093: RAISE FND_API.G_EXC_ERROR;
1094: end if;
1095:
1096: p_return_status := FND_API.G_RET_STS_SUCCESS;
1097:

Line 1096: p_return_status := FND_API.G_RET_STS_SUCCESS;

1092: --dbms_output.put_line(l_api_name || ' Update_Criteria failed');
1093: RAISE FND_API.G_EXC_ERROR;
1094: end if;
1095:
1096: p_return_status := FND_API.G_RET_STS_SUCCESS;
1097:
1098: EXCEPTION
1099: WHEN FND_API.G_EXC_ERROR THEN
1100: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1099: WHEN FND_API.G_EXC_ERROR THEN

1095:
1096: p_return_status := FND_API.G_RET_STS_SUCCESS;
1097:
1098: EXCEPTION
1099: WHEN FND_API.G_EXC_ERROR THEN
1100: p_return_status := FND_API.G_RET_STS_ERROR;
1101: rollback to start_update_critieria;
1102: WHEN OTHERS THEN
1103: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1100: p_return_status := FND_API.G_RET_STS_ERROR;

1096: p_return_status := FND_API.G_RET_STS_SUCCESS;
1097:
1098: EXCEPTION
1099: WHEN FND_API.G_EXC_ERROR THEN
1100: p_return_status := FND_API.G_RET_STS_ERROR;
1101: rollback to start_update_critieria;
1102: WHEN OTHERS THEN
1103: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1104: rollback to start_update_criteria;

Line 1103: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1099: WHEN FND_API.G_EXC_ERROR THEN
1100: p_return_status := FND_API.G_RET_STS_ERROR;
1101: rollback to start_update_critieria;
1102: WHEN OTHERS THEN
1103: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1104: rollback to start_update_criteria;
1105: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1106: SUBSTR (SQLERRM, 1, 240) );
1107: FND_MSG_PUB.Add;