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_FLOW_GRP dependencies on FND_API

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

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

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

30: p_return_status OUT NOCOPY VARCHAR2,
31: p_flow_application_id IN NUMBER,
32: p_flow_code IN VARCHAR2,
33: p_name IN VARCHAR2,
34: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
36: p_creation_date IN DATE := FND_API.G_MISS_DATE,
37: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
38: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

31: p_flow_application_id IN NUMBER,
32: p_flow_code IN VARCHAR2,
33: p_name IN VARCHAR2,
34: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
36: p_creation_date IN DATE := FND_API.G_MISS_DATE,
37: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
38: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
39: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

32: p_flow_code IN VARCHAR2,
33: p_name IN VARCHAR2,
34: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
36: p_creation_date IN DATE := FND_API.G_MISS_DATE,
37: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
38: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
39: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
40: ) is

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

33: p_name IN VARCHAR2,
34: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
36: p_creation_date IN DATE := FND_API.G_MISS_DATE,
37: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
38: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
39: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
40: ) is
41: l_api_version_number CONSTANT number := 1.0;

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

34: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
36: p_creation_date IN DATE := FND_API.G_MISS_DATE,
37: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
38: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
39: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
40: ) is
41: l_api_version_number CONSTANT number := 1.0;
42: l_api_name CONSTANT varchar2(30) := 'Create_Flow';

Line 39: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

35: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
36: p_creation_date IN DATE := FND_API.G_MISS_DATE,
37: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
38: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
39: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
40: ) is
41: l_api_version_number CONSTANT number := 1.0;
42: l_api_name CONSTANT varchar2(30) := 'Create_Flow';
43: l_return_status VARCHAR2(1);

Line 48: IF NOT FND_API.Compatible_API_Call (

44: l_pass NUMBER := 2;
45: l_copy_redo_flag BOOLEAN := FALSE;
46: begin
47: -- Check API version number
48: IF NOT FND_API.Compatible_API_Call (
49: l_api_version_number, p_api_version_number, l_api_name,
50: G_PKG_NAME) then
51: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
52: return;

Line 51: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

47: -- Check API version number
48: IF NOT FND_API.Compatible_API_Call (
49: l_api_version_number, p_api_version_number, l_api_name,
50: G_PKG_NAME) then
51: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
52: return;
53: END IF;
54:
55: -- Initialize the message table if requested.

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

80: p_copy_redo_flag => l_copy_redo_flag
81: );
82:
83: -- If API call returns with an error status...
84: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
85: (l_return_status = FND_API.G_RET_STS_ERROR) then
86: RAISE FND_API.G_EXC_ERROR;
87: end if;
88:

Line 85: (l_return_status = FND_API.G_RET_STS_ERROR) then

81: );
82:
83: -- If API call returns with an error status...
84: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
85: (l_return_status = FND_API.G_RET_STS_ERROR) then
86: RAISE FND_API.G_EXC_ERROR;
87: end if;
88:
89: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 86: RAISE FND_API.G_EXC_ERROR;

82:
83: -- If API call returns with an error status...
84: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
85: (l_return_status = FND_API.G_RET_STS_ERROR) then
86: RAISE FND_API.G_EXC_ERROR;
87: end if;
88:
89: p_return_status := FND_API.G_RET_STS_SUCCESS;
90:

Line 89: p_return_status := FND_API.G_RET_STS_SUCCESS;

85: (l_return_status = FND_API.G_RET_STS_ERROR) then
86: RAISE FND_API.G_EXC_ERROR;
87: end if;
88:
89: p_return_status := FND_API.G_RET_STS_SUCCESS;
90:
91: EXCEPTION
92: WHEN FND_API.G_EXC_ERROR THEN
93: p_return_status := FND_API.G_RET_STS_ERROR;

Line 92: WHEN FND_API.G_EXC_ERROR THEN

88:
89: p_return_status := FND_API.G_RET_STS_SUCCESS;
90:
91: EXCEPTION
92: WHEN FND_API.G_EXC_ERROR THEN
93: p_return_status := FND_API.G_RET_STS_ERROR;
94: rollback to start_create_flow;
95: WHEN OTHERS THEN
96: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 93: p_return_status := FND_API.G_RET_STS_ERROR;

89: p_return_status := FND_API.G_RET_STS_SUCCESS;
90:
91: EXCEPTION
92: WHEN FND_API.G_EXC_ERROR THEN
93: p_return_status := FND_API.G_RET_STS_ERROR;
94: rollback to start_create_flow;
95: WHEN OTHERS THEN
96: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
97: rollback to start_create_flow;

Line 96: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

92: WHEN FND_API.G_EXC_ERROR THEN
93: p_return_status := FND_API.G_RET_STS_ERROR;
94: rollback to start_create_flow;
95: WHEN OTHERS THEN
96: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
97: rollback to start_create_flow;
98: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
99: SUBSTR (SQLERRM, 1, 240) );
100: FND_MSG_PUB.Add;

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

123: -- Version Initial version number = 1.0
124: -- History Current version number = 1.0
125: --=======================================================
126: procedure CREATE_PAGE (
127: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
128: p_api_version_number IN NUMBER,
129: p_init_msg_tbl IN BOOLEAN := FALSE,
130: p_msg_count OUT NOCOPY NUMBER,
131: p_msg_data OUT NOCOPY VARCHAR2,

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

134: p_flow_code IN VARCHAR2,
135: p_page_application_id IN NUMBER,
136: p_page_code IN VARCHAR2,
137: p_name IN VARCHAR2,
138: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
141: p_creation_date IN DATE := FND_API.G_MISS_DATE,
142: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 139: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,

135: p_page_application_id IN NUMBER,
136: p_page_code IN VARCHAR2,
137: p_name IN VARCHAR2,
138: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
141: p_creation_date IN DATE := FND_API.G_MISS_DATE,
142: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
143: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

136: p_page_code IN VARCHAR2,
137: p_name IN VARCHAR2,
138: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
141: p_creation_date IN DATE := FND_API.G_MISS_DATE,
142: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
143: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
144: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

137: p_name IN VARCHAR2,
138: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
141: p_creation_date IN DATE := FND_API.G_MISS_DATE,
142: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
143: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
144: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
145: ) is

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

138: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
141: p_creation_date IN DATE := FND_API.G_MISS_DATE,
142: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
143: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
144: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
145: ) is
146: l_api_version_number CONSTANT number := 1.0;

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

139: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
141: p_creation_date IN DATE := FND_API.G_MISS_DATE,
142: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
143: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
144: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
145: ) is
146: l_api_version_number CONSTANT number := 1.0;
147: l_api_name CONSTANT varchar2(30) := 'Create_Page';

Line 144: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

140: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
141: p_creation_date IN DATE := FND_API.G_MISS_DATE,
142: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
143: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
144: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
145: ) is
146: l_api_version_number CONSTANT number := 1.0;
147: l_api_name CONSTANT varchar2(30) := 'Create_Page';
148: l_return_status VARCHAR2(1);

Line 153: IF NOT FND_API.Compatible_API_Call (

149: l_pass NUMBER := 2;
150: l_copy_redo_flag BOOLEAN := FALSE;
151: begin
152: -- Check API version number
153: IF NOT FND_API.Compatible_API_Call (
154: l_api_version_number, p_api_version_number, l_api_name,
155: G_PKG_NAME) then
156: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
157: return;

Line 156: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

152: -- Check API version number
153: IF NOT FND_API.Compatible_API_Call (
154: l_api_version_number, p_api_version_number, l_api_name,
155: G_PKG_NAME) then
156: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
157: return;
158: END IF;
159:
160: -- Initialize the message table if requested.

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

188: p_copy_redo_flag => l_copy_redo_flag
189: );
190:
191: -- If API call returns with an error status...
192: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
193: (l_return_status = FND_API.G_RET_STS_ERROR) then
194: RAISE FND_API.G_EXC_ERROR;
195: end if;
196:

Line 193: (l_return_status = FND_API.G_RET_STS_ERROR) then

189: );
190:
191: -- If API call returns with an error status...
192: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
193: (l_return_status = FND_API.G_RET_STS_ERROR) then
194: RAISE FND_API.G_EXC_ERROR;
195: end if;
196:
197: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 194: RAISE FND_API.G_EXC_ERROR;

190:
191: -- If API call returns with an error status...
192: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
193: (l_return_status = FND_API.G_RET_STS_ERROR) then
194: RAISE FND_API.G_EXC_ERROR;
195: end if;
196:
197: p_return_status := FND_API.G_RET_STS_SUCCESS;
198:

Line 197: p_return_status := FND_API.G_RET_STS_SUCCESS;

193: (l_return_status = FND_API.G_RET_STS_ERROR) then
194: RAISE FND_API.G_EXC_ERROR;
195: end if;
196:
197: p_return_status := FND_API.G_RET_STS_SUCCESS;
198:
199: EXCEPTION
200: WHEN FND_API.G_EXC_ERROR THEN
201: p_return_status := FND_API.G_RET_STS_ERROR;

Line 200: WHEN FND_API.G_EXC_ERROR THEN

196:
197: p_return_status := FND_API.G_RET_STS_SUCCESS;
198:
199: EXCEPTION
200: WHEN FND_API.G_EXC_ERROR THEN
201: p_return_status := FND_API.G_RET_STS_ERROR;
202: rollback to start_create_page;
203: WHEN OTHERS THEN
204: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 201: p_return_status := FND_API.G_RET_STS_ERROR;

197: p_return_status := FND_API.G_RET_STS_SUCCESS;
198:
199: EXCEPTION
200: WHEN FND_API.G_EXC_ERROR THEN
201: p_return_status := FND_API.G_RET_STS_ERROR;
202: rollback to start_create_page;
203: WHEN OTHERS THEN
204: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: rollback to start_create_page;

Line 204: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

200: WHEN FND_API.G_EXC_ERROR THEN
201: p_return_status := FND_API.G_RET_STS_ERROR;
202: rollback to start_create_page;
203: WHEN OTHERS THEN
204: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: rollback to start_create_page;
206: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
207: SUBSTR (SQLERRM, 1, 240) );
208: FND_MSG_PUB.Add;

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

238: -- Version Initial version number = 1.0
239: -- History Current version number = 1.0
240: --=======================================================
241: procedure CREATE_PAGE_REGION (
242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
243: p_api_version_number IN NUMBER,
244: p_init_msg_tbl IN BOOLEAN := FALSE,
245: p_msg_count OUT NOCOPY NUMBER,
246: p_msg_data OUT NOCOPY VARCHAR2,

Line 254: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,

250: p_page_application_id IN NUMBER,
251: p_page_code IN VARCHAR2,
252: p_region_application_id IN NUMBER,
253: p_region_code IN VARCHAR2,
254: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
255: p_region_style IN VARCHAR2,
256: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
257: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 256: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,

252: p_region_application_id IN NUMBER,
253: p_region_code IN VARCHAR2,
254: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
255: p_region_style IN VARCHAR2,
256: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
257: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
259: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 257: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,

253: p_region_code IN VARCHAR2,
254: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
255: p_region_style IN VARCHAR2,
256: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
257: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
259: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 258: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

254: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
255: p_region_style IN VARCHAR2,
256: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
257: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
259: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 259: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

255: p_region_style IN VARCHAR2,
256: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
257: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
259: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
263: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 260: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

256: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
257: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
259: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
263: p_creation_date IN DATE := FND_API.G_MISS_DATE,
264: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 261: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,

257: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
259: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
263: p_creation_date IN DATE := FND_API.G_MISS_DATE,
264: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
265: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

258: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
259: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
263: p_creation_date IN DATE := FND_API.G_MISS_DATE,
264: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
265: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
266: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

259: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
263: p_creation_date IN DATE := FND_API.G_MISS_DATE,
264: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
265: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
266: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
267: ) is

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

260: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
263: p_creation_date IN DATE := FND_API.G_MISS_DATE,
264: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
265: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
266: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
267: ) is
268: l_api_version_number CONSTANT number := 1.0;

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

261: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
263: p_creation_date IN DATE := FND_API.G_MISS_DATE,
264: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
265: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
266: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
267: ) is
268: l_api_version_number CONSTANT number := 1.0;
269: l_api_name CONSTANT varchar2(30) := 'Create_Page_Region';

Line 266: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

262: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
263: p_creation_date IN DATE := FND_API.G_MISS_DATE,
264: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
265: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
266: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
267: ) is
268: l_api_version_number CONSTANT number := 1.0;
269: l_api_name CONSTANT varchar2(30) := 'Create_Page_Region';
270: l_return_status VARCHAR2(1);

Line 275: IF NOT FND_API.Compatible_API_Call (

271: l_pass NUMBER := 2;
272: l_copy_redo_flag BOOLEAN := FALSE;
273: begin
274: -- Check API version number
275: IF NOT FND_API.Compatible_API_Call (
276: l_api_version_number, p_api_version_number, l_api_name,
277: G_PKG_NAME) then
278: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
279: return;

Line 278: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

274: -- Check API version number
275: IF NOT FND_API.Compatible_API_Call (
276: l_api_version_number, p_api_version_number, l_api_name,
277: G_PKG_NAME) then
278: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
279: return;
280: END IF;
281:
282: -- Initialize the message table if requested.

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

317: p_copy_redo_flag => l_copy_redo_flag
318: );
319:
320: -- If API call returns with an error status...
321: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
322: (l_return_status = FND_API.G_RET_STS_ERROR) then
323: RAISE FND_API.G_EXC_ERROR;
324: end if;
325:

Line 322: (l_return_status = FND_API.G_RET_STS_ERROR) then

318: );
319:
320: -- If API call returns with an error status...
321: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
322: (l_return_status = FND_API.G_RET_STS_ERROR) then
323: RAISE FND_API.G_EXC_ERROR;
324: end if;
325:
326: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 323: RAISE FND_API.G_EXC_ERROR;

319:
320: -- If API call returns with an error status...
321: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
322: (l_return_status = FND_API.G_RET_STS_ERROR) then
323: RAISE FND_API.G_EXC_ERROR;
324: end if;
325:
326: p_return_status := FND_API.G_RET_STS_SUCCESS;
327:

Line 326: p_return_status := FND_API.G_RET_STS_SUCCESS;

322: (l_return_status = FND_API.G_RET_STS_ERROR) then
323: RAISE FND_API.G_EXC_ERROR;
324: end if;
325:
326: p_return_status := FND_API.G_RET_STS_SUCCESS;
327:
328: EXCEPTION
329: WHEN FND_API.G_EXC_ERROR THEN
330: p_return_status := FND_API.G_RET_STS_ERROR;

Line 329: WHEN FND_API.G_EXC_ERROR THEN

325:
326: p_return_status := FND_API.G_RET_STS_SUCCESS;
327:
328: EXCEPTION
329: WHEN FND_API.G_EXC_ERROR THEN
330: p_return_status := FND_API.G_RET_STS_ERROR;
331: rollback to start_create_page_region;
332: WHEN OTHERS THEN
333: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 330: p_return_status := FND_API.G_RET_STS_ERROR;

326: p_return_status := FND_API.G_RET_STS_SUCCESS;
327:
328: EXCEPTION
329: WHEN FND_API.G_EXC_ERROR THEN
330: p_return_status := FND_API.G_RET_STS_ERROR;
331: rollback to start_create_page_region;
332: WHEN OTHERS THEN
333: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: rollback to start_create_page_region;

Line 333: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

329: WHEN FND_API.G_EXC_ERROR THEN
330: p_return_status := FND_API.G_RET_STS_ERROR;
331: rollback to start_create_page_region;
332: WHEN OTHERS THEN
333: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: rollback to start_create_page_region;
335: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
336: SUBSTR (SQLERRM, 1, 240) );
337: FND_MSG_PUB.Add;

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

355: -- Version Initial version number = 1.0
356: -- History Current version number = 1.0
357: --=======================================================
358: procedure CREATE_PAGE_REGION_ITEM (
359: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
360: p_api_version_number IN NUMBER,
361: p_init_msg_tbl IN BOOLEAN := FALSE,
362: p_msg_count OUT NOCOPY NUMBER,
363: p_msg_data OUT NOCOPY VARCHAR2,

Line 373: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,

369: p_region_application_id IN NUMBER,
370: p_region_code IN VARCHAR2,
371: p_attribute_application_id IN NUMBER,
372: p_attribute_code IN VARCHAR2,
373: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
374: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
376: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
377: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 374: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

370: p_region_code IN VARCHAR2,
371: p_attribute_application_id IN NUMBER,
372: p_attribute_code IN VARCHAR2,
373: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
374: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
376: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
377: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
378: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 375: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,

371: p_attribute_application_id IN NUMBER,
372: p_attribute_code IN VARCHAR2,
373: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
374: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
376: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
377: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
378: p_creation_date IN DATE := FND_API.G_MISS_DATE,
379: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 376: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

372: p_attribute_code IN VARCHAR2,
373: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
374: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
376: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
377: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
378: p_creation_date IN DATE := FND_API.G_MISS_DATE,
379: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
380: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

373: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
374: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
376: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
377: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
378: p_creation_date IN DATE := FND_API.G_MISS_DATE,
379: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
380: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
381: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

374: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
376: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
377: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
378: p_creation_date IN DATE := FND_API.G_MISS_DATE,
379: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
380: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
381: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
382: ) is

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

375: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
376: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
377: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
378: p_creation_date IN DATE := FND_API.G_MISS_DATE,
379: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
380: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
381: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
382: ) is
383: l_api_version_number CONSTANT number := 1.0;

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

376: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
377: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
378: p_creation_date IN DATE := FND_API.G_MISS_DATE,
379: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
380: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
381: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
382: ) is
383: l_api_version_number CONSTANT number := 1.0;
384: l_api_name CONSTANT varchar2(30) := 'Create_Page_Region_Item';

Line 381: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

377: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
378: p_creation_date IN DATE := FND_API.G_MISS_DATE,
379: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
380: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
381: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
382: ) is
383: l_api_version_number CONSTANT number := 1.0;
384: l_api_name CONSTANT varchar2(30) := 'Create_Page_Region_Item';
385: l_return_status VARCHAR2(1);

Line 390: IF NOT FND_API.Compatible_API_Call (

386: l_pass NUMBER := 2;
387: l_copy_redo_flag BOOLEAN := FALSE;
388: begin
389: -- Check API version number
390: IF NOT FND_API.Compatible_API_Call (
391: l_api_version_number, p_api_version_number, l_api_name,
392: G_PKG_NAME) then
393: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: return;

Line 393: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

389: -- Check API version number
390: IF NOT FND_API.Compatible_API_Call (
391: l_api_version_number, p_api_version_number, l_api_name,
392: G_PKG_NAME) then
393: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: return;
395: END IF;
396:
397: -- Initialize the message table if requested.

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

430: p_copy_redo_flag => l_copy_redo_flag
431: );
432:
433: -- If API call returns with an error status...
434: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
435: (l_return_status = FND_API.G_RET_STS_ERROR) then
436: RAISE FND_API.G_EXC_ERROR;
437: end if;
438:

Line 435: (l_return_status = FND_API.G_RET_STS_ERROR) then

431: );
432:
433: -- If API call returns with an error status...
434: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
435: (l_return_status = FND_API.G_RET_STS_ERROR) then
436: RAISE FND_API.G_EXC_ERROR;
437: end if;
438:
439: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 436: RAISE FND_API.G_EXC_ERROR;

432:
433: -- If API call returns with an error status...
434: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
435: (l_return_status = FND_API.G_RET_STS_ERROR) then
436: RAISE FND_API.G_EXC_ERROR;
437: end if;
438:
439: p_return_status := FND_API.G_RET_STS_SUCCESS;
440:

Line 439: p_return_status := FND_API.G_RET_STS_SUCCESS;

435: (l_return_status = FND_API.G_RET_STS_ERROR) then
436: RAISE FND_API.G_EXC_ERROR;
437: end if;
438:
439: p_return_status := FND_API.G_RET_STS_SUCCESS;
440:
441: EXCEPTION
442: WHEN FND_API.G_EXC_ERROR THEN
443: p_return_status := FND_API.G_RET_STS_ERROR;

Line 442: WHEN FND_API.G_EXC_ERROR THEN

438:
439: p_return_status := FND_API.G_RET_STS_SUCCESS;
440:
441: EXCEPTION
442: WHEN FND_API.G_EXC_ERROR THEN
443: p_return_status := FND_API.G_RET_STS_ERROR;
444: rollback to start_create_item;
445: WHEN OTHERS THEN
446: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 443: p_return_status := FND_API.G_RET_STS_ERROR;

439: p_return_status := FND_API.G_RET_STS_SUCCESS;
440:
441: EXCEPTION
442: WHEN FND_API.G_EXC_ERROR THEN
443: p_return_status := FND_API.G_RET_STS_ERROR;
444: rollback to start_create_item;
445: WHEN OTHERS THEN
446: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
447: rollback to start_create_item;

Line 446: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

442: WHEN FND_API.G_EXC_ERROR THEN
443: p_return_status := FND_API.G_RET_STS_ERROR;
444: rollback to start_create_item;
445: WHEN OTHERS THEN
446: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
447: rollback to start_create_item;
448: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
449: SUBSTR (SQLERRM, 1, 240) );
450: FND_MSG_PUB.Add;

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

468: -- Version Initial version number = 1.0
469: -- History Current version number = 1.0
470: --=======================================================
471: procedure CREATE_REGION_RELATION (
472: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
473: p_api_version_number IN NUMBER,
474: p_init_msg_tbl IN BOOLEAN := FALSE,
475: p_msg_count OUT NOCOPY NUMBER,
476: p_msg_data OUT NOCOPY VARCHAR2,

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

486: p_to_page_code IN VARCHAR2,
487: p_to_region_appl_id IN NUMBER,
488: p_to_region_code IN VARCHAR2,
489: p_application_id IN NUMBER,
490: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
491: p_creation_date IN DATE := FND_API.G_MISS_DATE,
492: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
493: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
494: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

487: p_to_region_appl_id IN NUMBER,
488: p_to_region_code IN VARCHAR2,
489: p_application_id IN NUMBER,
490: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
491: p_creation_date IN DATE := FND_API.G_MISS_DATE,
492: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
493: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
494: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
495: ) is

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

488: p_to_region_code IN VARCHAR2,
489: p_application_id IN NUMBER,
490: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
491: p_creation_date IN DATE := FND_API.G_MISS_DATE,
492: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
493: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
494: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
495: ) is
496: l_api_version_number CONSTANT number := 1.0;

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

489: p_application_id IN NUMBER,
490: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
491: p_creation_date IN DATE := FND_API.G_MISS_DATE,
492: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
493: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
494: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
495: ) is
496: l_api_version_number CONSTANT number := 1.0;
497: l_api_name CONSTANT varchar2(30) := 'Create_Region_Relation';

Line 494: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

490: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
491: p_creation_date IN DATE := FND_API.G_MISS_DATE,
492: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
493: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
494: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
495: ) is
496: l_api_version_number CONSTANT number := 1.0;
497: l_api_name CONSTANT varchar2(30) := 'Create_Region_Relation';
498: l_return_status VARCHAR2(1);

Line 503: IF NOT FND_API.Compatible_API_Call (

499: l_pass NUMBER := 2;
500: l_copy_redo_flag BOOLEAN := FALSE;
501: begin
502: -- Check API version number
503: IF NOT FND_API.Compatible_API_Call (
504: l_api_version_number, p_api_version_number, l_api_name,
505: G_PKG_NAME) then
506: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: return;

Line 506: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

502: -- Check API version number
503: IF NOT FND_API.Compatible_API_Call (
504: l_api_version_number, p_api_version_number, l_api_name,
505: G_PKG_NAME) then
506: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: return;
508: END IF;
509:
510: -- Initialize the message table if requested.

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

543: p_copy_redo_flag => l_copy_redo_flag
544: );
545:
546: -- If API call returns with an error status...
547: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
548: (l_return_status = FND_API.G_RET_STS_ERROR) then
549: RAISE FND_API.G_EXC_ERROR;
550: end if;
551:

Line 548: (l_return_status = FND_API.G_RET_STS_ERROR) then

544: );
545:
546: -- If API call returns with an error status...
547: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
548: (l_return_status = FND_API.G_RET_STS_ERROR) then
549: RAISE FND_API.G_EXC_ERROR;
550: end if;
551:
552: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 549: RAISE FND_API.G_EXC_ERROR;

545:
546: -- If API call returns with an error status...
547: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
548: (l_return_status = FND_API.G_RET_STS_ERROR) then
549: RAISE FND_API.G_EXC_ERROR;
550: end if;
551:
552: p_return_status := FND_API.G_RET_STS_SUCCESS;
553:

Line 552: p_return_status := FND_API.G_RET_STS_SUCCESS;

548: (l_return_status = FND_API.G_RET_STS_ERROR) then
549: RAISE FND_API.G_EXC_ERROR;
550: end if;
551:
552: p_return_status := FND_API.G_RET_STS_SUCCESS;
553:
554: EXCEPTION
555: WHEN FND_API.G_EXC_ERROR THEN
556: p_return_status := FND_API.G_RET_STS_ERROR;

Line 555: WHEN FND_API.G_EXC_ERROR THEN

551:
552: p_return_status := FND_API.G_RET_STS_SUCCESS;
553:
554: EXCEPTION
555: WHEN FND_API.G_EXC_ERROR THEN
556: p_return_status := FND_API.G_RET_STS_ERROR;
557: rollback to start_create_relation;
558: WHEN OTHERS THEN
559: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 556: p_return_status := FND_API.G_RET_STS_ERROR;

552: p_return_status := FND_API.G_RET_STS_SUCCESS;
553:
554: EXCEPTION
555: WHEN FND_API.G_EXC_ERROR THEN
556: p_return_status := FND_API.G_RET_STS_ERROR;
557: rollback to start_create_relation;
558: WHEN OTHERS THEN
559: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
560: rollback to start_create_relation;

Line 559: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

555: WHEN FND_API.G_EXC_ERROR THEN
556: p_return_status := FND_API.G_RET_STS_ERROR;
557: rollback to start_create_relation;
558: WHEN OTHERS THEN
559: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
560: rollback to start_create_relation;
561: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
562: SUBSTR (SQLERRM, 1, 240) );
563: FND_MSG_PUB.Add;

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

588: -- Version Initial version number = 1.0
589: -- History Current version number = 1.0
590: --=======================================================
591: procedure DELETE_FLOW (
592: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
593: p_api_version_number IN NUMBER,
594: p_init_msg_tbl IN BOOLEAN := FALSE,
595: p_msg_count OUT NOCOPY NUMBER,
596: p_msg_data OUT NOCOPY VARCHAR2,

Line 607: IF NOT FND_API.Compatible_API_Call (

603: l_api_name CONSTANT varchar2(30) := 'Delete_Flow';
604: l_return_status VARCHAR2(1);
605: begin
606: -- Check API version number
607: IF NOT FND_API.Compatible_API_Call (
608: l_api_version_number, p_api_version_number, l_api_name,
609: G_PKG_NAME) then
610: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
611: return;

Line 610: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

606: -- Check API version number
607: IF NOT FND_API.Compatible_API_Call (
608: l_api_version_number, p_api_version_number, l_api_name,
609: G_PKG_NAME) then
610: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
611: return;
612: END IF;
613:
614: -- Initialize the message table if requested.

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

631: p_delete_cascade => p_delete_cascade
632: );
633:
634: -- If API call returns with an error status...
635: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
636: (l_return_status = FND_API.G_RET_STS_ERROR) then
637: RAISE FND_API.G_EXC_ERROR;
638: end if;
639:

Line 636: (l_return_status = FND_API.G_RET_STS_ERROR) then

632: );
633:
634: -- If API call returns with an error status...
635: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
636: (l_return_status = FND_API.G_RET_STS_ERROR) then
637: RAISE FND_API.G_EXC_ERROR;
638: end if;
639:
640: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 637: RAISE FND_API.G_EXC_ERROR;

633:
634: -- If API call returns with an error status...
635: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
636: (l_return_status = FND_API.G_RET_STS_ERROR) then
637: RAISE FND_API.G_EXC_ERROR;
638: end if;
639:
640: p_return_status := FND_API.G_RET_STS_SUCCESS;
641:

Line 640: p_return_status := FND_API.G_RET_STS_SUCCESS;

636: (l_return_status = FND_API.G_RET_STS_ERROR) then
637: RAISE FND_API.G_EXC_ERROR;
638: end if;
639:
640: p_return_status := FND_API.G_RET_STS_SUCCESS;
641:
642: EXCEPTION
643: WHEN FND_API.G_EXC_ERROR THEN
644: p_return_status := FND_API.G_RET_STS_ERROR;

Line 643: WHEN FND_API.G_EXC_ERROR THEN

639:
640: p_return_status := FND_API.G_RET_STS_SUCCESS;
641:
642: EXCEPTION
643: WHEN FND_API.G_EXC_ERROR THEN
644: p_return_status := FND_API.G_RET_STS_ERROR;
645: rollback to start_delete_flow;
646: WHEN OTHERS THEN
647: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 644: p_return_status := FND_API.G_RET_STS_ERROR;

640: p_return_status := FND_API.G_RET_STS_SUCCESS;
641:
642: EXCEPTION
643: WHEN FND_API.G_EXC_ERROR THEN
644: p_return_status := FND_API.G_RET_STS_ERROR;
645: rollback to start_delete_flow;
646: WHEN OTHERS THEN
647: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
648: rollback to start_delete_flow;

Line 647: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

643: WHEN FND_API.G_EXC_ERROR THEN
644: p_return_status := FND_API.G_RET_STS_ERROR;
645: rollback to start_delete_flow;
646: WHEN OTHERS THEN
647: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
648: rollback to start_delete_flow;
649: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
650: SUBSTR (SQLERRM, 1, 240) );
651: FND_MSG_PUB.Add;

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

678: -- Version Initial version number = 1.0
679: -- History Current version number = 1.0
680: --=======================================================
681: procedure DELETE_PAGE (
682: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
683: p_api_version_number IN NUMBER,
684: p_init_msg_tbl IN BOOLEAN := FALSE,
685: p_msg_count OUT NOCOPY NUMBER,
686: p_msg_data OUT NOCOPY VARCHAR2,

Line 699: IF NOT FND_API.Compatible_API_Call (

695: l_api_name CONSTANT varchar2(30) := 'Delete_Page';
696: l_return_status VARCHAR2(1);
697: begin
698: -- Check API version number
699: IF NOT FND_API.Compatible_API_Call (
700: l_api_version_number, p_api_version_number, l_api_name,
701: G_PKG_NAME) then
702: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
703: return;

Line 702: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

725: p_delete_cascade => p_delete_cascade
726: );
727:
728: -- If API call returns with an error status...
729: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
730: (l_return_status = FND_API.G_RET_STS_ERROR) then
731: RAISE FND_API.G_EXC_ERROR;
732: end if;
733:

Line 730: (l_return_status = FND_API.G_RET_STS_ERROR) then

726: );
727:
728: -- If API call returns with an error status...
729: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
730: (l_return_status = FND_API.G_RET_STS_ERROR) then
731: RAISE FND_API.G_EXC_ERROR;
732: end if;
733:
734: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 731: RAISE FND_API.G_EXC_ERROR;

727:
728: -- If API call returns with an error status...
729: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
730: (l_return_status = FND_API.G_RET_STS_ERROR) then
731: RAISE FND_API.G_EXC_ERROR;
732: end if;
733:
734: p_return_status := FND_API.G_RET_STS_SUCCESS;
735:

Line 734: p_return_status := FND_API.G_RET_STS_SUCCESS;

730: (l_return_status = FND_API.G_RET_STS_ERROR) then
731: RAISE FND_API.G_EXC_ERROR;
732: end if;
733:
734: p_return_status := FND_API.G_RET_STS_SUCCESS;
735:
736: EXCEPTION
737: WHEN FND_API.G_EXC_ERROR THEN
738: p_return_status := FND_API.G_RET_STS_ERROR;

Line 737: WHEN FND_API.G_EXC_ERROR THEN

733:
734: p_return_status := FND_API.G_RET_STS_SUCCESS;
735:
736: EXCEPTION
737: WHEN FND_API.G_EXC_ERROR THEN
738: p_return_status := FND_API.G_RET_STS_ERROR;
739: rollback to start_delete_page;
740: WHEN OTHERS THEN
741: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 738: p_return_status := FND_API.G_RET_STS_ERROR;

734: p_return_status := FND_API.G_RET_STS_SUCCESS;
735:
736: EXCEPTION
737: WHEN FND_API.G_EXC_ERROR THEN
738: p_return_status := FND_API.G_RET_STS_ERROR;
739: rollback to start_delete_page;
740: WHEN OTHERS THEN
741: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
742: rollback to start_delete_page;

Line 741: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

737: WHEN FND_API.G_EXC_ERROR THEN
738: p_return_status := FND_API.G_RET_STS_ERROR;
739: rollback to start_delete_page;
740: WHEN OTHERS THEN
741: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
742: rollback to start_delete_page;
743: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
744: SUBSTR (SQLERRM, 1, 240) );
745: FND_MSG_PUB.Add;

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

774: -- Version Initial version number = 1.0
775: -- History Current version number = 1.0
776: --=======================================================
777: procedure DELETE_PAGE_REGION (
778: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
779: p_api_version_number IN NUMBER,
780: p_init_msg_tbl IN BOOLEAN := FALSE,
781: p_msg_count OUT NOCOPY NUMBER,
782: p_msg_data OUT NOCOPY VARCHAR2,

Line 797: IF NOT FND_API.Compatible_API_Call (

793: l_api_name CONSTANT varchar2(30) := 'Delete_Page_Region';
794: l_return_status VARCHAR2(1);
795: begin
796: -- Check API version number
797: IF NOT FND_API.Compatible_API_Call (
798: l_api_version_number, p_api_version_number, l_api_name,
799: G_PKG_NAME) then
800: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
801: return;

Line 800: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

796: -- Check API version number
797: IF NOT FND_API.Compatible_API_Call (
798: l_api_version_number, p_api_version_number, l_api_name,
799: G_PKG_NAME) then
800: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
801: return;
802: END IF;
803:
804: -- Initialize the message table if requested.

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

825: p_delete_cascade => p_delete_cascade
826: );
827:
828: -- If API call returns with an error status...
829: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
830: (l_return_status = FND_API.G_RET_STS_ERROR) then
831: RAISE FND_API.G_EXC_ERROR;
832: end if;
833:

Line 830: (l_return_status = FND_API.G_RET_STS_ERROR) then

826: );
827:
828: -- If API call returns with an error status...
829: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
830: (l_return_status = FND_API.G_RET_STS_ERROR) then
831: RAISE FND_API.G_EXC_ERROR;
832: end if;
833:
834: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 831: RAISE FND_API.G_EXC_ERROR;

827:
828: -- If API call returns with an error status...
829: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
830: (l_return_status = FND_API.G_RET_STS_ERROR) then
831: RAISE FND_API.G_EXC_ERROR;
832: end if;
833:
834: p_return_status := FND_API.G_RET_STS_SUCCESS;
835:

Line 834: p_return_status := FND_API.G_RET_STS_SUCCESS;

830: (l_return_status = FND_API.G_RET_STS_ERROR) then
831: RAISE FND_API.G_EXC_ERROR;
832: end if;
833:
834: p_return_status := FND_API.G_RET_STS_SUCCESS;
835:
836: EXCEPTION
837: WHEN FND_API.G_EXC_ERROR THEN
838: p_return_status := FND_API.G_RET_STS_ERROR;

Line 837: WHEN FND_API.G_EXC_ERROR THEN

833:
834: p_return_status := FND_API.G_RET_STS_SUCCESS;
835:
836: EXCEPTION
837: WHEN FND_API.G_EXC_ERROR THEN
838: p_return_status := FND_API.G_RET_STS_ERROR;
839: rollback to start_delete_page_region;
840: WHEN OTHERS THEN
841: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 838: p_return_status := FND_API.G_RET_STS_ERROR;

834: p_return_status := FND_API.G_RET_STS_SUCCESS;
835:
836: EXCEPTION
837: WHEN FND_API.G_EXC_ERROR THEN
838: p_return_status := FND_API.G_RET_STS_ERROR;
839: rollback to start_delete_page_region;
840: WHEN OTHERS THEN
841: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
842: rollback to start_delete_page_region;

Line 841: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

837: WHEN FND_API.G_EXC_ERROR THEN
838: p_return_status := FND_API.G_RET_STS_ERROR;
839: rollback to start_delete_page_region;
840: WHEN OTHERS THEN
841: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
842: rollback to start_delete_page_region;
843: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
844: SUBSTR (SQLERRM, 1, 240) );
845: FND_MSG_PUB.Add;

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

876: -- Version Initial version number = 1.0
877: -- History Current version number = 1.0
878: --=======================================================
879: procedure DELETE_PAGE_REGION_ITEM (
880: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
881: p_api_version_number IN NUMBER,
882: p_init_msg_tbl IN BOOLEAN := FALSE,
883: p_msg_count OUT NOCOPY NUMBER,
884: p_msg_data OUT NOCOPY VARCHAR2,

Line 901: IF NOT FND_API.Compatible_API_Call (

897: l_api_name CONSTANT varchar2(30) := 'Delete_Page_Region_Item';
898: l_return_status VARCHAR2(1);
899: begin
900: -- Check API version number
901: IF NOT FND_API.Compatible_API_Call (
902: l_api_version_number, p_api_version_number, l_api_name,
903: G_PKG_NAME) then
904: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
905: return;

Line 904: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

900: -- Check API version number
901: IF NOT FND_API.Compatible_API_Call (
902: l_api_version_number, p_api_version_number, l_api_name,
903: G_PKG_NAME) then
904: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
905: return;
906: END IF;
907:
908: -- Initialize the message table if requested.

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

931: p_delete_cascade => p_delete_cascade
932: );
933:
934: -- If API call returns with an error status...
935: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
936: (l_return_status = FND_API.G_RET_STS_ERROR) then
937: RAISE FND_API.G_EXC_ERROR;
938: end if;
939:

Line 936: (l_return_status = FND_API.G_RET_STS_ERROR) then

932: );
933:
934: -- If API call returns with an error status...
935: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
936: (l_return_status = FND_API.G_RET_STS_ERROR) then
937: RAISE FND_API.G_EXC_ERROR;
938: end if;
939:
940: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 937: RAISE FND_API.G_EXC_ERROR;

933:
934: -- If API call returns with an error status...
935: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
936: (l_return_status = FND_API.G_RET_STS_ERROR) then
937: RAISE FND_API.G_EXC_ERROR;
938: end if;
939:
940: p_return_status := FND_API.G_RET_STS_SUCCESS;
941:

Line 940: p_return_status := FND_API.G_RET_STS_SUCCESS;

936: (l_return_status = FND_API.G_RET_STS_ERROR) then
937: RAISE FND_API.G_EXC_ERROR;
938: end if;
939:
940: p_return_status := FND_API.G_RET_STS_SUCCESS;
941:
942: EXCEPTION
943: WHEN FND_API.G_EXC_ERROR THEN
944: p_return_status := FND_API.G_RET_STS_ERROR;

Line 943: WHEN FND_API.G_EXC_ERROR THEN

939:
940: p_return_status := FND_API.G_RET_STS_SUCCESS;
941:
942: EXCEPTION
943: WHEN FND_API.G_EXC_ERROR THEN
944: p_return_status := FND_API.G_RET_STS_ERROR;
945: rollback to start_delete_item;
946: WHEN OTHERS THEN
947: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 944: p_return_status := FND_API.G_RET_STS_ERROR;

940: p_return_status := FND_API.G_RET_STS_SUCCESS;
941:
942: EXCEPTION
943: WHEN FND_API.G_EXC_ERROR THEN
944: p_return_status := FND_API.G_RET_STS_ERROR;
945: rollback to start_delete_item;
946: WHEN OTHERS THEN
947: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
948: rollback to start_delete_item;

Line 947: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

943: WHEN FND_API.G_EXC_ERROR THEN
944: p_return_status := FND_API.G_RET_STS_ERROR;
945: rollback to start_delete_item;
946: WHEN OTHERS THEN
947: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
948: rollback to start_delete_item;
949: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
950: SUBSTR (SQLERRM, 1, 240) );
951: FND_MSG_PUB.Add;

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

985: -- Version Initial version number = 1.0
986: -- History Current version number = 1.0
987: --=======================================================
988: procedure DELETE_REGION_RELATION (
989: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
990: p_api_version_number IN NUMBER,
991: p_init_msg_tbl IN BOOLEAN := FALSE,
992: p_msg_count OUT NOCOPY NUMBER,
993: p_msg_data OUT NOCOPY VARCHAR2,

Line 1013: IF NOT FND_API.Compatible_API_Call (

1009: l_api_name CONSTANT varchar2(30) := 'Delete_Region_Relation';
1010: l_return_status VARCHAR2(1);
1011: begin
1012: -- Check API version number
1013: IF NOT FND_API.Compatible_API_Call (
1014: l_api_version_number, p_api_version_number, l_api_name,
1015: G_PKG_NAME) then
1016: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1017: return;

Line 1016: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1012: -- Check API version number
1013: IF NOT FND_API.Compatible_API_Call (
1014: l_api_version_number, p_api_version_number, l_api_name,
1015: G_PKG_NAME) then
1016: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1017: return;
1018: END IF;
1019:
1020: -- Initialize the message table if requested.

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

1046: p_delete_cascade => p_delete_cascade
1047: );
1048:
1049: -- If API call returns with an error status...
1050: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1051: (l_return_status = FND_API.G_RET_STS_ERROR) then
1052: RAISE FND_API.G_EXC_ERROR;
1053: end if;
1054:

Line 1051: (l_return_status = FND_API.G_RET_STS_ERROR) then

1047: );
1048:
1049: -- If API call returns with an error status...
1050: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1051: (l_return_status = FND_API.G_RET_STS_ERROR) then
1052: RAISE FND_API.G_EXC_ERROR;
1053: end if;
1054:
1055: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1052: RAISE FND_API.G_EXC_ERROR;

1048:
1049: -- If API call returns with an error status...
1050: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1051: (l_return_status = FND_API.G_RET_STS_ERROR) then
1052: RAISE FND_API.G_EXC_ERROR;
1053: end if;
1054:
1055: p_return_status := FND_API.G_RET_STS_SUCCESS;
1056:

Line 1055: p_return_status := FND_API.G_RET_STS_SUCCESS;

1051: (l_return_status = FND_API.G_RET_STS_ERROR) then
1052: RAISE FND_API.G_EXC_ERROR;
1053: end if;
1054:
1055: p_return_status := FND_API.G_RET_STS_SUCCESS;
1056:
1057: EXCEPTION
1058: WHEN FND_API.G_EXC_ERROR THEN
1059: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1058: WHEN FND_API.G_EXC_ERROR THEN

1054:
1055: p_return_status := FND_API.G_RET_STS_SUCCESS;
1056:
1057: EXCEPTION
1058: WHEN FND_API.G_EXC_ERROR THEN
1059: p_return_status := FND_API.G_RET_STS_ERROR;
1060: rollback to start_delete_relation;
1061: WHEN OTHERS THEN
1062: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1059: p_return_status := FND_API.G_RET_STS_ERROR;

1055: p_return_status := FND_API.G_RET_STS_SUCCESS;
1056:
1057: EXCEPTION
1058: WHEN FND_API.G_EXC_ERROR THEN
1059: p_return_status := FND_API.G_RET_STS_ERROR;
1060: rollback to start_delete_relation;
1061: WHEN OTHERS THEN
1062: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1063: rollback to start_delete_relation;

Line 1062: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1058: WHEN FND_API.G_EXC_ERROR THEN
1059: p_return_status := FND_API.G_RET_STS_ERROR;
1060: rollback to start_delete_relation;
1061: WHEN OTHERS THEN
1062: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1063: rollback to start_delete_relation;
1064: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1065: SUBSTR (SQLERRM, 1, 240) );
1066: FND_MSG_PUB.Add;

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

1116: -- Version Initial version number = 1.0
1117: -- History Current version number = 1.0
1118: --===========================================================
1119: procedure DOWNLOAD_FLOW (
1120: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1121: p_api_version_number IN NUMBER,
1122: p_init_msg_tbl IN BOOLEAN := FALSE,
1123: p_msg_count OUT NOCOPY NUMBER,
1124: p_msg_data OUT NOCOPY VARCHAR2,

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

1122: p_init_msg_tbl IN BOOLEAN := FALSE,
1123: p_msg_count OUT NOCOPY NUMBER,
1124: p_msg_data OUT NOCOPY VARCHAR2,
1125: p_return_status OUT NOCOPY VARCHAR2,
1126: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
1127: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1128: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1129: p_flow_pk_tbl IN AK_FLOW_PUB.Flow_PK_Tbl_Type
1130: := AK_FLOW_PUB.G_MISS_FLOW_PK_TBL

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

1123: p_msg_count OUT NOCOPY NUMBER,
1124: p_msg_data OUT NOCOPY VARCHAR2,
1125: p_return_status OUT NOCOPY VARCHAR2,
1126: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
1127: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1128: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1129: p_flow_pk_tbl IN AK_FLOW_PUB.Flow_PK_Tbl_Type
1130: := AK_FLOW_PUB.G_MISS_FLOW_PK_TBL
1131: ) is

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

1124: p_msg_data OUT NOCOPY VARCHAR2,
1125: p_return_status OUT NOCOPY VARCHAR2,
1126: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
1127: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1128: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1129: p_flow_pk_tbl IN AK_FLOW_PUB.Flow_PK_Tbl_Type
1130: := AK_FLOW_PUB.G_MISS_FLOW_PK_TBL
1131: ) is
1132: l_api_version_number CONSTANT number := 1.0;

Line 1143: IF NOT FND_API.Compatible_API_Call (

1139: l_return_status varchar2(1);
1140: begin
1141:
1142: -- Check verion number
1143: IF NOT FND_API.Compatible_API_Call (
1144: l_api_version_number, p_api_version_number, l_api_name,
1145: G_PKG_NAME) then
1146: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1147: return;

Line 1146: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1142: -- Check verion number
1143: IF NOT FND_API.Compatible_API_Call (
1144: l_api_version_number, p_api_version_number, l_api_name,
1145: G_PKG_NAME) then
1146: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1147: return;
1148: END IF;
1149:
1150: -- Initialize the message table if requested.

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

1178: from dual;
1179: end if;
1180:
1181: -- If API call returns with an error status...
1182: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1183: (l_return_status = FND_API.G_RET_STS_ERROR) then
1184: --dbms_output.put_line(G_PKG_NAME || ' download_header failed');
1185: RAISE FND_API.G_EXC_ERROR;
1186: end if;

Line 1183: (l_return_status = FND_API.G_RET_STS_ERROR) then

1179: end if;
1180:
1181: -- If API call returns with an error status...
1182: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1183: (l_return_status = FND_API.G_RET_STS_ERROR) then
1184: --dbms_output.put_line(G_PKG_NAME || ' download_header failed');
1185: RAISE FND_API.G_EXC_ERROR;
1186: end if;
1187:

Line 1185: RAISE FND_API.G_EXC_ERROR;

1181: -- If API call returns with an error status...
1182: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1183: (l_return_status = FND_API.G_RET_STS_ERROR) then
1184: --dbms_output.put_line(G_PKG_NAME || ' download_header failed');
1185: RAISE FND_API.G_EXC_ERROR;
1186: end if;
1187:
1188: -- - call the download procedure for flows to retrieve the
1189: -- selected flows from the database into a table of type

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

1198: );
1199:
1200: -- If download call returns with an error status or
1201: -- download failed to retrieve any information from the database..
1202: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1203: (l_return_status = FND_API.G_RET_STS_ERROR) then
1204: -- dbms_output.put_line(G_PKG_NAME || 'download flow returned error:' ||
1205: -- l_return_status);
1206: RAISE FND_API.G_EXC_ERROR;

Line 1203: (l_return_status = FND_API.G_RET_STS_ERROR) then

1199:
1200: -- If download call returns with an error status or
1201: -- download failed to retrieve any information from the database..
1202: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1203: (l_return_status = FND_API.G_RET_STS_ERROR) then
1204: -- dbms_output.put_line(G_PKG_NAME || 'download flow returned error:' ||
1205: -- l_return_status);
1206: RAISE FND_API.G_EXC_ERROR;
1207: end if;

Line 1206: RAISE FND_API.G_EXC_ERROR;

1202: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1203: (l_return_status = FND_API.G_RET_STS_ERROR) then
1204: -- dbms_output.put_line(G_PKG_NAME || 'download flow returned error:' ||
1205: -- l_return_status);
1206: RAISE FND_API.G_EXC_ERROR;
1207: end if;
1208:
1209: p_return_status := FND_API.G_RET_STS_SUCCESS;
1210:

Line 1209: p_return_status := FND_API.G_RET_STS_SUCCESS;

1205: -- l_return_status);
1206: RAISE FND_API.G_EXC_ERROR;
1207: end if;
1208:
1209: p_return_status := FND_API.G_RET_STS_SUCCESS;
1210:
1211: FND_MSG_PUB.Count_And_Get (
1212: p_count => p_msg_count,
1213: p_data => p_msg_data);

Line 1216: WHEN FND_API.G_EXC_ERROR THEN

1212: p_count => p_msg_count,
1213: p_data => p_msg_data);
1214:
1215: EXCEPTION
1216: WHEN FND_API.G_EXC_ERROR THEN
1217: rollback to Start_download;
1218: p_return_status := FND_API.G_RET_STS_ERROR;
1219: FND_MSG_PUB.Count_And_Get (
1220: p_count => p_msg_count,

Line 1218: p_return_status := FND_API.G_RET_STS_ERROR;

1214:
1215: EXCEPTION
1216: WHEN FND_API.G_EXC_ERROR THEN
1217: rollback to Start_download;
1218: p_return_status := FND_API.G_RET_STS_ERROR;
1219: FND_MSG_PUB.Count_And_Get (
1220: p_count => p_msg_count,
1221: p_data => p_msg_data);
1222: WHEN OTHERS THEN

Line 1223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1219: FND_MSG_PUB.Count_And_Get (
1220: p_count => p_msg_count,
1221: p_data => p_msg_data);
1222: WHEN OTHERS THEN
1223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1224: rollback to Start_download;
1225: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1226: SUBSTR (SQLERRM, 1, 240) );
1227: FND_MSG_PUB.Add;

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

1249: -- Version Initial version number = 1.0
1250: -- History Current version number = 1.0
1251: --=======================================================
1252: procedure UPDATE_FLOW (
1253: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1254: p_api_version_number IN NUMBER,
1255: p_init_msg_tbl IN BOOLEAN := FALSE,
1256: p_msg_count OUT NOCOPY NUMBER,
1257: p_msg_data OUT NOCOPY VARCHAR2,

Line 1261: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,

1257: p_msg_data OUT NOCOPY VARCHAR2,
1258: p_return_status OUT NOCOPY VARCHAR2,
1259: p_flow_application_id IN NUMBER,
1260: p_flow_code IN VARCHAR2,
1261: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1262: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1263: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1264: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1265: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 1262: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

1258: p_return_status OUT NOCOPY VARCHAR2,
1259: p_flow_application_id IN NUMBER,
1260: p_flow_code IN VARCHAR2,
1261: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1262: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1263: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1264: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1265: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1266: p_creation_date IN DATE := FND_API.G_MISS_DATE,

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

1259: p_flow_application_id IN NUMBER,
1260: p_flow_code IN VARCHAR2,
1261: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1262: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1263: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1264: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1265: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1266: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1267: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

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

1260: p_flow_code IN VARCHAR2,
1261: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1262: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1263: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1264: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1265: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1266: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1267: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1268: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

1261: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1262: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1263: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1264: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1265: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1266: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1267: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1268: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1269: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

1262: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1263: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1264: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1265: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1266: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1267: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1268: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1269: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1270: ) is

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

1263: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1264: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1265: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1266: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1267: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1268: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1269: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1270: ) is
1271: l_api_version_number CONSTANT number := 1.0;

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

1264: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1265: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1266: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1267: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1268: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1269: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1270: ) is
1271: l_api_version_number CONSTANT number := 1.0;
1272: l_api_name CONSTANT varchar2(30) := 'Update_Flow';

Line 1269: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

1265: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1266: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1267: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1268: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1269: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1270: ) is
1271: l_api_version_number CONSTANT number := 1.0;
1272: l_api_name CONSTANT varchar2(30) := 'Update_Flow';
1273: l_return_status VARCHAR2(1);

Line 1278: IF NOT FND_API.Compatible_API_Call (

1274: l_pass NUMBER := 2;
1275: l_copy_redo_flag BOOLEAN := FALSE;
1276: begin
1277: -- Check API version number
1278: IF NOT FND_API.Compatible_API_Call (
1279: l_api_version_number, p_api_version_number, l_api_name,
1280: G_PKG_NAME) then
1281: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1282: return;

Line 1281: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1277: -- Check API version number
1278: IF NOT FND_API.Compatible_API_Call (
1279: l_api_version_number, p_api_version_number, l_api_name,
1280: G_PKG_NAME) then
1281: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1282: return;
1283: END IF;
1284:
1285: -- Initialize the message table if requested.

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

1312: p_copy_redo_flag => l_copy_redo_flag
1313: );
1314:
1315: -- If API call returns with an error status...
1316: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1317: (l_return_status = FND_API.G_RET_STS_ERROR) then
1318: RAISE FND_API.G_EXC_ERROR;
1319: end if;
1320:

Line 1317: (l_return_status = FND_API.G_RET_STS_ERROR) then

1313: );
1314:
1315: -- If API call returns with an error status...
1316: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1317: (l_return_status = FND_API.G_RET_STS_ERROR) then
1318: RAISE FND_API.G_EXC_ERROR;
1319: end if;
1320:
1321: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1318: RAISE FND_API.G_EXC_ERROR;

1314:
1315: -- If API call returns with an error status...
1316: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1317: (l_return_status = FND_API.G_RET_STS_ERROR) then
1318: RAISE FND_API.G_EXC_ERROR;
1319: end if;
1320:
1321: p_return_status := FND_API.G_RET_STS_SUCCESS;
1322:

Line 1321: p_return_status := FND_API.G_RET_STS_SUCCESS;

1317: (l_return_status = FND_API.G_RET_STS_ERROR) then
1318: RAISE FND_API.G_EXC_ERROR;
1319: end if;
1320:
1321: p_return_status := FND_API.G_RET_STS_SUCCESS;
1322:
1323: EXCEPTION
1324: WHEN FND_API.G_EXC_ERROR THEN
1325: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1324: WHEN FND_API.G_EXC_ERROR THEN

1320:
1321: p_return_status := FND_API.G_RET_STS_SUCCESS;
1322:
1323: EXCEPTION
1324: WHEN FND_API.G_EXC_ERROR THEN
1325: p_return_status := FND_API.G_RET_STS_ERROR;
1326: rollback to start_update_flow;
1327: WHEN OTHERS THEN
1328: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1325: p_return_status := FND_API.G_RET_STS_ERROR;

1321: p_return_status := FND_API.G_RET_STS_SUCCESS;
1322:
1323: EXCEPTION
1324: WHEN FND_API.G_EXC_ERROR THEN
1325: p_return_status := FND_API.G_RET_STS_ERROR;
1326: rollback to start_update_flow;
1327: WHEN OTHERS THEN
1328: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1329: rollback to start_update_flow;

Line 1328: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1324: WHEN FND_API.G_EXC_ERROR THEN
1325: p_return_status := FND_API.G_RET_STS_ERROR;
1326: rollback to start_update_flow;
1327: WHEN OTHERS THEN
1328: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1329: rollback to start_update_flow;
1330: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1331: SUBSTR (SQLERRM, 1, 240) );
1332: FND_MSG_PUB.Add;

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

1353: -- Version Initial version number = 1.0
1354: -- History Current version number = 1.0
1355: --=======================================================
1356: procedure UPDATE_PAGE (
1357: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1358: p_api_version_number IN NUMBER,
1359: p_init_msg_tbl IN BOOLEAN := FALSE,
1360: p_msg_count OUT NOCOPY NUMBER,
1361: p_msg_data OUT NOCOPY VARCHAR2,

Line 1367: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,

1363: p_flow_application_id IN NUMBER,
1364: p_flow_code IN VARCHAR2,
1365: p_page_application_id IN NUMBER,
1366: p_page_code IN VARCHAR2,
1367: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1368: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1369: p_name IN VARCHAR2,
1370: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1371: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1368: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

1364: p_flow_code IN VARCHAR2,
1365: p_page_application_id IN NUMBER,
1366: p_page_code IN VARCHAR2,
1367: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1368: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1369: p_name IN VARCHAR2,
1370: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1371: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
1372: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

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

1366: p_page_code IN VARCHAR2,
1367: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1368: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1369: p_name IN VARCHAR2,
1370: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1371: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
1372: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1373: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1374: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 1371: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,

1367: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1368: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1369: p_name IN VARCHAR2,
1370: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1371: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
1372: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1373: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1374: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1375: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

1368: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1369: p_name IN VARCHAR2,
1370: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1371: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
1372: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1373: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1374: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1375: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1376: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

1369: p_name IN VARCHAR2,
1370: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1371: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
1372: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1373: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1374: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1375: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1376: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1377: ) is

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

1370: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1371: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
1372: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1373: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1374: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1375: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1376: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1377: ) is
1378: l_api_version_number CONSTANT number := 1.0;

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

1371: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
1372: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1373: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1374: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1375: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1376: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1377: ) is
1378: l_api_version_number CONSTANT number := 1.0;
1379: l_api_name CONSTANT varchar2(30) := 'Update_Page';

Line 1376: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

1372: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1373: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1374: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1375: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1376: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1377: ) is
1378: l_api_version_number CONSTANT number := 1.0;
1379: l_api_name CONSTANT varchar2(30) := 'Update_Page';
1380: l_return_status VARCHAR2(1);

Line 1385: IF NOT FND_API.Compatible_API_Call (

1381: l_pass NUMBER := 2;
1382: l_copy_redo_flag BOOLEAN := FALSE;
1383: begin
1384: -- Check API version number
1385: IF NOT FND_API.Compatible_API_Call (
1386: l_api_version_number, p_api_version_number, l_api_name,
1387: G_PKG_NAME) then
1388: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1389: return;

Line 1388: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1384: -- Check API version number
1385: IF NOT FND_API.Compatible_API_Call (
1386: l_api_version_number, p_api_version_number, l_api_name,
1387: G_PKG_NAME) then
1388: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1389: return;
1390: END IF;
1391:
1392: -- Initialize the message table if requested.

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

1422: p_copy_redo_flag => l_copy_redo_flag
1423: );
1424:
1425: -- If API call returns with an error status...
1426: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1427: (l_return_status = FND_API.G_RET_STS_ERROR) then
1428: RAISE FND_API.G_EXC_ERROR;
1429: end if;
1430:

Line 1427: (l_return_status = FND_API.G_RET_STS_ERROR) then

1423: );
1424:
1425: -- If API call returns with an error status...
1426: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1427: (l_return_status = FND_API.G_RET_STS_ERROR) then
1428: RAISE FND_API.G_EXC_ERROR;
1429: end if;
1430:
1431: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1428: RAISE FND_API.G_EXC_ERROR;

1424:
1425: -- If API call returns with an error status...
1426: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1427: (l_return_status = FND_API.G_RET_STS_ERROR) then
1428: RAISE FND_API.G_EXC_ERROR;
1429: end if;
1430:
1431: p_return_status := FND_API.G_RET_STS_SUCCESS;
1432:

Line 1431: p_return_status := FND_API.G_RET_STS_SUCCESS;

1427: (l_return_status = FND_API.G_RET_STS_ERROR) then
1428: RAISE FND_API.G_EXC_ERROR;
1429: end if;
1430:
1431: p_return_status := FND_API.G_RET_STS_SUCCESS;
1432:
1433: EXCEPTION
1434: WHEN FND_API.G_EXC_ERROR THEN
1435: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1434: WHEN FND_API.G_EXC_ERROR THEN

1430:
1431: p_return_status := FND_API.G_RET_STS_SUCCESS;
1432:
1433: EXCEPTION
1434: WHEN FND_API.G_EXC_ERROR THEN
1435: p_return_status := FND_API.G_RET_STS_ERROR;
1436: rollback to start_update_page;
1437: WHEN OTHERS THEN
1438: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1435: p_return_status := FND_API.G_RET_STS_ERROR;

1431: p_return_status := FND_API.G_RET_STS_SUCCESS;
1432:
1433: EXCEPTION
1434: WHEN FND_API.G_EXC_ERROR THEN
1435: p_return_status := FND_API.G_RET_STS_ERROR;
1436: rollback to start_update_page;
1437: WHEN OTHERS THEN
1438: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1439: rollback to start_update_page;

Line 1438: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1434: WHEN FND_API.G_EXC_ERROR THEN
1435: p_return_status := FND_API.G_RET_STS_ERROR;
1436: rollback to start_update_page;
1437: WHEN OTHERS THEN
1438: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1439: rollback to start_update_page;
1440: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1441: SUBSTR (SQLERRM, 1, 240) );
1442: FND_MSG_PUB.Add;

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

1472: -- Version Initial version number = 1.0
1473: -- History Current version number = 1.0
1474: --=======================================================
1475: procedure UPDATE_PAGE_REGION (
1476: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1477: p_api_version_number IN NUMBER,
1478: p_init_msg_tbl IN BOOLEAN := FALSE,
1479: p_msg_count OUT NOCOPY NUMBER,
1480: p_msg_data OUT NOCOPY VARCHAR2,

Line 1488: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,

1484: p_page_application_id IN NUMBER,
1485: p_page_code IN VARCHAR2,
1486: p_region_application_id IN NUMBER,
1487: p_region_code IN VARCHAR2,
1488: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
1489: p_region_style IN VARCHAR2,
1490: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
1491: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
1492: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 1490: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,

1486: p_region_application_id IN NUMBER,
1487: p_region_code IN VARCHAR2,
1488: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
1489: p_region_style IN VARCHAR2,
1490: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
1491: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
1492: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
1493: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1494: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1491: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,

1487: p_region_code IN VARCHAR2,
1488: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
1489: p_region_style IN VARCHAR2,
1490: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
1491: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
1492: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
1493: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1494: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1495: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1492: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

1488: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
1489: p_region_style IN VARCHAR2,
1490: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
1491: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
1492: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
1493: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1494: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1495: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
1496: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 1493: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

1489: p_region_style IN VARCHAR2,
1490: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
1491: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
1492: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
1493: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1494: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1495: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
1496: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1497: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 1494: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

1490: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
1491: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
1492: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
1493: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1494: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1495: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
1496: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1497: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1498: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 1495: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,

1491: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
1492: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
1493: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1494: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1495: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
1496: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1497: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1498: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1499: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

1492: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
1493: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1494: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1495: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
1496: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1497: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1498: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1499: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1500: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

1493: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1494: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1495: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
1496: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1497: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1498: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1499: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1500: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1501: ) is

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

1494: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1495: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
1496: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1497: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1498: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1499: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1500: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1501: ) is
1502: l_api_version_number CONSTANT number := 1.0;

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

1495: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
1496: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1497: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1498: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1499: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1500: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1501: ) is
1502: l_api_version_number CONSTANT number := 1.0;
1503: l_api_name CONSTANT varchar2(30) := 'Update_Page_Region';

Line 1500: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

1496: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1497: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1498: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1499: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1500: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1501: ) is
1502: l_api_version_number CONSTANT number := 1.0;
1503: l_api_name CONSTANT varchar2(30) := 'Update_Page_Region';
1504: l_return_status VARCHAR2(1);

Line 1509: IF NOT FND_API.Compatible_API_Call (

1505: l_pass NUMBER := 2;
1506: l_copy_redo_flag BOOLEAN := FALSE;
1507: begin
1508: -- Check API version number
1509: IF NOT FND_API.Compatible_API_Call (
1510: l_api_version_number, p_api_version_number, l_api_name,
1511: G_PKG_NAME) then
1512: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1513: return;

Line 1512: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1508: -- Check API version number
1509: IF NOT FND_API.Compatible_API_Call (
1510: l_api_version_number, p_api_version_number, l_api_name,
1511: G_PKG_NAME) then
1512: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1513: return;
1514: END IF;
1515:
1516: -- Initialize the message table if requested.

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

1551: p_copy_redo_flag => l_copy_redo_flag
1552: );
1553:
1554: -- If API call returns with an error status...
1555: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1556: (l_return_status = FND_API.G_RET_STS_ERROR) then
1557: RAISE FND_API.G_EXC_ERROR;
1558: end if;
1559:

Line 1556: (l_return_status = FND_API.G_RET_STS_ERROR) then

1552: );
1553:
1554: -- If API call returns with an error status...
1555: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1556: (l_return_status = FND_API.G_RET_STS_ERROR) then
1557: RAISE FND_API.G_EXC_ERROR;
1558: end if;
1559:
1560: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1557: RAISE FND_API.G_EXC_ERROR;

1553:
1554: -- If API call returns with an error status...
1555: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1556: (l_return_status = FND_API.G_RET_STS_ERROR) then
1557: RAISE FND_API.G_EXC_ERROR;
1558: end if;
1559:
1560: p_return_status := FND_API.G_RET_STS_SUCCESS;
1561:

Line 1560: p_return_status := FND_API.G_RET_STS_SUCCESS;

1556: (l_return_status = FND_API.G_RET_STS_ERROR) then
1557: RAISE FND_API.G_EXC_ERROR;
1558: end if;
1559:
1560: p_return_status := FND_API.G_RET_STS_SUCCESS;
1561:
1562: EXCEPTION
1563: WHEN FND_API.G_EXC_ERROR THEN
1564: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1563: WHEN FND_API.G_EXC_ERROR THEN

1559:
1560: p_return_status := FND_API.G_RET_STS_SUCCESS;
1561:
1562: EXCEPTION
1563: WHEN FND_API.G_EXC_ERROR THEN
1564: p_return_status := FND_API.G_RET_STS_ERROR;
1565: rollback to start_update_page_region;
1566: WHEN OTHERS THEN
1567: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1564: p_return_status := FND_API.G_RET_STS_ERROR;

1560: p_return_status := FND_API.G_RET_STS_SUCCESS;
1561:
1562: EXCEPTION
1563: WHEN FND_API.G_EXC_ERROR THEN
1564: p_return_status := FND_API.G_RET_STS_ERROR;
1565: rollback to start_update_page_region;
1566: WHEN OTHERS THEN
1567: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1568: rollback to start_update_page_region;

Line 1567: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1563: WHEN FND_API.G_EXC_ERROR THEN
1564: p_return_status := FND_API.G_RET_STS_ERROR;
1565: rollback to start_update_page_region;
1566: WHEN OTHERS THEN
1567: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1568: rollback to start_update_page_region;
1569: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1570: SUBSTR (SQLERRM, 1, 240) );
1571: FND_MSG_PUB.Add;

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

1589: -- Version Initial version number = 1.0
1590: -- History Current version number = 1.0
1591: --=======================================================
1592: procedure UPDATE_PAGE_REGION_ITEM (
1593: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1594: p_api_version_number IN NUMBER,
1595: p_init_msg_tbl IN BOOLEAN := FALSE,
1596: p_msg_count OUT NOCOPY NUMBER,
1597: p_msg_data OUT NOCOPY VARCHAR2,

Line 1607: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,

1603: p_region_application_id IN NUMBER,
1604: p_region_code IN VARCHAR2,
1605: p_attribute_application_id IN NUMBER,
1606: p_attribute_code IN VARCHAR2,
1607: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1608: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1609: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1610: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1611: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 1608: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

1604: p_region_code IN VARCHAR2,
1605: p_attribute_application_id IN NUMBER,
1606: p_attribute_code IN VARCHAR2,
1607: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1608: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1609: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1610: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1611: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1612: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 1609: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,

1605: p_attribute_application_id IN NUMBER,
1606: p_attribute_code IN VARCHAR2,
1607: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1608: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1609: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1610: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1611: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1612: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1613: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 1610: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

1606: p_attribute_code IN VARCHAR2,
1607: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1608: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1609: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1610: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1611: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1612: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1613: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1614: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

1607: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1608: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1609: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1610: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1611: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1612: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1613: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1614: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1615: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

1608: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1609: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1610: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1611: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1612: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1613: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1614: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1615: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1616: ) is

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

1609: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1610: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1611: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1612: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1613: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1614: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1615: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1616: ) is
1617: l_api_version_number CONSTANT number := 1.0;

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

1610: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1611: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1612: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1613: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1614: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1615: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1616: ) is
1617: l_api_version_number CONSTANT number := 1.0;
1618: l_api_name CONSTANT varchar2(30) := 'Update_Page_Region_Item';

Line 1615: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

1611: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1612: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1613: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1614: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1615: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1616: ) is
1617: l_api_version_number CONSTANT number := 1.0;
1618: l_api_name CONSTANT varchar2(30) := 'Update_Page_Region_Item';
1619: l_return_status VARCHAR2(1);

Line 1624: IF NOT FND_API.Compatible_API_Call (

1620: l_pass NUMBER := 2;
1621: l_copy_redo_flag BOOLEAN := FALSE;
1622: begin
1623: -- Check API version number
1624: IF NOT FND_API.Compatible_API_Call (
1625: l_api_version_number, p_api_version_number, l_api_name,
1626: G_PKG_NAME) then
1627: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1628: return;

Line 1627: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1623: -- Check API version number
1624: IF NOT FND_API.Compatible_API_Call (
1625: l_api_version_number, p_api_version_number, l_api_name,
1626: G_PKG_NAME) then
1627: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1628: return;
1629: END IF;
1630:
1631: -- Initialize the message table if requested.

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

1664: p_copy_redo_flag => l_copy_redo_flag
1665: );
1666:
1667: -- If API call returns with an error status...
1668: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1669: (l_return_status = FND_API.G_RET_STS_ERROR) then
1670: RAISE FND_API.G_EXC_ERROR;
1671: end if;
1672:

Line 1669: (l_return_status = FND_API.G_RET_STS_ERROR) then

1665: );
1666:
1667: -- If API call returns with an error status...
1668: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1669: (l_return_status = FND_API.G_RET_STS_ERROR) then
1670: RAISE FND_API.G_EXC_ERROR;
1671: end if;
1672:
1673: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1670: RAISE FND_API.G_EXC_ERROR;

1666:
1667: -- If API call returns with an error status...
1668: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1669: (l_return_status = FND_API.G_RET_STS_ERROR) then
1670: RAISE FND_API.G_EXC_ERROR;
1671: end if;
1672:
1673: p_return_status := FND_API.G_RET_STS_SUCCESS;
1674:

Line 1673: p_return_status := FND_API.G_RET_STS_SUCCESS;

1669: (l_return_status = FND_API.G_RET_STS_ERROR) then
1670: RAISE FND_API.G_EXC_ERROR;
1671: end if;
1672:
1673: p_return_status := FND_API.G_RET_STS_SUCCESS;
1674:
1675: EXCEPTION
1676: WHEN FND_API.G_EXC_ERROR THEN
1677: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1676: WHEN FND_API.G_EXC_ERROR THEN

1672:
1673: p_return_status := FND_API.G_RET_STS_SUCCESS;
1674:
1675: EXCEPTION
1676: WHEN FND_API.G_EXC_ERROR THEN
1677: p_return_status := FND_API.G_RET_STS_ERROR;
1678: rollback to start_update_item;
1679: WHEN OTHERS THEN
1680: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1677: p_return_status := FND_API.G_RET_STS_ERROR;

1673: p_return_status := FND_API.G_RET_STS_SUCCESS;
1674:
1675: EXCEPTION
1676: WHEN FND_API.G_EXC_ERROR THEN
1677: p_return_status := FND_API.G_RET_STS_ERROR;
1678: rollback to start_update_item;
1679: WHEN OTHERS THEN
1680: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1681: rollback to start_update_item;

Line 1680: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1676: WHEN FND_API.G_EXC_ERROR THEN
1677: p_return_status := FND_API.G_RET_STS_ERROR;
1678: rollback to start_update_item;
1679: WHEN OTHERS THEN
1680: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1681: rollback to start_update_item;
1682: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1683: SUBSTR (SQLERRM, 1, 240) );
1684: FND_MSG_PUB.Add;

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

1702: -- Version Initial version number = 1.0
1703: -- History Current version number = 1.0
1704: --=======================================================
1705: procedure UPDATE_REGION_RELATION (
1706: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1707: p_api_version_number IN NUMBER,
1708: p_init_msg_tbl IN BOOLEAN := FALSE,
1709: p_msg_count OUT NOCOPY NUMBER,
1710: p_msg_data OUT NOCOPY VARCHAR2,

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

1720: p_to_page_code IN VARCHAR2,
1721: p_to_region_appl_id IN NUMBER,
1722: p_to_region_code IN VARCHAR2,
1723: p_application_id IN NUMBER,
1724: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1725: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1726: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1727: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1728: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

1721: p_to_region_appl_id IN NUMBER,
1722: p_to_region_code IN VARCHAR2,
1723: p_application_id IN NUMBER,
1724: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1725: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1726: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1727: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1728: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1729: ) is

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

1722: p_to_region_code IN VARCHAR2,
1723: p_application_id IN NUMBER,
1724: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1725: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1726: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1727: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1728: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1729: ) is
1730: l_api_version_number CONSTANT number := 1.0;

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

1723: p_application_id IN NUMBER,
1724: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1725: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1726: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1727: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1728: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1729: ) is
1730: l_api_version_number CONSTANT number := 1.0;
1731: l_api_name CONSTANT varchar2(30) := 'Update_Region_Relation';

Line 1728: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

1724: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1725: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1726: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1727: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1728: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
1729: ) is
1730: l_api_version_number CONSTANT number := 1.0;
1731: l_api_name CONSTANT varchar2(30) := 'Update_Region_Relation';
1732: l_return_status VARCHAR2(1);

Line 1737: IF NOT FND_API.Compatible_API_Call (

1733: l_pass NUMBER := 2;
1734: l_copy_redo_flag BOOLEAN := FALSE;
1735: begin
1736: -- Check API version number
1737: IF NOT FND_API.Compatible_API_Call (
1738: l_api_version_number, p_api_version_number, l_api_name,
1739: G_PKG_NAME) then
1740: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1741: return;

Line 1740: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1736: -- Check API version number
1737: IF NOT FND_API.Compatible_API_Call (
1738: l_api_version_number, p_api_version_number, l_api_name,
1739: G_PKG_NAME) then
1740: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1741: return;
1742: END IF;
1743:
1744: -- Initialize the message table if requested.

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

1777: p_copy_redo_flag => l_copy_redo_flag
1778: );
1779:
1780: -- If API call returns with an error status...
1781: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1782: (l_return_status = FND_API.G_RET_STS_ERROR) then
1783: RAISE FND_API.G_EXC_ERROR;
1784: end if;
1785:

Line 1782: (l_return_status = FND_API.G_RET_STS_ERROR) then

1778: );
1779:
1780: -- If API call returns with an error status...
1781: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1782: (l_return_status = FND_API.G_RET_STS_ERROR) then
1783: RAISE FND_API.G_EXC_ERROR;
1784: end if;
1785:
1786: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1783: RAISE FND_API.G_EXC_ERROR;

1779:
1780: -- If API call returns with an error status...
1781: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1782: (l_return_status = FND_API.G_RET_STS_ERROR) then
1783: RAISE FND_API.G_EXC_ERROR;
1784: end if;
1785:
1786: p_return_status := FND_API.G_RET_STS_SUCCESS;
1787:

Line 1786: p_return_status := FND_API.G_RET_STS_SUCCESS;

1782: (l_return_status = FND_API.G_RET_STS_ERROR) then
1783: RAISE FND_API.G_EXC_ERROR;
1784: end if;
1785:
1786: p_return_status := FND_API.G_RET_STS_SUCCESS;
1787:
1788: EXCEPTION
1789: WHEN FND_API.G_EXC_ERROR THEN
1790: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1789: WHEN FND_API.G_EXC_ERROR THEN

1785:
1786: p_return_status := FND_API.G_RET_STS_SUCCESS;
1787:
1788: EXCEPTION
1789: WHEN FND_API.G_EXC_ERROR THEN
1790: p_return_status := FND_API.G_RET_STS_ERROR;
1791: rollback to start_update_relation;
1792: WHEN OTHERS THEN
1793: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1790: p_return_status := FND_API.G_RET_STS_ERROR;

1786: p_return_status := FND_API.G_RET_STS_SUCCESS;
1787:
1788: EXCEPTION
1789: WHEN FND_API.G_EXC_ERROR THEN
1790: p_return_status := FND_API.G_RET_STS_ERROR;
1791: rollback to start_update_relation;
1792: WHEN OTHERS THEN
1793: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1794: rollback to start_update_relation;

Line 1793: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1789: WHEN FND_API.G_EXC_ERROR THEN
1790: p_return_status := FND_API.G_RET_STS_ERROR;
1791: rollback to start_update_relation;
1792: WHEN OTHERS THEN
1793: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1794: rollback to start_update_relation;
1795: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1796: SUBSTR (SQLERRM, 1, 240) );
1797: FND_MSG_PUB.Add;