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

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

40: *********************************************************************/
41: PROCEDURE Validate_Structure
42: (
43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
45: p_commit IN VARCHAR2 := FND_API.G_FALSE,
46: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
47:
48: p_work_object_id IN NUMBER,

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

41: PROCEDURE Validate_Structure
42: (
43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
45: p_commit IN VARCHAR2 := FND_API.G_FALSE,
46: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
47:
48: p_work_object_id IN NUMBER,
49: p_work_object_type_id IN NUMBER,

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

42: (
43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
45: p_commit IN VARCHAR2 := FND_API.G_FALSE,
46: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
47:
48: p_work_object_id IN NUMBER,
49: p_work_object_type_id IN NUMBER,
50: p_exception_logging IN VARCHAR2 := 'N',

Line 109: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

105: BEGIN
106: -- Standard Start of API savepoint
107: SAVEPOINT EAM_WO_NETWORK_VALIDATE_PVT;
108: -- Standard call to check for call compatibility.
109: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
110: p_api_version ,
111: l_api_name ,
112: G_PKG_NAME )
113: THEN

Line 114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

110: p_api_version ,
111: l_api_name ,
112: G_PKG_NAME )
113: THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116: -- Initialize message list if p_init_msg_list is set to TRUE.
117: IF FND_API.to_Boolean( p_init_msg_list ) THEN
118: FND_MSG_PUB.initialize;

Line 117: IF FND_API.to_Boolean( p_init_msg_list ) THEN

113: THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116: -- Initialize message list if p_init_msg_list is set to TRUE.
117: IF FND_API.to_Boolean( p_init_msg_list ) THEN
118: FND_MSG_PUB.initialize;
119: END IF;
120: -- Initialize API return status to success
121: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 121: x_return_status := FND_API.G_RET_STS_SUCCESS;

117: IF FND_API.to_Boolean( p_init_msg_list ) THEN
118: FND_MSG_PUB.initialize;
119: END IF;
120: -- Initialize API return status to success
121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122: -- API body
123:
124: /* Initialize the local variables */
125: l_stmt_num := 10;

Line 152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

148: l_top_level_object_id := l_work_object_id;
149: l_top_level_object_type_id := l_work_object_type_id;
150: --dbms_output.put_line ('TOP = '||l_top_level_object_id);
151: WHEN OTHERS THEN
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153: END;
154:
155:
156:

Line 256: x_return_status := FND_API.G_RET_STS_ERROR;

252:
253:
254: IF (l_released_rowcount > 0 ) THEN
255: -- Error between two released work orders
256: x_return_status := FND_API.G_RET_STS_ERROR;
257:
258: END IF;
259: END IF;
260:

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

273: x_msg_data => l_msg_data
274: --x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
275: );
276:
277: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
278: x_return_status := FND_API.G_RET_STS_ERROR;
279:
280: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 278: x_return_status := FND_API.G_RET_STS_ERROR;

274: --x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
275: );
276:
277: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
278: x_return_status := FND_API.G_RET_STS_ERROR;
279:
280: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282:

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

276:
277: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
278: x_return_status := FND_API.G_RET_STS_ERROR;
279:
280: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282:
283: END IF;
284:

Line 281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

277: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
278: x_return_status := FND_API.G_RET_STS_ERROR;
279:
280: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282:
283: END IF;
284:
285:

Line 293: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

289: p_work_object_type_id => p_work_object_type_id,
290: x_return_status => l_return_status
291: );
292:
293: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
294: x_return_status := l_return_status;
295: END IF;
296: ELSE
297: -- Added for Detailed Scheduling

Line 303: x_return_status := FND_API.G_RET_STS_ERROR;

299: p_work_object_type_id => l_top_level_object_type_id,
300: p_wo_relationship_exc_tbl => l_wo_relationship_exc_tbl
301: );
302: IF (l_wo_relationship_exc_tbl.count >0 ) THEN
303: x_return_status := FND_API.G_RET_STS_ERROR;
304: END IF;
305:
306: l_stmt_num := 70;
307:

Line 456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

452: FND_MSG_PUB.Add_Exc_Msg
453: ( G_PKG_NAME,
454: l_api_name||'('||l_stmt_num||')'
455: );
456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
457: END;
458:
459: l_exception_msg := NULL;
460: FND_MESSAGE.CLEAR;

Line 539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

535: FND_MSG_PUB.Add_Exc_Msg
536: ( G_PKG_NAME,
537: l_api_name||'('||l_stmt_num||')'
538: );
539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
540: END;
541:
542: l_exception_msg := NULL;
543: FND_MESSAGE.CLEAR;

Line 583: IF FND_API.To_Boolean( p_commit ) THEN

579: --fix for 7943516
580:
581: -- End of API body.
582: -- Standard check of p_commit.
583: IF FND_API.To_Boolean( p_commit ) THEN
584: --dbms_output.put_line('committing');
585: COMMIT WORK;
586: END IF;
587: -- Standard call to get message count and if count is 1, get message info.

Line 592: WHEN FND_API.G_EXC_ERROR THEN

588: x_msg_count := FND_MSG_PUB.Count_Msg;
589: x_wo_relationship_exc_tbl := l_wo_relationship_exc_tbl;
590:
591: EXCEPTION
592: WHEN FND_API.G_EXC_ERROR THEN
593: x_return_status := FND_API.G_RET_STS_ERROR ;
594: FND_MSG_PUB.Count_And_Get
595: ( p_count => x_msg_count ,
596: p_data => x_msg_data

Line 593: x_return_status := FND_API.G_RET_STS_ERROR ;

589: x_wo_relationship_exc_tbl := l_wo_relationship_exc_tbl;
590:
591: EXCEPTION
592: WHEN FND_API.G_EXC_ERROR THEN
593: x_return_status := FND_API.G_RET_STS_ERROR ;
594: FND_MSG_PUB.Count_And_Get
595: ( p_count => x_msg_count ,
596: p_data => x_msg_data
597: );

Line 610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

606: SET EWR.RELATIONSHIP_STATUS = 0
607: WHERE EWR.TOP_LEVEL_OBJECT_TYPE_ID = l_top_level_object_type_id
608: AND EWR.TOP_LEVEL_OBJECT_ID = l_top_level_object_id;
609:
610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
612: FND_MSG_PUB.Count_And_Get
613: (
614: p_count => x_msg_count,

Line 611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

607: WHERE EWR.TOP_LEVEL_OBJECT_TYPE_ID = l_top_level_object_type_id
608: AND EWR.TOP_LEVEL_OBJECT_ID = l_top_level_object_id;
609:
610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
612: FND_MSG_PUB.Count_And_Get
613: (
614: p_count => x_msg_count,
615: p_data => x_msg_data

Line 630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

626: WHERE EWR.TOP_LEVEL_OBJECT_TYPE_ID = l_top_level_object_type_id
627: AND EWR.TOP_LEVEL_OBJECT_ID = l_top_level_object_id;
628:
629: WHEN OTHERS THEN
630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
631: IF FND_MSG_PUB.Check_Msg_Level
632: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
633: THEN
634: FND_MSG_PUB.Add_Exc_Msg

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

672:
673: PROCEDURE Check_Constrained_Children
674: (
675: p_api_version IN NUMBER,
676: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
677: p_commit IN VARCHAR2 := FND_API.G_FALSE,
678: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
679:
680: p_parent_object_id IN NUMBER,

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

673: PROCEDURE Check_Constrained_Children
674: (
675: p_api_version IN NUMBER,
676: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
677: p_commit IN VARCHAR2 := FND_API.G_FALSE,
678: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
679:
680: p_parent_object_id IN NUMBER,
681: p_parent_object_type_id IN NUMBER,

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

674: (
675: p_api_version IN NUMBER,
676: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
677: p_commit IN VARCHAR2 := FND_API.G_FALSE,
678: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
679:
680: p_parent_object_id IN NUMBER,
681: p_parent_object_type_id IN NUMBER,
682:

Line 716: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

712: BEGIN
713: -- Standard Start of API savepoint
714:
715: -- Standard call to check for call compatibility.
716: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
717: p_api_version ,
718: l_api_name ,
719: G_PKG_NAME )
720: THEN

Line 721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

717: p_api_version ,
718: l_api_name ,
719: G_PKG_NAME )
720: THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723: -- Initialize message list if p_init_msg_list is set to TRUE.
724: IF FND_API.to_Boolean( p_init_msg_list ) THEN
725: FND_MSG_PUB.initialize;

Line 724: IF FND_API.to_Boolean( p_init_msg_list ) THEN

720: THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723: -- Initialize message list if p_init_msg_list is set to TRUE.
724: IF FND_API.to_Boolean( p_init_msg_list ) THEN
725: FND_MSG_PUB.initialize;
726: END IF;
727: -- Initialize API return status to success
728: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 728: x_return_status := FND_API.G_RET_STS_SUCCESS;

724: IF FND_API.to_Boolean( p_init_msg_list ) THEN
725: FND_MSG_PUB.initialize;
726: END IF;
727: -- Initialize API return status to success
728: x_return_status := FND_API.G_RET_STS_SUCCESS;
729: -- API body
730:
731: /* Initialize the local variables */
732: l_stmt_num := 10;

Line 820: x_return_status := FND_API.G_RET_STS_ERROR;

816:
817:
818: IF (l_released_rowcount > 0 ) THEN
819: -- Error between two released work orders
820: x_return_status := FND_API.G_RET_STS_ERROR;
821:
822: END IF;
823:
824: END IF;

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

834: x_msg_count => l_msg_count,
835: x_msg_data => l_msg_data
836: );
837:
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: x_msg_data => l_msg_data
836: );
837:
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:
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 851: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 861: WHEN FND_API.G_EXC_ERROR THEN

857: ( p_count => x_msg_count ,
858: p_data => x_msg_data
859: );
860: EXCEPTION
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: p_data => x_msg_data
859: );
860: EXCEPTION
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: RETURN;
869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
870:
871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
872: FND_MSG_PUB.Count_And_Get
873: (

Line 871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

876: );
877:
878: RETURN;
879: WHEN OTHERS THEN
880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
881: IF FND_MSG_PUB.Check_Msg_Level
882: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
883: THEN
884: FND_MSG_PUB.Add_Exc_Msg

Line 926: x_return_status := FND_API.G_RET_STS_SUCCESS;

922: l_pending_flag VARCHAR2(1);
923: l_user_defined_status NUMBER;
924:
925: BEGIN
926: x_return_status := FND_API.G_RET_STS_SUCCESS;
927:
928: --Bug #5350181 :Changed the query to capture pending flag and user defined status
929: BEGIN
930: SELECT wdj.status_type,ewod.user_defined_status_id,ewod.pending_flag

Line 966: x_return_status:=FND_API.G_RET_STS_ERROR;

962: OR ((l_parent_status IN (4,5,12,14,15)) and (l_wo_status NOT IN (4,5,12,14,15,7)))
963: -- Bug #5350181: A child work order can't be sent for release approval when is parent is not in released status.
964: OR ((l_parent_status NOT IN (3,6))and (l_user_defined_status IN(3) and l_pending_flag='Y'))
965: ) THEN
966: x_return_status:=FND_API.G_RET_STS_ERROR;
967: END IF;
968: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('after parent status validation :'||x_return_status); END IF;
969:
970: EXCEPTION

Line 1030: x_return_status:=FND_API.G_RET_STS_ERROR;

1026: AND wdj.status_type NOT IN (4,5,12,14,15,7);
1027: END IF;
1028:
1029: IF(l_invalid_child<>0) THEN
1030: x_return_status:=FND_API.G_RET_STS_ERROR;
1031: END IF;
1032:
1033: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('after child status validation :'||x_return_status); END IF;
1034: END Validate_Status;

Line 1070: x_return_status := FND_API.G_RET_STS_SUCCESS;

1066: WHERE ewod.wip_entity_id = p_work_object_id
1067: AND ewod.user_defined_status_id = ewsv.status_id;
1068: BEGIN
1069:
1070: x_return_status := FND_API.G_RET_STS_SUCCESS;
1071:
1072: OPEN get_status(p_work_object_id);
1073: FETCH get_status INTO l_wo_status_meaning ;
1074: CLOSE get_status;

Line 1169: x_return_status:=FND_API.G_RET_STS_ERROR;

1165: END LOOP;
1166:
1167: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN
1168: IF p_wo_relationship_exc_tbl.count >0 THEN
1169: x_return_status:=FND_API.G_RET_STS_ERROR;
1170: END IF;
1171: EAM_ERROR_MESSAGE_PVT.Write_Debug('after Validate_Network_Status status validation :'||x_return_status);
1172: END IF;
1173: