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.WMS_ZONES_PVT dependencies on FND_API

Line 279: x_return_status := fnd_api.g_ret_sts_success;

275: END IF;
276:
277: l_progress_indicator := '40';
278:
279: x_return_status := fnd_api.g_ret_sts_success;
280:
281: DEBUG('Call Success', l_module_name,0);
282:
283: EXCEPTION

Line 292: x_return_status := fnd_api.g_ret_sts_unexp_error;

288: ||' : ' || SQLERRM,
289: l_module_name,
290: 9
291: );
292: x_return_status := fnd_api.g_ret_sts_unexp_error;
293: --x_msg_count := 1;
294: x_msg_data := substr(SQLERRM, 200);
295:
296: END populate_grid;

Line 1422: x_return_status := fnd_api.g_ret_sts_success;

1418: l_rowid VARCHAR2(200);
1419:
1420: BEGIN
1421:
1422: x_return_status := fnd_api.g_ret_sts_success;
1423:
1424: DEBUG('In procedure :', l_module_name,0);
1425:
1426: IF (l_debug = 1) THEN

Line 1524: x_return_status := fnd_api.g_ret_sts_success;

1520: );
1521:
1522: END IF;
1523:
1524: x_return_status := fnd_api.g_ret_sts_success;
1525:
1526: DEBUG('Call Success', l_module_name,0);
1527:
1528: EXCEPTION

Line 1535: x_return_status := fnd_api.g_ret_sts_unexp_error;

1531: DEBUG('Unexpected Exception :' ||l_progress_indicator
1532: ||' : '||SQLERRM ,
1533: l_module_name,0);
1534:
1535: x_return_status := fnd_api.g_ret_sts_unexp_error;
1536: x_msg_data := substr(SQLERRM, 200);
1537: x_msg_count := 1;
1538:
1539: END insert_wms_zones;

Line 1617: x_return_status := fnd_api.g_ret_sts_success;

1613: l_msg_count NUMBER;
1614:
1615: BEGIN
1616:
1617: x_return_status := fnd_api.g_ret_sts_success;
1618:
1619: DEBUG('In procedure :', l_module_name,0);
1620:
1621: IF (l_debug = 1) THEN

Line 1713: x_return_status := fnd_api.g_ret_sts_success;

1709: );
1710:
1711: END IF;
1712:
1713: x_return_status := fnd_api.g_ret_sts_success;
1714:
1715: DEBUG('Call Success', l_module_name,0);
1716:
1717: EXCEPTION

Line 1724: x_return_status := fnd_api.g_ret_sts_error;

1720: DEBUG('No data found Exception :' ||l_progress_indicator
1721: ||' : '||SQLERRM ,
1722: l_module_name,0);
1723:
1724: x_return_status := fnd_api.g_ret_sts_error;
1725: x_msg_data := substrb(SQLERRM, 200);
1726: x_msg_count := 1;
1727:
1728: WHEN OTHERS THEN

Line 1733: x_return_status := fnd_api.g_ret_sts_unexp_error;

1729: DEBUG('Unexpected Exception :' ||l_progress_indicator
1730: ||' : '||SQLERRM ,
1731: l_module_name,0);
1732:
1733: x_return_status := fnd_api.g_ret_sts_unexp_error;
1734: x_msg_data := substrb(SQLERRM, 200);
1735: x_msg_count := 1;
1736:
1737: END update_wms_zones;

Line 2060: x_return_status := FND_API.G_RET_STS_SUCCESS;

2056: RAISE record_changed;
2057:
2058: END IF;
2059:
2060: x_return_status := FND_API.G_RET_STS_SUCCESS;
2061: fnd_msg_pub.count_and_get(
2062: p_count => x_msg_count,
2063: p_data => x_msg_data
2064: );

Line 2068: x_return_status := fnd_api.g_ret_sts_error;

2064: );
2065:
2066: EXCEPTION
2067: WHEN NO_DATA_FOUND THEN
2068: x_return_status := fnd_api.g_ret_sts_error;
2069:
2070: fnd_message.set_name('INV','OE_LOCK_ROW_DELETED');
2071: fnd_msg_pub.add;
2072:

Line 2079: x_return_status := fnd_api.g_ret_sts_error;

2075: p_data => x_msg_data
2076: );
2077:
2078: WHEN app_exceptions.record_lock_exception THEN
2079: x_return_status := fnd_api.g_ret_sts_error;
2080:
2081: fnd_message.set_name('INV','OE_LOCK_ROW_ALREADY_LOCKED');
2082: fnd_msg_pub.add;
2083:

Line 2091: x_return_status := fnd_api.g_ret_sts_error;

2087: );
2088:
2089:
2090: WHEN record_changed THEN
2091: x_return_status := fnd_api.g_ret_sts_error;
2092:
2093: fnd_message.set_name('INV','OE_LOCK_ROW_CHANGED');
2094: fnd_msg_pub.add;
2095:

Line 2103: x_return_status := fnd_api.g_ret_sts_unexp_error;

2099: );
2100:
2101:
2102: WHEN OTHERS THEN
2103: x_return_status := fnd_api.g_ret_sts_unexp_error;
2104:
2105: x_msg_data := substrb(sqlerrm, 200);
2106: x_msg_count := 1;
2107:

Line 2566: x_return_status := fnd_api.g_ret_sts_success;

2562: IF l_debug > 0 THEN
2563: DEBUG('Records inserted :'||SQL%ROWCOUNT, l_module_name,0);
2564: END IF;
2565:
2566: x_return_status := fnd_api.g_ret_sts_success;
2567:
2568: DEBUG('Call Success', l_module_name,0);
2569:
2570: EXCEPTION

Line 2577: x_return_status := fnd_api.g_ret_sts_unexp_error;

2573: DEBUG('Unexpected Exception :' ||l_progress_indicator
2574: ||' : '||SQLERRM ,
2575: l_module_name,0);
2576:
2577: x_return_status := fnd_api.g_ret_sts_unexp_error;
2578: x_msg_data := substrb(SQLERRM, 200);
2579: x_msg_count := 1;
2580:
2581: END add_locators;

Line 2666: l_return_status := fnd_api.g_ret_sts_error;

2662: NULL;
2663:
2664: ELSE
2665:
2666: l_return_status := fnd_api.g_ret_sts_error;
2667:
2668: END IF;
2669:
2670: l_progress_indicator := '20';

Line 2678: l_return_status := fnd_api.g_ret_sts_error;

2674: * MUST be NULL
2675: */
2676: IF p_entire_sub_flag = 'Y' AND p_locator_id IS NOT NULL THEN
2677:
2678: l_return_status := fnd_api.g_ret_sts_error;
2679:
2680: END IF;
2681:
2682: l_progress_indicator := '30';

Line 2690: l_return_status := fnd_api.g_ret_sts_error;

2686: */
2687: OPEN c_org_id;
2688: FETCH c_org_id INTO l_id;
2689: IF c_org_id%NOTFOUND THEN
2690: l_return_status := fnd_api.g_ret_sts_error;
2691: END IF;
2692: CLOSE c_org_id;
2693:
2694: l_progress_indicator := '40';

Line 2702: l_return_status := fnd_api.g_ret_sts_error;

2698: */
2699: OPEN c_zone_id;
2700: FETCH c_zone_id INTO l_id;
2701: IF c_zone_id%NOTFOUND THEN
2702: l_return_status := fnd_api.g_ret_sts_error;
2703: END IF;
2704: CLOSE c_zone_id;
2705:
2706: l_progress_indicator := '50';

Line 2715: l_return_status := fnd_api.g_ret_sts_error;

2711: */
2712: OPEN c_subinventory_code;
2713: FETCH c_subinventory_code INTO l_id;
2714: IF c_subinventory_code%NOTFOUND THEN
2715: l_return_status := fnd_api.g_ret_sts_error;
2716: END IF;
2717: CLOSE c_subinventory_code;
2718:
2719: l_progress_indicator := '60';

Line 2734: l_return_status := fnd_api.g_ret_sts_error;

2730:
2731: OPEN c_locator_id;
2732: FETCH c_locator_id INTO l_id;
2733: IF c_locator_id%NOTFOUND THEN
2734: l_return_status := fnd_api.g_ret_sts_error;
2735: END IF;
2736: CLOSE c_locator_id;
2737:
2738: END IF;

Line 2754: x_return_status := fnd_api.g_ret_sts_unexp_error;

2750: DEBUG('Unexpected Exception :' ||l_progress_indicator
2751: ||' : '||SQLERRM ,
2752: l_module_name,0);
2753:
2754: x_return_status := fnd_api.g_ret_sts_unexp_error;
2755: x_msg_data := substrb(SQLERRM, 200);
2756: x_msg_count := 1;
2757:
2758: END validate_locators;

Line 2803: x_return_status := fnd_api.g_ret_sts_success;

2799: IF l_debug > 0 THEN
2800: DEBUG('Deleted Rows : '||SQL%ROWCOUNT, l_module_name, 9);
2801: END IF;
2802:
2803: x_return_status := fnd_api.g_ret_sts_success;
2804:
2805: DEBUG('Call Success', l_module_name,0);
2806:
2807: EXCEPTION

Line 2814: x_return_status := fnd_api.g_ret_sts_unexp_error;

2810: DEBUG('Unexpected Exception :' ||l_progress_indicator
2811: ||' : '||SQLERRM ,
2812: l_module_name,0);
2813:
2814: x_return_status := fnd_api.g_ret_sts_unexp_error;
2815: x_msg_data := substrb(SQLERRM, 200);
2816: x_msg_count := 1;
2817:
2818: END delete_locators;