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.15.12010000.2 2008/10/30 09:41:47 vmec ship $ */
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 907: l_Emp_Search_Result_Tbl EAM_ASSIGN_EMP_PUB.Emp_Search_Result_Tbl_Type;

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

Line 922: SAVEPOINT EAM_ASSIGN_EMP_PUB;

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

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

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

Line 1206: ROLLBACK TO EAM_ASSIGN_EMP_PUB;

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

Line 1213: ROLLBACK TO EAM_ASSIGN_EMP_PUB;

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

Line 1249: SAVEPOINT EAM_ASSIGN_EMP_PUB;

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

Line 1364: ROLLBACK TO EAM_ASSIGN_EMP_PUB;

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

Line 1371: ROLLBACK TO EAM_ASSIGN_EMP_PUB;

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

Line 2115: END EAM_ASSIGN_EMP_PUB;

2111: --msg('Work Order completion date in future?'||l_fetch_employee_results);
2112: RETURN l_fetch_employee_results;
2113: END Fetch_Details;
2114:
2115: END EAM_ASSIGN_EMP_PUB;