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.AHL_WORKORDER_SEARCH_PUB dependencies on FND_API

Line 14: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

10: -- Assigned Work Order Query---------------------------
11:
12: PROCEDURE get_wo_search_results(
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: p_module_type IN VARCHAR2,
18: p_userid IN VARCHAR2 := NULL,

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

11:
12: PROCEDURE get_wo_search_results(
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: p_module_type IN VARCHAR2,
18: p_userid IN VARCHAR2 := NULL,
19: x_return_status OUT NOCOPY VARCHAR2,

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

12: PROCEDURE get_wo_search_results(
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: p_module_type IN VARCHAR2,
18: p_userid IN VARCHAR2 := NULL,
19: x_return_status OUT NOCOPY VARCHAR2,
20: x_msg_count OUT NOCOPY NUMBER,

Line 51: IF(x_return_status <> Fnd_Api.G_RET_STS_SUCCESS)THEN

47: SAVEPOINT Search_Work_Orders;
48:
49: IF(p_module_type = 'BPEL') THEN
50: x_return_status := AHL_PRD_WO_PUB.init_user_and_role(p_userid);
51: IF(x_return_status <> Fnd_Api.G_RET_STS_SUCCESS)THEN
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
53: END IF;
54: END IF;
55:

Line 52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

48:
49: IF(p_module_type = 'BPEL') THEN
50: x_return_status := AHL_PRD_WO_PUB.init_user_and_role(p_userid);
51: IF(x_return_status <> Fnd_Api.G_RET_STS_SUCCESS)THEN
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
53: END IF;
54: END IF;
55:
56:

Line 59: IF Fnd_Api.to_boolean(p_init_msg_list)

55:
56:
57:
58: -- Initialize message list if p_init_msg_list is set to TRUE.
59: IF Fnd_Api.to_boolean(p_init_msg_list)
60: THEN
61: Fnd_Msg_Pub.initialize;
62: END IF;
63:

Line 66: --x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

62: END IF;
63:
64:
65: -- Initialize API return status to success
66: --x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
67: x_work_order_results.WORK_ORDERS(0).WORKORDER_ID := NULL;
68:
69: -- Standard call to check for call compatibility.
70: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,

Line 70: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,

66: --x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
67: x_work_order_results.WORK_ORDERS(0).WORKORDER_ID := NULL;
68:
69: -- Standard call to check for call compatibility.
70: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
71: p_api_version,
72: l_api_name,'AHL_WORKORDER_SEARCH_PUB')
73: THEN
74: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 74: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

70: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
71: p_api_version,
72: l_api_name,'AHL_WORKORDER_SEARCH_PUB')
73: THEN
74: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
75: END IF;
76:
77: IF (p_workorders_search_rec.SEARCH_TABLE_INDEX = 1) THEN
78:

Line 246: RAISE FND_API.G_EXC_ERROR;

242: 'wod.wip_entity_id = widj.wip_entity_id and '||
243: 'widj.date_released is not null) wo where 1=1';
244:
245: ELSE
246: RAISE FND_API.G_EXC_ERROR;
247: END IF;
248:
249: l_bind_index :=1;
250:

Line 465: WHEN Fnd_Api.G_EXC_ERROR THEN

461: x_work_order_results.start_row_index := NVL(p_workorders_search_rec.start_row_index,0);
462: x_work_order_results.NUMBER_OF_ROWS := j;
463:
464: EXCEPTION
465: WHEN Fnd_Api.G_EXC_ERROR THEN
466: ROLLBACK TO Search_Work_Orders;
467: x_return_status := Fnd_Api.G_RET_STS_ERROR;
468: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
469: p_data => x_msg_data,

Line 467: x_return_status := Fnd_Api.G_RET_STS_ERROR;

463:
464: EXCEPTION
465: WHEN Fnd_Api.G_EXC_ERROR THEN
466: ROLLBACK TO Search_Work_Orders;
467: x_return_status := Fnd_Api.G_RET_STS_ERROR;
468: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
469: p_data => x_msg_data,
470: p_encoded => Fnd_Api.g_false);
471:

Line 470: p_encoded => Fnd_Api.g_false);

466: ROLLBACK TO Search_Work_Orders;
467: x_return_status := Fnd_Api.G_RET_STS_ERROR;
468: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
469: p_data => x_msg_data,
470: p_encoded => Fnd_Api.g_false);
471:
472: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
473: ROLLBACK TO Search_Work_Orders;
474: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 472: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

468: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
469: p_data => x_msg_data,
470: p_encoded => Fnd_Api.g_false);
471:
472: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
473: ROLLBACK TO Search_Work_Orders;
474: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
475: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
476: p_data => x_msg_data,

Line 474: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

470: p_encoded => Fnd_Api.g_false);
471:
472: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
473: ROLLBACK TO Search_Work_Orders;
474: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
475: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
476: p_data => x_msg_data,
477: p_encoded => Fnd_Api.g_false);
478:

Line 477: p_encoded => Fnd_Api.g_false);

473: ROLLBACK TO Search_Work_Orders;
474: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
475: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
476: p_data => x_msg_data,
477: p_encoded => Fnd_Api.g_false);
478:
479: WHEN OTHERS THEN
480: -- dbms_output.put_line(' OTHERS ');
481: ROLLBACK TO Search_Work_Orders;

Line 482: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

478:
479: WHEN OTHERS THEN
480: -- dbms_output.put_line(' OTHERS ');
481: ROLLBACK TO Search_Work_Orders;
482: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
483: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'AHL_WORKORDER_SEARCH_PUB',
484: p_procedure_name => 'Get_Workorder_Search_Results',
485: p_error_text => SQLERRM);
486:

Line 489: p_encoded => Fnd_Api.g_false);

485: p_error_text => SQLERRM);
486:
487: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
488: p_data => x_msg_data,
489: p_encoded => Fnd_Api.g_false);
490:
491: END get_wo_search_results;
492:
493: END AHL_WORKORDER_SEARCH_PUB;