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 1424: l_return_status := FND_API.G_RET_STS_SUCCESS;

1420: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1421:
1422: BEGIN
1423:
1424: l_return_status := FND_API.G_RET_STS_SUCCESS;
1425:
1426: SELECT inventory_item_id
1427: INTO l_item_id
1428: FROM wip_lpn_completions

Line 1593: x_return_status := FND_API.G_RET_STS_ERROR;

1589:
1590: x_return_status := l_return_status;
1591: EXCEPTION
1592: WHEN OTHERS THEN
1593: x_return_status := FND_API.G_RET_STS_ERROR;
1594:
1595: IF (l_debug = 1) THEN
1596: mydebug('Update_serial: Unexpected error: ' || sqlcode || ' :: ' || sqlerrm);
1597: END IF;

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

1611: l_item_id NUMBER;
1612: l_org_id NUMBER;
1613: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
1614: l_lot_number VARCHAR2(80);
1615: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
1616: l_msg_count NUMBER;
1617: l_msg_data VARCHAR2(2000);
1618: l_object_id NUMBER;
1619: l_status_rec inv_material_status_pub.mtl_status_update_rec_type; --bug4073725

Line 1625: l_return_status := FND_API.G_RET_STS_SUCCESS;

1621:
1622: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1623: BEGIN
1624:
1625: l_return_status := FND_API.G_RET_STS_SUCCESS;
1626:
1627: l_lot_number := p_lot_number;
1628:
1629: SELECT inventory_item_id,organization_id

Line 1642: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1638: x_return_status => l_return_status,
1639: x_msg_count => l_msg_count,
1640: x_msg_data => l_msg_data);
1641:
1642: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1643:
1644: -- Lot number does not exist
1645: select mtl_gen_object_id_s.nextval into l_object_id from dual;
1646:

Line 1831: l_return_status := FND_API.G_RET_STS_SUCCESS;

1827: WHERE header_id = p_header_id
1828: AND lot_number = p_lot_number
1829: );
1830:
1831: l_return_status := FND_API.G_RET_STS_SUCCESS;
1832: END IF;
1833: /* bug4073725 changes start */
1834: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1835: SELECT status_id

Line 1834: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1830:
1831: l_return_status := FND_API.G_RET_STS_SUCCESS;
1832: END IF;
1833: /* bug4073725 changes start */
1834: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1835: SELECT status_id
1836: INTO l_status_id
1837: FROM wip_lpn_completions_lots
1838: WHERE header_id = p_header_id

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

1870: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
1871: l_lot_number VARCHAR2(80);
1872: l_lotunique NUMBER;
1873: l_lot_control_code NUMBER;
1874: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
1875: l_shelf_life_code NUMBER;
1876: l_expiration_date DATE;
1877:
1878: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 1881: l_return_status := FND_API.G_RET_STS_SUCCESS;

1877:
1878: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1879: BEGIN
1880:
1881: l_return_status := FND_API.G_RET_STS_SUCCESS;
1882:
1883: l_item_id:=p_item_id;
1884: l_org_id:=p_org_id;
1885: l_lot_number:=p_lot_number;

Line 1899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1895:
1896: IF l_lot_control_code = 1 THEN
1897: fnd_message.set_name('INV','INV_NO_LOT_CONTROL');
1898: fnd_msg_pub.add;
1899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1900: END IF;
1901:
1902: EXCEPTION
1903: WHEN NO_DATA_FOUND THEN

Line 1906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1902: EXCEPTION
1903: WHEN NO_DATA_FOUND THEN
1904: fnd_message.set_name('INV','INV_INVALID_ITEM');
1905: fnd_msg_pub.add;
1906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1907: END;
1908:
1909:
1910: SELECT lot_number_uniqueness

Line 1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1926:
1927: IF l_count > 0 then
1928: fnd_message.set_name('INV','INV_INT_LOTUNIQEXP');
1929: fnd_msg_pub.add;
1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1931: END IF;
1932: END IF;
1933:
1934: l_count := 0;

Line 1961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1957:
1958: IF l_shelf_life_code = 4 AND l_expiration_date < SYSDATE THEN
1959: fnd_message.set_name('INV','INV_LOT_EXPREQD');
1960: fnd_msg_pub.add;
1961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1962:
1963: ELSE
1964: l_return_status := FND_API.G_RET_STS_SUCCESS;
1965: END IF;

Line 1964: l_return_status := FND_API.G_RET_STS_SUCCESS;

1960: fnd_msg_pub.add;
1961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1962:
1963: ELSE
1964: l_return_status := FND_API.G_RET_STS_SUCCESS;
1965: END IF;
1966:
1967: ELSE
1968: l_return_status:=FND_API.G_RET_STS_ERROR;

Line 1968: l_return_status:=FND_API.G_RET_STS_ERROR;

1964: l_return_status := FND_API.G_RET_STS_SUCCESS;
1965: END IF;
1966:
1967: ELSE
1968: l_return_status:=FND_API.G_RET_STS_ERROR;
1969: END IF;
1970:
1971: x_return_status := l_return_status;
1972:

Line 1975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1971: x_return_status := l_return_status;
1972:
1973: EXCEPTION
1974:
1975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1976: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1977: fnd_msg_pub.count_and_get
1978: ( p_count => x_msg_count
1979: , p_data => x_msg_data

Line 1976: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

1972:
1973: EXCEPTION
1974:
1975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1976: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1977: fnd_msg_pub.count_and_get
1978: ( p_count => x_msg_count
1979: , p_data => x_msg_data
1980: );

Line 1983: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

1979: , p_data => x_msg_data
1980: );
1981:
1982: WHEN OTHERS THEN
1983: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1984: fnd_msg_pub.count_and_get
1985: ( p_count => x_msg_count
1986: , p_data => x_msg_data
1987: );

Line 2020: x_return_status :=FND_API.g_ret_sts_success;

2016: IF (l_debug = 1) THEN
2017: mydebug('post_completion: procedure post_completion begins');
2018: END IF;
2019:
2020: x_return_status :=FND_API.g_ret_sts_success;
2021: l_quantity := p_quantity;
2022:
2023: /* Call this API to parse the serial numbers into prefixes and numbers */
2024: IF (NOT MTL_Serial_Check.inv_serial_info

Line 2038: RAISE FND_API.G_EXC_ERROR;

2034: mydebug('post_completion: Invalid serial number given in range');
2035: END IF;
2036: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_SER');
2037: FND_MSG_PUB.ADD;
2038: RAISE FND_API.G_EXC_ERROR;
2039: END IF;
2040:
2041: -- Check that in the case of a range of serial numbers, that the
2042: -- inputted p_quantity equals the amount of items in the serial range.

Line 2050: RAISE FND_API.G_EXC_ERROR;

2046: mydebug('post_completion: Range of serial numbers does not match given qty');
2047: END IF;
2048: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_X_QTY');
2049: FND_MSG_PUB.ADD;
2050: RAISE FND_API.G_EXC_ERROR;
2051: END IF;
2052: END IF;
2053:
2054: l_length := length(p_fm_serial_number);

Line 2084: x_return_status := FND_API.g_ret_sts_success;

2080: IF (l_debug = 1) THEN
2081: mydebug('post_completion: procedure post_completion ends');
2082: END IF;
2083:
2084: x_return_status := FND_API.g_ret_sts_success;
2085:
2086: EXCEPTION
2087:
2088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2084: x_return_status := FND_API.g_ret_sts_success;
2085:
2086: EXCEPTION
2087:
2088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2089: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2090: fnd_msg_pub.count_and_get
2091: ( p_count => x_msg_count
2092: , p_data => x_msg_data

Line 2089: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2085:
2086: EXCEPTION
2087:
2088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2089: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2090: fnd_msg_pub.count_and_get
2091: ( p_count => x_msg_count
2092: , p_data => x_msg_data
2093: );

Line 2096: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2092: , p_data => x_msg_data
2093: );
2094:
2095: WHEN OTHERS THEN
2096: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2097: fnd_msg_pub.count_and_get
2098: ( p_count => x_msg_count
2099: , p_data => x_msg_data
2100: );

Line 2128: x_return_status :=FND_API.g_ret_sts_success;

2124:
2125: IF (l_debug = 1) THEN
2126: mydebug('get_wip_job_info: get_wip_job_info begins');
2127: END IF;
2128: x_return_status :=FND_API.g_ret_sts_success;
2129:
2130: IF p_wip_entity_type IN (1,5,6) THEN --Included 6 also for eAM-WMS Enhancement (Bug# 4093921)
2131:
2132: -- Discrete job or lot based job

Line 2273: x_return_status := FND_API.g_ret_sts_success;

2269:
2270: IF (l_debug = 1) THEN
2271: mydebug('get_wip_job_info: Get_wip_job_info ends');
2272: END IF;
2273: x_return_status := FND_API.g_ret_sts_success;
2274:
2275: EXCEPTION
2276:
2277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2273: x_return_status := FND_API.g_ret_sts_success;
2274:
2275: EXCEPTION
2276:
2277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2278: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2279: fnd_msg_pub.count_and_get
2280: ( p_count => x_msg_count
2281: , p_data => x_msg_data

Line 2278: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2274:
2275: EXCEPTION
2276:
2277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2278: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2279: fnd_msg_pub.count_and_get
2280: ( p_count => x_msg_count
2281: , p_data => x_msg_data
2282: );

Line 2285: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2281: , p_data => x_msg_data
2282: );
2283:
2284: WHEN OTHERS THEN
2285: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2286: fnd_msg_pub.count_and_get
2287: ( p_count => x_msg_count
2288: , p_data => x_msg_data
2289: );

Line 2323: x_return_status :=FND_API.g_ret_sts_success;

2319:
2320: IF (l_debug = 1) THEN
2321: mydebug('get_wip_info_for_putaway: get_wip_info_for_putaway begins');
2322: END IF;
2323: x_return_status :=FND_API.g_ret_sts_success;
2324:
2325: x_wip_entity_type :=NULL;
2326: x_job :=NULL;
2327: x_line :=NULL;

Line 2492: x_return_status := FND_API.g_ret_sts_success;

2488:
2489: IF (l_debug = 1) THEN
2490: mydebug('get_wip_info_for_putaway: Get_wip_info_for_putaway ends');
2491: END IF;
2492: x_return_status := FND_API.g_ret_sts_success;
2493:
2494: EXCEPTION
2495:
2496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2492: x_return_status := FND_API.g_ret_sts_success;
2493:
2494: EXCEPTION
2495:
2496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2497:
2498: IF (l_debug = 1) THEN
2499: mydebug('get_wip_info_for_putaway: unexpected error: ' || Sqlerrm);
2500: END IF;

Line 2501: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2497:
2498: IF (l_debug = 1) THEN
2499: mydebug('get_wip_info_for_putaway: unexpected error: ' || Sqlerrm);
2500: END IF;
2501: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2502: fnd_msg_pub.count_and_get
2503: ( p_count => x_msg_count
2504: , p_data => x_msg_data
2505: );

Line 2511: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2507: WHEN OTHERS THEN
2508: IF (l_debug = 1) THEN
2509: mydebug('get_wip_info_for_putaway: unexpected error: ' || Sqlerrm);
2510: END IF;
2511: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2512: fnd_msg_pub.count_and_get
2513: ( p_count => x_msg_count
2514: , p_data => x_msg_data
2515: );

Line 2539: l_return_status := FND_API.G_RET_STS_SUCCESS;

2535:
2536: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2537: BEGIN
2538:
2539: l_return_status := FND_API.G_RET_STS_SUCCESS;
2540:
2541: IF (l_debug = 1) THEN
2542: mydebug('wip_picking_pub.unallocate_material ends');
2543: END IF;

Line 2561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2557: x_msg_data := l_msg_data;
2558:
2559: EXCEPTION
2560:
2561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2562: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2563: fnd_msg_pub.count_and_get
2564: ( p_count => l_msg_count
2565: , p_data => l_msg_data

Line 2562: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2558:
2559: EXCEPTION
2560:
2561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2562: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2563: fnd_msg_pub.count_and_get
2564: ( p_count => l_msg_count
2565: , p_data => l_msg_data
2566: );

Line 2569: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2565: , p_data => l_msg_data
2566: );
2567:
2568: WHEN OTHERS THEN
2569: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2570: fnd_msg_pub.count_and_get
2571: ( p_count => l_msg_count
2572: , p_data => l_msg_data
2573: );

Line 2703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2699: END IF;
2700:
2701: EXCEPTION
2702:
2703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2704: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2705: fnd_msg_pub.count_and_get
2706: ( p_count => x_msg_count
2707: , p_data => x_err_msg

Line 2704: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2700:
2701: EXCEPTION
2702:
2703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2704: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2705: fnd_msg_pub.count_and_get
2706: ( p_count => x_msg_count
2707: , p_data => x_err_msg
2708: );

Line 2715: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2711: mydebug('transfer_reservation: G_EXC_UNEXPECTED_ERROR ' || sqlerrm);
2712: END IF;
2713:
2714: WHEN OTHERS THEN
2715: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2716: fnd_msg_pub.count_and_get
2717: ( p_count => x_msg_count
2718: , p_data => x_err_msg
2719: );

Line 2781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2777: p_transaction_type_id <> INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR) THEN
2778: IF (l_debug = 1) THEN
2779: mydebug ('update_mmtt_for_wip:'||'Invalid transaction type: ' || to_char(p_transaction_type_id));
2780: END IF;
2781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2782: END IF;
2783:
2784: BEGIN
2785: /* Bug6604904. Modified query to get project and task info from MTRL */

Line 2825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2821: IF (l_debug = 1) THEN
2822: mydebug ('update_mmtt_for_wip:'||
2823: 'Parameter p_repetitive_schedule_id cannot be null for entity type 2.');
2824: END IF;
2825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2826: ELSE
2827: BEGIN
2828: SELECT line_id
2829: INTO l_repetitive_line_id

Line 2894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2890: ELSE
2891: IF (l_debug = 1) THEN
2892: mydebug ('update_mmtt_for_wip:'||'Invalid entity type: ' || to_char(l_entity_type));
2893: END IF;
2894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2895: END IF;
2896: EXCEPTION
2897: WHEN NO_DATA_FOUND THEN
2898: -- Bug 2023916:

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

2988: mydebug('Txn Header ID : '|| p_txn_hdr_id );
2989: mydebug('business flow code : '|| p_business_flow_code);
2990: END IF;
2991:
2992: wip_mtlTempProc_grp.processtemp(p_initMsgList => FND_API.g_true,
2993: p_processInv => FND_API.g_true, --whether call inventory TM OR not
2994: p_txnHdrID => p_txn_hdr_id,
2995: p_mtlTxnBusinessFlowCode => p_business_flow_code,
2996: x_returnStatus => x_return_status,

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

2989: mydebug('business flow code : '|| p_business_flow_code);
2990: END IF;
2991:
2992: wip_mtlTempProc_grp.processtemp(p_initMsgList => FND_API.g_true,
2993: p_processInv => FND_API.g_true, --whether call inventory TM OR not
2994: p_txnHdrID => p_txn_hdr_id,
2995: p_mtlTxnBusinessFlowCode => p_business_flow_code,
2996: x_returnStatus => x_return_status,
2997: x_errorMsg => l_errorMsg);

Line 3005: WHEN FND_API.G_EXC_ERROR THEN

3001: END IF;
3002:
3003: EXCEPTION
3004:
3005: WHEN FND_API.G_EXC_ERROR THEN
3006: x_return_status:=FND_API.G_RET_STS_ERROR;
3007:
3008: FND_MSG_PUB.ADD;
3009: IF (l_debug = 1) THEN

Line 3006: x_return_status:=FND_API.G_RET_STS_ERROR;

3002:
3003: EXCEPTION
3004:
3005: WHEN FND_API.G_EXC_ERROR THEN
3006: x_return_status:=FND_API.G_RET_STS_ERROR;
3007:
3008: FND_MSG_PUB.ADD;
3009: IF (l_debug = 1) THEN
3010: mydebug('wip_processor: Error: ' || sqlerrm);

Line 3014: x_return_status := FND_API.g_ret_sts_error;

3010: mydebug('wip_processor: Error: ' || sqlerrm);
3011: END IF;
3012:
3013: WHEN OTHERS THEN
3014: x_return_status := FND_API.g_ret_sts_error;
3015:
3016: FND_MSG_PUB.ADD;
3017: IF (l_debug = 1) THEN
3018: mydebug('wip_processor: Other Error: ' || sqlerrm);