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

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

Line 928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 931: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 935: x_return_status := FND_API.g_ret_sts_success;

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

Line 1196: IF FND_API.TO_BOOLEAN(p_commit) THEN

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

Line 1205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1214: x_return_status := FND_API.G_RET_STS_ERROR ;

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

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

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

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

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

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

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

Line 1250: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

Line 1254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1257: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 1260: x_return_status := FND_API.g_ret_sts_success;

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

Line 1363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1372: x_return_status := FND_API.G_RET_STS_ERROR ;

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