APPS.CSP_PC_FORM_PICKHEADERS dependencies on CSP_PICKLIST_HEADERS

Line 81: From csp_picklist_headers

77: l_last_update_login NUMBER := p_last_update_login;
78: l_last_updated_by NUMBER := p_last_updated_by;
79: Cursor l_Get_Creation_Date_Csr Is
80: Select creation_date
81: From csp_picklist_headers
82: Where picklist_header_id = px_PICKLIST_HEADER_ID;
83:
84: BEGIN
85: SAVEPOINT Validate_And_Write_PUB;

Line 113: FROM CSP_PICKLIST_HEADERS

109: IF nvl(px_picklist_header_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
110: -- check whethter the px_picklist_header_id already exists.
111: BEGIN
112: SELECT picklist_header_id INTO l_check_existence
113: FROM CSP_PICKLIST_HEADERS
114: WHERE picklist_header_id = px_picklist_header_id
115: AND organization_id = p_organization_id;
116:
117: fnd_message.set_name ('CSP', 'CSP_DUPLICATE_RECORD');

Line 128: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);

124: WHEN OTHERS THEN
125: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
126: fnd_message.set_token('ERR_FIELD', 'px_picklist_header_id', FALSE);
127: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
128: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
129: FND_MSG_PUB.ADD;
130: RAISE EXCP_USER_DEFINED;
131: END;
132: END IF;

Line 222: from csp_picklist_headers

218: RAISE EXCP_USER_DEFINED;
219: ELSE
220: BEGIN
221: select picklist_header_id into l_check_existence
222: from csp_picklist_headers
223: where picklist_header_id = px_picklist_header_id;
224: EXCEPTION
225: WHEN NO_DATA_FOUND THEN
226: fnd_message.set_name('CSP', 'CSP_INVALID_PICKLIST_HEADER');

Line 234: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);

230: WHEN OTHERS THEN
231: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
232: fnd_message.set_token('ERR_FIELD', 'px_picklist_header_id', FALSE);
233: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
234: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
235: FND_MSG_PUB.ADD;
236: RAISE EXCP_USER_DEFINED;
237: END;
238: END IF;

Line 293: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);

289: Close l_Get_Creation_Date_Csr;
290: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
291: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);
292: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
293: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
294: FND_MSG_PUB.ADD;
295: RAISE EXCP_USER_DEFINED;
296: End if;
297: Close l_Get_Creation_Date_Csr;

Line 313: from csp_picklist_headers

309: RAISE EXCP_USER_DEFINED;
310: ELSE
311: BEGIN
312: select picklist_header_id/0 into l_check_existence
313: from csp_picklist_headers
314: where picklist_header_id = px_picklist_header_id;
315: EXCEPTION
316: WHEN NO_DATA_FOUND THEN
317: fnd_message.set_name('CSP', 'CSP_INVALID_PICKLIST_HEADER');

Line 325: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);

321: WHEN OTHERS THEN
322: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
323: fnd_message.set_token('ERR_FIELD', 'px_picklist_header_id', FALSE);
324: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
325: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
326: FND_MSG_PUB.ADD;
327: RAISE EXCP_USER_DEFINED;
328: END;
329: END IF;