APPS.PA_TEAM_TEMPLATES_PKG dependencies on PA_DEBUG

Line 4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

1: PACKAGE BODY pa_team_templates_pkg AS
2: /*$Header: PARTPKGB.pls 120.1 2005/08/19 17:01:03 mwasowic noship $*/
3: --
4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: PROCEDURE Insert_Row
6: (p_team_template_name IN pa_team_templates.team_template_name%TYPE
7: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
8: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE

Line 39: PA_DEBUG.set_err_stack('PA_TEAM_TEMPLATE_PKG.Insert_Row');

35:
36: BEGIN
37:
38: -- Initialize the Error Stack
39: PA_DEBUG.set_err_stack('PA_TEAM_TEMPLATE_PKG.Insert_Row');
40:
41: --Log Message
42: IF (P_DEBUG_MODE = 'Y') THEN
43: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PKG.insert_row'

Line 43: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PKG.insert_row'

39: PA_DEBUG.set_err_stack('PA_TEAM_TEMPLATE_PKG.Insert_Row');
40:
41: --Log Message
42: IF (P_DEBUG_MODE = 'Y') THEN
43: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PKG.insert_row'
44: ,x_msg => 'Beginning of the Team Template insert row'
45: ,x_log_level => 5);
46: END IF;
47:

Line 127: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

123: EXCEPTION
124: WHEN OTHERS THEN -- catch the exceptions here
125: -- Set the exception Message and the stack
126: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_TEAM_TEMPLATES_PKG.Insert_Row'
127: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
129: RAISE;
130:
131: END Insert_Row;

Line 172: PA_DEBUG.set_err_stack('PA_TEAM_TEMPLATE_PKG.Update_Row');

168:
169: BEGIN
170:
171: -- Initialize the Error Stack
172: PA_DEBUG.set_err_stack('PA_TEAM_TEMPLATE_PKG.Update_Row');
173:
174: --Log Message
175: IF (P_DEBUG_MODE = 'Y') THEN
176: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PKG.Update_Row'

Line 176: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PKG.Update_Row'

172: PA_DEBUG.set_err_stack('PA_TEAM_TEMPLATE_PKG.Update_Row');
173:
174: --Log Message
175: IF (P_DEBUG_MODE = 'Y') THEN
176: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PKG.Update_Row'
177: ,x_msg => 'Beginning of the Team Template update row'
178: ,x_log_level => 5);
179: END IF;
180:

Line 236: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

232: EXCEPTION
233: WHEN OTHERS THEN -- catch the exceptions here
234: -- Set the exception Message and the stack
235: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_TEAM_TEMPLATES_PKG.Update_Row'
236: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
238: RAISE;
239:
240: END Update_Row;

Line 253: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PKG.delete_row'

249:
250: BEGIN
251:
252: IF (P_DEBUG_MODE = 'Y') THEN
253: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PKG.delete_row'
254: ,x_msg => 'Beginning of the Team Template delete row'
255: ,x_log_level => 5);
256: END IF;
257:

Line 292: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

288: EXCEPTION
289: WHEN OTHERS THEN
290: -- Set the exception Message and the stack
291: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_TEAM_TEMPLATE_PKG.Delete_Row'
292: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
294: RAISE;
295: END Delete_Row;
296: