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 245: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

241:
242: -- Standard Start of API savepoint
243: SAVEPOINT EAM_WO_NETWORK_UTIL_PVT;
244: -- Standard call to check for call compatibility.
245: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
246: p_api_version ,
247: l_api_name ,
248: G_PKG_NAME )
249: THEN

Line 250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

246: p_api_version ,
247: l_api_name ,
248: G_PKG_NAME )
249: THEN
250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
251: END IF;
252: -- Initialize message list if p_init_msg_list is set to TRUE.
253: IF FND_API.to_Boolean( p_init_msg_list ) THEN
254: FND_MSG_PUB.initialize;

Line 253: IF FND_API.to_Boolean( p_init_msg_list ) THEN

249: THEN
250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
251: END IF;
252: -- Initialize message list if p_init_msg_list is set to TRUE.
253: IF FND_API.to_Boolean( p_init_msg_list ) THEN
254: FND_MSG_PUB.initialize;
255: END IF;
256: -- Initialize API return status to success
257: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 257: x_return_status := FND_API.G_RET_STS_SUCCESS;

253: IF FND_API.to_Boolean( p_init_msg_list ) THEN
254: FND_MSG_PUB.initialize;
255: END IF;
256: -- Initialize API return status to success
257: x_return_status := FND_API.G_RET_STS_SUCCESS;
258: x_msg_count := 0;
259: -- API body
260:
261: /* Initialize the local variables */

Line 270: l_return_status := FND_API.G_RET_STS_SUCCESS;

266: l_work_object_type_id := p_work_object_type_id;
267: l_offset_days := p_offset_days;
268: l_offset_direction := p_offset_direction;
269: l_schedule_method := p_schedule_method;
270: l_return_status := FND_API.G_RET_STS_SUCCESS;
271: l_start_date := p_start_date;
272: l_completion_date := p_completion_date;
273:
274: select scheduled_start_date, scheduled_completion_date

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

493: --dbms_output.put_line( '######');
494:
495: x_msg_count := l_msg_count;
496:
497: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
498: x_return_status := FND_API.G_RET_STS_ERROR;
499: RETURN;
500:
501: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 498: x_return_status := FND_API.G_RET_STS_ERROR;

494:
495: x_msg_count := l_msg_count;
496:
497: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
498: x_return_status := FND_API.G_RET_STS_ERROR;
499: RETURN;
500:
501: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

497: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
498: x_return_status := FND_API.G_RET_STS_ERROR;
499: RETURN;
500:
501: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
503: RETURN;
504:
505: END IF;

Line 502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

498: x_return_status := FND_API.G_RET_STS_ERROR;
499: RETURN;
500:
501: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
503: RETURN;
504:
505: END IF;
506:

Line 509: IF FND_API.To_Boolean( p_commit ) THEN

505: END IF;
506:
507: -- End of API body.
508: -- Standard check of p_commit.
509: IF FND_API.To_Boolean( p_commit ) THEN
510: --dbms_output.put_line('committing');
511: COMMIT WORK;
512: END IF;
513:

Line 520: WHEN FND_API.G_EXC_ERROR THEN

516: ( p_count => x_msg_count ,
517: p_data => x_msg_data
518: );
519: EXCEPTION
520: WHEN FND_API.G_EXC_ERROR THEN
521: x_return_status := FND_API.G_RET_STS_ERROR ;
522: FND_MSG_PUB.Count_And_Get
523: ( p_count => x_msg_count ,
524: p_data => x_msg_data

Line 521: x_return_status := FND_API.G_RET_STS_ERROR ;

517: p_data => x_msg_data
518: );
519: EXCEPTION
520: WHEN FND_API.G_EXC_ERROR THEN
521: x_return_status := FND_API.G_RET_STS_ERROR ;
522: FND_MSG_PUB.Count_And_Get
523: ( p_count => x_msg_count ,
524: p_data => x_msg_data
525: );

Line 528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

524: p_data => x_msg_data
525: );
526:
527:
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
530: FND_MSG_PUB.Count_And_Get
531: (
532: p_count => x_msg_count,

Line 529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

525: );
526:
527:
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
530: FND_MSG_PUB.Count_And_Get
531: (
532: p_count => x_msg_count,
533: p_data => x_msg_data

Line 537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

533: p_data => x_msg_data
534: );
535:
536: WHEN OTHERS THEN
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
538: IF FND_MSG_PUB.Check_Msg_Level
539: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
540: THEN
541: FND_MSG_PUB.Add_Exc_Msg

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

565:
566: PROCEDURE Schedule_for_Move
567: (
568: p_api_version IN NUMBER,
569: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
570: p_commit IN VARCHAR2 := FND_API.G_FALSE,
571: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
572:
573: p_work_object_id IN NUMBER,

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

566: PROCEDURE Schedule_for_Move
567: (
568: p_api_version IN NUMBER,
569: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
570: p_commit IN VARCHAR2 := FND_API.G_FALSE,
571: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
572:
573: p_work_object_id IN NUMBER,
574: p_work_object_type_id IN NUMBER,

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

567: (
568: p_api_version IN NUMBER,
569: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
570: p_commit IN VARCHAR2 := FND_API.G_FALSE,
571: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
572:
573: p_work_object_id IN NUMBER,
574: p_work_object_type_id IN NUMBER,
575: p_offset_days IN NUMBER := 1, -- 1 Day Default

Line 614: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

610: BEGIN
611: -- Standard Start of API savepoint
612: SAVEPOINT EAM_WO_NETWORK_UTIL_PVT;
613: -- Standard call to check for call compatibility.
614: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
615: p_api_version ,
616: l_api_name ,
617: G_PKG_NAME )
618: THEN

Line 619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

615: p_api_version ,
616: l_api_name ,
617: G_PKG_NAME )
618: THEN
619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
620: END IF;
621: -- Initialize message list if p_init_msg_list is set to TRUE.
622: IF FND_API.to_Boolean( p_init_msg_list ) THEN
623: FND_MSG_PUB.initialize;

Line 622: IF FND_API.to_Boolean( p_init_msg_list ) THEN

618: THEN
619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
620: END IF;
621: -- Initialize message list if p_init_msg_list is set to TRUE.
622: IF FND_API.to_Boolean( p_init_msg_list ) THEN
623: FND_MSG_PUB.initialize;
624: END IF;
625: -- Initialize API return status to success
626: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 626: x_return_status := FND_API.G_RET_STS_SUCCESS;

622: IF FND_API.to_Boolean( p_init_msg_list ) THEN
623: FND_MSG_PUB.initialize;
624: END IF;
625: -- Initialize API return status to success
626: x_return_status := FND_API.G_RET_STS_SUCCESS;
627: -- API body
628:
629: /* Initialize the local variables */
630: l_stmt_num := 10;

Line 657: x_return_status := FND_API.G_RET_STS_ERROR;

653: WHERE WDJ.WIP_ENTITY_ID = l_work_object_id
654: AND l_work_object_type_id = 1;
655: EXCEPTION
656: WHEN OTHERS THEN
657: x_return_status := FND_API.G_RET_STS_ERROR;
658:
659: RETURN;
660: END;
661:

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

806:
807: END IF; -- OffSet Direction
808:
809: /* Uncomment it later
810: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
811: x_return_status := FND_API.G_RET_STS_ERROR;
812:
813: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 811: x_return_status := FND_API.G_RET_STS_ERROR;

807: END IF; -- OffSet Direction
808:
809: /* Uncomment it later
810: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
811: x_return_status := FND_API.G_RET_STS_ERROR;
812:
813: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
815:

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

809: /* Uncomment it later
810: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
811: x_return_status := FND_API.G_RET_STS_ERROR;
812:
813: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
815:
816: END IF;
817: */

Line 814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

810: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
811: x_return_status := FND_API.G_RET_STS_ERROR;
812:
813: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
815:
816: END IF;
817: */
818:

Line 837: x_return_status := FND_API.G_RET_STS_ERROR;

833: AND l_work_object_type_id = 1;
834: EXCEPTION
835: WHEN OTHERS THEN
836:
837: x_return_status := FND_API.G_RET_STS_ERROR;
838: -- RETURN;
839: END;
840:
841:

Line 848: IF FND_API.To_Boolean( p_commit ) THEN

844:
845:
846: -- End of API body.
847: -- Standard check of p_commit.
848: IF FND_API.To_Boolean( p_commit ) THEN
849: --dbms_output.put_line('committing');
850: COMMIT WORK;
851: END IF;
852: -- Standard call to get message count and if count is 1, get message info.

Line 861: WHEN FND_API.G_EXC_ERROR THEN

857:
858:
859: EXCEPTION
860:
861: WHEN FND_API.G_EXC_ERROR THEN
862: x_return_status := FND_API.G_RET_STS_ERROR ;
863: FND_MSG_PUB.Count_And_Get
864: ( p_count => x_msg_count ,
865: p_data => x_msg_data

Line 862: x_return_status := FND_API.G_RET_STS_ERROR ;

858:
859: EXCEPTION
860:
861: WHEN FND_API.G_EXC_ERROR THEN
862: x_return_status := FND_API.G_RET_STS_ERROR ;
863: FND_MSG_PUB.Count_And_Get
864: ( p_count => x_msg_count ,
865: p_data => x_msg_data
866: );

Line 869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

865: p_data => x_msg_data
866: );
867:
868:
869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
871: FND_MSG_PUB.Count_And_Get
872: (
873: p_count => x_msg_count,

Line 870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

866: );
867:
868:
869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
871: FND_MSG_PUB.Count_And_Get
872: (
873: p_count => x_msg_count,
874: p_data => x_msg_data

Line 878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

874: p_data => x_msg_data
875: );
876:
877: WHEN OTHERS THEN
878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
879: IF FND_MSG_PUB.Check_Msg_Level
880: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
881: THEN
882: FND_MSG_PUB.Add_Exc_Msg