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

Line 46: x_return_status := FND_API.G_RET_STS_SUCCESS;

42: -- Initialize the Error Stack
43: PA_DEBUG.init_err_stack('PA_PAGE_TYPE_REGION_PVT.Create_Page_Type_Region');
44:
45: -- Initialize the return status to success
46: x_return_status := FND_API.G_RET_STS_SUCCESS;
47:
48: -- Issue API savepoint if the transaction is to be committed
49: IF p_commit = FND_API.G_TRUE THEN
50: SAVEPOINT PAGE_TYPE_REGION_PVT_CREATE;

Line 49: IF p_commit = FND_API.G_TRUE THEN

45: -- Initialize the return status to success
46: x_return_status := FND_API.G_RET_STS_SUCCESS;
47:
48: -- Issue API savepoint if the transaction is to be committed
49: IF p_commit = FND_API.G_TRUE THEN
50: SAVEPOINT PAGE_TYPE_REGION_PVT_CREATE;
51: END IF;
52:
53: OPEN get_template_type;

Line 60: IF (p_page_type_code IS NULL OR p_page_type_code = FND_API.g_miss_char)THEN

56:
57:
58:
59: -- check the page type is not null
60: IF (p_page_type_code IS NULL OR p_page_type_code = FND_API.g_miss_char)THEN
61: PA_UTILS.Add_Message( p_app_short_name => 'PA'
62: ,p_msg_name => 'PA_PAGE_TYPE_INV'
63: , p_token1 => 'TEMPLATE_TYPE'
64: , p_value1 => l_type);

Line 65: x_return_status := FND_API.G_RET_STS_ERROR;

61: PA_UTILS.Add_Message( p_app_short_name => 'PA'
62: ,p_msg_name => 'PA_PAGE_TYPE_INV'
63: , p_token1 => 'TEMPLATE_TYPE'
64: , p_value1 => l_type);
65: x_return_status := FND_API.G_RET_STS_ERROR;
66: END IF;
67:
68: -- check the end date and start date
69: IF (p_end_date_active IS NOT NULL AND p_end_date_active < p_start_date_active) THEN

Line 73: x_return_status := FND_API.G_RET_STS_ERROR;

69: IF (p_end_date_active IS NOT NULL AND p_end_date_active < p_start_date_active) THEN
70: PA_UTILS.Add_Message( p_app_short_name => 'PA'
71: ,p_msg_name => 'PA_EFFECTIVE_ED_DATE_INV');
72:
73: x_return_status := FND_API.G_RET_STS_ERROR;
74: END IF;
75:
76:
77: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then

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

73: x_return_status := FND_API.G_RET_STS_ERROR;
74: END IF;
75:
76:
77: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then
78:
79: pa_page_type_region_pkg.Insert_page_type_region_Row
80: (
81: p_page_type_code => p_page_type_code,

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

99: END IF;
100:
101:
102: -- Commit if the flag is set and there is no error
103: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.g_ret_sts_success )THEN
104: COMMIT;
105: END IF;
106:
107: -- Reset the error stack when returning to the calling program

Line 113: IF p_commit = FND_API.G_TRUE THEN

109:
110:
111: EXCEPTION
112: WHEN OTHERS THEN
113: IF p_commit = FND_API.G_TRUE THEN
114: ROLLBACK TO PAGE_TYPE_REGION_PVT_CREATE;
115: END IF;
116: --
117: -- Set the excetption Message and the stack

Line 121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

117: -- Set the excetption Message and the stack
118: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_TYPE_REGION_PVT.Create_Page_Type_Region'
119: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
120: --
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
122: RAISE; -- This is optional depending on the needs
123:
124: END create_page_type_region;
125:

Line 164: x_return_status := FND_API.G_RET_STS_SUCCESS;

160: -- Initialize the Error Stack
161: PA_DEBUG.init_err_stack('PA_PAGE_TYPE_REGION_PVT.Update_Page_Type_Region');
162:
163: -- Initialize the return status to success
164: x_return_status := FND_API.G_RET_STS_SUCCESS;
165:
166: -- Issue API savepoint if the transaction is to be committed
167: IF p_commit = FND_API.G_TRUE THEN
168: SAVEPOINT page_type_REGION_PVT_UPDATE;

Line 167: IF p_commit = FND_API.G_TRUE THEN

163: -- Initialize the return status to success
164: x_return_status := FND_API.G_RET_STS_SUCCESS;
165:
166: -- Issue API savepoint if the transaction is to be committed
167: IF p_commit = FND_API.G_TRUE THEN
168: SAVEPOINT page_type_REGION_PVT_UPDATE;
169: END IF;
170:
171:

Line 176: x_return_status := FND_API.G_RET_STS_ERROR;

172: IF (p_end_date_active IS NOT NULL AND p_end_date_active < p_start_date_active) THEN
173: PA_UTILS.Add_Message( p_app_short_name => 'PA'
174: ,p_msg_name => 'PA_EFFECTIVE_ED_DATE_INV');
175:
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: END IF;
178:
179:
180: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then

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

176: x_return_status := FND_API.G_RET_STS_ERROR;
177: END IF;
178:
179:
180: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then
181:
182: pa_page_type_region_pkg.Update_page_type_region_Row
183: (
184: p_page_type_code => p_page_type_code,

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

201:
202: END IF;
203:
204: -- Commit if the flag is set and there is no error
205: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.g_ret_sts_success) THEN
206: COMMIT;
207: END IF;
208:
209: -- Reset the error stack when returning to the calling program

Line 217: x_return_status := FND_API.G_RET_STS_ERROR;

213: EXCEPTION
214: WHEN NO_DATA_FOUND then
215: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
216: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
217: x_return_status := FND_API.G_RET_STS_ERROR;
218: IF p_commit = FND_API.G_TRUE THEN
219: ROLLBACK TO PAGE_TYPE_REGION_PVT_UPDATE;
220: END IF;
221: --RAISE;

Line 218: IF p_commit = FND_API.G_TRUE THEN

214: WHEN NO_DATA_FOUND then
215: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
216: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
217: x_return_status := FND_API.G_RET_STS_ERROR;
218: IF p_commit = FND_API.G_TRUE THEN
219: ROLLBACK TO PAGE_TYPE_REGION_PVT_UPDATE;
220: END IF;
221: --RAISE;
222: WHEN OTHERS THEN

Line 223: IF p_commit = FND_API.G_TRUE THEN

219: ROLLBACK TO PAGE_TYPE_REGION_PVT_UPDATE;
220: END IF;
221: --RAISE;
222: WHEN OTHERS THEN
223: IF p_commit = FND_API.G_TRUE THEN
224: ROLLBACK TO PAGE_TYPE_REGION_PVT_UPDATE;
225: END IF;
226: --
227: -- Set the excetption Message and the stack

Line 231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

227: -- Set the excetption Message and the stack
228: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_TYPE_REGION_PVT.Update_Page_Type_Region'
229: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
230: --
231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
232: RAISE; -- This is optional depending on the needs
233:
234: END update_page_type_region;
235:

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

237:
238: PROCEDURE Delete_Page_Type_Region
239: (
240: p_api_version IN NUMBER := 1.0,
241: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
242: p_commit IN VARCHAR2 := FND_API.g_false,
243: p_validate_only IN VARCHAR2 := FND_API.g_true,
244: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
245:

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

238: PROCEDURE Delete_Page_Type_Region
239: (
240: p_api_version IN NUMBER := 1.0,
241: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
242: p_commit IN VARCHAR2 := FND_API.g_false,
243: p_validate_only IN VARCHAR2 := FND_API.g_true,
244: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
245:
246: p_rowid IN VARCHAR2 := NULL,

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

239: (
240: p_api_version IN NUMBER := 1.0,
241: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
242: p_commit IN VARCHAR2 := FND_API.g_false,
243: p_validate_only IN VARCHAR2 := FND_API.g_true,
244: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
245:
246: p_rowid IN VARCHAR2 := NULL,
247: P_PAGE_TYPE_CODE in VARCHAR2 := NULL,

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

240: p_api_version IN NUMBER := 1.0,
241: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
242: p_commit IN VARCHAR2 := FND_API.g_false,
243: p_validate_only IN VARCHAR2 := FND_API.g_true,
244: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
245:
246: p_rowid IN VARCHAR2 := NULL,
247: P_PAGE_TYPE_CODE in VARCHAR2 := NULL,
248: P_REGION_SOURCE_TYPE in VARCHAR2 := NULL,

Line 262: x_return_status := FND_API.G_RET_STS_SUCCESS;

258: -- Initialize the Error Stack
259: PA_DEBUG.init_err_stack('PA_PAGE_TYPE_REGION_PVT.Delete_Page_Type_Region');
260:
261:
262: x_return_status := FND_API.G_RET_STS_SUCCESS;
263:
264: -- Issue API savepoint if the transaction is to be committed
265: IF p_commit = FND_API.G_TRUE THEN
266: SAVEPOINT PAGE_TYPE_REGION_PVT_DELETE;

Line 265: IF p_commit = FND_API.G_TRUE THEN

261:
262: x_return_status := FND_API.G_RET_STS_SUCCESS;
263:
264: -- Issue API savepoint if the transaction is to be committed
265: IF p_commit = FND_API.G_TRUE THEN
266: SAVEPOINT PAGE_TYPE_REGION_PVT_DELETE;
267: END IF;
268:
269:

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

266: SAVEPOINT PAGE_TYPE_REGION_PVT_DELETE;
267: END IF;
268:
269:
270: IF (p_validate_only = FND_API.g_false) THEN
271: PA_PAGE_TYPE_REGION_PKG.Delete_page_type_region_Row
272: (
273: p_rowid => p_rowid,
274: p_page_type_code => p_page_type_code,

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

279:
280:
281:
282: -- Commit if the flag is set and there is no error
283: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
284: COMMIT;
285: END IF;
286:
287: -- Reset the error stack when returning to the calling program

Line 293: IF p_commit = FND_API.G_TRUE THEN

289:
290:
291: EXCEPTION
292: WHEN OTHERS THEN
293: IF p_commit = FND_API.G_TRUE THEN
294: ROLLBACK TO PAGE_TYPE_REGION_PVT_DELETE;
295: END IF;
296:
297: -- Set the excetption Message and the stack

Line 301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

297: -- Set the excetption Message and the stack
298: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PAGE_TYPE_REGION_PVT.Delete_Page_Type_Region'
299: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
300: --
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
302: RAISE; -- This is optional depending on the needs
303:
304: END delete_page_type_region;
305: