DBA Data[Home] [Help]

APPS.PA_PROJECT_SETS_PVT dependencies on FND_MSG_PUB

Line 84: IF FND_MSG_PUB.Count_Msg =0 THEN

80: END IF;
81: END IF;
82:
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'

Line 126: IF FND_MSG_PUB.Count_Msg > 0 THEN

122: ,x_msg => 'x_project_set_id = '|| x_project_set_id
123: ,x_log_level => 5);
124: END IF;
125:
126: IF FND_MSG_PUB.Count_Msg > 0 THEN
127: x_return_status := FND_API.G_RET_STS_ERROR;
128: END IF;
129:
130: EXCEPTION

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 227: IF FND_MSG_PUB.Count_Msg =0 THEN

223: END IF;
224: END IF;
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);

Line 263: IF FND_MSG_PUB.Count_Msg > 0 THEN

259: ,x_return_status => l_return_status);
260:
261: END IF;
262:
263: IF FND_MSG_PUB.Count_Msg > 0 THEN
264: x_return_status := FND_API.G_RET_STS_ERROR;
265: END IF;
266:
267: EXCEPTION

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 317: IF FND_MSG_PUB.Count_Msg = 0 THEN

313: END LOOP;
314:
315: END IF;
316:
317: IF FND_MSG_PUB.Count_Msg = 0 THEN
318:
319: l_do_lines_exist := PA_PROJECT_SET_UTILS.do_lines_exist(p_project_set_id);
320:
321: IF l_do_lines_exist = 'N' THEN

Line 332: IF FND_MSG_PUB.Count_Msg > 0 THEN

328: END IF;
329:
330: END IF;
331:
332: IF FND_MSG_PUB.Count_Msg > 0 THEN
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: END IF;
335:
336: EXCEPTION

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

Line 470: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SET_LINES_PKG.Delete_project_from_project_sets'

466:
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;