[Home] [Help]
250: x_return_status := fnd_api.g_ret_sts_error;
251:
252: -- put error message "Error: Invalid Identifier";
253: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_PARENT_ID');
254: FND_MSG_PUB.ADD();
255:
256: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
257: p_count => x_msg_count,
258: p_data => x_msg_data);
252: -- put error message "Error: Invalid Identifier";
253: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_PARENT_ID');
254: FND_MSG_PUB.ADD();
255:
256: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
257: p_count => x_msg_count,
258: p_data => x_msg_data);
259:
260: -- Debug info.
271: END IF;
272: WHEN fnd_api.g_exc_unexpected_error THEN
273: x_return_status := fnd_api.g_ret_sts_unexp_error;
274:
275: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
276: p_count => x_msg_count,
277: p_data => x_msg_data);
278:
279: -- Debug info.
293: x_return_status := fnd_api.g_ret_sts_unexp_error;
294:
295: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
296: fnd_message.set_token('ERROR' ,SQLERRM);
297: fnd_msg_pub.add;
298:
299: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
300: p_count => x_msg_count,
301: p_data => x_msg_data);
295: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
296: fnd_message.set_token('ERROR' ,SQLERRM);
297: fnd_msg_pub.add;
298:
299: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
300: p_count => x_msg_count,
301: p_data => x_msg_data);
302:
303: -- Debug info.
431: -- user must not pass TCA id when create, if passed in create,
432: -- return error
433: IF(p_create_or_update = 'C') THEN
434: FND_MESSAGE.SET_NAME('AR','HZ_API_CANNOT_PASS_PK');
435: FND_MSG_PUB.ADD();
436: RAISE FND_API.G_EXC_ERROR;
437: END IF;
438: IF(p_obj_type in ('PHONE','TLX','EMAIL','WEB','EFT','EDI','SMS')) THEN
439: OPEN is_cp_valid(px_id, p_obj_type);
505: FETCH is_cp_valid INTO l_dummy;
506: CLOSE is_cp_valid;
507: IF(l_dummy IS NULL) THEN
508: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
509: FND_MSG_PUB.ADD;
510: RAISE fnd_api.g_exc_error;
511: END IF;
512: END IF;
513: END IF;
519: IF(px_id IS NOT NULL) THEN
520: -- if px_id is invalid, raise error
521: IF(l_valid_id IS NULL) THEN
522: FND_MESSAGE.SET_NAME('AR','HZ_API_UPDATE_NOT_EXIST');
523: FND_MSG_PUB.ADD();
524: RAISE fnd_api.g_exc_error;
525: -- if px_id is valid
526: ELSE
527: -- check if px_os/px_osr is passed
529: -- if px_os/px_osr is not valid, means that this is new os+osr
530: -- we should not create ssm mapping, error out
531: IF(l_count = 0) THEN
532: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_ID');
533: FND_MSG_PUB.ADD();
534: RAISE fnd_api.g_exc_error;
535: -- if px_os/px_osr is valid
536: ELSE
537: -- if px_os/px_osr is valid, but not same as px_id
536: ELSE
537: -- if px_os/px_osr is valid, but not same as px_id
538: IF(l_owner_table_id <> px_id) OR (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
539: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_ID');
540: FND_MSG_PUB.ADD();
541: RAISE fnd_api.g_exc_error;
542: END IF;
543: END IF;
544: -- if px_os/px_osr is valid and return value is same as px_id
553: IF(l_ss_flag = 'Y') AND (l_count = 1) AND (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
554: px_id := l_owner_table_id;
555: ELSE
556: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_ID');
557: FND_MSG_PUB.ADD();
558: RAISE fnd_api.g_exc_error;
559: END IF;
560: END IF;
561: -- for create
562: ELSIF(p_create_or_update = 'C') THEN
563: -- if os+osr is valid, raise error
564: IF(l_ss_flag = 'Y') AND (l_count > 0) AND (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
565: FND_MESSAGE.SET_NAME('AR','HZ_API_CREATE_ALREADY_EXISTS');
566: FND_MSG_PUB.ADD();
567: RAISE fnd_api.g_exc_error;
568: END IF;
569: END IF; -- if p_create_or_update
570:
571: EXCEPTION
572: WHEN fnd_api.g_exc_error THEN
573: x_return_status := fnd_api.g_ret_sts_error;
574:
575: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
576: p_count => x_msg_count,
577: p_data => x_msg_data);
578:
579: -- Debug info.
590: END IF;
591: WHEN fnd_api.g_exc_unexpected_error THEN
592: x_return_status := fnd_api.g_ret_sts_unexp_error;
593:
594: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
595: p_count => x_msg_count,
596: p_data => x_msg_data);
597:
598: -- Debug info.
611: x_return_status := fnd_api.g_ret_sts_unexp_error;
612:
613: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
614: fnd_message.set_token('ERROR' ,SQLERRM);
615: fnd_msg_pub.add;
616:
617: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
618: p_count => x_msg_count,
619: p_data => x_msg_data);
613: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
614: fnd_message.set_token('ERROR' ,SQLERRM);
615: fnd_msg_pub.add;
616:
617: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
618: p_count => x_msg_count,
619: p_data => x_msg_data);
620:
621: -- Debug info.
2041: FETCH is_contact_point_exist INTO l_parent_id, l_parent_table;
2042: CLOSE is_contact_point_exist;
2043: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id OR l_parent_table <> l_input_parent_table) THEN
2044: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2045: FND_MSG_PUB.ADD;
2046: RETURN 'E';
2047: END IF;
2048: l_dummy := 'X';
2049: ELSIF(p_entity_type = 'HZ_PARTY_SITES') THEN
2051: FETCH is_party_site_exist INTO l_parent_id;
2052: CLOSE is_party_site_exist;
2053: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id) THEN
2054: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2055: FND_MSG_PUB.ADD;
2056: RETURN 'E';
2057: END IF;
2058: l_dummy := 'X';
2059: ELSIF(p_entity_type = 'HZ_LOCATIONS') THEN
2069: FETCH is_org_contact_exist INTO l_parent_id;
2070: CLOSE is_org_contact_exist;
2071: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id) THEN
2072: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2073: FND_MSG_PUB.ADD;
2074: RETURN 'E';
2075: END IF;
2076: l_dummy := 'X';
2077: ELSIF(p_entity_type = 'HZ_CUST_ACCOUNTS') THEN
2079: FETCH is_cust_account_exist INTO l_parent_id;
2080: CLOSE is_cust_account_exist;
2081: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id) THEN
2082: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2083: FND_MSG_PUB.ADD;
2084: RETURN 'E';
2085: END IF;
2086: l_dummy := 'X';
2087: ELSIF(p_entity_type = 'HZ_CUST_ACCT_SITES_ALL') THEN
2089: FETCH is_cust_acct_site_exist INTO l_parent_id;
2090: CLOSE is_cust_acct_site_exist;
2091: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id) THEN
2092: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2093: FND_MSG_PUB.ADD;
2094: RETURN 'E';
2095: END IF;
2096: l_dummy := 'X';
2097: ELSIF(p_entity_type = 'HZ_CUST_SITE_USES_ALL') THEN
2099: FETCH is_cust_site_use_exist INTO l_parent_id;
2100: CLOSE is_cust_site_use_exist;
2101: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id) THEN
2102: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2103: FND_MSG_PUB.ADD;
2104: RETURN 'E';
2105: END IF;
2106: l_dummy := 'X';
2107: ELSIF(p_entity_type = 'HZ_CUST_ACCOUNT_ROLES') THEN
2110: CLOSE is_cust_acct_role_exist;
2111: IF(p_parent_obj_type = 'CUST_ACCT_SITE') THEN
2112: IF(l_parent_id IS NULL OR l_acct_site_id <> p_parent_id) THEN
2113: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2114: FND_MSG_PUB.ADD;
2115: RETURN 'E';
2116: END IF;
2117: ELSIF(p_parent_obj_type = 'CUST_ACCT') THEN
2118: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id) THEN
2116: END IF;
2117: ELSIF(p_parent_obj_type = 'CUST_ACCT') THEN
2118: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id) THEN
2119: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2120: FND_MSG_PUB.ADD;
2121: RETURN 'E';
2122: END IF;
2123: END IF;
2124: l_dummy := 'X';
2146: FETCH is_contact_point_exist INTO l_parent_id, l_parent_table;
2147: CLOSE is_contact_point_exist;
2148: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id OR l_parent_table <> l_input_parent_table) THEN
2149: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2150: FND_MSG_PUB.ADD;
2151: RETURN 'E';
2152: END IF;
2153: END IF;
2154: END IF;
2490: WHEN l_bus_object.business_object_code(i) = 'PHONE' THEN
2491: IF(p_phone_objs IS NULL OR p_phone_objs.COUNT < 1) THEN
2492: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
2493: fnd_message.set_token('OBJECT' ,'PHONE');
2494: fnd_msg_pub.add;
2495: RETURN FALSE;
2496: ELSE
2497: FOR j IN 1..p_phone_objs.COUNT LOOP
2498: IF(l_phone_cpref AND
2499: (p_phone_objs(j).contact_pref_objs IS NULL OR
2500: p_phone_objs(j).contact_pref_objs.COUNT < 1)) THEN
2501: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2502: fnd_message.set_token('ENTITY' ,'PHONE-CONTACT_PREFERENCE');
2503: fnd_msg_pub.add;
2504: RETURN FALSE;
2505: END IF;
2506: END LOOP;
2507: END IF;
2508: WHEN l_bus_object.business_object_code(i) = 'EMAIL' THEN
2509: IF(p_email_objs IS NULL OR p_email_objs.COUNT < 1) THEN
2510: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
2511: fnd_message.set_token('OBJECT' ,'EMAIL');
2512: fnd_msg_pub.add;
2513: RETURN FALSE;
2514: ELSE
2515: FOR j IN 1..p_email_objs.COUNT LOOP
2516: IF(l_email_cpref AND
2517: (p_email_objs(j).contact_pref_objs IS NULL OR
2518: p_email_objs(j).contact_pref_objs.COUNT < 1)) THEN
2519: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2520: fnd_message.set_token('ENTITY' ,'EMAIL-CONTACT_PREFERENCE');
2521: fnd_msg_pub.add;
2522: RETURN FALSE;
2523: END IF;
2524: END LOOP;
2525: END IF;
2526: WHEN l_bus_object.business_object_code(i) = 'TLX' THEN
2527: IF(p_telex_objs IS NULL OR p_telex_objs.COUNT < 1) THEN
2528: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
2529: fnd_message.set_token('OBJECT' ,'TELEX');
2530: fnd_msg_pub.add;
2531: RETURN FALSE;
2532: ELSE
2533: FOR j IN 1..p_telex_objs.COUNT LOOP
2534: IF(l_telex_cpref AND
2535: (p_telex_objs(j).contact_pref_objs IS NULL OR
2536: p_telex_objs(j).contact_pref_objs.COUNT < 1)) THEN
2537: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2538: fnd_message.set_token('ENTITY' ,'TLX-CONTACT_PREFERENCE');
2539: fnd_msg_pub.add;
2540: RETURN FALSE;
2541: END IF;
2542: END LOOP;
2543: END IF;
2544: WHEN l_bus_object.business_object_code(i) = 'WEB' THEN
2545: IF(p_web_objs IS NULL OR p_web_objs.COUNT < 1) THEN
2546: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
2547: fnd_message.set_token('OBJECT' ,'WEB');
2548: fnd_msg_pub.add;
2549: RETURN FALSE;
2550: ELSE
2551: FOR j IN 1..p_web_objs.COUNT LOOP
2552: IF(l_web_cpref AND
2553: (p_web_objs(j).contact_pref_objs IS NULL OR
2554: p_web_objs(j).contact_pref_objs.COUNT < 1)) THEN
2555: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2556: fnd_message.set_token('ENTITY' ,'WEB-CONTACT_PREFERENCE');
2557: fnd_msg_pub.add;
2558: RETURN FALSE;
2559: END IF;
2560: END LOOP;
2561: END IF;
2562: WHEN l_bus_object.business_object_code(i) = 'EDI' THEN
2563: IF(p_edi_objs IS NULL OR p_edi_objs.COUNT < 1) THEN
2564: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
2565: fnd_message.set_token('OBJECT' ,'EDI');
2566: fnd_msg_pub.add;
2567: RETURN FALSE;
2568: ELSE
2569: FOR j IN 1..p_edi_objs.COUNT LOOP
2570: IF(l_edi_cpref AND
2571: (p_edi_objs(j).contact_pref_objs IS NULL OR
2572: p_edi_objs(j).contact_pref_objs.COUNT < 1)) THEN
2573: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2574: fnd_message.set_token('ENTITY' ,'EDI-CONTACT_PREFERENCE');
2575: fnd_msg_pub.add;
2576: RETURN FALSE;
2577: END IF;
2578: END LOOP;
2579: END IF;
2580: WHEN l_bus_object.business_object_code(i) = 'EFT' THEN
2581: IF(p_eft_objs IS NULL OR p_eft_objs.COUNT < 1) THEN
2582: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
2583: fnd_message.set_token('OBJECT' ,'EFT');
2584: fnd_msg_pub.add;
2585: RETURN FALSE;
2586: ELSE
2587: FOR j IN 1..p_eft_objs.COUNT LOOP
2588: IF(l_eft_cpref AND
2589: (p_eft_objs(j).contact_pref_objs IS NULL OR
2590: p_eft_objs(j).contact_pref_objs.COUNT < 1)) THEN
2591: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2592: fnd_message.set_token('ENTITY' ,'EFT-CONTACT_PREFERENCE');
2593: fnd_msg_pub.add;
2594: RETURN FALSE;
2595: END IF;
2596: END LOOP;
2597: END IF;
2598: WHEN l_bus_object.business_object_code(i) = 'SMS' THEN
2599: IF(p_sms_objs IS NULL OR p_sms_objs.COUNT < 1) THEN
2600: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
2601: fnd_message.set_token('OBJECT' ,'SMS');
2602: fnd_msg_pub.add;
2603: RETURN FALSE;
2604: ELSE
2605: FOR j IN 1..p_sms_objs.COUNT LOOP
2606: IF(l_sms_cpref AND
2607: (p_sms_objs(j).contact_pref_objs IS NULL OR
2608: p_sms_objs(j).contact_pref_objs.COUNT < 1)) THEN
2609: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2610: fnd_message.set_token('ENTITY' ,'SMS-CONTACT_PREFERENCE');
2611: fnd_msg_pub.add;
2612: RETURN FALSE;
2613: END IF;
2614: END LOOP;
2615: END IF;
2666:
2667: IF(p_ps_objs IS NULL OR p_ps_objs.COUNT < 1) THEN
2668: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
2669: fnd_message.set_token('OBJECT' ,'PARTY_SITE');
2670: fnd_msg_pub.add;
2671: RETURN FALSE;
2672: END IF;
2673:
2674: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
2730: FOR i IN 1..p_ps_objs.COUNT LOOP
2731: IF(p_ps_objs(i).location_obj IS NULL) THEN
2732: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
2733: fnd_message.set_token('OBJECT' ,'LOCATION');
2734: fnd_msg_pub.add;
2735: RETURN FALSE;
2736: END IF;
2737: IF(l_psu AND
2738: (p_ps_objs(i).party_site_use_objs IS NULL OR
2738: (p_ps_objs(i).party_site_use_objs IS NULL OR
2739: p_ps_objs(i).party_site_use_objs.COUNT < 1)) THEN
2740: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2741: fnd_message.set_token('OBJECT' ,'PARTY_SITE_USE');
2742: fnd_msg_pub.add;
2743: RETURN FALSE;
2744: END IF;
2745: IF(l_cpref AND
2746: (p_ps_objs(i).contact_pref_objs IS NULL OR
2746: (p_ps_objs(i).contact_pref_objs IS NULL OR
2747: p_ps_objs(i).contact_pref_objs.COUNT < 1)) THEN
2748: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2749: fnd_message.set_token('OBJECT' ,'PARTY_SITE: CONTACT_PREFERENCE');
2750: fnd_msg_pub.add;
2751: RETURN FALSE;
2752: END IF;
2753: IF(l_ps_ext AND
2754: (p_ps_objs(i).ext_attributes_objs IS NULL OR
2754: (p_ps_objs(i).ext_attributes_objs IS NULL OR
2755: p_ps_objs(i).ext_attributes_objs.COUNT < 1)) THEN
2756: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2757: fnd_message.set_token('OBJECT' ,'PARTY_SITE: EXTENSIBILITY');
2758: fnd_msg_pub.add;
2759: RETURN FALSE;
2760: END IF;
2761: IF(l_loc_ext AND
2762: (p_ps_objs(i).location_obj.ext_attributes_objs IS NULL OR
2762: (p_ps_objs(i).location_obj.ext_attributes_objs IS NULL OR
2763: p_ps_objs(i).location_obj.ext_attributes_objs.COUNT < 1)) THEN
2764: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2765: fnd_message.set_token('OBJECT' ,'LOCATION: EXTENSIBILITY');
2766: fnd_msg_pub.add;
2767: RETURN FALSE;
2768: END IF;
2769: IF(l_phone_code IS NOT NULL OR l_telex_code IS NOT NULL OR
2770: l_email_code IS NOT NULL OR l_web_code IS NOT NULL) THEN
2933: (p_person_obj.preference_objs IS NULL OR
2934: p_person_obj.preference_objs.COUNT < 1)) THEN
2935: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2936: fnd_message.set_token('OBJECT' ,'PARTY_PREFERENCE');
2937: fnd_msg_pub.add;
2938: RETURN FALSE;
2939: END IF;
2940: IF(l_class AND
2941: (p_person_obj.class_objs IS NULL OR
2941: (p_person_obj.class_objs IS NULL OR
2942: p_person_obj.class_objs.COUNT < 1)) THEN
2943: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2944: fnd_message.set_token('OBJECT' ,'CLASSIFICATION');
2945: fnd_msg_pub.add;
2946: RETURN FALSE;
2947: END IF;
2948: IF(l_lang AND
2949: (p_person_obj.language_objs IS NULL OR
2949: (p_person_obj.language_objs IS NULL OR
2950: p_person_obj.language_objs.COUNT < 1)) THEN
2951: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2952: fnd_message.set_token('OBJECT' ,'LANGUAGE');
2953: fnd_msg_pub.add;
2954: RETURN FALSE;
2955: END IF;
2956: IF(l_edu AND
2957: (p_person_obj.education_objs IS NULL OR
2957: (p_person_obj.education_objs IS NULL OR
2958: p_person_obj.education_objs.COUNT < 1)) THEN
2959: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2960: fnd_message.set_token('OBJECT' ,'EDUCATION');
2961: fnd_msg_pub.add;
2962: RETURN FALSE;
2963: END IF;
2964: IF(l_citiz AND
2965: (p_person_obj.citizenship_objs IS NULL OR
2965: (p_person_obj.citizenship_objs IS NULL OR
2966: p_person_obj.citizenship_objs.COUNT < 1)) THEN
2967: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2968: fnd_message.set_token('OBJECT' ,'CITIZENSHIP');
2969: fnd_msg_pub.add;
2970: RETURN FALSE;
2971: END IF;
2972: IF(l_emp_hist AND
2973: (p_person_obj.employ_hist_objs IS NULL OR
2973: (p_person_obj.employ_hist_objs IS NULL OR
2974: p_person_obj.employ_hist_objs.COUNT < 1)) THEN
2975: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2976: fnd_message.set_token('OBJECT' ,'EMPLOYMENT_HISTORY');
2977: fnd_msg_pub.add;
2978: RETURN FALSE;
2979: FOR j IN 1..p_person_obj.employ_hist_objs.COUNT LOOP
2980: IF(l_work_class AND
2981: (p_person_obj.employ_hist_objs(j).work_class_objs IS NULL OR
2981: (p_person_obj.employ_hist_objs(j).work_class_objs IS NULL OR
2982: p_person_obj.employ_hist_objs(j).work_class_objs.COUNT < 1)) THEN
2983: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2984: fnd_message.set_token('OBJECT' ,'WORK_CLASS');
2985: fnd_msg_pub.add;
2986: RETURN FALSE;
2987: END IF;
2988: END LOOP;
2989: END IF;
2991: (p_person_obj.interest_objs IS NULL OR
2992: p_person_obj.interest_objs.COUNT < 1)) THEN
2993: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2994: fnd_message.set_token('OBJECT' ,'PERSON_INTEREST');
2995: fnd_msg_pub.add;
2996: RETURN FALSE;
2997: END IF;
2998: IF(l_cert AND
2999: (p_person_obj.certification_objs IS NULL OR
2999: (p_person_obj.certification_objs IS NULL OR
3000: p_person_obj.certification_objs.COUNT < 1)) THEN
3001: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3002: fnd_message.set_token('OBJECT' ,'CERTIFICATION');
3003: fnd_msg_pub.add;
3004: RETURN FALSE;
3005: END IF;
3006: IF(l_fin_prof AND
3007: (p_person_obj.financial_prof_objs IS NULL OR
3007: (p_person_obj.financial_prof_objs IS NULL OR
3008: p_person_obj.financial_prof_objs.COUNT < 1)) THEN
3009: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3010: fnd_message.set_token('OBJECT' ,'FINANCIAL_PROFILE');
3011: fnd_msg_pub.add;
3012: RETURN FALSE;
3013: END IF;
3014: IF(l_rel AND
3015: (p_person_obj.relationship_objs IS NULL OR
3015: (p_person_obj.relationship_objs IS NULL OR
3016: p_person_obj.relationship_objs.COUNT < 1)) THEN
3017: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3018: fnd_message.set_token('OBJECT' ,'RELATIONSHIP');
3019: fnd_msg_pub.add;
3020: RETURN FALSE;
3021: END IF;
3022: IF(l_cpref AND
3023: (p_person_obj.contact_pref_objs IS NULL OR
3023: (p_person_obj.contact_pref_objs IS NULL OR
3024: p_person_obj.contact_pref_objs.COUNT < 1)) THEN
3025: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3026: fnd_message.set_token('OBJECT' ,'PERSON: CONTACT_PREFERENCE');
3027: fnd_msg_pub.add;
3028: RETURN FALSE;
3029: END IF;
3030: IF(l_ext AND
3031: (p_person_obj.ext_attributes_objs IS NULL OR
3031: (p_person_obj.ext_attributes_objs IS NULL OR
3032: p_person_obj.ext_attributes_objs.COUNT < 1)) THEN
3033: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3034: fnd_message.set_token('OBJECT' ,'PERSON: EXTENSIBILITY');
3035: fnd_msg_pub.add;
3036: RETURN FALSE;
3037: END IF;
3038: IF(l_phone_code IS NOT NULL OR l_email_code IS NOT NULL OR
3039: l_web_code IS NOT NULL OR l_sms_code IS NOT NULL) THEN
3111:
3112: IF(p_oc_objs IS NULL OR p_oc_objs.COUNT < 1) THEN
3113: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
3114: fnd_message.set_token('OBJECT' ,'ORG_CONTACT');
3115: fnd_msg_pub.add;
3116: RETURN FALSE;
3117: END IF;
3118:
3119: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
3177: FOR i IN 1..p_oc_objs.COUNT LOOP
3178: IF(p_oc_objs(i).person_profile_obj IS NULL) THEN
3179: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3180: fnd_message.set_token('OBJECT' ,'PERSON_CONTACT');
3181: fnd_msg_pub.add;
3182: RETURN FALSE;
3183: END IF;
3184:
3185: IF(l_ocr AND
3186: (p_oc_objs(i).org_contact_role_objs IS NULL OR
3187: p_oc_objs(i).org_contact_role_objs.COUNT < 1)) THEN
3188: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3189: fnd_message.set_token('OBJECT' ,'ORG_CONTACT_ROLE');
3190: fnd_msg_pub.add;
3191: RETURN FALSE;
3192: END IF;
3193: IF(l_cpref AND
3194: (p_oc_objs(i).contact_pref_objs IS NULL OR
3194: (p_oc_objs(i).contact_pref_objs IS NULL OR
3195: p_oc_objs(i).contact_pref_objs.COUNT < 1)) THEN
3196: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3197: fnd_message.set_token('OBJECT' ,'ORG_CONTACT: CONTACT_PREFERENCE');
3198: fnd_msg_pub.add;
3199: RETURN FALSE;
3200: END IF;
3201:
3202: IF(l_phone_code IS NOT NULL OR l_telex_code IS NOT NULL OR
3377: (p_organization_obj.preference_objs IS NULL OR
3378: p_organization_obj.preference_objs.COUNT < 1)) THEN
3379: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3380: fnd_message.set_token('OBJECT' ,'PARTY_PREFERENCE');
3381: fnd_msg_pub.add;
3382: RETURN FALSE;
3383: END IF;
3384: IF(l_credit AND
3385: (p_organization_obj.credit_rating_objs IS NULL OR
3385: (p_organization_obj.credit_rating_objs IS NULL OR
3386: p_organization_obj.credit_rating_objs.COUNT < 1)) THEN
3387: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3388: fnd_message.set_token('OBJECT' ,'CREDIT_RATING');
3389: fnd_msg_pub.add;
3390: RETURN FALSE;
3391: END IF;
3392: IF(l_rel AND
3393: (p_organization_obj.relationship_objs IS NULL OR
3393: (p_organization_obj.relationship_objs IS NULL OR
3394: p_organization_obj.relationship_objs.COUNT < 1)) THEN
3395: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3396: fnd_message.set_token('OBJECT' ,'RELATIONSHIP');
3397: fnd_msg_pub.add;
3398: RETURN FALSE;
3399: END IF;
3400: IF(l_class AND
3401: (p_organization_obj.class_objs IS NULL OR
3401: (p_organization_obj.class_objs IS NULL OR
3402: p_organization_obj.class_objs.COUNT < 1)) THEN
3403: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3404: fnd_message.set_token('OBJECT' ,'CLASSIFICATION');
3405: fnd_msg_pub.add;
3406: RETURN FALSE;
3407: END IF;
3408: IF(l_fin_report AND
3409: (p_organization_obj.financial_report_objs IS NULL OR
3409: (p_organization_obj.financial_report_objs IS NULL OR
3410: p_organization_obj.financial_report_objs.COUNT < 1)) THEN
3411: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3412: fnd_message.set_token('OBJECT' ,'FINANCIAL_REPORT');
3413: fnd_msg_pub.add;
3414: RETURN FALSE;
3415:
3416: -- financial report always require financial number
3417: FOR j IN 1..p_organization_obj.financial_report_objs.COUNT LOOP
3418: IF(p_organization_obj.financial_report_objs(j).financial_number_objs IS NULL OR
3419: p_organization_obj.financial_report_objs(j).financial_number_objs.COUNT < 1) THEN
3420: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3421: fnd_message.set_token('OBJECT' ,'FINANCIAL_NUMBER');
3422: fnd_msg_pub.add;
3423: RETURN FALSE;
3424: END IF;
3425: END LOOP;
3426: END IF;
3428: (p_organization_obj.certification_objs IS NULL OR
3429: p_organization_obj.certification_objs.COUNT < 1)) THEN
3430: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3431: fnd_message.set_token('OBJECT' ,'CERTIFICATION');
3432: fnd_msg_pub.add;
3433: RETURN FALSE;
3434: END IF;
3435: IF(l_fin_prof AND
3436: (p_organization_obj.financial_prof_objs IS NULL OR
3436: (p_organization_obj.financial_prof_objs IS NULL OR
3437: p_organization_obj.financial_prof_objs.COUNT < 1)) THEN
3438: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3439: fnd_message.set_token('OBJECT' ,'FINANCIAL_PROFILE');
3440: fnd_msg_pub.add;
3441: RETURN FALSE;
3442: END IF;
3443: IF(l_cpref AND
3444: (p_organization_obj.contact_pref_objs IS NULL OR
3444: (p_organization_obj.contact_pref_objs IS NULL OR
3445: p_organization_obj.contact_pref_objs.COUNT < 1)) THEN
3446: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3447: fnd_message.set_token('OBJECT' ,'ORG: CONTACT_PREFERENCE');
3448: fnd_msg_pub.add;
3449: RETURN FALSE;
3450: END IF;
3451: IF(l_ext AND
3452: (p_organization_obj.ext_attributes_objs IS NULL OR
3452: (p_organization_obj.ext_attributes_objs IS NULL OR
3453: p_organization_obj.ext_attributes_objs.COUNT < 1)) THEN
3454: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3455: fnd_message.set_token('OBJECT' ,'ORG: EXTENSIBILITY');
3456: fnd_msg_pub.add;
3457: RETURN FALSE;
3458: END IF;
3459:
3460: IF(l_phone_code IS NOT NULL OR l_telex_code IS NOT NULL OR
3530:
3531: IF(p_cac_objs IS NULL OR p_cac_objs.COUNT < 1) THEN
3532: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
3533: fnd_message.set_token('OBJECT' ,'CUST_ACCT_CONTACT');
3534: fnd_msg_pub.add;
3535: RETURN FALSE;
3536: END IF;
3537:
3538: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
3554: (p_cac_objs(i).contact_role_objs IS NULL OR
3555: p_cac_objs(i).contact_role_objs.COUNT < 1)) THEN
3556: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3557: fnd_message.set_token('OBJECT' ,'ROLE_RESPONSIBILITY');
3558: fnd_msg_pub.add;
3559: RETURN FALSE;
3560: END IF;
3561: END LOOP;
3562:
3603:
3604: IF(p_cas_objs IS NULL OR p_cas_objs.COUNT < 1) THEN
3605: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
3606: fnd_message.set_token('OBJECT' ,'CUST_ACCT_SITE');
3607: fnd_msg_pub.add;
3608: RETURN FALSE;
3609: END IF;
3610:
3611: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
3664: (p_cas_objs(i).cust_acct_site_use_objs IS NULL OR
3665: p_cas_objs(i).cust_acct_site_use_objs.COUNT < 1)) THEN
3666: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3667: fnd_message.set_token('OBJECT' ,'CUST_ACCT_SITE_USE');
3668: fnd_msg_pub.add;
3669: RETURN FALSE;
3670:
3671: FOR j IN 1..p_cas_objs(i).cust_acct_site_use_objs.COUNT LOOP
3672: IF(l_cp AND p_cas_objs(i).cust_acct_site_use_objs(j).site_use_profile_obj IS NULL) THEN
3671: FOR j IN 1..p_cas_objs(i).cust_acct_site_use_objs.COUNT LOOP
3672: IF(l_cp AND p_cas_objs(i).cust_acct_site_use_objs(j).site_use_profile_obj IS NULL) THEN
3673: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3674: fnd_message.set_token('OBJECT' ,'SITE_USE_PROFILE');
3675: fnd_msg_pub.add;
3676: RETURN FALSE;
3677: END IF;
3678: IF(l_cpa AND
3679: (p_cas_objs(i).cust_acct_site_use_objs(j).site_use_profile_obj.cust_profile_amt_objs IS NULL OR
3679: (p_cas_objs(i).cust_acct_site_use_objs(j).site_use_profile_obj.cust_profile_amt_objs IS NULL OR
3680: p_cas_objs(i).cust_acct_site_use_objs(j).site_use_profile_obj.cust_profile_amt_objs.COUNT < 1)) THEN
3681: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3682: fnd_message.set_token('OBJECT' ,'SITE_USE_PROFILE_AMOUNT');
3683: fnd_msg_pub.add;
3684: RETURN FALSE;
3685: END IF;
3686: -- for bank account use and payment method
3687: IF(l_bau AND
3688: (p_cas_objs(i).cust_acct_site_use_objs(j).bank_acct_use_objs IS NULL OR
3689: p_cas_objs(i).cust_acct_site_use_objs(j).bank_acct_use_objs.COUNT < 1)) THEN
3690: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3691: fnd_message.set_token('OBJECT' ,'BANK_ACCOUNT');
3692: fnd_msg_pub.add;
3693: RETURN FALSE;
3694: END IF;
3695: IF(l_pm AND
3696: (p_cas_objs(i).cust_acct_site_use_objs(j).payment_method_obj IS NULL)) THEN
3695: IF(l_pm AND
3696: (p_cas_objs(i).cust_acct_site_use_objs(j).payment_method_obj IS NULL)) THEN
3697: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3698: fnd_message.set_token('OBJECT' ,'PAYMENT_METHOD');
3699: fnd_msg_pub.add;
3700: RETURN FALSE;
3701: END IF;
3702: END LOOP;
3703: END IF;
3748:
3749: IF(p_ca_objs IS NULL OR p_ca_objs.COUNT < 1) THEN
3750: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
3751: fnd_message.set_token('OBJECT' ,'CUST_ACCT');
3752: fnd_msg_pub.add;
3753: RETURN FALSE;
3754: END IF;
3755:
3756: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
3831: (p_ca_objs(i).acct_relate_objs IS NULL OR
3832: p_ca_objs(i).acct_relate_objs.COUNT < 1)) THEN
3833: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3834: fnd_message.set_token('OBJECT' ,'CUSTOMER_ACCOUNT_RELATE');
3835: fnd_msg_pub.add;
3836: RETURN FALSE;
3837: END IF;
3838:
3839: -- for bank account use and payment method
3841: (p_ca_objs(i).bank_acct_use_objs IS NULL OR
3842: p_ca_objs(i).bank_acct_use_objs.COUNT < 1)) THEN
3843: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3844: fnd_message.set_token('OBJECT' ,'BANK_ACCOUNT');
3845: fnd_msg_pub.add;
3846: RETURN FALSE;
3847: END IF;
3848: IF(l_pm AND
3849: (p_ca_objs(i).payment_method_obj IS NULL)) THEN
3848: IF(l_pm AND
3849: (p_ca_objs(i).payment_method_obj IS NULL)) THEN
3850: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3851: fnd_message.set_token('OBJECT' ,'PAYMENT_METHOD');
3852: fnd_msg_pub.add;
3853: RETURN FALSE;
3854: END IF;
3855:
3856: IF(l_cp AND p_ca_objs(i).cust_profile_obj IS NULL) THEN
3860: (p_ca_objs(i).cust_profile_obj.cust_profile_amt_objs IS NULL OR
3861: p_ca_objs(i).cust_profile_obj.cust_profile_amt_objs.COUNT < 1)) THEN
3862: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3863: fnd_message.set_token('OBJECT' ,'CUSTOMER_PROFILE_AMOUNT');
3864: fnd_msg_pub.add;
3865: RETURN FALSE;
3866: END IF;
3867: END IF;
3868: END LOOP;
4355:
4356: IF(p_cas_v2_objs IS NULL OR p_cas_v2_objs.COUNT < 1) THEN
4357: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
4358: fnd_message.set_token('OBJECT' ,'CUST_ACCT_SITE');
4359: fnd_msg_pub.add;
4360: RETURN FALSE;
4361: END IF;
4362:
4363: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
4416: (p_cas_v2_objs(i).cust_acct_site_use_objs IS NULL OR
4417: p_cas_v2_objs(i).cust_acct_site_use_objs.COUNT < 1)) THEN
4418: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
4419: fnd_message.set_token('OBJECT' ,'CUST_ACCT_SITE_USE');
4420: fnd_msg_pub.add;
4421: RETURN FALSE;
4422:
4423: FOR j IN 1..p_cas_v2_objs(i).cust_acct_site_use_objs.COUNT LOOP
4424: IF(l_cp AND p_cas_v2_objs(i).cust_acct_site_use_objs(j).site_use_profile_obj IS NULL) THEN
4423: FOR j IN 1..p_cas_v2_objs(i).cust_acct_site_use_objs.COUNT LOOP
4424: IF(l_cp AND p_cas_v2_objs(i).cust_acct_site_use_objs(j).site_use_profile_obj IS NULL) THEN
4425: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
4426: fnd_message.set_token('OBJECT' ,'SITE_USE_PROFILE');
4427: fnd_msg_pub.add;
4428: RETURN FALSE;
4429: END IF;
4430: IF(l_cpa AND
4431: (p_cas_v2_objs(i).cust_acct_site_use_objs(j).site_use_profile_obj.cust_profile_amt_objs IS NULL OR
4431: (p_cas_v2_objs(i).cust_acct_site_use_objs(j).site_use_profile_obj.cust_profile_amt_objs IS NULL OR
4432: p_cas_v2_objs(i).cust_acct_site_use_objs(j).site_use_profile_obj.cust_profile_amt_objs.COUNT < 1)) THEN
4433: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
4434: fnd_message.set_token('OBJECT' ,'SITE_USE_PROFILE_AMOUNT');
4435: fnd_msg_pub.add;
4436: RETURN FALSE;
4437: END IF;
4438: -- for bank account use and payment method
4439: IF(l_bau AND
4440: (p_cas_v2_objs(i).cust_acct_site_use_objs(j).bank_acct_use_objs IS NULL OR
4441: p_cas_v2_objs(i).cust_acct_site_use_objs(j).bank_acct_use_objs.COUNT < 1)) THEN
4442: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
4443: fnd_message.set_token('OBJECT' ,'BANK_ACCOUNT');
4444: fnd_msg_pub.add;
4445: RETURN FALSE;
4446: END IF;
4447: IF(l_pm AND
4448: (p_cas_v2_objs(i).cust_acct_site_use_objs(j).payment_method_objs IS NULL OR
4448: (p_cas_v2_objs(i).cust_acct_site_use_objs(j).payment_method_objs IS NULL OR
4449: p_cas_v2_objs(i).cust_acct_site_use_objs(j).payment_method_objs.COUNT < 1)) THEN
4450: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
4451: fnd_message.set_token('OBJECT' ,'PAYMENT_METHOD');
4452: fnd_msg_pub.add;
4453: RETURN FALSE;
4454: END IF;
4455: END LOOP;
4456: END IF;
4501:
4502: IF(p_ca_v2_objs IS NULL OR p_ca_v2_objs.COUNT < 1) THEN
4503: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
4504: fnd_message.set_token('OBJECT' ,'CUST_ACCT');
4505: fnd_msg_pub.add;
4506: RETURN FALSE;
4507: END IF;
4508:
4509: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
4584: (p_ca_v2_objs(i).acct_relate_objs IS NULL OR
4585: p_ca_v2_objs(i).acct_relate_objs.COUNT < 1)) THEN
4586: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
4587: fnd_message.set_token('OBJECT' ,'CUSTOMER_ACCOUNT_RELATE');
4588: fnd_msg_pub.add;
4589: RETURN FALSE;
4590: END IF;
4591:
4592: -- for bank account use and payment method
4594: (p_ca_v2_objs(i).bank_acct_use_objs IS NULL OR
4595: p_ca_v2_objs(i).bank_acct_use_objs.COUNT < 1)) THEN
4596: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
4597: fnd_message.set_token('OBJECT' ,'BANK_ACCOUNT');
4598: fnd_msg_pub.add;
4599: RETURN FALSE;
4600: END IF;
4601: IF(l_pm AND
4602: (p_ca_v2_objs(i).payment_method_objs IS NULL OR
4602: (p_ca_v2_objs(i).payment_method_objs IS NULL OR
4603: p_ca_v2_objs(i).payment_method_objs.COUNT < 1)) THEN
4604: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
4605: fnd_message.set_token('OBJECT' ,'PAYMENT_METHOD');
4606: fnd_msg_pub.add;
4607: RETURN FALSE;
4608: END IF;
4609:
4610: IF(l_cp AND p_ca_v2_objs(i).cust_profile_obj IS NULL) THEN
4614: (p_ca_v2_objs(i).cust_profile_obj.cust_profile_amt_objs IS NULL OR
4615: p_ca_v2_objs(i).cust_profile_obj.cust_profile_amt_objs.COUNT < 1)) THEN
4616: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
4617: fnd_message.set_token('OBJECT' ,'CUSTOMER_PROFILE_AMOUNT');
4618: fnd_msg_pub.add;
4619: RETURN FALSE;
4620: END IF;
4621: END IF;
4622: END LOOP;