DBA Data[Home] [Help]

APPS.PA_PROJECT_SETS_PKG dependencies on PA_DEBUG

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

28: ,x_project_set_id OUT NOCOPY pa_project_sets_b.project_set_id%TYPE --File.Sql.39 bug 4440895
29: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
30: )
31: IS
32: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
33: BEGIN
34:
35: -- Initialize the return status to success
36: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 40: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SET_Pkg.insert_row.begin'

36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37:
38: --Log Message
39: IF l_enable_log = 'Y' THEN
40: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SET_Pkg.insert_row.begin'
41: ,x_msg => 'Beginning of insert row'
42: ,x_log_level => 5);
43: END IF;
44:

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

136: EXCEPTION
137: WHEN OTHERS THEN
138: -- Set the excetption Message and the stack
139: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PKG.Insert_row'
140: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
141: --
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
143: RAISE;
144:

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

172: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE
173: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
174: )
175: IS
176: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
177: BEGIN
178:
179: -- Initialize the return status to success
180: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 184: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_Pkg.update_row.begin'

180: x_return_status := FND_API.G_RET_STS_SUCCESS;
181:
182: --Log Message
183: IF l_enable_log = 'Y' THEN
184: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_Pkg.update_row.begin'
185: ,x_msg => 'Beginning of update row'
186: ,x_log_level => 5);
187: END IF;
188:

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

239: EXCEPTION
240: WHEN OTHERS THEN
241: -- Set the excetption Message and the stack
242: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PKG.update_row'
243: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
244: --
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
246: RAISE;
247:

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

253: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE
254: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
255: )
256: IS
257: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
258: BEGIN
259:
260: -- Initialize the return status to success
261: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

282: EXCEPTION
283: WHEN OTHERS THEN
284: -- Set the exception Message and the stack
285: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_SETS_PKG.Delete_Row'
286: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
288: RAISE;
289: END Delete_Row;
290:

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

294: ,p_project_id IN pa_project_set_lines.project_id%TYPE
295: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
296: )
297: IS
298: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
299: BEGIN
300:
301: -- Initialize the return status to success
302: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 306: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SET_Pkg.insert_row_lines.begin'

302: x_return_status := FND_API.G_RET_STS_SUCCESS;
303:
304: --Log Message
305: IF l_enable_log = 'Y' THEN
306: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SET_Pkg.insert_row_lines.begin'
307: ,x_msg => 'Beginning of insert row lines'
308: ,x_log_level => 5);
309: END IF;
310:

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

328: EXCEPTION
329: WHEN OTHERS THEN
330: -- Set the exception Message and the stack
331: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SET_LINES_PKG.Insert_row_lines'
332: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
333: --
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
335: RAISE;
336:

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

342: ,p_project_id IN pa_project_set_lines.project_id%TYPE
343: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
344: )
345: IS
346: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
347: BEGIN
348:
349: -- Initialize the return status to success
350: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 354: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SET_Pkg.delete_row_lines.begin'

350: x_return_status := FND_API.G_RET_STS_SUCCESS;
351:
352: --Log Message
353: IF l_enable_log = 'Y' THEN
354: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SET_Pkg.delete_row_lines.begin'
355: ,x_msg => 'Beginning of delete row lines'
356: ,x_log_level => 5);
357: END IF;
358:

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

365: EXCEPTION
366: WHEN OTHERS THEN
367: -- Set the exception Message and the stack
368: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SET_LINES_PKG.Delete_row_lines'
369: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
370: --
371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
372: RAISE;
373: