DBA Data[Home] [Help]

APPS.RCV_SHIPMENT_LINES_PKG dependencies on RCV_SHIPMENT_LINES_PKG

Line 1: PACKAGE BODY RCV_SHIPMENT_LINES_PKG as

1: PACKAGE BODY RCV_SHIPMENT_LINES_PKG as
2: /* $Header: RCVTISLB.pls 120.4.12010000.7 2010/04/12 06:43:12 yjian ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'RCV_SHIPMENT_LINES_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(30) := 'RCVTISLB.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'RCV_SHIPMENT_LINES_PKG';

1: PACKAGE BODY RCV_SHIPMENT_LINES_PKG as
2: /* $Header: RCVTISLB.pls 120.4.12010000.7 2010/04/12 06:43:12 yjian ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'RCV_SHIPMENT_LINES_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(30) := 'RCVTISLB.pls';
6: g_module_prefix CONSTANT VARCHAR2(50) := 'pos.plsql.' || g_pkg_name || '.';
7:
8: g_asn_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

Line 28: l_module := 'pos.plsql.rcv_shipment_lines_pkg.'||p_api_name;

24: LEVEL_PROCEDURE CONSTANT NUMBER := 2;
25: LEVEL_STATEMENT CONSTANT NUMBER := 1;
26: */
27:
28: l_module := 'pos.plsql.rcv_shipment_lines_pkg.'||p_api_name;
29: IF(g_asn_debug = 'Y')THEN
30: IF ( p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
31: FND_LOG.string(LOG_LEVEL => p_level,
32: MODULE => l_module,

Line 138: po_message_s.sql_error('RCV_SHIPMENT_LINES_PKG.Lock_Line_s', x_progress, sqlcode);

134: end if;
135:
136: EXCEPTION
137: WHEN OTHERS THEN
138: po_message_s.sql_error('RCV_SHIPMENT_LINES_PKG.Lock_Line_s', x_progress, sqlcode);
139: RAISE;
140:
141: END Lock_Line_s;
142:

Line 187: po_message_s.sql_error('RCV_SHIPMENT_LINES_PKG.Update_Line_s', x_progress, sqlcode);

183:
184:
185: EXCEPTION
186: WHEN OTHERS THEN
187: po_message_s.sql_error('RCV_SHIPMENT_LINES_PKG.Update_Line_s', x_progress, sqlcode);
188: RAISE;
189:
190: END Update_Line_s;
191:

Line 268: po_message_s.sql_error('RCV_SHIPMENT_LINES_PKG.Update_wc_line', x_progress, sqlcode);

264: return;
265:
266: EXCEPTION
267: WHEN OTHERS THEN
268: po_message_s.sql_error('RCV_SHIPMENT_LINES_PKG.Update_wc_line', x_progress, sqlcode);
269: RAISE;
270:
271: END Update_wc_line;
272:

Line 675: po_message_s.sql_error('RCV_SHIPMENT_LINES_PKG.Update_quantity_amount', x_progress, sqlcode);

671: end if;
672:
673: EXCEPTION
674: WHEN OTHERS THEN
675: po_message_s.sql_error('RCV_SHIPMENT_LINES_PKG.Update_quantity_amount', x_progress, sqlcode);
676: RAISE;
677:
678: END Update_quantity_amount;
679:

Line 724: po_message_s.sql_error('RCV_SHIPMENT_LINES_PKG.delete_line_s', x_progress, sqlcode);

720: where shipment_line_id= p_shipment_line_id;
721:
722: EXCEPTION
723: WHEN OTHERS THEN
724: po_message_s.sql_error('RCV_SHIPMENT_LINES_PKG.delete_line_s', x_progress, sqlcode);
725: RAISE;
726:
727: END delete_line_s;
728:

Line 796: po_message_s.sql_error('RCV_SHIPMENT_LINES_PKG.update_approval_status', x_progress, sqlcode);

792: END IF;
793:
794: EXCEPTION
795: WHEN OTHERS THEN
796: po_message_s.sql_error('RCV_SHIPMENT_LINES_PKG.update_approval_status', x_progress, sqlcode);
797: RAISE;
798:
799: END update_approval_status;
800:

Line 815: l_api_name := 'rcv_shipment_lines_pkg.correct_wc_line';

811: l_material_stored_amount NUMBER;
812:
813: BEGIN
814:
815: l_api_name := 'rcv_shipment_lines_pkg.correct_wc_line';
816:
817: SELECT Nvl(quantity,0),
818: Nvl(amount,0),
819: Nvl(requested_amount,0),

Line 863: po_message_s.sql_error('RCV_SHIPMENT_LINES_PKG.correct_wc_line', x_progress, sqlcode);

859: return;
860:
861: EXCEPTION
862: WHEN OTHERS THEN
863: po_message_s.sql_error('RCV_SHIPMENT_LINES_PKG.correct_wc_line', x_progress, sqlcode);
864: RAISE;
865:
866: END correct_wc_line;
867: /* Bug 9534775 */

Line 894: l_api_name := 'rcv_shipment_lines_pkg.get_wc_available_quantity';

890: AND transaction_type = p_parent_transaction_type;
891:
892: BEGIN
893: x_progress := 10;
894: l_api_name := 'rcv_shipment_lines_pkg.get_wc_available_quantity';
895: x_progress := 20;
896: IF (g_asn_debug = 'Y') THEN
897: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
898: 'Enter get_wc_available_quantity');

Line 935: po_message_s.sql_error('RCV_SHIPMENT_LINES_PKG.get_wc_available_quantity', x_progress, sqlcode);

931: 'Leave get_wc_available_quantity');
932: END IF;
933: EXCEPTION
934: WHEN OTHERS THEN
935: po_message_s.sql_error('RCV_SHIPMENT_LINES_PKG.get_wc_available_quantity', x_progress, sqlcode);
936: RAISE;
937:
938: END get_wc_correct_quantity;
939:

Line 967: l_api_name := 'rcv_shipment_lines_pkg.get_wc_available_amount';

963: AND transaction_type = p_parent_transaction_type;
964:
965: BEGIN
966: x_progress := 10;
967: l_api_name := 'rcv_shipment_lines_pkg.get_wc_available_amount';
968: x_progress := 20;
969: IF (g_asn_debug = 'Y') THEN
970: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
971: 'Enter get_wc_available_amount');

Line 1005: po_message_s.sql_error('RCV_SHIPMENT_LINES_PKG.get_wc_available_amount', x_progress, sqlcode);

1001: 'Leave get_wc_available_amount');
1002: END IF;
1003: EXCEPTION
1004: WHEN OTHERS THEN
1005: po_message_s.sql_error('RCV_SHIPMENT_LINES_PKG.get_wc_available_amount', x_progress, sqlcode);
1006: RAISE;
1007:
1008: END get_wc_correct_amount;
1009:

Line 1010: END RCV_SHIPMENT_LINES_PKG;

1006: RAISE;
1007:
1008: END get_wc_correct_amount;
1009:
1010: END RCV_SHIPMENT_LINES_PKG;