APPS.CSP_PC_FORM_MTLTXNS dependencies on CSP_MOVEORDER_HEADERS

Line 1603: l_autoreceipt_flag csp_moveorder_headers.autoreceipt_flag%type;

1599: ELSE
1600: DECLARE
1601: l_header_id NUMBER;
1602: l_move_order_line_id NUMBER;
1603: l_autoreceipt_flag csp_moveorder_headers.autoreceipt_flag%type;
1604:
1605: -- validate whether the move_order_line_id exists
1606: BEGIN
1607: select move_order_line_id into l_move_order_line_id

Line 1619: from csp_moveorder_headers

1615: where line_id = l_move_order_line_id;
1616:
1617: -- validate whether the move order is under manual receipt, if not, raise an exception.
1618: select autoreceipt_flag into l_autoreceipt_flag
1619: from csp_moveorder_headers
1620: where header_id = l_header_id;
1621:
1622: IF l_autoreceipt_flag <> 'Y' THEN
1623: fnd_message.set_name ('CSP', 'CSP_INVALID_AUTORECEIPT');

Line 1639: fnd_message.set_token('TABLE', 'csp_moveorder_headers', TRUE);

1635: WHEN OTHERS THEN
1636: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1637: fnd_message.set_token('ERR_FIELD', 'autoreceipt_flag', TRUE);
1638: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1639: fnd_message.set_token('TABLE', 'csp_moveorder_headers', TRUE);
1640: FND_MSG_PUB.ADD;
1641: RAISE EXCP_USER_DEFINED;
1642: END;
1643: END IF;