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 1613: l_relieve_all := fnd_api.g_true;

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

Line 1618: l_relieve_all := fnd_api.g_false;

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

Line 1658: p_init_msg_lst => fnd_api.g_false,

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

Line 1667: p_validation_flag => fnd_api.g_true,

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

Line 1674: IF l_return_status = fnd_api.g_ret_sts_error THEN

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

Line 1675: RAISE fnd_api.g_exc_error;

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

Line 1678: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1674: IF l_return_status = fnd_api.g_ret_sts_error THEN
1675: RAISE fnd_api.g_exc_error;
1676: END IF ;
1677:
1678: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1679: RAISE fnd_api.g_exc_unexpected_error;
1680: END IF;
1681:
1682: l_stmt := '14';

Line 1679: RAISE fnd_api.g_exc_unexpected_error;

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

Line 1740: WHEN fnd_api.g_exc_error THEN

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

Line 1742: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1755: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 1757: x_return_status := fnd_api.g_ret_sts_unexp_error ;

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

Line 1772: x_return_status := fnd_api.g_ret_sts_unexp_error ;

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