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

Line 2357: FND_MSG_PUB.ADD;

2353: IF (l_debug = 1) THEN
2354: trace('Item is serial number control. No serial Number found !!!');
2355: END IF;
2356: FND_MESSAGE.SET_NAME('INV', 'WMS_SERIAL_FOUND');
2357: FND_MSG_PUB.ADD;
2358: RAISE SERIAL_EXCEPTION;
2359: -- Bug 2882958
2360: ELSE
2361: -- Reduce l_count to avoid extra increment

Line 2395: FND_MSG_PUB.ADD;

2391:
2392: IF l_serial_not_found THEN
2393: trace('Item is serial number control. No serial Number found !!!');
2394: FND_MESSAGE.SET_NAME('INV', 'WMS_SERIAL_FOUND');
2395: FND_MSG_PUB.ADD;
2396: RAISE SERIAL_EXCEPTION;
2397: -- Bug 2882958
2398: ELSE
2399: -- Reduce l_count to avoid extra increment

Line 2440: FND_MSG_PUB.ADD;

2436: IF (l_debug = 1) THEN
2437: trace('Item is serial number control. No serial Number found !!!');
2438: END IF;
2439: FND_MESSAGE.SET_NAME('INV', 'WMS_SERIAL_FOUND');
2440: FND_MSG_PUB.ADD;
2441: RAISE SERIAL_EXCEPTION;
2442: -- Bug 2882958
2443: ELSE
2444: -- Reduce l_count to avoid extra increment

Line 2481: FND_MSG_PUB.ADD;

2477: ,x_return_status => l_return_status
2478: ,x_number_table => l_serial_numbers_table);
2479: IF l_return_status <> 'S' THEN
2480: FND_MESSAGE.SET_NAME('WMS', 'WMS_GET_SER_CUR_FAILED');
2481: FND_MSG_PUB.ADD;
2482: RAISE SERIAL_EXCEPTION;
2483: END IF;
2484:
2485: FOR j IN 1..l_serial_numbers_table.count LOOP

Line 2496: FND_MSG_PUB.ADD;

2492: IF (l_debug = 1) THEN
2493: trace('Item is serial number control. No serial Number found !!! ');
2494: END IF;
2495: FND_MESSAGE.SET_NAME('INV', 'WMS_SERIAL_FOUND');
2496: FND_MSG_PUB.ADD;
2497: RAISE SERIAL_EXCEPTION;
2498:
2499: END IF;
2500:

Line 2543: FND_MSG_PUB.ADD;

2539: IF (l_debug = 1) THEN
2540: trace('Item is serial number control. No serial Number found ');
2541: END IF;
2542: FND_MESSAGE.SET_NAME('INV', 'WMS_SERIAL_FOUND');
2543: FND_MSG_PUB.ADD;
2544: -- RAISE SERIAL_EXCEPTION;
2545: END IF;
2546: ELSE
2547: l_in_tbl(l_counter) := l_in_rec;

Line 2576: FND_MSG_PUB.ADD;

2572: IF (l_debug = 1) THEN
2573: trace('Item is serial number control. No serial Number found ');
2574: END IF;
2575: FND_MESSAGE.SET_NAME('INV', 'WMS_SERIAL_FOUND');
2576: FND_MSG_PUB.ADD;
2577: -- RAISE SERIAL_EXCEPTION;
2578: END IF;
2579: ELSE
2580: l_in_tbl(l_counter) := l_in_rec;

Line 2796: FND_MSG_PUB.ADD;

2792: x_label_request_id => l_label_request_id);
2793:
2794: IF l_return_status <> 'S' THEN
2795: FND_MESSAGE.SET_NAME('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
2796: FND_MSG_PUB.ADD;
2797: l_label_format:= p_label_type_info.default_format_id;
2798: l_label_format_id:= p_label_type_info.default_format_name;
2799: END IF;
2800:

Line 2957: fnd_msg_pub.ADD;

2953: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
2954: x_return_status := FND_API.G_RET_STS_SUCCESS;
2955: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2956: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
2957: fnd_msg_pub.ADD;
2958: -- Fix for bug: 4179593 Start
2959: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2960: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2961: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

2955: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2956: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
2957: fnd_msg_pub.ADD;
2958: -- Fix for bug: 4179593 Start
2959: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2960: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2961: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2962: l_CustSqlWarnFlagSet := TRUE;
2963: -- Fix for bug: 4179593 End

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

2956: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
2957: fnd_msg_pub.ADD;
2958: -- Fix for bug: 4179593 Start
2959: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2960: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2961: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2962: l_CustSqlWarnFlagSet := TRUE;
2963: -- Fix for bug: 4179593 End
2964:

Line 2979: fnd_msg_pub.ADD;

2975: END IF;
2976: x_return_status := FND_API.G_RET_STS_SUCCESS;
2977: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2978: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
2979: fnd_msg_pub.ADD;
2980: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2981: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2982: -- Fix for bug: 4179593 Start
2983: --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 2981: /fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);/

2977: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2978: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
2979: fnd_msg_pub.ADD;
2980: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2981: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2982: -- Fix for bug: 4179593 Start
2983: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2984: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2985: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

2979: fnd_msg_pub.ADD;
2980: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2981: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2982: -- Fix for bug: 4179593 Start
2983: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2984: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2985: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2986: l_CustSqlWarnFlagSet := TRUE;
2987: -- Fix for bug: 4179593 End

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

2980: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2981: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2982: -- Fix for bug: 4179593 Start
2983: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2984: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2985: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2986: l_CustSqlWarnFlagSet := TRUE;
2987: -- Fix for bug: 4179593 End
2988: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 2997: fnd_msg_pub.ADD;

2993: l_sql_stmt_result := NULL;
2994: x_return_status := FND_API.G_RET_STS_SUCCESS;
2995: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
2996: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
2997: fnd_msg_pub.ADD;
2998: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2999: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
3000: -- Fix for bug: 4179593 Start
3001: --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 2999: /fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);/

2995: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
2996: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
2997: fnd_msg_pub.ADD;
2998: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2999: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
3000: -- Fix for bug: 4179593 Start
3001: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3002: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3003: l_CustSqlErrMsg := l_custom_sql_ret_msg;

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

2997: fnd_msg_pub.ADD;
2998: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2999: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
3000: -- Fix for bug: 4179593 Start
3001: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3002: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3003: l_CustSqlErrMsg := l_custom_sql_ret_msg;
3004: l_CustSqlErrFlagSet := TRUE;
3005: -- Fix for bug: 4179593 End

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

2998: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2999: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
3000: -- Fix for bug: 4179593 Start
3001: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3002: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3003: l_CustSqlErrMsg := l_custom_sql_ret_msg;
3004: l_CustSqlErrFlagSet := TRUE;
3005: -- Fix for bug: 4179593 End
3006: END IF;

Line 3021: fnd_msg_pub.ADD;

3017: trace('Custom Labels Trace [INVLA10B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
3018: END IF;
3019: x_return_status := FND_API.G_RET_STS_ERROR;
3020: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3021: fnd_msg_pub.ADD;
3022: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3024: END;
3025: IF (l_debug = 1) THEN

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

3018: END IF;
3019: x_return_status := FND_API.G_RET_STS_ERROR;
3020: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3021: fnd_msg_pub.ADD;
3022: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3024: END;
3025: IF (l_debug = 1) THEN
3026: trace('Custom Labels Trace [INVLA10B.pls]: At Breadcrumb 6');

Line 3119: FND_MSG_PUB.ADD;

3115: x_return_status := FND_API.G_RET_STS_ERROR;
3116:
3117: WHEN NO_LABEL_FORMAT_FOUND_X THEN
3118: FND_MESSAGE.SET_NAME('WMS', 'WMS_LABL_NO_LABEL_CREATED');
3119: FND_MSG_PUB.ADD;
3120: x_return_status := FND_API.G_RET_STS_ERROR;
3121:
3122:
3123: