DBA Data[Home] [Help]

APPS.RCV_PROCESSOR_PVT dependencies on FND_API

Line 103: x_return_status := fnd_api.g_ret_sts_success;

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

Line 350: x_return_status := fnd_api.g_ret_sts_error;

346: IF (g_asn_debug = 'Y') THEN
347: asn_debug.put_line('no_data_found insert_rcv_lots_supply');
348: END IF;
349:
350: x_return_status := fnd_api.g_ret_sts_error;
351:
352: INSERT INTO po_interface_errors
353: (interface_type,
354: interface_transaction_id,

Line 387: x_return_status := fnd_api.g_ret_sts_unexp_error;

383: IF (g_asn_debug = 'Y') THEN
384: asn_debug.put_line('others insert_rcv_lots_supply');
385: END IF;
386:
387: x_return_status := fnd_api.g_ret_sts_unexp_error;
388:
389: INSERT INTO po_interface_errors
390: (interface_type,
391: interface_transaction_id,

Line 470: x_return_status := fnd_api.g_ret_sts_success;

466: asn_debug.put_line('p_source_type_code ' || p_source_type_code);
467: asn_debug.put_line('p_transaction_type ' || p_transaction_type);
468: END IF;
469:
470: x_return_status := fnd_api.g_ret_sts_success;
471:
472: /* We can now come here if it is a lot-serial item and there is
473: * no row in mtl_transaction_lots_temp if user has not entered
474: * any lot/serial info for this transaction(Receive, Transfer etc).

Line 647: x_return_status := fnd_api.g_ret_sts_error;

643: IF (g_asn_debug = 'Y') THEN
644: asn_debug.put_line('no_data_found insert_rcv_serials_supply ');
645: END IF;
646:
647: x_return_status := fnd_api.g_ret_sts_error;
648:
649: INSERT INTO po_interface_errors
650: (interface_type,
651: interface_transaction_id,

Line 684: x_return_status := fnd_api.g_ret_sts_unexp_error;

680: IF (g_asn_debug = 'Y') THEN
681: asn_debug.put_line('others insert_rcv_serials_supply ');
682: END IF;
683:
684: x_return_status := fnd_api.g_ret_sts_unexp_error;
685:
686: INSERT INTO po_interface_errors
687: (interface_type,
688: interface_transaction_id,

Line 888: x_return_status := fnd_api.g_ret_sts_success;

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

Line 1309: x_return_status := fnd_api.g_ret_sts_error;

1305: IF (g_asn_debug = 'Y') THEN
1306: asn_debug.put_line('no_data_found update_rcv_lots_supply ');
1307: END IF;
1308:
1309: x_return_status := fnd_api.g_ret_sts_error;
1310:
1311: INSERT INTO po_interface_errors
1312: (interface_type,
1313: interface_transaction_id,

Line 1346: x_return_status := fnd_api.g_ret_sts_unexp_error;

1342: IF (g_asn_debug = 'Y') THEN
1343: asn_debug.put_line('others update_rcv_lots_supply ');
1344: END IF;
1345:
1346: x_return_status := fnd_api.g_ret_sts_unexp_error;
1347:
1348: INSERT INTO po_interface_errors
1349: (interface_type,
1350: interface_transaction_id,

Line 1434: x_return_status := fnd_api.g_ret_sts_success;

1430: asn_debug.put_line('p_parent_supply_id ' || p_parent_supply_id);
1431: asn_debug.put_line('p_correction_type ' || p_correction_type);
1432: END IF;
1433:
1434: x_return_status := fnd_api.g_ret_sts_success;
1435:
1436: /* We can now come here if it is a lot-serial item and there is
1437: * no row in mtl_transaction_lots_temp if user has not entered
1438: * any lot/serial info for this transaction(Receive, Transfer etc).

Line 1666: x_return_status := fnd_api.g_ret_sts_error;

1662: IF (g_asn_debug = 'Y') THEN
1663: asn_debug.put_line('no_data_found update_rcv_serials_supply');
1664: END IF;
1665:
1666: x_return_status := fnd_api.g_ret_sts_error;
1667:
1668: INSERT INTO po_interface_errors
1669: (interface_type,
1670: interface_transaction_id,

Line 1703: x_return_status := fnd_api.g_ret_sts_unexp_error;

1699: IF (g_asn_debug = 'Y') THEN
1700: asn_debug.put_line('others update_rcv_serials_supply');
1701: END IF;
1702:
1703: x_return_status := fnd_api.g_ret_sts_unexp_error;
1704:
1705: INSERT INTO po_interface_errors
1706: (interface_type,
1707: interface_transaction_id,

Line 1760: x_return_status := fnd_api.g_ret_sts_success;

1756: asn_debug.put_line('p_supply_type_code ' || p_supply_type_code);
1757: asn_debug.put_line('p_supply_source_id ' || p_supply_source_id);
1758: END IF;
1759:
1760: x_return_status := fnd_api.g_ret_sts_success;
1761:
1762: /* We can now come here if it is a lot-serial item and there is
1763: * no row in mtl_transaction_lots_temp if user has not entered
1764: * any lot/serial info for this transaction(Receive, Transfer etc).

Line 1905: x_return_status := fnd_api.g_ret_sts_error;

1901: IF (g_asn_debug = 'Y') THEN
1902: asn_debug.put_line('no_data_found insert_lots_supply ');
1903: END IF;
1904:
1905: x_return_status := fnd_api.g_ret_sts_error;
1906: RAISE;
1907: WHEN OTHERS THEN
1908: IF (g_asn_debug = 'Y') THEN
1909: asn_debug.put_line('others insert_lots_supply ');

Line 1912: x_return_status := fnd_api.g_ret_sts_unexp_error;

1908: IF (g_asn_debug = 'Y') THEN
1909: asn_debug.put_line('others insert_lots_supply ');
1910: END IF;
1911:
1912: x_return_status := fnd_api.g_ret_sts_unexp_error;
1913: RAISE;
1914: END insert_lot_supply;
1915:
1916: PROCEDURE insert_serial_supply(

Line 1943: x_return_status := fnd_api.g_ret_sts_success;

1939: asn_debug.put_line('p_supply_type_code ' || p_supply_type_code);
1940: asn_debug.put_line('p_supply_source_id ' || p_supply_source_id);
1941: END IF;
1942:
1943: x_return_status := fnd_api.g_ret_sts_success;
1944:
1945: /* We can now come here if it is a lot-serial item and there is
1946: * no row in mtl_transaction_lots_temp if user has not entered
1947: * any lot/serial info for this transaction(Receive, Transfer etc).

Line 2053: x_return_status := fnd_api.g_ret_sts_error;

2049: IF (g_asn_debug = 'Y') THEN
2050: asn_debug.put_line(' no_data_found insert_serial_supply');
2051: END IF;
2052:
2053: x_return_status := fnd_api.g_ret_sts_error;
2054: RAISE;
2055: WHEN OTHERS THEN
2056: IF (g_asn_debug = 'Y') THEN
2057: asn_debug.put_line(' others insert_serial_supply');

Line 2060: x_return_status := fnd_api.g_ret_sts_unexp_error;

2056: IF (g_asn_debug = 'Y') THEN
2057: asn_debug.put_line(' others insert_serial_supply');
2058: END IF;
2059:
2060: x_return_status := fnd_api.g_ret_sts_unexp_error;
2061: RAISE;
2062: END insert_serial_supply;
2063:
2064: PROCEDURE insert_lot_transactions(

Line 2087: x_return_status := fnd_api.g_ret_sts_success;

2083: asn_debug.put_line('p_correction_transaction_id ' || p_correction_transaction_id);
2084: asn_debug.put_line('p_negate_qty ' || p_negate_qty);
2085: END IF;
2086:
2087: x_return_status := fnd_api.g_ret_sts_success;
2088:
2089: /* We can now come here if it is a lot-serial item and there is
2090: * no row in mtl_transaction_lots_temp if user has not entered
2091: * any lot/serial info for this transaction(Receive, Transfer etc).

Line 2208: x_return_status := fnd_api.g_ret_sts_error;

2204: IF (g_asn_debug = 'Y') THEN
2205: asn_debug.put_line('no_data_found insert_lot_transactions ');
2206: END IF;
2207:
2208: x_return_status := fnd_api.g_ret_sts_error;
2209: RAISE;
2210: WHEN OTHERS THEN
2211: IF (g_asn_debug = 'Y') THEN
2212: asn_debug.put_line('others insert_lot_transactions ');

Line 2215: x_return_status := fnd_api.g_ret_sts_unexp_error;

2211: IF (g_asn_debug = 'Y') THEN
2212: asn_debug.put_line('others insert_lot_transactions ');
2213: END IF;
2214:
2215: x_return_status := fnd_api.g_ret_sts_unexp_error;
2216: RAISE;
2217: END insert_lot_transactions;
2218:
2219: PROCEDURE validate_lpn_groups(

Line 2254: fnd_api.g_true,

2250: asn_debug.put_line('Before calling inv api ');
2251: END IF;
2252:
2253: l_return := inv_rcv_integration_apis.validate_lpn_info(1.0,
2254: fnd_api.g_true,
2255: l_ret_status,
2256: l_msg_cnt,
2257: l_msg_data,
2258: inv_rcv_integration_apis.g_exists_or_create,

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

2262: IF (g_asn_debug = 'Y') THEN
2263: asn_debug.put_line('After calling inv api ');
2264: END IF;
2265:
2266: --If l_ret_status <> fnd_api.g_ret_sts_success then --
2267: IF (l_return <> TRUE) THEN --{
2268: IF (g_asn_debug = 'Y') THEN
2269: asn_debug.put_line('l_return is false ');
2270: END IF;