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 28: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

24: IF get_user_id_csr%NOTFOUND THEN
25: FND_MESSAGE.set_name('AHL','AHL_PRD_INV_BPEL_USR');
26: FND_MESSAGE.SET_TOKEN('USER_NAME',p_user_id);
27: FND_MSG_PUB.ADD;
28: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
29: END IF;
30: CLOSE get_user_id_csr;
31:
32: OPEN get_resp_id_csr;

Line 38: return Fnd_Api.G_RET_STS_SUCCESS;

34: CLOSE get_resp_id_csr;
35:
36: FND_GLOBAL.apps_initialize(l_user_id,l_resp_id,867);
37: mo_global.init('AHL');
38: return Fnd_Api.G_RET_STS_SUCCESS;
39:
40: END init_user_and_role;
41:
42: -- Assigned Work Order Query---------------------------

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

42: -- Assigned Work Order Query---------------------------
43:
44: PROCEDURE get_wo_search_results(
45: p_api_version IN NUMBER,
46: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
47: p_commit IN VARCHAR2 := FND_API.G_FALSE,
48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49: p_module_type IN VARCHAR2,
50: p_userid IN VARCHAR2 := NULL,

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

43:
44: PROCEDURE get_wo_search_results(
45: p_api_version IN NUMBER,
46: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
47: p_commit IN VARCHAR2 := FND_API.G_FALSE,
48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49: p_module_type IN VARCHAR2,
50: p_userid IN VARCHAR2 := NULL,
51: x_return_status OUT NOCOPY VARCHAR2,

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

44: PROCEDURE get_wo_search_results(
45: p_api_version IN NUMBER,
46: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
47: p_commit IN VARCHAR2 := FND_API.G_FALSE,
48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49: p_module_type IN VARCHAR2,
50: p_userid IN VARCHAR2 := NULL,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,

Line 83: IF Fnd_Api.to_boolean(p_init_msg_list)

79: --FND_GLOBAL.apps_initialize(1003259,62211,867);
80: --mo_global.init('AHL');
81:
82: -- Initialize message list if p_init_msg_list is set to TRUE.
83: IF Fnd_Api.to_boolean(p_init_msg_list)
84: THEN
85: Fnd_Msg_Pub.initialize;
86: END IF;
87:

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

86: END IF;
87:
88: x_return_status := init_user_and_role(p_userid);
89: -- Initialize API return status to success
90: --x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
91: x_work_order_results.WORK_ORDERS(0).WORKORDER_ID := NULL;
92:
93: -- Standard call to check for call compatibility.
94: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,

Line 94: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,

90: --x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
91: x_work_order_results.WORK_ORDERS(0).WORKORDER_ID := NULL;
92:
93: -- Standard call to check for call compatibility.
94: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
95: p_api_version,
96: l_api_name,'AHL_WORKORDER_SEARCH_PUB')
97: THEN
98: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 98: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

94: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
95: p_api_version,
96: l_api_name,'AHL_WORKORDER_SEARCH_PUB')
97: THEN
98: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
99: END IF;
100:
101: IF (p_workorders_search_rec.SEARCH_TABLE_INDEX = 1) THEN
102:

Line 266: RAISE FND_API.G_EXC_ERROR;

262: 'wod.wip_entity_id = widj.wip_entity_id and '||
263: 'widj.date_released is not null) wo where 1=1';
264:
265: ELSE
266: RAISE FND_API.G_EXC_ERROR;
267: END IF;
268:
269: l_bind_index :=1;
270:

Line 482: WHEN Fnd_Api.G_EXC_ERROR THEN

478: x_work_order_results.start_row_index := NVL(p_workorders_search_rec.start_row_index,0);
479: x_work_order_results.NUMBER_OF_ROWS := j;
480:
481: EXCEPTION
482: WHEN Fnd_Api.G_EXC_ERROR THEN
483: ROLLBACK TO Search_Work_Orders;
484: x_return_status := Fnd_Api.G_RET_STS_ERROR;
485: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
486: p_data => x_msg_data,

Line 484: x_return_status := Fnd_Api.G_RET_STS_ERROR;

480:
481: EXCEPTION
482: WHEN Fnd_Api.G_EXC_ERROR THEN
483: ROLLBACK TO Search_Work_Orders;
484: x_return_status := Fnd_Api.G_RET_STS_ERROR;
485: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
486: p_data => x_msg_data,
487: p_encoded => Fnd_Api.g_false);
488:

Line 487: p_encoded => Fnd_Api.g_false);

483: ROLLBACK TO Search_Work_Orders;
484: x_return_status := Fnd_Api.G_RET_STS_ERROR;
485: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
486: p_data => x_msg_data,
487: p_encoded => Fnd_Api.g_false);
488:
489: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
490: ROLLBACK TO Search_Work_Orders;
491: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 489: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

485: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
486: p_data => x_msg_data,
487: p_encoded => Fnd_Api.g_false);
488:
489: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
490: ROLLBACK TO Search_Work_Orders;
491: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
492: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
493: p_data => x_msg_data,

Line 491: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

487: p_encoded => Fnd_Api.g_false);
488:
489: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
490: ROLLBACK TO Search_Work_Orders;
491: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
492: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
493: p_data => x_msg_data,
494: p_encoded => Fnd_Api.g_false);
495:

Line 494: p_encoded => Fnd_Api.g_false);

490: ROLLBACK TO Search_Work_Orders;
491: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
492: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
493: p_data => x_msg_data,
494: p_encoded => Fnd_Api.g_false);
495:
496: WHEN OTHERS THEN
497: -- dbms_output.put_line(' OTHERS ');
498: ROLLBACK TO Search_Work_Orders;

Line 499: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

495:
496: WHEN OTHERS THEN
497: -- dbms_output.put_line(' OTHERS ');
498: ROLLBACK TO Search_Work_Orders;
499: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
500: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'AHL_WORKORDER_SEARCH_PUB',
501: p_procedure_name => 'Get_Workorder_Search_Results',
502: p_error_text => SQLERRM);
503:

Line 506: p_encoded => Fnd_Api.g_false);

502: p_error_text => SQLERRM);
503:
504: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
505: p_data => x_msg_data,
506: p_encoded => Fnd_Api.g_false);
507:
508: END get_wo_search_results;
509:
510: END AHL_WORKORDER_SEARCH_PUB;