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

Line 33: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

29: -- 02-DEC-96 Update lwerker Removed Savepoint and Rollbacks
30:
31: PROCEDURE Check_Delete_Task_OK_pvt
32: ( p_api_version_number IN NUMBER
33: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
34: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
35: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
36: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
37: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 97: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

93:
94: BEGIN
95:
96:
97: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
98: p_api_version_number ,
99: l_api_name ,
100: G_PKG_NAME )
101: THEN

Line 102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

98: p_api_version_number ,
99: l_api_name ,
100: G_PKG_NAME )
101: THEN
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: END IF;
104:
105: IF FND_API.TO_BOOLEAN( p_init_msg_list )
106: THEN

Line 105: IF FND_API.TO_BOOLEAN( p_init_msg_list )

101: THEN
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: END IF;
104:
105: IF FND_API.TO_BOOLEAN( p_init_msg_list )
106: THEN
107: FND_MSG_PUB.initialize;
108: END IF;
109:

Line 110: p_return_status := FND_API.G_RET_STS_SUCCESS;

106: THEN
107: FND_MSG_PUB.initialize;
108: END IF;
109:
110: p_return_status := FND_API.G_RET_STS_SUCCESS;
111:
112: PA_PROJECT_PVT.Convert_pm_projref_to_id
113: ( p_pm_project_reference => p_pm_project_reference
114: , p_pa_project_id => p_project_id

Line 118: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

114: , p_pa_project_id => p_project_id
115: , p_out_project_id => l_project_id_out
116: , p_return_status => l_return_status );
117:
118: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
119: THEN
120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
121:
122: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)

Line 120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

116: , p_return_status => l_return_status );
117:
118: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
119: THEN
120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
121:
122: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
123: THEN
124:

Line 122: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)

118: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
119: THEN
120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
121:
122: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
123: THEN
124:
125: RAISE FND_API.G_EXC_ERROR;
126: END IF;

Line 125: RAISE FND_API.G_EXC_ERROR;

121:
122: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
123: THEN
124:
125: RAISE FND_API.G_EXC_ERROR;
126: END IF;
127:
128: -- Added for the bug 4728670
129: /* Bug #5050424: Calling the API Convert_pm_taskref_to_id_all instead

Line 188: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

184: , p_out_task_id => l_task_id_out
185: , p_return_status => l_return_status );
186:
187: -- End of Bug Fix 5263429
188: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
189: THEN
190:
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192:

Line 191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

187: -- End of Bug Fix 5263429
188: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
189: THEN
190:
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192:
193: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
194: THEN
195:

Line 193: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)

189: THEN
190:
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192:
193: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
194: THEN
195:
196: RAISE FND_API.G_EXC_ERROR;
197: END IF;

Line 196: RAISE FND_API.G_EXC_ERROR;

192:
193: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
194: THEN
195:
196: RAISE FND_API.G_EXC_ERROR;
197: END IF;
198: -- end for the bug 4738608
199:
200: --Project Structure changes done for bug 2765115

Line 223: RAISE FND_API.G_EXC_ERROR;

219: ,p_attribute3 => ''
220: ,p_attribute4 => ''
221: ,p_attribute5 => '');
222: END IF;
223: RAISE FND_API.G_EXC_ERROR;
224: END IF;
225:
226: --get structure_version_id and task_version_id
227:

Line 244: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

240: , p_pa_project_id => p_project_id
241: , p_out_project_id => l_project_id_out
242: , p_return_status => l_return_status );
243:
244: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
245: THEN
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247:
248: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)

Line 246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

242: , p_return_status => l_return_status );
243:
244: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
245: THEN
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247:
248: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
249: THEN
250:

Line 248: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)

244: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
245: THEN
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247:
248: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
249: THEN
250:
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;

Line 251: RAISE FND_API.G_EXC_ERROR;

247:
248: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
249: THEN
250:
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;
253: */ --moved up
254:
255:

Line 275: RAISE FND_API.G_EXC_ERROR;

271: ,p_attribute3 => ''
272: ,p_attribute4 => ''
273: ,p_attribute5 => '');
274: END IF;
275: RAISE FND_API.G_EXC_ERROR;
276: END IF;
277: --bug 2893028
278:
279: IF p_structure_type = 'FINANCIAL' --Project Structure changes done for bug 2765115

Line 306: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

302: , p_pm_task_reference => p_pm_task_reference
303: , p_out_task_id => l_task_id_out
304: , p_return_status => l_return_status );
305:
306: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
307: THEN
308:
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310:

Line 309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

305:
306: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
307: THEN
308:
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310:
311: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
312: THEN
313:

Line 311: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)

307: THEN
308:
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310:
311: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
312: THEN
313:
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;

Line 314: RAISE FND_API.G_EXC_ERROR;

310:
311: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
312: THEN
313:
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316: */
317: l_amg_task_number := pa_interface_utils_pub.get_task_number_amg
318: (p_task_number=> ''

Line 426: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

422: END IF;
423: END IF;
424: */
425: --Project Structure changes done for bug 2765115
426: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
427: RAISE FND_API.G_EXC_ERROR;
428:
429: ELSE --l_err_code = 0
430: p_delete_task_ok_flag := 'Y';

Line 427: RAISE FND_API.G_EXC_ERROR;

423: END IF;
424: */
425: --Project Structure changes done for bug 2765115
426: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
427: RAISE FND_API.G_EXC_ERROR;
428:
429: ELSE --l_err_code = 0
430: p_delete_task_ok_flag := 'Y';
431: END IF;

Line 435: WHEN FND_API.G_EXC_ERROR

431: END IF;
432:
433: EXCEPTION
434:
435: WHEN FND_API.G_EXC_ERROR
436: THEN
437: p_return_status := FND_API.G_RET_STS_ERROR;
438:
439: -- 4537865 : RESET OUT PARAM VALUES

Line 437: p_return_status := FND_API.G_RET_STS_ERROR;

433: EXCEPTION
434:
435: WHEN FND_API.G_EXC_ERROR
436: THEN
437: p_return_status := FND_API.G_RET_STS_ERROR;
438:
439: -- 4537865 : RESET OUT PARAM VALUES
440: p_delete_task_ok_flag := 'N' ; -- Made this value as 'N' as per logic in the API
441:

Line 448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

444: p_encoded => 'F', -- Added for Issues found during Unit Testing 4096218
445: p_count => p_msg_count ,
446: p_data => p_msg_data );
447:
448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
449: THEN
450: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
451:
452: -- 4537865 : RESET OUT PARAM VALUES

Line 450: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

446: p_data => p_msg_data );
447:
448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
449: THEN
450: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
451:
452: -- 4537865 : RESET OUT PARAM VALUES
453: p_delete_task_ok_flag := 'N' ; -- Made this value as 'N' as per logic in the API
454:

Line 461: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

457: p_data => p_msg_data );
458:
459: WHEN OTHERS
460: THEN
461: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462:
463: -- 4537865 : RESET OUT PARAM VALUES
464: p_delete_task_ok_flag := 'N' ; -- Made this value as 'N' as per logic in the API
465:

Line 496: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

492: --
493:
494: PROCEDURE Check_Add_Subtask_OK_pvt
495: (p_api_version_number IN NUMBER
496: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
497: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
498: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
499: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
500: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 539: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

535: WHERE p.task_id = p_pa_task_id;
536:
537: BEGIN
538:
539: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
540: p_api_version_number ,
541: l_api_name ,
542: G_PKG_NAME )
543: THEN

Line 544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

540: p_api_version_number ,
541: l_api_name ,
542: G_PKG_NAME )
543: THEN
544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
545: END IF;
546:
547:
548: IF FND_API.TO_BOOLEAN( p_init_msg_list )

Line 548: IF FND_API.TO_BOOLEAN( p_init_msg_list )

544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
545: END IF;
546:
547:
548: IF FND_API.TO_BOOLEAN( p_init_msg_list )
549: THEN
550: FND_MSG_PUB.initialize;
551: END IF;
552:

Line 553: p_return_status := FND_API.G_RET_STS_SUCCESS;

549: THEN
550: FND_MSG_PUB.initialize;
551: END IF;
552:
553: p_return_status := FND_API.G_RET_STS_SUCCESS;
554:
555: PA_PROJECT_PVT.Convert_pm_projref_to_id
556: ( p_pm_project_reference => p_pm_project_reference
557: , p_pa_project_id => p_project_id

Line 561: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

557: , p_pa_project_id => p_project_id
558: , p_out_project_id => l_project_id_out
559: , p_return_status => l_return_status );
560:
561: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
562: THEN
563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
564:
565: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)

Line 563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

559: , p_return_status => l_return_status );
560:
561: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
562: THEN
563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
564:
565: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
566: THEN
567:

Line 565: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)

561: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
562: THEN
563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
564:
565: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
566: THEN
567:
568: RAISE FND_API.G_EXC_ERROR;
569: END IF;

Line 568: RAISE FND_API.G_EXC_ERROR;

564:
565: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
566: THEN
567:
568: RAISE FND_API.G_EXC_ERROR;
569: END IF;
570:
571:
572: PA_PROJECT_PVT.Convert_pm_taskref_to_id

Line 579: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

575: , p_pm_task_reference => p_pm_task_reference
576: , p_out_task_id => l_task_id_out
577: , p_return_status => l_return_status );
578:
579: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
580: THEN
581:
582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
583:

Line 582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

578:
579: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
580: THEN
581:
582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
583:
584: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
585: THEN
586:

Line 584: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)

580: THEN
581:
582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
583:
584: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
585: THEN
586:
587: RAISE FND_API.G_EXC_ERROR;
588: END IF;

Line 587: RAISE FND_API.G_EXC_ERROR;

583:
584: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
585: THEN
586:
587: RAISE FND_API.G_EXC_ERROR;
588: END IF;
589:
590: -- Get segment1 for AMG messages
591:

Line 672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

668: ,p_attribute5 => '');
669: END IF;
670: END IF;
671:
672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
673:
674: ELSE --l_err_code = 0
675:
676: p_add_subtask_ok_flag := 'Y';

Line 683: WHEN FND_API.G_EXC_ERROR

679:
680:
681: EXCEPTION
682:
683: WHEN FND_API.G_EXC_ERROR
684: THEN
685: p_return_status := FND_API.G_RET_STS_ERROR;
686:
687: -- 4537865 RESET OUT param value

Line 685: p_return_status := FND_API.G_RET_STS_ERROR;

681: EXCEPTION
682:
683: WHEN FND_API.G_EXC_ERROR
684: THEN
685: p_return_status := FND_API.G_RET_STS_ERROR;
686:
687: -- 4537865 RESET OUT param value
688: p_add_subtask_ok_flag := 'N' ;
689:

Line 695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

691: ( p_count => p_msg_count ,
692: p_data => p_msg_data );
693:
694:
695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
696: THEN
697: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
698:
699: -- 4537865 RESET OUT param value

Line 697: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

693:
694:
695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
696: THEN
697: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
698:
699: -- 4537865 RESET OUT param value
700: p_add_subtask_ok_flag := 'N' ;
701:

Line 709: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

705:
706:
707: WHEN OTHERS
708: THEN
709: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
710:
711: -- 4537865 RESET OUT param value
712: p_add_subtask_ok_flag := 'N' ;
713:

Line 744: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

740: -- 02-DEC-96 Update lwerker Removed Savepoint and Rollbacks
741: --
742: PROCEDURE Check_Unique_Task_Ref_pvt
743: (p_api_version_number IN NUMBER
744: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
745: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
746: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
747: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
748: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 781: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

777: l_exists_status NUMBER := 1;
778:
779: BEGIN
780:
781: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
782: p_api_version_number ,
783: l_api_name ,
784: G_PKG_NAME )
785: THEN

Line 786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

782: p_api_version_number ,
783: l_api_name ,
784: G_PKG_NAME )
785: THEN
786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
787: END IF;
788:
789: IF FND_API.TO_BOOLEAN( p_init_msg_list )
790: THEN

Line 789: IF FND_API.TO_BOOLEAN( p_init_msg_list )

785: THEN
786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
787: END IF;
788:
789: IF FND_API.TO_BOOLEAN( p_init_msg_list )
790: THEN
791: FND_MSG_PUB.initialize;
792: END IF;
793:

Line 794: p_return_status := FND_API.G_RET_STS_SUCCESS;

790: THEN
791: FND_MSG_PUB.initialize;
792: END IF;
793:
794: p_return_status := FND_API.G_RET_STS_SUCCESS;
795:
796: PA_PROJECT_PVT.Convert_pm_projref_to_id
797: ( p_pm_project_reference => p_pm_project_reference
798: , p_pa_project_id => p_project_id

Line 802: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

798: , p_pa_project_id => p_project_id
799: , p_out_project_id => l_project_id_out
800: , p_return_status => l_return_status );
801:
802: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
803: THEN
804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805:
806: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)

Line 804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

800: , p_return_status => l_return_status );
801:
802: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
803: THEN
804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805:
806: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
807: THEN
808:

Line 806: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)

802: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
803: THEN
804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805:
806: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
807: THEN
808:
809: RAISE FND_API.G_EXC_ERROR;
810: END IF;

Line 809: RAISE FND_API.G_EXC_ERROR;

805:
806: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
807: THEN
808:
809: RAISE FND_API.G_EXC_ERROR;
810: END IF;
811:
812: OPEN l_unique_task_ref_csr( l_project_id_out, p_pm_task_reference );
813: FETCH l_unique_task_ref_csr INTO l_dummy;

Line 828: WHEN FND_API.G_EXC_ERROR

824: CLOSE l_unique_task_ref_csr;
825:
826:
827: EXCEPTION
828: WHEN FND_API.G_EXC_ERROR
829: THEN
830: p_return_status := FND_API.G_RET_STS_ERROR;
831: -- 4537865 : RESET OUT param values.
832: p_unique_task_ref_flag := 'N' ;

Line 830: p_return_status := FND_API.G_RET_STS_ERROR;

826:
827: EXCEPTION
828: WHEN FND_API.G_EXC_ERROR
829: THEN
830: p_return_status := FND_API.G_RET_STS_ERROR;
831: -- 4537865 : RESET OUT param values.
832: p_unique_task_ref_flag := 'N' ;
833:
834: FND_MSG_PUB.Count_And_Get

Line 838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

834: FND_MSG_PUB.Count_And_Get
835: ( p_count => p_msg_count ,
836: p_data => p_msg_data );
837:
838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
839: THEN
840: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
841: -- 4537865 : RESET OUT param values.
842: p_unique_task_ref_flag := 'N' ;

Line 840: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

836: p_data => p_msg_data );
837:
838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
839: THEN
840: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
841: -- 4537865 : RESET OUT param values.
842: p_unique_task_ref_flag := 'N' ;
843:
844: FND_MSG_PUB.Count_And_Get

Line 850: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

846: p_data => p_msg_data );
847:
848: WHEN OTHERS
849: THEN
850: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
851: -- 4537865 : RESET OUT param values.
852: p_unique_task_ref_flag := 'N' ;
853:
854: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 887: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

883: -- Removed Savepoint and Rollbacks
884: --
885: PROCEDURE Check_Unique_Project_Ref_pvt
886: (p_api_version_number IN NUMBER
887: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
888: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
889: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
890: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
891: , p_pm_project_reference IN VARCHAR2

Line 919: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

915: l_exists_status NUMBER := 1;
916:
917: BEGIN
918:
919: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
920: p_api_version_number ,
921: l_api_name ,
922: G_PKG_NAME )
923: THEN

Line 924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

920: p_api_version_number ,
921: l_api_name ,
922: G_PKG_NAME )
923: THEN
924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
925: END IF;
926:
927: IF FND_API.TO_BOOLEAN( p_init_msg_list )
928: THEN

Line 927: IF FND_API.TO_BOOLEAN( p_init_msg_list )

923: THEN
924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
925: END IF;
926:
927: IF FND_API.TO_BOOLEAN( p_init_msg_list )
928: THEN
929: FND_MSG_PUB.initialize;
930: END IF;
931:

Line 932: p_return_status := FND_API.G_RET_STS_SUCCESS;

928: THEN
929: FND_MSG_PUB.initialize;
930: END IF;
931:
932: p_return_status := FND_API.G_RET_STS_SUCCESS;
933:
934: OPEN l_unique_project_ref_csr( p_pm_project_reference );
935: FETCH l_unique_project_ref_csr INTO l_dummy;
936:

Line 950: WHEN FND_API.G_EXC_ERROR

946: CLOSE l_unique_project_ref_csr;
947:
948: EXCEPTION
949:
950: WHEN FND_API.G_EXC_ERROR
951: THEN
952: p_return_status := FND_API.G_RET_STS_ERROR;
953: -- 4537865 : RESET OUT param values
954: p_unique_project_ref_flag := 'N';

Line 952: p_return_status := FND_API.G_RET_STS_ERROR;

948: EXCEPTION
949:
950: WHEN FND_API.G_EXC_ERROR
951: THEN
952: p_return_status := FND_API.G_RET_STS_ERROR;
953: -- 4537865 : RESET OUT param values
954: p_unique_project_ref_flag := 'N';
955:
956: FND_MSG_PUB.Count_And_Get

Line 960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

956: FND_MSG_PUB.Count_And_Get
957: ( p_count => p_msg_count ,
958: p_data => p_msg_data );
959:
960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
961: THEN
962: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
963: -- 4537865 : RESET OUT param values
964: p_unique_project_ref_flag := 'N';

Line 962: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

958: p_data => p_msg_data );
959:
960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
961: THEN
962: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
963: -- 4537865 : RESET OUT param values
964: p_unique_project_ref_flag := 'N';
965:
966: FND_MSG_PUB.Count_And_Get

Line 972: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

968: p_data => p_msg_data );
969:
970: WHEN OTHERS
971: THEN
972: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
973: -- 4537865 : RESET OUT param values
974: p_unique_project_ref_flag := 'N';
975:
976: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1006: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1002: --
1003:
1004: PROCEDURE Check_Delete_Project_OK_pvt
1005: (p_api_version_number IN NUMBER
1006: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1007: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1008: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
1009: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1010: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1039: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

1035: WHERE p.project_id = p_pa_project_id;
1036:
1037: BEGIN
1038:
1039: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
1040: p_api_version_number ,
1041: l_api_name ,
1042: G_PKG_NAME )
1043: THEN

Line 1044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1040: p_api_version_number ,
1041: l_api_name ,
1042: G_PKG_NAME )
1043: THEN
1044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1045: END IF;
1046:
1047: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1048: THEN

Line 1047: IF FND_API.TO_BOOLEAN( p_init_msg_list )

1043: THEN
1044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1045: END IF;
1046:
1047: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1048: THEN
1049: FND_MSG_PUB.initialize;
1050: END IF;
1051:

Line 1052: p_return_status := FND_API.G_RET_STS_SUCCESS;

1048: THEN
1049: FND_MSG_PUB.initialize;
1050: END IF;
1051:
1052: p_return_status := FND_API.G_RET_STS_SUCCESS;
1053:
1054:
1055: PA_PROJECT_PVT.Convert_pm_projref_to_id
1056: ( p_pm_project_reference => p_pm_project_reference

Line 1062: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1058: , p_out_project_id => l_project_id_out
1059: , p_return_status => l_return_status
1060: );
1061:
1062: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1063:
1064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1065:
1066: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1060: );
1061:
1062: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1063:
1064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1065:
1066: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1067:
1068: RAISE FND_API.G_EXC_ERROR;

Line 1066: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1062: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1063:
1064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1065:
1066: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1067:
1068: RAISE FND_API.G_EXC_ERROR;
1069: END IF;
1070:

Line 1068: RAISE FND_API.G_EXC_ERROR;

1064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1065:
1066: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1067:
1068: RAISE FND_API.G_EXC_ERROR;
1069: END IF;
1070:
1071: -- Get segment1 for AMG messages
1072:

Line 1143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1139: ,p_attribute5 => '');
1140: END IF;
1141: END IF;
1142:
1143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1144:
1145: ELSE --l_err_code = 0
1146:
1147: p_delete_project_ok_flag := 'Y';

Line 1154: WHEN FND_API.G_EXC_ERROR

1150:
1151:
1152: EXCEPTION
1153:
1154: WHEN FND_API.G_EXC_ERROR
1155: THEN
1156: p_return_status := FND_API.G_RET_STS_ERROR;
1157: -- 4537865 : RESET OUT PARAM VALUES
1158: p_delete_project_ok_flag := 'N' ;

Line 1156: p_return_status := FND_API.G_RET_STS_ERROR;

1152: EXCEPTION
1153:
1154: WHEN FND_API.G_EXC_ERROR
1155: THEN
1156: p_return_status := FND_API.G_RET_STS_ERROR;
1157: -- 4537865 : RESET OUT PARAM VALUES
1158: p_delete_project_ok_flag := 'N' ;
1159:
1160: FND_MSG_PUB.Count_And_Get

Line 1164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1160: FND_MSG_PUB.Count_And_Get
1161: ( p_count => p_msg_count ,
1162: p_data => p_msg_data );
1163:
1164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1165: THEN
1166: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1167: -- 4537865 : RESET OUT PARAM VALUES
1168: p_delete_project_ok_flag := 'N' ;

Line 1166: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1162: p_data => p_msg_data );
1163:
1164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1165: THEN
1166: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1167: -- 4537865 : RESET OUT PARAM VALUES
1168: p_delete_project_ok_flag := 'N' ;
1169:
1170: FND_MSG_PUB.Count_And_Get

Line 1176: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1172: p_data => p_msg_data );
1173:
1174: WHEN OTHERS
1175: THEN
1176: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1177: -- 4537865 : RESET OUT PARAM VALUES
1178: p_delete_project_ok_flag := 'N' ;
1179:
1180: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1210: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1206: -- Removed Savepoint and Rollbacks
1207: --
1208: PROCEDURE Check_Change_Parent_OK_pvt
1209: (p_api_version_number IN NUMBER
1210: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1211: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1212: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
1213: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1214: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1242: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

1238: l_change_parent_ok_flag VARCHAR2(1) := NULL;
1239:
1240: BEGIN
1241:
1242: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
1243: p_api_version_number ,
1244: l_api_name ,
1245: G_PKG_NAME )
1246: THEN

Line 1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1243: p_api_version_number ,
1244: l_api_name ,
1245: G_PKG_NAME )
1246: THEN
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1248: END IF;
1249:
1250: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1251: THEN

Line 1250: IF FND_API.TO_BOOLEAN( p_init_msg_list )

1246: THEN
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1248: END IF;
1249:
1250: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1251: THEN
1252: FND_MSG_PUB.initialize;
1253: END IF;
1254:

Line 1255: p_return_status := FND_API.G_RET_STS_SUCCESS;

1251: THEN
1252: FND_MSG_PUB.initialize;
1253: END IF;
1254:
1255: p_return_status := FND_API.G_RET_STS_SUCCESS;
1256:
1257:
1258: PA_PROJECT_PVT.Convert_pm_projref_to_id
1259: ( p_pm_project_reference => p_pm_project_reference

Line 1265: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

1261: , p_out_project_id => l_project_id_out
1262: , p_return_status => l_return_status
1263: );
1264:
1265: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1266: THEN
1267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1268:
1269: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)

Line 1267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1263: );
1264:
1265: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1266: THEN
1267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1268:
1269: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1270: THEN
1271: RAISE FND_API.G_EXC_ERROR;

Line 1269: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)

1265: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1266: THEN
1267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1268:
1269: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1270: THEN
1271: RAISE FND_API.G_EXC_ERROR;
1272: END IF;
1273:

Line 1271: RAISE FND_API.G_EXC_ERROR;

1267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1268:
1269: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1270: THEN
1271: RAISE FND_API.G_EXC_ERROR;
1272: END IF;
1273:
1274: PA_PROJECT_PVT.Convert_pm_taskref_to_id
1275: ( p_pa_project_id => l_project_id_out

Line 1282: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

1278: , p_out_task_id => l_task_id_out
1279: , p_return_status => l_return_status
1280: );
1281:
1282: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1283: THEN
1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1285:
1286: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)

Line 1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1280: );
1281:
1282: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1283: THEN
1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1285:
1286: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1287: THEN
1288: RAISE FND_API.G_EXC_ERROR;

Line 1286: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)

1282: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1283: THEN
1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1285:
1286: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1287: THEN
1288: RAISE FND_API.G_EXC_ERROR;
1289: END IF;
1290:

Line 1288: RAISE FND_API.G_EXC_ERROR;

1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1285:
1286: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1287: THEN
1288: RAISE FND_API.G_EXC_ERROR;
1289: END IF;
1290:
1291: PA_PROJECT_PVT.Convert_pm_taskref_to_id
1292: ( p_pa_project_id => l_project_id_out

Line 1298: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

1294: , p_pm_task_reference => p_pm_new_parent_task_reference
1295: , p_out_task_id => l_parent_task_id_out
1296: , p_return_status => l_return_status );
1297:
1298: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1299: THEN
1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1301:
1302: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)

Line 1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1296: , p_return_status => l_return_status );
1297:
1298: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1299: THEN
1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1301:
1302: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1303: THEN
1304: RAISE FND_API.G_EXC_ERROR;

Line 1302: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)

1298: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1299: THEN
1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1301:
1302: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1303: THEN
1304: RAISE FND_API.G_EXC_ERROR;
1305: END IF;
1306:

Line 1304: RAISE FND_API.G_EXC_ERROR;

1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1301:
1302: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1303: THEN
1304: RAISE FND_API.G_EXC_ERROR;
1305: END IF;
1306:
1307: BEGIN
1308: SELECT top_task_id

Line 1320: THEN RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1316: END IF;
1317:
1318: EXCEPTION
1319: WHEN OTHERS
1320: THEN RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1321: END;
1322:
1323:
1324: IF l_change_parent_ok_flag IS NULL

Line 1339: THEN RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1335: END IF;
1336:
1337: EXCEPTION
1338: WHEN OTHERS
1339: THEN RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1340: END;
1341: END IF;
1342:
1343: IF l_change_parent_ok_flag IS NULL

Line 1351: WHEN FND_API.G_EXC_ERROR

1347: p_change_parent_ok_flag := l_change_parent_ok_flag;
1348: END IF;
1349:
1350: EXCEPTION
1351: WHEN FND_API.G_EXC_ERROR
1352: THEN
1353: p_return_status := FND_API.G_RET_STS_ERROR;
1354:
1355: -- 4537865

Line 1353: p_return_status := FND_API.G_RET_STS_ERROR;

1349:
1350: EXCEPTION
1351: WHEN FND_API.G_EXC_ERROR
1352: THEN
1353: p_return_status := FND_API.G_RET_STS_ERROR;
1354:
1355: -- 4537865
1356: p_change_parent_ok_flag := 'N' ;
1357:

Line 1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1358: FND_MSG_PUB.Count_And_Get
1359: ( p_count => p_msg_count ,
1360: p_data => p_msg_data );
1361:
1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1363: THEN
1364: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1365: -- 4537865
1366: p_change_parent_ok_flag := 'N' ;

Line 1364: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1360: p_data => p_msg_data );
1361:
1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1363: THEN
1364: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1365: -- 4537865
1366: p_change_parent_ok_flag := 'N' ;
1367:
1368: FND_MSG_PUB.Count_And_Get

Line 1374: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1370: p_data => p_msg_data );
1371:
1372: WHEN OTHERS
1373: THEN
1374: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1375:
1376: -- 4537865
1377: p_change_parent_ok_flag := 'N' ;
1378:

Line 1409: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1405: --
1406:
1407: PROCEDURE Check_Change_Proj_Org_OK_pvt
1408: (p_api_version_number IN NUMBER
1409: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1410: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1411: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
1412: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1413: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1444: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

1440: WHERE p.project_id = p_pa_project_id;
1441:
1442: BEGIN
1443:
1444: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
1445: p_api_version_number ,
1446: l_api_name ,
1447: G_PKG_NAME )
1448: THEN

Line 1449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1445: p_api_version_number ,
1446: l_api_name ,
1447: G_PKG_NAME )
1448: THEN
1449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1450: END IF;
1451:
1452: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1453: THEN

Line 1452: IF FND_API.TO_BOOLEAN( p_init_msg_list )

1448: THEN
1449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1450: END IF;
1451:
1452: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1453: THEN
1454: FND_MSG_PUB.initialize;
1455: END IF;
1456:

Line 1457: p_return_status := FND_API.G_RET_STS_SUCCESS;

1453: THEN
1454: FND_MSG_PUB.initialize;
1455: END IF;
1456:
1457: p_return_status := FND_API.G_RET_STS_SUCCESS;
1458:
1459:
1460: PA_PROJECT_PVT.Convert_pm_projref_to_id
1461: ( p_pm_project_reference => p_pm_project_reference

Line 1467: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

1463: , p_out_project_id => l_project_id_out
1464: , p_return_status => l_return_status
1465: );
1466:
1467: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1468: THEN
1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1470: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1471: THEN

Line 1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1465: );
1466:
1467: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1468: THEN
1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1470: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1471: THEN
1472: RAISE FND_API.G_EXC_ERROR;
1473: END IF;

Line 1470: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)

1466:
1467: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1468: THEN
1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1470: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1471: THEN
1472: RAISE FND_API.G_EXC_ERROR;
1473: END IF;
1474:

Line 1472: RAISE FND_API.G_EXC_ERROR;

1468: THEN
1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1470: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1471: THEN
1472: RAISE FND_API.G_EXC_ERROR;
1473: END IF;
1474:
1475: -- Get segment1 for AMG messages
1476:

Line 1548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1544: ,p_attribute5 => '');
1545: END IF;
1546: END IF;
1547:
1548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1549:
1550: ELSE --l_err_code = 0
1551:
1552: p_change_project_org_ok_flag := 'Y';

Line 1557: WHEN FND_API.G_EXC_ERROR

1553:
1554: END IF;
1555:
1556: EXCEPTION
1557: WHEN FND_API.G_EXC_ERROR
1558: THEN
1559: p_return_status := FND_API.G_RET_STS_ERROR;
1560: -- 4537865 : RESET OUT PARAM VALUES
1561: p_change_project_org_ok_flag := 'N' ;

Line 1559: p_return_status := FND_API.G_RET_STS_ERROR;

1555:
1556: EXCEPTION
1557: WHEN FND_API.G_EXC_ERROR
1558: THEN
1559: p_return_status := FND_API.G_RET_STS_ERROR;
1560: -- 4537865 : RESET OUT PARAM VALUES
1561: p_change_project_org_ok_flag := 'N' ;
1562:
1563: FND_MSG_PUB.Count_And_Get

Line 1567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1563: FND_MSG_PUB.Count_And_Get
1564: ( p_count => p_msg_count ,
1565: p_data => p_msg_data );
1566:
1567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1568: THEN
1569: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1570: -- 4537865 : RESET OUT PARAM VALUES
1571: p_change_project_org_ok_flag := 'N' ;

Line 1569: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1565: p_data => p_msg_data );
1566:
1567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1568: THEN
1569: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1570: -- 4537865 : RESET OUT PARAM VALUES
1571: p_change_project_org_ok_flag := 'N' ;
1572:
1573: FND_MSG_PUB.Count_And_Get

Line 1579: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1575: p_data => p_msg_data );
1576:
1577: WHEN OTHERS
1578: THEN
1579: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1580:
1581: -- 4537865 : RESET OUT PARAM VALUES
1582: p_change_project_org_ok_flag := 'N' ;
1583:

Line 1614: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1610: --
1611:
1612: PROCEDURE Check_Unique_Task_Number_pvt
1613: (p_api_version_number IN NUMBER
1614: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1615: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1616: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
1617: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1618: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1649: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

1645:
1646:
1647: BEGIN
1648:
1649: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
1650: p_api_version_number ,
1651: l_api_name ,
1652: G_PKG_NAME )
1653: THEN

Line 1654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1650: p_api_version_number ,
1651: l_api_name ,
1652: G_PKG_NAME )
1653: THEN
1654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1655: END IF;
1656:
1657: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1658: THEN

Line 1657: IF FND_API.TO_BOOLEAN( p_init_msg_list )

1653: THEN
1654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1655: END IF;
1656:
1657: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1658: THEN
1659: FND_MSG_PUB.initialize;
1660: END IF;
1661:

Line 1662: p_return_status := FND_API.G_RET_STS_SUCCESS;

1658: THEN
1659: FND_MSG_PUB.initialize;
1660: END IF;
1661:
1662: p_return_status := FND_API.G_RET_STS_SUCCESS;
1663:
1664:
1665: PA_PROJECT_PVT.Convert_pm_projref_to_id
1666: ( p_pm_project_reference => p_pm_project_reference

Line 1672: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

1668: , p_out_project_id => l_project_id_out
1669: , p_return_status => l_return_status
1670: );
1671:
1672: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1673: THEN
1674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1675: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1676: THEN

Line 1674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1670: );
1671:
1672: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1673: THEN
1674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1675: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1676: THEN
1677: RAISE FND_API.G_EXC_ERROR;
1678: END IF;

Line 1675: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)

1671:
1672: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1673: THEN
1674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1675: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1676: THEN
1677: RAISE FND_API.G_EXC_ERROR;
1678: END IF;
1679:

Line 1677: RAISE FND_API.G_EXC_ERROR;

1673: THEN
1674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1675: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1676: THEN
1677: RAISE FND_API.G_EXC_ERROR;
1678: END IF;
1679:
1680: OPEN l_unique_task_num_csr( l_project_id_out, p_task_number );
1681: FETCH l_unique_task_num_csr INTO l_dummy;

Line 1696: WHEN FND_API.G_EXC_ERROR

1692: CLOSE l_unique_task_num_csr;
1693:
1694:
1695: EXCEPTION
1696: WHEN FND_API.G_EXC_ERROR
1697: THEN
1698: p_return_status := FND_API.G_RET_STS_ERROR;
1699: -- 4537865 : RESET OUT PARAM VALUES
1700: p_unique_task_number_flag := 'N';

Line 1698: p_return_status := FND_API.G_RET_STS_ERROR;

1694:
1695: EXCEPTION
1696: WHEN FND_API.G_EXC_ERROR
1697: THEN
1698: p_return_status := FND_API.G_RET_STS_ERROR;
1699: -- 4537865 : RESET OUT PARAM VALUES
1700: p_unique_task_number_flag := 'N';
1701:
1702: FND_MSG_PUB.Count_And_Get

Line 1706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1702: FND_MSG_PUB.Count_And_Get
1703: ( p_count => p_msg_count ,
1704: p_data => p_msg_data );
1705:
1706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1707: THEN
1708: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1709: -- 4537865 : RESET OUT PARAM VALUES
1710: p_unique_task_number_flag := 'N';

Line 1708: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1704: p_data => p_msg_data );
1705:
1706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1707: THEN
1708: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1709: -- 4537865 : RESET OUT PARAM VALUES
1710: p_unique_task_number_flag := 'N';
1711:
1712: FND_MSG_PUB.Count_And_Get

Line 1718: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1714: p_data => p_msg_data );
1715:
1716: WHEN OTHERS
1717: THEN
1718: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1719: -- 4537865 : RESET OUT PARAM VALUES
1720: p_unique_task_number_flag := 'N';
1721:
1722: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1752: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1748: -- Removed Savepoint and Rollbacks
1749:
1750: PROCEDURE Check_Task_Numb_Change_Ok_pvt
1751: ( p_api_version_number IN NUMBER
1752: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1753: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1754: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
1755: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1756: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1797: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

1793: WHERE p.task_id = p_pa_task_id;
1794:
1795: BEGIN
1796:
1797: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
1798: p_api_version_number ,
1799: l_api_name ,
1800: G_PKG_NAME )
1801: THEN

Line 1802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1798: p_api_version_number ,
1799: l_api_name ,
1800: G_PKG_NAME )
1801: THEN
1802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1803: END IF;
1804:
1805: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1806: THEN

Line 1805: IF FND_API.TO_BOOLEAN( p_init_msg_list )

1801: THEN
1802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1803: END IF;
1804:
1805: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1806: THEN
1807: FND_MSG_PUB.initialize;
1808: END IF;
1809:

Line 1810: p_return_status := FND_API.G_RET_STS_SUCCESS;

1806: THEN
1807: FND_MSG_PUB.initialize;
1808: END IF;
1809:
1810: p_return_status := FND_API.G_RET_STS_SUCCESS;
1811:
1812:
1813: PA_PROJECT_PVT.Convert_pm_projref_to_id
1814: ( p_pm_project_reference => p_pm_project_reference

Line 1820: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

1816: , p_out_project_id => l_project_id_out
1817: , p_return_status => l_return_status
1818: );
1819:
1820: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1821: THEN
1822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1823: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1824: THEN

Line 1822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1818: );
1819:
1820: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1821: THEN
1822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1823: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1824: THEN
1825: RAISE FND_API.G_EXC_ERROR;
1826: END IF;

Line 1823: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)

1819:
1820: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1821: THEN
1822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1823: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1824: THEN
1825: RAISE FND_API.G_EXC_ERROR;
1826: END IF;
1827:

Line 1825: RAISE FND_API.G_EXC_ERROR;

1821: THEN
1822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1823: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1824: THEN
1825: RAISE FND_API.G_EXC_ERROR;
1826: END IF;
1827:
1828: PA_PROJECT_PVT.Convert_pm_taskref_to_id
1829: ( p_pa_project_id => l_project_id_out

Line 1836: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

1832: , p_out_task_id => l_task_id_out
1833: , p_return_status => l_return_status
1834: );
1835:
1836: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1837: THEN
1838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1839: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1840: THEN

Line 1838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1834: );
1835:
1836: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1837: THEN
1838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1839: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1840: THEN
1841: RAISE FND_API.G_EXC_ERROR;
1842: END IF;

Line 1839: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)

1835:
1836: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1837: THEN
1838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1839: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1840: THEN
1841: RAISE FND_API.G_EXC_ERROR;
1842: END IF;
1843:

Line 1841: RAISE FND_API.G_EXC_ERROR;

1837: THEN
1838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1839: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
1840: THEN
1841: RAISE FND_API.G_EXC_ERROR;
1842: END IF;
1843:
1844: -- Get segment1 for AMG messages
1845:

Line 1928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1924: ,p_attribute5 => '');
1925: END IF;
1926: END IF;
1927:
1928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1929:
1930: ELSE --l_err_code = 0
1931:
1932: p_task_number_change_Ok_flag := 'Y';

Line 1938: WHEN FND_API.G_EXC_ERROR

1934: END IF;
1935:
1936:
1937: EXCEPTION
1938: WHEN FND_API.G_EXC_ERROR
1939: THEN
1940: p_return_status := FND_API.G_RET_STS_ERROR;
1941: -- 4537865 : RESET OUT PARAM VALUES
1942: p_task_number_change_Ok_flag := 'N' ;

Line 1940: p_return_status := FND_API.G_RET_STS_ERROR;

1936:
1937: EXCEPTION
1938: WHEN FND_API.G_EXC_ERROR
1939: THEN
1940: p_return_status := FND_API.G_RET_STS_ERROR;
1941: -- 4537865 : RESET OUT PARAM VALUES
1942: p_task_number_change_Ok_flag := 'N' ;
1943:
1944: FND_MSG_PUB.Count_And_Get

Line 1948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1944: FND_MSG_PUB.Count_And_Get
1945: ( p_count => p_msg_count ,
1946: p_data => p_msg_data );
1947:
1948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1949: THEN
1950: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1951: -- 4537865 : RESET OUT PARAM VALUES
1952: p_task_number_change_Ok_flag := 'N' ;

Line 1950: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1946: p_data => p_msg_data );
1947:
1948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1949: THEN
1950: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1951: -- 4537865 : RESET OUT PARAM VALUES
1952: p_task_number_change_Ok_flag := 'N' ;
1953:
1954: FND_MSG_PUB.Count_And_Get

Line 1960: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1956: p_data => p_msg_data );
1957:
1958: WHEN OTHERS
1959: THEN
1960: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1961: -- 4537865 : RESET OUT PARAM VALUES
1962: p_task_number_change_Ok_flag := 'N' ;
1963:
1964: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2137: p_return_status := FND_API.G_RET_STS_SUCCESS ;

2133:
2134: BEGIN
2135:
2136: -- Initialize p_return_status as Success
2137: p_return_status := FND_API.G_RET_STS_SUCCESS ;
2138: l_project_id := p_project_id; -- Added for bug 5643876
2139: l_task_rec := p_in_task_rec;
2140:
2141: -- Get segment1 for AMG messages

Line 2174: RAISE FND_API.G_EXC_ERROR;

2170: ,p_attribute3 => ''
2171: ,p_attribute4 => ''
2172: ,p_attribute5 => '');
2173: END IF;
2174: RAISE FND_API.G_EXC_ERROR;
2175: END IF;
2176:
2177: IF (l_task_rec.non_labor_sch_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2178: AND l_task_rec.non_labor_sch_type IS NOT NULL)

Line 2194: RAISE FND_API.G_EXC_ERROR;

2190: ,p_attribute3 => ''
2191: ,p_attribute4 => ''
2192: ,p_attribute5 => '');
2193: END IF;
2194: RAISE FND_API.G_EXC_ERROR;
2195: END IF;
2196: /* Commented for Bug No 4721987
2197: IF l_task_rec.labor_sch_type = 'I' -- (I- burden schedule B-Bill rate sch)
2198: -- ensure that bill rate orgid is not supplied

Line 2215: RAISE FND_API.G_EXC_ERROR;

2211: ,p_attribute3 => ''
2212: ,p_attribute4 => ''
2213: ,p_attribute5 => '');
2214: END IF;
2215: RAISE FND_API.G_EXC_ERROR;
2216: END IF;*/
2217:
2218: IF l_task_rec.non_labor_sch_type = 'I' --(I- burden schedule B-Bill rate sch)
2219: -- ensure that bill rate orgid is not supplied

Line 2236: RAISE FND_API.G_EXC_ERROR;

2232: ,p_attribute3 => ''
2233: ,p_attribute4 => ''
2234: ,p_attribute5 => '');
2235: END IF;
2236: RAISE FND_API.G_EXC_ERROR;
2237: END IF;
2238:
2239:
2240: IF (l_task_rec.labor_sch_type = 'I' OR l_task_rec.non_labor_sch_type = 'I' )

Line 2262: RAISE FND_API.G_EXC_ERROR;

2258: ,p_attribute3 => ''
2259: ,p_attribute4 => ''
2260: ,p_attribute5 => '');
2261: END IF;
2262: RAISE FND_API.G_EXC_ERROR;
2263: END IF;
2264:
2265: -- ensure that revenue schedule is specified
2266: IF l_task_rec.rev_ind_rate_sch_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2282: RAISE FND_API.G_EXC_ERROR;

2278: ,p_attribute3 => ''
2279: ,p_attribute4 => ''
2280: ,p_attribute5 => '');
2281: END IF;
2282: RAISE FND_API.G_EXC_ERROR;
2283: END IF;
2284:
2285: -- validate invoice schedule
2286: OPEN l_burden_sch_csr (l_task_rec.inv_ind_rate_sch_id);

Line 2306: RAISE FND_API.G_EXC_ERROR;

2302: ,p_attribute3 => ''
2303: ,p_attribute4 => ''
2304: ,p_attribute5 => '');
2305: END IF;
2306: RAISE FND_API.G_EXC_ERROR;
2307:
2308: ELSE
2309: CLOSE l_burden_sch_csr;
2310: END IF;

Line 2331: RAISE FND_API.G_EXC_ERROR;

2327: ,p_attribute3 => ''
2328: ,p_attribute4 => ''
2329: ,p_attribute5 => '');
2330: END IF;
2331: RAISE FND_API.G_EXC_ERROR;
2332:
2333: ELSE
2334: CLOSE l_burden_sch_csr;
2335: END IF;

Line 2358: RAISE FND_API.G_EXC_ERROR;

2354: ,p_attribute3 => ''
2355: ,p_attribute4 => ''
2356: ,p_attribute5 => '');
2357: END IF;
2358: RAISE FND_API.G_EXC_ERROR;
2359: END IF;
2360:
2361: OPEN l_labor_bill_rate_org_csr (l_task_rec.labor_bill_rate_org_id);
2362: FETCH l_labor_bill_rate_org_csr INTO l_dummy;

Line 2380: RAISE FND_API.G_EXC_ERROR;

2376: ,p_attribute3 => ''
2377: ,p_attribute4 => ''
2378: ,p_attribute5 => '');
2379: END IF;
2380: RAISE FND_API.G_EXC_ERROR;
2381:
2382: ELSE
2383: CLOSE l_labor_bill_rate_org_csr;
2384: END IF;

Line 2409: RAISE FND_API.G_EXC_ERROR;

2405: ,p_attribute3 => ''
2406: ,p_attribute4 => ''
2407: ,p_attribute5 => '');
2408: END IF;
2409: RAISE FND_API.G_EXC_ERROR;
2410:
2411: ELSE
2412: CLOSE l_labor_brs_csr;
2413: END IF;

Line 2442: RAISE FND_API.G_EXC_ERROR;

2438: ,p_attribute3 => ''
2439: ,p_attribute4 => ''
2440: ,p_attribute5 => '');
2441: END IF;
2442: RAISE FND_API.G_EXC_ERROR;
2443: END IF;
2444: ELSE
2445: IF (l_task_rec.job_bill_rate_schedule_id IS NULL
2446: OR l_task_rec.job_bill_rate_schedule_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) AND

Line 2463: RAISE FND_API.G_EXC_ERROR;

2459: ,p_attribute3 => ''
2460: ,p_attribute4 => ''
2461: ,p_attribute5 => '');
2462: END IF;
2463: RAISE FND_API.G_EXC_ERROR;
2464: END IF;
2465: END IF; -- end PA_INSTALL.IS_PRM_LICENSED = 'Y'
2466: IF (l_task_rec.job_bill_rate_schedule_id IS NOT NULL
2467: AND l_task_rec.job_bill_rate_schedule_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )

Line 2488: RAISE FND_API.G_EXC_ERROR;

2484: ,p_attribute3 => ''
2485: ,p_attribute4 => ''
2486: ,p_attribute5 => '');
2487: END IF;
2488: RAISE FND_API.G_EXC_ERROR;
2489: ELSE
2490: CLOSE l_job_brs_csr;
2491: END IF;
2492: END IF;

Line 2515: RAISE FND_API.G_EXC_ERROR;

2511: ,p_attribute3 => ''
2512: ,p_attribute4 => ''
2513: ,p_attribute5 => '');
2514: END IF;
2515: RAISE FND_API.G_EXC_ERROR;
2516: ELSE
2517: CLOSE l_emp_brs_csr;
2518: END IF;
2519: END IF;

Line 2544: RAISE FND_API.G_EXC_ERROR;

2540: ,p_attribute3 => ''
2541: ,p_attribute4 => ''
2542: ,p_attribute5 => '');
2543: END IF;
2544: RAISE FND_API.G_EXC_ERROR;
2545: END IF;
2546:
2547: OPEN l_non_labor_bill_rate_org_csr
2548: (l_task_rec.non_labor_bill_rate_org_id);

Line 2567: RAISE FND_API.G_EXC_ERROR;

2563: ,p_attribute3 => ''
2564: ,p_attribute4 => ''
2565: ,p_attribute5 => '');
2566: END IF;
2567: RAISE FND_API.G_EXC_ERROR;
2568:
2569: ELSE
2570: CLOSE l_non_labor_bill_rate_org_csr;
2571: END IF;

Line 2597: RAISE FND_API.G_EXC_ERROR;

2593: ,p_attribute3 => ''
2594: ,p_attribute4 => ''
2595: ,p_attribute5 => '');
2596: END IF;
2597: RAISE FND_API.G_EXC_ERROR;
2598:
2599: ELSE
2600: CLOSE l_non_labor_brs_csr;
2601: END IF;

Line 2610: WHEN FND_API.G_EXC_ERROR THEN

2606:
2607:
2608: EXCEPTION
2609:
2610: WHEN FND_API.G_EXC_ERROR THEN
2611: p_return_status := FND_API.G_RET_STS_ERROR;
2612:
2613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2614: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2611: p_return_status := FND_API.G_RET_STS_ERROR;

2607:
2608: EXCEPTION
2609:
2610: WHEN FND_API.G_EXC_ERROR THEN
2611: p_return_status := FND_API.G_RET_STS_ERROR;
2612:
2613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2614: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2615:

Line 2613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2609:
2610: WHEN FND_API.G_EXC_ERROR THEN
2611: p_return_status := FND_API.G_RET_STS_ERROR;
2612:
2613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2614: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2615:
2616: WHEN OTHERS THEN
2617: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2614: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2610: WHEN FND_API.G_EXC_ERROR THEN
2611: p_return_status := FND_API.G_RET_STS_ERROR;
2612:
2613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2614: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2615:
2616: WHEN OTHERS THEN
2617: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2618:

Line 2617: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2614: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2615:
2616: WHEN OTHERS THEN
2617: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2618:
2619: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2620: THEN
2621: FND_MSG_PUB.add_exc_msg

Line 2663: p_return_status := FND_API.G_RET_STS_SUCCESS;

2659: l_end_date DATE;
2660:
2661: BEGIN
2662:
2663: p_return_status := FND_API.G_RET_STS_SUCCESS;
2664:
2665: IF p_new_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2666: AND p_new_start_date IS NOT NULL --redundant, but added for clarity
2667: THEN

Line 2705: RAISE FND_API.G_EXC_ERROR;

2701: ,p_attribute3 => ''
2702: ,p_attribute4 => ''
2703: ,p_attribute5 => '');
2704: END IF;
2705: RAISE FND_API.G_EXC_ERROR;
2706: END IF;
2707:
2708: ELSIF p_new_end_date IS NULL
2709: THEN

Line 2739: RAISE FND_API.G_EXC_ERROR;

2735: ,p_attribute3 => ''
2736: ,p_attribute4 => ''
2737: ,p_attribute5 => '');
2738: END IF;
2739: RAISE FND_API.G_EXC_ERROR;
2740: END IF;
2741: END IF;
2742: END IF;
2743:

Line 2770: RAISE FND_API.G_EXC_ERROR;

2766: ,p_attribute4 => ''
2767: ,p_attribute5 => '');
2768: END IF;
2769:
2770: RAISE FND_API.G_EXC_ERROR;
2771:
2772: ELSIF p_new_end_date IS NULL
2773: THEN
2774: IF p_old_end_date IS NOT NULL

Line 2800: RAISE FND_API.G_EXC_ERROR;

2796: ,p_attribute4 => ''
2797: ,p_attribute5 => '');
2798: END IF;
2799:
2800: RAISE FND_API.G_EXC_ERROR;
2801: END IF;
2802: END IF;
2803:
2804: ELSE --p_new_start_date was not passed

Line 2832: RAISE FND_API.G_EXC_ERROR;

2828: ,p_attribute4 => ''
2829: ,p_attribute5 => '');
2830: END IF;
2831:
2832: RAISE FND_API.G_EXC_ERROR;
2833: END IF;
2834:
2835: ELSE
2836: p_update_end_date_flag := 'N';

Line 2859: WHEN FND_API.G_EXC_ERROR

2855:
2856:
2857: EXCEPTION
2858:
2859: WHEN FND_API.G_EXC_ERROR
2860: THEN
2861:
2862: p_return_status := FND_API.G_RET_STS_ERROR;
2863: -- 4537865

Line 2862: p_return_status := FND_API.G_RET_STS_ERROR;

2858:
2859: WHEN FND_API.G_EXC_ERROR
2860: THEN
2861:
2862: p_return_status := FND_API.G_RET_STS_ERROR;
2863: -- 4537865
2864: p_update_end_date_flag := NULL ;
2865: p_update_start_date_flag := NULL ;
2866:

Line 2867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

2863: -- 4537865
2864: p_update_end_date_flag := NULL ;
2865: p_update_start_date_flag := NULL ;
2866:
2867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2868: THEN
2869:
2870: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2871: -- 4537865

Line 2870: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2866:
2867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2868: THEN
2869:
2870: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2871: -- 4537865
2872: p_update_end_date_flag := NULL ;
2873: p_update_start_date_flag := NULL ;
2874:

Line 2877: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2873: p_update_start_date_flag := NULL ;
2874:
2875: WHEN OTHERS THEN
2876:
2877: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2878: -- 4537865
2879: p_update_end_date_flag := NULL ;
2880: p_update_start_date_flag := NULL ;
2881:

Line 2980: p_return_status := FND_API.G_RET_STS_SUCCESS;

2976: Else update the end date of the existing manager to either
2977: (a) new manager's start date -1 or (b) sysdate -1
2978: (being done in check_for_one_manager);
2979: */
2980: p_return_status := FND_API.G_RET_STS_SUCCESS;
2981: --dbms_output.put_line('Inside check_for one_manager_pvt');
2982:
2983: -- begin NEW code for ROLE BASED SECURITY
2984: -- getting the project_role_id for call to PA_PROJECT_PARTIES_PUB.UPDATE_PROJECT_PARTY

Line 3035: RAISE FND_API.G_EXC_ERROR;

3031: ,p_attribute2 => ''
3032: ,p_attribute3 => ''
3033: ,p_attribute4 => ''
3034: ,p_attribute5 => '');
3035: RAISE FND_API.G_EXC_ERROR;
3036: End If;
3037: END IF;
3038: l_current_manager_updated := 'N';
3039:

Line 3085: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list

3081: IF l_current_project_man_rec.scheduled_flag ='N' OR l_current_project_man_rec.scheduled_flag IS NULL
3082: THEN
3083: PA_PROJECT_PARTIES_PUB.update_project_party(
3084: p_api_version => 1.0 -- p_api_version
3085: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
3086: , p_commit => FND_API.G_FALSE -- p_commit /* bug#2417448 */
3087: , p_validate_only => FND_API.G_FALSE -- p_validate_only
3088: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
3089: , p_debug_mode => 'N' -- p_debug_mode

Line 3086: , p_commit => FND_API.G_FALSE -- p_commit /* bug#2417448 */

3082: THEN
3083: PA_PROJECT_PARTIES_PUB.update_project_party(
3084: p_api_version => 1.0 -- p_api_version
3085: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
3086: , p_commit => FND_API.G_FALSE -- p_commit /* bug#2417448 */
3087: , p_validate_only => FND_API.G_FALSE -- p_validate_only
3088: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
3089: , p_debug_mode => 'N' -- p_debug_mode
3090: , p_object_id => p_project_id -- p_object_id

Line 3087: , p_validate_only => FND_API.G_FALSE -- p_validate_only

3083: PA_PROJECT_PARTIES_PUB.update_project_party(
3084: p_api_version => 1.0 -- p_api_version
3085: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
3086: , p_commit => FND_API.G_FALSE -- p_commit /* bug#2417448 */
3087: , p_validate_only => FND_API.G_FALSE -- p_validate_only
3088: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
3089: , p_debug_mode => 'N' -- p_debug_mode
3090: , p_object_id => p_project_id -- p_object_id
3091: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE

Line 3088: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level

3084: p_api_version => 1.0 -- p_api_version
3085: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
3086: , p_commit => FND_API.G_FALSE -- p_commit /* bug#2417448 */
3087: , p_validate_only => FND_API.G_FALSE -- p_validate_only
3088: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
3089: , p_debug_mode => 'N' -- p_debug_mode
3090: , p_object_id => p_project_id -- p_object_id
3091: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE
3092: , p_project_role_id => l_project_role_id -- p_project_role_id

Line 3114: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) Then

3110: , x_return_status =>x_return_status -- x_return_status
3111: , x_msg_count => x_msg_count -- x_msg_count
3112: , x_msg_data => x_msg_data -- x_msg_data
3113: );
3114: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) Then
3115: p_return_status := x_return_status;
3116: -- p_msg_count := x_msg_count;
3117: -- p_msg_data := SUBSTR(p_msg_data||x_msg_data,1,2000);
3118: END IF;

Line 3173: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list

3169: /* IF l_current_project_man_rec.scheduled_flag ='N' OR l_current_project_man_rec.scheduled_flag IS NULL
3170: THEN */ -- Commented FOR Bug 6631033
3171: PA_PROJECT_PARTIES_PUB.UPDATE_PROJECT_PARTY(
3172: p_api_version => 1.0 -- p_api_version
3173: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
3174: , p_commit => FND_API.G_FALSE -- p_commit /* bug#2417448 */
3175: , p_validate_only => FND_API.G_FALSE -- p_validate_only
3176: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
3177: , p_debug_mode => 'N' -- p_debug_mode

Line 3174: , p_commit => FND_API.G_FALSE -- p_commit /* bug#2417448 */

3170: THEN */ -- Commented FOR Bug 6631033
3171: PA_PROJECT_PARTIES_PUB.UPDATE_PROJECT_PARTY(
3172: p_api_version => 1.0 -- p_api_version
3173: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
3174: , p_commit => FND_API.G_FALSE -- p_commit /* bug#2417448 */
3175: , p_validate_only => FND_API.G_FALSE -- p_validate_only
3176: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
3177: , p_debug_mode => 'N' -- p_debug_mode
3178: , p_object_id => p_project_id -- p_object_id

Line 3175: , p_validate_only => FND_API.G_FALSE -- p_validate_only

3171: PA_PROJECT_PARTIES_PUB.UPDATE_PROJECT_PARTY(
3172: p_api_version => 1.0 -- p_api_version
3173: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
3174: , p_commit => FND_API.G_FALSE -- p_commit /* bug#2417448 */
3175: , p_validate_only => FND_API.G_FALSE -- p_validate_only
3176: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
3177: , p_debug_mode => 'N' -- p_debug_mode
3178: , p_object_id => p_project_id -- p_object_id
3179: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE

Line 3176: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level

3172: p_api_version => 1.0 -- p_api_version
3173: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
3174: , p_commit => FND_API.G_FALSE -- p_commit /* bug#2417448 */
3175: , p_validate_only => FND_API.G_FALSE -- p_validate_only
3176: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
3177: , p_debug_mode => 'N' -- p_debug_mode
3178: , p_object_id => p_project_id -- p_object_id
3179: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE
3180: , p_project_role_id => l_project_role_id -- p_project_role_id

Line 3202: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) Then

3198: , x_return_status => x_return_status -- x_return_status
3199: , x_msg_count => x_msg_count -- x_msg_count
3200: , x_msg_data => x_msg_data -- x_msg_data
3201: );
3202: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) Then
3203: p_return_status := x_return_status;
3204: -- p_msg_count := x_msg_count;
3205: -- p_msg_data := SUBSTR(p_msg_data||x_msg_data,1,2000);
3206: END IF;

Line 3215: WHEN FND_API.G_EXC_ERROR

3211: END IF;
3212: -- 4537865
3213: EXCEPTION
3214:
3215: WHEN FND_API.G_EXC_ERROR
3216: THEN
3217:
3218: p_return_status := FND_API.G_RET_STS_ERROR;
3219:

Line 3218: p_return_status := FND_API.G_RET_STS_ERROR;

3214:
3215: WHEN FND_API.G_EXC_ERROR
3216: THEN
3217:
3218: p_return_status := FND_API.G_RET_STS_ERROR;
3219:
3220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3221: THEN
3222:

Line 3220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

3216: THEN
3217:
3218: p_return_status := FND_API.G_RET_STS_ERROR;
3219:
3220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3221: THEN
3222:
3223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3224:

Line 3223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3219:
3220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3221: THEN
3222:
3223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3224:
3225: WHEN OTHERS THEN
3226:
3227: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3227: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3224:
3225: WHEN OTHERS THEN
3226:
3227: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3228:
3229: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3230: THEN
3231: FND_MSG_PUB.add_exc_msg

Line 3284: p_return_status := FND_API.G_RET_STS_SUCCESS;

3280: p_multiple_task_msg VARCHAR2(1) := 'T';
3281:
3282: BEGIN
3283:
3284: p_return_status := FND_API.G_RET_STS_SUCCESS;
3285:
3286: p_proceed_with_update_flag := 'Y';
3287:
3288: -- check whether task number is changing

Line 3376: -- RAISE FND_API.G_EXC_ERROR;

3372: ,p_attribute4 => ''
3373: ,p_attribute5 => '');
3374: END IF;
3375: p_multiple_task_msg := 'F';
3376: -- RAISE FND_API.G_EXC_ERROR;
3377: END IF;
3378: IF G_task_num_updated_index_tbl.EXISTS(1) THEN
3379: l_count := G_task_num_updated_index_tbl.COUNT;
3380: l_count := l_count + 1;

Line 3400: RAISE FND_API.G_EXC_ERROR;

3396: END IF;
3397: END LOOP;
3398: IF p_multiple_task_msg = 'F'
3399: THEN
3400: RAISE FND_API.G_EXC_ERROR;
3401: END IF;
3402: END IF;
3403:
3404: EXCEPTION

Line 3406: WHEN FND_API.G_EXC_ERROR

3402: END IF;
3403:
3404: EXCEPTION
3405:
3406: WHEN FND_API.G_EXC_ERROR
3407: THEN
3408:
3409: p_return_status := FND_API.G_RET_STS_ERROR;
3410:

Line 3409: p_return_status := FND_API.G_RET_STS_ERROR;

3405:
3406: WHEN FND_API.G_EXC_ERROR
3407: THEN
3408:
3409: p_return_status := FND_API.G_RET_STS_ERROR;
3410:
3411: -- 4537865
3412: p_proceed_with_update_flag := 'N' ;
3413:

Line 3414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

3410:
3411: -- 4537865
3412: p_proceed_with_update_flag := 'N' ;
3413:
3414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3415: THEN
3416:
3417: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3418: -- 4537865

Line 3417: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3413:
3414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3415: THEN
3416:
3417: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3418: -- 4537865
3419: p_proceed_with_update_flag := 'N' ;
3420:
3421: WHEN OTHERS THEN

Line 3423: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3419: p_proceed_with_update_flag := 'N' ;
3420:
3421: WHEN OTHERS THEN
3422:
3423: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3424: -- 4537865
3425: p_proceed_with_update_flag := 'N';
3426:
3427: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3497: p_return_status := FND_API.G_RET_STS_SUCCESS;

3493:
3494: p_multiple_task_msg VARCHAR2(1) := 'T';
3495:
3496: BEGIN
3497: p_return_status := FND_API.G_RET_STS_SUCCESS;
3498:
3499: -- Get segment1 for AMG messages
3500:
3501: OPEN l_amg_project_csr( p_project_id );

Line 3541: -- RAISE FND_API.G_EXC_ERROR;

3537: ,p_attribute5 => '');
3538: END IF;
3539: CLOSE l_get_parent_dates_csr;
3540: p_multiple_task_msg := 'F';
3541: -- RAISE FND_API.G_EXC_ERROR;
3542: ELSE
3543: CLOSE l_get_parent_dates_csr;
3544: END IF;
3545: IF l_parent_start_date > l_get_tasks_rec.start_date THEN

Line 3560: -- RAISE FND_API.G_EXC_ERROR;

3556: ,p_attribute5 => '');
3557: END IF;
3558: CLOSE l_get_tasks_csr;
3559: p_multiple_task_msg := 'F';
3560: -- RAISE FND_API.G_EXC_ERROR;
3561: END IF;
3562:
3563: IF l_parent_completion_date < l_get_tasks_rec.completion_date THEN
3564: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 3578: -- RAISE FND_API.G_EXC_ERROR;

3574: ,p_attribute5 => '');
3575: END IF;
3576: CLOSE l_get_tasks_csr;
3577: p_multiple_task_msg := 'F';
3578: -- RAISE FND_API.G_EXC_ERROR;
3579: END IF;
3580: END IF;
3581:
3582: l_min_child_start_date := NULL;

Line 3607: -- RAISE FND_API.G_EXC_ERROR;

3603: ,p_attribute4 => ''
3604: ,p_attribute5 => '');
3605: END IF;
3606: p_multiple_task_msg := 'F';
3607: -- RAISE FND_API.G_EXC_ERROR;
3608: END IF;
3609: END IF;
3610: IF l_max_child_completion_date IS NOT NULL THEN
3611: IF l_get_tasks_rec.completion_date < l_max_child_completion_date

Line 3628: -- RAISE FND_API.G_EXC_ERROR;

3624: ,p_attribute4 => ''
3625: ,p_attribute5 => '');
3626: END IF;
3627: p_multiple_task_msg := 'F';
3628: -- RAISE FND_API.G_EXC_ERROR;
3629: END IF;
3630: END IF;
3631: END LOOP;
3632:

Line 3635: RAISE FND_API.G_EXC_ERROR;

3631: END LOOP;
3632:
3633: IF p_multiple_task_msg = 'F'
3634: THEN
3635: RAISE FND_API.G_EXC_ERROR;
3636: END IF;
3637:
3638: CLOSE l_get_tasks_csr;
3639:

Line 3642: WHEN FND_API.G_EXC_ERROR

3638: CLOSE l_get_tasks_csr;
3639:
3640: EXCEPTION
3641:
3642: WHEN FND_API.G_EXC_ERROR
3643: THEN
3644: IF l_get_tasks_csr%ISOPEN THEN
3645: CLOSE l_get_tasks_csr;
3646: END IF;

Line 3648: p_return_status := FND_API.G_RET_STS_ERROR;

3644: IF l_get_tasks_csr%ISOPEN THEN
3645: CLOSE l_get_tasks_csr;
3646: END IF;
3647:
3648: p_return_status := FND_API.G_RET_STS_ERROR;
3649:
3650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3651: THEN
3652: IF l_get_tasks_csr%ISOPEN THEN

Line 3650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

3646: END IF;
3647:
3648: p_return_status := FND_API.G_RET_STS_ERROR;
3649:
3650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3651: THEN
3652: IF l_get_tasks_csr%ISOPEN THEN
3653: CLOSE l_get_tasks_csr;
3654: END IF;

Line 3656: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3652: IF l_get_tasks_csr%ISOPEN THEN
3653: CLOSE l_get_tasks_csr;
3654: END IF;
3655:
3656: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3657:
3658: WHEN OTHERS THEN
3659: IF l_get_tasks_csr%ISOPEN THEN
3660: CLOSE l_get_tasks_csr;

Line 3663: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3659: IF l_get_tasks_csr%ISOPEN THEN
3660: CLOSE l_get_tasks_csr;
3661: END IF;
3662:
3663: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3664:
3665: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3666: THEN
3667: FND_MSG_PUB.add_exc_msg

Line 3692: p_return_status := FND_API.G_RET_STS_SUCCESS;

3688: l_start_no_mgr_date DATE;
3689: l_end_no_mgr_date DATE;
3690:
3691: BEGIN
3692: p_return_status := FND_API.G_RET_STS_SUCCESS;
3693: --dbms_output.put_line('is this called');
3694: PA_PROJECT_PARTIES_UTILS.validate_manager_date_range( p_mode => 'AMG'
3695: ,p_project_id => p_project_id
3696: ,x_start_no_mgr_date => l_start_no_mgr_date

Line 3714: RAISE FND_API.G_EXC_ERROR;

3710: ,p_token2 => 'END_DATE'
3711: ,p_value2 => l_end_no_mgr_date
3712: );
3713: END IF;
3714: RAISE FND_API.G_EXC_ERROR;
3715:
3716: END IF;
3717:
3718: EXCEPTION

Line 3720: WHEN FND_API.G_EXC_ERROR

3716: END IF;
3717:
3718: EXCEPTION
3719:
3720: WHEN FND_API.G_EXC_ERROR
3721: THEN
3722: p_return_status := FND_API.G_RET_STS_ERROR;
3723:
3724: WHEN OTHERS THEN

Line 3722: p_return_status := FND_API.G_RET_STS_ERROR;

3718: EXCEPTION
3719:
3720: WHEN FND_API.G_EXC_ERROR
3721: THEN
3722: p_return_status := FND_API.G_RET_STS_ERROR;
3723:
3724: WHEN OTHERS THEN
3725: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3726:

Line 3725: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3721: THEN
3722: p_return_status := FND_API.G_RET_STS_ERROR;
3723:
3724: WHEN OTHERS THEN
3725: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3726:
3727: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3728: THEN
3729: FND_MSG_PUB.add_exc_msg