APPS.CSP_TO_FORM_MOHEADERS dependencies on CSP_MOVEORDER_HEADERS

Line 6: -- the prviate API in the CSP_MOVEORDER_HEADERS_PVT package.

2: /*$Header: cspgtmhb.pls 115.21 2002/11/26 06:53:45 hhaugeru ship $*/
3: -- Start of Comments
4: -- Package name : CSP_TO_FORM_MOMEAHDERS_B
5: -- Purpose : Takes all parameters from the FORM and construct those parameters into a record for calling
6: -- the prviate API in the CSP_MOVEORDER_HEADERS_PVT package.
7: -- History : 11/17/1999, Created by Vernon Lou
8: -- NOTE :
9: -- End of Comments
10:

Line 76: From csp_moveorder_headers

72: l_last_update_login NUMBER := p_last_update_login;
73: l_last_updated_by NUMBER := p_last_updated_by;
74: Cursor l_Get_Creation_Date_Csr Is
75: Select creation_date
76: From csp_moveorder_headers
77: Where header_id = p_header_id;
78: Cursor l_Get_Header_ID_Csr IS
79: Select header_id
80: From csp_moveorder_headers

Line 80: From csp_moveorder_headers

76: From csp_moveorder_headers
77: Where header_id = p_header_id;
78: Cursor l_Get_Header_ID_Csr IS
79: Select header_id
80: From csp_moveorder_headers
81: Where header_id = p_header_id;
82:
83: BEGIN
84: savepoint Validate_And_Write_PUB;

Line 117: -- First we need to validate whether the given header_id already exists in the csp_moveorder_headers.

113: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_header_id', FALSE);
114: FND_MSG_PUB.ADD;
115: RAISE EXCP_USER_DEFINED;
116: ELSE
117: -- First we need to validate whether the given header_id already exists in the csp_moveorder_headers.
118: OPEN l_Get_Header_ID_Csr;
119: FETCH l_Get_Header_ID_Csr INTO l_check_existence;
120: IF l_Get_Header_ID_Csr%NOTFOUND THEN
121: -- Now, validate whether the given header_id exists in the mtl_txn_request_headers table.

Line 206: FROM csp_moveorder_headers

202: ELSE
203: -- Validate whether the given header_id exists in the mtl_txn_request_headers table.
204: BEGIN
205: SELECT header_id INTO l_check_existence
206: FROM csp_moveorder_headers
207: WHERE header_id = p_header_id;
208:
209: EXCEPTION
210: WHEN NO_DATA_FOUND THEN

Line 219: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_HEADERS', FALSE);

215: WHEN OTHERS THEN
216: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
217: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);
218: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
219: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_HEADERS', FALSE);
220: FND_MSG_PUB.ADD;
221: RAISE EXCP_USER_DEFINED;
222:
223: END;

Line 259: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_HEADERS', FALSE);

255: Close l_Get_Creation_Date_Csr;
256: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
257: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);
258: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
259: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_HEADERS', FALSE);
260: FND_MSG_PUB.ADD;
261: RAISE EXCP_USER_DEFINED;
262: End if;
263: Close l_Get_Creation_Date_Csr;

Line 279: FROM csp_moveorder_headers

275: ELSE
276: -- Validate whether the given header_id exists in the mtl_txn_request_headers table.
277: BEGIN
278: SELECT header_id INTO l_check_existence
279: FROM csp_moveorder_headers
280: WHERE header_id = p_header_id;
281:
282: EXCEPTION
283: WHEN NO_DATA_FOUND THEN

Line 292: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_HEADERS', FALSE);

288: WHEN OTHERS THEN
289: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
290: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);
291: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
292: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_HEADERS', FALSE);
293: FND_MSG_PUB.ADD;
294: RAISE EXCP_USER_DEFINED;
295:
296: END;