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

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

51: l_remain_qty NUMBER;
52: l_ship_qty NUMBER;
53: l_msg_count NUMBER;
54: l_msg_data VARCHAR2(240);
55: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
56: l_relieve_all VARCHAR2(1);
57: l_api_name CONSTANT VARCHAR2(30) := 'rsv_relief';
58: l_stmt VARCHAR2(10) := '0';
59: -- begin declaration for 3347075

Line 117: l_miss_char := fnd_api.g_miss_char;

113: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
114: BEGIN
115: l_stmt := '1';
116: -- Begin changes for bug 3347075
117: l_miss_char := fnd_api.g_miss_char;
118: l_miss_num := fnd_api.g_miss_num;
119: -- End changes for bug 3347075
120: x_return_status := fnd_api.g_ret_sts_success;
121:

Line 118: l_miss_num := fnd_api.g_miss_num;

114: BEGIN
115: l_stmt := '1';
116: -- Begin changes for bug 3347075
117: l_miss_char := fnd_api.g_miss_char;
118: l_miss_num := fnd_api.g_miss_num;
119: -- End changes for bug 3347075
120: x_return_status := fnd_api.g_ret_sts_success;
121:
122: IF (p_qty_at_puom IS NULL OR p_qty_at_puom < 0) THEN

Line 120: x_return_status := fnd_api.g_ret_sts_success;

116: -- Begin changes for bug 3347075
117: l_miss_char := fnd_api.g_miss_char;
118: l_miss_num := fnd_api.g_miss_num;
119: -- End changes for bug 3347075
120: x_return_status := fnd_api.g_ret_sts_success;
121:
122: IF (p_qty_at_puom IS NULL OR p_qty_at_puom < 0) THEN
123: x_return_status := fnd_api.g_ret_sts_success;
124: RETURN;

Line 123: x_return_status := fnd_api.g_ret_sts_success;

119: -- End changes for bug 3347075
120: x_return_status := fnd_api.g_ret_sts_success;
121:
122: IF (p_qty_at_puom IS NULL OR p_qty_at_puom < 0) THEN
123: x_return_status := fnd_api.g_ret_sts_success;
124: RETURN;
125: END IF;
126:
127: l_stmt := '2';

Line 715: l_relieve_all := fnd_api.g_true;

711:
712: l_stmt := '12';
713:
714: IF l_qty_to_relieve = l_qty_reserved THEN
715: l_relieve_all := fnd_api.g_true;
716: IF (l_debug = 1) THEN
717: debug_print(' relieve all');
718: END IF;
719: ELSE

Line 720: l_relieve_all := fnd_api.g_false;

716: IF (l_debug = 1) THEN
717: debug_print(' relieve all');
718: END IF;
719: ELSE
720: l_relieve_all := fnd_api.g_false;
721: IF (l_debug = 1) THEN
722: debug_print('dont relieve all');
723: END IF;
724: END IF;

Line 734: p_init_msg_lst => fnd_api.g_false,

730: END IF;
731:
732: inv_reservation_pvt.relieve_reservation
733: (p_api_version_number => 1.0,
734: p_init_msg_lst => fnd_api.g_false,
735: x_return_status => l_return_status,
736: x_msg_count => l_msg_count,
737: x_msg_data => l_msg_data,
738: p_rsv_rec => l_rsv_rec,

Line 743: p_validation_flag => fnd_api.g_true,

739: p_primary_relieved_quantity => l_qty_to_relieve,
740: p_secondary_relieved_quantity => NULL, -- INVCONV
741: p_relieve_all => l_relieve_all,
742: p_original_serial_number => l_dummy_serial_numbers,
743: p_validation_flag => fnd_api.g_true,
744: x_primary_relieved_quantity => l_qty_relieved,
745: x_secondary_relieved_quantity => l_secondary_qty_relieved, -- INVCONV
746: x_primary_remain_quantity => l_remain_qty,
747: x_secondary_remain_quantity => l_secondary_remain_qty -- INVCONV

Line 750: IF l_return_status = fnd_api.g_ret_sts_error THEN

746: x_primary_remain_quantity => l_remain_qty,
747: x_secondary_remain_quantity => l_secondary_remain_qty -- INVCONV
748: );
749:
750: IF l_return_status = fnd_api.g_ret_sts_error THEN
751: RAISE fnd_api.g_exc_error;
752: END IF ;
753:
754: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 751: RAISE fnd_api.g_exc_error;

747: x_secondary_remain_quantity => l_secondary_remain_qty -- INVCONV
748: );
749:
750: IF l_return_status = fnd_api.g_ret_sts_error THEN
751: RAISE fnd_api.g_exc_error;
752: END IF ;
753:
754: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
755: RAISE fnd_api.g_exc_unexpected_error;

Line 754: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

750: IF l_return_status = fnd_api.g_ret_sts_error THEN
751: RAISE fnd_api.g_exc_error;
752: END IF ;
753:
754: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
755: RAISE fnd_api.g_exc_unexpected_error;
756: END IF;
757:
758: l_stmt := '14';

Line 755: RAISE fnd_api.g_exc_unexpected_error;

751: RAISE fnd_api.g_exc_error;
752: END IF ;
753:
754: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
755: RAISE fnd_api.g_exc_unexpected_error;
756: END IF;
757:
758: l_stmt := '14';
759:

Line 805: WHEN fnd_api.g_exc_error THEN

801:
802: x_return_status := l_return_status;
803:
804: EXCEPTION
805: WHEN fnd_api.g_exc_error THEN
806: ROLLBACK TO trx_relieve_sa;
807: x_return_status := fnd_api.g_ret_sts_error;
808:
809: l_stmt := 'Stmt' || l_stmt;

Line 807: x_return_status := fnd_api.g_ret_sts_error;

803:
804: EXCEPTION
805: WHEN fnd_api.g_exc_error THEN
806: ROLLBACK TO trx_relieve_sa;
807: x_return_status := fnd_api.g_ret_sts_error;
808:
809: l_stmt := 'Stmt' || l_stmt;
810: fnd_message.set_name('INV', 'INV-Request failed');
811: fnd_message.set_token('ENTITY',l_api_name);

Line 820: WHEN fnd_api.g_exc_unexpected_error THEN

816: fnd_msg_pub.count_and_get
817: ( p_count => x_msg_count
818: , p_data => x_msg_data
819: );
820: WHEN fnd_api.g_exc_unexpected_error THEN
821: ROLLBACK TO trx_relieve_sa;
822: x_return_status := fnd_api.g_ret_sts_unexp_error ;
823:
824: l_stmt := 'Stmt' || l_stmt;

Line 822: x_return_status := fnd_api.g_ret_sts_unexp_error ;

818: , p_data => x_msg_data
819: );
820: WHEN fnd_api.g_exc_unexpected_error THEN
821: ROLLBACK TO trx_relieve_sa;
822: x_return_status := fnd_api.g_ret_sts_unexp_error ;
823:
824: l_stmt := 'Stmt' || l_stmt;
825: fnd_message.set_name('INV', 'INV-Request failed');
826: fnd_message.set_token('ENTITY',l_api_name);

Line 837: x_return_status := fnd_api.g_ret_sts_unexp_error ;

833: , p_data => x_msg_data
834: );
835: WHEN OTHERS THEN
836: ROLLBACK TO trx_relieve_sa;
837: x_return_status := fnd_api.g_ret_sts_unexp_error ;
838:
839: l_stmt := 'Stmt' || l_stmt;
840: fnd_message.set_name('INV', 'INV-Request failed');
841: fnd_message.set_token('ENTITY',l_api_name);

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

901: l_secondary_remain_qty NUMBER; -- INVCONV
902: l_ship_qty NUMBER;
903: l_msg_count NUMBER;
904: l_msg_data VARCHAR2(240);
905: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
906: l_relieve_all VARCHAR2(1);
907: l_api_name CONSTANT VARCHAR2(30) := 'rsv_relief';
908: l_stmt VARCHAR2(10) := '0';
909: -- begin declaration for 3347075

Line 971: l_miss_char := fnd_api.g_miss_char;

967: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
968: BEGIN
969: l_stmt := '1';
970: -- Begin changes for bug 3347075
971: l_miss_char := fnd_api.g_miss_char;
972: l_miss_num := fnd_api.g_miss_num;
973: -- End changes for bug 3347075
974: x_return_status := fnd_api.g_ret_sts_success;
975:

Line 972: l_miss_num := fnd_api.g_miss_num;

968: BEGIN
969: l_stmt := '1';
970: -- Begin changes for bug 3347075
971: l_miss_char := fnd_api.g_miss_char;
972: l_miss_num := fnd_api.g_miss_num;
973: -- End changes for bug 3347075
974: x_return_status := fnd_api.g_ret_sts_success;
975:
976: IF (p_qty_at_puom IS NULL OR p_qty_at_puom < 0) THEN

Line 974: x_return_status := fnd_api.g_ret_sts_success;

970: -- Begin changes for bug 3347075
971: l_miss_char := fnd_api.g_miss_char;
972: l_miss_num := fnd_api.g_miss_num;
973: -- End changes for bug 3347075
974: x_return_status := fnd_api.g_ret_sts_success;
975:
976: IF (p_qty_at_puom IS NULL OR p_qty_at_puom < 0) THEN
977: x_return_status := fnd_api.g_ret_sts_success;
978: RETURN;

Line 977: x_return_status := fnd_api.g_ret_sts_success;

973: -- End changes for bug 3347075
974: x_return_status := fnd_api.g_ret_sts_success;
975:
976: IF (p_qty_at_puom IS NULL OR p_qty_at_puom < 0) THEN
977: x_return_status := fnd_api.g_ret_sts_success;
978: RETURN;
979: END IF;
980:
981: l_stmt := '2';

Line 989: RAISE fnd_api.g_exc_error;

985: -- INVCONV BEGIN
986: OPEN l_tracking_qty_cur;
987: FETCH l_tracking_qty_cur INTO l_tracking_quantity_ind;
988: IF l_tracking_qty_cur%notfound THEN
989: RAISE fnd_api.g_exc_error;
990: END IF;
991: -- INVCONV END
992:
993: l_total_qty_to_relieve := p_qty_at_puom;

Line 1616: l_relieve_all := fnd_api.g_true;

1612:
1613: l_stmt := '12';
1614:
1615: IF l_qty_to_relieve = l_qty_reserved THEN
1616: l_relieve_all := fnd_api.g_true;
1617: IF (l_debug = 1) THEN
1618: debug_print(' relieve all');
1619: END IF;
1620: ELSE

Line 1621: l_relieve_all := fnd_api.g_false;

1617: IF (l_debug = 1) THEN
1618: debug_print(' relieve all');
1619: END IF;
1620: ELSE
1621: l_relieve_all := fnd_api.g_false;
1622: IF (l_debug = 1) THEN
1623: debug_print('dont relieve all');
1624: END IF;
1625: --Bug 4764790: Query the serials for that reservation id

Line 1661: p_init_msg_lst => fnd_api.g_false,

1657: END IF;
1658:
1659: inv_reservation_pvt.relieve_reservation
1660: (p_api_version_number => 1.0,
1661: p_init_msg_lst => fnd_api.g_false,
1662: x_return_status => l_return_status,
1663: x_msg_count => l_msg_count,
1664: x_msg_data => l_msg_data,
1665: p_rsv_rec => l_rsv_rec,

Line 1670: p_validation_flag => fnd_api.g_true,

1666: p_primary_relieved_quantity => l_qty_to_relieve,
1667: p_secondary_relieved_quantity => NULL, -- INVCONV
1668: p_relieve_all => l_relieve_all,
1669: p_original_serial_number => l_original_serial_numbers,
1670: p_validation_flag => fnd_api.g_true,
1671: x_primary_relieved_quantity => l_qty_relieved,
1672: x_secondary_relieved_quantity => l_secondary_qty_relieved, -- INVCONV
1673: x_primary_remain_quantity => l_remain_qty,
1674: x_secondary_remain_quantity => l_secondary_remain_qty -- INVCONV

Line 1677: IF l_return_status = fnd_api.g_ret_sts_error THEN

1673: x_primary_remain_quantity => l_remain_qty,
1674: x_secondary_remain_quantity => l_secondary_remain_qty -- INVCONV
1675: );
1676:
1677: IF l_return_status = fnd_api.g_ret_sts_error THEN
1678: RAISE fnd_api.g_exc_error;
1679: END IF ;
1680:
1681: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1678: RAISE fnd_api.g_exc_error;

1674: x_secondary_remain_quantity => l_secondary_remain_qty -- INVCONV
1675: );
1676:
1677: IF l_return_status = fnd_api.g_ret_sts_error THEN
1678: RAISE fnd_api.g_exc_error;
1679: END IF ;
1680:
1681: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1682: RAISE fnd_api.g_exc_unexpected_error;

Line 1681: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1677: IF l_return_status = fnd_api.g_ret_sts_error THEN
1678: RAISE fnd_api.g_exc_error;
1679: END IF ;
1680:
1681: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1682: RAISE fnd_api.g_exc_unexpected_error;
1683: END IF;
1684:
1685: l_stmt := '14';

Line 1682: RAISE fnd_api.g_exc_unexpected_error;

1678: RAISE fnd_api.g_exc_error;
1679: END IF ;
1680:
1681: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1682: RAISE fnd_api.g_exc_unexpected_error;
1683: END IF;
1684:
1685: l_stmt := '14';
1686:

Line 1743: WHEN fnd_api.g_exc_error THEN

1739:
1740: x_return_status := l_return_status;
1741:
1742: EXCEPTION
1743: WHEN fnd_api.g_exc_error THEN
1744: ROLLBACK TO trx_relieve_sa;
1745: x_return_status := fnd_api.g_ret_sts_error;
1746:
1747: l_stmt := 'Stmt' || l_stmt;

Line 1745: x_return_status := fnd_api.g_ret_sts_error;

1741:
1742: EXCEPTION
1743: WHEN fnd_api.g_exc_error THEN
1744: ROLLBACK TO trx_relieve_sa;
1745: x_return_status := fnd_api.g_ret_sts_error;
1746:
1747: l_stmt := 'Stmt' || l_stmt;
1748: fnd_message.set_name('INV', 'INV-Request failed');
1749: fnd_message.set_token('ENTITY',l_api_name);

Line 1758: WHEN fnd_api.g_exc_unexpected_error THEN

1754: fnd_msg_pub.count_and_get
1755: ( p_count => x_msg_count
1756: , p_data => x_msg_data
1757: );
1758: WHEN fnd_api.g_exc_unexpected_error THEN
1759: ROLLBACK TO trx_relieve_sa;
1760: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1761:
1762: l_stmt := 'Stmt' || l_stmt;

Line 1760: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1756: , p_data => x_msg_data
1757: );
1758: WHEN fnd_api.g_exc_unexpected_error THEN
1759: ROLLBACK TO trx_relieve_sa;
1760: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1761:
1762: l_stmt := 'Stmt' || l_stmt;
1763: fnd_message.set_name('INV', 'INV-Request failed');
1764: fnd_message.set_token('ENTITY',l_api_name);

Line 1775: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1771: , p_data => x_msg_data
1772: );
1773: WHEN OTHERS THEN
1774: ROLLBACK TO trx_relieve_sa;
1775: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1776:
1777: l_stmt := 'Stmt' || l_stmt;
1778: fnd_message.set_name('INV', 'INV-Request failed');
1779: fnd_message.set_token('ENTITY',l_api_name);