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 EAM_ASSIGN_EMP_PUB

Line 1: PACKAGE BODY EAM_ASSIGN_EMP_PUB as

1: PACKAGE BODY EAM_ASSIGN_EMP_PUB as
2: /* $Header: EAMPESHB.pls 120.23 2012/01/27 10:51:00 vchidura noship $ */
3: /***************************************************************************
4: --
5: -- Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA

Line 21: g_pkg_name CONSTANT VARCHAR2(30):= 'EAM_ASSIGN_EMP_PUB';

17: -- HISTORY
18: --
19: -- 11-Mar-05 Samir Jain Initial Creation
20: ***************************************************************************/
21: g_pkg_name CONSTANT VARCHAR2(30):= 'EAM_ASSIGN_EMP_PUB';
22: g_debug CONSTANT VARCHAR2(1):=NVL(fnd_profile.value('APPS_DEBUG'),'N');
23:
24: procedure msg(x varchar2) is
25: pragma autonomous_transaction;

Line 128: EAM_ASSIGN_EMP_PUB.get_emp_search_results_pvt(

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 ,
131: p_organization_id ,
132: p_wip_entity_id ,

Line 150: ROLLBACK TO EAM_ASSIGN_EMP_PUB;

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(
154: p_count => x_msg_count,

Line 158: ROLLBACK TO EAM_ASSIGN_EMP_PUB;

154: p_count => x_msg_count,
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,

Line 237: ROLLBACK TO EAM_ASSIGN_EMP_PUB;

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(
241: p_count => x_msg_count,

Line 245: ROLLBACK TO EAM_ASSIGN_EMP_PUB;

241: p_count => x_msg_count,
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,

Line 908: l_Emp_Search_Result_Tbl EAM_ASSIGN_EMP_PUB.Emp_Search_Result_Tbl_Type;

904: l_start_count BINARY_INTEGER;
905:
906:
907: l_Emp_Search_Result_Rec Eam_Emp_Search_Result_Tbl%ROWTYPE;
908: l_Emp_Search_Result_Tbl EAM_ASSIGN_EMP_PUB.Emp_Search_Result_Tbl_Type;
909:
910:
911:
912: l_api_name CONSTANT VARCHAR2(30) := 'Get_Emp_Search_Results_Pvt';

Line 923: SAVEPOINT EAM_ASSIGN_EMP_PUB;

919: --msg(' wip_entity_id ==>' || p_wip_entity_id);
920: --msg( 'p_operation_seq_num ==>' || p_operation_seq_num);
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 ,

Line 997: l_Emp_Search_Result_Tbl := EAM_ASSIGN_EMP_PUB.Emp_Search_Result_Tbl_Type();

993: END IF;
994: -- get all the person ids and loop through them
995:
996: l_end_count := 1;
997: l_Emp_Search_Result_Tbl := EAM_ASSIGN_EMP_PUB.Emp_Search_Result_Tbl_Type();
998:
999: FOR l_person_rec IN l_person_id_csr_type LOOP
1000: EXIT WHEN l_person_id_csr_type%NOTFOUND;
1001:

Line 1209: ROLLBACK TO EAM_ASSIGN_EMP_PUB;

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(
1213: p_count => x_msg_count,

Line 1216: ROLLBACK TO EAM_ASSIGN_EMP_PUB;

1212: FND_MSG_PUB.Count_And_Get(
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,

Line 1252: SAVEPOINT EAM_ASSIGN_EMP_PUB;

1248:
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

Line 1367: ROLLBACK TO EAM_ASSIGN_EMP_PUB;

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(
1371: p_count => x_msg_count,

Line 1374: ROLLBACK TO EAM_ASSIGN_EMP_PUB;

1370: FND_MSG_PUB.Count_And_Get(
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,

Line 2118: END EAM_ASSIGN_EMP_PUB;

2114: --msg('Work Order completion date in future?'||l_fetch_employee_results);
2115: RETURN l_fetch_employee_results;
2116: END Fetch_Details;
2117:
2118: END EAM_ASSIGN_EMP_PUB;