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 706: FND_MSG_PUB.ADD;

702: );
703:
704: IF l_return_status <> 'S' THEN
705: FND_MESSAGE.SET_NAME('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
706: FND_MSG_PUB.ADD;
707: l_label_format:= p_label_type_info.default_format_id;
708: l_label_format_id:= p_label_type_info.default_format_name;
709: END IF;
710: IF (l_debug = 1) THEN

Line 877: fnd_msg_pub.ADD;

873: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
874: x_return_status := FND_API.G_RET_STS_SUCCESS;
875: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
876: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
877: fnd_msg_pub.ADD;
878: -- Fix for bug: 4179593 Start
879: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
880: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
881: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

875: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
876: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
877: fnd_msg_pub.ADD;
878: -- Fix for bug: 4179593 Start
879: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
880: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
881: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
882: l_CustSqlWarnFlagSet := TRUE;
883: -- Fix for bug: 4179593 End

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

876: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
877: fnd_msg_pub.ADD;
878: -- Fix for bug: 4179593 Start
879: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
880: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
881: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
882: l_CustSqlWarnFlagSet := TRUE;
883: -- Fix for bug: 4179593 End
884: IF (l_debug = 1) THEN

Line 898: fnd_msg_pub.ADD;

894: END IF;
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_NO_DATA_FOUND');
898: fnd_msg_pub.ADD;
899: /* Replaced following statement for Bug 4207625: Anupam Jain*/
900: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
901: -- Fix for bug: 4179593 Start
902: --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 900: /fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);/

896: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
897: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
898: fnd_msg_pub.ADD;
899: /* Replaced following statement for Bug 4207625: Anupam Jain*/
900: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
901: -- Fix for bug: 4179593 Start
902: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
903: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
904: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

898: fnd_msg_pub.ADD;
899: /* Replaced following statement for Bug 4207625: Anupam Jain*/
900: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
901: -- Fix for bug: 4179593 Start
902: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
903: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
904: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
905: l_CustSqlWarnFlagSet := TRUE;
906: -- Fix for bug: 4179593 End

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

899: /* Replaced following statement for Bug 4207625: Anupam Jain*/
900: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
901: -- Fix for bug: 4179593 Start
902: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
903: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
904: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
905: l_CustSqlWarnFlagSet := TRUE;
906: -- Fix for bug: 4179593 End
907: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 916: fnd_msg_pub.ADD;

912: l_sql_stmt_result := NULL;
913: x_return_status := FND_API.G_RET_STS_SUCCESS;
914: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
915: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
916: fnd_msg_pub.ADD;
917: /* Replaced following statement for Bug 4207625: Anupam Jain*/
918: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
919: -- Fix for bug: 4179593 Start
920: --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 918: /fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);/

914: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
915: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
916: fnd_msg_pub.ADD;
917: /* Replaced following statement for Bug 4207625: Anupam Jain*/
918: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
919: -- Fix for bug: 4179593 Start
920: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
921: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
922: l_CustSqlErrMsg := l_custom_sql_ret_msg;

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

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

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

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

Line 940: fnd_msg_pub.ADD;

936: trace('Custom Labels Trace [INVLAP7B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
937: END IF;
938: x_return_status := FND_API.G_RET_STS_ERROR;
939: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
940: fnd_msg_pub.ADD;
941: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
943: END;
944: IF (l_debug = 1) THEN

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

937: END IF;
938: x_return_status := FND_API.G_RET_STS_ERROR;
939: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
940: fnd_msg_pub.ADD;
941: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
943: END;
944: IF (l_debug = 1) THEN
945: trace('Custom Labels Trace [INVLAP7B.pls]: At Breadcrumb 6');