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.INV_LABEL_PVT7 dependencies on FND_MSG_PUB

Line 727: FND_MSG_PUB.ADD;

723: );
724:
725: IF l_return_status <> 'S' THEN
726: FND_MESSAGE.SET_NAME('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
727: FND_MSG_PUB.ADD;
728: l_label_format:= p_label_type_info.default_format_id;
729: l_label_format_id:= p_label_type_info.default_format_name;
730: END IF;
731: IF (l_debug = 1) THEN

Line 898: fnd_msg_pub.ADD;

894: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
895: x_return_status := FND_API.G_RET_STS_SUCCESS;
896: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
897: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
898: fnd_msg_pub.ADD;
899: -- Fix for bug: 4179593 Start
900: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
901: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
902: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

Line 900: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

896: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
897: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
898: fnd_msg_pub.ADD;
899: -- Fix for bug: 4179593 Start
900: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
901: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
902: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
903: l_CustSqlWarnFlagSet := TRUE;
904: -- Fix for bug: 4179593 End

Line 901: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

897: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
898: fnd_msg_pub.ADD;
899: -- Fix for bug: 4179593 Start
900: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
901: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
902: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
903: l_CustSqlWarnFlagSet := TRUE;
904: -- Fix for bug: 4179593 End
905: IF (l_debug = 1) THEN

Line 919: fnd_msg_pub.ADD;

915: END IF;
916: x_return_status := FND_API.G_RET_STS_SUCCESS;
917: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
918: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
919: fnd_msg_pub.ADD;
920: /* Replaced following statement for Bug 4207625: Anupam Jain*/
921: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
922: -- Fix for bug: 4179593 Start
923: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

Line 921: /fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);/

917: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
918: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
919: fnd_msg_pub.ADD;
920: /* Replaced following statement for Bug 4207625: Anupam Jain*/
921: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
922: -- Fix for bug: 4179593 Start
923: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
924: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
925: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

Line 923: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

919: fnd_msg_pub.ADD;
920: /* Replaced following statement for Bug 4207625: Anupam Jain*/
921: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
922: -- Fix for bug: 4179593 Start
923: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
924: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
925: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
926: l_CustSqlWarnFlagSet := TRUE;
927: -- Fix for bug: 4179593 End

Line 924: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

920: /* Replaced following statement for Bug 4207625: Anupam Jain*/
921: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
922: -- Fix for bug: 4179593 Start
923: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
924: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
925: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
926: l_CustSqlWarnFlagSet := TRUE;
927: -- Fix for bug: 4179593 End
928: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 937: fnd_msg_pub.ADD;

933: l_sql_stmt_result := NULL;
934: x_return_status := FND_API.G_RET_STS_SUCCESS;
935: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
936: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
937: fnd_msg_pub.ADD;
938: /* Replaced following statement for Bug 4207625: Anupam Jain*/
939: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
940: -- Fix for bug: 4179593 Start
941: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

Line 939: /fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);/

935: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
936: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
937: fnd_msg_pub.ADD;
938: /* Replaced following statement for Bug 4207625: Anupam Jain*/
939: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
940: -- Fix for bug: 4179593 Start
941: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
942: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
943: l_CustSqlErrMsg := l_custom_sql_ret_msg;

Line 941: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

937: fnd_msg_pub.ADD;
938: /* Replaced following statement for Bug 4207625: Anupam Jain*/
939: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
940: -- Fix for bug: 4179593 Start
941: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
942: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
943: l_CustSqlErrMsg := l_custom_sql_ret_msg;
944: l_CustSqlErrFlagSet := TRUE;
945: -- Fix for bug: 4179593 End

Line 942: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

938: /* Replaced following statement for Bug 4207625: Anupam Jain*/
939: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
940: -- Fix for bug: 4179593 Start
941: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
942: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
943: l_CustSqlErrMsg := l_custom_sql_ret_msg;
944: l_CustSqlErrFlagSet := TRUE;
945: -- Fix for bug: 4179593 End
946: END IF;

Line 961: fnd_msg_pub.ADD;

957: trace('Custom Labels Trace [INVLAP7B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
958: END IF;
959: x_return_status := FND_API.G_RET_STS_ERROR;
960: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
961: fnd_msg_pub.ADD;
962: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
964: END;
965: IF (l_debug = 1) THEN

Line 962: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

958: END IF;
959: x_return_status := FND_API.G_RET_STS_ERROR;
960: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
961: fnd_msg_pub.ADD;
962: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
964: END;
965: IF (l_debug = 1) THEN
966: trace('Custom Labels Trace [INVLAP7B.pls]: At Breadcrumb 6');