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

Line 143: FND_MSG_PUB.Initialize;

139: END IF;
140:
141: -- Initialize message list if p_init_msg_list is set to TRUE
142: IF FND_API.To_Boolean(p_init_msg_list) THEN
143: FND_MSG_PUB.Initialize;
144: END IF;
145:
146: --Commented by mpothuku as this API is not being used. At a later point, need to consider removing the
147: --declaration in Spec, Record Structure for Criteria and Rosetta

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

362: WHEN FND_API.G_EXC_ERROR THEN
363: --dbms_output.put_line('Excep 1 ');
364: x_return_status := FND_API.G_RET_STS_ERROR;
365: -- Rollback to Search_OSP_Pvt;
366: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
367: p_data => x_msg_data,
368: p_encoded => fnd_api.g_false);
369:
370: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

373:
374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
375: -- dbms_output.put_line('Excep 2 ');
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
378: p_data => x_msg_data,
379: p_encoded => fnd_api.g_false);
380: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
381: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);

Line 388: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

384: WHEN OTHERS THEN
385: -- dbms_output.put_line('Excep 3 ');
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: -- Rollback to Search_OSP_Pvt;
388: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
389: p_procedure_name => 'Search_OSP_Orders',
390: p_error_text => SQLERRM);
391:
392: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

388: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
389: p_procedure_name => 'Search_OSP_Orders',
390: p_error_text => SQLERRM);
391:
392: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
393: p_data => x_msg_data,
394: p_encoded => fnd_api.g_false);
395:
396: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 516: FND_MSG_PUB.Initialize;

512: END IF;
513:
514: -- Initialize message list if p_init_msg_list is set to TRUE
515: IF FND_API.To_Boolean(p_init_msg_list) THEN
516: FND_MSG_PUB.Initialize;
517: END IF;
518:
519: --Commented by mpothuku as this API is not being used. At a later point, need to consider removing the
520: --declaration in Spec, Record Structure for Criteria and Rosetta

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

672: WHEN FND_API.G_EXC_ERROR THEN
673: --dbms_output.put_line('Excep 1 ');
674: x_return_status := FND_API.G_RET_STS_ERROR;
675: -- Rollback to Search_WO_pvt;
676: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
677: p_data => x_msg_data,
678: p_encoded => fnd_api.g_false);
679:
680: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: -- dbms_output.put_line('Excep 2 ');
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687: --Rollback to Search_WO_pvt;
688: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
689: p_data => x_msg_data,
690: p_encoded => fnd_api.g_false);
691:
692:

Line 701: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

697: WHEN OTHERS THEN
698: -- dbms_output.put_line('Excep 3 ');
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: --Rollback to Search_WO_pvt;
701: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
702: p_procedure_name => 'Search_WO',
703: p_error_text => SQLERRM);
704:
705: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

701: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
702: p_procedure_name => 'Search_WO',
703: p_error_text => SQLERRM);
704:
705: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
706: p_data => x_msg_data,
707: p_encoded => fnd_api.g_false);
708:
709: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 842: FND_MSG_PUB.Initialize;

838: END IF;
839:
840: -- Initialize message list if p_init_msg_list is set to TRUE
841: IF FND_API.To_Boolean(p_init_msg_list) THEN
842: FND_MSG_PUB.Initialize;
843: END IF;
844:
845: -- Initialize API return status to success
846: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1051: FND_MSG_PUB.Count_And_Get

1047: END IF;
1048: */
1049:
1050: -- Standard call to get message count and if count is 1, get message info
1051: FND_MSG_PUB.Count_And_Get
1052: ( p_count => x_msg_count,
1053: p_data => x_msg_data,
1054: p_encoded => fnd_api.g_false
1055: );

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

1062: WHEN FND_API.G_EXC_ERROR THEN
1063: --dbms_output.put_line('Excep 1 ');
1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065: --Rollback to get_header_lines_pvt;
1066: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1067: p_data => x_msg_data,
1068: p_encoded => fnd_api.g_false);
1069: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1070: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Exception: ' || x_msg_data);

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

1074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1075: -- dbms_output.put_line('Excep 2 ');
1076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1077: -- Rollback to get_header_lines_pvt;
1078: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1079: p_data => x_msg_data,
1080: p_encoded => fnd_api.g_false);
1081: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1082: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);

Line 1089: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

1085: WHEN OTHERS THEN
1086: --dbms_output.put_line('Excep 3 ');
1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1088: -- Rollback to get_header_lines_pvt;
1089: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
1090: p_procedure_name => 'GET_HEADER_AND_LINES',
1091: p_error_text => SQLERRM);
1092:
1093: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

1089: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
1090: p_procedure_name => 'GET_HEADER_AND_LINES',
1091: p_error_text => SQLERRM);
1092:
1093: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1094: p_data => x_msg_data,
1095: p_encoded => fnd_api.g_false);
1096: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1097: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);

Line 1235: FND_MSG_PUB.Initialize;

1231: END IF;
1232:
1233: -- Initialize message list if p_init_msg_list is set to TRUE
1234: IF FND_API.To_Boolean(p_init_msg_list) THEN
1235: FND_MSG_PUB.Initialize;
1236: END IF;
1237:
1238: -- Initialize API return status to success
1239: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1452: WHEN FND_API.G_EXC_ERROR THEN
1453: --dbms_output.put_line('Excep 1 ');
1454: x_return_status := FND_API.G_RET_STS_ERROR;
1455: --Rollback to get_order_lines_pvt;
1456: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1457: p_data => x_msg_data,
1458: p_encoded => fnd_api.g_false);
1459: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1460: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Exception: ' || x_msg_data);

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

1463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1464: --dbms_output.put_line('Excep 2 ');
1465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1466: --Rollback to get_order_lines_pvt;
1467: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1468: p_data => x_msg_data,
1469: p_encoded => fnd_api.g_false);
1470: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1471: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);

Line 1478: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

1474: WHEN OTHERS THEN
1475: --dbms_output.put_line('Excep 3 ');
1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1477: -- Rollback to get_order_lines_pvt;
1478: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
1479: p_procedure_name => 'GET_ORDER_LINES',
1480: p_error_text => SQLERRM);
1481:
1482: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

1478: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
1479: p_procedure_name => 'GET_ORDER_LINES',
1480: p_error_text => SQLERRM);
1481:
1482: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1483: p_data => x_msg_data,
1484: p_encoded => fnd_api.g_false);
1485: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1486: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);