APPS.AHL_WORKORDER_SEARCH_PUB dependencies on FND_MSG_PUB

Line 27: FND_MSG_PUB.ADD;

23: FETCH get_user_id_csr INTO l_user_id;
24: IF get_user_id_csr%NOTFOUND THEN
25: FND_MESSAGE.set_name('AHL','AHL_PRD_INV_BPEL_USR');
26: FND_MESSAGE.SET_TOKEN('USER_NAME',p_user_id);
27: FND_MSG_PUB.ADD;
28: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
29: END IF;
30: CLOSE get_user_id_csr;
31:

Line 85: Fnd_Msg_Pub.initialize;

81:
82: -- Initialize message list if p_init_msg_list is set to TRUE.
83: IF Fnd_Api.to_boolean(p_init_msg_list)
84: THEN
85: Fnd_Msg_Pub.initialize;
86: END IF;
87:
88: x_return_status := init_user_and_role(p_userid);
89: -- Initialize API return status to success

Line 485: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

481: EXCEPTION
482: WHEN Fnd_Api.G_EXC_ERROR THEN
483: ROLLBACK TO Search_Work_Orders;
484: x_return_status := Fnd_Api.G_RET_STS_ERROR;
485: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
486: p_data => x_msg_data,
487: p_encoded => Fnd_Api.g_false);
488:
489: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 492: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

488:
489: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
490: ROLLBACK TO Search_Work_Orders;
491: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
492: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
493: p_data => x_msg_data,
494: p_encoded => Fnd_Api.g_false);
495:
496: WHEN OTHERS THEN

Line 500: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'AHL_WORKORDER_SEARCH_PUB',

496: WHEN OTHERS THEN
497: -- dbms_output.put_line(' OTHERS ');
498: ROLLBACK TO Search_Work_Orders;
499: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
500: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'AHL_WORKORDER_SEARCH_PUB',
501: p_procedure_name => 'Get_Workorder_Search_Results',
502: p_error_text => SQLERRM);
503:
504: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

Line 504: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

500: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'AHL_WORKORDER_SEARCH_PUB',
501: p_procedure_name => 'Get_Workorder_Search_Results',
502: p_error_text => SQLERRM);
503:
504: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
505: p_data => x_msg_data,
506: p_encoded => Fnd_Api.g_false);
507:
508: END get_wo_search_results;