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_R_PROJECT_RESOURCES_PUB dependencies on PA_DEBUG

Line 7: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */

3: AS
4:
5: G_PKG_NAME VARCHAR2(30) := 'PA_R_PROJECT_RESOURCES_PUB';
6:
7: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
8:
9: PROCEDURE CREATE_RESOURCE(
10: P_API_VERSION IN NUMBER,
11: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT NULL,

Line 63: PA_DEBUG.init_err_stack('PA_R_PROJECT_RESOURCES_PUB.Create_Resource');

59:
60: --For bug 4345198
61: IF p_debug_mode = 'Y' THEN
62: -- Initialize the Error Stack
63: PA_DEBUG.init_err_stack('PA_R_PROJECT_RESOURCES_PUB.Create_Resource');
64: END IF;
65:
66: -- only for the concurrent program (l_individual = N)
67: -- that we check for the debug mode

Line 70: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

66: -- only for the concurrent program (l_individual = N)
67: -- that we check for the debug mode
68: -- if not, just leave the default value as N for individual pull
69: IF (l_individual = 'N') THEN
70: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
71: l_debug_mode := NVL(l_debug_mode, 'N');
72: END IF;
73:
74: IF p_debug_mode = 'Y' THEN --For bug 4345198

Line 75: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

71: l_debug_mode := NVL(l_debug_mode, 'N');
72: END IF;
73:
74: IF p_debug_mode = 'Y' THEN --For bug 4345198
75: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
76: END IF;
77:
78: IF P_INIT_MSG_LIST IS NULL THEN
79: L_INIT_MSG_LIST := FND_API.G_FALSE;

Line 124: pa_debug.g_err_stage := 'Log: Calling private API - Create_Resource'; --For bug 4345198

120:
121: ---Call the Private Procedure
122: --dbms_output.put_line('Calling Private Procedure PA_R_PROJECT_RESOURCES_PVT.CREATE_RESOURCE ');
123: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
124: pa_debug.g_err_stage := 'Log: Calling private API - Create_Resource'; --For bug 4345198
125: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG',pa_debug.g_err_stage);
126: END IF;
127:
128: PA_R_PROJECT_RESOURCES_PVT.CREATE_RESOURCE (

Line 125: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG',pa_debug.g_err_stage);

121: ---Call the Private Procedure
122: --dbms_output.put_line('Calling Private Procedure PA_R_PROJECT_RESOURCES_PVT.CREATE_RESOURCE ');
123: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
124: pa_debug.g_err_stage := 'Log: Calling private API - Create_Resource'; --For bug 4345198
125: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG',pa_debug.g_err_stage);
126: END IF;
127:
128: PA_R_PROJECT_RESOURCES_PVT.CREATE_RESOURCE (
129: P_COMMIT => L_COMMIT,

Line 156: pa_debug.g_err_stage := 'Log: After private API - Create_Resource'; --For bug 4345198

152: X_RESOURCE_ID => X_RESOURCE_ID );
153: --dbms_output.put_line('after private X_RETURN STATUS ' || x_return_status);
154:
155: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
156: pa_debug.g_err_stage := 'Log: After private API - Create_Resource'; --For bug 4345198
157: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG',pa_debug.g_err_stage);
158: END IF;
159:
160: IF fnd_api.to_boolean(l_commit) THEN

Line 157: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG',pa_debug.g_err_stage);

153: --dbms_output.put_line('after private X_RETURN STATUS ' || x_return_status);
154:
155: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
156: pa_debug.g_err_stage := 'Log: After private API - Create_Resource'; --For bug 4345198
157: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG',pa_debug.g_err_stage);
158: END IF;
159:
160: IF fnd_api.to_boolean(l_commit) THEN
161: COMMIT WORK;

Line 190: PA_DEBUG.Reset_Err_Stack;

186: END IF;
187:
188: IF P_DEBUG_MODE = 'Y' THEN --For bug 4345198
189: --Reset the error stack when returning to the calling program
190: PA_DEBUG.Reset_Err_Stack;
191: END IF;
192:
193:
194: EXCEPTION

Line 210: pa_debug.write_file('LOG','Public API - Create_Resource exception: Others');

206: --DBMS_OUTPUT.put_line (' Raised Others in Create Resource Public');
207: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
208:
209: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
210: pa_debug.write_file('LOG','*****Public API - Create_Resource exception: Others*****');
211: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG', SQLERRM);
212: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG',pa_debug.g_err_stack);
213: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG',pa_debug.g_err_stage);
214: END IF;

Line 211: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG', SQLERRM);

207: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
208:
209: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
210: pa_debug.write_file('LOG','*****Public API - Create_Resource exception: Others*****');
211: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG', SQLERRM);
212: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG',pa_debug.g_err_stack);
213: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG',pa_debug.g_err_stage);
214: END IF;
215:

Line 212: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG',pa_debug.g_err_stack);

208:
209: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
210: pa_debug.write_file('LOG','*****Public API - Create_Resource exception: Others*****');
211: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG', SQLERRM);
212: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG',pa_debug.g_err_stack);
213: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG',pa_debug.g_err_stage);
214: END IF;
215:
216: IF (p_commit = FND_API.G_TRUE) THEN

Line 213: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG',pa_debug.g_err_stage);

209: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
210: pa_debug.write_file('LOG','*****Public API - Create_Resource exception: Others*****');
211: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG', SQLERRM);
212: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG',pa_debug.g_err_stack);
213: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG',pa_debug.g_err_stage);
214: END IF;
215:
216: IF (p_commit = FND_API.G_TRUE) THEN
217: ROLLBACK TO res_pub_create_resource;