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_PVT8 dependencies on FND_API

Line 1376: x_return_status := FND_API.G_RET_STS_SUCCESS;

1372: --Bug 6880623
1373:
1374: BEGIN
1375: -- Initialize return status as success
1376: x_return_status := FND_API.G_RET_STS_SUCCESS;
1377: -- Initialize debug
1378: l_debug := INV_LABEL.l_debug;
1379:
1380:

Line 1677: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN

1673: x_return_status => l_return_status,
1674: x_msg_data => l_msg_data,
1675: x_msg_count => l_msg_count);
1676:
1677: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
1678: IF (l_debug = 1) THEN
1679: trace('Failed to get the pick UOM');
1680: END IF;
1681: l_loop_counter := l_cons_wdd.shipped_quantity;

Line 1684: IF ( l_return_status = fnd_api.g_ret_sts_success ) THEN

1680: END IF;
1681: l_loop_counter := l_cons_wdd.shipped_quantity;
1682: END IF;
1683:
1684: IF ( l_return_status = fnd_api.g_ret_sts_success ) THEN
1685: IF (l_debug = 1) THEN
1686: trace('l_pick_uom ' || l_pick_uom);
1687: trace('l_pick_qty ' || l_pick_qty);
1688: trace('l_uom_string ' || l_uom_string);

Line 1722: p_validation_level => FND_API.G_VALID_LEVEL_NONE);

1718: p_organization_id => l_wdd_tb(l_qty_index).organization_id,
1719: p_lpn_out => l_to_lpn,
1720: p_lpn_id_out => l_to_lpn_id,
1721: p_process_id => l_process_id,
1722: p_validation_level => FND_API.G_VALID_LEVEL_NONE);
1723:
1724: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
1725: IF (l_debug = 1) THEN
1726: trace('failed to genrate LPN');

Line 1724: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN

1720: p_lpn_id_out => l_to_lpn_id,
1721: p_process_id => l_process_id,
1722: p_validation_level => FND_API.G_VALID_LEVEL_NONE);
1723:
1724: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
1725: IF (l_debug = 1) THEN
1726: trace('failed to genrate LPN');
1727: END IF;
1728: fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');

Line 3002: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;

2998: /* Loop for each selected fields, find the columns and write into the XML_content*/
2999: OPEN c_fields_for_format (l_label_format_id);
3000:
3001: l_variable_list := '';
3002: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;
3003:
3004: LOOP -- Loop for c_fields_for_format
3005: FETCH c_fields_for_format
3006: INTO l_column_name_in_format;

Line 3049: x_return_status := FND_API.G_RET_STS_SUCCESS;

3045: EXIT WHEN c_sql_stmt%notfound OR c_sql_stmt%rowcount >=2;
3046: END LOOP;
3047:
3048: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
3049: x_return_status := FND_API.G_RET_STS_SUCCESS;
3050: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3051: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
3052: fnd_msg_pub.ADD;
3053: -- Fix for bug: 4179593 Start

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

3050: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3051: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
3052: fnd_msg_pub.ADD;
3053: -- Fix for bug: 4179593 Start
3054: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3055: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3056: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3057: l_CustSqlWarnFlagSet := TRUE;
3058: -- Fix for bug: 4179593 End

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

3051: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
3052: fnd_msg_pub.ADD;
3053: -- Fix for bug: 4179593 Start
3054: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3055: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3056: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3057: l_CustSqlWarnFlagSet := TRUE;
3058: -- Fix for bug: 4179593 End
3059: IF (l_debug = 1) THEN

Line 3070: x_return_status := FND_API.G_RET_STS_SUCCESS;

3066: IF (l_debug = 1) THEN
3067: trace('Custom Labels Trace [INVLAP8B.pls]: At Breadcrumb 3');
3068: trace('Custom Labels Trace [INVLAP8B.pls]: WARNING: No row returned by the Custom SQL query');
3069: END IF;
3070: x_return_status := FND_API.G_RET_STS_SUCCESS;
3071: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3072: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
3073: fnd_msg_pub.ADD;
3074: -- Fix for bug: 4179593 Start

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

3071: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3072: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
3073: fnd_msg_pub.ADD;
3074: -- Fix for bug: 4179593 Start
3075: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3076: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3077: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3078: l_CustSqlWarnFlagSet := TRUE;
3079: -- Fix for bug: 4179593 End

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

3072: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
3073: fnd_msg_pub.ADD;
3074: -- Fix for bug: 4179593 Start
3075: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3076: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3077: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3078: l_CustSqlWarnFlagSet := TRUE;
3079: -- Fix for bug: 4179593 End
3080: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 3085: x_return_status := FND_API.G_RET_STS_SUCCESS;

3081: IF (l_debug = 1) THEN
3082: trace('Custom Labels Trace [INVLAP8B.pls]: At Breadcrumb 4');
3083: trace('Custom Labels Trace [INVLAP8B.pls]: ERROR: Multiple values returned by the Custom SQL query');
3084: END IF;
3085: x_return_status := FND_API.G_RET_STS_SUCCESS;
3086: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3087: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
3088: fnd_msg_pub.ADD;
3089: -- Fix for bug: 4179593 Start

Line 3086: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

3082: trace('Custom Labels Trace [INVLAP8B.pls]: At Breadcrumb 4');
3083: trace('Custom Labels Trace [INVLAP8B.pls]: ERROR: Multiple values returned by the Custom SQL query');
3084: END IF;
3085: x_return_status := FND_API.G_RET_STS_SUCCESS;
3086: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3087: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
3088: fnd_msg_pub.ADD;
3089: -- Fix for bug: 4179593 Start
3090: --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 3090: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

3086: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3087: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
3088: fnd_msg_pub.ADD;
3089: -- Fix for bug: 4179593 Start
3090: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3091: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3092: l_CustSqlErrMsg := l_custom_sql_ret_msg;
3093: l_CustSqlErrFlagSet := TRUE;
3094: -- Fix for bug: 4179593 End

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

3087: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
3088: fnd_msg_pub.ADD;
3089: -- Fix for bug: 4179593 Start
3090: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3091: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3092: l_CustSqlErrMsg := l_custom_sql_ret_msg;
3093: l_CustSqlErrFlagSet := TRUE;
3094: -- Fix for bug: 4179593 End
3095: END IF;

Line 3108: x_return_status := FND_API.G_RET_STS_ERROR;

3104: IF (l_debug = 1) THEN
3105: trace('Custom Labels Trace [INVLAP8B.pls]: At Breadcrumb 5');
3106: trace('Custom Labels Trace [INVLAP8B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
3107: END IF;
3108: x_return_status := FND_API.G_RET_STS_ERROR;
3109: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3110: fnd_msg_pub.ADD;
3111: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3107: END IF;
3108: x_return_status := FND_API.G_RET_STS_ERROR;
3109: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3110: fnd_msg_pub.ADD;
3111: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3113: END;
3114: IF (l_debug = 1) THEN
3115: trace('Custom Labels Trace [INVLAP8B.pls]: At Breadcrumb 6');

Line 3112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3108: x_return_status := FND_API.G_RET_STS_ERROR;
3109: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3110: fnd_msg_pub.ADD;
3111: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3113: END;
3114: IF (l_debug = 1) THEN
3115: trace('Custom Labels Trace [INVLAP8B.pls]: At Breadcrumb 6');
3116: trace('Custom Labels Trace [INVLAP8B.pls]: Before assigning it to l_shipping_content_data');

Line 3203: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

3199: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
3200: END IF;
3201:
3202: IF (l_CustSqlErrFlagSet) THEN
3203: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3204: l_custom_sql_ret_msg := l_CustSqlErrMsg;
3205: END IF;
3206: -- Fix for bug: 4179593 End
3207: