DBA Data[Home] [Help]

APPS.INV_LABEL_PVT1 dependencies on FND_MSG_PUB

Line 2216: fnd_msg_pub.ADD;

2212: );
2213:
2214: IF l_return_status <> 'S' THEN
2215: fnd_message.set_name('WMS', 'WMS_INSTALL_CHECK_INSTALL_FAILED');
2216: fnd_msg_pub.ADD;
2217: RETURN;
2218: END IF;
2219:
2220: IF (l_debug = 1) THEN

Line 3548: fnd_msg_pub.ADD;

3544: );
3545:
3546: IF l_return_status <> 'S' THEN
3547: fnd_message.set_name('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
3548: fnd_msg_pub.ADD;
3549: l_label_format_set_id := p_label_type_info.default_format_id;
3550: l_label_format := p_label_type_info.default_format_name;
3551: END IF;
3552:

Line 3622: fnd_msg_pub.ADD;

3618: );
3619:
3620: IF l_return_status <> 'S' THEN
3621: fnd_message.set_name('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
3622: fnd_msg_pub.ADD;
3623: l_label_format_id := p_label_type_info.default_format_id;
3624: l_label_format := p_label_type_info.default_format_name;
3625: END IF;
3626:

Line 3843: fnd_msg_pub.ADD;

3839: );
3840:
3841: IF l_return_status <> 'S' THEN
3842: fnd_message.set_name('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
3843: fnd_msg_pub.ADD;
3844: l_label_format_id := p_label_type_info.default_format_id;
3845: l_label_format := p_label_type_info.default_format_name;
3846: END IF;
3847:

Line 4022: fnd_msg_pub.ADD;

4018: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
4019: x_return_status := FND_API.G_RET_STS_SUCCESS;
4020: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
4021: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
4022: fnd_msg_pub.ADD;
4023: -- Fix for bug: 4179593 Start
4024: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
4025: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
4026: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

4020: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
4021: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
4022: fnd_msg_pub.ADD;
4023: -- Fix for bug: 4179593 Start
4024: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
4025: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
4026: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
4027: l_CustSqlWarnFlagSet := TRUE;
4028: -- Fix for bug: 4179593 End

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

4021: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
4022: fnd_msg_pub.ADD;
4023: -- Fix for bug: 4179593 Start
4024: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
4025: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
4026: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
4027: l_CustSqlWarnFlagSet := TRUE;
4028: -- Fix for bug: 4179593 End
4029:

Line 4044: fnd_msg_pub.ADD;

4040: END IF;
4041: x_return_status := FND_API.G_RET_STS_SUCCESS;
4042: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
4043: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
4044: fnd_msg_pub.ADD;
4045: -- Fix for bug: 4179593 Start
4046: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
4047: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
4048: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

4042: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
4043: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
4044: fnd_msg_pub.ADD;
4045: -- Fix for bug: 4179593 Start
4046: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
4047: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
4048: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
4049: l_CustSqlWarnFlagSet := TRUE;
4050: -- Fix for bug: 4179593 End

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

4043: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
4044: fnd_msg_pub.ADD;
4045: -- Fix for bug: 4179593 Start
4046: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
4047: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
4048: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
4049: l_CustSqlWarnFlagSet := TRUE;
4050: -- Fix for bug: 4179593 End
4051: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 4060: fnd_msg_pub.ADD;

4056: l_sql_stmt_result := NULL;
4057: x_return_status := FND_API.G_RET_STS_SUCCESS;
4058: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
4059: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
4060: fnd_msg_pub.ADD;
4061: -- Fix for bug: 4179593 Start
4062: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
4063: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
4064: l_CustSqlErrMsg := l_custom_sql_ret_msg;

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

4058: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
4059: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
4060: fnd_msg_pub.ADD;
4061: -- Fix for bug: 4179593 Start
4062: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
4063: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
4064: l_CustSqlErrMsg := l_custom_sql_ret_msg;
4065: l_CustSqlErrFlagSet := TRUE;
4066: -- Fix for bug: 4179593 End

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

4059: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
4060: fnd_msg_pub.ADD;
4061: -- Fix for bug: 4179593 Start
4062: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
4063: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
4064: l_CustSqlErrMsg := l_custom_sql_ret_msg;
4065: l_CustSqlErrFlagSet := TRUE;
4066: -- Fix for bug: 4179593 End
4067: END IF;

Line 4082: fnd_msg_pub.ADD;

4078: trace('Custom Labels Trace [INVLAP1B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
4079: END IF;
4080: x_return_status := FND_API.G_RET_STS_ERROR;
4081: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
4082: fnd_msg_pub.ADD;
4083: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4085: END;
4086: IF (l_debug = 1) THEN

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

4079: END IF;
4080: x_return_status := FND_API.G_RET_STS_ERROR;
4081: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
4082: fnd_msg_pub.ADD;
4083: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4085: END;
4086: IF (l_debug = 1) THEN
4087: trace('Custom Labels Trace [INVLAP1B.pls]: At Breadcrumb 6');