DBA Data[Home] [Help]

APPS.INV_LABEL_PVT1 dependencies on FND_MSG_PUB

Line 2094: fnd_msg_pub.ADD;

2090: );
2091:
2092: IF l_return_status <> 'S' THEN
2093: fnd_message.set_name('WMS', 'WMS_INSTALL_CHECK_INSTALL_FAILED');
2094: fnd_msg_pub.ADD;
2095: RETURN;
2096: END IF;
2097:
2098: IF (l_debug = 1) THEN

Line 3249: fnd_msg_pub.ADD;

3245: );
3246:
3247: IF l_return_status <> 'S' THEN
3248: fnd_message.set_name('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
3249: fnd_msg_pub.ADD;
3250: l_label_format_set_id := p_label_type_info.default_format_id;
3251: l_label_format := p_label_type_info.default_format_name;
3252: END IF;
3253:

Line 3323: fnd_msg_pub.ADD;

3319: );
3320:
3321: IF l_return_status <> 'S' THEN
3322: fnd_message.set_name('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
3323: fnd_msg_pub.ADD;
3324: l_label_format_id := p_label_type_info.default_format_id;
3325: l_label_format := p_label_type_info.default_format_name;
3326: END IF;
3327:

Line 3545: fnd_msg_pub.ADD;

3541: );
3542:
3543: IF l_return_status <> 'S' THEN
3544: fnd_message.set_name('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
3545: fnd_msg_pub.ADD;
3546: l_label_format_id := p_label_type_info.default_format_id;
3547: l_label_format := p_label_type_info.default_format_name;
3548: END IF;
3549:

Line 3724: fnd_msg_pub.ADD;

3720: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
3721: x_return_status := FND_API.G_RET_STS_SUCCESS;
3722: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3723: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
3724: fnd_msg_pub.ADD;
3725: -- Fix for bug: 4179593 Start
3726: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3727: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3728: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

3722: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3723: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
3724: fnd_msg_pub.ADD;
3725: -- Fix for bug: 4179593 Start
3726: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3727: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3728: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3729: l_CustSqlWarnFlagSet := TRUE;
3730: -- Fix for bug: 4179593 End

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

3723: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
3724: fnd_msg_pub.ADD;
3725: -- Fix for bug: 4179593 Start
3726: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3727: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3728: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3729: l_CustSqlWarnFlagSet := TRUE;
3730: -- Fix for bug: 4179593 End
3731:

Line 3746: fnd_msg_pub.ADD;

3742: END IF;
3743: x_return_status := FND_API.G_RET_STS_SUCCESS;
3744: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3745: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
3746: fnd_msg_pub.ADD;
3747: -- Fix for bug: 4179593 Start
3748: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3749: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3750: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

3744: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3745: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
3746: fnd_msg_pub.ADD;
3747: -- Fix for bug: 4179593 Start
3748: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3749: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3750: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3751: l_CustSqlWarnFlagSet := TRUE;
3752: -- Fix for bug: 4179593 End

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

3745: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
3746: fnd_msg_pub.ADD;
3747: -- Fix for bug: 4179593 Start
3748: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3749: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3750: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3751: l_CustSqlWarnFlagSet := TRUE;
3752: -- Fix for bug: 4179593 End
3753: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 3762: fnd_msg_pub.ADD;

3758: l_sql_stmt_result := NULL;
3759: x_return_status := FND_API.G_RET_STS_SUCCESS;
3760: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3761: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
3762: fnd_msg_pub.ADD;
3763: -- Fix for bug: 4179593 Start
3764: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3765: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3766: l_CustSqlErrMsg := l_custom_sql_ret_msg;

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

3760: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3761: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
3762: fnd_msg_pub.ADD;
3763: -- Fix for bug: 4179593 Start
3764: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3765: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3766: l_CustSqlErrMsg := l_custom_sql_ret_msg;
3767: l_CustSqlErrFlagSet := TRUE;
3768: -- Fix for bug: 4179593 End

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

3761: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
3762: fnd_msg_pub.ADD;
3763: -- Fix for bug: 4179593 Start
3764: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3765: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3766: l_CustSqlErrMsg := l_custom_sql_ret_msg;
3767: l_CustSqlErrFlagSet := TRUE;
3768: -- Fix for bug: 4179593 End
3769: END IF;

Line 3784: fnd_msg_pub.ADD;

3780: trace('Custom Labels Trace [INVLAP1B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
3781: END IF;
3782: x_return_status := FND_API.G_RET_STS_ERROR;
3783: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3784: fnd_msg_pub.ADD;
3785: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3787: END;
3788: IF (l_debug = 1) THEN

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

3781: END IF;
3782: x_return_status := FND_API.G_RET_STS_ERROR;
3783: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3784: fnd_msg_pub.ADD;
3785: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3787: END;
3788: IF (l_debug = 1) THEN
3789: trace('Custom Labels Trace [INVLAP1B.pls]: At Breadcrumb 6');