eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ROLE_PROFILES_PKG dependencies on PA_DEBUG

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

21: p_resource_id IN NUMBER DEFAULT NULL,
22: x_profile_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
23: x_return_status OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
24:
25: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
26:
27: BEGIN
28: x_return_status := FND_API.G_RET_STS_SUCCESS;
29:

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

67: EXCEPTION
68: WHEN OTHERS THEN -- catch the exceptins here
69: -- Set the exception Message and the stack
70: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ROLE_PROFILES_PKG.Insert_Row1'
71: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
73: RAISE;
74: END Insert_Row1;
75:

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

86: p_project_role_id IN NUMBER,
87: p_role_weighting IN NUMBER,
88: x_return_status OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
89:
90: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
91:
92: BEGIN
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:

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

112: EXCEPTION
113: WHEN OTHERS THEN -- catch the exceptins here
114: -- Set the exception Message and the stack
115: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ROLE_PROFILES_PKG.Insert_Row2'
116: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
118: RAISE;
119: END Insert_Row2;
120:

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

140: p_position_id IN NUMBER DEFAULT NULL,
141: p_resource_id IN NUMBER DEFAULT NULL,
142: x_return_status OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
143:
144: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
145:
146: BEGIN
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148:

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

164: EXCEPTION
165: WHEN OTHERS THEN -- catch the exceptins here
166: -- Set the exception Message and the stack
167: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ROLE_PROFILES_PKG.Update_Row'
168: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
170: RAISE;
171: END Update_Row;
172:

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

214: l_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
215: l_exists VARCHAR2(1);
216: l_return_status VARCHAR2(1);
217: l_msg_index_out NUMBER := 0;
218: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
219: BEGIN
220: -------------------------------------------------------------------
221: -- Initial Setup
222: -------------------------------------------------------------------

Line 224: PA_DEBUG.init_err_stack('PA_ROLE_PROFILES_PUB.Add_Res_Profile');

220: -------------------------------------------------------------------
221: -- Initial Setup
222: -------------------------------------------------------------------
223: IF l_enable_log = 'Y' THEN
224: PA_DEBUG.init_err_stack('PA_ROLE_PROFILES_PUB.Add_Res_Profile');
225: END IF;
226: dbms_output.put_line('started');
227:
228: -- Clear the global PL/SQL message table

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

348: END IF;
349:
350: -- Set the exception Message and the stack
351: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_ROLE_PROFILES_PUB.Add_Res_Profiles'
352: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
353: RAISE; -- This is optional depending on the needs
354:
355: END Add_Res_Profiles;
356: */

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

394: l_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
395: l_exists VARCHAR2(1) := 'N';
396: l_return_status VARCHAR2(1);
397: l_msg_index_out NUMBER := 0;
398: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
399: BEGIN
400: -------------------------------------------------------------------
401: -- Initial Setup
402: -------------------------------------------------------------------

Line 404: PA_DEBUG.init_err_stack('PA_ROLE_PROFILES_PUB.Update_Res_Profile');

400: -------------------------------------------------------------------
401: -- Initial Setup
402: -------------------------------------------------------------------
403: IF l_enable_log = 'Y' THEN
404: PA_DEBUG.init_err_stack('PA_ROLE_PROFILES_PUB.Update_Res_Profile');
405: END IF;
406:
407: -- Clear the global PL/SQL message table
408: FND_MSG_PUB.initialize;

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

506: END IF;
507:
508: -- Set the exception Message and the stack
509: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_ROLE_PROFILES_PUB.Update_Res_Profiles'
510: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
511: RAISE; -- This is optional depending on the needs
512:
513: END Update_Res_Profiles;
514: