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

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

34: l_return_status VARCHAR2(1);
35: l_unique VARCHAR2(1);
36: l_msg_count NUMBER;
37: l_msg_data VARCHAR2(240);
38: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
39:
40: BEGIN
41:
42: -- Initialize the return status to success

Line 47: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PVT.Create_Project_Set.begin'

43: x_return_status := FND_API.G_RET_STS_SUCCESS;
44:
45: --Log Message
46: IF l_enable_log = 'Y' THEN
47: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PVT.Create_Project_Set.begin'
48: ,x_msg => 'Beginning of Create_Project_Set pvt'
49: ,x_log_level => 5);
50: END IF;
51: -- have to get the party_id of the owner if party_id passed in is NULL

Line 87: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PVT.Create_Project_Set'

83:
84: IF FND_MSG_PUB.Count_Msg =0 THEN
85:
86: IF l_enable_log = 'Y' THEN
87: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PVT.Create_Project_Set'
88: ,x_msg => 'before pa_project_sets_pkg.insert_row'
89: ,x_log_level => 5);
90: END IF;
91:

Line 121: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PVT.Create_Project_Set'

117:
118: END IF;
119:
120: IF l_enable_log = 'Y' THEN
121: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PVT.Create_Project_Set'
122: ,x_msg => 'x_project_set_id = '|| x_project_set_id
123: ,x_log_level => 5);
124: END IF;
125:

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

131: WHEN OTHERS THEN
132:
133: -- Set the excetption Message and the stack
134: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PVT.Create_Project_Set'
135: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
136: --
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
138:
139: -- Start : RESET other OUT param too : 4537865

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

178: l_return_status VARCHAR2(1);
179: l_unique VARCHAR2(1);
180: l_msg_count NUMBER;
181: l_msg_data VARCHAR2(240);
182: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
183:
184: BEGIN
185:
186: -- Initialize the return status to success

Line 191: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PVT.Update_Project_Set.begin'

187: x_return_status := FND_API.G_RET_STS_SUCCESS;
188:
189: --Log Message
190: IF l_enable_log = 'Y' THEN
191: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PVT.Update_Project_Set.begin'
192: ,x_msg => 'Beginning of Update_Project_Set pvt'
193: ,x_log_level => 5);
194: END IF;
195:

Line 229: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PVT.Update_Project_Set'

225:
226:
227: IF FND_MSG_PUB.Count_Msg =0 THEN
228: IF l_enable_log = 'Y' THEN
229: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PVT.Update_Project_Set'
230: ,x_msg => 'before pa_project_sets_pkg.insert_row'
231: ,x_log_level => 5);
232: END IF;
233:

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

268: WHEN OTHERS THEN
269:
270: -- Set the excetption Message and the stack
271: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PVT.Update_Project_Set'
272: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
273: --
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
275: --RAISE;
276:

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

285: IS
286: l_return_status VARCHAR2(1);
287: l_do_lines_exist VARCHAR2(1);
288: l_project_set_lines_tbl pa_project_set_utils.project_set_lines_tbl_type;
289: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
290:
291: BEGIN
292:
293: -- Initialize the return status to success

Line 298: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PVT.Delete_Project_Set'

294: x_return_status := FND_API.G_RET_STS_SUCCESS;
295:
296: --Log Message
297: IF l_enable_log = 'Y' THEN
298: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PVT.Delete_Project_Set'
299: ,x_msg => 'Beginning of Delete_Project_Set pvt'
300: ,x_log_level => 5);
301: END IF;
302:

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

337: WHEN OTHERS THEN
338:
339: -- Set the excetption Message and the stack
340: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PVT.Delete_Project_Set'
341: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
342: --
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
344: --RAISE;
345:

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

355: l_exists VARCHAR2(1);
356: l_project_set_id PA_PROJECT_SETS_B.project_set_id%TYPE;
357: e_row_is_locked EXCEPTION;
358: PRAGMA EXCEPTION_INIT(e_row_is_locked, -54);
359: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
360:
361: BEGIN
362:
363: -- Initialize the return status to success

Line 368: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PVT.Create_Project_Set_Line.begin'

364: x_return_status := FND_API.G_RET_STS_SUCCESS;
365:
366: --Log Message
367: IF l_enable_log = 'Y' THEN
368: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PVT.Create_Project_Set_Line.begin'
369: ,x_msg => 'Beginning of Create_Project_Set_Line pvt'
370: ,x_log_level => 5);
371: END IF;
372:

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

396: x_return_status := FND_API.G_RET_STS_ERROR;
397:
398: WHEN OTHERS THEN
399: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PVT.create_project_set_line'
400: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
402: RAISE;
403:
404: END create_project_set_line;

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

411: )
412: IS
413: l_return_status VARCHAR2(1);
414: l_exists VARCHAR2(1);
415: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
416: BEGIN
417:
418: -- Initialize the return status to success
419: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 423: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PVT.Delete_Project_Set_Line.begin'

419: x_return_status := FND_API.G_RET_STS_SUCCESS;
420:
421: --Log Message
422: IF l_enable_log = 'Y' THEN
423: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PVT.Delete_Project_Set_Line.begin'
424: ,x_msg => 'Beginning of Delete_Project_Set_Line pvt'
425: ,x_log_level => 5);
426: END IF;
427:

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

467: EXCEPTION
468: WHEN OTHERS THEN
469: -- Set the exception Message and the stack
470: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SET_LINES_PKG.Delete_project_from_project_sets'
471: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
472:
473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
474: RAISE;
475: