DBA Data[Home] [Help]

APPS.CSD_RECEIVE_PVT dependencies on CSD_RECEIVE_UTIL

Line 25: p_receive_tbl IN csd_receive_util.rcv_tbl_type,

21: )
22: RETURN BOOLEAN;
23:
24: PROCEDURE dump_receive_tbl (
25: p_receive_tbl IN csd_receive_util.rcv_tbl_type,
26: p_level NUMBER,
27: p_module VARCHAR2
28: );
29:

Line 45: /* p_receive_rec CSD_RECEIVE_UTIL.RCV_REC_TYPE Required */

41: /* fnd_api.g_false */
42: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
43: /* validation steps must be done and which steps */
44: /* should be skipped. */
45: /* p_receive_rec CSD_RECEIVE_UTIL.RCV_REC_TYPE Required */
46: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
47: /* fnd_api.g_ret_sts_success (success) */
48: /* fnd_api.g_ret_sts_error (error) */
49: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

Line 62: x_rcv_error_msg_tbl OUT NOCOPY csd_receive_util.rcv_error_msg_tbl,

58: p_validation_level IN NUMBER,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_msg_data OUT NOCOPY VARCHAR2,
62: x_rcv_error_msg_tbl OUT NOCOPY csd_receive_util.rcv_error_msg_tbl,
63: p_receive_tbl IN OUT NOCOPY csd_receive_util.rcv_tbl_type
64: )
65: IS
66: l_api_version_number CONSTANT NUMBER := 1.0;

Line 63: p_receive_tbl IN OUT NOCOPY csd_receive_util.rcv_tbl_type

59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_msg_data OUT NOCOPY VARCHAR2,
62: x_rcv_error_msg_tbl OUT NOCOPY csd_receive_util.rcv_error_msg_tbl,
63: p_receive_tbl IN OUT NOCOPY csd_receive_util.rcv_tbl_type
64: )
65: IS
66: l_api_version_number CONSTANT NUMBER := 1.0;
67: l_api_name CONSTANT VARCHAR2 (30) := 'RECEIVE_ITEM';

Line 73: l_receive_tbl csd_receive_util.rcv_tbl_type;

69: l_request_group_id NUMBER;
70: l_retcode NUMBER;
71:
72: -- subhat, for bug#9058678
73: l_receive_tbl csd_receive_util.rcv_tbl_type;
74: l_counter number := 1;
75: -- end changes,subhat, for bug#9058678
76: BEGIN
77:

Line 129: csd_receive_util.validate_rcv_input

125: LOOP
126: -- subhat, bug#9058678.
127: -- Dont error out entire transaction if one record errors out.
128: BEGIN
129: csd_receive_util.validate_rcv_input
130: (p_validation_level => fnd_api.g_valid_level_full,
131: x_return_status => x_return_status,
132: p_receive_rec => p_receive_tbl (l_index)
133: );

Line 140: csd_receive_util.is_auto_rcv_available

136: RAISE fnd_api.g_exc_error;
137: END IF;
138:
139: p_receive_tbl (l_index).routing_header_id :=
140: csd_receive_util.is_auto_rcv_available
141: (p_receive_tbl (l_index).inventory_item_id,
142: p_receive_tbl (l_index).to_organization_id,
143: p_receive_tbl (l_index).internal_order_flag,
144: p_receive_tbl (l_index).from_organization_id

Line 230: csd_receive_util.check_rcv_errors

226: );
227: END IF;
228:
229: --Call Check_Rcv_Errors to check the errors in the PO_INTERFACE_ERRORS table.
230: csd_receive_util.check_rcv_errors
231: (x_return_status => x_return_status,
232: x_rcv_error_msg_tbl => x_rcv_error_msg_tbl,
233: p_request_group_id => l_request_group_id
234: );

Line 346: /* p_receive_rec CSD_RECEIVE_UTIL.RCV_REC_TYPE Required */

342: /* fnd_api.g_false */
343: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
344: /* validation steps must be done and which steps */
345: /* should be skipped. */
346: /* p_receive_rec CSD_RECEIVE_UTIL.RCV_REC_TYPE Required */
347: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
348: /* fnd_api.g_ret_sts_success (success) */
349: /* fnd_api.g_ret_sts_error (error) */
350: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

Line 362: p_receive_tbl IN csd_receive_util.rcv_tbl_type,

358: p_validation_level IN NUMBER,
359: x_return_status OUT NOCOPY VARCHAR2,
360: x_msg_count OUT NOCOPY NUMBER,
361: x_msg_data OUT NOCOPY VARCHAR2,
362: p_receive_tbl IN csd_receive_util.rcv_tbl_type,
363: x_request_group_id OUT NOCOPY NUMBER
364: )
365: IS
366: pragma AUTONOMOUS_TRANSACTION;

Line 372: p_receive_rec csd_receive_util.rcv_rec_type;

368: l_api_name CONSTANT VARCHAR2 (30)
369: := 'Populate_Rcv_Intf_Tbls';
370: l_hdr_intf_id NUMBER;
371: i NUMBER;
372: p_receive_rec csd_receive_util.rcv_rec_type;
373: l_source_code VARCHAR2 (240);
374: l_source_line_id NUMBER := 1;
375: l_txn_tmp_id NUMBER;
376: l_source_header_id NUMBER := 1;

Line 532: csd_receive_util.get_employee_id (fnd_global.user_id, l_emp_id);

528: 'Inserting transactions interface table data'
529: );
530: END IF;
531:
532: csd_receive_util.get_employee_id (fnd_global.user_id, l_emp_id);
533:
534: --Insert data into the transactions interface table.
535: FOR i IN p_receive_tbl.FIRST .. p_receive_tbl.LAST
536: LOOP

Line 539: csd_receive_util.get_rcv_item_params (p_receive_rec);

535: FOR i IN p_receive_tbl.FIRST .. p_receive_tbl.LAST
536: LOOP
537: p_receive_rec := p_receive_tbl (i);
538: p_receive_rec.employee_id := l_emp_id;
539: csd_receive_util.get_rcv_item_params (p_receive_rec);
540:
541: -- Derive the Org id
542: -- MOAC change Bug#4245577
543: OPEN c_get_org_id (p_receive_rec.order_line_id);

Line 1704: p_receive_tbl IN csd_receive_util.rcv_tbl_type,

1700: /****************************************************************
1701: Dupms the input receive table records in to log
1702: *****************************************************************/
1703: PROCEDURE dump_receive_tbl (
1704: p_receive_tbl IN csd_receive_util.rcv_tbl_type,
1705: p_level NUMBER,
1706: p_module VARCHAR2
1707: )
1708: IS