APPS.PA_REPORT_TYPES_PUB dependencies on PA_UTILS

Line 47: PA_UTILS.Add_Message( p_app_short_name => 'PA'

43: END IF;
44:
45: -- check the mandatory report_name
46: IF (p_name IS NULL) then
47: PA_UTILS.Add_Message( p_app_short_name => 'PA'
48: ,p_msg_name => 'PA_REPORT_NAME_INV');
49: x_return_status := 'E';
50: else
51: begin

Line 60: PA_UTILS.Add_Message( p_app_short_name => 'PA'

56: exception when no_data_found then
57: null;
58: end;
59: if l_dummy = 'Y' then
60: PA_UTILS.Add_Message( p_app_short_name => 'PA'
61: ,p_msg_name => 'PA_REPORT_NAME_DUPLICATE');
62: x_return_status := 'E';
63: end if;
64: End if;

Line 69: PA_UTILS.Add_Message( p_app_short_name => 'PA'

65:
66: -- check the page id is not null
67: IF (p_page_id IS NULL)THEN
68: If (p_page_layout is null or p_page_layout = '^') then
69: PA_UTILS.Add_Message( p_app_short_name => 'PA'
70: ,p_msg_name => 'PA_PAGE_LAYOUT_NAME_INV');
71: x_return_status := 'E';
72: else
73: --- get page_id from page layout

Line 87: PA_UTILS.Add_Message( p_app_short_name => 'PA'

83: End If;
84:
85: -- check the end date and start date
86: IF (p_end_date_active IS NOT NULL AND p_end_date_active < p_start_date_active) THEN
87: PA_UTILS.Add_Message( p_app_short_name => 'PA'
88: ,p_msg_name => 'PA_EFFECTIVE_ED_DATE_INV');
89: x_return_status := 'E';
90: End If;
91:

Line 206: PA_UTILS.Add_Message( p_app_short_name => 'PA'

202: null;
203: end;
204:
205: if (l_created_by = 1) then
206: PA_UTILS.Add_Message( p_app_short_name => 'PA'
207: ,p_msg_name => 'PA_REPORT_TYPE_SEED');
208: x_return_status := 'E';
209: return;
210: end if; */

Line 214: PA_UTILS.Add_Message( p_app_short_name => 'PA'

210: end if; */
211:
212: -- check the mandatory report_name
213: IF (p_name IS NULL or p_name = '^') then
214: PA_UTILS.Add_Message( p_app_short_name => 'PA'
215: ,p_msg_name => 'PA_REPORT_NAME_INV');
216: x_return_status := 'E';
217: else
218: begin

Line 228: PA_UTILS.Add_Message( p_app_short_name => 'PA'

224: exception when no_data_found then
225: null;
226: end;
227: if l_dummy = 'Y' then
228: PA_UTILS.Add_Message( p_app_short_name => 'PA'
229: ,p_msg_name => 'PA_REPORT_NAME_DUPLICATE');
230: x_return_status := 'E';
231: end if;
232: End if;

Line 237: PA_UTILS.Add_Message( p_app_short_name => 'PA'

233:
234: -- check the page id is not null
235: IF (p_page_id IS NULL or p_page_id = -99)THEN
236: If (p_page_layout is null or p_page_layout = '^') then
237: PA_UTILS.Add_Message( p_app_short_name => 'PA'
238: ,p_msg_name => 'PA_PAGE_LAYOUT_NAME_INV');
239: x_return_status := 'E';
240: else
241: --- get page_id from page layout

Line 267: PA_UTILS.Add_Message( p_app_short_name => 'PA'

263: l_end_date_active := p_end_date_active;
264: end if;
265:
266: IF (l_end_date_active IS NOT NULL AND l_end_date_active < l_start_date_active) THEN
267: PA_UTILS.Add_Message( p_app_short_name => 'PA'
268: ,p_msg_name => 'PA_EFFECTIVE_ED_DATE_INV');
269: x_return_status := 'E';
270: End If;
271:

Line 373: PA_UTILS.Add_Message( p_app_short_name => 'PA'

369: null;
370: end;
371:
372: if (l_created_by = 1) then
373: PA_UTILS.Add_Message( p_app_short_name => 'PA'
374: ,p_msg_name => 'PA_REPORT_TYPE_SEED');
375: x_return_status := 'E';
376: return;
377: end if;

Line 390: PA_UTILS.Add_Message( p_app_short_name => 'PA'

386: when too_many_rows then
387: l_dummy := 'Y';
388: end;
389: if (l_dummy = 'Y') then
390: PA_UTILS.Add_Message( p_app_short_name => 'PA'
391: ,p_msg_name => 'PA_REPORT_TYPE_IN_USE');
392: x_return_status := 'E';
393: else
394: if (p_validate_only <> 'T' and x_return_status = 'S') then