APPS.PA_ROLE_PROFILES_PKG dependencies on FND_MSG_PUB

Line 70: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ROLE_PROFILES_PKG.Insert_Row1'

66:
67: EXCEPTION
68: WHEN OTHERS THEN -- catch the exceptins here
69: -- Set the exception Message and the stack
70: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ROLE_PROFILES_PKG.Insert_Row1'
71: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
73: RAISE;
74: END Insert_Row1;

Line 115: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ROLE_PROFILES_PKG.Insert_Row2'

111:
112: EXCEPTION
113: WHEN OTHERS THEN -- catch the exceptins here
114: -- Set the exception Message and the stack
115: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ROLE_PROFILES_PKG.Insert_Row2'
116: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
118: RAISE;
119: END Insert_Row2;

Line 167: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ROLE_PROFILES_PKG.Update_Row'

163:
164: EXCEPTION
165: WHEN OTHERS THEN -- catch the exceptins here
166: -- Set the exception Message and the stack
167: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ROLE_PROFILES_PKG.Update_Row'
168: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
170: RAISE;
171: END Update_Row;

Line 229: FND_MSG_PUB.initialize;

225: END IF;
226: dbms_output.put_line('started');
227:
228: -- Clear the global PL/SQL message table
229: FND_MSG_PUB.initialize;
230:
231: -- Issue API savepoint if the transaction is to be committed
232: IF (p_commit = FND_API.G_TRUE) THEN
233: SAVEPOINT ROLE_PUB_ADD_RES_PRF;

Line 335: x_msg_count := FND_MSG_PUB.Count_Msg;

331: -------------------------------------------------------------------
332: EXCEPTION
333: WHEN FND_API.G_EXC_ERROR THEN
334: x_return_status := FND_API.G_RET_STS_ERROR;
335: x_msg_count := FND_MSG_PUB.Count_Msg;
336: IF x_msg_count = 1 THEN
337: pa_interface_utils_pub.get_messages (p_encoded => FND_API.G_TRUE,
338: p_msg_index => 1,
339: p_data => x_msg_data,

Line 351: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_ROLE_PROFILES_PUB.Add_Res_Profiles'

347: ROLLBACK TO ROLE_PUB_ADD_RES_PRF;
348: END IF;
349:
350: -- Set the exception Message and the stack
351: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_ROLE_PROFILES_PUB.Add_Res_Profiles'
352: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
353: RAISE; -- This is optional depending on the needs
354:
355: END Add_Res_Profiles;

Line 408: FND_MSG_PUB.initialize;

404: PA_DEBUG.init_err_stack('PA_ROLE_PROFILES_PUB.Update_Res_Profile');
405: END IF;
406:
407: -- Clear the global PL/SQL message table
408: FND_MSG_PUB.initialize;
409:
410: -- Issue API savepoint if the transaction is to be committed
411: IF (p_commit = FND_API.G_TRUE) THEN
412: SAVEPOINT ROLE_PUB_UPD_RES_PRF;

Line 494: x_msg_count := FND_MSG_PUB.Count_Msg;

490: -------------------------------------------------------------------
491: EXCEPTION
492: WHEN FND_API.G_EXC_ERROR THEN
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: x_msg_count := FND_MSG_PUB.Count_Msg;
495: IF x_msg_count = 1 THEN
496: pa_interface_utils_pub.get_messages (p_encoded => FND_API.G_TRUE,
497: p_msg_index => 1,
498: p_data => x_msg_data,

Line 509: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_ROLE_PROFILES_PUB.Update_Res_Profiles'

505: ROLLBACK TO ROLE_PUB_UPD_RES_PRF;
506: END IF;
507:
508: -- Set the exception Message and the stack
509: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_ROLE_PROFILES_PUB.Update_Res_Profiles'
510: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
511: RAISE; -- This is optional depending on the needs
512:
513: END Update_Res_Profiles;