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.RCV_SHIPMENT_LINES_PKG dependencies on RCV_SHIPMENT_LINES

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 75: FROM RCV_SHIPMENT_LINES

71: X_progress VARCHAR2(4) := '000';
72:
73: CURSOR C IS
74: SELECT *
75: FROM RCV_SHIPMENT_LINES
76: WHERE rowid = X_Rowid
77: FOR UPDATE of Shipment_Line_Id NOWAIT;
78: Recinfo C%ROWTYPE;
79:

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 161: FROM rcv_shipment_lines

157: /* Bug 8899316 */
158:
159: SELECT 'Check for records in RSL'
160: INTO x_temp
161: FROM rcv_shipment_lines
162: where shipment_line_id = x_shipment_line_id;
163:
164: /* Bug 8899316 */
165:

Line 166: update rcv_shipment_lines

162: where shipment_line_id = x_shipment_line_id;
163:
164: /* Bug 8899316 */
165:
166: update rcv_shipment_lines
167: set item_revision = x_item_revision,
168: locator_id = x_stock_locator_id,
169: packing_slip = x_packing_slip,
170: comments = x_comments,

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 210: from rcv_shipment_lines

206: select wf_item_key
207: into l_itemkey
208: from rcv_shipment_headers
209: where shipment_header_id =( select shipment_header_id
210: from rcv_shipment_lines
211: where shipment_line_id= p_shipment_line_id);
212:
213: l_api_name := l_itemkey || ' update_wc_line';
214:

Line 236: FROM rcv_shipment_lines

232: /* Bug 8899316 */
233:
234: SELECT 'Check for records in RSL'
235: INTO x_temp
236: FROM rcv_shipment_lines
237: where shipment_line_id = p_shipment_line_id;
238:
239: /* Bug 8899316 */
240:

Line 241: update rcv_shipment_lines

237: where shipment_line_id = p_shipment_line_id;
238:
239: /* Bug 8899316 */
240:
241: update rcv_shipment_lines
242: set requested_amount = p_requested_amount,
243: material_stored_amount = p_material_stored_amount,
244: amount_shipped = p_amount_shipped,
245: quantity_shipped = p_quantity_shipped,

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 334: from rcv_shipment_lines

330: select wf_item_key
331: into l_itemkey
332: from rcv_shipment_headers
333: where shipment_header_id =( select shipment_header_id
334: from rcv_shipment_lines
335: where shipment_line_id= p_shipment_line_id);
336:
337: l_api_name := l_itemkey || ' update_quantity_amount';
338:

Line 354: from rcv_shipment_lines

350: po_line_location_id
351: into l_orig_qty_shipped,
352: l_orig_amt_shipped,
353: l_line_location_id
354: from rcv_shipment_lines
355: where shipment_line_id = p_shipment_line_id;
356:
357: IF (g_asn_debug = 'Y') THEN
358: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

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 694: from rcv_shipment_lines

690: select wf_item_key
691: into l_itemkey
692: from rcv_shipment_headers
693: where shipment_header_id =( select shipment_header_id
694: from rcv_shipment_lines
695: where shipment_line_id= p_shipment_line_id);
696:
697: l_api_name := l_itemkey || ' delete_line_s';
698:

Line 719: delete from rcv_shipment_lines

715: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
716: 'Before Delete '||p_shipment_line_id);
717: END IF;
718:
719: delete from rcv_shipment_lines
720: where shipment_line_id= p_shipment_line_id;
721:
722: EXCEPTION
723: WHEN OTHERS THEN

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 769: from rcv_shipment_lines

765: select wf_item_key
766: into l_itemkey
767: from rcv_shipment_headers
768: where shipment_header_id =( select shipment_header_id
769: from rcv_shipment_lines
770: where shipment_line_id= p_document_id);
771:
772: l_api_name := l_itemkey || ' update_approval_status';
773:

Line 780: update rcv_shipment_lines

776: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
777: 'Enter LINE update_approval_status');
778: END IF;
779:
780: update rcv_shipment_lines
781: set approval_status = p_approval_status,
782: comments = p_comments,
783: last_update_date = sysdate,
784: last_updated_by = fnd_global.user_id,

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 847: update rcv_shipment_lines

843: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
844: 'material_stored_amount : ' || l_material_stored_amount);
845: END IF;
846:
847: update rcv_shipment_lines
848: set quantity_shipped = quantity_shipped + l_trx_quantity,
849: amount_shipped = amount_shipped + l_trx_amount,
850: requested_amount = requested_amount + l_requested_amount,
851: material_stored_amount = material_stored_amount + l_material_stored_amount

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;