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 1519: x_return_status := FND_API.G_RET_STS_SUCCESS;

1515: l_wdd_loop_counter_start NUMBER := 1; -- Bug 16506369
1516:
1517: BEGIN
1518: -- Initialize return status as success
1519: x_return_status := FND_API.G_RET_STS_SUCCESS;
1520: -- Initialize debug
1521: l_debug := INV_LABEL.l_debug;
1522:
1523:

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

1816: x_return_status => l_return_status,
1817: x_msg_data => l_msg_data,
1818: x_msg_count => l_msg_count);
1819:
1820: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
1821: IF (l_debug = 1) THEN
1822: trace('Failed to get the pick UOM');
1823: END IF;
1824: l_loop_counter := l_cons_wdd.shipped_quantity;

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

1823: END IF;
1824: l_loop_counter := l_cons_wdd.shipped_quantity;
1825: END IF;
1826:
1827: IF ( l_return_status = fnd_api.g_ret_sts_success ) THEN
1828: IF (l_debug = 1) THEN
1829: trace('l_pick_uom ' || l_pick_uom);
1830: trace('l_pick_qty ' || l_pick_qty);
1831: trace('l_uom_string ' || l_uom_string);

Line 1865: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

1861: p_organization_id => l_wdd_tb(l_qty_index).organization_id,
1862: p_lpn_out => l_to_lpn,
1863: p_lpn_id_out => l_to_lpn_id,
1864: p_process_id => l_process_id,
1865: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1866: p_client_code => wms_deploy.get_client_code(l_wdd_tb(l_qty_index).inventory_item_id) -- Added for LSP, bug 9087971
1867: );
1868:
1869: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN

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

1865: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1866: p_client_code => wms_deploy.get_client_code(l_wdd_tb(l_qty_index).inventory_item_id) -- Added for LSP, bug 9087971
1867: );
1868:
1869: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
1870: IF (l_debug = 1) THEN
1871: trace('failed to genrate LPN');
1872: END IF;
1873: fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');

Line 3715: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;

3711: /* Loop for each selected fields, find the columns and write into the XML_content*/
3712: OPEN c_fields_for_format (l_label_format_id);
3713:
3714: l_variable_list := '';
3715: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;
3716:
3717: LOOP -- Loop for c_fields_for_format
3718: FETCH c_fields_for_format
3719: INTO l_column_name_in_format;

Line 3762: x_return_status := FND_API.G_RET_STS_SUCCESS;

3758: EXIT WHEN c_sql_stmt%notfound OR c_sql_stmt%rowcount >=2;
3759: END LOOP;
3760:
3761: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
3762: x_return_status := FND_API.G_RET_STS_SUCCESS;
3763: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3764: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
3765: fnd_msg_pub.ADD;
3766: -- Fix for bug: 4179593 Start

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

3763: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3764: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
3765: fnd_msg_pub.ADD;
3766: -- Fix for bug: 4179593 Start
3767: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3768: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3769: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3770: l_CustSqlWarnFlagSet := TRUE;
3771: -- Fix for bug: 4179593 End

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

3764: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
3765: fnd_msg_pub.ADD;
3766: -- Fix for bug: 4179593 Start
3767: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3768: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3769: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3770: l_CustSqlWarnFlagSet := TRUE;
3771: -- Fix for bug: 4179593 End
3772: IF (l_debug = 1) THEN

Line 3783: x_return_status := FND_API.G_RET_STS_SUCCESS;

3779: IF (l_debug = 1) THEN
3780: trace('Custom Labels Trace [INVLAP8B.pls]: At Breadcrumb 3');
3781: trace('Custom Labels Trace [INVLAP8B.pls]: WARNING: No row returned by the Custom SQL query');
3782: END IF;
3783: x_return_status := FND_API.G_RET_STS_SUCCESS;
3784: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3785: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
3786: fnd_msg_pub.ADD;
3787: -- Fix for bug: 4179593 Start

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

3784: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3785: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
3786: fnd_msg_pub.ADD;
3787: -- Fix for bug: 4179593 Start
3788: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3789: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3790: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3791: l_CustSqlWarnFlagSet := TRUE;
3792: -- Fix for bug: 4179593 End

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

3785: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
3786: fnd_msg_pub.ADD;
3787: -- Fix for bug: 4179593 Start
3788: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3789: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3790: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3791: l_CustSqlWarnFlagSet := TRUE;
3792: -- Fix for bug: 4179593 End
3793: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 3798: x_return_status := FND_API.G_RET_STS_SUCCESS;

3794: IF (l_debug = 1) THEN
3795: trace('Custom Labels Trace [INVLAP8B.pls]: At Breadcrumb 4');
3796: trace('Custom Labels Trace [INVLAP8B.pls]: ERROR: Multiple values returned by the Custom SQL query');
3797: END IF;
3798: x_return_status := FND_API.G_RET_STS_SUCCESS;
3799: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3800: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
3801: fnd_msg_pub.ADD;
3802: -- Fix for bug: 4179593 Start

Line 3799: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

3795: trace('Custom Labels Trace [INVLAP8B.pls]: At Breadcrumb 4');
3796: trace('Custom Labels Trace [INVLAP8B.pls]: ERROR: Multiple values returned by the Custom SQL query');
3797: END IF;
3798: x_return_status := FND_API.G_RET_STS_SUCCESS;
3799: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3800: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
3801: fnd_msg_pub.ADD;
3802: -- Fix for bug: 4179593 Start
3803: --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 3803: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

3799: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3800: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
3801: fnd_msg_pub.ADD;
3802: -- Fix for bug: 4179593 Start
3803: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3804: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3805: l_CustSqlErrMsg := l_custom_sql_ret_msg;
3806: l_CustSqlErrFlagSet := TRUE;
3807: -- Fix for bug: 4179593 End

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

3800: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
3801: fnd_msg_pub.ADD;
3802: -- Fix for bug: 4179593 Start
3803: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3804: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3805: l_CustSqlErrMsg := l_custom_sql_ret_msg;
3806: l_CustSqlErrFlagSet := TRUE;
3807: -- Fix for bug: 4179593 End
3808: END IF;

Line 3821: x_return_status := FND_API.G_RET_STS_ERROR;

3817: IF (l_debug = 1) THEN
3818: trace('Custom Labels Trace [INVLAP8B.pls]: At Breadcrumb 5');
3819: trace('Custom Labels Trace [INVLAP8B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
3820: END IF;
3821: x_return_status := FND_API.G_RET_STS_ERROR;
3822: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3823: fnd_msg_pub.ADD;
3824: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3820: END IF;
3821: x_return_status := FND_API.G_RET_STS_ERROR;
3822: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3823: fnd_msg_pub.ADD;
3824: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3826: END;
3827: IF (l_debug = 1) THEN
3828: trace('Custom Labels Trace [INVLAP8B.pls]: At Breadcrumb 6');

Line 3825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3821: x_return_status := FND_API.G_RET_STS_ERROR;
3822: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3823: fnd_msg_pub.ADD;
3824: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3826: END;
3827: IF (l_debug = 1) THEN
3828: trace('Custom Labels Trace [INVLAP8B.pls]: At Breadcrumb 6');
3829: trace('Custom Labels Trace [INVLAP8B.pls]: Before assigning it to l_shipping_content_data');

Line 3930: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

3926: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
3927: END IF;
3928:
3929: IF (l_CustSqlErrFlagSet) THEN
3930: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3931: l_custom_sql_ret_msg := l_CustSqlErrMsg;
3932: END IF;
3933: -- Fix for bug: 4179593 End
3934: