APPS.PA_TEAM_TEMPLATES_UTILS dependencies on PA_TEAM_TEMPLATES

Line 1: PACKAGE BODY pa_team_templates_utils AS

1: PACKAGE BODY pa_team_templates_utils AS
2: /*$Header: PARTUTLB.pls 120.1 2005/08/19 17:02:16 mwasowic noship $*/
3: --
4:
5:

Line 7: FUNCTION Is_Team_Template_Name_Unique(p_team_template_name IN pa_team_templates.team_template_name%TYPE)

3: --
4:
5:
6:
7: FUNCTION Is_Team_Template_Name_Unique(p_team_template_name IN pa_team_templates.team_template_name%TYPE)
8: RETURN VARCHAR2
9: IS
10:
11: l_validate_team_template_name VARCHAR2(1);

Line 16: FROM pa_team_templates

12: l_return_value VARCHAR2(1);
13:
14: CURSOR validate_team_template_name IS
15: SELECT 'X'
16: FROM pa_team_templates
17: WHERE team_template_name = p_team_template_name;
18:
19: BEGIN
20: /*

Line 25: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_UTILS.Is_Team_Template_Name_Unique.begin'

21: -- Initialize the Error Stack
22: PA_DEBUG.set_err_stack('PA_TEAM_TEMPLATE_UTILS.Is_Team_Template_Name_Unique');
23:
24: --Log Message
25: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_UTILS.Is_Team_Template_Name_Unique.begin'
26: ,x_msg => 'Beginning of Is_Team_Template_Name_Unique'
27: ,x_log_level => 5);
28: */
29: l_return_value := 'Y';

Line 45: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_UTILS.Is_Team_Template_Name_Unique'

41: EXCEPTION
42: WHEN OTHERS THEN
43: /* --
44: -- Set the excetption Message and the stack
45: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_UTILS.Is_Team_Template_Name_Unique'
46: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
47: --
48: */ RAISE;
49:

Line 68: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_UTILS.Check_Team_Template_Name_Or_Id.begin'

64: PA_DEBUG.set_err_stack('PA_TEAM_TEMPLATE_UTILS.Check_Team_Template_Name_Or_Id');
65:
66: --Log Message
67: IF (P_DEBUG_MODE ='Y') THEN
68: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_UTILS.Check_Team_Template_Name_Or_Id.begin'
69: ,x_msg => 'Beginning of Is_Team_Template_Name_Unique'
70: ,x_log_level => 5);
71: END IF;
72:

Line 77: FROM pa_team_templates tt

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
78: WHERE tt.team_template_id = p_team_template_id;
79: ELSE
80: x_team_template_id := p_team_template_id;
81: END IF;

Line 85: FROM pa_team_templates tt

81: END IF;
82: ELSE
83: SELECT team_template_id
84: INTO x_team_template_id
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;

Line 100: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_UTILS.Check_Team_Template_Name_Or_Id'

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'
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

Line 152: END pa_team_templates_utils;

148: END IF;
149:
150: END CallbackFunction;
151:
152: END pa_team_templates_utils;
153: