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

Line 3016: FND_MSG_PUB.ADD;

3012: x_label_request_id =>l_label_request_id);
3013:
3014: IF l_return_status <> 'S' THEN
3015: FND_MESSAGE.SET_NAME('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
3016: FND_MSG_PUB.ADD;
3017: l_label_format_set_id:= p_label_type_info.default_format_id;
3018: l_label_format := p_label_type_info.default_format_name;
3019: END IF;
3020:

Line 3095: FND_MSG_PUB.ADD;

3091: x_label_request_id =>l_label_request_id);
3092:
3093: IF l_return_status <> 'S' THEN
3094: FND_MESSAGE.SET_NAME('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
3095: FND_MSG_PUB.ADD;
3096: l_label_format_id:= p_label_type_info.default_format_id;
3097: l_label_format := p_label_type_info.default_format_name;
3098: END IF;
3099:

Line 3416: fnd_msg_pub.ADD;

3412: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
3413: x_return_status := FND_API.G_RET_STS_SUCCESS;
3414: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3415: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
3416: fnd_msg_pub.ADD;
3417: -- Fix for bug: 4179593 Start
3418: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3419: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3420: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

3414: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3415: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
3416: fnd_msg_pub.ADD;
3417: -- Fix for bug: 4179593 Start
3418: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3419: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3420: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3421: l_CustSqlWarnFlagSet := TRUE;
3422: -- Fix for bug: 4179593 End

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

3415: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
3416: fnd_msg_pub.ADD;
3417: -- Fix for bug: 4179593 Start
3418: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3419: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3420: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3421: l_CustSqlWarnFlagSet := TRUE;
3422: -- Fix for bug: 4179593 End
3423: IF (l_debug = 1) THEN

Line 3437: fnd_msg_pub.ADD;

3433: END IF;
3434: x_return_status := FND_API.G_RET_STS_SUCCESS;
3435: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3436: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
3437: fnd_msg_pub.ADD;
3438: /* Replaced following statement for Bug 4207625: Anupam Jain*/
3439: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
3440: -- Fix for bug: 4179593 Start
3441: --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 3439: /fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);/

3435: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3436: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
3437: fnd_msg_pub.ADD;
3438: /* Replaced following statement for Bug 4207625: Anupam Jain*/
3439: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
3440: -- Fix for bug: 4179593 Start
3441: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3442: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3443: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

3437: fnd_msg_pub.ADD;
3438: /* Replaced following statement for Bug 4207625: Anupam Jain*/
3439: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
3440: -- Fix for bug: 4179593 Start
3441: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3442: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3443: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3444: l_CustSqlWarnFlagSet := TRUE;
3445: -- Fix for bug: 4179593 End

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

3438: /* Replaced following statement for Bug 4207625: Anupam Jain*/
3439: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
3440: -- Fix for bug: 4179593 Start
3441: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3442: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3443: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3444: l_CustSqlWarnFlagSet := TRUE;
3445: -- Fix for bug: 4179593 End
3446: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 3455: fnd_msg_pub.ADD;

3451: l_sql_stmt_result := NULL;
3452: x_return_status := FND_API.G_RET_STS_SUCCESS;
3453: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3454: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
3455: fnd_msg_pub.ADD;
3456: /* Replaced following statement for Bug 4207625: Anupam Jain*/
3457: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
3458: -- Fix for bug: 4179593 Start
3459: --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 3457: /fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);/

3453: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3454: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
3455: fnd_msg_pub.ADD;
3456: /* Replaced following statement for Bug 4207625: Anupam Jain*/
3457: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
3458: -- Fix for bug: 4179593 Start
3459: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3460: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3461: l_CustSqlErrMsg := l_custom_sql_ret_msg;

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

3455: fnd_msg_pub.ADD;
3456: /* Replaced following statement for Bug 4207625: Anupam Jain*/
3457: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
3458: -- Fix for bug: 4179593 Start
3459: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3460: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3461: l_CustSqlErrMsg := l_custom_sql_ret_msg;
3462: l_CustSqlErrFlagSet := TRUE;
3463: -- Fix for bug: 4179593 End

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

3456: /* Replaced following statement for Bug 4207625: Anupam Jain*/
3457: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
3458: -- Fix for bug: 4179593 Start
3459: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3460: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3461: l_CustSqlErrMsg := l_custom_sql_ret_msg;
3462: l_CustSqlErrFlagSet := TRUE;
3463: -- Fix for bug: 4179593 End
3464: END IF;

Line 3479: fnd_msg_pub.ADD;

3475: trace('Custom Labels Trace [INVLAP4B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
3476: END IF;
3477: x_return_status := FND_API.G_RET_STS_ERROR;
3478: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3479: fnd_msg_pub.ADD;
3480: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3482: END;
3483: IF (l_debug = 1) THEN

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

3476: END IF;
3477: x_return_status := FND_API.G_RET_STS_ERROR;
3478: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3479: fnd_msg_pub.ADD;
3480: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3482: END;
3483: IF (l_debug = 1) THEN
3484: trace('Custom Labels Trace [INVLAP4B.pls]: At Breadcrumb 6');