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

Line 59: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 62: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

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

Line 80: x_return_status := FND_API.G_RET_STS_ERROR;

76: PA_UTILS.Add_Message( p_app_short_name => 'PA'
77: ,p_msg_name => 'PA_UDS_SETUP_NAME_INV');
78:
79:
80: x_return_status := FND_API.G_RET_STS_ERROR;
81: END IF;
82:
83: -- check if the region_source_code is used already
84: open check_region_source_unique;

Line 91: x_return_status := FND_API.G_RET_STS_ERROR;

87: PA_UTILS.Add_Message( p_app_short_name => 'PA'
88: ,p_msg_name => 'PA_UDS_SETUP_NAME_NOT_UNIQUE');
89:
90:
91: x_return_status := FND_API.G_RET_STS_ERROR;
92:
93: end if;
94:
95: close check_region_source_unique;

Line 107: x_return_status := FND_API.G_RET_STS_ERROR;

103: PA_UTILS.Add_Message( p_app_short_name => 'PA'
104: ,p_msg_name => 'PA_UDS_SETUP_NAME_NOT_UNIQUE');
105:
106:
107: x_return_status := FND_API.G_RET_STS_ERROR;
108:
109: end if;
110:
111: close check_region_source_unique;

Line 115: IF (p_view_region_code IS NULL AND x_return_status = FND_API.g_ret_sts_success )THEN

111: close check_region_source_unique;
112:
113: END IF;
114:
115: IF (p_view_region_code IS NULL AND x_return_status = FND_API.g_ret_sts_success )THEN
116: l_view_region_code := pa_page_layout_utils.get_ak_region_code(p_view_region_name, 275);
117:
118: IF l_view_region_code IS NULL THEN
119: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 123: x_return_status := FND_API.G_RET_STS_ERROR;

119: PA_UTILS.Add_Message( p_app_short_name => 'PA'
120: ,p_msg_name => 'PA_UDS_SETUP_STYLE_INV'
121: );
122:
123: x_return_status := FND_API.G_RET_STS_ERROR;
124: END IF;
125:
126: ELSE
127: l_view_region_code := p_view_region_code;

Line 130: IF (p_edit_region_code IS NULL AND x_return_status = FND_API.g_ret_sts_success )THEN

126: ELSE
127: l_view_region_code := p_view_region_code;
128: END IF;
129:
130: IF (p_edit_region_code IS NULL AND x_return_status = FND_API.g_ret_sts_success )THEN
131: l_edit_region_code := pa_page_layout_utils.get_ak_region_code(p_edit_region_name, 275);
132:
133: IF l_edit_region_code IS NULL THEN
134: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 138: x_return_status := FND_API.G_RET_STS_ERROR;

134: PA_UTILS.Add_Message( p_app_short_name => 'PA'
135: ,p_msg_name => 'PA_UDS_SETUP_STYLE_INV'
136: );
137:
138: x_return_status := FND_API.G_RET_STS_ERROR;
139: END IF;
140:
141: ELSE
142: l_edit_region_code := p_edit_region_code;

Line 145: IF (x_return_status = FND_API.g_ret_sts_success ) THEN

141: ELSE
142: l_edit_region_code := p_edit_region_code;
143: END IF;
144:
145: IF (x_return_status = FND_API.g_ret_sts_success ) THEN
146:
147: pa_page_type_region_pvt.Create_Page_Type_Region
148: (
149: p_api_version => p_api_version,

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

180: --
181:
182: x_msg_count := FND_MSG_PUB.Count_Msg;
183: IF x_msg_count = 1 THEN
184: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
185: ,p_msg_index => 1
186: ,p_data => x_msg_data
187: ,p_msg_index_out => l_msg_index_out
188: );

Line 205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 256: x_return_status := FND_API.G_RET_STS_SUCCESS;

252: -- Initialize the Error Stack
253: PA_DEBUG.init_err_stack('PA_PAGE_TYPE_REGION_PUB.Update_Page_Type_Region');
254:
255: -- Initialize the return status to success
256: x_return_status := FND_API.G_RET_STS_SUCCESS;
257:
258: --Clear the global PL/SQL message table
259: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
260: FND_MSG_PUB.initialize;

Line 259: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

255: -- Initialize the return status to success
256: x_return_status := FND_API.G_RET_STS_SUCCESS;
257:
258: --Clear the global PL/SQL message table
259: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
260: FND_MSG_PUB.initialize;
261: END IF;
262:
263: IF (p_region_source_code IS NULL AND x_return_status = FND_API.g_ret_sts_success )THEN

Line 263: IF (p_region_source_code IS NULL AND x_return_status = FND_API.g_ret_sts_success )THEN

259: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
260: FND_MSG_PUB.initialize;
261: END IF;
262:
263: IF (p_region_source_code IS NULL AND x_return_status = FND_API.g_ret_sts_success )THEN
264: l_region_source_code := pa_page_layout_utils.get_region_source_code(p_region_source_name, P_REGION_SOURCE_TYPE, 275, 'PA_STATUS_REPORT_DESC_FLEX');
265:
266: IF l_region_source_code IS NULL THEN
267: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 271: x_return_status := FND_API.G_RET_STS_ERROR;

267: PA_UTILS.Add_Message( p_app_short_name => 'PA'
268: ,p_msg_name => 'PA_UDS_SETUP_NAME_INV'
269: );
270:
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: END IF;
273: ELSE
274: l_region_source_code := p_region_source_code;
275: END IF;

Line 277: IF (p_view_region_code IS NULL AND x_return_status = FND_API.g_ret_sts_success )THEN

273: ELSE
274: l_region_source_code := p_region_source_code;
275: END IF;
276:
277: IF (p_view_region_code IS NULL AND x_return_status = FND_API.g_ret_sts_success )THEN
278: l_view_region_code := pa_page_layout_utils.get_ak_region_code(p_view_region_name, 275);
279:
280: IF l_view_region_code IS NULL THEN
281: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 285: x_return_status := FND_API.G_RET_STS_ERROR;

281: PA_UTILS.Add_Message( p_app_short_name => 'PA'
282: ,p_msg_name => 'PA_UDS_SETUP_STYLE_INV'
283: );
284:
285: x_return_status := FND_API.G_RET_STS_ERROR;
286: END IF;
287:
288: ELSE
289: l_view_region_code := p_view_region_code;

Line 292: IF (p_edit_region_code IS NULL AND x_return_status = FND_API.g_ret_sts_success )THEN

288: ELSE
289: l_view_region_code := p_view_region_code;
290: END IF;
291:
292: IF (p_edit_region_code IS NULL AND x_return_status = FND_API.g_ret_sts_success )THEN
293: l_edit_region_code := pa_page_layout_utils.get_ak_region_code(p_edit_region_name, 275);
294:
295: IF l_edit_region_code IS NULL THEN
296: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 300: x_return_status := FND_API.G_RET_STS_ERROR;

296: PA_UTILS.Add_Message( p_app_short_name => 'PA'
297: ,p_msg_name => 'PA_UDS_SETUP_STYLE_INV'
298: );
299:
300: x_return_status := FND_API.G_RET_STS_ERROR;
301: END IF;
302:
303: ELSE
304: l_edit_region_code := p_edit_region_code;

Line 307: IF (x_return_status = FND_API.g_ret_sts_success ) THEN

303: ELSE
304: l_edit_region_code := p_edit_region_code;
305: END IF;
306:
307: IF (x_return_status = FND_API.g_ret_sts_success ) THEN
308:
309: pa_page_type_region_pvt.Update_Page_Type_Region
310: (
311: p_api_version => p_api_version,

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

345: -- stack and return its text
346: --
347: x_msg_count := FND_MSG_PUB.Count_Msg;
348: IF x_msg_count = 1 THEN
349: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
350: ,p_msg_index => 1
351: ,p_data => x_msg_data
352: ,p_msg_index_out => l_msg_index_out
353: );

Line 369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

365: -- Set the exception Message and the stack
366: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_TYPE_REGION_PUB.Update_Page_Type_Region'
367: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
368: --
369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
370: RAISE; -- This is optional depending on the needs
371: --
372:
373: END update_page_type_region;

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

376:
377: PROCEDURE Delete_Page_Type_Region
378: (
379: p_api_version IN NUMBER := 1.0,
380: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
381: p_commit IN VARCHAR2 := FND_API.g_false,
382: p_validate_only IN VARCHAR2 := FND_API.g_true,
383: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
384:

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

377: PROCEDURE Delete_Page_Type_Region
378: (
379: p_api_version IN NUMBER := 1.0,
380: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
381: p_commit IN VARCHAR2 := FND_API.g_false,
382: p_validate_only IN VARCHAR2 := FND_API.g_true,
383: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
384:
385: p_rowid IN VARCHAR2 := NULL,

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

378: (
379: p_api_version IN NUMBER := 1.0,
380: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
381: p_commit IN VARCHAR2 := FND_API.g_false,
382: p_validate_only IN VARCHAR2 := FND_API.g_true,
383: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
384:
385: p_rowid IN VARCHAR2 := NULL,
386: P_PAGE_TYPE_CODE in VARCHAR2 := NULL,

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

379: p_api_version IN NUMBER := 1.0,
380: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
381: p_commit IN VARCHAR2 := FND_API.g_false,
382: p_validate_only IN VARCHAR2 := FND_API.g_true,
383: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
384:
385: p_rowid IN VARCHAR2 := NULL,
386: P_PAGE_TYPE_CODE in VARCHAR2 := NULL,
387: P_REGION_SOURCE_TYPE in VARCHAR2 := NULL,

Line 402: x_return_status := FND_API.G_RET_STS_SUCCESS;

398:
399: -- Initialize the Error Stack
400: PA_DEBUG.init_err_stack('PA_PAGE_TYPE_REGION_PUB.Delete_Page_Type_Region');
401:
402: x_return_status := FND_API.G_RET_STS_SUCCESS;
403:
404: --Clear the global PL/SQL message table
405: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
406: FND_MSG_PUB.initialize;

Line 405: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

401:
402: x_return_status := FND_API.G_RET_STS_SUCCESS;
403:
404: --Clear the global PL/SQL message table
405: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
406: FND_MSG_PUB.initialize;
407: END IF;
408:
409:

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

430: -- stack and return its text
431: --
432: x_msg_count := FND_MSG_PUB.Count_Msg;
433: IF x_msg_count = 1 THEN
434: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
435: ,p_msg_index => 1
436: ,p_data => x_msg_data
437: ,p_msg_index_out => l_msg_index_out
438: );

Line 455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

451: -- Set the excetption Message and the stack
452: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PAGE_TYPE_REGION_PUB.Delete_Page_Type_Region'
453: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
454: --
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
456: RAISE; -- This is optional depending on the needs
457:
458: END delete_page_type_region;
459: