DBA Data[Home] [Help]

APPS.RCV_PROCESSOR_PVT dependencies on FND_API

Line 104: x_return_status := fnd_api.g_ret_sts_success;

100: asn_debug.put_line('p_source_type_code ' || p_source_type_code);
101: asn_debug.put_line('p_transaction_type ' || p_transaction_type);
102: END IF;
103:
104: x_return_status := fnd_api.g_ret_sts_success;
105:
106: /* We can now come here if it is a lot-serial item and there is
107: * no row in mtl_transaction_lots_temp if user has not entered
108: * any lot/serial info for this transaction(Receive, Transfer etc).

Line 363: x_return_status := fnd_api.g_ret_sts_error;

359: IF (g_asn_debug = 'Y') THEN
360: asn_debug.put_line('no_data_found insert_rcv_lots_supply');
361: END IF;
362:
363: x_return_status := fnd_api.g_ret_sts_error;
364:
365: INSERT INTO po_interface_errors
366: (interface_type,
367: interface_transaction_id,

Line 400: x_return_status := fnd_api.g_ret_sts_unexp_error;

396: IF (g_asn_debug = 'Y') THEN
397: asn_debug.put_line('others insert_rcv_lots_supply');
398: END IF;
399:
400: x_return_status := fnd_api.g_ret_sts_unexp_error;
401:
402: INSERT INTO po_interface_errors
403: (interface_type,
404: interface_transaction_id,

Line 483: x_return_status := fnd_api.g_ret_sts_success;

479: asn_debug.put_line('p_source_type_code ' || p_source_type_code);
480: asn_debug.put_line('p_transaction_type ' || p_transaction_type);
481: END IF;
482:
483: x_return_status := fnd_api.g_ret_sts_success;
484:
485: /* We can now come here if it is a lot-serial item and there is
486: * no row in mtl_transaction_lots_temp if user has not entered
487: * any lot/serial info for this transaction(Receive, Transfer etc).

Line 660: x_return_status := fnd_api.g_ret_sts_error;

656: IF (g_asn_debug = 'Y') THEN
657: asn_debug.put_line('no_data_found insert_rcv_serials_supply ');
658: END IF;
659:
660: x_return_status := fnd_api.g_ret_sts_error;
661:
662: INSERT INTO po_interface_errors
663: (interface_type,
664: interface_transaction_id,

Line 697: x_return_status := fnd_api.g_ret_sts_unexp_error;

693: IF (g_asn_debug = 'Y') THEN
694: asn_debug.put_line('others insert_rcv_serials_supply ');
695: END IF;
696:
697: x_return_status := fnd_api.g_ret_sts_unexp_error;
698:
699: INSERT INTO po_interface_errors
700: (interface_type,
701: interface_transaction_id,

Line 894: x_return_status := fnd_api.g_ret_sts_success;

890: asn_debug.put_line('p_parent_supply_id ' || p_parent_supply_id);
891: asn_debug.put_line('p_correction_type ' || p_correction_type);
892: END IF;
893:
894: x_return_status := fnd_api.g_ret_sts_success;
895:
896: /* We can now come here if it is a lot-serial item and there is
897: * no row in mtl_transaction_lots_temp if user has not entered
898: * any lot/serial info for this transaction(Receive, Transfer etc).

Line 1322: x_return_status := fnd_api.g_ret_sts_error;

1318: IF (g_asn_debug = 'Y') THEN
1319: asn_debug.put_line('no_data_found update_rcv_lots_supply ');
1320: END IF;
1321:
1322: x_return_status := fnd_api.g_ret_sts_error;
1323:
1324: INSERT INTO po_interface_errors
1325: (interface_type,
1326: interface_transaction_id,

Line 1359: x_return_status := fnd_api.g_ret_sts_unexp_error;

1355: IF (g_asn_debug = 'Y') THEN
1356: asn_debug.put_line('others update_rcv_lots_supply ');
1357: END IF;
1358:
1359: x_return_status := fnd_api.g_ret_sts_unexp_error;
1360:
1361: INSERT INTO po_interface_errors
1362: (interface_type,
1363: interface_transaction_id,

Line 1447: x_return_status := fnd_api.g_ret_sts_success;

1443: asn_debug.put_line('p_parent_supply_id ' || p_parent_supply_id);
1444: asn_debug.put_line('p_correction_type ' || p_correction_type);
1445: END IF;
1446:
1447: x_return_status := fnd_api.g_ret_sts_success;
1448:
1449: /* We can now come here if it is a lot-serial item and there is
1450: * no row in mtl_transaction_lots_temp if user has not entered
1451: * any lot/serial info for this transaction(Receive, Transfer etc).

Line 1679: x_return_status := fnd_api.g_ret_sts_error;

1675: IF (g_asn_debug = 'Y') THEN
1676: asn_debug.put_line('no_data_found update_rcv_serials_supply');
1677: END IF;
1678:
1679: x_return_status := fnd_api.g_ret_sts_error;
1680:
1681: INSERT INTO po_interface_errors
1682: (interface_type,
1683: interface_transaction_id,

Line 1716: x_return_status := fnd_api.g_ret_sts_unexp_error;

1712: IF (g_asn_debug = 'Y') THEN
1713: asn_debug.put_line('others update_rcv_serials_supply');
1714: END IF;
1715:
1716: x_return_status := fnd_api.g_ret_sts_unexp_error;
1717:
1718: INSERT INTO po_interface_errors
1719: (interface_type,
1720: interface_transaction_id,

Line 1773: x_return_status := fnd_api.g_ret_sts_success;

1769: asn_debug.put_line('p_supply_type_code ' || p_supply_type_code);
1770: asn_debug.put_line('p_supply_source_id ' || p_supply_source_id);
1771: END IF;
1772:
1773: x_return_status := fnd_api.g_ret_sts_success;
1774:
1775: /* We can now come here if it is a lot-serial item and there is
1776: * no row in mtl_transaction_lots_temp if user has not entered
1777: * any lot/serial info for this transaction(Receive, Transfer etc).

Line 1918: x_return_status := fnd_api.g_ret_sts_error;

1914: IF (g_asn_debug = 'Y') THEN
1915: asn_debug.put_line('no_data_found insert_lots_supply ');
1916: END IF;
1917:
1918: x_return_status := fnd_api.g_ret_sts_error;
1919: RAISE;
1920: WHEN OTHERS THEN
1921: IF (g_asn_debug = 'Y') THEN
1922: asn_debug.put_line('others insert_lots_supply ');

Line 1925: x_return_status := fnd_api.g_ret_sts_unexp_error;

1921: IF (g_asn_debug = 'Y') THEN
1922: asn_debug.put_line('others insert_lots_supply ');
1923: END IF;
1924:
1925: x_return_status := fnd_api.g_ret_sts_unexp_error;
1926: RAISE;
1927: END insert_lot_supply;
1928:
1929: PROCEDURE insert_serial_supply(

Line 1956: x_return_status := fnd_api.g_ret_sts_success;

1952: asn_debug.put_line('p_supply_type_code ' || p_supply_type_code);
1953: asn_debug.put_line('p_supply_source_id ' || p_supply_source_id);
1954: END IF;
1955:
1956: x_return_status := fnd_api.g_ret_sts_success;
1957:
1958: /* We can now come here if it is a lot-serial item and there is
1959: * no row in mtl_transaction_lots_temp if user has not entered
1960: * any lot/serial info for this transaction(Receive, Transfer etc).

Line 2066: x_return_status := fnd_api.g_ret_sts_error;

2062: IF (g_asn_debug = 'Y') THEN
2063: asn_debug.put_line(' no_data_found insert_serial_supply');
2064: END IF;
2065:
2066: x_return_status := fnd_api.g_ret_sts_error;
2067: RAISE;
2068: WHEN OTHERS THEN
2069: IF (g_asn_debug = 'Y') THEN
2070: asn_debug.put_line(' others insert_serial_supply');

Line 2073: x_return_status := fnd_api.g_ret_sts_unexp_error;

2069: IF (g_asn_debug = 'Y') THEN
2070: asn_debug.put_line(' others insert_serial_supply');
2071: END IF;
2072:
2073: x_return_status := fnd_api.g_ret_sts_unexp_error;
2074: RAISE;
2075: END insert_serial_supply;
2076:
2077: PROCEDURE insert_lot_transactions(

Line 2100: x_return_status := fnd_api.g_ret_sts_success;

2096: asn_debug.put_line('p_correction_transaction_id ' || p_correction_transaction_id);
2097: asn_debug.put_line('p_negate_qty ' || p_negate_qty);
2098: END IF;
2099:
2100: x_return_status := fnd_api.g_ret_sts_success;
2101:
2102: /* We can now come here if it is a lot-serial item and there is
2103: * no row in mtl_transaction_lots_temp if user has not entered
2104: * any lot/serial info for this transaction(Receive, Transfer etc).

Line 2221: x_return_status := fnd_api.g_ret_sts_error;

2217: IF (g_asn_debug = 'Y') THEN
2218: asn_debug.put_line('no_data_found insert_lot_transactions ');
2219: END IF;
2220:
2221: x_return_status := fnd_api.g_ret_sts_error;
2222: RAISE;
2223: WHEN OTHERS THEN
2224: IF (g_asn_debug = 'Y') THEN
2225: asn_debug.put_line('others insert_lot_transactions ');

Line 2228: x_return_status := fnd_api.g_ret_sts_unexp_error;

2224: IF (g_asn_debug = 'Y') THEN
2225: asn_debug.put_line('others insert_lot_transactions ');
2226: END IF;
2227:
2228: x_return_status := fnd_api.g_ret_sts_unexp_error;
2229: RAISE;
2230: END insert_lot_transactions;
2231:
2232: PROCEDURE validate_lpn_groups(

Line 2267: fnd_api.g_true,

2263: asn_debug.put_line('Before calling inv api ');
2264: END IF;
2265:
2266: l_return := inv_rcv_integration_apis.validate_lpn_info(1.0,
2267: fnd_api.g_true,
2268: l_ret_status,
2269: l_msg_cnt,
2270: l_msg_data,
2271: inv_rcv_integration_apis.g_exists_or_create,

Line 2279: --If l_ret_status <> fnd_api.g_ret_sts_success then --

2275: IF (g_asn_debug = 'Y') THEN
2276: asn_debug.put_line('After calling inv api ');
2277: END IF;
2278:
2279: --If l_ret_status <> fnd_api.g_ret_sts_success then --
2280: IF (l_return <> TRUE) THEN --{
2281: IF (g_asn_debug = 'Y') THEN
2282: asn_debug.put_line('l_return is false ');
2283: END IF;