eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_CORE_UTIL dependencies on FND_API

Line 141: p_contact_firstname IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

137: ( p_api_name IN VARCHAR2,
138: p_parameter_name_ln IN VARCHAR2,
139: p_parameter_name_fn IN VARCHAR2,
140: p_contact_lastname IN VARCHAR2,
141: p_contact_firstname IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
142: x_contact_id OUT NOCOPY NUMBER,
143: x_return_status OUT NOCOPY VARCHAR2 )
144: IS
145: BEGIN

Line 146: x_return_status := fnd_api.g_ret_sts_success;

142: x_contact_id OUT NOCOPY NUMBER,
143: x_return_status OUT NOCOPY VARCHAR2 )
144: IS
145: BEGIN
146: x_return_status := fnd_api.g_ret_sts_success;
147: /****
148: IF p_contact_firstname <> fnd_api.g_miss_char THEN
149: SELECT contact_id INTO x_contact_id
150: FROM ra_contacts

Line 148: IF p_contact_firstname <> fnd_api.g_miss_char THEN

144: IS
145: BEGIN
146: x_return_status := fnd_api.g_ret_sts_success;
147: /****
148: IF p_contact_firstname <> fnd_api.g_miss_char THEN
149: SELECT contact_id INTO x_contact_id
150: FROM ra_contacts
151: WHERE last_name = p_contact_lastname
152: AND first_name = p_contact_firstname;

Line 161: x_return_status := fnd_api.g_ret_sts_error;

157: END IF;
158: ***/
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,

Line 162: IF p_contact_firstname <> fnd_api.g_miss_char THEN

158: ***/
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 );

Line 174: x_return_status := fnd_api.g_ret_sts_error;

170: p_token_v => p_contact_lastname,
171: p_token_p => p_parameter_name_ln );
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 );

Line 175: IF p_contact_firstname <> fnd_api.g_miss_char THEN

171: p_token_p => p_parameter_name_ln );
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

Line 194: p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

190: PROCEDURE Convert_Customer_To_ID
191: ( p_api_name IN VARCHAR2,
192: p_parameter_name_nb IN VARCHAR2,
193: p_parameter_name_n IN VARCHAR2,
194: p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
195: p_customer_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
196: x_customer_id OUT NOCOPY NUMBER,
197: x_return_status OUT NOCOPY VARCHAR2 )
198: IS

Line 195: p_customer_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

191: ( p_api_name IN VARCHAR2,
192: p_parameter_name_nb IN VARCHAR2,
193: p_parameter_name_n IN VARCHAR2,
194: p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
195: p_customer_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
196: x_customer_id OUT NOCOPY NUMBER,
197: x_return_status OUT NOCOPY VARCHAR2 )
198: IS
199: BEGIN

Line 200: x_return_status := fnd_api.g_ret_sts_success;

196: x_customer_id OUT NOCOPY NUMBER,
197: x_return_status OUT NOCOPY VARCHAR2 )
198: IS
199: BEGIN
200: x_return_status := fnd_api.g_ret_sts_success;
201:
202: IF p_customer_number <> fnd_api.g_miss_char THEN
203: BEGIN
204: SELECT party_id INTO x_customer_id

Line 202: IF p_customer_number <> fnd_api.g_miss_char THEN

198: IS
199: BEGIN
200: x_return_status := fnd_api.g_ret_sts_success;
201:
202: IF p_customer_number <> fnd_api.g_miss_char THEN
203: BEGIN
204: SELECT party_id INTO x_customer_id
205: FROM hz_parties
206: WHERE party_number = p_customer_number;

Line 209: x_return_status := fnd_api.g_ret_sts_error;

205: FROM hz_parties
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;

Line 214: IF p_customer_name <> fnd_api.g_miss_char THEN

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
215: cs_core_util.add_param_ignored_msg(p_api_name, p_parameter_name_n);
216: END IF;
217: ELSE
218: BEGIN

Line 224: x_return_status := fnd_api.g_ret_sts_error;

220: FROM hz_parties
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;

Line 228: x_return_status := fnd_api.g_ret_sts_error;

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,
230: p_parameter_name_n);
231: END;
232: END IF;

Line 247: x_return_status := fnd_api.g_ret_sts_success;

243: x_customer_name OUT NOCOPY VARCHAR2,
244: x_return_status OUT NOCOPY VARCHAR2 )
245: IS
246: BEGIN
247: x_return_status := fnd_api.g_ret_sts_success;
248:
249: -- Fetch name from database.
250: SELECT party_name INTO x_customer_name
251: FROM hz_parties

Line 256: x_return_status := fnd_api.g_ret_sts_error;

252: WHERE party_id = p_customer_id;
253:
254: EXCEPTION
255: WHEN no_data_found THEN
256: x_return_status := fnd_api.g_ret_sts_error;
257: add_invalid_argument_msg(p_api_name, To_char(p_customer_id),
258: p_parameter_name);
259: END Convert_Customer_To_Name;
260:

Line 269: p_employee_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

265: PROCEDURE Convert_Employee_To_ID
266: ( p_api_name IN VARCHAR2,
267: p_parameter_name_nb IN VARCHAR2,
268: p_parameter_name_n IN VARCHAR2,
269: p_employee_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
270: p_employee_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
271: x_employee_id OUT NOCOPY NUMBER,
272: x_return_status OUT NOCOPY VARCHAR2 )
273: IS

Line 270: p_employee_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

266: ( p_api_name IN VARCHAR2,
267: p_parameter_name_nb IN VARCHAR2,
268: p_parameter_name_n IN VARCHAR2,
269: p_employee_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
270: p_employee_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
271: x_employee_id OUT NOCOPY NUMBER,
272: x_return_status OUT NOCOPY VARCHAR2 )
273: IS
274: BEGIN

Line 275: x_return_status := fnd_api.g_ret_sts_success;

271: x_employee_id OUT NOCOPY NUMBER,
272: x_return_status OUT NOCOPY VARCHAR2 )
273: IS
274: BEGIN
275: x_return_status := fnd_api.g_ret_sts_success;
276:
277: IF p_employee_number <> fnd_api.g_miss_char THEN
278: BEGIN
279: SELECT person_id INTO x_employee_id

Line 277: IF p_employee_number <> fnd_api.g_miss_char THEN

273: IS
274: BEGIN
275: x_return_status := fnd_api.g_ret_sts_success;
276:
277: IF p_employee_number <> fnd_api.g_miss_char THEN
278: BEGIN
279: SELECT person_id INTO x_employee_id
280: FROM per_people_x
281: WHERE employee_number = p_employee_number;

Line 284: x_return_status := fnd_api.g_ret_sts_error;

280: FROM per_people_x
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

Line 289: 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;
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

Line 293: IF p_employee_name <> fnd_api.g_miss_char 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);
295: END IF;
296: ELSE
297: BEGIN

Line 303: x_return_status := fnd_api.g_ret_sts_error;

299: FROM per_people_x
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;

Line 307: x_return_status := fnd_api.g_ret_sts_error;

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,
309: p_parameter_name_n);
310: END;
311: END IF;

Line 327: x_return_status := fnd_api.g_ret_sts_success;

323: x_lookup_code OUT NOCOPY VARCHAR2,
324: x_return_status OUT NOCOPY VARCHAR2 )
325: IS
326: BEGIN
327: x_return_status := fnd_api.g_ret_sts_success;
328:
329: SELECT lookup_code INTO x_lookup_code
330: FROM cs_lookups
331: WHERE lookup_type = p_lookup_type

Line 335: x_return_status := fnd_api.g_ret_sts_error;

331: WHERE lookup_type = p_lookup_type
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:

Line 352: x_return_status := fnd_api.g_ret_sts_success;

348: x_org_id OUT NOCOPY NUMBER,
349: x_return_status OUT NOCOPY VARCHAR2 )
350: IS
351: BEGIN
352: x_return_status := fnd_api.g_ret_sts_success;
353:
354: SELECT organization_id INTO x_org_id
355: FROM hr_operating_units
356: WHERE name = p_org_name;

Line 359: x_return_status := fnd_api.g_ret_sts_error;

355: FROM hr_operating_units
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;

Line 363: x_return_status := fnd_api.g_ret_sts_error;

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);
365: END Convert_Org_To_ID;
366:
367: ------------------------------------------------------------------------------

Line 387: IF p_resp_appl_id = fnd_api.g_miss_num THEN

383: -- returns -1 by default, which is an invalid value. FND_GLOBAL.USER_ID
384: -- is okay, because user ID -1 corresponds to user 'ANONYMOUS.' If
385: -- FND_GLOBAL returns -1, the variables are set to NULL instead.
386: -------------------------------------------------------------------------
387: IF p_resp_appl_id = fnd_api.g_miss_num THEN
388: IF fnd_global.resp_appl_id <> -1 THEN
389: p_resp_appl_id := fnd_global.resp_appl_id;
390: ELSE
391: p_resp_appl_id := NULL;

Line 395: IF p_resp_id = fnd_api.g_miss_num THEN

391: p_resp_appl_id := NULL;
392: END IF;
393: END IF;
394:
395: IF p_resp_id = fnd_api.g_miss_num THEN
396: IF fnd_global.resp_id <> -1 THEN
397: p_resp_id := fnd_global.resp_id;
398: ELSE
399: p_resp_id := NULL;

Line 403: IF p_user_id = fnd_api.g_miss_num THEN

399: p_resp_id := NULL;
400: END IF;
401: END IF;
402:
403: IF p_user_id = fnd_api.g_miss_num THEN
404: p_user_id := fnd_global.user_id;
405: END IF;
406:
407: IF p_login_id = fnd_api.g_miss_num THEN

Line 407: IF p_login_id = fnd_api.g_miss_num THEN

403: IF p_user_id = fnd_api.g_miss_num THEN
404: p_user_id := fnd_global.user_id;
405: END IF;
406:
407: IF p_login_id = fnd_api.g_miss_num THEN
408: IF fnd_global.login_id NOT IN (-1,0) THEN
409: p_login_id := fnd_global.login_id;
410: ELSE
411: p_login_id := NULL;

Line 421: IF p_org_id = fnd_api.g_miss_num THEN

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
425: FROM dual;

Line 435: IF p_inventory_org_id = fnd_api.g_miss_num THEN

431: END IF;
432: END IF;
433: END IF;
434:
435: IF p_inventory_org_id = fnd_api.g_miss_num THEN
436: p_inventory_org_id :=
437: To_number(fnd_profile.value_specific('SO_ORGANIZATION_ID', p_user_id,
438: p_resp_id, p_resp_appl_id));
439: END IF;

Line 509: x_return_status := fnd_api.g_ret_sts_success;

505: x_bill_to_customer_id OUT NOCOPY NUMBER,
506: x_return_status OUT NOCOPY VARCHAR2 )
507: IS
508: BEGIN
509: x_return_status := fnd_api.g_ret_sts_success;
510: /*****
511: -- Find the customer of the given site
512: SELECT a.customer_id INTO x_bill_to_customer_id
513: FROM ra_site_uses_all su, ra_addresses_all a

Line 530: x_return_status := fnd_api.g_ret_sts_error;

526: AND Nvl(ra.org_id,-99) = Decode(ra.org_id,NULL,-99,p_org_id) ) );
527: *****/
528: EXCEPTION
529: WHEN no_data_found THEN
530: x_return_status := fnd_api.g_ret_sts_error;
531: add_invalid_argument_msg(p_api_name, To_char(p_bill_to_site_id),
532: p_parameter_name);
533: END Validate_Bill_To_Site;
534:

Line 547: x_return_status := fnd_api.g_ret_sts_success;

543: x_return_status OUT NOCOPY VARCHAR2 )
544: IS
545: l_dummy VARCHAR2(1);
546: BEGIN
547: x_return_status := fnd_api.g_ret_sts_success;
548:
549: -- Validate against cs_comments, which contains all notes across
550: -- multiple source object types
551: SELECT 'x' INTO l_dummy

Line 556: x_return_status := fnd_api.g_ret_sts_error;

552: FROM cs_comments
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: **********************************/

Line 573: x_return_status := fnd_api.g_ret_sts_success;

569: x_return_status OUT NOCOPY VARCHAR2 )
570: IS
571: l_dummy VARCHAR2(1);
572: BEGIN
573: x_return_status := fnd_api.g_ret_sts_success;
574: SELECT 'x' INTO l_dummy
575: FROM hz_parties
576: WHERE party_id = p_customer_id
577: AND status = 'A';

Line 580: x_return_status := fnd_api.g_ret_sts_error;

576: WHERE party_id = p_customer_id
577: AND status = 'A';
578: EXCEPTION
579: WHEN no_data_found THEN
580: x_return_status := fnd_api.g_ret_sts_error;
581: add_invalid_argument_msg(p_api_name, To_char(p_customer_id),
582: p_parameter_name);
583: END Validate_Customer;
584:

Line 606: x_return_status := fnd_api.g_ret_sts_success;

602: x_return_status OUT NOCOPY VARCHAR2 )
603: IS
604: l_dummy VARCHAR2(1);
605: BEGIN
606: x_return_status := fnd_api.g_ret_sts_success;
607: /********
608: SELECT 'x' INTO l_dummy
609: FROM ra_contacts
610: WHERE contact_id = p_customer_contact_id

Line 624: x_return_status := fnd_api.g_ret_sts_error;

620: AND Nvl(org_id,-99) = Decode(org_id,NULL,-99,p_org_id) );
621: *****/
622: EXCEPTION
623: WHEN no_data_found THEN
624: x_return_status := fnd_api.g_ret_sts_error;
625: add_invalid_argument_msg(p_api_name, To_char(p_customer_contact_id),
626: p_parameter_name);
627: END Validate_Customer_Contact;
628:

Line 674: x_return_status := fnd_api.g_ret_sts_success;

670: x_return_status OUT NOCOPY VARCHAR2 )
671: IS
672: l_error_message VARCHAR2(2000);
673: BEGIN
674: x_return_status := fnd_api.g_ret_sts_success;
675:
676: fnd_flex_descval.set_column_value(p_column_name1, p_column_value1);
677: fnd_flex_descval.set_column_value(p_column_name2, p_column_value2);
678: fnd_flex_descval.set_column_value(p_column_name3, p_column_value3);

Line 699: x_return_status := fnd_api.g_ret_sts_error;

695: resp_appl_id => p_resp_appl_id,
696: resp_id => p_resp_id ) THEN
697: l_error_message := fnd_flex_descval.error_message;
698: add_desc_flex_msg(p_api_name, l_error_message);
699: x_return_status := fnd_api.g_ret_sts_error;
700: END IF;
701: END Validate_Desc_Flex;
702:
703: ------------------------------------------------------------------------------

Line 918: x_return_status := fnd_api.g_ret_sts_success;

914: x_return_status OUT NOCOPY VARCHAR2 )
915: IS
916: l_error_message VARCHAR2(2000);
917: BEGIN
918: x_return_status := fnd_api.g_ret_sts_success;
919: fnd_flex_descval.set_column_value(p_column_name1, p_column_value1);
920: fnd_flex_descval.set_column_value(p_column_name2, p_column_value2);
921: fnd_flex_descval.set_column_value(p_column_name3, p_column_value3);
922: fnd_flex_descval.set_column_value(p_column_name4, p_column_value4);

Line 1027: x_return_status := fnd_api.g_ret_sts_error;

1023: resp_appl_id => p_resp_appl_id,
1024: resp_id => p_resp_id ) THEN
1025: l_error_message := fnd_flex_descval.error_message;
1026: add_desc_flex_msg(p_api_name, l_error_message);
1027: x_return_status := fnd_api.g_ret_sts_error;
1028: END IF;
1029: END Validate_Price_Attribs;
1030:
1031:

Line 1047: x_return_status := fnd_api.g_ret_sts_success;

1043: IS
1044: l_orig_org_id NUMBER;
1045: l_dummy VARCHAR2(1);
1046: BEGIN
1047: x_return_status := fnd_api.g_ret_sts_success;
1048:
1049: -- Store the old value of the multi-org context
1050: SELECT To_number(Decode(substrb(userenv('CLIENT_INFO'),1,1), ' ', NULL,
1051: substrb(userenv('CLIENT_INFO'),1,10)))

Line 1081: x_return_status := fnd_api.g_ret_sts_error;

1077: fnd_client_info.set_org_context(l_orig_org_id);
1078: END IF;
1079: EXCEPTION
1080: WHEN no_data_found THEN
1081: x_return_status := fnd_api.g_ret_sts_error;
1082: IF (p_org_id IS NOT NULL) THEN
1083: -- Restore the original multi-org context
1084: fnd_client_info.set_org_context(l_orig_org_id);
1085: END IF;

Line 1109: x_return_status := fnd_api.g_ret_sts_success;

1105: x_return_status OUT NOCOPY VARCHAR2 )
1106: IS
1107: BEGIN
1108: IF p_later_date >= p_earlier_date THEN
1109: x_return_status := fnd_api.g_ret_sts_success;
1110: ELSE
1111: x_return_status := fnd_api.g_ret_sts_error;
1112: add_invalid_argument_msg(p_api_name, To_char(p_later_date),
1113: p_parameter_name);

Line 1111: x_return_status := fnd_api.g_ret_sts_error;

1107: BEGIN
1108: IF p_later_date >= p_earlier_date THEN
1109: x_return_status := fnd_api.g_ret_sts_success;
1110: ELSE
1111: x_return_status := fnd_api.g_ret_sts_error;
1112: add_invalid_argument_msg(p_api_name, To_char(p_later_date),
1113: p_parameter_name);
1114: END IF;
1115: END Validate_Later_Date;

Line 1130: x_return_status := fnd_api.g_ret_sts_success;

1126: x_return_status OUT NOCOPY VARCHAR2 )
1127: IS
1128: l_dummy VARCHAR2(1);
1129: BEGIN
1130: x_return_status := fnd_api.g_ret_sts_success;
1131:
1132: SELECT 'x' INTO l_dummy
1133: FROM cs_lookups
1134: WHERE lookup_code = p_lookup_code

Line 1141: x_return_status := fnd_api.g_ret_sts_error;

1137: AND Trunc(Sysdate) BETWEEN Trunc(Nvl(start_date_active, Sysdate))
1138: AND Trunc(Nvl(end_date_active, Sysdate));
1139: EXCEPTION
1140: WHEN no_data_found THEN
1141: x_return_status := fnd_api.g_ret_sts_error;
1142: add_invalid_argument_msg(p_api_name, p_lookup_code, p_parameter_name);
1143: END Validate_Lookup_Code;
1144:
1145: ------------------------------------------------------------------------------

Line 1157: x_return_status := fnd_api.g_ret_sts_success;

1153: x_return_status OUT NOCOPY VARCHAR2 )
1154: IS
1155: l_dummy VARCHAR2(1);
1156: BEGIN
1157: x_return_status := fnd_api.g_ret_sts_success;
1158:
1159: SELECT 'x' INTO l_dummy
1160: FROM hr_operating_units
1161: WHERE organization_id = p_org_id;

Line 1164: x_return_status := fnd_api.g_ret_sts_error;

1160: FROM hr_operating_units
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:

Line 1181: x_return_status := fnd_api.g_ret_sts_success;

1177: x_return_status OUT NOCOPY VARCHAR2 )
1178: IS
1179: l_dummy VARCHAR2(1);
1180: BEGIN
1181: x_return_status := fnd_api.g_ret_sts_success;
1182:
1183: -- Validate against per_people_x, which contains all employees across
1184: -- multiple business groups
1185: SELECT 'x' INTO l_dummy

Line 1194: x_return_status := fnd_api.g_ret_sts_error;

1190: AND a.primary_flag = 'Y'
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:

Line 1240: x_return_status := fnd_api.g_ret_sts_success;

1236: AND status = 'A'
1237: AND Nvl(org_id,-99) = Decode(org_id,NULL,-99,p_org_id) );
1238: ******/
1239: BEGIN
1240: x_return_status := fnd_api.g_ret_sts_success;
1241:
1242: /****
1243: OPEN l_ship_to_site_csr;
1244: FETCH l_ship_to_site_csr INTO x_ship_to_customer_id;

Line 1246: x_return_status := fnd_api.g_ret_sts_error;

1242: /****
1243: OPEN l_ship_to_site_csr;
1244: FETCH l_ship_to_site_csr INTO x_ship_to_customer_id;
1245: IF l_ship_to_site_csr%notfound THEN
1246: x_return_status := fnd_api.g_ret_sts_error;
1247: add_invalid_argument_msg(p_api_name, To_char(p_ship_to_site_use_id),
1248: p_parameter_name);
1249: END IF;
1250: CLOSE l_ship_to_site_csr;

Line 1274: x_return_status := fnd_api.g_ret_sts_success;

1270: x_return_status OUT NOCOPY VARCHAR2 )
1271: IS
1272: l_dummy VARCHAR2(1);
1273: BEGIN
1274: x_return_status := fnd_api.g_ret_sts_success;
1275:
1276: IF (p_source_object_code = 'INT') THEN
1277: SELECT 'x' INTO l_dummy
1278: FROM cs_interactions

Line 1289: x_return_status := fnd_api.g_ret_sts_error;

1285: AND Nvl(org_id, -99) = Decode(org_id, NULL, -99, p_org_id);
1286: END IF;
1287: EXCEPTION
1288: WHEN no_data_found THEN
1289: x_return_status := fnd_api.g_ret_sts_error;
1290: add_invalid_argument_msg(p_api_name, p_source_object_id,
1291: p_parameter_name);
1292: END Validate_Source_Object_ID;
1293:

Line 1310: x_return_status := fnd_api.g_ret_sts_success;

1306: x_return_status OUT NOCOPY VARCHAR2 )
1307: IS
1308: l_dummy VARCHAR2(1);
1309: BEGIN
1310: x_return_status := fnd_api.g_ret_sts_success;
1311:
1312: BEGIN
1313: -- Special check to not check the dates when the user ID is (-1).
1314: IF p_user_id = -1 THEN

Line 1327: x_return_status := fnd_api.g_ret_sts_error;

1323: AND Trunc(Nvl(end_date, Sysdate));
1324: END IF;
1325: EXCEPTION
1326: WHEN no_data_found THEN
1327: x_return_status := fnd_api.g_ret_sts_error;
1328: add_invalid_argument_msg(p_api_name, To_char(p_user_id),
1329: p_parameter_name_usr);
1330: RETURN;
1331: END;

Line 1344: x_return_status := fnd_api.g_ret_sts_error;

1340: WHERE login_id = p_login_id
1341: AND user_id = p_user_id;
1342: EXCEPTION
1343: WHEN no_data_found THEN
1344: x_return_status := fnd_api.g_ret_sts_error;
1345: add_invalid_argument_msg(p_api_name, To_char(p_login_id),
1346: p_parameter_name_log);
1347: END;
1348: END IF;

Line 1390: RAISE FND_API.G_EXC_ERROR;

1386: /* More than 15 attributes not currently supported. Please contact developer. */
1387: FND_MESSAGE.SET_NAME('CS','CS_API_NUM_OF_DESCFLEX_GT_MAX');
1388: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
1389: FND_MSG_PUB.Add;
1390: RAISE FND_API.G_EXC_ERROR;
1391: END IF;
1392:
1393: Validate_Desc_Flex
1394: (

Line 1433: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1429: l_resp_appl_id,
1430: l_resp_id,
1431: l_return_status );
1432:
1433: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1434: RAISE FND_API.G_EXC_ERROR;
1435: end if;
1436: END Is_DescFlex_Valid;
1437:

Line 1434: RAISE FND_API.G_EXC_ERROR;

1430: l_resp_id,
1431: l_return_status );
1432:
1433: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1434: RAISE FND_API.G_EXC_ERROR;
1435: end if;
1436: END Is_DescFlex_Valid;
1437:
1438: PROCEDURE Is_PriceAttribs_Valid

Line 1765: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1761: l_resp_appl_id,
1762: l_resp_id,
1763: l_return_status );
1764:
1765: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1766: RAISE FND_API.G_EXC_ERROR;
1767: end if;
1768: END Is_PriceAttribs_Valid;
1769: ------------------------------------------------------------------------------

Line 1766: RAISE FND_API.G_EXC_ERROR;

1762: l_resp_id,
1763: l_return_status );
1764:
1765: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1766: RAISE FND_API.G_EXC_ERROR;
1767: end if;
1768: END Is_PriceAttribs_Valid;
1769: ------------------------------------------------------------------------------
1770: -- Procedure : get_g_false

Line 1776: return (fnd_api.g_false);

1772:
1773: function get_g_false return varchar2 is
1774:
1775: begin
1776: return (fnd_api.g_false);
1777:
1778: end get_g_false;
1779:
1780: ------------------------------------------------------------------------------

Line 1787: return (fnd_api.g_true);

1783:
1784: function get_g_true return varchar2 is
1785:
1786: begin
1787: return (fnd_api.g_true);
1788:
1789: end get_g_true;
1790:
1791: ------------------------------------------------------------------------------

Line 1798: return (fnd_api.g_valid_level_full);

1794:
1795: function get_g_valid_level_full return varchar2 is
1796:
1797: begin
1798: return (fnd_api.g_valid_level_full);
1799:
1800: end get_g_valid_level_full;
1801:
1802: ------------------------------------------------------------------------------

Line 1809: return (fnd_api.g_miss_num);

1805:
1806: function get_g_miss_num return number is
1807:
1808: begin
1809: return (fnd_api.g_miss_num);
1810:
1811: end get_g_miss_num;
1812:
1813: ------------------------------------------------------------------------------

Line 1820: return (fnd_api.g_miss_char);

1816:
1817: function get_g_miss_char return varchar2 is
1818:
1819: begin
1820: return (fnd_api.g_miss_char);
1821:
1822: end get_g_miss_char;
1823:
1824: ------------------------------------------------------------------------------

Line 1831: return (fnd_api.g_miss_date);

1827:
1828: function get_g_miss_date return date is
1829:
1830: begin
1831: return (fnd_api.g_miss_date);
1832:
1833: end get_g_miss_date;
1834:
1835: ----------------------------------- End of Code -----------------------------