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

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

51: p_operation_seq_num IN NUMBER ,
52: p_department_id IN NUMBER ,
53: p_person_id IN NUMBER ,
54: p_api_version IN NUMBER :=1.0 ,
55: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
56: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
57: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
58: x_return_status OUT NOCOPY VARCHAR2 ,
59: x_msg_count OUT NOCOPY NUMBER ,

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

52: p_department_id IN NUMBER ,
53: p_person_id IN NUMBER ,
54: p_api_version IN NUMBER :=1.0 ,
55: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
56: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
57: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
58: x_return_status OUT NOCOPY VARCHAR2 ,
59: x_msg_count OUT NOCOPY NUMBER ,
60: x_msg_data OUT NOCOPY VARCHAR2)

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

53: p_person_id IN NUMBER ,
54: p_api_version IN NUMBER :=1.0 ,
55: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
56: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
57: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
58: x_return_status OUT NOCOPY VARCHAR2 ,
59: x_msg_count OUT NOCOPY NUMBER ,
60: x_msg_data OUT NOCOPY VARCHAR2)
61: AS

Line 71: x_return_status := FND_API.G_RET_STS_SUCCESS;

67:
68:
69: BEGIN
70: --msg('inside Get_Emp_Search_Results_Pub');
71: x_return_status := FND_API.G_RET_STS_SUCCESS;
72: -- Check for call compatibility.
73: --msg('Checkign APi compatibility');
74: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
75: p_api_version ,

Line 74: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

70: --msg('inside Get_Emp_Search_Results_Pub');
71: x_return_status := FND_API.G_RET_STS_SUCCESS;
72: -- Check for call compatibility.
73: --msg('Checkign APi compatibility');
74: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
75: p_api_version ,
76: l_api_name ,
77: G_PKG_NAME )
78: THEN

Line 79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

75: p_api_version ,
76: l_api_name ,
77: G_PKG_NAME )
78: THEN
79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
81: --msg('insitializing message list');
82: IF FND_API.to_Boolean( p_init_msg_list ) THEN
83: FND_MSG_PUB.initialize;

Line 82: IF FND_API.to_Boolean( p_init_msg_list ) THEN

78: THEN
79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
81: --msg('insitializing message list');
82: IF FND_API.to_Boolean( p_init_msg_list ) THEN
83: FND_MSG_PUB.initialize;
84: END IF;
85: --msg('validating parameters');
86: -- Validate the parameters passed.

Line 90: x_return_status := FND_API.G_RET_STS_ERROR;

86: -- Validate the parameters passed.
87: IF (p_organization_id IS NULL) THEN
88: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_ASSET_ORG_ID_REQ');
89: FND_MSG_PUB.Add;
90: x_return_status := FND_API.G_RET_STS_ERROR;
91: ELSIF (p_competence_type IS NULL AND p_competence_id IS NULL AND
92: p_person_id IS NULL AND p_resource_id IS NULL AND p_department_id IS NULL) THEN
93:
94: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_EMPSCH_DEP_RES');

Line 96: x_return_status := FND_API.G_RET_STS_ERROR;

92: p_person_id IS NULL AND p_resource_id IS NULL AND p_department_id IS NULL) THEN
93:
94: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_EMPSCH_DEP_RES');
95: FND_MSG_PUB.Add;
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: ELSE
98: IF (p_horizon_start_date IS NULL OR p_horizon_end_date IS NULL) THEN
99: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_EMPSCH_DATE_MISS');
100: FND_MSG_PUB.Add;

Line 101: x_return_status := FND_API.G_RET_STS_ERROR;

97: ELSE
98: IF (p_horizon_start_date IS NULL OR p_horizon_end_date IS NULL) THEN
99: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_EMPSCH_DATE_MISS');
100: FND_MSG_PUB.Add;
101: x_return_status := FND_API.G_RET_STS_ERROR;
102: ELSIF (p_horizon_start_date > p_horizon_end_date) THEN
103: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_EMPSCHED_DT_ERROR');
104: FND_MSG_PUB.Add;
105: x_return_status := FND_API.G_RET_STS_ERROR;

Line 105: x_return_status := FND_API.G_RET_STS_ERROR;

101: x_return_status := FND_API.G_RET_STS_ERROR;
102: ELSIF (p_horizon_start_date > p_horizon_end_date) THEN
103: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_EMPSCHED_DT_ERROR');
104: FND_MSG_PUB.Add;
105: x_return_status := FND_API.G_RET_STS_ERROR;
106: END IF;
107: END IF;
108:
109: FND_MSG_PUB.count_and_get(

Line 110: p_encoded => FND_API.G_FALSE,

106: END IF;
107: END IF;
108:
109: FND_MSG_PUB.count_and_get(
110: p_encoded => FND_API.G_FALSE,
111: p_count => x_msg_count,
112: p_data => x_msg_data
113: );
114:

Line 119: l_msg_data := FND_MSG_PUB.get(indexCount, FND_API.G_FALSE);

115: IF x_msg_count > 0
116: THEN
117: FOR indexCount IN 1..x_msg_count
118: LOOP
119: l_msg_data := FND_MSG_PUB.get(indexCount, FND_API.G_FALSE);
120: --msg(indexCount ||'-'||l_msg_data);
121: END LOOP;
122: END IF;
123:

Line 126: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

122: END IF;
123:
124: --msg('p_wip_entity_id==>' || p_wip_entity_id);
125: --msg('return status before calling private API==>' || x_return_status);
126: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
127: --msg('calling private API');
128: EAM_ASSIGN_EMP_PUB.get_emp_search_results_pvt(
129: p_horizon_start_date ,
130: p_horizon_end_date ,

Line 149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

145: x_msg_count,
146: x_msg_data);
147: END IF;
148: EXCEPTION
149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
150: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
152: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
153: FND_MSG_PUB.Count_And_Get(

Line 151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

147: END IF;
148: EXCEPTION
149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
150: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
152: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
153: FND_MSG_PUB.Count_And_Get(
154: p_count => x_msg_count,
155: p_data => x_msg_data);

Line 159: x_return_status := FND_API.G_RET_STS_ERROR ;

155: p_data => x_msg_data);
156:
157: WHEN NO_DATA_FOUND THEN
158: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
159: x_return_status := FND_API.G_RET_STS_ERROR ;
160: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
161: FND_MSG_PUB.Count_And_Get(
162: p_count => x_msg_count,
163: p_data => x_msg_data);

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

172: p_horizon_start_date IN DATE,
173: p_horizon_end_date IN DATE,
174: p_organization_id IN NUMBER,
175: p_api_version IN NUMBER :=1.0 ,
176: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
177: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
178: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
179: x_return_status OUT NOCOPY VARCHAR2 ,
180: x_msg_count OUT NOCOPY NUMBER ,

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

173: p_horizon_end_date IN DATE,
174: p_organization_id IN NUMBER,
175: p_api_version IN NUMBER :=1.0 ,
176: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
177: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
178: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
179: x_return_status OUT NOCOPY VARCHAR2 ,
180: x_msg_count OUT NOCOPY NUMBER ,
181: x_msg_data OUT NOCOPY VARCHAR2)

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

174: p_organization_id IN NUMBER,
175: p_api_version IN NUMBER :=1.0 ,
176: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
177: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
178: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
179: x_return_status OUT NOCOPY VARCHAR2 ,
180: x_msg_count OUT NOCOPY NUMBER ,
181: x_msg_data OUT NOCOPY VARCHAR2)
182: AS

Line 188: x_return_status := FND_API.G_RET_STS_SUCCESS;

184: l_api_version CONSTANT NUMBER := 1.0;
185: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
186:
187: BEGIN
188: x_return_status := FND_API.G_RET_STS_SUCCESS;
189: -- Check for call compatibility.
190: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
191: p_api_version ,
192: l_api_name ,

Line 190: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

186:
187: BEGIN
188: x_return_status := FND_API.G_RET_STS_SUCCESS;
189: -- Check for call compatibility.
190: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
191: p_api_version ,
192: l_api_name ,
193: G_PKG_NAME )
194: THEN

Line 195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

191: p_api_version ,
192: l_api_name ,
193: G_PKG_NAME )
194: THEN
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: END IF;
197: IF FND_API.to_Boolean( p_init_msg_list ) THEN
198: FND_MSG_PUB.initialize;
199: END IF;

Line 197: IF FND_API.to_Boolean( p_init_msg_list ) THEN

193: G_PKG_NAME )
194: THEN
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: END IF;
197: IF FND_API.to_Boolean( p_init_msg_list ) THEN
198: FND_MSG_PUB.initialize;
199: END IF;
200:
201: --validate the parameters passed

Line 205: x_return_status := FND_API.G_RET_STS_ERROR;

201: --validate the parameters passed
202: IF (p_organization_id IS NULL) THEN
203: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_ASSET_ORG_ID_REQ');
204: FND_MSG_PUB.Add;
205: x_return_status := FND_API.G_RET_STS_ERROR;
206: ELSIF (p_person_id IS NULL) THEN
207: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_EMPSCH_PERSON_MISS');
208: FND_MSG_PUB.Add;
209: x_return_status := FND_API.G_RET_STS_ERROR;

Line 209: x_return_status := FND_API.G_RET_STS_ERROR;

205: x_return_status := FND_API.G_RET_STS_ERROR;
206: ELSIF (p_person_id IS NULL) THEN
207: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_EMPSCH_PERSON_MISS');
208: FND_MSG_PUB.Add;
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: ELSE
211: IF (p_horizon_start_date IS NULL OR p_horizon_end_date IS NULL) THEN
212: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_EMPSCH_DATE_MISS');
213: FND_MSG_PUB.Add;

Line 214: x_return_status := FND_API.G_RET_STS_ERROR;

210: ELSE
211: IF (p_horizon_start_date IS NULL OR p_horizon_end_date IS NULL) THEN
212: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_EMPSCH_DATE_MISS');
213: FND_MSG_PUB.Add;
214: x_return_status := FND_API.G_RET_STS_ERROR;
215: ELSIF (p_horizon_start_date > p_horizon_end_date) THEN
216: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_EMPSCHED_DT_ERROR');
217: FND_MSG_PUB.Add;
218: x_return_status := FND_API.G_RET_STS_ERROR;

Line 218: x_return_status := FND_API.G_RET_STS_ERROR;

214: x_return_status := FND_API.G_RET_STS_ERROR;
215: ELSIF (p_horizon_start_date > p_horizon_end_date) THEN
216: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_EMPSCHED_DT_ERROR');
217: FND_MSG_PUB.Add;
218: x_return_status := FND_API.G_RET_STS_ERROR;
219: END IF;
220: END IF;
221:
222: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 222: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

218: x_return_status := FND_API.G_RET_STS_ERROR;
219: END IF;
220: END IF;
221:
222: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
223: Get_Emp_Assignment_Details_Pvt(p_person_id,
224: p_horizon_start_date,
225: p_horizon_end_date,
226: p_organization_id,

Line 236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

232: x_msg_count,
233: x_msg_data);
234: END IF;
235: EXCEPTION
236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
237: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
239: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
240: FND_MSG_PUB.Count_And_Get(

Line 238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

234: END IF;
235: EXCEPTION
236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
237: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
239: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
240: FND_MSG_PUB.Count_And_Get(
241: p_count => x_msg_count,
242: p_data => x_msg_data);

Line 246: x_return_status := FND_API.G_RET_STS_ERROR ;

242: p_data => x_msg_data);
243:
244: WHEN NO_DATA_FOUND THEN
245: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
246: x_return_status := FND_API.G_RET_STS_ERROR ;
247: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
248: FND_MSG_PUB.Count_And_Get(
249: p_count => x_msg_count,
250: p_data => x_msg_data);

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

650: p_operation_seq_num IN NUMBER ,
651: p_department_id IN NUMBER ,
652: p_person_id IN NUMBER ,
653: p_api_version IN NUMBER :=1.0 ,
654: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
655: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
656: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
657: x_return_status OUT NOCOPY VARCHAR2 ,
658: x_msg_count OUT NOCOPY NUMBER ,

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

651: p_department_id IN NUMBER ,
652: p_person_id IN NUMBER ,
653: p_api_version IN NUMBER :=1.0 ,
654: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
655: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
656: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
657: x_return_status OUT NOCOPY VARCHAR2 ,
658: x_msg_count OUT NOCOPY NUMBER ,
659: x_msg_data OUT NOCOPY VARCHAR2)

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

652: p_person_id IN NUMBER ,
653: p_api_version IN NUMBER :=1.0 ,
654: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
655: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
656: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
657: x_return_status OUT NOCOPY VARCHAR2 ,
658: x_msg_count OUT NOCOPY NUMBER ,
659: x_msg_data OUT NOCOPY VARCHAR2)
660:

Line 925: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

921: --msg(' p_resource_seq_num ==>' || p_resource_seq_num);
922: --msg(' p_organization_id ==>' || p_organization_id);
923: SAVEPOINT EAM_ASSIGN_EMP_PUB;
924: -- Standard call to check for call compatibility.
925: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
926: p_api_version ,
927: l_api_name ,
928: G_PKG_NAME ) THEN
929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

925: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
926: p_api_version ,
927: l_api_name ,
928: G_PKG_NAME ) THEN
929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
930: END IF;
931: -- Initialize message list if p_init_msg_list is set to TRUE.
932: IF FND_API.to_Boolean( p_init_msg_list ) THEN
933: FND_MSG_PUB.initialize;

Line 932: IF FND_API.to_Boolean( p_init_msg_list ) THEN

928: G_PKG_NAME ) THEN
929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
930: END IF;
931: -- Initialize message list if p_init_msg_list is set to TRUE.
932: IF FND_API.to_Boolean( p_init_msg_list ) THEN
933: FND_MSG_PUB.initialize;
934: END IF;
935: -- Initialize API return status to success
936: x_return_status := FND_API.g_ret_sts_success;

Line 936: x_return_status := FND_API.g_ret_sts_success;

932: IF FND_API.to_Boolean( p_init_msg_list ) THEN
933: FND_MSG_PUB.initialize;
934: END IF;
935: -- Initialize API return status to success
936: x_return_status := FND_API.g_ret_sts_success;
937: --msg('Getting the calndar code.p_organization_id==>' ||p_organization_id);
938:
939: SELECT calendar_code INTO l_calendar_code
940: FROM mtl_parameters

Line 1199: IF FND_API.TO_BOOLEAN(p_commit) THEN

1195: -- Copy the contents of the search table into the global temporary table.
1196: --Bulk collect into global temporary table
1197:
1198: DELETE FROM Eam_Emp_Search_Result_Tbl;
1199: IF FND_API.TO_BOOLEAN(p_commit) THEN
1200: COMMIT WORK;
1201: end if;
1202: FORALL indx IN l_Emp_Search_Result_Tbl.FIRST..l_Emp_Search_Result_Tbl.LAST
1203: INSERT INTO Eam_Emp_Search_Result_Tbl

Line 1208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1204: VALUES l_Emp_Search_Result_Tbl(indx);
1205:
1206:
1207: EXCEPTION
1208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1209: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1211: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1212: FND_MSG_PUB.Count_And_Get(

Line 1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1206:
1207: EXCEPTION
1208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1209: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1211: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1212: FND_MSG_PUB.Count_And_Get(
1213: p_count => x_msg_count,
1214: p_data => x_msg_data);

Line 1217: x_return_status := FND_API.G_RET_STS_ERROR ;

1213: p_count => x_msg_count,
1214: p_data => x_msg_data);
1215: WHEN NO_DATA_FOUND THEN
1216: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1217: x_return_status := FND_API.G_RET_STS_ERROR ;
1218: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1219: FND_MSG_PUB.Count_And_Get(
1220: p_count => x_msg_count,
1221: p_data => x_msg_data);

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

1231: p_horizon_start_date IN DATE,
1232: p_horizon_end_date IN DATE,
1233: p_organization_id IN NUMBER,
1234: p_api_version IN NUMBER :=1.0 ,
1235: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
1236: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
1237: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
1238: x_return_status OUT NOCOPY VARCHAR2 ,
1239: x_msg_count OUT NOCOPY NUMBER ,

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

1232: p_horizon_end_date IN DATE,
1233: p_organization_id IN NUMBER,
1234: p_api_version IN NUMBER :=1.0 ,
1235: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
1236: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
1237: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
1238: x_return_status OUT NOCOPY VARCHAR2 ,
1239: x_msg_count OUT NOCOPY NUMBER ,
1240: x_msg_data OUT NOCOPY VARCHAR2

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

1233: p_organization_id IN NUMBER,
1234: p_api_version IN NUMBER :=1.0 ,
1235: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
1236: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
1237: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
1238: x_return_status OUT NOCOPY VARCHAR2 ,
1239: x_msg_count OUT NOCOPY NUMBER ,
1240: x_msg_data OUT NOCOPY VARCHAR2
1241: )

Line 1253: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

1249: BEGIN
1250: -- Initialize API return status to success
1251:
1252: SAVEPOINT EAM_ASSIGN_EMP_PUB;
1253: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1254: p_api_version ,
1255: l_api_name ,
1256: G_PKG_NAME ) THEN
1257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1253: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1254: p_api_version ,
1255: l_api_name ,
1256: G_PKG_NAME ) THEN
1257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1258: END IF;
1259:
1260: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1261: FND_MSG_PUB.initialize;

Line 1260: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1256: G_PKG_NAME ) THEN
1257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1258: END IF;
1259:
1260: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1261: FND_MSG_PUB.initialize;
1262: END IF;
1263: x_return_status := FND_API.g_ret_sts_success;
1264: --copy the contents into the global temporary table

Line 1263: x_return_status := FND_API.g_ret_sts_success;

1259:
1260: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1261: FND_MSG_PUB.initialize;
1262: END IF;
1263: x_return_status := FND_API.g_ret_sts_success;
1264: --copy the contents into the global temporary table
1265: DELETE FROM Eam_Emp_Assignment_Details_Tbl ;
1266: /* Bug 4715069 :
1267: Removed code to COMMIT. Issuing a COMMIT will truncate the search results GTT too which is not desired.

Line 1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1362: AND woru.completion_date >= p_horizon_start_date
1363: AND woru.instance_id is not null ;
1364:
1365: EXCEPTION
1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1367: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1369: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1370: FND_MSG_PUB.Count_And_Get(

Line 1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1364:
1365: EXCEPTION
1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1367: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1369: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1370: FND_MSG_PUB.Count_And_Get(
1371: p_count => x_msg_count,
1372: p_data => x_msg_data);

Line 1375: x_return_status := FND_API.G_RET_STS_ERROR ;

1371: p_count => x_msg_count,
1372: p_data => x_msg_data);
1373: WHEN NO_DATA_FOUND THEN
1374: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1375: x_return_status := FND_API.G_RET_STS_ERROR ;
1376: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1377: FND_MSG_PUB.Count_And_Get(
1378: p_count => x_msg_count,
1379: p_data => x_msg_data);