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.PA_PAGE_LAYOUT_PVT 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,

Line 77: x_return_status := FND_API.G_RET_STS_SUCCESS;

73: -- Initialize the Error Stack
74: PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_PVT.Create_Page_Layout');
75:
76: -- Initialize the return status to success
77: x_return_status := FND_API.G_RET_STS_SUCCESS;
78:
79: -- Issue API savepoint if the transaction is to be committed
80: IF p_commit = FND_API.G_TRUE THEN
81: SAVEPOINT PAGE_LAYOUT_PVT_CREATE;

Line 80: IF p_commit = FND_API.G_TRUE THEN

76: -- Initialize the return status to success
77: x_return_status := FND_API.G_RET_STS_SUCCESS;
78:
79: -- Issue API savepoint if the transaction is to be committed
80: IF p_commit = FND_API.G_TRUE THEN
81: SAVEPOINT PAGE_LAYOUT_PVT_CREATE;
82: END IF;
83:
84: OPEN get_template_type;

Line 109: x_return_status := FND_API.G_RET_STS_ERROR;

105: CLOSE get_menu_id;
106: PA_UTILS.Add_Message( p_app_short_name => 'PA'
107: ,p_msg_name => 'PA_MENU_NAME_INV'
108: );
109: x_return_status := FND_API.G_RET_STS_ERROR;
110: RETURN;
111: ELSE
112: CLOSE get_menu_id;
113: END IF;

Line 120: IF (p_page_name IS NULL OR p_page_name = FND_API.g_miss_char) then

116: END IF;
117:
118:
119: -- check the mandatory page_name
120: IF (p_page_name IS NULL OR p_page_name = FND_API.g_miss_char) then
121: PA_UTILS.Add_Message( p_app_short_name => 'PA'
122: ,p_msg_name => 'PA_PAGE_NAME_INV'
123: , p_token1 => 'TEMPLATE_TYPE'
124: , p_value1 => l_type);

Line 125: x_return_status := FND_API.G_RET_STS_ERROR;

121: PA_UTILS.Add_Message( p_app_short_name => 'PA'
122: ,p_msg_name => 'PA_PAGE_NAME_INV'
123: , p_token1 => 'TEMPLATE_TYPE'
124: , p_value1 => l_type);
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: ELSE
127:
128: -- added by syao check if the name already exists
129: open get_menu_name;

Line 138: x_return_status := FND_API.G_RET_STS_ERROR;

134: CLOSE get_menu_name;
135: PA_UTILS.Add_Message( p_app_short_name => 'PA'
136: ,p_msg_name => 'PA_PAGE_NAME_NOT_UNIQUE'
137: );
138: x_return_status := FND_API.G_RET_STS_ERROR;
139: RETURN;
140: end if;
141: close get_menu_name;
142: -- end

Line 146: IF (p_page_type IS NULL OR p_page_type = FND_API.g_miss_char)THEN

142: -- end
143:
144:
145: -- check the page type is not null
146: IF (p_page_type IS NULL OR p_page_type = FND_API.g_miss_char)THEN
147: PA_UTILS.Add_Message( p_app_short_name => 'PA'
148: ,p_msg_name => 'PA_PAGE_TYPE_INV'
149: , p_token1 => 'TEMPLATE_TYPE'
150: , p_value1 => l_type);

Line 151: x_return_status := FND_API.G_RET_STS_ERROR;

147: PA_UTILS.Add_Message( p_app_short_name => 'PA'
148: ,p_msg_name => 'PA_PAGE_TYPE_INV'
149: , p_token1 => 'TEMPLATE_TYPE'
150: , p_value1 => l_type);
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: END IF;
153:
154: -- check the end date and start date
155:

Line 161: x_return_status := FND_API.G_RET_STS_ERROR;

157: IF (p_end_date IS NOT NULL AND p_end_date < p_start_date) THEN
158: PA_UTILS.Add_Message( p_app_short_name => 'PA'
159: ,p_msg_name => 'PA_EFFECTIVE_ED_DATE_INV');
160:
161: x_return_status := FND_API.G_RET_STS_ERROR;
162: END IF;
163:
164:
165: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then

Line 165: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then

161: x_return_status := FND_API.G_RET_STS_ERROR;
162: END IF;
163:
164:
165: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then
166:
167: --debug_msg ('shore menu id = ' || to_char(p_shortcut_menu_id));
168: pa_page_layout_pkg.Insert_page_layout_Row
169: (

Line 187: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.g_ret_sts_success )THEN

183: END IF;
184:
185:
186: -- Commit if the flag is set and there is no error
187: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.g_ret_sts_success )THEN
188: COMMIT;
189: END IF;
190:
191: END IF;

Line 199: IF p_commit = FND_API.G_TRUE THEN

195:
196:
197: EXCEPTION
198: WHEN OTHERS THEN
199: IF p_commit = FND_API.G_TRUE THEN
200: ROLLBACK TO PAGE_LAYOUT_PVT_CREATE;
201: END IF;
202: --
203: -- Set the excetption Message and the stack

Line 207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

203: -- Set the excetption Message and the stack
204: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_LAYOUT_PVT.Create_Page_Layout'
205: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
206: --
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
208: RAISE; -- This is optional depending on the needs
209:
210: END create_page_layout;
211:

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

213:
214: PROCEDURE Update_Page_Layout
215: (
216: p_api_version IN NUMBER := 1.0,
217: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
218: p_commit IN VARCHAR2 := FND_API.g_false,
219: p_validate_only IN VARCHAR2 := FND_API.g_true,
220: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
221:

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

214: PROCEDURE Update_Page_Layout
215: (
216: p_api_version IN NUMBER := 1.0,
217: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
218: p_commit IN VARCHAR2 := FND_API.g_false,
219: p_validate_only IN VARCHAR2 := FND_API.g_true,
220: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
221:
222: p_page_id IN number,

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

215: (
216: p_api_version IN NUMBER := 1.0,
217: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
218: p_commit IN VARCHAR2 := FND_API.g_false,
219: p_validate_only IN VARCHAR2 := FND_API.g_true,
220: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
221:
222: p_page_id IN number,
223:

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

216: p_api_version IN NUMBER := 1.0,
217: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
218: p_commit IN VARCHAR2 := FND_API.g_false,
219: p_validate_only IN VARCHAR2 := FND_API.g_true,
220: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
221:
222: p_page_id IN number,
223:
224: p_page_name IN VARCHAR2 := FND_API.g_miss_char,

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

220: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
221:
222: p_page_id IN number,
223:
224: p_page_name IN VARCHAR2 := FND_API.g_miss_char,
225:
226: -- p_page_type IN VARCHAR2 := FND_API.g_miss_char,
227:
228: p_description IN VARCHAR2 := FND_API.g_miss_char,

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

222: p_page_id IN number,
223:
224: p_page_name IN VARCHAR2 := FND_API.g_miss_char,
225:
226: -- p_page_type IN VARCHAR2 := FND_API.g_miss_char,
227:
228: p_description IN VARCHAR2 := FND_API.g_miss_char,
229:
230: p_start_date IN date,

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

224: p_page_name IN VARCHAR2 := FND_API.g_miss_char,
225:
226: -- p_page_type IN VARCHAR2 := FND_API.g_miss_char,
227:
228: p_description IN VARCHAR2 := FND_API.g_miss_char,
229:
230: p_start_date IN date,
231:
232: p_end_date IN date,

Line 288: x_return_status := FND_API.G_RET_STS_SUCCESS;

284: -- Initialize the Error Stack
285: PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_PVT.Create_Page_Layout');
286:
287: -- Initialize the return status to success
288: x_return_status := FND_API.G_RET_STS_SUCCESS;
289:
290: -- Issue API savepoint if the transaction is to be committed
291: IF p_commit = FND_API.G_TRUE THEN
292: SAVEPOINT PAGE_LAYOUT_PVT_UPDATE;

Line 291: IF p_commit = FND_API.G_TRUE THEN

287: -- Initialize the return status to success
288: x_return_status := FND_API.G_RET_STS_SUCCESS;
289:
290: -- Issue API savepoint if the transaction is to be committed
291: IF p_commit = FND_API.G_TRUE THEN
292: SAVEPOINT PAGE_LAYOUT_PVT_UPDATE;
293: END IF;
294:
295: IF p_shortcut_menu_id IS NOT NULL AND p_shortcut_menu_id <> -99 THEN

Line 315: x_return_status := FND_API.G_RET_STS_ERROR;

311: CLOSE get_menu_id;
312: PA_UTILS.Add_Message( p_app_short_name => 'PA'
313: ,p_msg_name => 'PA_MENU_NAME_INV'
314: );
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: RETURN;
317: ELSE
318: CLOSE get_menu_id;
319: END IF;

Line 329: IF (p_page_id IS NULL OR p_page_id = FND_API.g_miss_num)THEN

325: FETCH get_template_type INTO l_type;
326: CLOSE get_template_type;
327:
328: -- check the page id is not null
329: IF (p_page_id IS NULL OR p_page_id = FND_API.g_miss_num)THEN
330: PA_UTILS.Add_Message( p_app_short_name => 'PA'
331: ,p_msg_name => 'PA_PAGE_ID_INV'
332: , p_token1 => 'TEMPLATE_TYPE'
333: , p_value1 => l_type);

Line 334: x_return_status := FND_API.G_RET_STS_ERROR;

330: PA_UTILS.Add_Message( p_app_short_name => 'PA'
331: ,p_msg_name => 'PA_PAGE_ID_INV'
332: , p_token1 => 'TEMPLATE_TYPE'
333: , p_value1 => l_type);
334: x_return_status := FND_API.G_RET_STS_ERROR;
335: END IF;
336:
337: -- check the mandatory page name is not null
338: IF (p_page_name IS NULL OR p_page_name = FND_API.g_miss_char)THEN

Line 338: IF (p_page_name IS NULL OR p_page_name = FND_API.g_miss_char)THEN

334: x_return_status := FND_API.G_RET_STS_ERROR;
335: END IF;
336:
337: -- check the mandatory page name is not null
338: IF (p_page_name IS NULL OR p_page_name = FND_API.g_miss_char)THEN
339: PA_UTILS.Add_Message( p_app_short_name => 'PA'
340: ,p_msg_name => 'PA_PAGE_NAME_INV'
341: , p_token1 => 'TEMPLATE_TYPE'
342: , p_value1 => l_type

Line 344: x_return_status := FND_API.G_RET_STS_ERROR;

340: ,p_msg_name => 'PA_PAGE_NAME_INV'
341: , p_token1 => 'TEMPLATE_TYPE'
342: , p_value1 => l_type
343: );
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: --ELSE
346: -- check the page name is unique
347: -- OPEN check_page_name;
348: -- FETCH check_page_name INTO l_name_exists;

Line 354: --x_return_status := FND_API.G_RET_STS_ERROR;

350:
351: --IF l_names_exists = 'Y' THEN
352: --PA_UTILS.Add_Message( p_app_short_name => 'PA'
353: -- ,p_msg_name => 'PA_PAGE_NAME_EXISTS');
354: --x_return_status := FND_API.G_RET_STS_ERROR;
355: --END IF;
356: END IF;
357:
358: IF (p_end_date IS NOT NULL AND p_end_date < p_start_date) THEN

Line 362: x_return_status := FND_API.G_RET_STS_ERROR;

358: IF (p_end_date IS NOT NULL AND p_end_date < p_start_date) THEN
359: PA_UTILS.Add_Message( p_app_short_name => 'PA'
360: ,p_msg_name => 'PA_EFFECTIVE_ED_DATE_INV');
361:
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: END IF;
364:
365:
366: -- check the page type is not null

Line 367: -- IF (p_page_type IS NULL OR p_page_type = FND_API.g_miss_char)THEN

363: END IF;
364:
365:
366: -- check the page type is not null
367: -- IF (p_page_type IS NULL OR p_page_type = FND_API.g_miss_char)THEN
368: -- PA_UTILS.Add_Message( p_app_short_name => 'PA'
369: -- ,p_msg_name => 'PA_PAGE_TYPE_INV');
370: --x_return_status := FND_API.G_RET_STS_ERROR;
371: --END IF;

Line 370: --x_return_status := FND_API.G_RET_STS_ERROR;

366: -- check the page type is not null
367: -- IF (p_page_type IS NULL OR p_page_type = FND_API.g_miss_char)THEN
368: -- PA_UTILS.Add_Message( p_app_short_name => 'PA'
369: -- ,p_msg_name => 'PA_PAGE_TYPE_INV');
370: --x_return_status := FND_API.G_RET_STS_ERROR;
371: --END IF;
372:
373: IF x_return_status = FND_API.g_ret_sts_success then
374: -- check the record version number

Line 373: IF x_return_status = FND_API.g_ret_sts_success then

369: -- ,p_msg_name => 'PA_PAGE_TYPE_INV');
370: --x_return_status := FND_API.G_RET_STS_ERROR;
371: --END IF;
372:
373: IF x_return_status = FND_API.g_ret_sts_success then
374: -- check the record version number
375: OPEN check_record_version;
376:
377: FETCH check_record_version INTO l_page_layout_row_id;

Line 384: x_return_status := FND_API.G_RET_STS_ERROR;

380: CLOSE check_record_version;
381: PA_UTILS.Add_Message( p_app_short_name => 'PA'
382: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
383:
384: x_return_status := FND_API.G_RET_STS_ERROR;
385:
386: ELSE
387: CLOSE check_record_version;
388: pa_page_layout_pkg.Update_page_layout_Row

Line 408: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.g_ret_sts_success) THEN

404:
405: END IF;
406:
407: -- Commit if the flag is set and there is no error
408: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.g_ret_sts_success) THEN
409: COMMIT;
410: END IF;
411:
412: -- Reset the error stack when returning to the calling program

Line 418: IF p_commit = FND_API.G_TRUE THEN

414:
415:
416: EXCEPTION
417: WHEN OTHERS THEN
418: IF p_commit = FND_API.G_TRUE THEN
419: ROLLBACK TO PAGE_LAYOUT_PVT_UPDATE;
420: END IF;
421: --
422: -- Set the excetption Message and the stack

Line 426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

422: -- Set the excetption Message and the stack
423: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_LAYOUT_PVT.Update_Page_Layout'
424: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
425: --
426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
427: RAISE; -- This is optional depending on the needs
428:
429: END update_page_layout;
430:

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

432:
433: PROCEDURE Delete_Page_Layout
434: (
435: p_api_version IN NUMBER := 1.0,
436: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
437: p_commit IN VARCHAR2 := FND_API.g_false,
438: p_validate_only IN VARCHAR2 := FND_API.g_true,
439: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
440:

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

433: PROCEDURE Delete_Page_Layout
434: (
435: p_api_version IN NUMBER := 1.0,
436: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
437: p_commit IN VARCHAR2 := FND_API.g_false,
438: p_validate_only IN VARCHAR2 := FND_API.g_true,
439: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
440:
441: p_page_id IN number,

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

434: (
435: p_api_version IN NUMBER := 1.0,
436: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
437: p_commit IN VARCHAR2 := FND_API.g_false,
438: p_validate_only IN VARCHAR2 := FND_API.g_true,
439: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
440:
441: p_page_id IN number,
442: p_record_version_number IN NUMBER ,

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

435: p_api_version IN NUMBER := 1.0,
436: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
437: p_commit IN VARCHAR2 := FND_API.g_false,
438: p_validate_only IN VARCHAR2 := FND_API.g_true,
439: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
440:
441: p_page_id IN number,
442: p_record_version_number IN NUMBER ,
443:

Line 482: x_return_status := FND_API.G_RET_STS_SUCCESS;

478: -- Initialize the Error Stack
479: PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_PVT.Delete_Page_Layout');
480:
481:
482: x_return_status := FND_API.G_RET_STS_SUCCESS;
483:
484: -- Issue API savepoint if the transaction is to be committed
485: IF p_commit = FND_API.G_TRUE THEN
486: SAVEPOINT PAGE_LAYOUT_PVT_DELETE;

Line 485: IF p_commit = FND_API.G_TRUE THEN

481:
482: x_return_status := FND_API.G_RET_STS_SUCCESS;
483:
484: -- Issue API savepoint if the transaction is to be committed
485: IF p_commit = FND_API.G_TRUE THEN
486: SAVEPOINT PAGE_LAYOUT_PVT_DELETE;
487: END IF;
488:
489: --debug_msg('before delete');

Line 506: x_return_status := FND_API.G_RET_STS_ERROR;

502: CLOSE check_page_layout;
503:
504: PA_UTILS.Add_Message( p_app_short_name => 'PA'
505: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
506: x_return_status := FND_API.G_RET_STS_ERROR;
507:
508: ELSE
509:
510: --debug_msg('before delete3');

Line 522: IF (p_validate_only = FND_API.g_false) THEN

518: IF check_object_page_versions%NOTFOUND THEN
519: -- we can delete if this page is not used yet
520: CLOSE check_object_page_versions;
521:
522: IF (p_validate_only = FND_API.g_false) THEN
523:
524:
525: --debug_msg('before delete 4');
526: PA_PAGE_LAYOUT_PKG.Delete_page_layout_Row

Line 536: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

532: ,x_msg_data => x_msg_data
533: );
534: END IF;
535:
536: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
537:
538: -- DELETE FROM pa_object_page_layouts
539: -- WHERE page_id = p_page_id;
540:

Line 562: x_return_status := FND_API.G_RET_STS_ERROR;

558: PA_UTILS.Add_Message( p_app_short_name => 'PA'
559: ,p_msg_name => 'PA_PAGE_IN_USE'
560: , p_token1 => 'TEMPLATE_TYPE'
561: , p_value1 => l_type);
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: ELSE
564: PA_PAGE_LAYOUT_PKG.Delete_page_layout_Row
565: (
566: p_page_id => p_page_id

Line 586: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

582:
583:
584:
585: -- Commit if the flag is set and there is no error
586: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
587: COMMIT;
588: END IF;
589:
590: -- Reset the error stack when returning to the calling program

Line 596: IF p_commit = FND_API.G_TRUE THEN

592:
593:
594: EXCEPTION
595: WHEN OTHERS THEN
596: IF p_commit = FND_API.G_TRUE THEN
597: ROLLBACK TO PAGE_LAYOUT_PVT_DELETE;
598: END IF;
599:
600: -- Set the excetption Message and the stack

Line 604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

608:
609:
610: procedure ADD_PAGE_REGION (
611: p_api_version IN NUMBER := 1.0,
612: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
613: p_commit IN VARCHAR2 := FND_API.g_false,
614: p_validate_only IN VARCHAR2 := FND_API.g_true,
615: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
616: P_PAGE_ID in NUMBER,

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

609:
610: procedure ADD_PAGE_REGION (
611: p_api_version IN NUMBER := 1.0,
612: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
613: p_commit IN VARCHAR2 := FND_API.g_false,
614: p_validate_only IN VARCHAR2 := FND_API.g_true,
615: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
616: P_PAGE_ID in NUMBER,
617: P_REGION_SOURCE_TYPE in VARCHAR2,

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

610: procedure ADD_PAGE_REGION (
611: p_api_version IN NUMBER := 1.0,
612: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
613: p_commit IN VARCHAR2 := FND_API.g_false,
614: p_validate_only IN VARCHAR2 := FND_API.g_true,
615: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
616: P_PAGE_ID in NUMBER,
617: P_REGION_SOURCE_TYPE in VARCHAR2,
618: P_REGION_SOURCE_CODE in VARCHAR2,

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

611: p_api_version IN NUMBER := 1.0,
612: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
613: p_commit IN VARCHAR2 := FND_API.g_false,
614: p_validate_only IN VARCHAR2 := FND_API.g_true,
615: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
616: P_PAGE_ID in NUMBER,
617: P_REGION_SOURCE_TYPE in VARCHAR2,
618: P_REGION_SOURCE_CODE in VARCHAR2,
619: P_VIEW_REGION_CODE in VARCHAR2,

Line 655: x_return_status := FND_API.G_RET_STS_SUCCESS;

651: -- Initialize the Error Stack
652: PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_PVT.Add_Page_Region');
653:
654: -- Initialize the return status to success
655: x_return_status := FND_API.G_RET_STS_SUCCESS;
656:
657: -- Issue API savepoint if the transaction is to be committed
658: IF p_commit = FND_API.G_TRUE THEN
659: SAVEPOINT PVT_ADD_PAGE_REGION;

Line 658: IF p_commit = FND_API.G_TRUE THEN

654: -- Initialize the return status to success
655: x_return_status := FND_API.G_RET_STS_SUCCESS;
656:
657: -- Issue API savepoint if the transaction is to be committed
658: IF p_commit = FND_API.G_TRUE THEN
659: SAVEPOINT PVT_ADD_PAGE_REGION;
660: END IF;
661:
662: -- check the mandatory page_id

Line 668: x_return_status := FND_API.G_RET_STS_ERROR;

664: PA_UTILS.Add_Message( p_app_short_name => 'PA'
665: ,p_msg_name => 'PA_PAGE_ID_INV'
666: , p_token1 => 'TEMPLATE_TYPE'
667: , p_value1 => l_type);
668: x_return_status := FND_API.G_RET_STS_ERROR;
669: END IF;
670:
671: IF (p_region_source_code IS null) then
672: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 676: x_return_status := FND_API.G_RET_STS_ERROR;

672: PA_UTILS.Add_Message( p_app_short_name => 'PA'
673: ,p_msg_name => 'PA_REGION_CODE_INV'
674: , p_token1 => 'TEMPLATE_TYPE'
675: , p_value1 => l_type);
676: x_return_status := FND_API.G_RET_STS_ERROR;
677: END IF;
678:
679: IF (p_edit_region_code IS NULL OR p_view_region_code IS NULL) THEN
680:

Line 688: x_return_status := FND_API.G_RET_STS_ERROR;

684: /*
685: IF (get_edit_region_code%notfound ) THEN
686: PA_UTILS.Add_Message( p_app_short_name => 'PA'
687: ,p_msg_name => 'PA_REGION_REF_INV');
688: x_return_status := FND_API.G_RET_STS_ERROR;
689:
690: ELSE
691:
692: NULL;

Line 705: x_return_status := FND_API.G_RET_STS_ERROR;

701:
702: IF (p_display_order IS NULL) then
703: PA_UTILS.Add_Message( p_app_short_name => 'PA'
704: ,p_msg_name => 'PA_DISPLAY_ORDER_INV');
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: END IF;
707:
708:
709: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then

Line 709: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then

705: x_return_status := FND_API.G_RET_STS_ERROR;
706: END IF;
707:
708:
709: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then
710:
711: pa_page_layout_pkg.Insert_page_region_Row
712: (
713: p_page_id => p_page_id,

Line 727: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.g_ret_sts_success )THEN

723: );
724:
725:
726: -- Commit if the flag is set and there is no error
727: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.g_ret_sts_success )THEN
728: COMMIT;
729: END IF;
730:
731: END IF;

Line 739: IF p_commit = FND_API.G_TRUE THEN

735:
736:
737: EXCEPTION
738: WHEN OTHERS THEN
739: IF p_commit = FND_API.G_TRUE THEN
740: ROLLBACK TO PVT_ADD_PAGE_REGION;
741: END IF;
742: --
743: -- Set the excetption Message and the stack

Line 747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

743: -- Set the excetption Message and the stack
744: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_LAYOUT_PVT.Add_Page_Region'
745: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
746: --
747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
748: RAISE; -- This is option
749:
750: END add_page_region;
751:

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

752:
753: PROCEDURE Delete_Page_Region
754: (
755: p_api_version IN NUMBER := 1.0,
756: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
757: p_commit IN VARCHAR2 := FND_API.g_false,
758: p_validate_only IN VARCHAR2 := FND_API.g_true,
759: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
760:

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

753: PROCEDURE Delete_Page_Region
754: (
755: p_api_version IN NUMBER := 1.0,
756: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
757: p_commit IN VARCHAR2 := FND_API.g_false,
758: p_validate_only IN VARCHAR2 := FND_API.g_true,
759: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
760:
761: p_page_id IN number,

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

754: (
755: p_api_version IN NUMBER := 1.0,
756: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
757: p_commit IN VARCHAR2 := FND_API.g_false,
758: p_validate_only IN VARCHAR2 := FND_API.g_true,
759: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
760:
761: p_page_id IN number,
762: p_region_source_type IN VARCHAR2,

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

755: p_api_version IN NUMBER := 1.0,
756: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
757: p_commit IN VARCHAR2 := FND_API.g_false,
758: p_validate_only IN VARCHAR2 := FND_API.g_true,
759: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
760:
761: p_page_id IN number,
762: p_region_source_type IN VARCHAR2,
763: p_region_source_code IN VARCHAR2,

Line 788: x_return_status := FND_API.G_RET_STS_SUCCESS;

784: -- Initialize the Error Stack
785: PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_PVT.Delete_Page_Region');
786:
787:
788: x_return_status := FND_API.G_RET_STS_SUCCESS;
789:
790: -- Issue API savepoint if the transaction is to be committed
791: IF p_commit = FND_API.G_TRUE THEN
792: SAVEPOINT PVT_DELETE_PAGE_REGION;

Line 791: IF p_commit = FND_API.G_TRUE THEN

787:
788: x_return_status := FND_API.G_RET_STS_SUCCESS;
789:
790: -- Issue API savepoint if the transaction is to be committed
791: IF p_commit = FND_API.G_TRUE THEN
792: SAVEPOINT PVT_DELETE_PAGE_REGION;
793: END IF;
794:
795:

Line 806: x_return_status := FND_API.G_RET_STS_ERROR;

802: CLOSE check_page_region;
803:
804: PA_UTILS.Add_Message( p_app_short_name => 'PA'
805: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
806: x_return_status := FND_API.G_RET_STS_ERROR;
807:
808: ELSE
809:
810: CLOSE check_page_region;

Line 812: IF (p_validate_only = FND_API.g_false) THEN

808: ELSE
809:
810: CLOSE check_page_region;
811:
812: IF (p_validate_only = FND_API.g_false) THEN
813:
814:
815: PA_PAGE_LAYOUT_PKG.Delete_page_region_Row
816: (

Line 831: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

827: END IF;
828:
829:
830: -- Commit if the flag is set and there is no error
831: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
832: COMMIT;
833: END IF;
834:
835: -- Reset the error stack when returning to the calling program

Line 841: IF p_commit = FND_API.G_TRUE THEN

837:
838:
839: EXCEPTION
840: WHEN OTHERS THEN
841: IF p_commit = FND_API.G_TRUE THEN
842: ROLLBACK TO PVT_DELETE_PAGE_REGION;
843: END IF;
844:
845: -- Set the excetption Message and the stack

Line 849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

845: -- Set the excetption Message and the stack
846: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PAGE_LAYOUT_PVT.Delete_Page_Region'
847: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
848: --
849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
850: RAISE; -- This is optional depending on the needs
851:
852: END delete_page_region;
853:

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

854:
855: PROCEDURE Delete_All_Page_Region
856: (
857: p_api_version IN NUMBER := 1.0,
858: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
859: p_commit IN VARCHAR2 := FND_API.g_false,
860: p_validate_only IN VARCHAR2 := FND_API.g_true,
861: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
862:

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

855: PROCEDURE Delete_All_Page_Region
856: (
857: p_api_version IN NUMBER := 1.0,
858: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
859: p_commit IN VARCHAR2 := FND_API.g_false,
860: p_validate_only IN VARCHAR2 := FND_API.g_true,
861: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
862:
863: p_page_id IN NUMBER := null,

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

856: (
857: p_api_version IN NUMBER := 1.0,
858: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
859: p_commit IN VARCHAR2 := FND_API.g_false,
860: p_validate_only IN VARCHAR2 := FND_API.g_true,
861: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
862:
863: p_page_id IN NUMBER := null,
864: p_region_position IN VARCHAR2 := null,

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

857: p_api_version IN NUMBER := 1.0,
858: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
859: p_commit IN VARCHAR2 := FND_API.g_false,
860: p_validate_only IN VARCHAR2 := FND_API.g_true,
861: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
862:
863: p_page_id IN NUMBER := null,
864: p_region_position IN VARCHAR2 := null,
865:

Line 895: x_return_status := FND_API.G_RET_STS_SUCCESS;

891: -- Initialize the Error Stack
892: PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_PUB.Delete_Page_Region');
893:
894: -- Initialize the return status to success
895: x_return_status := FND_API.G_RET_STS_SUCCESS;
896:
897: --Clear the global PL/SQL message table
898: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
899: FND_MSG_PUB.initialize;

Line 898: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

894: -- Initialize the return status to success
895: x_return_status := FND_API.G_RET_STS_SUCCESS;
896:
897: --Clear the global PL/SQL message table
898: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
899: FND_MSG_PUB.initialize;
900: END IF;
901:
902: FOR reg_rec IN get_region loop

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

919: -- stack and return its text
920: --
921: x_msg_count := FND_MSG_PUB.Count_Msg;
922: IF x_msg_count = 1 THEN
923: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
924: ,p_msg_index => 1
925: ,p_data => x_msg_data
926: ,p_msg_index_out => l_msg_index_out
927: );

Line 946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

942: -- Set the exception Message and the stack
943: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_LAYOUT_PUB.Delete_Page_Region'
944: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
945: --
946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
947: RAISE; -- This is optional depending on the needs
948: --
949:
950: END delete_all_page_region;

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

951:
952: PROCEDURE Delete_All_link_Page_Region
953: (
954: p_api_version IN NUMBER := 1.0,
955: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
956: p_commit IN VARCHAR2 := FND_API.g_false,
957: p_validate_only IN VARCHAR2 := FND_API.g_true,
958: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
959:

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

952: PROCEDURE Delete_All_link_Page_Region
953: (
954: p_api_version IN NUMBER := 1.0,
955: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
956: p_commit IN VARCHAR2 := FND_API.g_false,
957: p_validate_only IN VARCHAR2 := FND_API.g_true,
958: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
959:
960: p_page_id IN NUMBER := null,

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

953: (
954: p_api_version IN NUMBER := 1.0,
955: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
956: p_commit IN VARCHAR2 := FND_API.g_false,
957: p_validate_only IN VARCHAR2 := FND_API.g_true,
958: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
959:
960: p_page_id IN NUMBER := null,
961: p_region_position IN VARCHAR2 := null,

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

954: p_api_version IN NUMBER := 1.0,
955: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
956: p_commit IN VARCHAR2 := FND_API.g_false,
957: p_validate_only IN VARCHAR2 := FND_API.g_true,
958: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
959:
960: p_page_id IN NUMBER := null,
961: p_region_position IN VARCHAR2 := null,
962:

Line 986: x_return_status := FND_API.G_RET_STS_SUCCESS;

982: -- Initialize the Error Stack
983: PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_PUB.Delete_All_link_Page_Region');
984:
985: -- Initialize the return status to success
986: x_return_status := FND_API.G_RET_STS_SUCCESS;
987:
988: --Clear the global PL/SQL message table
989: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
990: FND_MSG_PUB.initialize;

Line 989: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

985: -- Initialize the return status to success
986: x_return_status := FND_API.G_RET_STS_SUCCESS;
987:
988: --Clear the global PL/SQL message table
989: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
990: FND_MSG_PUB.initialize;
991: END IF;
992:
993: FOR reg_rec IN get_region loop

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

1010: -- stack and return its text
1011: --
1012: x_msg_count := FND_MSG_PUB.Count_Msg;
1013: IF x_msg_count = 1 THEN
1014: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1015: ,p_msg_index => 1
1016: ,p_data => x_msg_data
1017: ,p_msg_index_out => l_msg_index_out
1018: );

Line 1037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1033: -- Set the exception Message and the stack
1034: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_LAYOUT_PUB.Delete_All_link_Page_Region'
1035: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1036: --
1037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1038: RAISE; -- This is optional depending on the needs
1039: --
1040:
1041: END delete_all_link_page_region;