DBA Data[Home] [Help]

APPS.CS_CORE_UTIL dependencies on CS_CORE_UTIL

Line 1: PACKAGE BODY CS_Core_UTIL AS

1: PACKAGE BODY CS_Core_UTIL AS
2: /* $Header: csucoreb.pls 120.4 2006/06/21 19:25:09 spusegao noship $ */
3:
4: ------------------------------------------------------------------------------
5: -- Procedure : Add_Desc_Flex_Msg

Line 163: cs_core_util.add_invalid_argument_msg

159: EXCEPTION
160: WHEN no_data_found THEN
161: x_return_status := fnd_api.g_ret_sts_error;
162: IF p_contact_firstname <> fnd_api.g_miss_char THEN
163: cs_core_util.add_invalid_argument_msg
164: ( p_token_an => p_api_name,
165: p_token_v => p_contact_lastname||', '||p_contact_firstname,
166: p_token_p => p_parameter_name_ln||', '||p_parameter_name_fn );
167: ELSE

Line 168: cs_core_util.add_invalid_argument_msg

164: ( p_token_an => p_api_name,
165: p_token_v => p_contact_lastname||', '||p_contact_firstname,
166: p_token_p => p_parameter_name_ln||', '||p_parameter_name_fn );
167: ELSE
168: cs_core_util.add_invalid_argument_msg
169: ( p_token_an => p_api_name,
170: p_token_v => p_contact_lastname,
171: p_token_p => p_parameter_name_ln );
172: END IF;

Line 176: cs_core_util.add_duplicate_value_msg

172: END IF;
173: WHEN too_many_rows THEN
174: x_return_status := fnd_api.g_ret_sts_error;
175: IF p_contact_firstname <> fnd_api.g_miss_char THEN
176: cs_core_util.add_duplicate_value_msg
177: ( p_token_an => p_api_name,
178: p_token_p => p_parameter_name_ln||', '||p_parameter_name_fn );
179: ELSE
180: cs_core_util.add_duplicate_value_msg

Line 180: cs_core_util.add_duplicate_value_msg

176: cs_core_util.add_duplicate_value_msg
177: ( p_token_an => p_api_name,
178: p_token_p => p_parameter_name_ln||', '||p_parameter_name_fn );
179: ELSE
180: cs_core_util.add_duplicate_value_msg
181: ( p_token_an => p_api_name,
182: p_token_p => p_parameter_name_ln );
183: END IF;
184: END Convert_Contact_To_ID;

Line 210: cs_core_util.add_invalid_argument_msg(p_api_name,

206: WHERE party_number = p_customer_number;
207: EXCEPTION
208: WHEN no_data_found THEN
209: x_return_status := fnd_api.g_ret_sts_error;
210: cs_core_util.add_invalid_argument_msg(p_api_name,
211: p_customer_number,
212: p_parameter_name_nb);
213: END;
214: IF p_customer_name <> fnd_api.g_miss_char THEN

Line 215: cs_core_util.add_param_ignored_msg(p_api_name, p_parameter_name_n);

211: p_customer_number,
212: p_parameter_name_nb);
213: END;
214: IF p_customer_name <> fnd_api.g_miss_char THEN
215: cs_core_util.add_param_ignored_msg(p_api_name, p_parameter_name_n);
216: END IF;
217: ELSE
218: BEGIN
219: SELECT party_id INTO x_customer_id

Line 225: cs_core_util.add_invalid_argument_msg(p_api_name, p_customer_name,

221: WHERE party_name = p_customer_name;
222: EXCEPTION
223: WHEN no_data_found THEN
224: x_return_status := fnd_api.g_ret_sts_error;
225: cs_core_util.add_invalid_argument_msg(p_api_name, p_customer_name,
226: p_parameter_name_n);
227: WHEN too_many_rows THEN
228: x_return_status := fnd_api.g_ret_sts_error;
229: cs_core_util.add_duplicate_value_msg(p_api_name,

Line 229: cs_core_util.add_duplicate_value_msg(p_api_name,

225: cs_core_util.add_invalid_argument_msg(p_api_name, p_customer_name,
226: p_parameter_name_n);
227: WHEN too_many_rows THEN
228: x_return_status := fnd_api.g_ret_sts_error;
229: cs_core_util.add_duplicate_value_msg(p_api_name,
230: p_parameter_name_n);
231: END;
232: END IF;
233: END Convert_Customer_To_ID;

Line 285: cs_core_util.add_invalid_argument_msg(p_api_name,

281: WHERE employee_number = p_employee_number;
282: EXCEPTION
283: WHEN no_data_found THEN
284: x_return_status := fnd_api.g_ret_sts_error;
285: cs_core_util.add_invalid_argument_msg(p_api_name,
286: p_employee_number,
287: p_parameter_name_nb);
288: WHEN too_many_rows THEN
289: x_return_status := fnd_api.g_ret_sts_error;

Line 290: cs_core_util.add_duplicate_value_msg(p_api_name,

286: p_employee_number,
287: p_parameter_name_nb);
288: WHEN too_many_rows THEN
289: x_return_status := fnd_api.g_ret_sts_error;
290: cs_core_util.add_duplicate_value_msg(p_api_name,
291: p_parameter_name_nb);
292: END;
293: IF p_employee_name <> fnd_api.g_miss_char THEN
294: cs_core_util.add_param_ignored_msg(p_api_name, p_parameter_name_n);

Line 294: cs_core_util.add_param_ignored_msg(p_api_name, p_parameter_name_n);

290: cs_core_util.add_duplicate_value_msg(p_api_name,
291: p_parameter_name_nb);
292: END;
293: IF p_employee_name <> fnd_api.g_miss_char THEN
294: cs_core_util.add_param_ignored_msg(p_api_name, p_parameter_name_n);
295: END IF;
296: ELSE
297: BEGIN
298: SELECT person_id INTO x_employee_id

Line 304: cs_core_util.add_invalid_argument_msg(p_api_name, p_employee_name,

300: WHERE full_name = p_employee_name;
301: EXCEPTION
302: WHEN no_data_found THEN
303: x_return_status := fnd_api.g_ret_sts_error;
304: cs_core_util.add_invalid_argument_msg(p_api_name, p_employee_name,
305: p_parameter_name_n);
306: WHEN too_many_rows THEN
307: x_return_status := fnd_api.g_ret_sts_error;
308: cs_core_util.add_duplicate_value_msg(p_api_name,

Line 308: cs_core_util.add_duplicate_value_msg(p_api_name,

304: cs_core_util.add_invalid_argument_msg(p_api_name, p_employee_name,
305: p_parameter_name_n);
306: WHEN too_many_rows THEN
307: x_return_status := fnd_api.g_ret_sts_error;
308: cs_core_util.add_duplicate_value_msg(p_api_name,
309: p_parameter_name_n);
310: END;
311: END IF;
312: END Convert_Employee_To_ID;

Line 336: cs_core_util.add_invalid_argument_msg(p_api_name, p_meaning,

332: AND meaning = p_meaning;
333: EXCEPTION
334: WHEN no_data_found THEN
335: x_return_status := fnd_api.g_ret_sts_error;
336: cs_core_util.add_invalid_argument_msg(p_api_name, p_meaning,
337: p_parameter_name);
338: END Convert_Lookup_To_Code;
339:
340: ------------------------------------------------------------------------------

Line 360: cs_core_util.add_invalid_argument_msg(p_api_name, p_org_name,

356: WHERE name = p_org_name;
357: EXCEPTION
358: WHEN no_data_found THEN
359: x_return_status := fnd_api.g_ret_sts_error;
360: cs_core_util.add_invalid_argument_msg(p_api_name, p_org_name,
361: p_parameter_name);
362: WHEN too_many_rows THEN
363: x_return_status := fnd_api.g_ret_sts_error;
364: cs_core_util.add_duplicate_value_msg(p_api_name, p_parameter_name);

Line 364: cs_core_util.add_duplicate_value_msg(p_api_name, p_parameter_name);

360: cs_core_util.add_invalid_argument_msg(p_api_name, p_org_name,
361: p_parameter_name);
362: WHEN too_many_rows THEN
363: x_return_status := fnd_api.g_ret_sts_error;
364: cs_core_util.add_duplicate_value_msg(p_api_name, p_parameter_name);
365: END Convert_Org_To_ID;
366:
367: ------------------------------------------------------------------------------
368: -- Procedure : Default_Common_Attributes

Line 420: IF cs_core_util.is_multiorg_enabled THEN

416: -- If Multi-Org is enabled, get the default from the session variable
417: -- CLIENT_INFO. If it is not set, get the default from the ORG_ID profile
418: -- option.
419: --
420: IF cs_core_util.is_multiorg_enabled THEN
421: IF p_org_id = fnd_api.g_miss_num THEN
422: SELECT To_number(Decode(substrb(userenv('CLIENT_INFO'),1,1), ' ',
423: NULL, substrb(userenv('CLIENT_INFO'),1,10)))
424: INTO p_org_id

Line 557: cs_core_util.add_invalid_argument_msg(p_api_name, p_comment_id,

553: WHERE comment_id = p_comment_id;
554: EXCEPTION
555: WHEN no_data_found THEN
556: x_return_status := fnd_api.g_ret_sts_error;
557: cs_core_util.add_invalid_argument_msg(p_api_name, p_comment_id,
558: p_parameter_name);
559: END Validate_Comment;
560: **********************************/
561: ------------------------------------------------------------------------------

Line 1165: cs_core_util.add_invalid_argument_msg(p_api_name, p_org_id,

1161: WHERE organization_id = p_org_id;
1162: EXCEPTION
1163: WHEN no_data_found THEN
1164: x_return_status := fnd_api.g_ret_sts_error;
1165: cs_core_util.add_invalid_argument_msg(p_api_name, p_org_id,
1166: p_parameter_name);
1167: END Validate_Operating_Unit;
1168:
1169: ------------------------------------------------------------------------------

Line 1195: cs_core_util.add_invalid_argument_msg(p_api_name, p_person_id,

1191: AND p.employee_number IS NOT NULL;
1192: EXCEPTION
1193: WHEN no_data_found THEN
1194: x_return_status := fnd_api.g_ret_sts_error;
1195: cs_core_util.add_invalid_argument_msg(p_api_name, p_person_id,
1196: p_parameter_name);
1197: END Validate_Person;
1198:
1199: ------------------------------------------------------------------------------

Line 1837: END CS_CORE_UTIL;

1833: end get_g_miss_date;
1834:
1835: ----------------------------------- End of Code -----------------------------
1836:
1837: END CS_CORE_UTIL;