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

Line 21: l_return_status:= FND_API.G_RET_STS_SUCCESS;

17: l_return_status VARCHAR2(1);
18:
19: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
20: BEGIN
21: l_return_status:= FND_API.G_RET_STS_SUCCESS;
22:
23: UPDATE mtl_txn_request_lines
24: SET wms_process_flag = p_wms_process_flag
25: WHERE lpn_id = p_lpn_id;

Line 32: x_return_status:=FND_API.G_RET_STS_ERROR;

28:
29: EXCEPTION
30:
31: WHEN no_data_found THEN
32: x_return_status:=FND_API.G_RET_STS_ERROR;
33: fnd_msg_pub.count_and_get
34: ( p_count => x_msg_count
35: , p_data => x_msg_data
36: );

Line 98: l_return_status:= FND_API.G_RET_STS_SUCCESS;

94: FROM wip_lpn_completions_lots
95: WHERE header_id = l_temp_header_id;
96: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
97: BEGIN
98: l_return_status:= FND_API.G_RET_STS_SUCCESS;
99: l_query_result := 0;
100: l_txn_ret:=0;
101:
102: BEGIN

Line 827: p_commit => fnd_api.g_false,

823:
824: -- Call the txn processor
825: l_txn_ret := inv_lpn_trx_pub.process_lpn_trx
826: (p_trx_hdr_id => l_next_transaction_header_id,
827: p_commit => fnd_api.g_false,
828: p_proc_mode => 1,
829: x_proc_msg => l_msg_data
830: );
831:

Line 841: l_return_status:=FND_API.G_RET_STS_ERROR;

837: IF l_txn_ret<>0 THEN
838: FND_MESSAGE.SET_NAME('WMS','WMS_TD_TXNMGR_ERROR' );
839: FND_MSG_PUB.ADD;
840:
841: l_return_status:=FND_API.G_RET_STS_ERROR;
842: fnd_msg_pub.count_and_get
843: ( p_count => x_msg_count
844: , p_data => x_msg_data
845: );

Line 848: l_return_status:= FND_API.G_RET_STS_SUCCESS;

844: , p_data => x_msg_data
845: );
846: ELSE
847:
848: l_return_status:= FND_API.G_RET_STS_SUCCESS;
849:
850: END IF;
851:
852: ELSE

Line 854: l_return_status:=FND_API.G_RET_STS_ERROR;

850: END IF;
851:
852: ELSE
853: -- No rows found in wip_lpn_completions
854: l_return_status:=FND_API.G_RET_STS_ERROR;
855: fnd_msg_pub.count_and_get
856: ( p_count => x_msg_count
857: , p_data => x_msg_data
858: );

Line 865: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

861: x_return_status:=l_return_status;
862:
863: EXCEPTION
864:
865: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
866: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
867: fnd_msg_pub.count_and_get
868: (p_count => x_msg_count
869: , p_data => x_msg_data

Line 866: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

862:
863: EXCEPTION
864:
865: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
866: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
867: fnd_msg_pub.count_and_get
868: (p_count => x_msg_count
869: , p_data => x_msg_data
870: );

Line 873: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

869: , p_data => x_msg_data
870: );
871:
872: WHEN OTHERS THEN
873: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
874: fnd_msg_pub.count_and_get
875: (p_count => x_msg_count
876: , p_data => x_msg_data
877: );

Line 1406: l_return_status := FND_API.G_RET_STS_SUCCESS;

1402: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1403:
1404: BEGIN
1405:
1406: l_return_status := FND_API.G_RET_STS_SUCCESS;
1407:
1408: SELECT inventory_item_id
1409: INTO l_item_id
1410: FROM wip_lpn_completions

Line 1575: x_return_status := FND_API.G_RET_STS_ERROR;

1571:
1572: x_return_status := l_return_status;
1573: EXCEPTION
1574: WHEN OTHERS THEN
1575: x_return_status := FND_API.G_RET_STS_ERROR;
1576:
1577: IF (l_debug = 1) THEN
1578: mydebug('Update_serial: Unexpected error: ' || sqlcode || ' :: ' || sqlerrm);
1579: END IF;

Line 1597: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

1593: l_item_id NUMBER;
1594: l_org_id NUMBER;
1595: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
1596: l_lot_number VARCHAR2(80);
1597: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
1598: l_msg_count NUMBER;
1599: l_msg_data VARCHAR2(2000);
1600: l_object_id NUMBER;
1601: l_status_rec inv_material_status_pub.mtl_status_update_rec_type; --bug4073725

Line 1607: l_return_status := FND_API.G_RET_STS_SUCCESS;

1603:
1604: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1605: BEGIN
1606:
1607: l_return_status := FND_API.G_RET_STS_SUCCESS;
1608:
1609: l_lot_number := p_lot_number;
1610:
1611: SELECT inventory_item_id,organization_id

Line 1624: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1620: x_return_status => l_return_status,
1621: x_msg_count => l_msg_count,
1622: x_msg_data => l_msg_data);
1623:
1624: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1625:
1626: -- Lot number does not exist
1627: select mtl_gen_object_id_s.nextval into l_object_id from dual;
1628:

Line 1801: l_return_status := FND_API.G_RET_STS_SUCCESS;

1797: WHERE header_id = p_header_id
1798: AND lot_number = p_lot_number
1799: );
1800:
1801: l_return_status := FND_API.G_RET_STS_SUCCESS;
1802: END IF;
1803: /* bug4073725 changes start */
1804: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1805: SELECT status_id

Line 1804: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1800:
1801: l_return_status := FND_API.G_RET_STS_SUCCESS;
1802: END IF;
1803: /* bug4073725 changes start */
1804: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1805: SELECT status_id
1806: INTO l_status_id
1807: FROM wip_lpn_completions_lots
1808: WHERE header_id = p_header_id

Line 1844: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

1840: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
1841: l_lot_number VARCHAR2(80);
1842: l_lotunique NUMBER;
1843: l_lot_control_code NUMBER;
1844: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
1845: l_shelf_life_code NUMBER;
1846: l_expiration_date DATE;
1847:
1848: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 1851: l_return_status := FND_API.G_RET_STS_SUCCESS;

1847:
1848: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1849: BEGIN
1850:
1851: l_return_status := FND_API.G_RET_STS_SUCCESS;
1852:
1853: l_item_id:=p_item_id;
1854: l_org_id:=p_org_id;
1855: l_lot_number:=p_lot_number;

Line 1869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1865:
1866: IF l_lot_control_code = 1 THEN
1867: fnd_message.set_name('INV','INV_NO_LOT_CONTROL');
1868: fnd_msg_pub.add;
1869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1870: END IF;
1871:
1872: EXCEPTION
1873: WHEN NO_DATA_FOUND THEN

Line 1876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1872: EXCEPTION
1873: WHEN NO_DATA_FOUND THEN
1874: fnd_message.set_name('INV','INV_INVALID_ITEM');
1875: fnd_msg_pub.add;
1876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1877: END;
1878:
1879:
1880: SELECT lot_number_uniqueness

Line 1900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1896:
1897: IF l_count > 0 then
1898: fnd_message.set_name('INV','INV_INT_LOTUNIQEXP');
1899: fnd_msg_pub.add;
1900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1901: END IF;
1902: END IF;
1903:
1904: l_count := 0;

Line 1931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1927:
1928: IF l_shelf_life_code = 4 AND l_expiration_date < SYSDATE THEN
1929: fnd_message.set_name('INV','INV_LOT_EXPREQD');
1930: fnd_msg_pub.add;
1931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1932:
1933: ELSE
1934: l_return_status := FND_API.G_RET_STS_SUCCESS;
1935: END IF;

Line 1934: l_return_status := FND_API.G_RET_STS_SUCCESS;

1930: fnd_msg_pub.add;
1931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1932:
1933: ELSE
1934: l_return_status := FND_API.G_RET_STS_SUCCESS;
1935: END IF;
1936:
1937: ELSE
1938: l_return_status:=FND_API.G_RET_STS_ERROR;

Line 1938: l_return_status:=FND_API.G_RET_STS_ERROR;

1934: l_return_status := FND_API.G_RET_STS_SUCCESS;
1935: END IF;
1936:
1937: ELSE
1938: l_return_status:=FND_API.G_RET_STS_ERROR;
1939: END IF;
1940:
1941: x_return_status := l_return_status;
1942:

Line 1945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1941: x_return_status := l_return_status;
1942:
1943: EXCEPTION
1944:
1945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1946: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1947: fnd_msg_pub.count_and_get
1948: ( p_count => x_msg_count
1949: , p_data => x_msg_data

Line 1946: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

1942:
1943: EXCEPTION
1944:
1945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1946: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1947: fnd_msg_pub.count_and_get
1948: ( p_count => x_msg_count
1949: , p_data => x_msg_data
1950: );

Line 1953: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

1949: , p_data => x_msg_data
1950: );
1951:
1952: WHEN OTHERS THEN
1953: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1954: fnd_msg_pub.count_and_get
1955: ( p_count => x_msg_count
1956: , p_data => x_msg_data
1957: );

Line 1990: x_return_status :=FND_API.g_ret_sts_success;

1986: IF (l_debug = 1) THEN
1987: mydebug('post_completion: procedure post_completion begins');
1988: END IF;
1989:
1990: x_return_status :=FND_API.g_ret_sts_success;
1991: l_quantity := p_quantity;
1992:
1993: /* Call this API to parse the serial numbers into prefixes and numbers */
1994: IF (NOT MTL_Serial_Check.inv_serial_info

Line 2008: RAISE FND_API.G_EXC_ERROR;

2004: mydebug('post_completion: Invalid serial number given in range');
2005: END IF;
2006: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_SER');
2007: FND_MSG_PUB.ADD;
2008: RAISE FND_API.G_EXC_ERROR;
2009: END IF;
2010:
2011: -- Check that in the case of a range of serial numbers, that the
2012: -- inputted p_quantity equals the amount of items in the serial range.

Line 2020: RAISE FND_API.G_EXC_ERROR;

2016: mydebug('post_completion: Range of serial numbers does not match given qty');
2017: END IF;
2018: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_X_QTY');
2019: FND_MSG_PUB.ADD;
2020: RAISE FND_API.G_EXC_ERROR;
2021: END IF;
2022: END IF;
2023:
2024: l_length := length(p_fm_serial_number);

Line 2054: x_return_status := FND_API.g_ret_sts_success;

2050: IF (l_debug = 1) THEN
2051: mydebug('post_completion: procedure post_completion ends');
2052: END IF;
2053:
2054: x_return_status := FND_API.g_ret_sts_success;
2055:
2056: EXCEPTION
2057:
2058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2054: x_return_status := FND_API.g_ret_sts_success;
2055:
2056: EXCEPTION
2057:
2058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2059: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2060: fnd_msg_pub.count_and_get
2061: ( p_count => x_msg_count
2062: , p_data => x_msg_data

Line 2059: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2055:
2056: EXCEPTION
2057:
2058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2059: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2060: fnd_msg_pub.count_and_get
2061: ( p_count => x_msg_count
2062: , p_data => x_msg_data
2063: );

Line 2066: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2062: , p_data => x_msg_data
2063: );
2064:
2065: WHEN OTHERS THEN
2066: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2067: fnd_msg_pub.count_and_get
2068: ( p_count => x_msg_count
2069: , p_data => x_msg_data
2070: );

Line 2098: x_return_status :=FND_API.g_ret_sts_success;

2094:
2095: IF (l_debug = 1) THEN
2096: mydebug('get_wip_job_info: get_wip_job_info begins');
2097: END IF;
2098: x_return_status :=FND_API.g_ret_sts_success;
2099:
2100: IF p_wip_entity_type IN (1,5,6) THEN --Included 6 also for eAM-WMS Enhancement (Bug# 4093921)
2101:
2102: -- Discrete job or lot based job

Line 2243: x_return_status := FND_API.g_ret_sts_success;

2239:
2240: IF (l_debug = 1) THEN
2241: mydebug('get_wip_job_info: Get_wip_job_info ends');
2242: END IF;
2243: x_return_status := FND_API.g_ret_sts_success;
2244:
2245: EXCEPTION
2246:
2247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2243: x_return_status := FND_API.g_ret_sts_success;
2244:
2245: EXCEPTION
2246:
2247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2248: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2249: fnd_msg_pub.count_and_get
2250: ( p_count => x_msg_count
2251: , p_data => x_msg_data

Line 2248: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2244:
2245: EXCEPTION
2246:
2247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2248: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2249: fnd_msg_pub.count_and_get
2250: ( p_count => x_msg_count
2251: , p_data => x_msg_data
2252: );

Line 2255: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2251: , p_data => x_msg_data
2252: );
2253:
2254: WHEN OTHERS THEN
2255: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2256: fnd_msg_pub.count_and_get
2257: ( p_count => x_msg_count
2258: , p_data => x_msg_data
2259: );

Line 2293: x_return_status :=FND_API.g_ret_sts_success;

2289:
2290: IF (l_debug = 1) THEN
2291: mydebug('get_wip_info_for_putaway: get_wip_info_for_putaway begins');
2292: END IF;
2293: x_return_status :=FND_API.g_ret_sts_success;
2294:
2295: x_wip_entity_type :=NULL;
2296: x_job :=NULL;
2297: x_line :=NULL;

Line 2462: x_return_status := FND_API.g_ret_sts_success;

2458:
2459: IF (l_debug = 1) THEN
2460: mydebug('get_wip_info_for_putaway: Get_wip_info_for_putaway ends');
2461: END IF;
2462: x_return_status := FND_API.g_ret_sts_success;
2463:
2464: EXCEPTION
2465:
2466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2462: x_return_status := FND_API.g_ret_sts_success;
2463:
2464: EXCEPTION
2465:
2466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2467:
2468: IF (l_debug = 1) THEN
2469: mydebug('get_wip_info_for_putaway: unexpected error: ' || Sqlerrm);
2470: END IF;

Line 2471: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2467:
2468: IF (l_debug = 1) THEN
2469: mydebug('get_wip_info_for_putaway: unexpected error: ' || Sqlerrm);
2470: END IF;
2471: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2472: fnd_msg_pub.count_and_get
2473: ( p_count => x_msg_count
2474: , p_data => x_msg_data
2475: );

Line 2481: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2477: WHEN OTHERS THEN
2478: IF (l_debug = 1) THEN
2479: mydebug('get_wip_info_for_putaway: unexpected error: ' || Sqlerrm);
2480: END IF;
2481: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2482: fnd_msg_pub.count_and_get
2483: ( p_count => x_msg_count
2484: , p_data => x_msg_data
2485: );

Line 2509: l_return_status := FND_API.G_RET_STS_SUCCESS;

2505:
2506: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2507: BEGIN
2508:
2509: l_return_status := FND_API.G_RET_STS_SUCCESS;
2510:
2511: IF (l_debug = 1) THEN
2512: mydebug('wip_picking_pub.unallocate_material ends');
2513: END IF;

Line 2531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2527: x_msg_data := l_msg_data;
2528:
2529: EXCEPTION
2530:
2531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2532: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2533: fnd_msg_pub.count_and_get
2534: ( p_count => l_msg_count
2535: , p_data => l_msg_data

Line 2532: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2528:
2529: EXCEPTION
2530:
2531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2532: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2533: fnd_msg_pub.count_and_get
2534: ( p_count => l_msg_count
2535: , p_data => l_msg_data
2536: );

Line 2539: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2535: , p_data => l_msg_data
2536: );
2537:
2538: WHEN OTHERS THEN
2539: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2540: fnd_msg_pub.count_and_get
2541: ( p_count => l_msg_count
2542: , p_data => l_msg_data
2543: );

Line 2673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2669: END IF;
2670:
2671: EXCEPTION
2672:
2673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2674: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2675: fnd_msg_pub.count_and_get
2676: ( p_count => x_msg_count
2677: , p_data => x_err_msg

Line 2674: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2670:
2671: EXCEPTION
2672:
2673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2674: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2675: fnd_msg_pub.count_and_get
2676: ( p_count => x_msg_count
2677: , p_data => x_err_msg
2678: );

Line 2685: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2681: mydebug('transfer_reservation: G_EXC_UNEXPECTED_ERROR ' || sqlerrm);
2682: END IF;
2683:
2684: WHEN OTHERS THEN
2685: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2686: fnd_msg_pub.count_and_get
2687: ( p_count => x_msg_count
2688: , p_data => x_err_msg
2689: );

Line 2751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2747: p_transaction_type_id <> INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR) THEN
2748: IF (l_debug = 1) THEN
2749: mydebug ('update_mmtt_for_wip:'||'Invalid transaction type: ' || to_char(p_transaction_type_id));
2750: END IF;
2751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2752: END IF;
2753:
2754: BEGIN
2755: /* Bug6604904. Modified query to get project and task info from MTRL */

Line 2795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2791: IF (l_debug = 1) THEN
2792: mydebug ('update_mmtt_for_wip:'||
2793: 'Parameter p_repetitive_schedule_id cannot be null for entity type 2.');
2794: END IF;
2795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2796: ELSE
2797: BEGIN
2798: SELECT line_id
2799: INTO l_repetitive_line_id

Line 2864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2860: ELSE
2861: IF (l_debug = 1) THEN
2862: mydebug ('update_mmtt_for_wip:'||'Invalid entity type: ' || to_char(l_entity_type));
2863: END IF;
2864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2865: END IF;
2866: EXCEPTION
2867: WHEN NO_DATA_FOUND THEN
2868: -- Bug 2023916:

Line 2962: wip_mtlTempProc_grp.processtemp(p_initMsgList => FND_API.g_true,

2958: mydebug('Txn Header ID : '|| p_txn_hdr_id );
2959: mydebug('business flow code : '|| p_business_flow_code);
2960: END IF;
2961:
2962: wip_mtlTempProc_grp.processtemp(p_initMsgList => FND_API.g_true,
2963: p_processInv => FND_API.g_true, --whether call inventory TM OR not
2964: p_txnHdrID => p_txn_hdr_id,
2965: p_mtlTxnBusinessFlowCode => p_business_flow_code,
2966: x_returnStatus => x_return_status,

Line 2963: p_processInv => FND_API.g_true, --whether call inventory TM OR not

2959: mydebug('business flow code : '|| p_business_flow_code);
2960: END IF;
2961:
2962: wip_mtlTempProc_grp.processtemp(p_initMsgList => FND_API.g_true,
2963: p_processInv => FND_API.g_true, --whether call inventory TM OR not
2964: p_txnHdrID => p_txn_hdr_id,
2965: p_mtlTxnBusinessFlowCode => p_business_flow_code,
2966: x_returnStatus => x_return_status,
2967: x_errorMsg => l_errorMsg);

Line 2975: WHEN FND_API.G_EXC_ERROR THEN

2971: END IF;
2972:
2973: EXCEPTION
2974:
2975: WHEN FND_API.G_EXC_ERROR THEN
2976: x_return_status:=FND_API.G_RET_STS_ERROR;
2977:
2978: FND_MSG_PUB.ADD;
2979: IF (l_debug = 1) THEN

Line 2976: x_return_status:=FND_API.G_RET_STS_ERROR;

2972:
2973: EXCEPTION
2974:
2975: WHEN FND_API.G_EXC_ERROR THEN
2976: x_return_status:=FND_API.G_RET_STS_ERROR;
2977:
2978: FND_MSG_PUB.ADD;
2979: IF (l_debug = 1) THEN
2980: mydebug('wip_processor: Error: ' || sqlerrm);

Line 2984: x_return_status := FND_API.g_ret_sts_error;

2980: mydebug('wip_processor: Error: ' || sqlerrm);
2981: END IF;
2982:
2983: WHEN OTHERS THEN
2984: x_return_status := FND_API.g_ret_sts_error;
2985:
2986: FND_MSG_PUB.ADD;
2987: IF (l_debug = 1) THEN
2988: mydebug('wip_processor: Other Error: ' || sqlerrm);