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_ROLE_LISTS_PVT dependencies on PA_ROLE_LISTS_PVT

Line 1: package body PA_ROLE_LISTS_PVT AS

1: package body PA_ROLE_LISTS_PVT AS
2: /* $Header: PARLTPVB.pls 120.1 2005/08/19 16:55:54 mwasowic noship $ */
3: ------------------------------------------------------------------------------
4: procedure INSERT_ROW (
5: P_ROWID in out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 37: PA_DEBUG.init_err_stack('PA_ROLE_LISTS_PVT.INSERT_ROW');

33: X_MSG_COUNT out NOCOPY NUMBER, --File.Sql.39 bug 4440895
34: X_MSG_DATA out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
35: ) is
36: begin
37: PA_DEBUG.init_err_stack('PA_ROLE_LISTS_PVT.INSERT_ROW');
38:
39: -- Check for duplicate row list names
40: PA_ROLE_UTILS.CHECK_DUP_ROLE_LIST_NAME(
41: p_name,

Line 83: p_pkg_name => 'PA_ROLE_LISTS_PVT',

79: PA_DEBUG.reset_err_stack;
80: else
81: X_MSG_COUNT := 1;
82: FND_MSG_PUB.add_exc_msg(
83: p_pkg_name => 'PA_ROLE_LISTS_PVT',
84: p_procedure_name => PA_DEBUG.G_err_stack,
85: p_error_text => X_MSG_DATA);
86: end if;
87:

Line 94: p_pkg_name => 'PA_ROLE_LISTS_PVT',

90: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
91: X_MSG_COUNT := 1;
92: X_MSG_DATA := substr(SQLERRM, 1, 240);
93: FND_MSG_PUB.add_exc_msg(
94: p_pkg_name => 'PA_ROLE_LISTS_PVT',
95: p_procedure_name => PA_DEBUG.G_err_stack,
96: p_error_text => X_MSG_DATA);
97: end;
98:

Line 108: PA_DEBUG.init_err_stack('PA_ROLE_LISTS_PVT.LOCK_ROW');

104: X_MSG_COUNT out NOCOPY NUMBER, --File.Sql.39 bug 4440895
105: X_MSG_DATA out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
106: ) is
107: begin
108: PA_DEBUG.init_err_stack('PA_ROLE_LISTS_PVT.LOCK_ROW');
109: --any validation to be added here ?
110: --call table handler to lock the row
111: PA_ROLE_LISTS_PKG.LOCK_ROW(
112: P_ROWID,

Line 126: p_pkg_name => 'PA_ROLE_LISTS_PVT',

122: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
123: X_MSG_COUNT := 1;
124: X_MSG_DATA := substr(SQLERRM, 1, 240);
125: FND_MSG_PUB.add_exc_msg(
126: p_pkg_name => 'PA_ROLE_LISTS_PVT',
127: p_procedure_name => PA_DEBUG.G_err_stack,
128: p_error_text => X_MSG_DATA);
129: end;
130:

Line 166: PA_DEBUG.init_err_stack('PA_ROLE_LISTS_PVT.UPDATE_ROW');

162: X_MSG_DATA out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
163: ) is
164: v_name PA_ROLE_LISTS.name%TYPE;
165: begin
166: PA_DEBUG.init_err_stack('PA_ROLE_LISTS_PVT.UPDATE_ROW');
167:
168: select name
169: into v_name
170: from pa_role_lists

Line 221: p_pkg_name => 'PA_ROLE_LISTS_PVT',

217: PA_DEBUG.reset_err_stack;
218: else
219: X_MSG_COUNT := 1;
220: FND_MSG_PUB.add_exc_msg(
221: p_pkg_name => 'PA_ROLE_LISTS_PVT',
222: p_procedure_name => PA_DEBUG.G_err_stack,
223: p_error_text => X_MSG_DATA);
224: end if;
225:

Line 232: p_pkg_name => 'PA_ROLE_LISTS_PVT',

228: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
229: X_MSG_COUNT := 1;
230: X_MSG_DATA := substr(SQLERRM, 1, 240);
231: FND_MSG_PUB.add_exc_msg(
232: p_pkg_name => 'PA_ROLE_LISTS_PVT',
233: p_procedure_name => PA_DEBUG.G_err_stack,
234: p_error_text => X_MSG_DATA);
235: end;
236:

Line 246: PA_DEBUG.init_err_stack('PA_ROLE_LISTS_PVT.DELETE_ROW');

242: X_MSG_DATA out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
243: ) is
244: v_role_list_id number;
245: begin
246: PA_DEBUG.init_err_stack('PA_ROLE_LISTS_PVT.DELETE_ROW');
247: --validate if the role list can be deleted or not
248: select role_list_id
249: into v_role_list_id
250: from pa_role_lists

Line 272: p_pkg_name => 'PA_ROLE_LISTS_PVT',

268:
269: else
270: X_MSG_COUNT := 1;
271: FND_MSG_PUB.add_exc_msg(
272: p_pkg_name => 'PA_ROLE_LISTS_PVT',
273: p_procedure_name => PA_DEBUG.G_err_stack,
274: p_error_text => X_MSG_DATA);
275: end if;
276:

Line 283: p_pkg_name => 'PA_ROLE_LISTS_PVT',

279: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
280: X_MSG_COUNT := 1;
281: X_MSG_DATA := substr(SQLERRM, 1, 240);
282: FND_MSG_PUB.add_exc_msg(
283: p_pkg_name => 'PA_ROLE_LISTS_PVT',
284: p_procedure_name => PA_DEBUG.G_err_stack,
285: p_error_text => X_MSG_DATA);
286: end;
287:

Line 288: end PA_ROLE_LISTS_PVT;

284: p_procedure_name => PA_DEBUG.G_err_stack,
285: p_error_text => X_MSG_DATA);
286: end;
287:
288: end PA_ROLE_LISTS_PVT;