DBA Data[Home] [Help]

APPS.PA_PAGE_LAYOUT_PUB dependencies on FND_API

Line 12: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

8:
9: PROCEDURE Create_Page_Layout
10: (
11: p_api_version IN NUMBER := 1.0,
12: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
13: p_commit IN VARCHAR2 := FND_API.g_false,
14: p_validate_only IN VARCHAR2 := FND_API.g_true,
15: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
16:

Line 13: p_commit IN VARCHAR2 := FND_API.g_false,

9: PROCEDURE Create_Page_Layout
10: (
11: p_api_version IN NUMBER := 1.0,
12: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
13: p_commit IN VARCHAR2 := FND_API.g_false,
14: p_validate_only IN VARCHAR2 := FND_API.g_true,
15: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
16:
17: p_page_name IN VARCHAR2 := FND_API.g_miss_char,

Line 14: p_validate_only IN VARCHAR2 := FND_API.g_true,

10: (
11: p_api_version IN NUMBER := 1.0,
12: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
13: p_commit IN VARCHAR2 := FND_API.g_false,
14: p_validate_only IN VARCHAR2 := FND_API.g_true,
15: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
16:
17: p_page_name IN VARCHAR2 := FND_API.g_miss_char,
18:

Line 15: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

11: p_api_version IN NUMBER := 1.0,
12: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
13: p_commit IN VARCHAR2 := FND_API.g_false,
14: p_validate_only IN VARCHAR2 := FND_API.g_true,
15: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
16:
17: p_page_name IN VARCHAR2 := FND_API.g_miss_char,
18:
19: p_page_type IN VARCHAR2 := FND_API.g_miss_char,

Line 17: p_page_name IN VARCHAR2 := FND_API.g_miss_char,

13: p_commit IN VARCHAR2 := FND_API.g_false,
14: p_validate_only IN VARCHAR2 := FND_API.g_true,
15: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
16:
17: p_page_name IN VARCHAR2 := FND_API.g_miss_char,
18:
19: p_page_type IN VARCHAR2 := FND_API.g_miss_char,
20:
21: p_description IN VARCHAR2 := FND_API.g_miss_char,

Line 19: p_page_type IN VARCHAR2 := FND_API.g_miss_char,

15: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
16:
17: p_page_name IN VARCHAR2 := FND_API.g_miss_char,
18:
19: p_page_type IN VARCHAR2 := FND_API.g_miss_char,
20:
21: p_description IN VARCHAR2 := FND_API.g_miss_char,
22:
23: p_start_date IN DATE ,

Line 21: p_description IN VARCHAR2 := FND_API.g_miss_char,

17: p_page_name IN VARCHAR2 := FND_API.g_miss_char,
18:
19: p_page_type IN VARCHAR2 := FND_API.g_miss_char,
20:
21: p_description IN VARCHAR2 := FND_API.g_miss_char,
22:
23: p_start_date IN DATE ,
24:
25: p_end_date IN DATE := null,

Line 26: p_shortcut_menu_id IN NUMBER := FND_API.g_miss_num,

22:
23: p_start_date IN DATE ,
24:
25: p_end_date IN DATE := null,
26: p_shortcut_menu_id IN NUMBER := FND_API.g_miss_num,
27: p_shortcut_menu_name IN VARCHAR2 := NULL,
28: p_function_name IN VARCHAR2,
29: x_page_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
30: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 60: x_return_status := FND_API.G_RET_STS_SUCCESS;

56: -- Initialize the Error Stack
57: PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_PUB.Create_Page_Layout');
58:
59: -- Initialize the return status to success
60: x_return_status := FND_API.G_RET_STS_SUCCESS;
61:
62: --Clear the global PL/SQL message table
63: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
64: FND_MSG_PUB.initialize;

Line 63: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

59: -- Initialize the return status to success
60: x_return_status := FND_API.G_RET_STS_SUCCESS;
61:
62: --Clear the global PL/SQL message table
63: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
64: FND_MSG_PUB.initialize;
65: END IF;
66:
67: IF p_page_type = FND_API.g_miss_char THEN

Line 67: IF p_page_type = FND_API.g_miss_char THEN

63: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
64: FND_MSG_PUB.initialize;
65: END IF;
66:
67: IF p_page_type = FND_API.g_miss_char THEN
68: l_page_type := 'PPR';
69: ELSE
70: l_page_type := p_page_type;
71: END IF;

Line 124: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

120: --
121:
122: x_msg_count := FND_MSG_PUB.Count_Msg;
123: IF x_msg_count = 1 THEN
124: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
125: ,p_msg_index => 1
126: ,p_data => x_msg_data
127: ,p_msg_index_out => l_msg_index_out
128: );

Line 146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

142: -- Set the excetption Message and the stack
143: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_LAYOUT_PUB.Create_Page_Layout'
144: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
145: --
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
147: RAISE; -- This is optional depending on the needs
148:
149: END create_page_layout;
150:

Line 156: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

152:
153: PROCEDURE Update_Page_Layout
154: (
155: p_api_version IN NUMBER := 1.0,
156: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
157: p_commit IN VARCHAR2 := FND_API.g_false,
158: p_validate_only IN VARCHAR2 := FND_API.g_true,
159: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
160:

Line 157: p_commit IN VARCHAR2 := FND_API.g_false,

153: PROCEDURE Update_Page_Layout
154: (
155: p_api_version IN NUMBER := 1.0,
156: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
157: p_commit IN VARCHAR2 := FND_API.g_false,
158: p_validate_only IN VARCHAR2 := FND_API.g_true,
159: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
160:
161: p_page_id IN NUMBER := null,

Line 158: p_validate_only IN VARCHAR2 := FND_API.g_true,

154: (
155: p_api_version IN NUMBER := 1.0,
156: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
157: p_commit IN VARCHAR2 := FND_API.g_false,
158: p_validate_only IN VARCHAR2 := FND_API.g_true,
159: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
160:
161: p_page_id IN NUMBER := null,
162:

Line 159: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

155: p_api_version IN NUMBER := 1.0,
156: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
157: p_commit IN VARCHAR2 := FND_API.g_false,
158: p_validate_only IN VARCHAR2 := FND_API.g_true,
159: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
160:
161: p_page_id IN NUMBER := null,
162:
163: p_page_name IN VARCHAR2 := FND_API.g_miss_char,

Line 163: p_page_name IN VARCHAR2 := FND_API.g_miss_char,

159: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
160:
161: p_page_id IN NUMBER := null,
162:
163: p_page_name IN VARCHAR2 := FND_API.g_miss_char,
164:
165: -- p_page_type IN VARCHAR2 := FND_API.g_miss_char,
166:
167: p_description IN VARCHAR2 := FND_API.g_miss_char,

Line 165: -- p_page_type IN VARCHAR2 := FND_API.g_miss_char,

161: p_page_id IN NUMBER := null,
162:
163: p_page_name IN VARCHAR2 := FND_API.g_miss_char,
164:
165: -- p_page_type IN VARCHAR2 := FND_API.g_miss_char,
166:
167: p_description IN VARCHAR2 := FND_API.g_miss_char,
168:
169: p_start_date IN DATE := null,

Line 167: p_description IN VARCHAR2 := FND_API.g_miss_char,

163: p_page_name IN VARCHAR2 := FND_API.g_miss_char,
164:
165: -- p_page_type IN VARCHAR2 := FND_API.g_miss_char,
166:
167: p_description IN VARCHAR2 := FND_API.g_miss_char,
168:
169: p_start_date IN DATE := null,
170:
171: p_end_date IN DATE := null,

Line 172: p_shortcut_menu_id IN NUMBER := FND_API.g_miss_num,

168:
169: p_start_date IN DATE := null,
170:
171: p_end_date IN DATE := null,
172: p_shortcut_menu_id IN NUMBER := FND_API.g_miss_num,
173: p_shortcut_menu_name IN VARCHAR2 := NULL,
174: p_record_version_number IN NUMBER := null,
175: p_function_name IN VARCHAR2,
176: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 188: x_return_status := FND_API.G_RET_STS_SUCCESS;

184: -- Initialize the Error Stack
185: PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_PUB.Update_Page_Layout');
186:
187: -- Initialize the return status to success
188: x_return_status := FND_API.G_RET_STS_SUCCESS;
189:
190: --Clear the global PL/SQL message table
191: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
192: FND_MSG_PUB.initialize;

Line 191: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

187: -- Initialize the return status to success
188: x_return_status := FND_API.G_RET_STS_SUCCESS;
189:
190: --Clear the global PL/SQL message table
191: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
192: FND_MSG_PUB.initialize;
193: END IF;
194:
195:

Line 226: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

222: -- stack and return its text
223: --
224: x_msg_count := FND_MSG_PUB.Count_Msg;
225: IF x_msg_count = 1 THEN
226: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
227: ,p_msg_index => 1
228: ,p_data => x_msg_data
229: ,p_msg_index_out => l_msg_index_out
230: );

Line 246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

242: -- Set the exception Message and the stack
243: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_LAYOUT_PUB.Update_Page_Layout'
244: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
245: --
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
247: RAISE; -- This is optional depending on the needs
248: --
249:
250: END update_page_layout;

Line 257: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

253:
254: PROCEDURE Delete_Page_Layout
255: (
256: p_api_version IN NUMBER := 1.0,
257: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
258: p_commit IN VARCHAR2 := FND_API.g_false,
259: p_validate_only IN VARCHAR2 := FND_API.g_true,
260: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
261:

Line 258: p_commit IN VARCHAR2 := FND_API.g_false,

254: PROCEDURE Delete_Page_Layout
255: (
256: p_api_version IN NUMBER := 1.0,
257: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
258: p_commit IN VARCHAR2 := FND_API.g_false,
259: p_validate_only IN VARCHAR2 := FND_API.g_true,
260: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
261:
262: p_page_id IN NUMBER := null,

Line 259: p_validate_only IN VARCHAR2 := FND_API.g_true,

255: (
256: p_api_version IN NUMBER := 1.0,
257: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
258: p_commit IN VARCHAR2 := FND_API.g_false,
259: p_validate_only IN VARCHAR2 := FND_API.g_true,
260: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
261:
262: p_page_id IN NUMBER := null,
263: p_record_version_number IN NUMBER := null,

Line 260: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

256: p_api_version IN NUMBER := 1.0,
257: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
258: p_commit IN VARCHAR2 := FND_API.g_false,
259: p_validate_only IN VARCHAR2 := FND_API.g_true,
260: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
261:
262: p_page_id IN NUMBER := null,
263: p_record_version_number IN NUMBER := null,
264:

Line 277: x_return_status := FND_API.G_RET_STS_SUCCESS;

273:
274: -- Initialize the Error Stack
275: PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_PUB.Delete_Page_Layout');
276:
277: x_return_status := FND_API.G_RET_STS_SUCCESS;
278:
279: --Clear the global PL/SQL message table
280: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
281: FND_MSG_PUB.initialize;

Line 280: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

276:
277: x_return_status := FND_API.G_RET_STS_SUCCESS;
278:
279: --Clear the global PL/SQL message table
280: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
281: FND_MSG_PUB.initialize;
282: END IF;
283:
284:

Line 306: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

302: -- stack and return its text
303: --
304: x_msg_count := FND_MSG_PUB.Count_Msg;
305: IF x_msg_count = 1 THEN
306: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
307: ,p_msg_index => 1
308: ,p_data => x_msg_data
309: ,p_msg_index_out => l_msg_index_out
310: );

Line 327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

323: -- Set the excetption Message and the stack
324: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PAGE_LAYOUT_PUB.Delete_Page_Layout'
325: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
326: --
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
328: RAISE; -- This is optional depending on the needs
329:
330: END delete_page_layout;
331:

Line 334: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

330: END delete_page_layout;
331:
332: procedure ADD_PAGE_REGION (
333: p_api_version IN NUMBER := 1.0,
334: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
335: p_commit IN VARCHAR2 := FND_API.g_false,
336: p_validate_only IN VARCHAR2 := FND_API.g_true,
337: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
338:

Line 335: p_commit IN VARCHAR2 := FND_API.g_false,

331:
332: procedure ADD_PAGE_REGION (
333: p_api_version IN NUMBER := 1.0,
334: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
335: p_commit IN VARCHAR2 := FND_API.g_false,
336: p_validate_only IN VARCHAR2 := FND_API.g_true,
337: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
338:
339: P_PAGE_ID in NUMBER := null,

Line 336: p_validate_only IN VARCHAR2 := FND_API.g_true,

332: procedure ADD_PAGE_REGION (
333: p_api_version IN NUMBER := 1.0,
334: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
335: p_commit IN VARCHAR2 := FND_API.g_false,
336: p_validate_only IN VARCHAR2 := FND_API.g_true,
337: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
338:
339: P_PAGE_ID in NUMBER := null,
340: P_REGION_SOURCE_TYPE in VARCHAR2 default 'STD',

Line 337: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

333: p_api_version IN NUMBER := 1.0,
334: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
335: p_commit IN VARCHAR2 := FND_API.g_false,
336: p_validate_only IN VARCHAR2 := FND_API.g_true,
337: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
338:
339: P_PAGE_ID in NUMBER := null,
340: P_REGION_SOURCE_TYPE in VARCHAR2 default 'STD',
341: P_REGION_SOURCE_CODE in VARCHAR2,

Line 375: x_return_status := FND_API.G_RET_STS_SUCCESS;

371: -- Initialize the Error Stack
372: PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_PUB.Add_Page_Region');
373:
374: -- Initialize the return status to success
375: x_return_status := FND_API.G_RET_STS_SUCCESS;
376:
377: --Clear the global PL/SQL message table
378: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
379: FND_MSG_PUB.initialize;

Line 378: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

374: -- Initialize the return status to success
375: x_return_status := FND_API.G_RET_STS_SUCCESS;
376:
377: --Clear the global PL/SQL message table
378: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
379: FND_MSG_PUB.initialize;
380: END IF;
381:
382: --debug_msg_s1('***p_view_region_code ' || p_view_region_code);

Line 424: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

420: --
421:
422: x_msg_count := FND_MSG_PUB.Count_Msg;
423: IF x_msg_count = 1 THEN
424: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
425: ,p_msg_index => 1
426: ,p_data => x_msg_data
427: ,p_msg_index_out => l_msg_index_out
428: );

Line 445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

441: -- Set the excetption Message and the stack
442: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_LAYOUT_PUB.ADD_Page_Region'
443: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
444: --
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
446: RAISE; -- This is optional depending on the needs
447:
448: END add_page_region;
449:

Line 453: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

449:
450: PROCEDURE Delete_Page_Region
451: (
452: p_api_version IN NUMBER := 1.0,
453: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
454: p_commit IN VARCHAR2 := FND_API.g_false,
455: p_validate_only IN VARCHAR2 := FND_API.g_true,
456: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
457:

Line 454: p_commit IN VARCHAR2 := FND_API.g_false,

450: PROCEDURE Delete_Page_Region
451: (
452: p_api_version IN NUMBER := 1.0,
453: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
454: p_commit IN VARCHAR2 := FND_API.g_false,
455: p_validate_only IN VARCHAR2 := FND_API.g_true,
456: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
457:
458: p_page_id IN NUMBER := null,

Line 455: p_validate_only IN VARCHAR2 := FND_API.g_true,

451: (
452: p_api_version IN NUMBER := 1.0,
453: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
454: p_commit IN VARCHAR2 := FND_API.g_false,
455: p_validate_only IN VARCHAR2 := FND_API.g_true,
456: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
457:
458: p_page_id IN NUMBER := null,
459: P_REGION_SOURCE_TYPE in VARCHAR2 := 'STD',

Line 456: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

452: p_api_version IN NUMBER := 1.0,
453: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
454: p_commit IN VARCHAR2 := FND_API.g_false,
455: p_validate_only IN VARCHAR2 := FND_API.g_true,
456: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
457:
458: p_page_id IN NUMBER := null,
459: P_REGION_SOURCE_TYPE in VARCHAR2 := 'STD',
460: P_REGION_SOURCE_CODE in VARCHAR2,

Line 474: x_return_status := FND_API.G_RET_STS_SUCCESS;

470: -- Initialize the Error Stack
471: PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_PUB.Delete_Page_Region');
472:
473: -- Initialize the return status to success
474: x_return_status := FND_API.G_RET_STS_SUCCESS;
475:
476: --Clear the global PL/SQL message table
477: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
478: FND_MSG_PUB.initialize;

Line 477: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

473: -- Initialize the return status to success
474: x_return_status := FND_API.G_RET_STS_SUCCESS;
475:
476: --Clear the global PL/SQL message table
477: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
478: FND_MSG_PUB.initialize;
479: END IF;
480:
481: pa_page_layout_pvt.Delete_Page_Region

Line 505: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

501: -- stack and return its text
502: --
503: x_msg_count := FND_MSG_PUB.Count_Msg;
504: IF x_msg_count = 1 THEN
505: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
506: ,p_msg_index => 1
507: ,p_data => x_msg_data
508: ,p_msg_index_out => l_msg_index_out
509: );

Line 525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

521: -- Set the exception Message and the stack
522: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_LAYOUT_PUB.Delete_Page_Region'
523: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
524: --
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
526: RAISE; -- This is optional depending on the needs
527: --
528:
529: END delete_page_region;

Line 534: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

530:
531: PROCEDURE Delete_All_Page_Region
532: (
533: p_api_version IN NUMBER := 1.0,
534: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
535: p_commit IN VARCHAR2 := FND_API.g_false,
536: p_validate_only IN VARCHAR2 := FND_API.g_true,
537: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
538:

Line 535: p_commit IN VARCHAR2 := FND_API.g_false,

531: PROCEDURE Delete_All_Page_Region
532: (
533: p_api_version IN NUMBER := 1.0,
534: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
535: p_commit IN VARCHAR2 := FND_API.g_false,
536: p_validate_only IN VARCHAR2 := FND_API.g_true,
537: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
538:
539: p_page_id IN NUMBER := null,

Line 536: p_validate_only IN VARCHAR2 := FND_API.g_true,

532: (
533: p_api_version IN NUMBER := 1.0,
534: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
535: p_commit IN VARCHAR2 := FND_API.g_false,
536: p_validate_only IN VARCHAR2 := FND_API.g_true,
537: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
538:
539: p_page_id IN NUMBER := null,
540: p_region_position IN VARCHAR2 := null,

Line 537: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

533: p_api_version IN NUMBER := 1.0,
534: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
535: p_commit IN VARCHAR2 := FND_API.g_false,
536: p_validate_only IN VARCHAR2 := FND_API.g_true,
537: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
538:
539: p_page_id IN NUMBER := null,
540: p_region_position IN VARCHAR2 := null,
541:

Line 554: x_return_status := FND_API.G_RET_STS_SUCCESS;

550: -- Initialize the Error Stack
551: PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_PUB.Delete_All_Page_Region');
552:
553: -- Initialize the return status to success
554: x_return_status := FND_API.G_RET_STS_SUCCESS;
555:
556: --Clear the global PL/SQL message table
557: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
558: FND_MSG_PUB.initialize;

Line 557: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

553: -- Initialize the return status to success
554: x_return_status := FND_API.G_RET_STS_SUCCESS;
555:
556: --Clear the global PL/SQL message table
557: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
558: FND_MSG_PUB.initialize;
559: END IF;
560:
561: pa_page_layout_pvt.Delete_All_Page_Region

Line 585: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

581: -- stack and return its text
582: --
583: x_msg_count := FND_MSG_PUB.Count_Msg;
584: IF x_msg_count = 1 THEN
585: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
586: ,p_msg_index => 1
587: ,p_data => x_msg_data
588: ,p_msg_index_out => l_msg_index_out
589: );

Line 605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

601: -- Set the exception Message and the stack
602: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_LAYOUT_PUB.Delete_All_Page_Region'
603: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
604: --
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
606: RAISE; -- This is optional depending on the needs
607: --
608:
609: END delete_all_page_region;

Line 614: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

610:
611: PROCEDURE Delete_All_link_Page_Region
612: (
613: p_api_version IN NUMBER := 1.0,
614: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
615: p_commit IN VARCHAR2 := FND_API.g_false,
616: p_validate_only IN VARCHAR2 := FND_API.g_true,
617: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
618:

Line 615: p_commit IN VARCHAR2 := FND_API.g_false,

611: PROCEDURE Delete_All_link_Page_Region
612: (
613: p_api_version IN NUMBER := 1.0,
614: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
615: p_commit IN VARCHAR2 := FND_API.g_false,
616: p_validate_only IN VARCHAR2 := FND_API.g_true,
617: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
618:
619: p_page_id IN NUMBER := null,

Line 616: p_validate_only IN VARCHAR2 := FND_API.g_true,

612: (
613: p_api_version IN NUMBER := 1.0,
614: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
615: p_commit IN VARCHAR2 := FND_API.g_false,
616: p_validate_only IN VARCHAR2 := FND_API.g_true,
617: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
618:
619: p_page_id IN NUMBER := null,
620: p_region_position IN VARCHAR2 := null,

Line 617: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

613: p_api_version IN NUMBER := 1.0,
614: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
615: p_commit IN VARCHAR2 := FND_API.g_false,
616: p_validate_only IN VARCHAR2 := FND_API.g_true,
617: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
618:
619: p_page_id IN NUMBER := null,
620: p_region_position IN VARCHAR2 := null,
621:

Line 634: x_return_status := FND_API.G_RET_STS_SUCCESS;

630: -- Initialize the Error Stack
631: PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_PUB.Delete_All_link_Page_Region');
632:
633: -- Initialize the return status to success
634: x_return_status := FND_API.G_RET_STS_SUCCESS;
635:
636: --Clear the global PL/SQL message table
637: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
638: FND_MSG_PUB.initialize;

Line 637: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

633: -- Initialize the return status to success
634: x_return_status := FND_API.G_RET_STS_SUCCESS;
635:
636: --Clear the global PL/SQL message table
637: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
638: FND_MSG_PUB.initialize;
639: END IF;
640:
641: pa_page_layout_pvt.Delete_All_link_Page_Region

Line 665: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

661: -- stack and return its text
662: --
663: x_msg_count := FND_MSG_PUB.Count_Msg;
664: IF x_msg_count = 1 THEN
665: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
666: ,p_msg_index => 1
667: ,p_data => x_msg_data
668: ,p_msg_index_out => l_msg_index_out
669: );

Line 685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

681: -- Set the exception Message and the stack
682: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_LAYOUT_PUB.Delete_All_link_Page_Region'
683: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
684: --
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
686: RAISE; -- This is optional depending on the needs
687: --
688:
689: END delete_all_link_page_region;