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.15 2006/09/18 08:58:24 cboppana noship $ */
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.15 2006/09/18 08:58:24 cboppana noship $ */
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 895: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',

891: IF p_commit = FND_API.G_TRUE THEN
892: ROLLBACK TO complete_workorder;
893: END IF;
894:
895: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',
896: p_procedure_name => EAM_DEBUG.G_err_stack);
897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
898: WHEN FND_API.G_EXC_ERROR THEN
899: IF p_commit = FND_API.G_TRUE THEN

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

899: IF p_commit = FND_API.G_TRUE THEN
900: ROLLBACK TO complete_workorder;
901: END IF;
902:
903: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',
904: p_procedure_name => EAM_DEBUG.G_err_stack);
905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
906: WHEN OTHERS THEN
907: IF p_commit = FND_API.G_TRUE THEN

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

907: IF p_commit = FND_API.G_TRUE THEN
908: ROLLBACK TO complete_workorder;
909: END IF;
910:
911: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',
912: p_procedure_name => EAM_DEBUG.G_err_stack);
913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
914: END Complete_Workorder;
915:

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

1209: x_msg_count := 0;
1210:
1211: SAVEPOINT create_easy_work_order;
1212:
1213: eam_debug.init_err_stack('eam_workorders_jsp.create_easy_work_order');
1214:
1215: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1216: p_api_version,
1217: l_api_name,

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

2495: FND_API.G_EXC_UNEXPECTED_ERROR THEN
2496: IF p_commit = FND_API.G_TRUE THEN
2497: ROLLBACK TO create_easy_work_order;
2498: END IF;
2499: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',
2500: p_procedure_name => EAM_DEBUG.G_err_stack);
2501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2502: WHEN FND_API.G_EXC_ERROR THEN
2503: IF p_commit = FND_API.G_TRUE THEN

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

2503: IF p_commit = FND_API.G_TRUE THEN
2504: ROLLBACK TO create_easy_work_order;
2505: END IF;
2506:
2507: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',
2508: p_procedure_name => EAM_DEBUG.G_err_stack);
2509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2510:
2511: WHEN OTHERS THEN -- all dml excpetion

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

2512: IF p_commit = FND_API.G_TRUE THEN
2513: ROLLBACK TO create_easy_work_order;
2514: END IF;
2515:
2516: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',
2517: p_procedure_name => EAM_DEBUG.G_err_stack);
2518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2519:
2520: end create_ez_work_order;

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

2575: IF p_commit = FND_API.G_TRUE THEN
2576: SAVEPOINT complete_workorder;
2577: END IF;
2578:
2579: eam_debug.init_err_stack('eam_workorders_jsp.update_work_order');
2580:
2581: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
2582: p_api_version,
2583: l_api_name,

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

2734: IF p_commit = FND_API.G_TRUE THEN
2735: ROLLBACK TO complete_workorder;
2736: END IF;
2737:
2738: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',
2739: p_procedure_name => EAM_DEBUG.G_err_stack);
2740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2741: WHEN FND_API.G_EXC_ERROR THEN
2742: IF p_commit = FND_API.G_TRUE THEN

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

2742: IF p_commit = FND_API.G_TRUE THEN
2743: ROLLBACK TO complete_workorder;
2744: END IF;
2745:
2746: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',
2747: p_procedure_name => EAM_DEBUG.G_err_stack);
2748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2749: WHEN OTHERS THEN
2750: IF p_commit = FND_API.G_TRUE THEN

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

2750: IF p_commit = FND_API.G_TRUE THEN
2751: ROLLBACK TO complete_workorder;
2752: END IF;
2753:
2754: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',
2755: p_procedure_name => EAM_DEBUG.G_err_stack);
2756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2757: END update_work_order;
2758:

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

2773: l_sched_start_date date := null;
2774: l_sched_end_date date := null;
2775:
2776: begin
2777: eam_debug.init_err_stack('eam_workorders_jsp.' || l_api_name);
2778:
2779: --initialize so at sysdate is returned when 1) no completed operations exist
2780: -- 2) some other error takes place
2781: x_start_date := sysdate;

Line 3413: EAM_WORKORDERS_JSP.Delete_WorkOrder_Dependency (

3409:
3410:
3411:
3412: -- Delete the record if exists. The child WO cannot have more than 1 parent.
3413: EAM_WORKORDERS_JSP.Delete_WorkOrder_Dependency (
3414: p_commit => FND_API.G_TRUE
3415: ,p_prior_object_type_id => 1
3416: ,p_next_object_type_id => 1
3417: ,p_organization_id => p_org_id

Line 3726: end EAM_WORKORDERS_JSP;

3722:
3723:
3724:
3725: END resize_wo_hierarchy_pvt;
3726: end EAM_WORKORDERS_JSP;