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.EAM_WO_NETWORK_UTIL_PVT dependencies on FND_API

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

29:
30: PROCEDURE Move_WO
31: (
32: p_api_version IN NUMBER,
33: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
34: p_commit IN VARCHAR2 := FND_API.G_FALSE,
35: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36:
37: p_work_object_id IN NUMBER,

Line 34: p_commit IN VARCHAR2 := FND_API.G_FALSE,

30: PROCEDURE Move_WO
31: (
32: p_api_version IN NUMBER,
33: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
34: p_commit IN VARCHAR2 := FND_API.G_FALSE,
35: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36:
37: p_work_object_id IN NUMBER,
38: p_work_object_type_id IN NUMBER,

Line 35: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

31: (
32: p_api_version IN NUMBER,
33: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
34: p_commit IN VARCHAR2 := FND_API.G_FALSE,
35: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36:
37: p_work_object_id IN NUMBER,
38: p_work_object_type_id IN NUMBER,
39: p_offset_days IN NUMBER := 1, -- 1 Day Default

Line 253: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

249:
250: -- Standard Start of API savepoint
251: SAVEPOINT EAM_WO_NETWORK_UTIL_PVT;
252: -- Standard call to check for call compatibility.
253: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
254: p_api_version ,
255: l_api_name ,
256: G_PKG_NAME )
257: THEN

Line 258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

254: p_api_version ,
255: l_api_name ,
256: G_PKG_NAME )
257: THEN
258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
259: END IF;
260: -- Initialize message list if p_init_msg_list is set to TRUE.
261: IF FND_API.to_Boolean( p_init_msg_list ) THEN
262: FND_MSG_PUB.initialize;

Line 261: IF FND_API.to_Boolean( p_init_msg_list ) THEN

257: THEN
258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
259: END IF;
260: -- Initialize message list if p_init_msg_list is set to TRUE.
261: IF FND_API.to_Boolean( p_init_msg_list ) THEN
262: FND_MSG_PUB.initialize;
263: END IF;
264: -- Initialize API return status to success
265: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 265: x_return_status := FND_API.G_RET_STS_SUCCESS;

261: IF FND_API.to_Boolean( p_init_msg_list ) THEN
262: FND_MSG_PUB.initialize;
263: END IF;
264: -- Initialize API return status to success
265: x_return_status := FND_API.G_RET_STS_SUCCESS;
266: x_msg_count := 0;
267: -- API body
268:
269: /* Initialize the local variables */

Line 278: l_return_status := FND_API.G_RET_STS_SUCCESS;

274: l_work_object_type_id := p_work_object_type_id;
275: l_offset_days := p_offset_days;
276: l_offset_direction := p_offset_direction;
277: l_schedule_method := p_schedule_method;
278: l_return_status := FND_API.G_RET_STS_SUCCESS;
279: l_start_date := p_start_date;
280: l_completion_date := p_completion_date;
281:
282: select scheduled_start_date, scheduled_completion_date

Line 525: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

521: --dbms_output.put_line( '######');
522:
523: x_msg_count := l_msg_count;
524:
525: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
526: x_return_status := FND_API.G_RET_STS_ERROR;
527: RETURN;
528:
529: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 526: x_return_status := FND_API.G_RET_STS_ERROR;

522:
523: x_msg_count := l_msg_count;
524:
525: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
526: x_return_status := FND_API.G_RET_STS_ERROR;
527: RETURN;
528:
529: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 529: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

525: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
526: x_return_status := FND_API.G_RET_STS_ERROR;
527: RETURN;
528:
529: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
531: RETURN;
532:
533: END IF;

Line 530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

526: x_return_status := FND_API.G_RET_STS_ERROR;
527: RETURN;
528:
529: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
531: RETURN;
532:
533: END IF;
534:

Line 537: IF FND_API.To_Boolean( p_commit ) THEN

533: END IF;
534:
535: -- End of API body.
536: -- Standard check of p_commit.
537: IF FND_API.To_Boolean( p_commit ) THEN
538: --dbms_output.put_line('committing');
539: COMMIT WORK;
540: END IF;
541:

Line 548: WHEN FND_API.G_EXC_ERROR THEN

544: ( p_count => x_msg_count ,
545: p_data => x_msg_data
546: );
547: EXCEPTION
548: WHEN FND_API.G_EXC_ERROR THEN
549: x_return_status := FND_API.G_RET_STS_ERROR ;
550: FND_MSG_PUB.Count_And_Get
551: ( p_count => x_msg_count ,
552: p_data => x_msg_data

Line 549: x_return_status := FND_API.G_RET_STS_ERROR ;

545: p_data => x_msg_data
546: );
547: EXCEPTION
548: WHEN FND_API.G_EXC_ERROR THEN
549: x_return_status := FND_API.G_RET_STS_ERROR ;
550: FND_MSG_PUB.Count_And_Get
551: ( p_count => x_msg_count ,
552: p_data => x_msg_data
553: );

Line 556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

552: p_data => x_msg_data
553: );
554:
555:
556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
558: FND_MSG_PUB.Count_And_Get
559: (
560: p_count => x_msg_count,

Line 557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

553: );
554:
555:
556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
558: FND_MSG_PUB.Count_And_Get
559: (
560: p_count => x_msg_count,
561: p_data => x_msg_data

Line 565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

561: p_data => x_msg_data
562: );
563:
564: WHEN OTHERS THEN
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
566: IF FND_MSG_PUB.Check_Msg_Level
567: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
568: THEN
569: FND_MSG_PUB.Add_Exc_Msg

Line 597: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

593:
594: PROCEDURE Schedule_for_Move
595: (
596: p_api_version IN NUMBER,
597: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
598: p_commit IN VARCHAR2 := FND_API.G_FALSE,
599: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
600:
601: p_work_object_id IN NUMBER,

Line 598: p_commit IN VARCHAR2 := FND_API.G_FALSE,

594: PROCEDURE Schedule_for_Move
595: (
596: p_api_version IN NUMBER,
597: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
598: p_commit IN VARCHAR2 := FND_API.G_FALSE,
599: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
600:
601: p_work_object_id IN NUMBER,
602: p_work_object_type_id IN NUMBER,

Line 599: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

595: (
596: p_api_version IN NUMBER,
597: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
598: p_commit IN VARCHAR2 := FND_API.G_FALSE,
599: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
600:
601: p_work_object_id IN NUMBER,
602: p_work_object_type_id IN NUMBER,
603: p_offset_days IN NUMBER := 1, -- 1 Day Default

Line 642: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

638: BEGIN
639: -- Standard Start of API savepoint
640: SAVEPOINT EAM_WO_NETWORK_UTIL_PVT;
641: -- Standard call to check for call compatibility.
642: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
643: p_api_version ,
644: l_api_name ,
645: G_PKG_NAME )
646: THEN

Line 647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

643: p_api_version ,
644: l_api_name ,
645: G_PKG_NAME )
646: THEN
647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
648: END IF;
649: -- Initialize message list if p_init_msg_list is set to TRUE.
650: IF FND_API.to_Boolean( p_init_msg_list ) THEN
651: FND_MSG_PUB.initialize;

Line 650: IF FND_API.to_Boolean( p_init_msg_list ) THEN

646: THEN
647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
648: END IF;
649: -- Initialize message list if p_init_msg_list is set to TRUE.
650: IF FND_API.to_Boolean( p_init_msg_list ) THEN
651: FND_MSG_PUB.initialize;
652: END IF;
653: -- Initialize API return status to success
654: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 654: x_return_status := FND_API.G_RET_STS_SUCCESS;

650: IF FND_API.to_Boolean( p_init_msg_list ) THEN
651: FND_MSG_PUB.initialize;
652: END IF;
653: -- Initialize API return status to success
654: x_return_status := FND_API.G_RET_STS_SUCCESS;
655: -- API body
656:
657: /* Initialize the local variables */
658: l_stmt_num := 10;

Line 685: x_return_status := FND_API.G_RET_STS_ERROR;

681: WHERE WDJ.WIP_ENTITY_ID = l_work_object_id
682: AND l_work_object_type_id = 1;
683: EXCEPTION
684: WHEN OTHERS THEN
685: x_return_status := FND_API.G_RET_STS_ERROR;
686:
687: RETURN;
688: END;
689:

Line 838: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

834:
835: END IF; -- OffSet Direction
836:
837: /* Uncomment it later
838: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
839: x_return_status := FND_API.G_RET_STS_ERROR;
840:
841: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 839: x_return_status := FND_API.G_RET_STS_ERROR;

835: END IF; -- OffSet Direction
836:
837: /* Uncomment it later
838: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
839: x_return_status := FND_API.G_RET_STS_ERROR;
840:
841: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
843:

Line 841: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

837: /* Uncomment it later
838: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
839: x_return_status := FND_API.G_RET_STS_ERROR;
840:
841: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
843:
844: END IF;
845: */

Line 842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

838: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
839: x_return_status := FND_API.G_RET_STS_ERROR;
840:
841: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
843:
844: END IF;
845: */
846:

Line 865: x_return_status := FND_API.G_RET_STS_ERROR;

861: AND l_work_object_type_id = 1;
862: EXCEPTION
863: WHEN OTHERS THEN
864:
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: -- RETURN;
867: END;
868:
869:

Line 876: IF FND_API.To_Boolean( p_commit ) THEN

872:
873:
874: -- End of API body.
875: -- Standard check of p_commit.
876: IF FND_API.To_Boolean( p_commit ) THEN
877: --dbms_output.put_line('committing');
878: COMMIT WORK;
879: END IF;
880: -- Standard call to get message count and if count is 1, get message info.

Line 889: WHEN FND_API.G_EXC_ERROR THEN

885:
886:
887: EXCEPTION
888:
889: WHEN FND_API.G_EXC_ERROR THEN
890: x_return_status := FND_API.G_RET_STS_ERROR ;
891: FND_MSG_PUB.Count_And_Get
892: ( p_count => x_msg_count ,
893: p_data => x_msg_data

Line 890: x_return_status := FND_API.G_RET_STS_ERROR ;

886:
887: EXCEPTION
888:
889: WHEN FND_API.G_EXC_ERROR THEN
890: x_return_status := FND_API.G_RET_STS_ERROR ;
891: FND_MSG_PUB.Count_And_Get
892: ( p_count => x_msg_count ,
893: p_data => x_msg_data
894: );

Line 897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

893: p_data => x_msg_data
894: );
895:
896:
897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
899: FND_MSG_PUB.Count_And_Get
900: (
901: p_count => x_msg_count,

Line 898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

894: );
895:
896:
897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
899: FND_MSG_PUB.Count_And_Get
900: (
901: p_count => x_msg_count,
902: p_data => x_msg_data

Line 906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

902: p_data => x_msg_data
903: );
904:
905: WHEN OTHERS THEN
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
907: IF FND_MSG_PUB.Check_Msg_Level
908: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
909: THEN
910: FND_MSG_PUB.Add_Exc_Msg