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

Line 5: p_commit IN VARCHAR2:=FND_API.G_FALSE,

1: package body PA_PROJECT_ROLES_PVT AS
2: /* $Header: PARPRPVB.pls 120.1 2005/08/19 16:59:35 mwasowic noship $ */
3:
4: procedure INSERT_ROW (
5: p_commit IN VARCHAR2:=FND_API.G_FALSE,
6: p_debug_mode in varchar2 default 'N',
7: X_ROWID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
8: X_PROJECT_ROLE_ID IN NUMBER,
9: X_PROJECT_ROLE_TYPE IN VARCHAR2,

Line 57: if x_return_status =FND_API.G_RET_STS_SUCCESS then

53: ----Check if the role name is duplicate
54: pa_role_utils.check_dup_role_name(x_meaning,
55: x_return_status,
56: v_error_message_code);
57: if x_return_status =FND_API.G_RET_STS_SUCCESS then
58:
59: --- call table handler to insert into the table
60: pa_project_role_types_pkg.insert_row(
61: X_ROWID ,

Line 99: elsif x_return_status =FND_API.G_RET_STS_ERROR then

95: X_DEFAULT_ACCESS_LEVEL ,
96: X_ROLE_PARTY_CLASS ,
97: X_STATUS_LEVEL
98: );
99: elsif x_return_status =FND_API.G_RET_STS_ERROR then
100: fnd_message.set_name('PA',v_error_message_code);
101: fnd_msg_pub.ADD;
102: x_msg_count:=x_msg_count+1;
103:

Line 104: elsif x_return_status =FND_API.G_RET_STS_UNEXP_ERROR then

100: fnd_message.set_name('PA',v_error_message_code);
101: fnd_msg_pub.ADD;
102: x_msg_count:=x_msg_count+1;
103:
104: elsif x_return_status =FND_API.G_RET_STS_UNEXP_ERROR then
105: fnd_msg_pub.add_exc_msg
106: (p_pkg_name => 'PA_ROLE_UTILS',
107: p_procedure_name => 'check_dup_role_name',
108: P_ERROR_TEXT =>v_error_message_code);

Line 114: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

110: end if;
111:
112: exception
113: when others then
114: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
115: v_sqlcode:=SQLCODE;
116: fnd_msg_pub.add_exc_msg
117: (p_pkg_name => 'PA_PROJECT_ROLES_PVT',
118: p_procedure_name => 'INSERT_ROW',

Line 125: p_commit IN VARCHAR2:=FND_API.G_FALSE,

121:
122: end;
123:
124: procedure LOCK_ROW (
125: p_commit IN VARCHAR2:=FND_API.G_FALSE,
126: p_debug_mode in varchar2 default 'N',
127: X_ROWID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
128: X_RECORD_VERSION_NUMBER IN NUMBER,
129: x_return_status OUT NOCOPY varchar2, --File.Sql.39 bug 4440895

Line 142: x_return_status:=FND_API.G_RET_STS_SUCCESS;

138: -----call table handler to lock the row
139: pa_project_role_types_pkg.lock_row (
140: X_ROWID ,
141: X_RECORD_VERSION_NUMBER );
142: x_return_status:=FND_API.G_RET_STS_SUCCESS;
143: exception
144: when others then
145: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
146: v_sqlcode:=SQLCODE;

Line 145: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

141: X_RECORD_VERSION_NUMBER );
142: x_return_status:=FND_API.G_RET_STS_SUCCESS;
143: exception
144: when others then
145: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
146: v_sqlcode:=SQLCODE;
147: fnd_msg_pub.add_exc_msg
148: (p_pkg_name => 'PA_PROJECT_ROLES_PVT',
149: p_procedure_name => 'LOCK_ROW',

Line 155: p_commit IN VARCHAR2:=FND_API.G_FALSE,

151: x_msg_count:=x_msg_count+1;
152: end;
153:
154: procedure UPDATE_ROW (
155: p_commit IN VARCHAR2:=FND_API.G_FALSE,
156: p_debug_mode in varchar2 default 'N',
157: X_ROWID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
158: X_PROJECT_ROLE_ID IN NUMBER,
159: X_PROJECT_ROLE_TYPE IN VARCHAR2,

Line 216: x_return_status:=FND_API.G_RET_STS_SUCCESS;

212: from pa_project_role_types_vl
213: where row_id=x_rowid;
214: --dbms_output.put_line('v_menu_id: '||v_menu_id);
215:
216: x_return_status:=FND_API.G_RET_STS_SUCCESS;
217:
218: --Throwing an error if seeded role
219: /* Commented for bug 2661505
220: IF v_created_by = 1 THEN

Line 221: x_return_status:=FND_API.G_RET_STS_ERROR;

217:
218: --Throwing an error if seeded role
219: /* Commented for bug 2661505
220: IF v_created_by = 1 THEN
221: x_return_status:=FND_API.G_RET_STS_ERROR;
222: fnd_message.set_name('PA', 'PA_COMMON_SEEDED_ROLES');
223: fnd_msg_pub.ADD;
224: x_msg_count:=x_msg_count+1;
225: RETURN;

Line 235: If x_return_status =FND_API.G_RET_STS_SUCCESS then

231: x_return_status,
232: v_error_message_code);
233: end if;
234: --dbms_output.put_line('check1');
235: If x_return_status =FND_API.G_RET_STS_SUCCESS then
236: --dbms_output.put_line('check2');
237: -- hr_utility.trace('update');
238: pa_project_role_types_pkg.update_row(
239: X_ROWID ,

Line 286: if x_return_status=FND_API.G_RET_STS_ERROR then

282: pa_role_utils.update_menu_in_grants(x_project_role_id,
283: x_menu_id,
284: x_return_status,
285: v_error_message_code);
286: if x_return_status=FND_API.G_RET_STS_ERROR then
287: fnd_message.set_name('PA',v_error_message_code);
288: fnd_msg_pub.ADD;
289: x_msg_count:=x_msg_count+1;
290: return;

Line 291: elsif x_return_status =FND_API.G_RET_STS_UNEXP_ERROR then

287: fnd_message.set_name('PA',v_error_message_code);
288: fnd_msg_pub.ADD;
289: x_msg_count:=x_msg_count+1;
290: return;
291: elsif x_return_status =FND_API.G_RET_STS_UNEXP_ERROR then
292: fnd_msg_pub.add_exc_msg
293: (p_pkg_name => 'PA_ROLE_UTILS',
294: p_procedure_name => 'update_menu_in_grants',
295: P_ERROR_TEXT =>v_error_message_code);

Line 304: if x_return_status=FND_API.G_RET_STS_ERROR then

300: elsif v_menu_id is not null and x_menu_id is null then
301: pa_role_utils.disable_role_based_sec(x_project_role_id,
302: x_return_status,
303: v_error_message_code) ;
304: if x_return_status=FND_API.G_RET_STS_ERROR then
305: fnd_message.set_name('PA',v_error_message_code);
306: fnd_msg_pub.ADD;
307: x_msg_count:=x_msg_count+1;
308: return;

Line 309: elsif x_return_status =FND_API.G_RET_STS_UNEXP_ERROR then

305: fnd_message.set_name('PA',v_error_message_code);
306: fnd_msg_pub.ADD;
307: x_msg_count:=x_msg_count+1;
308: return;
309: elsif x_return_status =FND_API.G_RET_STS_UNEXP_ERROR then
310: fnd_msg_pub.add_exc_msg
311: (p_pkg_name => 'PA_ROLE_UTILS',
312: p_procedure_name => 'disable_role_based_sec',
313: P_ERROR_TEXT =>v_error_message_code);

Line 326: if x_return_status=FND_API.G_RET_STS_ERROR then

322: v_error_message_code) ;
323: -- hr_utility.trace('x_return_status is ' || x_return_status);
324: -- hr_utility.trace('v_error_message_code is ' || v_error_message_code);
325: -- hr_utility.trace('after enable menu update');
326: if x_return_status=FND_API.G_RET_STS_ERROR then
327: fnd_message.set_name('PA',v_error_message_code);
328: fnd_msg_pub.ADD;
329: x_msg_count:=x_msg_count+1;
330: -- hr_utility.trace('The end');

Line 332: elsif x_return_status =FND_API.G_RET_STS_UNEXP_ERROR then

328: fnd_msg_pub.ADD;
329: x_msg_count:=x_msg_count+1;
330: -- hr_utility.trace('The end');
331: return;
332: elsif x_return_status =FND_API.G_RET_STS_UNEXP_ERROR then
333: fnd_msg_pub.add_exc_msg
334: (p_pkg_name => 'PA_ROLE_UTILS',
335: p_procedure_name => 'Enable_role_based_sec',
336: P_ERROR_TEXT =>v_error_message_code);

Line 342: elsif x_return_status =FND_API.G_RET_STS_ERROR then

338: return;
339: end if;
340: end if;
341:
342: elsif x_return_status =FND_API.G_RET_STS_ERROR then
343: fnd_message.set_name('PA',v_error_message_code);
344: fnd_msg_pub.ADD;
345: x_msg_count:=x_msg_count+1;
346: elsif x_return_status =FND_API.G_RET_STS_UNEXP_ERROR then

Line 346: elsif x_return_status =FND_API.G_RET_STS_UNEXP_ERROR then

342: elsif x_return_status =FND_API.G_RET_STS_ERROR then
343: fnd_message.set_name('PA',v_error_message_code);
344: fnd_msg_pub.ADD;
345: x_msg_count:=x_msg_count+1;
346: elsif x_return_status =FND_API.G_RET_STS_UNEXP_ERROR then
347: fnd_msg_pub.add_exc_msg
348: (p_pkg_name => 'PA_ROLE_UTILS',
349: p_procedure_name => 'check_dup_role_name',
350: P_ERROR_TEXT =>v_error_message_code);

Line 357: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

353:
354: exception
355: when others then
356: --dbms_output.put_line('check4');
357: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
358: v_sqlcode:=SQLCODE;
359: fnd_msg_pub.add_exc_msg
360: (p_pkg_name => 'PA_PROJECT_ROLES_PVT',
361: p_procedure_name => 'UPDATE_ROW',

Line 368: p_commit IN VARCHAR2:=FND_API.G_FALSE,

364: end;
365:
366:
367: procedure DELETE_ROW (
368: p_commit IN VARCHAR2:=FND_API.G_FALSE,
369: p_debug_mode in varchar2 default 'N',
370: X_ROWID in varchar2,
371: x_return_status OUT NOCOPY varchar2, --File.Sql.39 bug 4440895
372: x_msg_count out NOCOPY number, --File.Sql.39 bug 4440895

Line 390: x_return_status:=FND_API.G_RET_STS_ERROR;

386: where row_id=X_ROWID;
387:
388: --Throwing an error if seeded role
389: IF v_created_by = 1 THEN
390: x_return_status:=FND_API.G_RET_STS_ERROR;
391: fnd_message.set_name('PA', 'PA_COMMON_SEEDED_ROLES');
392: fnd_msg_pub.ADD;
393: x_msg_count:=x_msg_count+1;
394: RETURN;

Line 403: if x_return_status =FND_API.G_RET_STS_SUCCESS then

399: x_return_status,
400: v_error_message_code);
401: --dbms_output.put_line('x_return_status: '||x_return_status);
402:
403: if x_return_status =FND_API.G_RET_STS_SUCCESS then
404: ----call the table handler to delete roles
405: pa_project_role_types_pkg.delete_row(X_ROWID);
406: --dbms_output.put_line('called delete_row');
407:

Line 424: elsif x_return_status =FND_API.G_RET_STS_ERROR then

420: where OBJECT_ID=v_role_id
421: and OBJECT_NAME='PROJECT_ROLE';
422: --dbms_output.put_line('delete competence ele');
423:
424: elsif x_return_status =FND_API.G_RET_STS_ERROR then
425: fnd_message.set_name('PA',v_error_message_code);
426: fnd_msg_pub.ADD;
427: x_msg_count:=x_msg_count+1;
428: elsif x_return_status =FND_API.G_RET_STS_UNEXP_ERROR then

Line 428: elsif x_return_status =FND_API.G_RET_STS_UNEXP_ERROR then

424: elsif x_return_status =FND_API.G_RET_STS_ERROR then
425: fnd_message.set_name('PA',v_error_message_code);
426: fnd_msg_pub.ADD;
427: x_msg_count:=x_msg_count+1;
428: elsif x_return_status =FND_API.G_RET_STS_UNEXP_ERROR then
429: fnd_msg_pub.add_exc_msg
430: (p_pkg_name => 'PA_ROLE_UTILS',
431: p_procedure_name => 'check_delete_role_ok',
432: P_ERROR_TEXT =>v_error_message_code);

Line 437: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

433: x_msg_count:=x_msg_count+1;
434: end if;
435: exception
436: when others then
437: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
438: v_sqlcode:=SQLCODE;
439: fnd_msg_pub.add_exc_msg
440: (p_pkg_name => 'PA_PROJECT_ROLES_PVT',
441: p_procedure_name => 'DELETE_ROW',