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

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 47: PA_ROLE_LISTS_PKG.INSERT_ROW(

43: X_MSG_DATA);
44:
45: if X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS then
46: --call table handler to insert the row
47: PA_ROLE_LISTS_PKG.INSERT_ROW(
48: P_ROWID,
49: P_ROLE_LIST_ID,
50: P_NAME,
51: P_START_DATE_ACTIVE,

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 111: PA_ROLE_LISTS_PKG.LOCK_ROW(

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,
113: P_RECORD_VERSION_NUMBER);
114:
115: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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 164: v_name PA_ROLE_LISTS.name%TYPE;

160: X_RETURN_STATUS out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
161: X_MSG_COUNT out NOCOPY NUMBER, --File.Sql.39 bug 4440895
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

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 170: from pa_role_lists

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
171: where rowid = p_rowid;
172:
173: x_return_status := FND_API.G_RET_STS_SUCCESS;
174:

Line 185: PA_ROLE_LISTS_PKG.UPDATE_ROW(

181: end if;
182:
183: if X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS then
184: --call table handler to update the row
185: PA_ROLE_LISTS_PKG.UPDATE_ROW(
186: P_ROWID,
187: P_ROLE_LIST_ID,
188: P_NAME,
189: P_START_DATE_ACTIVE,

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 250: from pa_role_lists

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
251: where rowid = P_ROWID;
252:
253: PA_ROLE_UTILS.CHECK_DELETE_ROLE_LIST_OK(
254: v_role_list_id,

Line 260: PA_ROLE_LISTS_PKG.DELETE_ROW(P_ROWID);

256: X_MSG_DATA);
257:
258: if X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS then
259: ----call the table handler to delete role list
260: PA_ROLE_LISTS_PKG.DELETE_ROW(P_ROWID);
261:
262: delete from PA_ROLE_LIST_MEMBERS
263: where ROLE_LIST_ID = v_role_list_id;
264:

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;