DBA Data[Home] [Help]

APPS.PA_PURGE_VALIDATE_PJRM dependencies on FND_MESSAGE

Line 95: fnd_message.set_name('PA',l_msg_name );

91: -- and set the appropriate message
92: --
93: Fetch IsAPJRMProject into l_dummy , l_msg_name ;
94: Exit When IsAPJRMProject%Notfound;
95: fnd_message.set_name('PA',l_msg_name );
96: fnd_msg_pub.add;
97: x_err_stack := x_err_stack || ' ->After open cursor ' ||l_dummy ;
98: pa_debug.debug(' * ' || l_dummy|| ' for ' || to_char(p_project_id));
99:

Line 204: fnd_message.set_name('PA', 'PA_ARPR_OPEN_REQ_EXIST');

200: OPEN CUR_REQUIREMENTS_ACTIVE;
201: FETCH CUR_REQUIREMENTS_ACTIVE INTO l_dummy;
202:
203: IF CUR_REQUIREMENTS_ACTIVE%FOUND THEN
204: fnd_message.set_name('PA', 'PA_ARPR_OPEN_REQ_EXIST');
205: fnd_msg_pub.add;
206: l_err_code := 10 ;
207:
208: l_err_stage := 'After checking for Requirements for Open Indirect Project';

Line 224: fnd_message.set_name('PA', 'PA_ARPR_CLOSED_REQ_EXIST');

220: OPEN CUR_REQUIREMENTS_CLOSED;
221: FETCH CUR_REQUIREMENTS_CLOSED INTO l_dummy;
222:
223: IF CUR_REQUIREMENTS_CLOSED%FOUND THEN
224: fnd_message.set_name('PA', 'PA_ARPR_CLOSED_REQ_EXIST');
225: fnd_msg_pub.add;
226: l_err_code := 10 ;
227: l_err_stage := 'After checking for Requirements for Closed Project';
228: l_err_stack := l_err_stack ||

Line 319: fnd_message.set_name('PA', 'PA_ARPR_CLOSED_ASGMT_EXIST');

315: OPEN CUR_ASSIGNMENTS;
316: FETCH CUR_ASSIGNMENTS INTO l_dummy;
317:
318: IF CUR_ASSIGNMENTS%FOUND THEN
319: fnd_message.set_name('PA', 'PA_ARPR_CLOSED_ASGMT_EXIST');
320: fnd_msg_pub.add;
321: l_err_code := 10 ;
322: l_err_stage := 'After checking for Assignments for Closed Project';
323: l_err_stack := l_err_stack ||

Line 509: fnd_message.set_name('PA', 'PA_PJI_UNSUMMARIZED_EXIST');

505: IF nvl(l_count_fnd, 0) = 1 OR nvl(l_count_drv, 0) = 1
506: OR nvl(l_count_cdl, 0) = 1 OR nvl(l_count_inv, 0) = 1
507: OR nvl(l_count_log, 0) = 1 THEN
508:
509: fnd_message.set_name('PA', 'PA_PJI_UNSUMMARIZED_EXIST');
510: fnd_msg_pub.add;
511: l_err_code := 10;
512: l_err_stage := 'After checking for PJI details the Project';
513: l_err_stack := l_err_stack ||

Line 549: fnd_message.set_name('PA', 'PA_PJI_MIGRATED_PROJECT');

545: FETCH chk_pji_migrated INTO l_count_migrated;
546: CLOSE chk_pji_migrated;
547:
548: IF l_count_migrated = 1 AND NVL(pa_purge_validate_pjrm.g_purge_summary_flag,'N')='Y' THEN
549: fnd_message.set_name('PA', 'PA_PJI_MIGRATED_PROJECT');
550: fnd_msg_pub.add;
551: l_err_code := 10;
552: l_err_stage:='After checking for Perf Reporting details the Project';
553: l_err_stack := l_err_stack ||