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

Line 224: x_return_status := fnd_api.g_ret_sts_success;

220: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
221: END IF;
222: -- end of debugging section
223: --
224: x_return_status := fnd_api.g_ret_sts_success;
225: -- get the request record
226: print_debug('in context ');
227: OPEN l_req_csr;
228: BEGIN

Line 254: RAISE fnd_api.g_exc_error;

250: fnd_message.set_token
251: ('LINE_ID',fnd_number.number_to_canonical(p_move_order_line_id));
252: fnd_msg_pub.ADD;
253: CLOSE l_req_csr;
254: RAISE fnd_api.g_exc_error;
255: END IF;
256: CLOSE l_req_csr;
257: print_debug('init request_context');
258: -- initialize x_request_context

Line 506: RAISE fnd_api.g_exc_unexpected_error;

502: inv_salesorder.get_salesorder_for_oeheader(x_request_context.txn_header_id);
503: IF x_request_context.txn_header_id IS NULL THEN
504: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_GET_MSO_HEADER');
505: FND_MSG_PUB.Add;
506: RAISE fnd_api.g_exc_unexpected_error;
507: END IF;
508: --
509: --bug 1248138
510: --not sure why this is happening, but it probably shouldn't be, so

Line 551: RAISE fnd_api.g_exc_unexpected_error;

547: inv_salesorder.get_salesorder_for_oeheader(x_request_context.txn_header_id);
548: IF x_request_context.txn_header_id IS NULL THEN
549: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_GET_MSO_HEADER');
550: FND_MSG_PUB.Add;
551: RAISE fnd_api.g_exc_unexpected_error;
552: END IF;
553: END IF;
554:
555: -- Bug 2027368

Line 762: WHEN fnd_api.g_exc_error THEN

758: END IF;
759: -- end of debugging section
760: --
761: EXCEPTION
762: WHEN fnd_api.g_exc_error THEN
763: --
764: -- debugging section
765: -- can be commented ut for final code
766: IF inv_pp_debug.is_debug_mode THEN

Line 775: x_return_status := fnd_api.g_ret_sts_error;

771: inv_pp_debug.send_last_error_message;
772: END IF;
773: -- end of debugging section
774: --
775: x_return_status := fnd_api.g_ret_sts_error;
776: IF l_req_csr%isopen THEN
777: CLOSE l_req_csr;
778: END IF;
779: /*IF l_context_csr%isopen THEN

Line 786: WHEN fnd_api.g_exc_unexpected_error THEN

782: IF l_ship_info_csr%isopen THEN
783: CLOSE l_ship_info_csr;
784: END IF;
785: --
786: WHEN fnd_api.g_exc_unexpected_error THEN
787: --
788: -- debugging section
789: -- can be commented ut for final code
790: IF inv_pp_debug.is_debug_mode THEN

Line 799: x_return_status := fnd_api.g_ret_sts_unexp_error;

795: inv_pp_debug.send_last_error_message;
796: END IF;
797: -- end of debugging section
798: --
799: x_return_status := fnd_api.g_ret_sts_unexp_error;
800: IF l_req_csr%isopen THEN
801: CLOSE l_req_csr;
802: END IF;
803: /*IF l_context_csr%isopen THEN

Line 823: x_return_status := fnd_api.g_ret_sts_unexp_error;

819: inv_pp_debug.send_last_error_message;
820: END IF;
821: -- end of debugging section
822: --
823: x_return_status := fnd_api.g_ret_sts_unexp_error;
824: IF l_req_csr%isopen THEN
825: CLOSE l_req_csr;
826: END IF;
827: /*IF l_context_csr%isopen THEN

Line 852: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

848: , x_remaining_quantity OUT NOCOPY NUMBER
849: , x_remaining_sec_qty OUT NOCOPY NUMBER
850: )
851: IS
852: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
853: l_api_name VARCHAR2(30) := 'compute_pick_detail_level';
854: l_remain_pri_qty NUMBER;
855: l_remain_sec_qty NUMBER;
856: l_pp_temp_qty NUMBER;

Line 945: AND p_reservations(l_index).serial_number <> fnd_api.g_miss_char THEN -- bug#10392328

941: END IF;
942: -- [ added the following code to support the allocation for serial reserved items ]
943: -- [ decide serial Number ]
944: IF p_reservations(l_index).serial_number IS NOT NULL
945: AND p_reservations(l_index).serial_number <> fnd_api.g_miss_char THEN -- bug#10392328
946: x_detail_level_tbl(l_index).serial_number := p_reservations(l_index).serial_number ;
947: x_detail_level_tbl(l_index).serial_resv_flag := 'Y' ;
948: ELSE
949: x_detail_level_tbl(l_index).serial_number := NULL;

Line 1105: when fnd_api.g_exc_error then

1101: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
1102: END IF;
1103: --
1104: EXCEPTION
1105: when fnd_api.g_exc_error then
1106: x_return_status := fnd_api.g_ret_sts_error ;
1107: --
1108: when fnd_api.g_exc_unexpected_error then
1109: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1106: x_return_status := fnd_api.g_ret_sts_error ;

1102: END IF;
1103: --
1104: EXCEPTION
1105: when fnd_api.g_exc_error then
1106: x_return_status := fnd_api.g_ret_sts_error ;
1107: --
1108: when fnd_api.g_exc_unexpected_error then
1109: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1110: --

Line 1108: when fnd_api.g_exc_unexpected_error then

1104: EXCEPTION
1105: when fnd_api.g_exc_error then
1106: x_return_status := fnd_api.g_ret_sts_error ;
1107: --
1108: when fnd_api.g_exc_unexpected_error then
1109: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1110: --
1111: when others then
1112: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1109: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1105: when fnd_api.g_exc_error then
1106: x_return_status := fnd_api.g_ret_sts_error ;
1107: --
1108: when fnd_api.g_exc_unexpected_error then
1109: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1110: --
1111: when others then
1112: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1113: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN

Line 1112: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1108: when fnd_api.g_exc_unexpected_error then
1109: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1110: --
1111: when others then
1112: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1113: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1114: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1115: end if;
1116: --

Line 1152: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

1148: x_request_context OUT NOCOPY g_request_context_rec_type,
1149: p_wave_simulation_mode IN VARCHAR2 DEFAULT 'N'
1150: )
1151: IS
1152: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1153: l_api_name VARCHAR2(30) := 'validate_and_init';
1154: BEGIN
1155: --
1156: IF inv_pp_debug.is_debug_mode THEN

Line 1165: RAISE fnd_api.g_exc_error;

1161: print_debug('in inv validate and init');
1162: IF p_request_line_id IS NULL THEN
1163: fnd_message.set_name('INV','INV_PP_TRX_REQ_LINE_ID_MISS');
1164: fnd_msg_pub.add;
1165: RAISE fnd_api.g_exc_error;
1166: END IF;
1167: --
1168: -- get request context
1169: print_debug('before context ');

Line 1176: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1172: x_request_context,
1173: x_request_line_rec,
1174: p_wave_simulation_mode
1175: );
1176: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1177: RAISE fnd_api.g_exc_error;
1178: END IF;
1179: --
1180: -- check whether quantity to detail is >0, if not, return

Line 1177: RAISE fnd_api.g_exc_error;

1173: x_request_line_rec,
1174: p_wave_simulation_mode
1175: );
1176: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1177: RAISE fnd_api.g_exc_error;
1178: END IF;
1179: --
1180: -- check whether quantity to detail is >0, if not, return
1181: IF x_request_line_rec.quantity IS NOT NULL

Line 1202: IF p_suggest_serial = fnd_api.g_true AND

1198: -- in the get_request_context procedure.
1199: --x_request_context.detail_any_serial :=
1200: -- to_number(fnd_profile.value('INV:DETAIL_SERIAL_NUMBERS'));
1201:
1202: IF p_suggest_serial = fnd_api.g_true AND
1203: x_request_context.item_serial_control_code NOT IN (1,6) AND
1204: (x_request_context.detail_any_serial = 1 OR
1205: (x_request_line_rec.serial_number_start IS NOT NULL AND
1206: x_request_line_rec.serial_number_end IS NOT NULL)) THEN

Line 1224: when fnd_api.g_exc_error then

1220: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
1221: END IF;
1222: --
1223: EXCEPTION
1224: when fnd_api.g_exc_error then
1225: x_return_status := fnd_api.g_ret_sts_error ;
1226: --
1227: when fnd_api.g_exc_unexpected_error then
1228: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1225: x_return_status := fnd_api.g_ret_sts_error ;

1221: END IF;
1222: --
1223: EXCEPTION
1224: when fnd_api.g_exc_error then
1225: x_return_status := fnd_api.g_ret_sts_error ;
1226: --
1227: when fnd_api.g_exc_unexpected_error then
1228: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1229: --

Line 1227: when fnd_api.g_exc_unexpected_error then

1223: EXCEPTION
1224: when fnd_api.g_exc_error then
1225: x_return_status := fnd_api.g_ret_sts_error ;
1226: --
1227: when fnd_api.g_exc_unexpected_error then
1228: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1229: --
1230: when others then
1231: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1228: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1224: when fnd_api.g_exc_error then
1225: x_return_status := fnd_api.g_ret_sts_error ;
1226: --
1227: when fnd_api.g_exc_unexpected_error then
1228: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1229: --
1230: when others then
1231: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1232: if (fnd_msg_pub.check_msg_level(

Line 1231: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1227: when fnd_api.g_exc_unexpected_error then
1228: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1229: --
1230: when others then
1231: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1232: if (fnd_msg_pub.check_msg_level(
1233: fnd_msg_pub.g_msg_lvl_unexp_error)) then
1234: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1235: end if;

Line 1316: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1312: ,x_return_status => l_return_status
1313: ,x_msg_count => l_msg_count
1314: ,x_msg_data => l_msg_data);
1315:
1316: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1317: CLOSE c_sub_status;
1318: RAISE fnd_api.g_exc_unexpected_error;
1319: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1320: CLOSE c_sub_status;

Line 1318: RAISE fnd_api.g_exc_unexpected_error;

1314: ,x_msg_data => l_msg_data);
1315:
1316: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1317: CLOSE c_sub_status;
1318: RAISE fnd_api.g_exc_unexpected_error;
1319: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1320: CLOSE c_sub_status;
1321: RAISE fnd_api.g_exc_error;
1322: END IF;

Line 1319: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1315:
1316: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1317: CLOSE c_sub_status;
1318: RAISE fnd_api.g_exc_unexpected_error;
1319: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1320: CLOSE c_sub_status;
1321: RAISE fnd_api.g_exc_error;
1322: END IF;
1323: END IF;

Line 1321: RAISE fnd_api.g_exc_error;

1317: CLOSE c_sub_status;
1318: RAISE fnd_api.g_exc_unexpected_error;
1319: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1320: CLOSE c_sub_status;
1321: RAISE fnd_api.g_exc_error;
1322: END IF;
1323: END IF;
1324: CLOSE c_sub_status;
1325: g_isllta_subinventory_code := p_subinventory_code;

Line 1354: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1350: ,x_return_status => l_return_status
1351: ,x_msg_count => l_msg_count
1352: ,x_msg_data => l_msg_data);
1353:
1354: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1355: CLOSE c_loc_status;
1356: RAISE fnd_api.g_exc_unexpected_error;
1357: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1358: CLOSE c_loc_status;

Line 1356: RAISE fnd_api.g_exc_unexpected_error;

1352: ,x_msg_data => l_msg_data);
1353:
1354: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1355: CLOSE c_loc_status;
1356: RAISE fnd_api.g_exc_unexpected_error;
1357: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1358: CLOSE c_loc_status;
1359: RAISE fnd_api.g_exc_error;
1360: END IF;

Line 1357: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1353:
1354: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1355: CLOSE c_loc_status;
1356: RAISE fnd_api.g_exc_unexpected_error;
1357: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1358: CLOSE c_loc_status;
1359: RAISE fnd_api.g_exc_error;
1360: END IF;
1361: END IF;

Line 1359: RAISE fnd_api.g_exc_error;

1355: CLOSE c_loc_status;
1356: RAISE fnd_api.g_exc_unexpected_error;
1357: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1358: CLOSE c_loc_status;
1359: RAISE fnd_api.g_exc_error;
1360: END IF;
1361: END IF;
1362: CLOSE c_loc_status;
1363: g_isllta_locator_id := p_locator_id;

Line 1386: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1382: ,x_default_lot_status_id => l_default_lot_status_id
1383: ,x_serial_status_enabled => l_serial_status_enabled
1384: ,x_default_serial_status_id => l_default_serial_status_id);
1385:
1386: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1387: RAISE fnd_api.g_exc_unexpected_error;
1388: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1389: RAISE fnd_api.g_exc_error;
1390: END IF;

Line 1387: RAISE fnd_api.g_exc_unexpected_error;

1383: ,x_serial_status_enabled => l_serial_status_enabled
1384: ,x_default_serial_status_id => l_default_serial_status_id);
1385:
1386: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1387: RAISE fnd_api.g_exc_unexpected_error;
1388: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1389: RAISE fnd_api.g_exc_error;
1390: END IF;
1391:

Line 1388: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1384: ,x_default_serial_status_id => l_default_serial_status_id);
1385:
1386: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1387: RAISE fnd_api.g_exc_unexpected_error;
1388: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1389: RAISE fnd_api.g_exc_error;
1390: END IF;
1391:
1392: if l_lot_status_enabled = 'Y' AND p_lot_number IS NOT NULL THEN

Line 1389: RAISE fnd_api.g_exc_error;

1385:
1386: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1387: RAISE fnd_api.g_exc_unexpected_error;
1388: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1389: RAISE fnd_api.g_exc_error;
1390: END IF;
1391:
1392: if l_lot_status_enabled = 'Y' AND p_lot_number IS NOT NULL THEN
1393: --get status

Line 1409: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1405: ,x_return_status => l_return_status
1406: ,x_msg_count => l_msg_count
1407: ,x_msg_data => l_msg_data);
1408:
1409: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1410: CLOSE c_lot_status;
1411: RAISE fnd_api.g_exc_unexpected_error;
1412: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1413: CLOSE c_lot_status;

Line 1411: RAISE fnd_api.g_exc_unexpected_error;

1407: ,x_msg_data => l_msg_data);
1408:
1409: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1410: CLOSE c_lot_status;
1411: RAISE fnd_api.g_exc_unexpected_error;
1412: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1413: CLOSE c_lot_status;
1414: RAISE fnd_api.g_exc_error;
1415: END IF;

Line 1412: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1408:
1409: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1410: CLOSE c_lot_status;
1411: RAISE fnd_api.g_exc_unexpected_error;
1412: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1413: CLOSE c_lot_status;
1414: RAISE fnd_api.g_exc_error;
1415: END IF;
1416: END IF;

Line 1414: RAISE fnd_api.g_exc_error;

1410: CLOSE c_lot_status;
1411: RAISE fnd_api.g_exc_unexpected_error;
1412: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1413: CLOSE c_lot_status;
1414: RAISE fnd_api.g_exc_error;
1415: END IF;
1416: END IF;
1417: CLOSE c_lot_status;
1418: g_isllta_lot_number := p_lot_number;

Line 1495: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1491: ,x_default_lot_status_id => l_default_lot_status_id
1492: ,x_serial_status_enabled => g_serial_status_enabled
1493: ,x_default_serial_status_id => l_default_serial_status_id);
1494:
1495: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1496: RAISE fnd_api.g_exc_unexpected_error;
1497: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1498: RAISE fnd_api.g_exc_error;
1499: END IF;

Line 1496: RAISE fnd_api.g_exc_unexpected_error;

1492: ,x_serial_status_enabled => g_serial_status_enabled
1493: ,x_default_serial_status_id => l_default_serial_status_id);
1494:
1495: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1496: RAISE fnd_api.g_exc_unexpected_error;
1497: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1498: RAISE fnd_api.g_exc_error;
1499: END IF;
1500: END IF;

Line 1497: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1493: ,x_default_serial_status_id => l_default_serial_status_id);
1494:
1495: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1496: RAISE fnd_api.g_exc_unexpected_error;
1497: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1498: RAISE fnd_api.g_exc_error;
1499: END IF;
1500: END IF;
1501:

Line 1498: RAISE fnd_api.g_exc_error;

1494:
1495: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1496: RAISE fnd_api.g_exc_unexpected_error;
1497: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1498: RAISE fnd_api.g_exc_error;
1499: END IF;
1500: END IF;
1501:
1502: IF g_serial_status_enabled = 'Y' AND p_serial_status IS NOT NULL THEN

Line 1517: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1513: ,x_return_status => l_return_status
1514: ,x_msg_count => l_msg_count
1515: ,x_msg_data => l_msg_data);
1516:
1517: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1518: RAISE fnd_api.g_exc_unexpected_error;
1519: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1520: RAISE fnd_api.g_exc_error;
1521: END IF;

Line 1518: RAISE fnd_api.g_exc_unexpected_error;

1514: ,x_msg_count => l_msg_count
1515: ,x_msg_data => l_msg_data);
1516:
1517: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1518: RAISE fnd_api.g_exc_unexpected_error;
1519: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1520: RAISE fnd_api.g_exc_error;
1521: END IF;
1522: l_serial_return := g_serial_return;

Line 1519: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1515: ,x_msg_data => l_msg_data);
1516:
1517: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1518: RAISE fnd_api.g_exc_unexpected_error;
1519: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1520: RAISE fnd_api.g_exc_error;
1521: END IF;
1522: l_serial_return := g_serial_return;
1523: END IF;

Line 1520: RAISE fnd_api.g_exc_error;

1516:
1517: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1518: RAISE fnd_api.g_exc_unexpected_error;
1519: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1520: RAISE fnd_api.g_exc_error;
1521: END IF;
1522: l_serial_return := g_serial_return;
1523: END IF;
1524: END IF;

Line 1548: x_return_status := fnd_api.g_ret_sts_success;

1544: ,x_sql_statement OUT NOCOPY LONG)
1545: IS
1546:
1547: BEGIN
1548: x_return_status := fnd_api.g_ret_sts_success;
1549: x_sql_statement := '
1550: SELECT
1551: x.organization_id
1552: ,x.inventory_item_id

Line 1633: x_return_status := fnd_api.g_ret_sts_success;

1629:
1630: -- constants
1631: l_api_name constant varchar(30) := 'search_serial_numbers';
1632: begin
1633: x_return_status := fnd_api.g_ret_sts_success;
1634: x_found := FALSE;
1635:
1636: if (g_serial_tbl_ptr > 0) then
1637: for i in 1..g_serial_tbl_ptr loop

Line 1649: when fnd_api.g_exc_error then

1645: end loop;
1646: end if;
1647: --
1648: exception
1649: when fnd_api.g_exc_error then
1650: x_return_status := fnd_api.g_ret_sts_error ;
1651: x_found := TRUE;
1652:
1653: when fnd_api.g_exc_unexpected_error then

Line 1650: x_return_status := fnd_api.g_ret_sts_error ;

1646: end if;
1647: --
1648: exception
1649: when fnd_api.g_exc_error then
1650: x_return_status := fnd_api.g_ret_sts_error ;
1651: x_found := TRUE;
1652:
1653: when fnd_api.g_exc_unexpected_error then
1654: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1653: when fnd_api.g_exc_unexpected_error then

1649: when fnd_api.g_exc_error then
1650: x_return_status := fnd_api.g_ret_sts_error ;
1651: x_found := TRUE;
1652:
1653: when fnd_api.g_exc_unexpected_error then
1654: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1655: x_found := TRUE;
1656:
1657: when others then

Line 1654: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1650: x_return_status := fnd_api.g_ret_sts_error ;
1651: x_found := TRUE;
1652:
1653: when fnd_api.g_exc_unexpected_error then
1654: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1655: x_found := TRUE;
1656:
1657: when others then
1658: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1658: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1654: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1655: x_found := TRUE;
1656:
1657: when others then
1658: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1659: x_found := TRUE;
1660:
1661: if (fnd_msg_pub.check_msg_level(
1662: fnd_msg_pub.g_msg_lvl_unexp_error)) then

Line 1811: x_return_status := fnd_api.g_ret_sts_success ;

1807: l_custom_select_serials INV_DETAIL_UTIL_PVT.g_serial_row_table_rec;
1808: l_selected_serials INV_DETAIL_UTIL_PVT.g_serial_row_table_rec;
1809:
1810: BEGIN
1811: x_return_status := fnd_api.g_ret_sts_success ;
1812: x_available_sl_qty := 0;
1813: x_serial_index := 0;
1814:
1815: IF g_debug IS NULL or NOT INV_CACHE.is_pickrelease THEN

Line 1860: IF ( x_return_status = fnd_api.g_ret_sts_unexp_error ) THEN

1856: , p_demand_source_header_id => p_demand_source_header_id
1857: , p_demand_source_line_id => p_demand_source_line_id
1858: , x_serial_numbers => l_custom_select_serials );
1859:
1860: IF ( x_return_status = fnd_api.g_ret_sts_unexp_error ) THEN
1861: IF ( l_debug = 1 ) THEN
1862: print_debug('unexp_error from Get_User_Serial_Numbers');
1863: END IF;
1864: RAISE fnd_api.g_exc_unexpected_error;

Line 1864: RAISE fnd_api.g_exc_unexpected_error;

1860: IF ( x_return_status = fnd_api.g_ret_sts_unexp_error ) THEN
1861: IF ( l_debug = 1 ) THEN
1862: print_debug('unexp_error from Get_User_Serial_Numbers');
1863: END IF;
1864: RAISE fnd_api.g_exc_unexpected_error;
1865: ELSIF ( x_return_status = fnd_api.g_ret_sts_error ) THEN
1866: IF ( l_debug = 1 ) THEN
1867: print_debug('error from Get_User_Serial_Numbers');
1868: END IF;

Line 1865: ELSIF ( x_return_status = fnd_api.g_ret_sts_error ) THEN

1861: IF ( l_debug = 1 ) THEN
1862: print_debug('unexp_error from Get_User_Serial_Numbers');
1863: END IF;
1864: RAISE fnd_api.g_exc_unexpected_error;
1865: ELSIF ( x_return_status = fnd_api.g_ret_sts_error ) THEN
1866: IF ( l_debug = 1 ) THEN
1867: print_debug('error from Get_User_Serial_Numbers');
1868: END IF;
1869: RAISE fnd_api.g_exc_error;

Line 1869: RAISE fnd_api.g_exc_error;

1865: ELSIF ( x_return_status = fnd_api.g_ret_sts_error ) THEN
1866: IF ( l_debug = 1 ) THEN
1867: print_debug('error from Get_User_Serial_Numbers');
1868: END IF;
1869: RAISE fnd_api.g_exc_error;
1870: END IF;
1871:
1872: --Bulk insert the return values from user into temp table for validation
1873: BEGIN

Line 1892: RAISE fnd_api.g_exc_error;

1888: print_debug('Get_User_Serial_Numbers returned duplicate serials', 1);
1889: END IF;
1890: fnd_message.set_name('INV', 'INV_DUPLICATE_SERIAL');
1891: fnd_msg_pub.ADD;
1892: RAISE fnd_api.g_exc_error;
1893: END;
1894:
1895: --Retrieve only valid rows returned from api
1896: OPEN validate_sn_cur;

Line 1992: WHEN fnd_api.g_exc_error then

1988: IF ( l_debug = 1 )THEN
1989: print_debug('exit '||g_pkg_name||'.'||l_api_name);
1990: END IF;
1991: EXCEPTION
1992: WHEN fnd_api.g_exc_error then
1993: x_return_status := fnd_api.g_ret_sts_error;
1994: x_available_sl_qty := 0;
1995: x_serial_index := 0;
1996:

Line 1993: x_return_status := fnd_api.g_ret_sts_error;

1989: print_debug('exit '||g_pkg_name||'.'||l_api_name);
1990: END IF;
1991: EXCEPTION
1992: WHEN fnd_api.g_exc_error then
1993: x_return_status := fnd_api.g_ret_sts_error;
1994: x_available_sl_qty := 0;
1995: x_serial_index := 0;
1996:
1997: IF (l_debug = 1) THEN

Line 2001: x_return_status := fnd_api.g_ret_sts_unexp_error;

1997: IF (l_debug = 1) THEN
1998: print_debug(l_api_name ||' Exc err progress='||l_progress||' SQL err: '||SQLERRM(SQLCODE), 1);
1999: END IF;
2000: WHEN OTHERS THEN
2001: x_return_status := fnd_api.g_ret_sts_unexp_error;
2002: x_available_sl_qty := 0;
2003: x_serial_index := 0;
2004:
2005: IF (l_debug = 1) THEN

Line 2038: x_return_status := fnd_api.g_ret_sts_success;

2034: END IF;
2035: -- end of debugging section
2036: --
2037: -- Initialisize API return status to access
2038: x_return_status := fnd_api.g_ret_sts_success;
2039: IF p_mmtt_tbl_size IS NULL OR p_mmtt_tbl_size <1 THEN
2040: RETURN;
2041: END IF;
2042: --

Line 2457: when fnd_api.g_exc_error then

2453: END IF;
2454: -- end of debugging section
2455: --
2456: EXCEPTION
2457: when fnd_api.g_exc_error then
2458: --
2459: -- debugging portion
2460: -- can be commented ut for final code
2461: IF inv_pp_debug.is_debug_mode THEN

Line 2470: x_return_status := fnd_api.g_ret_sts_error;

2466: inv_pp_debug.send_last_error_message;
2467: END IF;
2468: -- end of debugging section
2469: --
2470: x_return_status := fnd_api.g_ret_sts_error;
2471: --
2472: when fnd_api.g_exc_unexpected_error then
2473: --
2474: -- debugging portion

Line 2472: when fnd_api.g_exc_unexpected_error then

2468: -- end of debugging section
2469: --
2470: x_return_status := fnd_api.g_ret_sts_error;
2471: --
2472: when fnd_api.g_exc_unexpected_error then
2473: --
2474: -- debugging portion
2475: -- can be commented ut for final code
2476: IF inv_pp_debug.is_debug_mode THEN

Line 2485: x_return_status := fnd_api.g_ret_sts_unexp_error;

2481: inv_pp_debug.send_last_error_message;
2482: END IF;
2483: -- end of debugging section
2484: --
2485: x_return_status := fnd_api.g_ret_sts_unexp_error;
2486: --
2487: when others then
2488: --
2489: -- debugging portion

Line 2500: x_return_status := fnd_api.g_ret_sts_unexp_error;

2496: inv_pp_debug.send_last_error_message;
2497: END IF;
2498: -- end of debugging section
2499: --
2500: x_return_status := fnd_api.g_ret_sts_unexp_error;
2501: if fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2502: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2503: end if;
2504: --

Line 2531: x_return_status := fnd_api.g_ret_sts_success;

2527: END IF;
2528: -- end of debugging section
2529: --
2530: -- Initialisize API return status to access
2531: x_return_status := fnd_api.g_ret_sts_success;
2532: IF p_mtlt_tbl_size IS NULL OR p_mtlt_tbl_size < 1 THEN
2533: RETURN;
2534: END IF;
2535: --

Line 2775: when fnd_api.g_exc_error then

2771: END IF;
2772: -- end of debugging section
2773: --
2774: EXCEPTION
2775: when fnd_api.g_exc_error then
2776: --
2777: -- debugging portion
2778: -- can be commented ut for final code
2779: IF inv_pp_debug.is_debug_mode THEN

Line 2788: x_return_status := fnd_api.g_ret_sts_error;

2784: inv_pp_debug.send_last_error_message;
2785: END IF;
2786: -- end of debugging section
2787: --
2788: x_return_status := fnd_api.g_ret_sts_error;
2789: --
2790: when fnd_api.g_exc_unexpected_error then
2791: --
2792: -- debugging portion

Line 2790: when fnd_api.g_exc_unexpected_error then

2786: -- end of debugging section
2787: --
2788: x_return_status := fnd_api.g_ret_sts_error;
2789: --
2790: when fnd_api.g_exc_unexpected_error then
2791: --
2792: -- debugging portion
2793: -- can be commented ut for final code
2794: IF inv_pp_debug.is_debug_mode THEN

Line 2803: x_return_status := fnd_api.g_ret_sts_unexp_error;

2799: inv_pp_debug.send_last_error_message;
2800: END IF;
2801: -- end of debugging section
2802: --
2803: x_return_status := fnd_api.g_ret_sts_unexp_error;
2804: --
2805: when others then
2806: --
2807: -- debugging portion

Line 2818: x_return_status := fnd_api.g_ret_sts_unexp_error;

2814: inv_pp_debug.send_last_error_message;
2815: END IF;
2816: -- end of debugging section
2817: --
2818: x_return_status := fnd_api.g_ret_sts_unexp_error;
2819: if fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2820: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
2821: end if;
2822: --

Line 2849: x_return_status := fnd_api.g_ret_sts_success;

2845: END IF;
2846: -- end of debugging section
2847: --
2848: -- Initialisize API return status to access
2849: x_return_status := fnd_api.g_ret_sts_success;
2850: IF p_msnt_tbl_size IS NULL OR p_msnt_tbl_size < 1 THEN
2851: RETURN;
2852: END IF;
2853: --

Line 2912: when fnd_api.g_exc_error then

2908: END IF;
2909: -- end of debugging section
2910: --
2911: EXCEPTION
2912: when fnd_api.g_exc_error then
2913: --
2914: -- debugging portion
2915: -- can be commented ut for final code
2916: IF inv_pp_debug.is_debug_mode THEN

Line 2925: x_return_status := fnd_api.g_ret_sts_error;

2921: inv_pp_debug.send_last_error_message;
2922: END IF;
2923: -- end of debugging section
2924: --
2925: x_return_status := fnd_api.g_ret_sts_error;
2926: --
2927: when fnd_api.g_exc_unexpected_error then
2928: --
2929: -- debugging portion

Line 2927: when fnd_api.g_exc_unexpected_error then

2923: -- end of debugging section
2924: --
2925: x_return_status := fnd_api.g_ret_sts_error;
2926: --
2927: when fnd_api.g_exc_unexpected_error then
2928: --
2929: -- debugging portion
2930: -- can be commented ut for final code
2931: IF inv_pp_debug.is_debug_mode THEN

Line 2940: x_return_status := fnd_api.g_ret_sts_unexp_error;

2936: inv_pp_debug.send_last_error_message;
2937: END IF;
2938: -- end of debugging section
2939: --
2940: x_return_status := fnd_api.g_ret_sts_unexp_error;
2941: --
2942: when others then
2943: --
2944: -- debugging portion

Line 2955: x_return_status := fnd_api.g_ret_sts_unexp_error;

2951: inv_pp_debug.send_last_error_message;
2952: END IF;
2953: -- end of debugging section
2954: --
2955: x_return_status := fnd_api.g_ret_sts_unexp_error;
2956: if fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2957: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
2958: end if;
2959: --

Line 3200: x_return_status := fnd_api.g_ret_sts_success;

3196: , secondary_detailed_quantity = secondary_detailed_quantity + g_output_process_tbl(l_index).secondary_quantity
3197: WHERE reservation_id = l_reservation_id;
3198: END IF;
3199: END LOOP;
3200: x_return_status := fnd_api.g_ret_sts_success;
3201: EXCEPTION
3202: WHEN OTHERS THEN
3203: FND_MESSAGE.SET_NAME('INV','INV_UPD_RSV_FAILED');
3204: FND_MSG_PUB.Add;

Line 3205: x_return_status := fnd_api.g_ret_sts_unexp_error;

3201: EXCEPTION
3202: WHEN OTHERS THEN
3203: FND_MESSAGE.SET_NAME('INV','INV_UPD_RSV_FAILED');
3204: FND_MSG_PUB.Add;
3205: x_return_status := fnd_api.g_ret_sts_unexp_error;
3206: END update_detailed_quantities;
3207: --
3208: -- create suggestion records.
3209: -- insert into mtl_material_transactions_temp, mtl_serial_numbers_temp,

Line 3219: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

3215: p_plan_tasks IN BOOLEAN
3216: ) IS
3217: l_api_name CONSTANT VARCHAR2(30) := 'Process_Output';
3218: l_debug NUMBER;
3219: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3220: l_insert_lot BOOLEAN; -- insert a new lot record
3221: l_insert_serial BOOLEAN; -- insert a new serial record
3222: l_insert_txn BOOLEAN; -- insert a new transaction temp record
3223: l_txn_temp_id NUMBER;

Line 3278: x_return_status := fnd_api.g_ret_sts_success;

3274: print_debug('in process output ');
3275: print_output_process_tbl(p_request_context);
3276: END IF;
3277: -- Initialisize API return status to access
3278: x_return_status := fnd_api.g_ret_sts_success;
3279: IF g_output_process_tbl_size IS NULL OR
3280: g_output_process_tbl_size < 1 THEN
3281: RETURN;
3282: END IF;

Line 3839: x_return_status := FND_API.G_RET_STS_ERROR;

3835: END IF;
3836: IF l_mmtt_tbl(l_mmtt_tbl_size).acct_period_id = -1 THEN
3837: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');
3838: FND_MSG_PUB.add;
3839: x_return_status := FND_API.G_RET_STS_ERROR;
3840: raise FND_API.G_EXC_ERROR;
3841: END IF;
3842: l_mmtt_tbl(l_mmtt_tbl_size).transaction_reference :=
3843: p_request_line_rec.reference;

Line 3840: raise FND_API.G_EXC_ERROR;

3836: IF l_mmtt_tbl(l_mmtt_tbl_size).acct_period_id = -1 THEN
3837: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');
3838: FND_MSG_PUB.add;
3839: x_return_status := FND_API.G_RET_STS_ERROR;
3840: raise FND_API.G_EXC_ERROR;
3841: END IF;
3842: l_mmtt_tbl(l_mmtt_tbl_size).transaction_reference :=
3843: p_request_line_rec.reference;
3844: l_mmtt_tbl(l_mmtt_tbl_size).reason_id :=

Line 3990: IF l_return_status = fnd_api.g_ret_sts_error THEN

3986: x_return_status => l_return_status ,
3987: p_mmtt_tbl => l_mmtt_tbl ,
3988: p_mmtt_tbl_size => l_mmtt_tbl_size
3989: );
3990: IF l_return_status = fnd_api.g_ret_sts_error THEN
3991: RAISE fnd_api.g_exc_error;
3992: END IF;
3993: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3994: RAISE fnd_api.g_exc_unexpected_error;

Line 3991: RAISE fnd_api.g_exc_error;

3987: p_mmtt_tbl => l_mmtt_tbl ,
3988: p_mmtt_tbl_size => l_mmtt_tbl_size
3989: );
3990: IF l_return_status = fnd_api.g_ret_sts_error THEN
3991: RAISE fnd_api.g_exc_error;
3992: END IF;
3993: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3994: RAISE fnd_api.g_exc_unexpected_error;
3995: END IF;

Line 3993: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3989: );
3990: IF l_return_status = fnd_api.g_ret_sts_error THEN
3991: RAISE fnd_api.g_exc_error;
3992: END IF;
3993: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3994: RAISE fnd_api.g_exc_unexpected_error;
3995: END IF;
3996: END IF;
3997: IF l_mtlt_tbl_size > 0 THEN

Line 3994: RAISE fnd_api.g_exc_unexpected_error;

3990: IF l_return_status = fnd_api.g_ret_sts_error THEN
3991: RAISE fnd_api.g_exc_error;
3992: END IF;
3993: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3994: RAISE fnd_api.g_exc_unexpected_error;
3995: END IF;
3996: END IF;
3997: IF l_mtlt_tbl_size > 0 THEN
3998: insert_mtlt

Line 4004: IF l_return_status = fnd_api.g_ret_sts_error THEN

4000: x_return_status => l_return_status ,
4001: p_mtlt_tbl => l_mtlt_tbl ,
4002: p_mtlt_tbl_size => l_mtlt_tbl_size
4003: );
4004: IF l_return_status = fnd_api.g_ret_sts_error THEN
4005: RAISE fnd_api.g_exc_error;
4006: END IF;
4007: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4008: RAISE fnd_api.g_exc_unexpected_error;

Line 4005: RAISE fnd_api.g_exc_error;

4001: p_mtlt_tbl => l_mtlt_tbl ,
4002: p_mtlt_tbl_size => l_mtlt_tbl_size
4003: );
4004: IF l_return_status = fnd_api.g_ret_sts_error THEN
4005: RAISE fnd_api.g_exc_error;
4006: END IF;
4007: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4008: RAISE fnd_api.g_exc_unexpected_error;
4009: END IF;

Line 4007: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

4003: );
4004: IF l_return_status = fnd_api.g_ret_sts_error THEN
4005: RAISE fnd_api.g_exc_error;
4006: END IF;
4007: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4008: RAISE fnd_api.g_exc_unexpected_error;
4009: END IF;
4010: END IF;
4011: IF l_msnt_tbl_size > 0 THEN

Line 4008: RAISE fnd_api.g_exc_unexpected_error;

4004: IF l_return_status = fnd_api.g_ret_sts_error THEN
4005: RAISE fnd_api.g_exc_error;
4006: END IF;
4007: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4008: RAISE fnd_api.g_exc_unexpected_error;
4009: END IF;
4010: END IF;
4011: IF l_msnt_tbl_size > 0 THEN
4012: insert_msnt

Line 4018: IF l_return_status = fnd_api.g_ret_sts_error THEN

4014: x_return_status => l_return_status ,
4015: p_msnt_tbl => l_msnt_tbl ,
4016: p_msnt_tbl_size => l_msnt_tbl_size
4017: );
4018: IF l_return_status = fnd_api.g_ret_sts_error THEN
4019: RAISE fnd_api.g_exc_error;
4020: END IF;
4021: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4022: RAISE fnd_api.g_exc_unexpected_error;

Line 4019: RAISE fnd_api.g_exc_error;

4015: p_msnt_tbl => l_msnt_tbl ,
4016: p_msnt_tbl_size => l_msnt_tbl_size
4017: );
4018: IF l_return_status = fnd_api.g_ret_sts_error THEN
4019: RAISE fnd_api.g_exc_error;
4020: END IF;
4021: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4022: RAISE fnd_api.g_exc_unexpected_error;
4023: END IF;

Line 4021: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

4017: );
4018: IF l_return_status = fnd_api.g_ret_sts_error THEN
4019: RAISE fnd_api.g_exc_error;
4020: END IF;
4021: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4022: RAISE fnd_api.g_exc_unexpected_error;
4023: END IF;
4024: END IF;
4025: IF p_request_context.detail_serial AND

Line 4022: RAISE fnd_api.g_exc_unexpected_error;

4018: IF l_return_status = fnd_api.g_ret_sts_error THEN
4019: RAISE fnd_api.g_exc_error;
4020: END IF;
4021: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4022: RAISE fnd_api.g_exc_unexpected_error;
4023: END IF;
4024: END IF;
4025: IF p_request_context.detail_serial AND
4026: (p_request_context.transfer_flag OR

Line 4042: --IF l_return_status = fnd_api.g_ret_sts_error THEN

4038: -- detailed quantity but not updating the quantity tree.
4039: -- Since we update detailed_quantity in INV_PICK_RELEASE_PVT.Process_line,
4040: -- we don't need to do it here.
4041: --update_detailed_quantities(l_return_status);
4042: --IF l_return_status = fnd_api.g_ret_sts_error THEN
4043: -- RAISE fnd_api.g_exc_error;
4044: --END IF;
4045: --IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4046: -- RAISE fnd_api.g_exc_unexpected_error;

Line 4043: -- RAISE fnd_api.g_exc_error;

4039: -- Since we update detailed_quantity in INV_PICK_RELEASE_PVT.Process_line,
4040: -- we don't need to do it here.
4041: --update_detailed_quantities(l_return_status);
4042: --IF l_return_status = fnd_api.g_ret_sts_error THEN
4043: -- RAISE fnd_api.g_exc_error;
4044: --END IF;
4045: --IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4046: -- RAISE fnd_api.g_exc_unexpected_error;
4047: --END IF;

Line 4045: --IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

4041: --update_detailed_quantities(l_return_status);
4042: --IF l_return_status = fnd_api.g_ret_sts_error THEN
4043: -- RAISE fnd_api.g_exc_error;
4044: --END IF;
4045: --IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4046: -- RAISE fnd_api.g_exc_unexpected_error;
4047: --END IF;
4048: x_return_status := l_return_status;
4049: --

Line 4046: -- RAISE fnd_api.g_exc_unexpected_error;

4042: --IF l_return_status = fnd_api.g_ret_sts_error THEN
4043: -- RAISE fnd_api.g_exc_error;
4044: --END IF;
4045: --IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4046: -- RAISE fnd_api.g_exc_unexpected_error;
4047: --END IF;
4048: x_return_status := l_return_status;
4049: --
4050: -- debugging section

Line 4065: WHEN fnd_api.g_exc_error THEN

4061: END IF;
4062: -- end of debugging section
4063: --
4064: EXCEPTION
4065: WHEN fnd_api.g_exc_error THEN
4066: --
4067: -- debugging section
4068: -- can be commented ut for final code
4069: IF inv_pp_debug.is_debug_mode THEN

Line 4078: x_return_status := fnd_api.g_ret_sts_error;

4074: inv_pp_debug.send_last_error_message;
4075: END IF;
4076: -- end of debugging section
4077: --
4078: x_return_status := fnd_api.g_ret_sts_error;
4079: --
4080: WHEN fnd_api.g_exc_unexpected_error THEN
4081: --
4082: -- debugging section

Line 4080: WHEN fnd_api.g_exc_unexpected_error THEN

4076: -- end of debugging section
4077: --
4078: x_return_status := fnd_api.g_ret_sts_error;
4079: --
4080: WHEN fnd_api.g_exc_unexpected_error THEN
4081: --
4082: -- debugging section
4083: -- can be commented ut for final code
4084: IF inv_pp_debug.is_debug_mode THEN

Line 4093: x_return_status := fnd_api.g_ret_sts_unexp_error;

4089: inv_pp_debug.send_last_error_message;
4090: END IF;
4091: -- end of debugging section
4092: --
4093: x_return_status := fnd_api.g_ret_sts_unexp_error;
4094: --
4095: WHEN OTHERS THEN
4096: --
4097: -- debugging section

Line 4108: x_return_status := fnd_api.g_ret_sts_unexp_error;

4104: inv_pp_debug.send_last_error_message;
4105: END IF;
4106: -- end of debugging section
4107: --
4108: x_return_status := fnd_api.g_ret_sts_unexp_error;
4109: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4110: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4111: END IF;
4112: --

Line 4303: IF l_status_return = fnd_api.g_ret_sts_unexp_error THEN

4299: ,p_transaction_type_id => p_transaction_type_id
4300: ,x_return_status => l_status_return ,x_msg_count => l_msg_count
4301: ,x_msg_data => l_msg_data);
4302:
4303: IF l_status_return = fnd_api.g_ret_sts_unexp_error THEN
4304: RAISE fnd_api.g_exc_unexpected_error;
4305: ELSIF l_status_return = fnd_api.g_ret_sts_error THEN
4306: RAISE fnd_api.g_exc_error;
4307: END IF;

Line 4304: RAISE fnd_api.g_exc_unexpected_error;

4300: ,x_return_status => l_status_return ,x_msg_count => l_msg_count
4301: ,x_msg_data => l_msg_data);
4302:
4303: IF l_status_return = fnd_api.g_ret_sts_unexp_error THEN
4304: RAISE fnd_api.g_exc_unexpected_error;
4305: ELSIF l_status_return = fnd_api.g_ret_sts_error THEN
4306: RAISE fnd_api.g_exc_error;
4307: END IF;
4308: EXCEPTION

Line 4305: ELSIF l_status_return = fnd_api.g_ret_sts_error THEN

4301: ,x_msg_data => l_msg_data);
4302:
4303: IF l_status_return = fnd_api.g_ret_sts_unexp_error THEN
4304: RAISE fnd_api.g_exc_unexpected_error;
4305: ELSIF l_status_return = fnd_api.g_ret_sts_error THEN
4306: RAISE fnd_api.g_exc_error;
4307: END IF;
4308: EXCEPTION
4309: WHEN OTHERS THEN

Line 4306: RAISE fnd_api.g_exc_error;

4302:
4303: IF l_status_return = fnd_api.g_ret_sts_unexp_error THEN
4304: RAISE fnd_api.g_exc_unexpected_error;
4305: ELSIF l_status_return = fnd_api.g_ret_sts_error THEN
4306: RAISE fnd_api.g_exc_error;
4307: END IF;
4308: EXCEPTION
4309: WHEN OTHERS THEN
4310: IF (l_debug = 1) THEN

Line 4313: RAISE fnd_api.g_exc_unexpected_error;

4309: WHEN OTHERS THEN
4310: IF (l_debug = 1) THEN
4311: l_progress := 'WMSSCC-0890';
4312: print_debug('INV_DETAIL_UTIL_PVT:'||l_api_name||': Error occured'||l_progress, 1);
4313: RAISE fnd_api.g_exc_unexpected_error;
4314: END IF;
4315: END;
4316:
4317: IF ( l_debug = 1 ) THEN