APPS.PA_ROLE_STATUS_MENU_PVT dependencies on FND_MSG_PUB

Line 45: FND_MSG_PUB.initialize;

41:
42: BEGIN
43:
44:
45: FND_MSG_PUB.initialize;
46:
47: p_msg_count := 0;
48:
49: -- Check if the role status is a duplicate

Line 126: fnd_msg_pub.ADD;

122: END IF;
123:
124: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
125: fnd_message.set_name('PA', l_error_message_code);
126: fnd_msg_pub.ADD;
127: p_msg_count := p_msg_count + 1;
128:
129: ELSIF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
130:

Line 131: fnd_msg_pub.add_exc_msg

127: p_msg_count := p_msg_count + 1;
128:
129: ELSIF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
130:
131: fnd_msg_pub.add_exc_msg
132: (p_pkg_name => 'pa_role_status_menu_utils',
133: p_procedure_name => 'check_dup_role_status',
134: p_error_text => l_error_message_code);
135:

Line 146: fnd_msg_pub.add_exc_msg

142:
143: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: l_sqlcode := SQLCODE;
145:
146: fnd_msg_pub.add_exc_msg
147: (p_pkg_name => 'PA_ROLE_STATUS_MENU_PVT',
148: p_procedure_name => 'INSERT_ROW',
149: p_error_text => l_sqlcode);
150:

Line 169: FND_MSG_PUB.initialize;

165: l_sqlcode varchar2(30);
166:
167: BEGIN
168:
169: FND_MSG_PUB.initialize;
170:
171: p_msg_count := 0;
172:
173: -- Call the table handler to lock the row

Line 188: fnd_msg_pub.add_exc_msg

184:
185: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: l_sqlcode := SQLCODE;
187:
188: fnd_msg_pub.add_exc_msg
189: (p_pkg_name => 'PA_ROLE_STATUS_MENU_PVT',
190: p_procedure_name => 'LOCK_ROW',
191: p_error_text => l_sqlcode);
192:

Line 237: FND_MSG_PUB.initialize;

233: l_sqlcode VARCHAR2(30);
234:
235: BEGIN
236:
237: FND_MSG_PUB.initialize;
238:
239: p_msg_count := 0;
240:
241: -- Check for duplicates.

Line 328: fnd_msg_pub.ADD;

324:
325:
326: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
327: fnd_message.set_name('PA', l_error_message_code);
328: fnd_msg_pub.ADD;
329:
330: p_msg_count := p_msg_count + 1;
331: ELSIF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
332:

Line 333: fnd_msg_pub.add_exc_msg

329:
330: p_msg_count := p_msg_count + 1;
331: ELSIF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
332:
333: fnd_msg_pub.add_exc_msg
334: (p_pkg_name => 'PA_ROLE_STATUS_MENU_UTILS',
335: p_procedure_name => 'check_dup_role_status',
336: p_error_text => l_error_message_code);
337:

Line 347: fnd_msg_pub.add_exc_msg

343:
344: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
345: l_sqlcode := SQLCODE;
346:
347: fnd_msg_pub.add_exc_msg
348: (p_pkg_name => 'PA_ROLE_STATUS_MENU_PVT',
349: p_procedure_name => 'UPDATE_ROW',
350: p_error_text => l_sqlcode);
351:

Line 391: FND_MSG_PUB.initialize;

387: BEGIN
388: -- hr_utility.trace_on(NULL, 'RMFORM');
389: -- hr_utility.trace('start');
390:
391: FND_MSG_PUB.initialize;
392:
393: p_msg_count := 0;
394:
395: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 468: fnd_msg_pub.add_exc_msg

464: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
465:
466: l_sqlcode := SQLCODE;
467:
468: fnd_msg_pub.add_exc_msg
469: (p_pkg_name => 'PA_ROLE_STATUS_MENU_PVT',
470: p_procedure_name => 'DELETE_ROW',
471: p_error_text => l_sqlcode);
472: