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 508: RAISE FND_API.G_EXC_ERROR;

504: IF (p_start_date IS NOT NULL and
505: l_start_date > p_start_date) THEN
506: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');
507: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
508: RAISE FND_API.G_EXC_ERROR;
509: END IF;
510:
511: IF (l_end_date IS NOT NULL and
512: p_start_date > l_end_date) THEN

Line 515: RAISE FND_API.G_EXC_ERROR;

511: IF (l_end_date IS NOT NULL and
512: p_start_date > l_end_date) THEN
513: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');
514: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
515: RAISE FND_API.G_EXC_ERROR;
516: END IF;
517:
518: if(PA_TASK_PVT1.G_CHG_DOC_CNTXT = 1 )
519: then

Line 525: RAISE FND_API.G_EXC_ERROR;

521: fetch get_parent_dates into l_sch_s_date,l_sch_e_date;
522: close get_parent_dates;
523: if(l_sch_s_date is not null and l_sch_s_date>p_start_date) then
524: x_msg_data := 'PA_PARENT_TASK_GREATER';
525: RAISE FND_API.G_EXC_ERROR;
526: END IF;
527:
528: end if;
529: ELSE -- NOT A TOP TASK, compare with parent task

Line 539: RAISE FND_API.G_EXC_ERROR;

535: IF (p_start_date is NOT NULL and
536: l_start_date > p_start_date) THEN
537: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_TASK_GREATER');
538: x_msg_data := 'PA_PARENT_TASK_GREATER';
539: RAISE FND_API.G_EXC_ERROR;
540: END IF;
541: IF (l_end_date IS NOT NULL and
542: p_start_date > l_end_date) THEN
543: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_TASK_GREATER');

Line 545: RAISE FND_API.G_EXC_ERROR;

541: IF (l_end_date IS NOT NULL and
542: p_start_date > l_end_date) THEN
543: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_TASK_GREATER');
544: x_msg_data := 'PA_PARENT_TASK_GREATER';
545: RAISE FND_API.G_EXC_ERROR;
546: END IF;
547:
548: -- Bug Start 6163119
549: select start_date, completion_date

Line 568: RAISE FND_API.G_EXC_ERROR;

564: IF p_start_date IS NOT NULL AND l_start_date IS NULL THEN
565: IF l_tstart_date IS NOT NULL THEN
566: IF(l_tstart_date > p_start_date) THEN
567: x_msg_data := 'PA_PARENT_TASK_GREATER';
568: RAISE FND_API.G_EXC_ERROR;
569: END IF;
570: ELSIF l_pstart_date IS NOT NULL THEN
571: IF(l_pstart_date > p_start_date) THEN
572: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';

Line 573: RAISE FND_API.G_EXC_ERROR;

569: END IF;
570: ELSIF l_pstart_date IS NOT NULL THEN
571: IF(l_pstart_date > p_start_date) THEN
572: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
573: RAISE FND_API.G_EXC_ERROR;
574: END IF;
575: END IF;
576: END IF;
577:

Line 583: RAISE FND_API.G_EXC_ERROR;

579: IF p_start_date IS NOT NULL AND l_end_date IS NULL THEN
580: IF l_tend_date IS NOT NULL THEN
581: IF (p_start_date > l_tend_date) THEN
582: x_msg_data := 'PA_PARENT_TASK_GREATER';
583: RAISE FND_API.G_EXC_ERROR;
584: END IF;
585: ELSIF l_pend_date IS NOT NULL THEN
586: IF(p_start_date > l_pend_date) THEN
587: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';

Line 588: RAISE FND_API.G_EXC_ERROR;

584: END IF;
585: ELSIF l_pend_date IS NOT NULL THEN
586: IF(p_start_date > l_pend_date) THEN
587: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
588: RAISE FND_API.G_EXC_ERROR;
589: END IF;
590: END IF;
591: END IF;
592:

Line 610: RAISE FND_API.G_EXC_ERROR;

606: l_start_date < p_start_date) THEN -- Bug 7386335
607: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_CHILD_TASK_DATE_EARLIER');
608: x_msg_data := 'PA_CHILD_TASK_DATE_EARLIER';
609: CLOSE c1;
610: RAISE FND_API.G_EXC_ERROR;
611: END IF;
612: IF (l_end_date IS NOT NULL and
613: p_start_date > l_end_date) THEN
614: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_CHILD_TASK_DATE_EARLIER');

Line 617: RAISE FND_API.G_EXC_ERROR;

613: p_start_date > l_end_date) THEN
614: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_CHILD_TASK_DATE_EARLIER');
615: x_msg_data := 'PA_CHILD_TASK_DATE_EARLIER';
616: CLOSE c1;
617: RAISE FND_API.G_EXC_ERROR;
618: END IF;
619: END LOOP;
620: CLOSE c1;
621: END IF;

Line 622: x_return_status := FND_API.G_RET_STS_SUCCESS;

618: END IF;
619: END LOOP;
620: CLOSE c1;
621: END IF;
622: x_return_status := FND_API.G_RET_STS_SUCCESS;
623:
624: EXCEPTION
625: WHEN FND_API.G_EXC_ERROR THEN
626: x_return_status := FND_API.G_RET_STS_ERROR;

Line 625: WHEN FND_API.G_EXC_ERROR THEN

621: END IF;
622: x_return_status := FND_API.G_RET_STS_SUCCESS;
623:
624: EXCEPTION
625: WHEN FND_API.G_EXC_ERROR THEN
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: x_msg_count := FND_MSG_PUB.count_msg;
628: WHEN OTHERS THEN
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 626: x_return_status := FND_API.G_RET_STS_ERROR;

622: x_return_status := FND_API.G_RET_STS_SUCCESS;
623:
624: EXCEPTION
625: WHEN FND_API.G_EXC_ERROR THEN
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: x_msg_count := FND_MSG_PUB.count_msg;
628: WHEN OTHERS THEN
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: -- 4537865 : RESET other OUT params too

Line 629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

625: WHEN FND_API.G_EXC_ERROR THEN
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: x_msg_count := FND_MSG_PUB.count_msg;
628: WHEN OTHERS THEN
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: -- 4537865 : RESET other OUT params too
631: x_msg_count := 1;
632: x_msg_data := SUBSTRB(SQLERRM ,1,240);
633:

Line 692: RAISE FND_API.G_EXC_ERROR;

688: IF (p_end_date IS NOT NULL and
689: l_end_date < p_end_date) THEN
690: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');
691: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
692: RAISE FND_API.G_EXC_ERROR;
693: END IF;
694: IF (p_end_date IS NOT NULL and
695: l_start_date > p_end_date) THEN
696: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');

Line 698: RAISE FND_API.G_EXC_ERROR;

694: IF (p_end_date IS NOT NULL and
695: l_start_date > p_end_date) THEN
696: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');
697: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
698: RAISE FND_API.G_EXC_ERROR;
699: END IF;
700:
701: if(PA_TASK_PVT1.G_CHG_DOC_CNTXT = 1 )
702: then

Line 708: RAISE FND_API.G_EXC_ERROR;

704: fetch get_parent_dates into l_sch_s_date,l_sch_e_date;
705: close get_parent_dates;
706: if(l_sch_s_date is not null and l_sch_e_date 707: x_msg_data := 'PA_PARENT_COMPLETION_EARLIER';
708: RAISE FND_API.G_EXC_ERROR;
709: END IF;
710:
711: end if;
712:

Line 723: RAISE FND_API.G_EXC_ERROR;

719: IF (p_end_date is NOT NULL and
720: l_end_date < p_end_date) THEN
721: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_COMPLETION_EARLIER');
722: x_msg_data := 'PA_PARENT_COMPLETION_EARLIER';
723: RAISE FND_API.G_EXC_ERROR;
724: END IF;
725: IF (p_end_date is NOT NULL and
726: l_start_date > p_end_date) THEN
727: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_COMPLETION_EARLIER');

Line 729: RAISE FND_API.G_EXC_ERROR;

725: IF (p_end_date is NOT NULL and
726: l_start_date > p_end_date) THEN
727: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_COMPLETION_EARLIER');
728: x_msg_data := 'PA_PARENT_COMPLETION_EARLIER';
729: RAISE FND_API.G_EXC_ERROR;
730: END IF;
731:
732: -- Bug Start 6163119
733: select start_date, completion_date

Line 752: RAISE FND_API.G_EXC_ERROR;

748: IF p_end_date IS NOT NULL AND l_end_date IS NULL THEN
749: IF l_tend_date IS NOT NULL THEN
750: IF (l_tend_date < p_end_date) THEN
751: x_msg_data := 'PA_PARENT_COMPLETION_EARLIER';
752: RAISE FND_API.G_EXC_ERROR;
753: END IF;
754: ELSIF l_pend_date IS NOT NULL THEN
755: IF (l_pend_date < p_end_date) THEN
756: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';

Line 757: RAISE FND_API.G_EXC_ERROR;

753: END IF;
754: ELSIF l_pend_date IS NOT NULL THEN
755: IF (l_pend_date < p_end_date) THEN
756: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
757: RAISE FND_API.G_EXC_ERROR;
758: END IF;
759: END IF;
760: END IF;
761:

Line 767: RAISE FND_API.G_EXC_ERROR;

763: IF p_end_date IS NOT NULL AND l_start_date IS NULL THEN
764: IF l_tstart_date IS NOT NULL THEN
765: IF(l_tstart_date > p_end_date) THEN
766: x_msg_data := 'PA_PARENT_COMPLETION_EARLIER';
767: RAISE FND_API.G_EXC_ERROR;
768: END IF;
769: ELSIF l_pstart_date is NOT NULL THEN
770: IF(l_pstart_date > p_end_date) THEN
771: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';

Line 772: RAISE FND_API.G_EXC_ERROR;

768: END IF;
769: ELSIF l_pstart_date is NOT NULL THEN
770: IF(l_pstart_date > p_end_date) THEN
771: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774: END IF;
775: END IF;
776:

Line 793: RAISE FND_API.G_EXC_ERROR;

789: l_end_date > p_end_date) THEN
790: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_CHILD_COMPLETION_LATER');
791: x_msg_data := 'PA_CHILD_COMPLETION_LATER';
792: CLOSE c1;
793: RAISE FND_API.G_EXC_ERROR;
794: END IF;
795: IF (p_end_date is NOT NULL and
796: l_start_date > p_end_date) THEN
797: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_TASK_GREATER');

Line 800: RAISE FND_API.G_EXC_ERROR;

796: l_start_date > p_end_date) THEN
797: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_TASK_GREATER');
798: x_msg_data := 'PA_CHILD_COMPLETION_LATER';
799: CLOSE c1;
800: RAISE FND_API.G_EXC_ERROR;
801: END IF;
802:
803: END LOOP;
804: CLOSE c1;

Line 806: x_return_status := FND_API.G_RET_STS_SUCCESS;

802:
803: END LOOP;
804: CLOSE c1;
805: END IF;
806: x_return_status := FND_API.G_RET_STS_SUCCESS;
807:
808: EXCEPTION
809: WHEN FND_API.G_EXC_ERROR THEN
810: x_return_status := FND_API.G_RET_STS_ERROR;

Line 809: WHEN FND_API.G_EXC_ERROR THEN

805: END IF;
806: x_return_status := FND_API.G_RET_STS_SUCCESS;
807:
808: EXCEPTION
809: WHEN FND_API.G_EXC_ERROR THEN
810: x_return_status := FND_API.G_RET_STS_ERROR;
811: x_msg_count := FND_MSG_PUB.count_msg;
812: WHEN OTHERS THEN
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 810: x_return_status := FND_API.G_RET_STS_ERROR;

806: x_return_status := FND_API.G_RET_STS_SUCCESS;
807:
808: EXCEPTION
809: WHEN FND_API.G_EXC_ERROR THEN
810: x_return_status := FND_API.G_RET_STS_ERROR;
811: x_msg_count := FND_MSG_PUB.count_msg;
812: WHEN OTHERS THEN
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
814: -- 4537865 : RESET other OUT params too

Line 813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

809: WHEN FND_API.G_EXC_ERROR THEN
810: x_return_status := FND_API.G_RET_STS_ERROR;
811: x_msg_count := FND_MSG_PUB.count_msg;
812: WHEN OTHERS THEN
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
814: -- 4537865 : RESET other OUT params too
815: x_msg_count := 1;
816: x_msg_data := SUBSTRB(SQLERRM ,1,240);
817: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_UTILS',

Line 905: RAISE FND_API.G_EXC_ERROR;

901: --commenting the following line after discussing with
902: --sakthi. The reason is that there are two messages being appended
903: --for the same error.
904: --x_msg_data := 'PA_INVALID_SCH_DATES';
905: RAISE FND_API.G_EXC_ERROR;
906: END IF;
907: END IF;
908:
909: OPEN c1;

Line 915: RAISE FND_API.G_EXC_ERROR;

911: IF c1%NOTFOUND THEN
912: PA_UTILS.ADD_MESSAGE('PA', 'PA_PROJ_NOT_EXIST');
913: x_msg_data := 'PA_PROJ_NOT_EXIST';
914: CLOSE c1;
915: RAISE FND_API.G_EXC_ERROR;
916: END IF;
917: CLOSE c1;
918:
919: IF (p_sch_start_date IS NOT NULL and l_start_date > p_sch_start_date) THEN

Line 922: RAISE FND_API.G_EXC_ERROR;

918:
919: IF (p_sch_start_date IS NOT NULL and l_start_date > p_sch_start_date) THEN
920: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_SCH_DATE_OUTSIDE_PROJ_RANGE');
921: x_msg_data := 'PA_SCH_DATE_OUTSIDE_PROJ_RANGE';
922: RAISE FND_API.G_EXC_ERROR;
923: END IF;
924:
925: IF (p_sch_end_date IS NOT NULL and l_finish_date < p_sch_end_date) THEN
926: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_SCH_DATE_OUTSIDE_PROJ_RANGE');

Line 928: RAISE FND_API.G_EXC_ERROR;

924:
925: IF (p_sch_end_date IS NOT NULL and l_finish_date < p_sch_end_date) THEN
926: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_SCH_DATE_OUTSIDE_PROJ_RANGE');
927: x_msg_data := 'PA_SCH_DATE_OUTSIDE_PROJ_RANGE';
928: RAISE FND_API.G_EXC_ERROR;
929: END IF;
930:
931: x_msg_data := NULL;
932: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 932: x_return_status := FND_API.G_RET_STS_SUCCESS;

928: RAISE FND_API.G_EXC_ERROR;
929: END IF;
930:
931: x_msg_data := NULL;
932: x_return_status := FND_API.G_RET_STS_SUCCESS;
933: EXCEPTION
934: WHEN FND_API.G_EXC_ERROR THEN
935: x_return_status := FND_API.G_RET_STS_ERROR;
936: x_msg_count := FND_MSG_PUB.count_msg;

Line 934: WHEN FND_API.G_EXC_ERROR THEN

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

Line 935: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 976: RAISE FND_API.G_EXC_ERROR;

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

Line 981: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 984: WHEN FND_API.G_EXC_ERROR THEN

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

Line 985: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1025: RAISE FND_API.G_EXC_ERROR;

1021: p_return_status => l_ret);
1022: IF (l_ret <> 'S') THEN
1023: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_INVALID_ACTUAL_DATES');
1024: x_msg_data := 'PA_INVALID_ACTUAL_DATES';
1025: RAISE FND_API.G_EXC_ERROR;
1026: END IF;
1027: END IF;
1028:
1029: x_msg_data := NULL;

Line 1030: x_return_status := FND_API.G_RET_STS_SUCCESS;

1026: END IF;
1027: END IF;
1028:
1029: x_msg_data := NULL;
1030: x_return_status := FND_API.G_RET_STS_SUCCESS;
1031:
1032: EXCEPTION
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1033: WHEN FND_API.G_EXC_ERROR THEN

1029: x_msg_data := NULL;
1030: x_return_status := FND_API.G_RET_STS_SUCCESS;
1031:
1032: EXCEPTION
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: x_msg_count := FND_MSG_PUB.count_msg;
1036: WHEN OTHERS THEN
1037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1034: x_return_status := FND_API.G_RET_STS_ERROR;

1030: x_return_status := FND_API.G_RET_STS_SUCCESS;
1031:
1032: EXCEPTION
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: x_msg_count := FND_MSG_PUB.count_msg;
1036: WHEN OTHERS THEN
1037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1038: -- 4537865 : RESET other OUT params too

Line 1037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1033: WHEN FND_API.G_EXC_ERROR THEN
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: x_msg_count := FND_MSG_PUB.count_msg;
1036: WHEN OTHERS THEN
1037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1038: -- 4537865 : RESET other OUT params too
1039: x_msg_count := 1;
1040: x_msg_data := SUBSTRB(SQLERRM ,1,240);
1041: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_UTILS',

Line 1155: x_return_status := FND_API.G_RET_STS_SUCCESS;

1151: l_parent_task_id NUMBER;
1152: l_project_id NUMBER;
1153:
1154: BEGIN
1155: x_return_status := FND_API.G_RET_STS_SUCCESS;
1156: IF p_reference_task_id IS NULL
1157: THEN
1158: x_return_status := FND_API.G_RET_STS_ERROR;
1159: x_error_msg_code := 'PA_PRJ_TASK_ID_REQ';

Line 1158: x_return_status := FND_API.G_RET_STS_ERROR;

1154: BEGIN
1155: x_return_status := FND_API.G_RET_STS_SUCCESS;
1156: IF p_reference_task_id IS NULL
1157: THEN
1158: x_return_status := FND_API.G_RET_STS_ERROR;
1159: x_error_msg_code := 'PA_PRJ_TASK_ID_REQ';
1160: RAISE FND_API.G_EXC_ERROR;
1161: END IF;
1162:

Line 1160: RAISE FND_API.G_EXC_ERROR;

1156: IF p_reference_task_id IS NULL
1157: THEN
1158: x_return_status := FND_API.G_RET_STS_ERROR;
1159: x_error_msg_code := 'PA_PRJ_TASK_ID_REQ';
1160: RAISE FND_API.G_EXC_ERROR;
1161: END IF;
1162:
1163: IF p_task_type IS NULL
1164: THEN

Line 1165: x_return_status := FND_API.G_RET_STS_ERROR;

1161: END IF;
1162:
1163: IF p_task_type IS NULL
1164: THEN
1165: x_return_status := FND_API.G_RET_STS_ERROR;
1166: x_error_msg_code := 'PA_PRJ_TASK_TYPE_REQ';
1167: RAISE FND_API.G_EXC_ERROR;
1168: END IF;
1169:

Line 1167: RAISE FND_API.G_EXC_ERROR;

1163: IF p_task_type IS NULL
1164: THEN
1165: x_return_status := FND_API.G_RET_STS_ERROR;
1166: x_error_msg_code := 'PA_PRJ_TASK_TYPE_REQ';
1167: RAISE FND_API.G_EXC_ERROR;
1168: END IF;
1169:
1170: IF p_task_type = 'SUB'
1171: THEN

Line 1221: WHEN FND_API.G_EXC_ERROR THEN

1217: END IF;
1218: END IF;
1219:
1220: EXCEPTION
1221: WHEN FND_API.G_EXC_ERROR THEN
1222: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1223: -- 4537865 : RESET other OUT params too
1224: x_carrying_out_org_id := NULL ;
1225: x_carrying_out_org_name := NULL ;

Line 1222: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

1218: END IF;
1219:
1220: EXCEPTION
1221: WHEN FND_API.G_EXC_ERROR THEN
1222: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1223: -- 4537865 : RESET other OUT params too
1224: x_carrying_out_org_id := NULL ;
1225: x_carrying_out_org_name := NULL ;
1226: x_work_type_id := NULL ;

Line 1232: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

1228: x_service_type_code := NULL ;
1229: x_service_type_name := NULL ;
1230:
1231: WHEN OTHERS THEN
1232: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1233: -- 4537865 : Start
1234: x_carrying_out_org_id := NULL ;
1235: x_carrying_out_org_name := NULL ;
1236: x_work_type_id := NULL ;

Line 1308: x_return_status := FND_API.G_RET_STS_SUCCESS;

1304: l_record_found VARCHAR2(1) := 'N';
1305: l_num_of_records NUMBER;
1306:
1307: BEGIN
1308: x_return_status := FND_API.G_RET_STS_SUCCESS;
1309: OPEN cur_pa_tasks_sub;
1310: LOOP
1311: FETCH cur_pa_tasks_sub INTO x_carrying_out_org_id
1312: ,x_carrying_out_org_name

Line 1339: x_return_status:= FND_API.G_RET_STS_ERROR;

1335: RAISE NO_DATA_FOUND;
1336: END IF;
1337: EXCEPTION
1338: WHEN no_data_found THEN
1339: x_return_status:= FND_API.G_RET_STS_ERROR;
1340: -- 4537865 : Start
1341: x_carrying_out_org_id := NULL ;
1342: x_carrying_out_org_name := NULL ;
1343: x_work_type_id := NULL ;

Line 1349: x_return_status:= FND_API.G_RET_STS_ERROR;

1345: x_service_type_code := NULL ;
1346: x_service_type_name := NULL ;
1347: -- 4537865 : End
1348: WHEN too_many_rows THEN
1349: x_return_status:= FND_API.G_RET_STS_ERROR;
1350: -- 4537865 : Start
1351: x_carrying_out_org_id := NULL ;
1352: x_carrying_out_org_name := NULL ;
1353: x_work_type_id := NULL ;

Line 1360: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

1356: x_service_type_name := NULL ;
1357:
1358: -- 4537865 : End
1359: WHEN OTHERS THEN
1360: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1361: -- 4537865 : Start
1362: x_carrying_out_org_id := NULL ;
1363: x_carrying_out_org_name := NULL ;
1364: x_work_type_id := NULL ;

Line 1441: x_return_status := FND_API.G_RET_STS_SUCCESS;

1437: l_record_found VARCHAR2(1) := 'N';
1438: l_num_of_records NUMBER;
1439:
1440: BEGIN
1441: x_return_status := FND_API.G_RET_STS_SUCCESS;
1442: OPEN cur_pa_project;
1443: LOOP
1444: FETCH cur_pa_project INTO x_carrying_out_org_id
1445: ,x_carrying_out_org_name

Line 1472: x_return_status:= FND_API.G_RET_STS_ERROR;

1468: RAISE NO_DATA_FOUND;
1469: END IF;
1470: EXCEPTION
1471: WHEN no_data_found THEN
1472: x_return_status:= FND_API.G_RET_STS_ERROR;
1473: -- 4537865 :Start
1474: x_carrying_out_org_id := NULL ;
1475: x_carrying_out_org_name := NULL ;
1476: x_work_type_id := NULL ;

Line 1483: x_return_status:= FND_API.G_RET_STS_ERROR;

1479: x_service_type_name := NULL ;
1480:
1481: -- 4537865 :End
1482: WHEN too_many_rows THEN
1483: x_return_status:= FND_API.G_RET_STS_ERROR;
1484: -- 4537865 :Start
1485: x_carrying_out_org_id := NULL ;
1486: x_carrying_out_org_name := NULL ;
1487: x_work_type_id := NULL ;

Line 1494: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

1490: x_service_type_name := NULL ;
1491:
1492: -- 4537865 :End
1493: WHEN OTHERS THEN
1494: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1495: -- 4537865 :Start
1496: x_carrying_out_org_id := NULL ;
1497: x_carrying_out_org_name := NULL ;
1498: x_work_type_id := NULL ;

Line 1626: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1622: AND ppev.proj_element_id = pt.task_id;
1623:
1624: BEGIN
1625:
1626: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1627:
1628: OPEN cur_wbs_above;
1629: FETCH cur_wbs_above INTO x_task_level_above, x_task_id_above, x_top_task_id_above,
1630: x_parent_task_id_above, x_display_sequence_above;

Line 1640: x_return_status:= FND_API.G_RET_STS_ERROR;

1636: CLOSE cur_wbs;
1637:
1638: EXCEPTION
1639: WHEN OTHERS THEN
1640: x_return_status:= FND_API.G_RET_STS_ERROR;
1641: -- 4537865 : Start
1642: x_task_level := 1 ; -- set task level as 1 so that ,caller API throws error properly
1643: x_parent_task_id := NULL ;
1644: x_top_task_id := NULL ;

Line 1679: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1675: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
1676: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1677: ) AS
1678: BEGIN
1679: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1680: IF p_reference_project_id IS NULL OR p_reference_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1681: THEN
1682: x_error_msg_code := 'PA_TASK_TARGET_PRJ_ID_REQ';
1683: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 1683: x_return_status:= FND_API.G_RET_STS_ERROR;

1679: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1680: IF p_reference_project_id IS NULL OR p_reference_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1681: THEN
1682: x_error_msg_code := 'PA_TASK_TARGET_PRJ_ID_REQ';
1683: x_return_status:= FND_API.G_RET_STS_ERROR;
1684: RAISE FND_API.G_EXC_ERROR;
1685: END IF;
1686:
1687: IF p_reference_task_id IS NULL OR p_reference_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1684: RAISE FND_API.G_EXC_ERROR;

1680: IF p_reference_project_id IS NULL OR p_reference_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1681: THEN
1682: x_error_msg_code := 'PA_TASK_TARGET_PRJ_ID_REQ';
1683: x_return_status:= FND_API.G_RET_STS_ERROR;
1684: RAISE FND_API.G_EXC_ERROR;
1685: END IF;
1686:
1687: IF p_reference_task_id IS NULL OR p_reference_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1688: THEN

Line 1690: x_return_status:= FND_API.G_RET_STS_ERROR;

1686:
1687: IF p_reference_task_id IS NULL OR p_reference_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1688: THEN
1689: x_error_msg_code := 'PA_TASK_TARGET_TASK_ID_REQ';
1690: x_return_status:= FND_API.G_RET_STS_ERROR;
1691: RAISE FND_API.G_EXC_ERROR;
1692: END IF;
1693: EXCEPTION
1694: WHEN FND_API.G_EXC_ERROR THEN

Line 1691: RAISE FND_API.G_EXC_ERROR;

1687: IF p_reference_task_id IS NULL OR p_reference_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1688: THEN
1689: x_error_msg_code := 'PA_TASK_TARGET_TASK_ID_REQ';
1690: x_return_status:= FND_API.G_RET_STS_ERROR;
1691: RAISE FND_API.G_EXC_ERROR;
1692: END IF;
1693: EXCEPTION
1694: WHEN FND_API.G_EXC_ERROR THEN
1695: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 1694: WHEN FND_API.G_EXC_ERROR THEN

1690: x_return_status:= FND_API.G_RET_STS_ERROR;
1691: RAISE FND_API.G_EXC_ERROR;
1692: END IF;
1693: EXCEPTION
1694: WHEN FND_API.G_EXC_ERROR THEN
1695: x_return_status:= FND_API.G_RET_STS_ERROR;
1696: END REF_PRJ_TASK_ID_REQ_CHECK;
1697:
1698:

Line 1695: x_return_status:= FND_API.G_RET_STS_ERROR;

1691: RAISE FND_API.G_EXC_ERROR;
1692: END IF;
1693: EXCEPTION
1694: WHEN FND_API.G_EXC_ERROR THEN
1695: x_return_status:= FND_API.G_RET_STS_ERROR;
1696: END REF_PRJ_TASK_ID_REQ_CHECK;
1697:
1698:
1699: -- API name : SRC_PRJ_TASK_ID_REQ_CHECK

Line 1722: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1718: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
1719: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1720: ) AS
1721: BEGIN
1722: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1723: IF p_project_id IS NULL OR p_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1724: THEN
1725: x_error_msg_code := 'PA_TASK_SOURCE_PRJ_ID_REQ';
1726: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 1726: x_return_status:= FND_API.G_RET_STS_ERROR;

1722: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1723: IF p_project_id IS NULL OR p_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1724: THEN
1725: x_error_msg_code := 'PA_TASK_SOURCE_PRJ_ID_REQ';
1726: x_return_status:= FND_API.G_RET_STS_ERROR;
1727: RAISE FND_API.G_EXC_ERROR;
1728: END IF;
1729:
1730: IF p_task_id IS NULL OR p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1727: RAISE FND_API.G_EXC_ERROR;

1723: IF p_project_id IS NULL OR p_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1724: THEN
1725: x_error_msg_code := 'PA_TASK_SOURCE_PRJ_ID_REQ';
1726: x_return_status:= FND_API.G_RET_STS_ERROR;
1727: RAISE FND_API.G_EXC_ERROR;
1728: END IF;
1729:
1730: IF p_task_id IS NULL OR p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1731: THEN

Line 1733: x_return_status:= FND_API.G_RET_STS_ERROR;

1729:
1730: IF p_task_id IS NULL OR p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1731: THEN
1732: x_error_msg_code := 'PA_TASK_SOURCE_TASK_ID_REQ';
1733: x_return_status:= FND_API.G_RET_STS_ERROR;
1734: RAISE FND_API.G_EXC_ERROR;
1735: END IF;
1736: EXCEPTION
1737: WHEN FND_API.G_EXC_ERROR THEN

Line 1734: RAISE FND_API.G_EXC_ERROR;

1730: IF p_task_id IS NULL OR p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1731: THEN
1732: x_error_msg_code := 'PA_TASK_SOURCE_TASK_ID_REQ';
1733: x_return_status:= FND_API.G_RET_STS_ERROR;
1734: RAISE FND_API.G_EXC_ERROR;
1735: END IF;
1736: EXCEPTION
1737: WHEN FND_API.G_EXC_ERROR THEN
1738: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 1737: WHEN FND_API.G_EXC_ERROR THEN

1733: x_return_status:= FND_API.G_RET_STS_ERROR;
1734: RAISE FND_API.G_EXC_ERROR;
1735: END IF;
1736: EXCEPTION
1737: WHEN FND_API.G_EXC_ERROR THEN
1738: x_return_status:= FND_API.G_RET_STS_ERROR;
1739: END SRC_PRJ_TASK_ID_REQ_CHECK;
1740:
1741:

Line 1738: x_return_status:= FND_API.G_RET_STS_ERROR;

1734: RAISE FND_API.G_EXC_ERROR;
1735: END IF;
1736: EXCEPTION
1737: WHEN FND_API.G_EXC_ERROR THEN
1738: x_return_status:= FND_API.G_RET_STS_ERROR;
1739: END SRC_PRJ_TASK_ID_REQ_CHECK;
1740:
1741:
1742: --procedure from pa_project_check_pvt.check_start_end_date_Pvt

Line 1758: p_return_status := FND_API.G_RET_STS_SUCCESS;

1754: l_start_date DATE;
1755: l_end_date DATE;
1756: l_meaning pa_lookups.meaning%TYPE;
1757: BEGIN
1758: p_return_status := FND_API.G_RET_STS_SUCCESS;
1759:
1760: -- added by hsiu
1761: -- set token
1762: IF p_context = 'START' then

Line 1817: RAISE FND_API.G_EXC_ERROR;

1813: --hsiu: commented for bug 2686499
1814: -- fnd_message.set_token('PA_DATE',l_meaning);
1815: fnd_msg_pub.add;
1816: END IF;
1817: RAISE FND_API.G_EXC_ERROR;
1818: END IF;
1819:
1820: ELSIF p_new_end_date IS NULL
1821: THEN

Line 1858: RAISE FND_API.G_EXC_ERROR;

1854: --commented for bug 2686499
1855: -- fnd_message.set_token('PA_DATE',l_meaning);
1856: fnd_msg_pub.add;
1857: END IF;
1858: RAISE FND_API.G_EXC_ERROR;
1859: END IF;
1860: END IF;
1861: END IF;
1862:

Line 1895: RAISE FND_API.G_EXC_ERROR;

1891: fnd_message.set_token('PA_DATE',l_meaning);
1892: fnd_msg_pub.add;
1893: END IF;
1894:
1895: RAISE FND_API.G_EXC_ERROR;
1896:
1897: ELSIF p_new_end_date IS NULL
1898: THEN
1899: IF p_old_end_date IS NOT NULL

Line 1932: RAISE FND_API.G_EXC_ERROR;

1928: -- fnd_message.set_token('PA_DATE',l_meaning);
1929: fnd_msg_pub.add;
1930: END IF;
1931:
1932: RAISE FND_API.G_EXC_ERROR;
1933: END IF;
1934: END IF;
1935:
1936: ELSE --p_new_start_date was not passed

Line 1971: RAISE FND_API.G_EXC_ERROR;

1967: -- fnd_message.set_token('PA_DATE',l_meaning);
1968: fnd_msg_pub.add;
1969: END IF;
1970:
1971: RAISE FND_API.G_EXC_ERROR;
1972: END IF;
1973:
1974: ELSE
1975: p_update_end_date_flag := 'N';

Line 1998: WHEN FND_API.G_EXC_ERROR

1994:
1995:
1996: EXCEPTION
1997:
1998: WHEN FND_API.G_EXC_ERROR
1999: THEN
2000:
2001: p_return_status := FND_API.G_RET_STS_ERROR;
2002:

Line 2001: p_return_status := FND_API.G_RET_STS_ERROR;

1997:
1998: WHEN FND_API.G_EXC_ERROR
1999: THEN
2000:
2001: p_return_status := FND_API.G_RET_STS_ERROR;
2002:
2003: -- 4537865 : Start RESET other out params too.
2004: p_update_start_date_flag := NULL ;
2005: p_update_end_date_flag := NULL ;

Line 2007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

2003: -- 4537865 : Start RESET other out params too.
2004: p_update_start_date_flag := NULL ;
2005: p_update_end_date_flag := NULL ;
2006:
2007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2008: THEN
2009:
2010: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2011:

Line 2010: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2006:
2007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2008: THEN
2009:
2010: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2011:
2012: -- 4537865 : Start RESET other out params too.
2013: p_update_start_date_flag := NULL ;
2014: p_update_end_date_flag := NULL ;

Line 2019: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2015: -- 4537865 : End
2016:
2017: WHEN OTHERS THEN
2018:
2019: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2020: -- 4537865 : Start RESET other out params too.
2021: p_update_start_date_flag := NULL ;
2022: p_update_end_date_flag := NULL ;
2023: -- 4537865 : End

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

2038: -- Return Value : N/A
2039: -- Prameters
2040: -- p_project_id IN NUMBER REQUIRED
2041: -- p_wbs_record_version_number IN NUMBER REQUIRED
2042: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2043: -- x_return_status OUT VARCHAR2 REQUIRED
2044: -- x_error_msg_code OUT VARCHAR2 REQUIRED
2045: --
2046: -- History

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

2049: --
2050: --
2051:
2052: PROCEDURE LOCK_PROJECT(
2053: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
2054: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
2055: p_project_id IN NUMBER,
2056: p_wbs_record_version_number IN NUMBER,
2057: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 2062: IF p_validate_only <> FND_API.G_TRUE

2058: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2059: ) AS
2060: l_dummy_char VARCHAR2(1);
2061: BEGIN
2062: IF p_validate_only <> FND_API.G_TRUE
2063: THEN
2064: BEGIN
2065: SELECT 'x' INTO l_dummy_char
2066: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure

Line 2240: x_return_status := FND_API.G_RET_STS_SUCCESS;

2236:
2237: BEGIN
2238:
2239: x_msg_count := 0;
2240: x_return_status := FND_API.G_RET_STS_SUCCESS;
2241: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2242:
2243: IF l_debug_mode = 'Y' THEN
2244: PA_DEBUG.set_curr_function( p_function => 'CHECK_MOVE_FINANCIAL_TASK_OK',

Line 2283: x_return_status := FND_API.G_RET_STS_ERROR;

2279: THEN
2280:
2281: --Raise an error message
2282: x_error_msg_code := 'PA_CANT_MOVE_SELECTED_TASK';
2283: x_return_status := FND_API.G_RET_STS_ERROR;
2284: return;
2285: END IF;
2286: END IF;
2287:

Line 2292: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

2288: EXCEPTION
2289:
2290: WHEN OTHERS THEN
2291:
2292: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2293: x_msg_count := 1;
2294: x_msg_data := SQLERRM;
2295:
2296: -- 4537865 : RESET x_error_message_code also

Line 2384: x_return_status := FND_API.G_RET_STS_SUCCESS;

2380: );
2381:
2382: BEGIN
2383: x_msg_count := 0;
2384: x_return_status := FND_API.G_RET_STS_SUCCESS;
2385: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2386:
2387: IF l_debug_mode = 'Y' THEN
2388: PA_DEBUG.set_curr_function( p_function => 'CHECK_WORKPLAN_TASK_EXISTS',

Line 2411: x_return_status := FND_API.G_RET_STS_ERROR;

2407: IF (l_fin_flag = 'X')
2408: THEN
2409: --Populate error message
2410: x_error_msg_code := 'PA_WORKPLAN_TASK_EXISTS';
2411: x_return_status := FND_API.G_RET_STS_ERROR;
2412:
2413: END IF;
2414: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS )
2415: THEN

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

2410: x_error_msg_code := 'PA_WORKPLAN_TASK_EXISTS';
2411: x_return_status := FND_API.G_RET_STS_ERROR;
2412:
2413: END IF;
2414: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS )
2415: THEN
2416: return;
2417: END IF;
2418:

Line 2423: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

2419: EXCEPTION
2420:
2421: WHEN OTHERS THEN
2422:
2423: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2424: x_msg_count := 1;
2425: x_msg_data := SQLERRM;
2426:
2427: -- 4537865 : RESET x_error_message_code also

Line 2518: RAISE FND_API.G_EXC_ERROR;

2514: p_value1 => x_ei_date);
2515: x_msg_data := 'PA_EI_INVALID_DATES';
2516: */
2517: -- End Changes for bug 6467429
2518: RAISE FND_API.G_EXC_ERROR;
2519: ELSE
2520: close cur_date;
2521: END IF ;
2522: END IF ;

Line 2523: x_return_status := FND_API.G_RET_STS_SUCCESS;

2519: ELSE
2520: close cur_date;
2521: END IF ;
2522: END IF ;
2523: x_return_status := FND_API.G_RET_STS_SUCCESS;
2524:
2525: EXCEPTION
2526: WHEN FND_API.G_EXC_ERROR THEN
2527: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2526: WHEN FND_API.G_EXC_ERROR THEN

2522: END IF ;
2523: x_return_status := FND_API.G_RET_STS_SUCCESS;
2524:
2525: EXCEPTION
2526: WHEN FND_API.G_EXC_ERROR THEN
2527: x_return_status := FND_API.G_RET_STS_ERROR;
2528: x_msg_count := FND_MSG_PUB.count_msg;
2529: WHEN OTHERS THEN
2530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2527: x_return_status := FND_API.G_RET_STS_ERROR;

2523: x_return_status := FND_API.G_RET_STS_SUCCESS;
2524:
2525: EXCEPTION
2526: WHEN FND_API.G_EXC_ERROR THEN
2527: x_return_status := FND_API.G_RET_STS_ERROR;
2528: x_msg_count := FND_MSG_PUB.count_msg;
2529: WHEN OTHERS THEN
2530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2531: -- 4537865 : RESET x_msg_count, x_msg_data also

Line 2530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2526: WHEN FND_API.G_EXC_ERROR THEN
2527: x_return_status := FND_API.G_RET_STS_ERROR;
2528: x_msg_count := FND_MSG_PUB.count_msg;
2529: WHEN OTHERS THEN
2530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2531: -- 4537865 : RESET x_msg_count, x_msg_data also
2532: x_msg_count := 1 ;
2533: x_msg_data := SUBSTRB(SQLERRM,1,240);
2534:

Line 2608: RAISE FND_API.G_EXC_ERROR;

2604: p_value1 => x_ei_min_date);
2605: x_msg_data := 'PA_EI_INVALID_START_DATE';
2606: */
2607: -- End Changes for Bug 6633233
2608: RAISE FND_API.G_EXC_ERROR;
2609: ELSE
2610: close cur_start_date;
2611: END IF ;
2612: END IF ;

Line 2613: x_return_status := FND_API.G_RET_STS_SUCCESS;

2609: ELSE
2610: close cur_start_date;
2611: END IF ;
2612: END IF ;
2613: x_return_status := FND_API.G_RET_STS_SUCCESS;
2614:
2615: EXCEPTION
2616: WHEN FND_API.G_EXC_ERROR THEN
2617: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2616: WHEN FND_API.G_EXC_ERROR THEN

2612: END IF ;
2613: x_return_status := FND_API.G_RET_STS_SUCCESS;
2614:
2615: EXCEPTION
2616: WHEN FND_API.G_EXC_ERROR THEN
2617: x_return_status := FND_API.G_RET_STS_ERROR;
2618: x_msg_count := FND_MSG_PUB.count_msg;
2619: WHEN OTHERS THEN
2620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2617: x_return_status := FND_API.G_RET_STS_ERROR;

2613: x_return_status := FND_API.G_RET_STS_SUCCESS;
2614:
2615: EXCEPTION
2616: WHEN FND_API.G_EXC_ERROR THEN
2617: x_return_status := FND_API.G_RET_STS_ERROR;
2618: x_msg_count := FND_MSG_PUB.count_msg;
2619: WHEN OTHERS THEN
2620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2621: -- 4537865 : RESET x_msg_count, x_msg_data also

Line 2620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2616: WHEN FND_API.G_EXC_ERROR THEN
2617: x_return_status := FND_API.G_RET_STS_ERROR;
2618: x_msg_count := FND_MSG_PUB.count_msg;
2619: WHEN OTHERS THEN
2620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2621: -- 4537865 : RESET x_msg_count, x_msg_data also
2622: x_msg_count := 1 ;
2623: x_msg_data := SUBSTRB(SQLERRM,1,240);
2624: