DBA Data[Home] [Help]

APPS.PA_PURGE_VALIDATE_PJRM dependencies on FND_MSG_PUB

Line 96: fnd_msg_pub.add;

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

Line 205: fnd_msg_pub.add;

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';
209: l_err_stack := l_err_stack ||

Line 225: fnd_msg_pub.add;

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 ||
229: ' ->After checking for Requirements for Closed Project';

Line 320: fnd_msg_pub.add;

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 ||
324: ' ->After checking for Assignments for Closed Project';

Line 510: fnd_msg_pub.add;

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 ||
514: ' ->After checking for PJI details for the Project';

Line 550: fnd_msg_pub.add;

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 ||
554: ' ->After checking for Perf Reporting details for the Project';