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 1404: x_return_status := fnd_api.g_ret_sts_success;

1400: l_rowid VARCHAR2(200);
1401:
1402: BEGIN
1403:
1404: x_return_status := fnd_api.g_ret_sts_success;
1405:
1406: DEBUG('In procedure :', l_module_name,0);
1407:
1408: IF (l_debug = 1) THEN

Line 1502: x_return_status := fnd_api.g_ret_sts_success;

1498: );
1499:
1500: END IF;
1501:
1502: x_return_status := fnd_api.g_ret_sts_success;
1503:
1504: DEBUG('Call Success', l_module_name,0);
1505:
1506: EXCEPTION

Line 1513: x_return_status := fnd_api.g_ret_sts_unexp_error;

1509: DEBUG('Unexpected Exception :' ||l_progress_indicator
1510: ||' : '||SQLERRM ,
1511: l_module_name,0);
1512:
1513: x_return_status := fnd_api.g_ret_sts_unexp_error;
1514: x_msg_data := substr(SQLERRM, 200);
1515: x_msg_count := 1;
1516:
1517: END insert_wms_zones;

Line 1594: x_return_status := fnd_api.g_ret_sts_success;

1590: l_msg_count NUMBER;
1591:
1592: BEGIN
1593:
1594: x_return_status := fnd_api.g_ret_sts_success;
1595:
1596: DEBUG('In procedure :', l_module_name,0);
1597:
1598: IF (l_debug = 1) THEN

Line 1689: x_return_status := fnd_api.g_ret_sts_success;

1685: );
1686:
1687: END IF;
1688:
1689: x_return_status := fnd_api.g_ret_sts_success;
1690:
1691: DEBUG('Call Success', l_module_name,0);
1692:
1693: EXCEPTION

Line 1700: x_return_status := fnd_api.g_ret_sts_error;

1696: DEBUG('No data found Exception :' ||l_progress_indicator
1697: ||' : '||SQLERRM ,
1698: l_module_name,0);
1699:
1700: x_return_status := fnd_api.g_ret_sts_error;
1701: x_msg_data := substrb(SQLERRM, 200);
1702: x_msg_count := 1;
1703:
1704: WHEN OTHERS THEN

Line 1709: x_return_status := fnd_api.g_ret_sts_unexp_error;

1705: DEBUG('Unexpected Exception :' ||l_progress_indicator
1706: ||' : '||SQLERRM ,
1707: l_module_name,0);
1708:
1709: x_return_status := fnd_api.g_ret_sts_unexp_error;
1710: x_msg_data := substrb(SQLERRM, 200);
1711: x_msg_count := 1;
1712:
1713: END update_wms_zones;

Line 2033: x_return_status := FND_API.G_RET_STS_SUCCESS;

2029: RAISE record_changed;
2030:
2031: END IF;
2032:
2033: x_return_status := FND_API.G_RET_STS_SUCCESS;
2034: fnd_msg_pub.count_and_get(
2035: p_count => x_msg_count,
2036: p_data => x_msg_data
2037: );

Line 2041: x_return_status := fnd_api.g_ret_sts_error;

2037: );
2038:
2039: EXCEPTION
2040: WHEN NO_DATA_FOUND THEN
2041: x_return_status := fnd_api.g_ret_sts_error;
2042:
2043: fnd_message.set_name('INV','OE_LOCK_ROW_DELETED');
2044: fnd_msg_pub.add;
2045:

Line 2052: x_return_status := fnd_api.g_ret_sts_error;

2048: p_data => x_msg_data
2049: );
2050:
2051: WHEN app_exceptions.record_lock_exception THEN
2052: x_return_status := fnd_api.g_ret_sts_error;
2053:
2054: fnd_message.set_name('INV','OE_LOCK_ROW_ALREADY_LOCKED');
2055: fnd_msg_pub.add;
2056:

Line 2064: x_return_status := fnd_api.g_ret_sts_error;

2060: );
2061:
2062:
2063: WHEN record_changed THEN
2064: x_return_status := fnd_api.g_ret_sts_error;
2065:
2066: fnd_message.set_name('INV','OE_LOCK_ROW_CHANGED');
2067: fnd_msg_pub.add;
2068:

Line 2076: x_return_status := fnd_api.g_ret_sts_unexp_error;

2072: );
2073:
2074:
2075: WHEN OTHERS THEN
2076: x_return_status := fnd_api.g_ret_sts_unexp_error;
2077:
2078: x_msg_data := substrb(sqlerrm, 200);
2079: x_msg_count := 1;
2080:

Line 2539: x_return_status := fnd_api.g_ret_sts_success;

2535: IF l_debug > 0 THEN
2536: DEBUG('Records inserted :'||SQL%ROWCOUNT, l_module_name,0);
2537: END IF;
2538:
2539: x_return_status := fnd_api.g_ret_sts_success;
2540:
2541: DEBUG('Call Success', l_module_name,0);
2542:
2543: EXCEPTION

Line 2550: x_return_status := fnd_api.g_ret_sts_unexp_error;

2546: DEBUG('Unexpected Exception :' ||l_progress_indicator
2547: ||' : '||SQLERRM ,
2548: l_module_name,0);
2549:
2550: x_return_status := fnd_api.g_ret_sts_unexp_error;
2551: x_msg_data := substrb(SQLERRM, 200);
2552: x_msg_count := 1;
2553:
2554: END add_locators;

Line 2639: l_return_status := fnd_api.g_ret_sts_error;

2635: NULL;
2636:
2637: ELSE
2638:
2639: l_return_status := fnd_api.g_ret_sts_error;
2640:
2641: END IF;
2642:
2643: l_progress_indicator := '20';

Line 2651: l_return_status := fnd_api.g_ret_sts_error;

2647: * MUST be NULL
2648: */
2649: IF p_entire_sub_flag = 'Y' AND p_locator_id IS NOT NULL THEN
2650:
2651: l_return_status := fnd_api.g_ret_sts_error;
2652:
2653: END IF;
2654:
2655: l_progress_indicator := '30';

Line 2663: l_return_status := fnd_api.g_ret_sts_error;

2659: */
2660: OPEN c_org_id;
2661: FETCH c_org_id INTO l_id;
2662: IF c_org_id%NOTFOUND THEN
2663: l_return_status := fnd_api.g_ret_sts_error;
2664: END IF;
2665: CLOSE c_org_id;
2666:
2667: l_progress_indicator := '40';

Line 2675: l_return_status := fnd_api.g_ret_sts_error;

2671: */
2672: OPEN c_zone_id;
2673: FETCH c_zone_id INTO l_id;
2674: IF c_zone_id%NOTFOUND THEN
2675: l_return_status := fnd_api.g_ret_sts_error;
2676: END IF;
2677: CLOSE c_zone_id;
2678:
2679: l_progress_indicator := '50';

Line 2688: l_return_status := fnd_api.g_ret_sts_error;

2684: */
2685: OPEN c_subinventory_code;
2686: FETCH c_subinventory_code INTO l_id;
2687: IF c_subinventory_code%NOTFOUND THEN
2688: l_return_status := fnd_api.g_ret_sts_error;
2689: END IF;
2690: CLOSE c_subinventory_code;
2691:
2692: l_progress_indicator := '60';

Line 2707: l_return_status := fnd_api.g_ret_sts_error;

2703:
2704: OPEN c_locator_id;
2705: FETCH c_locator_id INTO l_id;
2706: IF c_locator_id%NOTFOUND THEN
2707: l_return_status := fnd_api.g_ret_sts_error;
2708: END IF;
2709: CLOSE c_locator_id;
2710:
2711: END IF;

Line 2727: x_return_status := fnd_api.g_ret_sts_unexp_error;

2723: DEBUG('Unexpected Exception :' ||l_progress_indicator
2724: ||' : '||SQLERRM ,
2725: l_module_name,0);
2726:
2727: x_return_status := fnd_api.g_ret_sts_unexp_error;
2728: x_msg_data := substrb(SQLERRM, 200);
2729: x_msg_count := 1;
2730:
2731: END validate_locators;

Line 2776: x_return_status := fnd_api.g_ret_sts_success;

2772: IF l_debug > 0 THEN
2773: DEBUG('Deleted Rows : '||SQL%ROWCOUNT, l_module_name, 9);
2774: END IF;
2775:
2776: x_return_status := fnd_api.g_ret_sts_success;
2777:
2778: DEBUG('Call Success', l_module_name,0);
2779:
2780: EXCEPTION

Line 2787: x_return_status := fnd_api.g_ret_sts_unexp_error;

2783: DEBUG('Unexpected Exception :' ||l_progress_indicator
2784: ||' : '||SQLERRM ,
2785: l_module_name,0);
2786:
2787: x_return_status := fnd_api.g_ret_sts_unexp_error;
2788: x_msg_data := substrb(SQLERRM, 200);
2789: x_msg_count := 1;
2790:
2791: END delete_locators;