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_PRD_WORKORDER_PUB dependencies on FND_MSG_PUB

Line 128: FND_MSG_PUB.Initialize;

124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: END IF;
126:
127: IF FND_API.To_Boolean(p_init_msg_list) THEN
128: FND_MSG_PUB.Initialize;
129: END IF;
130:
131: -- Check Error Message stack.
132: IF(p_Workorder_Id IS NULL AND p_Workorder_Number IS NULL)THEN

Line 134: FND_MSG_PUB.ADD;

130:
131: -- Check Error Message stack.
132: IF(p_Workorder_Id IS NULL AND p_Workorder_Number IS NULL)THEN
133: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
134: FND_MSG_PUB.ADD;
135: RAISE FND_API.G_EXC_ERROR;
136: ELSIF (p_Workorder_Id IS NULL AND p_Workorder_Number IS NOT NULL)THEN
137: l_workorder_id := get_workorder_id(p_Workorder_Number);
138: ELSE

Line 142: x_msg_count := FND_MSG_PUB.count_msg;

138: ELSE
139: l_workorder_id := p_Workorder_Id;
140: END IF;
141:
142: x_msg_count := FND_MSG_PUB.count_msg;
143: IF x_msg_count > 0 THEN
144: RAISE FND_API.G_EXC_ERROR;
145: END IF;
146:

Line 155: x_msg_count := FND_MSG_PUB.count_msg;

151: ELSE
152: l_workorder_operation_id := p_WoOperationId;
153: END IF;
154: --l_workorder_operation_id := NULL;
155: x_msg_count := FND_MSG_PUB.count_msg;
156: IF x_msg_count > 0 THEN
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:

Line 296: x_msg_count := FND_MSG_PUB.count_msg;

292: l_result_row_index := l_result_row_index + 1;
293: END LOOP;
294: END IF;
295: -- Check Error Message stack.
296: x_msg_count := FND_MSG_PUB.count_msg;
297:
298: EXCEPTION
299: WHEN FND_API.G_EXC_ERROR THEN
300: x_return_status := FND_API.G_RET_STS_ERROR;

Line 301: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

297:
298: EXCEPTION
299: WHEN FND_API.G_EXC_ERROR THEN
300: x_return_status := FND_API.G_RET_STS_ERROR;
301: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
302: p_data => x_msg_data,
303: p_encoded => fnd_api.g_false);
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 306: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

302: p_data => x_msg_data,
303: p_encoded => fnd_api.g_false);
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
306: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
307: p_data => x_msg_data,
308: p_encoded => fnd_api.g_false);
309: WHEN OTHERS THEN
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 312: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

308: p_encoded => fnd_api.g_false);
309: WHEN OTHERS THEN
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311:
312: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
313: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
314: p_procedure_name => l_api_name,
315: p_error_text => SUBSTR(SQLERRM,1,500));
316: END IF;

Line 313: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

309: WHEN OTHERS THEN
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311:
312: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
313: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
314: p_procedure_name => l_api_name,
315: p_error_text => SUBSTR(SQLERRM,1,500));
316: END IF;
317: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 317: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

313: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
314: p_procedure_name => l_api_name,
315: p_error_text => SUBSTR(SQLERRM,1,500));
316: END IF;
317: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
318: p_data => x_msg_data,
319: p_encoded => fnd_api.g_false);
320: END get_qa_plan_results;
321:

Line 336: FND_MSG_PUB.ADD;

332: OPEN get_workorder_id_csr(p_Workorder_Number);
333: FETCH get_workorder_id_csr INTO l_workorder_id;
334: IF(get_workorder_id_csr%NOTFOUND)THEN
335: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
336: FND_MSG_PUB.ADD;
337: CLOSE get_workorder_id_csr;
338: RAISE FND_API.G_EXC_ERROR;
339: END IF;
340: CLOSE get_workorder_id_csr;

Line 359: FND_MSG_PUB.ADD;

355: OPEN get_workorder_operation_id_csr(p_Workorder_Id, p_operation_sequence);
356: FETCH get_workorder_operation_id_csr INTO l_workorder_operation_id;
357: IF(get_workorder_operation_id_csr%NOTFOUND)THEN
358: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
359: FND_MSG_PUB.ADD;
360: CLOSE get_workorder_operation_id_csr;
361: RAISE FND_API.G_EXC_ERROR;
362: END IF;
363: CLOSE get_workorder_operation_id_csr;

Line 463: FND_MSG_PUB.ADD;

459: OPEN get_status_csr(p_x_workorder_rec.status);
460: FETCH get_status_csr INTO p_x_workorder_rec.status_code;
461: IF get_status_csr%NOTFOUND THEN
462: FND_MESSAGE.SET_NAME('AHL','AHL_PP_JOB_INV_STATUS_JSP');
463: FND_MSG_PUB.ADD;
464: CLOSE get_status_csr;
465: RAISE FND_API.G_EXC_ERROR;
466: ELSE
467: CLOSE get_status_csr;

Line 479: FND_MSG_PUB.ADD;

475: IF validate_status_csr%NOTFOUND THEN
476: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_INVALID_STTS_CHNG');
477: FND_MESSAGE.SET_TOKEN('FROM_STATUS',p_curr_workorder_rec.status_code);
478: FND_MESSAGE.SET_TOKEN('TO_STATUS', p_x_workorder_rec.status_code);
479: FND_MSG_PUB.ADD;
480: CLOSE validate_status_csr;
481: RAISE FND_API.G_EXC_ERROR;
482: ELSE
483: CLOSE validate_status_csr;

Line 1407: FND_MSG_PUB.ADD;

1403: FETCH get_route_id_validation_csr INTO l_temp;
1404: IF(get_route_id_validation_csr%NOTFOUND)THEN
1405: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPER_INV_CR');
1406: FND_MESSAGE.SET_TOKEN('RECORD',l_prd_operation_tbl(j).operation_sequence_num,false);
1407: FND_MSG_PUB.ADD;
1408: CLOSE get_route_id_validation_csr;
1409: RAISE FND_API.G_EXC_ERROR;
1410: END IF;
1411: CLOSE get_route_id_validation_csr;

Line 1422: FND_MSG_PUB.ADD;

1418: FETCH get_operation_status INTO p_x_Operations(i).status_code;
1419: IF(get_operation_status%NOTFOUND)THEN
1420: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_UPDOP_INV_OP_STATUS');
1421: FND_MESSAGE.SET_TOKEN('OP_SEQ', p_x_Operations(i).Operation_Sequence_Number);
1422: FND_MSG_PUB.ADD;
1423: CLOSE get_operation_status;
1424: RAISE FND_API.G_EXC_ERROR;
1425: END IF;
1426: CLOSE get_operation_status;

Line 2548: FND_MSG_PUB.ADD;

2544: OPEN get_status_csr(p_x_workorder_rec.status);
2545: FETCH get_status_csr INTO p_x_workorder_rec.status_code;
2546: IF get_status_csr%NOTFOUND THEN
2547: FND_MESSAGE.SET_NAME('AHL','AHL_PP_JOB_INV_STATUS_JSP');
2548: FND_MSG_PUB.ADD;
2549: CLOSE get_status_csr;
2550: RAISE FND_API.G_EXC_ERROR;
2551: ELSE
2552: CLOSE get_status_csr;

Line 2692: FND_MSG_PUB.Initialize;

2688:
2689: SAVEPOINT PROCESS_WORKORDER;
2690:
2691: IF FND_API.To_Boolean(p_init_msg_list) THEN
2692: FND_MSG_PUB.Initialize;
2693: END IF;
2694: -- Initialize API return status to success
2695: x_return_status := FND_API.G_RET_STS_SUCCESS;
2696: --AHL_DEBUG_PUB.debug( 'p_x_workorder_rec.Workorder_Id : '||p_x_workorder_rec.Workorder_Id);

Line 2721: FND_MSG_PUB.ADD;

2717: IF(p_x_workorder_rec.Object_Version_Number IS NULL OR
2718: p_x_workorder_rec.Object_Version_Number <> l_workorder_rec.Object_Version_Number)THEN
2719: --AHL_DEBUG_PUB.debug( 'Object Version Numbers are not same');
2720: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
2721: FND_MSG_PUB.ADD;
2722: RAISE FND_API.G_EXC_ERROR;
2723: END IF;
2724:
2725: --JKJain, ER 9283136 (Unclosing a WorkOrder)

Line 2732: FND_MSG_PUB.ADD;

2728: IF(p_x_workorder_rec.UNCLOSE_WORKORDER_FLAG = 'Y') THEN
2729:
2730: IF (l_workorder_rec.Status_Code <> '12') THEN
2731: FND_MESSAGE.SET_NAME('AHL','AHL_PP_UNCLOSE_ONLY_CLOSED');
2732: FND_MSG_PUB.ADD;
2733: RAISE FND_API.G_EXC_ERROR;
2734: END IF;
2735:
2736: process_Unclose_Workorder(

Line 2877: FND_MSG_PUB.Count_And_Get

2873: IF FND_API.to_boolean(p_commit) THEN
2874: COMMIT;
2875: END IF;
2876: -- Standard call to get message count and if count is 1, get message
2877: FND_MSG_PUB.Count_And_Get
2878: ( p_count => x_msg_count,
2879: p_data => x_msg_data,
2880: p_encoded => fnd_api.g_false);
2881:

Line 2886: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2882: EXCEPTION
2883: WHEN FND_API.G_EXC_ERROR THEN
2884: ROLLBACK TO PROCESS_WORKORDER;
2885: x_return_status := FND_API.G_RET_STS_ERROR;
2886: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2887: p_data => x_msg_data,
2888: p_encoded => fnd_api.g_false);
2889: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2890: ROLLBACK TO PROCESS_WORKORDER;

Line 2892: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2888: p_encoded => fnd_api.g_false);
2889: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2890: ROLLBACK TO PROCESS_WORKORDER;
2891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2892: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2893: p_data => x_msg_data,
2894: p_encoded => fnd_api.g_false);
2895: WHEN OTHERS THEN
2896: ROLLBACK TO PROCESS_WORKORDER;

Line 2899: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2895: WHEN OTHERS THEN
2896: ROLLBACK TO PROCESS_WORKORDER;
2897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2898:
2899: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2900: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2901: p_procedure_name => l_api_name,
2902: p_error_text => SUBSTR(SQLERRM,1,500));
2903: END IF;

Line 2900: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

2896: ROLLBACK TO PROCESS_WORKORDER;
2897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2898:
2899: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2900: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2901: p_procedure_name => l_api_name,
2902: p_error_text => SUBSTR(SQLERRM,1,500));
2903: END IF;
2904: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 2904: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2900: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2901: p_procedure_name => l_api_name,
2902: p_error_text => SUBSTR(SQLERRM,1,500));
2903: END IF;
2904: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2905: p_data => x_msg_data,
2906: p_encoded => fnd_api.g_false);
2907: END process_workorder;
2908: