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_TASKS_MAINT_UTILS dependencies on FND_API

Line 151: x_return_status := FND_API.G_RET_STS_SUCCESS;

147:
148: END IF;
149: END IF;
150:
151: x_return_status := FND_API.G_RET_STS_SUCCESS;
152: EXCEPTION
153: WHEN NO_DATA_FOUND THEN
154: x_task_mgr_id := NULL;
155: x_return_status := FND_API.G_RET_STS_ERROR;

Line 155: x_return_status := FND_API.G_RET_STS_ERROR;

151: x_return_status := FND_API.G_RET_STS_SUCCESS;
152: EXCEPTION
153: WHEN NO_DATA_FOUND THEN
154: x_task_mgr_id := NULL;
155: x_return_status := FND_API.G_RET_STS_ERROR;
156: x_error_msg_code := 'PA_TASK_MGR_ID_INVALID';
157: WHEN TOO_MANY_ROWS THEN
158: x_task_mgr_id := NULL;
159: x_return_status := FND_API.G_RET_STS_ERROR;

Line 159: x_return_status := FND_API.G_RET_STS_ERROR;

155: x_return_status := FND_API.G_RET_STS_ERROR;
156: x_error_msg_code := 'PA_TASK_MGR_ID_INVALID';
157: WHEN TOO_MANY_ROWS THEN
158: x_task_mgr_id := NULL;
159: x_return_status := FND_API.G_RET_STS_ERROR;
160: x_error_msg_code := 'PA_TASK_MGR_ID_NOT_UNIQUE';
161: WHEN OTHERS THEN
162: x_task_mgr_id := NULL;
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

159: x_return_status := FND_API.G_RET_STS_ERROR;
160: x_error_msg_code := 'PA_TASK_MGR_ID_NOT_UNIQUE';
161: WHEN OTHERS THEN
162: x_task_mgr_id := NULL;
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: -- 4537865 : RESET x_error_msg_code also
165: x_error_msg_code := SQLCODE;
166:
167: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_UTILS',

Line 245: x_return_status := FND_API.G_RET_STS_SUCCESS;

241: END IF;
242: END IF;
243: END IF;
244:
245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246: EXCEPTION
247: WHEN NO_DATA_FOUND THEN
248: x_project_id := NULL;
249: x_return_status := FND_API.G_RET_STS_ERROR;

Line 249: x_return_status := FND_API.G_RET_STS_ERROR;

245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246: EXCEPTION
247: WHEN NO_DATA_FOUND THEN
248: x_project_id := NULL;
249: x_return_status := FND_API.G_RET_STS_ERROR;
250: x_error_msg_code := 'PA_TASK_INV_PRJ_ID';
251: WHEN TOO_MANY_ROWS THEN
252: x_project_id := NULL;
253: x_return_status := FND_API.G_RET_STS_ERROR;

Line 253: x_return_status := FND_API.G_RET_STS_ERROR;

249: x_return_status := FND_API.G_RET_STS_ERROR;
250: x_error_msg_code := 'PA_TASK_INV_PRJ_ID';
251: WHEN TOO_MANY_ROWS THEN
252: x_project_id := NULL;
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: x_error_msg_code := 'PA_TASK_PRJ_ID_NOT_UNIQ';
255: WHEN OTHERS THEN
256: x_project_id := NULL;
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

253: x_return_status := FND_API.G_RET_STS_ERROR;
254: x_error_msg_code := 'PA_TASK_PRJ_ID_NOT_UNIQ';
255: WHEN OTHERS THEN
256: x_project_id := NULL;
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: -- 4537865 : RESET x_error_msg_code also
259: x_error_msg_code := SQLCODE ;
260:
261: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_UTILS',

Line 340: x_return_status := FND_API.G_RET_STS_SUCCESS;

336: END IF;
337: END IF;
338: END IF;
339:
340: x_return_status := FND_API.G_RET_STS_SUCCESS;
341: EXCEPTION
342: WHEN NO_DATA_FOUND THEN
343: x_task_id := NULL;
344: x_return_status := FND_API.G_RET_STS_ERROR;

Line 344: x_return_status := FND_API.G_RET_STS_ERROR;

340: x_return_status := FND_API.G_RET_STS_SUCCESS;
341: EXCEPTION
342: WHEN NO_DATA_FOUND THEN
343: x_task_id := NULL;
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: x_error_msg_code := 'PA_TASK_ID_INVALID';
346: WHEN TOO_MANY_ROWS THEN
347: x_task_id := NULL;
348: x_return_status := FND_API.G_RET_STS_ERROR;

Line 348: x_return_status := FND_API.G_RET_STS_ERROR;

344: x_return_status := FND_API.G_RET_STS_ERROR;
345: x_error_msg_code := 'PA_TASK_ID_INVALID';
346: WHEN TOO_MANY_ROWS THEN
347: x_task_id := NULL;
348: x_return_status := FND_API.G_RET_STS_ERROR;
349: x_error_msg_code := 'PA_TASK_ID_NOT_UNIQUE';
350: WHEN OTHERS THEN
351: x_task_id := NULL;
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

348: x_return_status := FND_API.G_RET_STS_ERROR;
349: x_error_msg_code := 'PA_TASK_ID_NOT_UNIQUE';
350: WHEN OTHERS THEN
351: x_task_id := NULL;
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
353: -- 4537865 : RESET x_error_msg_code also
354: x_error_msg_code := SQLCODE;
355:
356: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_UTILS',

Line 494: RAISE FND_API.G_EXC_ERROR;

490: IF (p_start_date IS NOT NULL and
491: l_start_date > p_start_date) THEN
492: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');
493: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
494: RAISE FND_API.G_EXC_ERROR;
495: END IF;
496:
497: IF (l_end_date IS NOT NULL and
498: p_start_date > l_end_date) THEN

Line 501: RAISE FND_API.G_EXC_ERROR;

497: IF (l_end_date IS NOT NULL and
498: p_start_date > l_end_date) THEN
499: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');
500: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
501: RAISE FND_API.G_EXC_ERROR;
502: END IF;
503:
504: ELSE -- NOT A TOP TASK, compare with parent task
505: --select parent task start date

Line 514: RAISE FND_API.G_EXC_ERROR;

510: IF (p_start_date is NOT NULL and
511: l_start_date > p_start_date) THEN
512: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_TASK_GREATER');
513: x_msg_data := 'PA_PARENT_TASK_GREATER';
514: RAISE FND_API.G_EXC_ERROR;
515: END IF;
516: IF (l_end_date IS NOT NULL and
517: p_start_date > l_end_date) THEN
518: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_TASK_GREATER');

Line 520: RAISE FND_API.G_EXC_ERROR;

516: IF (l_end_date IS NOT NULL and
517: p_start_date > l_end_date) THEN
518: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_TASK_GREATER');
519: x_msg_data := 'PA_PARENT_TASK_GREATER';
520: RAISE FND_API.G_EXC_ERROR;
521: END IF;
522:
523: -- Bug Start 6163119
524: select start_date, completion_date

Line 543: RAISE FND_API.G_EXC_ERROR;

539: IF p_start_date IS NOT NULL AND l_start_date IS NULL THEN
540: IF l_tstart_date IS NOT NULL THEN
541: IF(l_tstart_date > p_start_date) THEN
542: x_msg_data := 'PA_PARENT_TASK_GREATER';
543: RAISE FND_API.G_EXC_ERROR;
544: END IF;
545: ELSIF l_pstart_date IS NOT NULL THEN
546: IF(l_pstart_date > p_start_date) THEN
547: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';

Line 548: RAISE FND_API.G_EXC_ERROR;

544: END IF;
545: ELSIF l_pstart_date IS NOT NULL THEN
546: IF(l_pstart_date > p_start_date) THEN
547: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
548: RAISE FND_API.G_EXC_ERROR;
549: END IF;
550: END IF;
551: END IF;
552:

Line 558: RAISE FND_API.G_EXC_ERROR;

554: IF p_start_date IS NOT NULL AND l_end_date IS NULL THEN
555: IF l_tend_date IS NOT NULL THEN
556: IF (p_start_date > l_tend_date) THEN
557: x_msg_data := 'PA_PARENT_TASK_GREATER';
558: RAISE FND_API.G_EXC_ERROR;
559: END IF;
560: ELSIF l_pend_date IS NOT NULL THEN
561: IF(p_start_date > l_pend_date) THEN
562: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';

Line 563: RAISE FND_API.G_EXC_ERROR;

559: END IF;
560: ELSIF l_pend_date IS NOT NULL THEN
561: IF(p_start_date > l_pend_date) THEN
562: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
563: RAISE FND_API.G_EXC_ERROR;
564: END IF;
565: END IF;
566: END IF;
567:

Line 585: RAISE FND_API.G_EXC_ERROR;

581: l_start_date < p_start_date) THEN -- Bug 7386335
582: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_CHILD_TASK_DATE_EARLIER');
583: x_msg_data := 'PA_CHILD_TASK_DATE_EARLIER';
584: CLOSE c1;
585: RAISE FND_API.G_EXC_ERROR;
586: END IF;
587: IF (l_end_date IS NOT NULL and
588: p_start_date > l_end_date) THEN
589: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_CHILD_TASK_DATE_EARLIER');

Line 592: RAISE FND_API.G_EXC_ERROR;

588: p_start_date > l_end_date) THEN
589: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_CHILD_TASK_DATE_EARLIER');
590: x_msg_data := 'PA_CHILD_TASK_DATE_EARLIER';
591: CLOSE c1;
592: RAISE FND_API.G_EXC_ERROR;
593: END IF;
594: END LOOP;
595: CLOSE c1;
596: END IF;

Line 597: x_return_status := FND_API.G_RET_STS_SUCCESS;

593: END IF;
594: END LOOP;
595: CLOSE c1;
596: END IF;
597: x_return_status := FND_API.G_RET_STS_SUCCESS;
598:
599: EXCEPTION
600: WHEN FND_API.G_EXC_ERROR THEN
601: x_return_status := FND_API.G_RET_STS_ERROR;

Line 600: WHEN FND_API.G_EXC_ERROR THEN

596: END IF;
597: x_return_status := FND_API.G_RET_STS_SUCCESS;
598:
599: EXCEPTION
600: WHEN FND_API.G_EXC_ERROR THEN
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: x_msg_count := FND_MSG_PUB.count_msg;
603: WHEN OTHERS THEN
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 601: x_return_status := FND_API.G_RET_STS_ERROR;

597: x_return_status := FND_API.G_RET_STS_SUCCESS;
598:
599: EXCEPTION
600: WHEN FND_API.G_EXC_ERROR THEN
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: x_msg_count := FND_MSG_PUB.count_msg;
603: WHEN OTHERS THEN
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
605: -- 4537865 : RESET other OUT params too

Line 604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

600: WHEN FND_API.G_EXC_ERROR THEN
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: x_msg_count := FND_MSG_PUB.count_msg;
603: WHEN OTHERS THEN
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
605: -- 4537865 : RESET other OUT params too
606: x_msg_count := 1;
607: x_msg_data := SUBSTRB(SQLERRM ,1,240);
608:

Line 653: RAISE FND_API.G_EXC_ERROR;

649: IF (p_end_date IS NOT NULL and
650: l_end_date < p_end_date) THEN
651: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');
652: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
653: RAISE FND_API.G_EXC_ERROR;
654: END IF;
655: IF (p_end_date IS NOT NULL and
656: l_start_date > p_end_date) THEN
657: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');

Line 659: RAISE FND_API.G_EXC_ERROR;

655: IF (p_end_date IS NOT NULL and
656: l_start_date > p_end_date) THEN
657: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');
658: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
659: RAISE FND_API.G_EXC_ERROR;
660: END IF;
661:
662: ELSE -- NOT A TOP TASK, compare with parent task
663: --select parent task completion date

Line 672: RAISE FND_API.G_EXC_ERROR;

668: IF (p_end_date is NOT NULL and
669: l_end_date < p_end_date) THEN
670: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_COMPLETION_EARLIER');
671: x_msg_data := 'PA_PARENT_COMPLETION_EARLIER';
672: RAISE FND_API.G_EXC_ERROR;
673: END IF;
674: IF (p_end_date is NOT NULL and
675: l_start_date > p_end_date) THEN
676: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_COMPLETION_EARLIER');

Line 678: RAISE FND_API.G_EXC_ERROR;

674: IF (p_end_date is NOT NULL and
675: l_start_date > p_end_date) THEN
676: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_COMPLETION_EARLIER');
677: x_msg_data := 'PA_PARENT_COMPLETION_EARLIER';
678: RAISE FND_API.G_EXC_ERROR;
679: END IF;
680:
681: -- Bug Start 6163119
682: select start_date, completion_date

Line 701: RAISE FND_API.G_EXC_ERROR;

697: IF p_end_date IS NOT NULL AND l_end_date IS NULL THEN
698: IF l_tend_date IS NOT NULL THEN
699: IF (l_tend_date < p_end_date) THEN
700: x_msg_data := 'PA_PARENT_COMPLETION_EARLIER';
701: RAISE FND_API.G_EXC_ERROR;
702: END IF;
703: ELSIF l_pend_date IS NOT NULL THEN
704: IF (l_pend_date < p_end_date) THEN
705: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';

Line 706: RAISE FND_API.G_EXC_ERROR;

702: END IF;
703: ELSIF l_pend_date IS NOT NULL THEN
704: IF (l_pend_date < p_end_date) THEN
705: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
706: RAISE FND_API.G_EXC_ERROR;
707: END IF;
708: END IF;
709: END IF;
710:

Line 716: RAISE FND_API.G_EXC_ERROR;

712: IF p_end_date IS NOT NULL AND l_start_date IS NULL THEN
713: IF l_tstart_date IS NOT NULL THEN
714: IF(l_tstart_date > p_end_date) THEN
715: x_msg_data := 'PA_PARENT_COMPLETION_EARLIER';
716: RAISE FND_API.G_EXC_ERROR;
717: END IF;
718: ELSIF l_pstart_date is NOT NULL THEN
719: IF(l_pstart_date > p_end_date) THEN
720: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';

Line 721: RAISE FND_API.G_EXC_ERROR;

717: END IF;
718: ELSIF l_pstart_date is NOT NULL THEN
719: IF(l_pstart_date > p_end_date) THEN
720: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
721: RAISE FND_API.G_EXC_ERROR;
722: END IF;
723: END IF;
724: END IF;
725:

Line 742: RAISE FND_API.G_EXC_ERROR;

738: l_end_date > p_end_date) THEN
739: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_CHILD_COMPLETION_LATER');
740: x_msg_data := 'PA_CHILD_COMPLETION_LATER';
741: CLOSE c1;
742: RAISE FND_API.G_EXC_ERROR;
743: END IF;
744: IF (p_end_date is NOT NULL and
745: l_start_date > p_end_date) THEN
746: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_TASK_GREATER');

Line 749: RAISE FND_API.G_EXC_ERROR;

745: l_start_date > p_end_date) THEN
746: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_TASK_GREATER');
747: x_msg_data := 'PA_CHILD_COMPLETION_LATER';
748: CLOSE c1;
749: RAISE FND_API.G_EXC_ERROR;
750: END IF;
751:
752: END LOOP;
753: CLOSE c1;

Line 755: x_return_status := FND_API.G_RET_STS_SUCCESS;

751:
752: END LOOP;
753: CLOSE c1;
754: END IF;
755: x_return_status := FND_API.G_RET_STS_SUCCESS;
756:
757: EXCEPTION
758: WHEN FND_API.G_EXC_ERROR THEN
759: x_return_status := FND_API.G_RET_STS_ERROR;

Line 758: WHEN FND_API.G_EXC_ERROR THEN

754: END IF;
755: x_return_status := FND_API.G_RET_STS_SUCCESS;
756:
757: EXCEPTION
758: WHEN FND_API.G_EXC_ERROR THEN
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: x_msg_count := FND_MSG_PUB.count_msg;
761: WHEN OTHERS THEN
762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 759: x_return_status := FND_API.G_RET_STS_ERROR;

755: x_return_status := FND_API.G_RET_STS_SUCCESS;
756:
757: EXCEPTION
758: WHEN FND_API.G_EXC_ERROR THEN
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: x_msg_count := FND_MSG_PUB.count_msg;
761: WHEN OTHERS THEN
762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
763: -- 4537865 : RESET other OUT params too

Line 762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

758: WHEN FND_API.G_EXC_ERROR THEN
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: x_msg_count := FND_MSG_PUB.count_msg;
761: WHEN OTHERS THEN
762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
763: -- 4537865 : RESET other OUT params too
764: x_msg_count := 1;
765: x_msg_data := SUBSTRB(SQLERRM ,1,240);
766: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_UTILS',

Line 854: RAISE FND_API.G_EXC_ERROR;

850: --commenting the following line after discussing with
851: --sakthi. The reason is that there are two messages being appended
852: --for the same error.
853: --x_msg_data := 'PA_INVALID_SCH_DATES';
854: RAISE FND_API.G_EXC_ERROR;
855: END IF;
856: END IF;
857:
858: OPEN c1;

Line 864: RAISE FND_API.G_EXC_ERROR;

860: IF c1%NOTFOUND THEN
861: PA_UTILS.ADD_MESSAGE('PA', 'PA_PROJ_NOT_EXIST');
862: x_msg_data := 'PA_PROJ_NOT_EXIST';
863: CLOSE c1;
864: RAISE FND_API.G_EXC_ERROR;
865: END IF;
866: CLOSE c1;
867:
868: IF (p_sch_start_date IS NOT NULL and l_start_date > p_sch_start_date) THEN

Line 871: RAISE FND_API.G_EXC_ERROR;

867:
868: IF (p_sch_start_date IS NOT NULL and l_start_date > p_sch_start_date) THEN
869: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_SCH_DATE_OUTSIDE_PROJ_RANGE');
870: x_msg_data := 'PA_SCH_DATE_OUTSIDE_PROJ_RANGE';
871: RAISE FND_API.G_EXC_ERROR;
872: END IF;
873:
874: IF (p_sch_end_date IS NOT NULL and l_finish_date < p_sch_end_date) THEN
875: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_SCH_DATE_OUTSIDE_PROJ_RANGE');

Line 877: RAISE FND_API.G_EXC_ERROR;

873:
874: IF (p_sch_end_date IS NOT NULL and l_finish_date < p_sch_end_date) THEN
875: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_SCH_DATE_OUTSIDE_PROJ_RANGE');
876: x_msg_data := 'PA_SCH_DATE_OUTSIDE_PROJ_RANGE';
877: RAISE FND_API.G_EXC_ERROR;
878: END IF;
879:
880: x_msg_data := NULL;
881: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 881: x_return_status := FND_API.G_RET_STS_SUCCESS;

877: RAISE FND_API.G_EXC_ERROR;
878: END IF;
879:
880: x_msg_data := NULL;
881: x_return_status := FND_API.G_RET_STS_SUCCESS;
882: EXCEPTION
883: WHEN FND_API.G_EXC_ERROR THEN
884: x_return_status := FND_API.G_RET_STS_ERROR;
885: x_msg_count := FND_MSG_PUB.count_msg;

Line 883: WHEN FND_API.G_EXC_ERROR THEN

879:
880: x_msg_data := NULL;
881: x_return_status := FND_API.G_RET_STS_SUCCESS;
882: EXCEPTION
883: WHEN FND_API.G_EXC_ERROR THEN
884: x_return_status := FND_API.G_RET_STS_ERROR;
885: x_msg_count := FND_MSG_PUB.count_msg;
886: WHEN OTHERS THEN
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 884: x_return_status := FND_API.G_RET_STS_ERROR;

880: x_msg_data := NULL;
881: x_return_status := FND_API.G_RET_STS_SUCCESS;
882: EXCEPTION
883: WHEN FND_API.G_EXC_ERROR THEN
884: x_return_status := FND_API.G_RET_STS_ERROR;
885: x_msg_count := FND_MSG_PUB.count_msg;
886: WHEN OTHERS THEN
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
888: -- 4537865 : RESET other OUT params too

Line 887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

883: WHEN FND_API.G_EXC_ERROR THEN
884: x_return_status := FND_API.G_RET_STS_ERROR;
885: x_msg_count := FND_MSG_PUB.count_msg;
886: WHEN OTHERS THEN
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
888: -- 4537865 : RESET other OUT params too
889: x_msg_count := 1;
890: x_msg_data := SUBSTRB(SQLERRM ,1,240);
891:

Line 925: RAISE FND_API.G_EXC_ERROR;

921: p_return_status => l_ret);
922: IF (l_ret <> 'S') THEN
923: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_INVALID_EST_DATES');
924: x_msg_data := 'PA_INVALID_EST_DATES';
925: RAISE FND_API.G_EXC_ERROR;
926: END IF;
927: END IF;
928:
929: x_msg_data := NULL;

Line 930: x_return_status := FND_API.G_RET_STS_SUCCESS;

926: END IF;
927: END IF;
928:
929: x_msg_data := NULL;
930: x_return_status := FND_API.G_RET_STS_SUCCESS;
931:
932: EXCEPTION
933: WHEN FND_API.G_EXC_ERROR THEN
934: x_return_status := FND_API.G_RET_STS_ERROR;

Line 933: WHEN FND_API.G_EXC_ERROR THEN

929: x_msg_data := NULL;
930: x_return_status := FND_API.G_RET_STS_SUCCESS;
931:
932: EXCEPTION
933: WHEN FND_API.G_EXC_ERROR THEN
934: x_return_status := FND_API.G_RET_STS_ERROR;
935: x_msg_count := FND_MSG_PUB.count_msg;
936: WHEN OTHERS THEN
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 934: x_return_status := FND_API.G_RET_STS_ERROR;

930: x_return_status := FND_API.G_RET_STS_SUCCESS;
931:
932: EXCEPTION
933: WHEN FND_API.G_EXC_ERROR THEN
934: x_return_status := FND_API.G_RET_STS_ERROR;
935: x_msg_count := FND_MSG_PUB.count_msg;
936: WHEN OTHERS THEN
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: -- 4537865 : RESET other OUT params too

Line 937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

933: WHEN FND_API.G_EXC_ERROR THEN
934: x_return_status := FND_API.G_RET_STS_ERROR;
935: x_msg_count := FND_MSG_PUB.count_msg;
936: WHEN OTHERS THEN
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: -- 4537865 : RESET other OUT params too
939: x_msg_count := 1;
940: x_msg_data := SUBSTRB(SQLERRM ,1,240);
941: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_UTILS',

Line 974: RAISE FND_API.G_EXC_ERROR;

970: p_return_status => l_ret);
971: IF (l_ret <> 'S') THEN
972: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_INVALID_ACTUAL_DATES');
973: x_msg_data := 'PA_INVALID_ACTUAL_DATES';
974: RAISE FND_API.G_EXC_ERROR;
975: END IF;
976: END IF;
977:
978: x_msg_data := NULL;

Line 979: x_return_status := FND_API.G_RET_STS_SUCCESS;

975: END IF;
976: END IF;
977:
978: x_msg_data := NULL;
979: x_return_status := FND_API.G_RET_STS_SUCCESS;
980:
981: EXCEPTION
982: WHEN FND_API.G_EXC_ERROR THEN
983: x_return_status := FND_API.G_RET_STS_ERROR;

Line 982: WHEN FND_API.G_EXC_ERROR THEN

978: x_msg_data := NULL;
979: x_return_status := FND_API.G_RET_STS_SUCCESS;
980:
981: EXCEPTION
982: WHEN FND_API.G_EXC_ERROR THEN
983: x_return_status := FND_API.G_RET_STS_ERROR;
984: x_msg_count := FND_MSG_PUB.count_msg;
985: WHEN OTHERS THEN
986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 983: x_return_status := FND_API.G_RET_STS_ERROR;

979: x_return_status := FND_API.G_RET_STS_SUCCESS;
980:
981: EXCEPTION
982: WHEN FND_API.G_EXC_ERROR THEN
983: x_return_status := FND_API.G_RET_STS_ERROR;
984: x_msg_count := FND_MSG_PUB.count_msg;
985: WHEN OTHERS THEN
986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
987: -- 4537865 : RESET other OUT params too

Line 986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

982: WHEN FND_API.G_EXC_ERROR THEN
983: x_return_status := FND_API.G_RET_STS_ERROR;
984: x_msg_count := FND_MSG_PUB.count_msg;
985: WHEN OTHERS THEN
986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
987: -- 4537865 : RESET other OUT params too
988: x_msg_count := 1;
989: x_msg_data := SUBSTRB(SQLERRM ,1,240);
990: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_UTILS',

Line 1104: x_return_status := FND_API.G_RET_STS_SUCCESS;

1100: l_parent_task_id NUMBER;
1101: l_project_id NUMBER;
1102:
1103: BEGIN
1104: x_return_status := FND_API.G_RET_STS_SUCCESS;
1105: IF p_reference_task_id IS NULL
1106: THEN
1107: x_return_status := FND_API.G_RET_STS_ERROR;
1108: x_error_msg_code := 'PA_PRJ_TASK_ID_REQ';

Line 1107: x_return_status := FND_API.G_RET_STS_ERROR;

1103: BEGIN
1104: x_return_status := FND_API.G_RET_STS_SUCCESS;
1105: IF p_reference_task_id IS NULL
1106: THEN
1107: x_return_status := FND_API.G_RET_STS_ERROR;
1108: x_error_msg_code := 'PA_PRJ_TASK_ID_REQ';
1109: RAISE FND_API.G_EXC_ERROR;
1110: END IF;
1111:

Line 1109: RAISE FND_API.G_EXC_ERROR;

1105: IF p_reference_task_id IS NULL
1106: THEN
1107: x_return_status := FND_API.G_RET_STS_ERROR;
1108: x_error_msg_code := 'PA_PRJ_TASK_ID_REQ';
1109: RAISE FND_API.G_EXC_ERROR;
1110: END IF;
1111:
1112: IF p_task_type IS NULL
1113: THEN

Line 1114: x_return_status := FND_API.G_RET_STS_ERROR;

1110: END IF;
1111:
1112: IF p_task_type IS NULL
1113: THEN
1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115: x_error_msg_code := 'PA_PRJ_TASK_TYPE_REQ';
1116: RAISE FND_API.G_EXC_ERROR;
1117: END IF;
1118:

Line 1116: RAISE FND_API.G_EXC_ERROR;

1112: IF p_task_type IS NULL
1113: THEN
1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115: x_error_msg_code := 'PA_PRJ_TASK_TYPE_REQ';
1116: RAISE FND_API.G_EXC_ERROR;
1117: END IF;
1118:
1119: IF p_task_type = 'SUB'
1120: THEN

Line 1170: WHEN FND_API.G_EXC_ERROR THEN

1166: END IF;
1167: END IF;
1168:
1169: EXCEPTION
1170: WHEN FND_API.G_EXC_ERROR THEN
1171: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1172: -- 4537865 : RESET other OUT params too
1173: x_carrying_out_org_id := NULL ;
1174: x_carrying_out_org_name := NULL ;

Line 1171: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

1167: END IF;
1168:
1169: EXCEPTION
1170: WHEN FND_API.G_EXC_ERROR THEN
1171: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1172: -- 4537865 : RESET other OUT params too
1173: x_carrying_out_org_id := NULL ;
1174: x_carrying_out_org_name := NULL ;
1175: x_work_type_id := NULL ;

Line 1181: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

1177: x_service_type_code := NULL ;
1178: x_service_type_name := NULL ;
1179:
1180: WHEN OTHERS THEN
1181: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1182: -- 4537865 : Start
1183: x_carrying_out_org_id := NULL ;
1184: x_carrying_out_org_name := NULL ;
1185: x_work_type_id := NULL ;

Line 1257: x_return_status := FND_API.G_RET_STS_SUCCESS;

1253: l_record_found VARCHAR2(1) := 'N';
1254: l_num_of_records NUMBER;
1255:
1256: BEGIN
1257: x_return_status := FND_API.G_RET_STS_SUCCESS;
1258: OPEN cur_pa_tasks_sub;
1259: LOOP
1260: FETCH cur_pa_tasks_sub INTO x_carrying_out_org_id
1261: ,x_carrying_out_org_name

Line 1288: x_return_status:= FND_API.G_RET_STS_ERROR;

1284: RAISE NO_DATA_FOUND;
1285: END IF;
1286: EXCEPTION
1287: WHEN no_data_found THEN
1288: x_return_status:= FND_API.G_RET_STS_ERROR;
1289: -- 4537865 : Start
1290: x_carrying_out_org_id := NULL ;
1291: x_carrying_out_org_name := NULL ;
1292: x_work_type_id := NULL ;

Line 1298: x_return_status:= FND_API.G_RET_STS_ERROR;

1294: x_service_type_code := NULL ;
1295: x_service_type_name := NULL ;
1296: -- 4537865 : End
1297: WHEN too_many_rows THEN
1298: x_return_status:= FND_API.G_RET_STS_ERROR;
1299: -- 4537865 : Start
1300: x_carrying_out_org_id := NULL ;
1301: x_carrying_out_org_name := NULL ;
1302: x_work_type_id := NULL ;

Line 1309: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

1305: x_service_type_name := NULL ;
1306:
1307: -- 4537865 : End
1308: WHEN OTHERS THEN
1309: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1310: -- 4537865 : Start
1311: x_carrying_out_org_id := NULL ;
1312: x_carrying_out_org_name := NULL ;
1313: x_work_type_id := NULL ;

Line 1390: x_return_status := FND_API.G_RET_STS_SUCCESS;

1386: l_record_found VARCHAR2(1) := 'N';
1387: l_num_of_records NUMBER;
1388:
1389: BEGIN
1390: x_return_status := FND_API.G_RET_STS_SUCCESS;
1391: OPEN cur_pa_project;
1392: LOOP
1393: FETCH cur_pa_project INTO x_carrying_out_org_id
1394: ,x_carrying_out_org_name

Line 1421: x_return_status:= FND_API.G_RET_STS_ERROR;

1417: RAISE NO_DATA_FOUND;
1418: END IF;
1419: EXCEPTION
1420: WHEN no_data_found THEN
1421: x_return_status:= FND_API.G_RET_STS_ERROR;
1422: -- 4537865 :Start
1423: x_carrying_out_org_id := NULL ;
1424: x_carrying_out_org_name := NULL ;
1425: x_work_type_id := NULL ;

Line 1432: x_return_status:= FND_API.G_RET_STS_ERROR;

1428: x_service_type_name := NULL ;
1429:
1430: -- 4537865 :End
1431: WHEN too_many_rows THEN
1432: x_return_status:= FND_API.G_RET_STS_ERROR;
1433: -- 4537865 :Start
1434: x_carrying_out_org_id := NULL ;
1435: x_carrying_out_org_name := NULL ;
1436: x_work_type_id := NULL ;

Line 1443: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

1439: x_service_type_name := NULL ;
1440:
1441: -- 4537865 :End
1442: WHEN OTHERS THEN
1443: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1444: -- 4537865 :Start
1445: x_carrying_out_org_id := NULL ;
1446: x_carrying_out_org_name := NULL ;
1447: x_work_type_id := NULL ;

Line 1575: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1571: AND ppev.proj_element_id = pt.task_id;
1572:
1573: BEGIN
1574:
1575: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1576:
1577: OPEN cur_wbs_above;
1578: FETCH cur_wbs_above INTO x_task_level_above, x_task_id_above, x_top_task_id_above,
1579: x_parent_task_id_above, x_display_sequence_above;

Line 1589: x_return_status:= FND_API.G_RET_STS_ERROR;

1585: CLOSE cur_wbs;
1586:
1587: EXCEPTION
1588: WHEN OTHERS THEN
1589: x_return_status:= FND_API.G_RET_STS_ERROR;
1590: -- 4537865 : Start
1591: x_task_level := 1 ; -- set task level as 1 so that ,caller API throws error properly
1592: x_parent_task_id := NULL ;
1593: x_top_task_id := NULL ;

Line 1628: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1624: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
1625: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1626: ) AS
1627: BEGIN
1628: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1629: IF p_reference_project_id IS NULL OR p_reference_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1630: THEN
1631: x_error_msg_code := 'PA_TASK_TARGET_PRJ_ID_REQ';
1632: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 1632: x_return_status:= FND_API.G_RET_STS_ERROR;

1628: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1629: IF p_reference_project_id IS NULL OR p_reference_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1630: THEN
1631: x_error_msg_code := 'PA_TASK_TARGET_PRJ_ID_REQ';
1632: x_return_status:= FND_API.G_RET_STS_ERROR;
1633: RAISE FND_API.G_EXC_ERROR;
1634: END IF;
1635:
1636: IF p_reference_task_id IS NULL OR p_reference_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1633: RAISE FND_API.G_EXC_ERROR;

1629: IF p_reference_project_id IS NULL OR p_reference_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1630: THEN
1631: x_error_msg_code := 'PA_TASK_TARGET_PRJ_ID_REQ';
1632: x_return_status:= FND_API.G_RET_STS_ERROR;
1633: RAISE FND_API.G_EXC_ERROR;
1634: END IF;
1635:
1636: IF p_reference_task_id IS NULL OR p_reference_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1637: THEN

Line 1639: x_return_status:= FND_API.G_RET_STS_ERROR;

1635:
1636: IF p_reference_task_id IS NULL OR p_reference_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1637: THEN
1638: x_error_msg_code := 'PA_TASK_TARGET_TASK_ID_REQ';
1639: x_return_status:= FND_API.G_RET_STS_ERROR;
1640: RAISE FND_API.G_EXC_ERROR;
1641: END IF;
1642: EXCEPTION
1643: WHEN FND_API.G_EXC_ERROR THEN

Line 1640: RAISE FND_API.G_EXC_ERROR;

1636: IF p_reference_task_id IS NULL OR p_reference_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1637: THEN
1638: x_error_msg_code := 'PA_TASK_TARGET_TASK_ID_REQ';
1639: x_return_status:= FND_API.G_RET_STS_ERROR;
1640: RAISE FND_API.G_EXC_ERROR;
1641: END IF;
1642: EXCEPTION
1643: WHEN FND_API.G_EXC_ERROR THEN
1644: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 1643: WHEN FND_API.G_EXC_ERROR THEN

1639: x_return_status:= FND_API.G_RET_STS_ERROR;
1640: RAISE FND_API.G_EXC_ERROR;
1641: END IF;
1642: EXCEPTION
1643: WHEN FND_API.G_EXC_ERROR THEN
1644: x_return_status:= FND_API.G_RET_STS_ERROR;
1645: END REF_PRJ_TASK_ID_REQ_CHECK;
1646:
1647:

Line 1644: x_return_status:= FND_API.G_RET_STS_ERROR;

1640: RAISE FND_API.G_EXC_ERROR;
1641: END IF;
1642: EXCEPTION
1643: WHEN FND_API.G_EXC_ERROR THEN
1644: x_return_status:= FND_API.G_RET_STS_ERROR;
1645: END REF_PRJ_TASK_ID_REQ_CHECK;
1646:
1647:
1648: -- API name : SRC_PRJ_TASK_ID_REQ_CHECK

Line 1671: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1667: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
1668: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1669: ) AS
1670: BEGIN
1671: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1672: IF p_project_id IS NULL OR p_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1673: THEN
1674: x_error_msg_code := 'PA_TASK_SOURCE_PRJ_ID_REQ';
1675: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 1675: x_return_status:= FND_API.G_RET_STS_ERROR;

1671: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1672: IF p_project_id IS NULL OR p_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1673: THEN
1674: x_error_msg_code := 'PA_TASK_SOURCE_PRJ_ID_REQ';
1675: x_return_status:= FND_API.G_RET_STS_ERROR;
1676: RAISE FND_API.G_EXC_ERROR;
1677: END IF;
1678:
1679: IF p_task_id IS NULL OR p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1676: RAISE FND_API.G_EXC_ERROR;

1672: IF p_project_id IS NULL OR p_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1673: THEN
1674: x_error_msg_code := 'PA_TASK_SOURCE_PRJ_ID_REQ';
1675: x_return_status:= FND_API.G_RET_STS_ERROR;
1676: RAISE FND_API.G_EXC_ERROR;
1677: END IF;
1678:
1679: IF p_task_id IS NULL OR p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1680: THEN

Line 1682: x_return_status:= FND_API.G_RET_STS_ERROR;

1678:
1679: IF p_task_id IS NULL OR p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1680: THEN
1681: x_error_msg_code := 'PA_TASK_SOURCE_TASK_ID_REQ';
1682: x_return_status:= FND_API.G_RET_STS_ERROR;
1683: RAISE FND_API.G_EXC_ERROR;
1684: END IF;
1685: EXCEPTION
1686: WHEN FND_API.G_EXC_ERROR THEN

Line 1683: RAISE FND_API.G_EXC_ERROR;

1679: IF p_task_id IS NULL OR p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1680: THEN
1681: x_error_msg_code := 'PA_TASK_SOURCE_TASK_ID_REQ';
1682: x_return_status:= FND_API.G_RET_STS_ERROR;
1683: RAISE FND_API.G_EXC_ERROR;
1684: END IF;
1685: EXCEPTION
1686: WHEN FND_API.G_EXC_ERROR THEN
1687: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 1686: WHEN FND_API.G_EXC_ERROR THEN

1682: x_return_status:= FND_API.G_RET_STS_ERROR;
1683: RAISE FND_API.G_EXC_ERROR;
1684: END IF;
1685: EXCEPTION
1686: WHEN FND_API.G_EXC_ERROR THEN
1687: x_return_status:= FND_API.G_RET_STS_ERROR;
1688: END SRC_PRJ_TASK_ID_REQ_CHECK;
1689:
1690:

Line 1687: x_return_status:= FND_API.G_RET_STS_ERROR;

1683: RAISE FND_API.G_EXC_ERROR;
1684: END IF;
1685: EXCEPTION
1686: WHEN FND_API.G_EXC_ERROR THEN
1687: x_return_status:= FND_API.G_RET_STS_ERROR;
1688: END SRC_PRJ_TASK_ID_REQ_CHECK;
1689:
1690:
1691: --procedure from pa_project_check_pvt.check_start_end_date_Pvt

Line 1707: p_return_status := FND_API.G_RET_STS_SUCCESS;

1703: l_start_date DATE;
1704: l_end_date DATE;
1705: l_meaning pa_lookups.meaning%TYPE;
1706: BEGIN
1707: p_return_status := FND_API.G_RET_STS_SUCCESS;
1708:
1709: -- added by hsiu
1710: -- set token
1711: IF p_context = 'START' then

Line 1766: RAISE FND_API.G_EXC_ERROR;

1762: --hsiu: commented for bug 2686499
1763: -- fnd_message.set_token('PA_DATE',l_meaning);
1764: fnd_msg_pub.add;
1765: END IF;
1766: RAISE FND_API.G_EXC_ERROR;
1767: END IF;
1768:
1769: ELSIF p_new_end_date IS NULL
1770: THEN

Line 1807: RAISE FND_API.G_EXC_ERROR;

1803: --commented for bug 2686499
1804: -- fnd_message.set_token('PA_DATE',l_meaning);
1805: fnd_msg_pub.add;
1806: END IF;
1807: RAISE FND_API.G_EXC_ERROR;
1808: END IF;
1809: END IF;
1810: END IF;
1811:

Line 1844: RAISE FND_API.G_EXC_ERROR;

1840: fnd_message.set_token('PA_DATE',l_meaning);
1841: fnd_msg_pub.add;
1842: END IF;
1843:
1844: RAISE FND_API.G_EXC_ERROR;
1845:
1846: ELSIF p_new_end_date IS NULL
1847: THEN
1848: IF p_old_end_date IS NOT NULL

Line 1881: RAISE FND_API.G_EXC_ERROR;

1877: -- fnd_message.set_token('PA_DATE',l_meaning);
1878: fnd_msg_pub.add;
1879: END IF;
1880:
1881: RAISE FND_API.G_EXC_ERROR;
1882: END IF;
1883: END IF;
1884:
1885: ELSE --p_new_start_date was not passed

Line 1920: RAISE FND_API.G_EXC_ERROR;

1916: -- fnd_message.set_token('PA_DATE',l_meaning);
1917: fnd_msg_pub.add;
1918: END IF;
1919:
1920: RAISE FND_API.G_EXC_ERROR;
1921: END IF;
1922:
1923: ELSE
1924: p_update_end_date_flag := 'N';

Line 1947: WHEN FND_API.G_EXC_ERROR

1943:
1944:
1945: EXCEPTION
1946:
1947: WHEN FND_API.G_EXC_ERROR
1948: THEN
1949:
1950: p_return_status := FND_API.G_RET_STS_ERROR;
1951:

Line 1950: p_return_status := FND_API.G_RET_STS_ERROR;

1946:
1947: WHEN FND_API.G_EXC_ERROR
1948: THEN
1949:
1950: p_return_status := FND_API.G_RET_STS_ERROR;
1951:
1952: -- 4537865 : Start RESET other out params too.
1953: p_update_start_date_flag := NULL ;
1954: p_update_end_date_flag := NULL ;

Line 1956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1952: -- 4537865 : Start RESET other out params too.
1953: p_update_start_date_flag := NULL ;
1954: p_update_end_date_flag := NULL ;
1955:
1956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1957: THEN
1958:
1959: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1960:

Line 1959: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1955:
1956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1957: THEN
1958:
1959: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1960:
1961: -- 4537865 : Start RESET other out params too.
1962: p_update_start_date_flag := NULL ;
1963: p_update_end_date_flag := NULL ;

Line 1968: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1964: -- 4537865 : End
1965:
1966: WHEN OTHERS THEN
1967:
1968: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1969: -- 4537865 : Start RESET other out params too.
1970: p_update_start_date_flag := NULL ;
1971: p_update_end_date_flag := NULL ;
1972: -- 4537865 : End

Line 1991: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

1987: -- Return Value : N/A
1988: -- Prameters
1989: -- p_project_id IN NUMBER REQUIRED
1990: -- p_wbs_record_version_number IN NUMBER REQUIRED
1991: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1992: -- x_return_status OUT VARCHAR2 REQUIRED
1993: -- x_error_msg_code OUT VARCHAR2 REQUIRED
1994: --
1995: -- History

Line 2002: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

1998: --
1999: --
2000:
2001: PROCEDURE LOCK_PROJECT(
2002: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
2003: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
2004: p_project_id IN NUMBER,
2005: p_wbs_record_version_number IN NUMBER,
2006: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 2011: IF p_validate_only <> FND_API.G_TRUE

2007: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2008: ) AS
2009: l_dummy_char VARCHAR2(1);
2010: BEGIN
2011: IF p_validate_only <> FND_API.G_TRUE
2012: THEN
2013: BEGIN
2014: SELECT 'x' INTO l_dummy_char
2015: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure

Line 2189: x_return_status := FND_API.G_RET_STS_SUCCESS;

2185:
2186: BEGIN
2187:
2188: x_msg_count := 0;
2189: x_return_status := FND_API.G_RET_STS_SUCCESS;
2190: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2191:
2192: IF l_debug_mode = 'Y' THEN
2193: PA_DEBUG.set_curr_function( p_function => 'CHECK_MOVE_FINANCIAL_TASK_OK',

Line 2232: x_return_status := FND_API.G_RET_STS_ERROR;

2228: THEN
2229:
2230: --Raise an error message
2231: x_error_msg_code := 'PA_CANT_MOVE_SELECTED_TASK';
2232: x_return_status := FND_API.G_RET_STS_ERROR;
2233: return;
2234: END IF;
2235: END IF;
2236:

Line 2241: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

2237: EXCEPTION
2238:
2239: WHEN OTHERS THEN
2240:
2241: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2242: x_msg_count := 1;
2243: x_msg_data := SQLERRM;
2244:
2245: -- 4537865 : RESET x_error_message_code also

Line 2333: x_return_status := FND_API.G_RET_STS_SUCCESS;

2329: );
2330:
2331: BEGIN
2332: x_msg_count := 0;
2333: x_return_status := FND_API.G_RET_STS_SUCCESS;
2334: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2335:
2336: IF l_debug_mode = 'Y' THEN
2337: PA_DEBUG.set_curr_function( p_function => 'CHECK_WORKPLAN_TASK_EXISTS',

Line 2360: x_return_status := FND_API.G_RET_STS_ERROR;

2356: IF (l_fin_flag = 'X')
2357: THEN
2358: --Populate error message
2359: x_error_msg_code := 'PA_WORKPLAN_TASK_EXISTS';
2360: x_return_status := FND_API.G_RET_STS_ERROR;
2361:
2362: END IF;
2363: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS )
2364: THEN

Line 2363: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS )

2359: x_error_msg_code := 'PA_WORKPLAN_TASK_EXISTS';
2360: x_return_status := FND_API.G_RET_STS_ERROR;
2361:
2362: END IF;
2363: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS )
2364: THEN
2365: return;
2366: END IF;
2367:

Line 2372: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

2368: EXCEPTION
2369:
2370: WHEN OTHERS THEN
2371:
2372: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2373: x_msg_count := 1;
2374: x_msg_data := SQLERRM;
2375:
2376: -- 4537865 : RESET x_error_message_code also

Line 2451: RAISE FND_API.G_EXC_ERROR;

2447: p_msg_name => 'PA_EI_INVALID_DATES',
2448: p_token1 => 'EIDATE',
2449: p_value1 => x_ei_date);
2450: x_msg_data := 'PA_EI_INVALID_DATES';
2451: RAISE FND_API.G_EXC_ERROR;
2452: ELSE
2453: close cur_date;
2454: END IF ;
2455: END IF ;

Line 2456: x_return_status := FND_API.G_RET_STS_SUCCESS;

2452: ELSE
2453: close cur_date;
2454: END IF ;
2455: END IF ;
2456: x_return_status := FND_API.G_RET_STS_SUCCESS;
2457:
2458: EXCEPTION
2459: WHEN FND_API.G_EXC_ERROR THEN
2460: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2459: WHEN FND_API.G_EXC_ERROR THEN

2455: END IF ;
2456: x_return_status := FND_API.G_RET_STS_SUCCESS;
2457:
2458: EXCEPTION
2459: WHEN FND_API.G_EXC_ERROR THEN
2460: x_return_status := FND_API.G_RET_STS_ERROR;
2461: x_msg_count := FND_MSG_PUB.count_msg;
2462: WHEN OTHERS THEN
2463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2460: x_return_status := FND_API.G_RET_STS_ERROR;

2456: x_return_status := FND_API.G_RET_STS_SUCCESS;
2457:
2458: EXCEPTION
2459: WHEN FND_API.G_EXC_ERROR THEN
2460: x_return_status := FND_API.G_RET_STS_ERROR;
2461: x_msg_count := FND_MSG_PUB.count_msg;
2462: WHEN OTHERS THEN
2463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2464: -- 4537865 : RESET x_msg_count, x_msg_data also

Line 2463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2459: WHEN FND_API.G_EXC_ERROR THEN
2460: x_return_status := FND_API.G_RET_STS_ERROR;
2461: x_msg_count := FND_MSG_PUB.count_msg;
2462: WHEN OTHERS THEN
2463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2464: -- 4537865 : RESET x_msg_count, x_msg_data also
2465: x_msg_count := 1 ;
2466: x_msg_data := SUBSTRB(SQLERRM,1,240);
2467:

Line 2525: RAISE FND_API.G_EXC_ERROR;

2521: p_msg_name => 'PA_EI_INVALID_START_DATE',
2522: p_token1 => 'EISTARTDATE',
2523: p_value1 => x_ei_min_date);
2524: x_msg_data := 'PA_EI_INVALID_START_DATE';
2525: RAISE FND_API.G_EXC_ERROR;
2526: ELSE
2527: close cur_start_date;
2528: END IF ;
2529: END IF ;

Line 2530: x_return_status := FND_API.G_RET_STS_SUCCESS;

2526: ELSE
2527: close cur_start_date;
2528: END IF ;
2529: END IF ;
2530: x_return_status := FND_API.G_RET_STS_SUCCESS;
2531:
2532: EXCEPTION
2533: WHEN FND_API.G_EXC_ERROR THEN
2534: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2533: WHEN FND_API.G_EXC_ERROR THEN

2529: END IF ;
2530: x_return_status := FND_API.G_RET_STS_SUCCESS;
2531:
2532: EXCEPTION
2533: WHEN FND_API.G_EXC_ERROR THEN
2534: x_return_status := FND_API.G_RET_STS_ERROR;
2535: x_msg_count := FND_MSG_PUB.count_msg;
2536: WHEN OTHERS THEN
2537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2534: x_return_status := FND_API.G_RET_STS_ERROR;

2530: x_return_status := FND_API.G_RET_STS_SUCCESS;
2531:
2532: EXCEPTION
2533: WHEN FND_API.G_EXC_ERROR THEN
2534: x_return_status := FND_API.G_RET_STS_ERROR;
2535: x_msg_count := FND_MSG_PUB.count_msg;
2536: WHEN OTHERS THEN
2537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2538: -- 4537865 : RESET x_msg_count, x_msg_data also

Line 2537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2533: WHEN FND_API.G_EXC_ERROR THEN
2534: x_return_status := FND_API.G_RET_STS_ERROR;
2535: x_msg_count := FND_MSG_PUB.count_msg;
2536: WHEN OTHERS THEN
2537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2538: -- 4537865 : RESET x_msg_count, x_msg_data also
2539: x_msg_count := 1 ;
2540: x_msg_data := SUBSTRB(SQLERRM,1,240);
2541: