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:
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,
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:
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,
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,
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 ,
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,
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
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;
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
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;
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: );
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:
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:
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,
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:
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,
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,
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,
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,
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
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;
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:
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: );
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;
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:
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,
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,
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:
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;
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:
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: );
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:
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:
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,
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',
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,
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;
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);
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: );
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:
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:
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,
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',
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,
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;
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
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: );
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;
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:
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,
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,
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:
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;
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
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: );
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;
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:
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,
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,
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:
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;
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
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: );
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;