DBA Data[Home] [Help]

APPS.CSP_PC_FORM_PICKLINES dependencies on CSP_MOVEORDER_LINES

Line 162: from csp_moveorder_lines

158: RAISE EXCP_USER_DEFINED;
159: ELSE
160: BEGIN
161: select line_id into l_check_existence
162: from csp_moveorder_lines
163: where line_id = p_line_id;
164: Exception
165: WHEN NO_DATA_FOUND THEN
166: fnd_message.set_name ('CSP', 'CSP_INVALID_MOVEORDER_LINE');

Line 177: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);

173: WHEN OTHERS THEN
174: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
175: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
176: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
177: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);
178: FND_MSG_PUB.ADD;
179: RAISE EXCP_USER_DEFINED;
180: END;
181: END IF;

Line 419: from csp_moveorder_lines

415: -- Validate the move order line id
416: IF nvl(p_line_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
417: BEGIN
418: select line_id into l_check_existence
419: from csp_moveorder_lines
420: where line_id = p_line_id;
421: EXCEPTION
422: WHEN NO_DATA_FOUND THEN
423: fnd_message.set_name ('CSP', 'CSP_INVALID_MOVEORDER_LINE');

Line 434: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);

430: WHEN OTHERS THEN
431: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
432: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
433: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
434: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);
435: FND_MSG_PUB.ADD;
436: RAISE EXCP_USER_DEFINED;
437: END;
438: END IF;