DBA Data[Home] [Help]

APPS.EAM_WORKORDERS_JSP dependencies on EAM_WORKORDERS_JSP

Line 1: package body EAM_WORKORDERS_JSP AS

1: package body EAM_WORKORDERS_JSP AS
2: /* $Header: EAMJOBJB.pls 120.16.12020000.3 2012/12/05 12:59:27 somitra ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EAM_WORKORDERS_JSP';
4: g_debug_sqlerrm VARCHAR2(250);
5:

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EAM_WORKORDERS_JSP';

1: package body EAM_WORKORDERS_JSP AS
2: /* $Header: EAMJOBJB.pls 120.16.12020000.3 2012/12/05 12:59:27 somitra ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EAM_WORKORDERS_JSP';
4: g_debug_sqlerrm VARCHAR2(250);
5:
6: ---------------------------------------------------------------------
7: --procedure to add existing work orders

Line 123: eam_debug.init_err_stack('eam_workorders_jsp.add_exist_work_order');

119: BEGIN
120:
121: SAVEPOINT add_exist_work_order;
122:
123: eam_debug.init_err_stack('eam_workorders_jsp.add_exist_work_order');
124:
125: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
126: p_api_version,
127: l_api_name,

Line 244: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.ADD_EXIST_WORK_ORDER',

240: FND_API.G_EXC_UNEXPECTED_ERROR THEN
241: IF p_commit = FND_API.G_TRUE THEN
242: ROLLBACK TO add_exist_work_order;
243: END IF;
244: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.ADD_EXIST_WORK_ORDER',
245: p_procedure_name => EAM_DEBUG.G_err_stack);
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: WHEN FND_API.G_EXC_ERROR THEN
248: IF p_commit = FND_API.G_TRUE THEN

Line 252: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.ADD_EXIST_WORK_ORDER',

248: IF p_commit = FND_API.G_TRUE THEN
249: ROLLBACK TO add_exist_work_order;
250: END IF;
251:
252: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.ADD_EXIST_WORK_ORDER',
253: p_procedure_name => EAM_DEBUG.G_err_stack);
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255:
256: WHEN OTHERS THEN -- all dml excpetion

Line 261: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.ADD_EXIST_WORK_ORDER',

257: IF p_commit = FND_API.G_TRUE THEN
258: ROLLBACK TO add_exist_work_order;
259: END IF;
260:
261: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.ADD_EXIST_WORK_ORDER',
262: p_procedure_name => EAM_DEBUG.G_err_stack);
263:
264:
265: END add_exist_work_order;

Line 445: eam_debug.init_err_stack('eam_workorders_jsp.complete_workorder');

441: IF p_commit = FND_API.G_TRUE THEN
442: SAVEPOINT complete_workorder;
443: END IF;
444:
445: eam_debug.init_err_stack('eam_workorders_jsp.complete_workorder');
446:
447: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
448: p_api_version,
449: l_api_name,

Line 915: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',

911: IF p_commit = FND_API.G_TRUE THEN
912: ROLLBACK TO complete_workorder;
913: END IF;
914:
915: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',
916: p_procedure_name => EAM_DEBUG.G_err_stack);
917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
918: WHEN FND_API.G_EXC_ERROR THEN
919: IF p_commit = FND_API.G_TRUE THEN

Line 923: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',

919: IF p_commit = FND_API.G_TRUE THEN
920: ROLLBACK TO complete_workorder;
921: END IF;
922:
923: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',
924: p_procedure_name => EAM_DEBUG.G_err_stack);
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
926: WHEN OTHERS THEN
927: IF p_commit = FND_API.G_TRUE THEN

Line 931: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',

927: IF p_commit = FND_API.G_TRUE THEN
928: ROLLBACK TO complete_workorder;
929: END IF;
930:
931: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',
932: p_procedure_name => EAM_DEBUG.G_err_stack);
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934: END Complete_Workorder;
935:

Line 1244: eam_debug.init_err_stack('eam_workorders_jsp.create_easy_work_order');

1240: x_msg_count := 0;
1241:
1242: SAVEPOINT create_easy_work_order;
1243:
1244: eam_debug.init_err_stack('eam_workorders_jsp.create_easy_work_order');
1245:
1246: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1247: p_api_version,
1248: l_api_name,

Line 2530: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',

2526: FND_API.G_EXC_UNEXPECTED_ERROR THEN
2527: IF p_commit = FND_API.G_TRUE THEN
2528: ROLLBACK TO create_easy_work_order;
2529: END IF;
2530: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',
2531: p_procedure_name => EAM_DEBUG.G_err_stack);
2532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2533: WHEN FND_API.G_EXC_ERROR THEN
2534: IF p_commit = FND_API.G_TRUE THEN

Line 2538: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',

2534: IF p_commit = FND_API.G_TRUE THEN
2535: ROLLBACK TO create_easy_work_order;
2536: END IF;
2537:
2538: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',
2539: p_procedure_name => EAM_DEBUG.G_err_stack);
2540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2541:
2542: WHEN OTHERS THEN -- all dml excpetion

Line 2547: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',

2543: IF p_commit = FND_API.G_TRUE THEN
2544: ROLLBACK TO create_easy_work_order;
2545: END IF;
2546:
2547: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',
2548: p_procedure_name => EAM_DEBUG.G_err_stack);
2549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2550:
2551: end create_ez_work_order;

Line 2610: eam_debug.init_err_stack('eam_workorders_jsp.update_work_order');

2606: IF p_commit = FND_API.G_TRUE THEN
2607: SAVEPOINT complete_workorder;
2608: END IF;
2609:
2610: eam_debug.init_err_stack('eam_workorders_jsp.update_work_order');
2611:
2612: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
2613: p_api_version,
2614: l_api_name,

Line 2769: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',

2765: IF p_commit = FND_API.G_TRUE THEN
2766: ROLLBACK TO complete_workorder;
2767: END IF;
2768:
2769: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',
2770: p_procedure_name => EAM_DEBUG.G_err_stack);
2771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2772: WHEN FND_API.G_EXC_ERROR THEN
2773: IF p_commit = FND_API.G_TRUE THEN

Line 2777: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',

2773: IF p_commit = FND_API.G_TRUE THEN
2774: ROLLBACK TO complete_workorder;
2775: END IF;
2776:
2777: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',
2778: p_procedure_name => EAM_DEBUG.G_err_stack);
2779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2780: WHEN OTHERS THEN
2781: IF p_commit = FND_API.G_TRUE THEN

Line 2785: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',

2781: IF p_commit = FND_API.G_TRUE THEN
2782: ROLLBACK TO complete_workorder;
2783: END IF;
2784:
2785: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',
2786: p_procedure_name => EAM_DEBUG.G_err_stack);
2787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2788: END update_work_order;
2789:

Line 2808: eam_debug.init_err_stack('eam_workorders_jsp.' || l_api_name);

2804: l_sched_start_date date := null;
2805: l_sched_end_date date := null;
2806: l_actual_comp_date_preference varchar2(1);
2807: begin
2808: eam_debug.init_err_stack('eam_workorders_jsp.' || l_api_name);
2809:
2810: --initialize so at sysdate is returned when 1) no completed operations exist
2811: -- 2) some other error takes place
2812: x_start_date := sysdate;

Line 3452: EAM_WORKORDERS_JSP.Delete_WorkOrder_Dependency (

3448:
3449:
3450:
3451: -- Delete the record if exists. The child WO cannot have more than 1 parent.
3452: EAM_WORKORDERS_JSP.Delete_WorkOrder_Dependency (
3453: p_commit => FND_API.G_TRUE
3454: ,p_prior_object_type_id => 1
3455: ,p_next_object_type_id => 1
3456: ,p_organization_id => p_org_id

Line 3765: end EAM_WORKORDERS_JSP;

3761:
3762:
3763:
3764: END resize_wo_hierarchy_pvt;
3765: end EAM_WORKORDERS_JSP;