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_MSG_PUB

Line 51: FND_MSG_PUB.initialize;

47: ) IS
48: v_sqlcode varchar2(30);
49: v_error_message_code varchar2(30);
50: begin
51: FND_MSG_PUB.initialize;
52: x_msg_count:=0;
53: ----Check if the role name is duplicate
54: pa_role_utils.check_dup_role_name(x_meaning,
55: x_return_status,

Line 101: fnd_msg_pub.ADD;

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:
104: elsif x_return_status =FND_API.G_RET_STS_UNEXP_ERROR then
105: fnd_msg_pub.add_exc_msg

Line 105: fnd_msg_pub.add_exc_msg

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);
109: x_msg_count:=x_msg_count+1;

Line 116: fnd_msg_pub.add_exc_msg

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',
119: P_ERROR_TEXT =>v_sqlcode);
120: x_msg_count:=x_msg_count+1;

Line 135: FND_MSG_PUB.initialize;

131: x_msg_data out NOCOPY varchar2 --File.Sql.39 bug 4440895
132: ) IS
133: v_sqlcode varchar2(30);
134: begin
135: FND_MSG_PUB.initialize;
136: x_msg_count:=0;
137: -----any validation to be added here ?
138: -----call table handler to lock the row
139: pa_project_role_types_pkg.lock_row (

Line 147: fnd_msg_pub.add_exc_msg

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',
150: P_ERROR_TEXT =>v_sqlcode);
151: x_msg_count:=x_msg_count+1;

Line 207: FND_MSG_PUB.initialize;

203:
204: begin
205: -- hr_utility.trace_on(NULL, 'RMFORM');
206: -- hr_utility.trace('start');
207: FND_MSG_PUB.initialize;
208: x_msg_count:=0;
209: ---any validation to be added here
210: select menu_id, meaning, created_by
211: into v_menu_id, v_meaning, v_created_by

Line 223: fnd_msg_pub.ADD;

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;
226: END IF;
227: */

Line 288: fnd_msg_pub.ADD;

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;
291: elsif x_return_status =FND_API.G_RET_STS_UNEXP_ERROR then
292: fnd_msg_pub.add_exc_msg

Line 292: fnd_msg_pub.add_exc_msg

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);
296: x_msg_count:=x_msg_count+1;

Line 306: fnd_msg_pub.ADD;

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;
309: elsif x_return_status =FND_API.G_RET_STS_UNEXP_ERROR then
310: fnd_msg_pub.add_exc_msg

Line 310: fnd_msg_pub.add_exc_msg

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);
314: x_msg_count:=x_msg_count+1;

Line 328: fnd_msg_pub.ADD;

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');
331: return;
332: elsif x_return_status =FND_API.G_RET_STS_UNEXP_ERROR then

Line 333: fnd_msg_pub.add_exc_msg

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);
337: x_msg_count:=x_msg_count+1;

Line 344: fnd_msg_pub.ADD;

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
347: fnd_msg_pub.add_exc_msg
348: (p_pkg_name => 'PA_ROLE_UTILS',

Line 347: fnd_msg_pub.add_exc_msg

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);
351: x_msg_count:=x_msg_count+1;

Line 359: fnd_msg_pub.add_exc_msg

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',
362: P_ERROR_TEXT =>v_sqlcode);
363: x_msg_count:=x_msg_count+1;

Line 380: FND_MSG_PUB.initialize;

376: v_created_by NUMBER;
377: v_error_message_code varchar2(30);
378: v_sqlcode varchar2(30);
379: begin
380: FND_MSG_PUB.initialize;
381: x_msg_count:=0;
382: --validate if the role can be deleted or not
383: select project_role_id, created_by
384: into v_role_id, v_created_by

Line 392: fnd_msg_pub.ADD;

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;
395: END IF;
396:

Line 426: fnd_msg_pub.ADD;

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
429: fnd_msg_pub.add_exc_msg
430: (p_pkg_name => 'PA_ROLE_UTILS',

Line 429: fnd_msg_pub.add_exc_msg

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);
433: x_msg_count:=x_msg_count+1;

Line 439: fnd_msg_pub.add_exc_msg

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',
442: P_ERROR_TEXT =>v_sqlcode);
443: x_msg_count:=x_msg_count+1;