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

2783: x_label_request_id => l_label_request_id);
2784:
2785: IF l_return_status <> 'S' THEN
2786: FND_MESSAGE.SET_NAME('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
2787: FND_MSG_PUB.ADD;
2788: l_label_format:= p_label_type_info.default_format_id;
2789: l_label_format_id:= p_label_type_info.default_format_name;
2790: END IF;
2791:

Line 2948: fnd_msg_pub.ADD;

2944: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
2945: x_return_status := FND_API.G_RET_STS_SUCCESS;
2946: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2947: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
2948: fnd_msg_pub.ADD;
2949: -- Fix for bug: 4179593 Start
2950: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2951: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2952: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

2946: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2947: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
2948: fnd_msg_pub.ADD;
2949: -- Fix for bug: 4179593 Start
2950: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2951: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2952: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2953: l_CustSqlWarnFlagSet := TRUE;
2954: -- Fix for bug: 4179593 End

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

2947: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
2948: fnd_msg_pub.ADD;
2949: -- Fix for bug: 4179593 Start
2950: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2951: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2952: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2953: l_CustSqlWarnFlagSet := TRUE;
2954: -- Fix for bug: 4179593 End
2955:

Line 2970: fnd_msg_pub.ADD;

2966: END IF;
2967: x_return_status := FND_API.G_RET_STS_SUCCESS;
2968: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2969: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
2970: fnd_msg_pub.ADD;
2971: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2972: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2973: -- Fix for bug: 4179593 Start
2974: --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 2972: /fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);/

2968: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2969: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
2970: fnd_msg_pub.ADD;
2971: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2972: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2973: -- Fix for bug: 4179593 Start
2974: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2975: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2976: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

2970: fnd_msg_pub.ADD;
2971: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2972: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2973: -- Fix for bug: 4179593 Start
2974: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2975: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2976: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2977: l_CustSqlWarnFlagSet := TRUE;
2978: -- Fix for bug: 4179593 End

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

2971: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2972: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2973: -- Fix for bug: 4179593 Start
2974: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2975: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2976: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2977: l_CustSqlWarnFlagSet := TRUE;
2978: -- Fix for bug: 4179593 End
2979: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 2988: fnd_msg_pub.ADD;

2984: l_sql_stmt_result := NULL;
2985: x_return_status := FND_API.G_RET_STS_SUCCESS;
2986: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
2987: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
2988: fnd_msg_pub.ADD;
2989: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2990: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2991: -- Fix for bug: 4179593 Start
2992: --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 2990: /fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);/

2986: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
2987: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
2988: fnd_msg_pub.ADD;
2989: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2990: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2991: -- Fix for bug: 4179593 Start
2992: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2993: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2994: l_CustSqlErrMsg := l_custom_sql_ret_msg;

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

2988: fnd_msg_pub.ADD;
2989: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2990: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2991: -- Fix for bug: 4179593 Start
2992: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2993: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2994: l_CustSqlErrMsg := l_custom_sql_ret_msg;
2995: l_CustSqlErrFlagSet := TRUE;
2996: -- Fix for bug: 4179593 End

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

2989: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2990: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2991: -- Fix for bug: 4179593 Start
2992: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2993: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2994: l_CustSqlErrMsg := l_custom_sql_ret_msg;
2995: l_CustSqlErrFlagSet := TRUE;
2996: -- Fix for bug: 4179593 End
2997: END IF;

Line 3012: fnd_msg_pub.ADD;

3008: trace('Custom Labels Trace [INVLA10B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
3009: END IF;
3010: x_return_status := FND_API.G_RET_STS_ERROR;
3011: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3012: fnd_msg_pub.ADD;
3013: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3015: END;
3016: IF (l_debug = 1) THEN

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

3009: END IF;
3010: x_return_status := FND_API.G_RET_STS_ERROR;
3011: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3012: fnd_msg_pub.ADD;
3013: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3015: END;
3016: IF (l_debug = 1) THEN
3017: trace('Custom Labels Trace [INVLA10B.pls]: At Breadcrumb 6');

Line 3110: FND_MSG_PUB.ADD;

3106: x_return_status := FND_API.G_RET_STS_ERROR;
3107:
3108: WHEN NO_LABEL_FORMAT_FOUND_X THEN
3109: FND_MESSAGE.SET_NAME('WMS', 'WMS_LABL_NO_LABEL_CREATED');
3110: FND_MSG_PUB.ADD;
3111: x_return_status := FND_API.G_RET_STS_ERROR;
3112:
3113:
3114: