DBA Data[Home] [Help]

APPS.PA_PROJECT_SETS_PVT dependencies on PA_PROJECT_SETS_PVT

Line 1: PACKAGE BODY pa_project_sets_pvt AS

1: PACKAGE BODY pa_project_sets_pvt AS
2: /*$Header: PAPPSPVB.pls 120.2 2005/08/23 05:29:31 avaithia noship $*/
3:
4: --
5: PROCEDURE create_project_set

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 134: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PVT.Create_Project_Set'

130: EXCEPTION
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:

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 271: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PVT.Update_Project_Set'

267: EXCEPTION
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;

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 340: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PVT.Delete_Project_Set'

336: EXCEPTION
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;

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 399: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PVT.create_project_set_line'

395: ,p_msg_name => 'PA_PROJECT_SET_LOCKED');
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:

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 445: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PVT'

441: EXCEPTION
442: WHEN OTHERS THEN
443:
444: -- Set the exception Message and the stack
445: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PVT'
446: ,p_procedure_name => 'Delete_Project_Set_line',
447: p_error_text => SUBSTRB(SQLERRM,1,120)
448: );
449: --