DBA Data[Home] [Help]

APPS.PA_TEAM_TEMPLATES_UTILS dependencies on FND_API

Line 73: IF p_team_template_id IS NOT NULL AND p_team_template_id<>FND_API.G_MISS_NUM THEN

69: ,x_msg => 'Beginning of Is_Team_Template_Name_Unique'
70: ,x_log_level => 5);
71: END IF;
72:
73: IF p_team_template_id IS NOT NULL AND p_team_template_id<>FND_API.G_MISS_NUM THEN
74: IF p_check_id_flag = 'Y' THEN
75: SELECT team_template_id
76: INTO x_team_template_id
77: FROM pa_team_templates tt

Line 89: x_return_status := FND_API.G_RET_STS_SUCCESS;

85: FROM pa_team_templates tt
86: WHERE tt.team_template_name = p_team_template_name;
87: END IF;
88:
89: x_return_status := FND_API.G_RET_STS_SUCCESS;
90:
91: EXCEPTION
92: WHEN NO_DATA_FOUND THEN
93: x_return_status := FND_API.G_RET_STS_ERROR;

Line 93: x_return_status := FND_API.G_RET_STS_ERROR;

89: x_return_status := FND_API.G_RET_STS_SUCCESS;
90:
91: EXCEPTION
92: WHEN NO_DATA_FOUND THEN
93: x_return_status := FND_API.G_RET_STS_ERROR;
94: x_error_message_code := 'PA_TEAM_TEMPLATE_INV_AMG';
95: WHEN TOO_MANY_ROWS THEN
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: x_error_message_code := 'PA_TEAM_TEMPLATE_INV_AMG';

Line 96: x_return_status := FND_API.G_RET_STS_ERROR;

92: WHEN NO_DATA_FOUND THEN
93: x_return_status := FND_API.G_RET_STS_ERROR;
94: x_error_message_code := 'PA_TEAM_TEMPLATE_INV_AMG';
95: WHEN TOO_MANY_ROWS THEN
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: x_error_message_code := 'PA_TEAM_TEMPLATE_INV_AMG';
98: WHEN OTHERS THEN
99: -- Set the excetption Message and the stack
100: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_UTILS.Check_Team_Template_Name_Or_Id'

Line 103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

99: -- Set the excetption Message and the stack
100: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_UTILS.Check_Team_Template_Name_Or_Id'
101: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
102:
103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
104: RAISE; -- This is optional depending on the needs
105:
106: END Check_Team_Template_Name_Or_Id;
107: