[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.
2036: FETCH is_contact_point_exist INTO l_parent_id, l_parent_table;
2037: CLOSE is_contact_point_exist;
2038: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id OR l_parent_table <> l_input_parent_table) THEN
2039: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2040: FND_MSG_PUB.ADD;
2041: RETURN 'E';
2042: END IF;
2043: l_dummy := 'X';
2044: ELSIF(p_entity_type = 'HZ_PARTY_SITES') THEN
2046: FETCH is_party_site_exist INTO l_parent_id;
2047: CLOSE is_party_site_exist;
2048: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id) THEN
2049: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2050: FND_MSG_PUB.ADD;
2051: RETURN 'E';
2052: END IF;
2053: l_dummy := 'X';
2054: ELSIF(p_entity_type = 'HZ_LOCATIONS') THEN
2064: FETCH is_org_contact_exist INTO l_parent_id;
2065: CLOSE is_org_contact_exist;
2066: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id) THEN
2067: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2068: FND_MSG_PUB.ADD;
2069: RETURN 'E';
2070: END IF;
2071: l_dummy := 'X';
2072: ELSIF(p_entity_type = 'HZ_CUST_ACCOUNTS') THEN
2074: FETCH is_cust_account_exist INTO l_parent_id;
2075: CLOSE is_cust_account_exist;
2076: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id) THEN
2077: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2078: FND_MSG_PUB.ADD;
2079: RETURN 'E';
2080: END IF;
2081: l_dummy := 'X';
2082: ELSIF(p_entity_type = 'HZ_CUST_ACCT_SITES_ALL') THEN
2084: FETCH is_cust_acct_site_exist INTO l_parent_id;
2085: CLOSE is_cust_acct_site_exist;
2086: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id) THEN
2087: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2088: FND_MSG_PUB.ADD;
2089: RETURN 'E';
2090: END IF;
2091: l_dummy := 'X';
2092: ELSIF(p_entity_type = 'HZ_CUST_SITE_USES_ALL') THEN
2094: FETCH is_cust_site_use_exist INTO l_parent_id;
2095: CLOSE is_cust_site_use_exist;
2096: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id) THEN
2097: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2098: FND_MSG_PUB.ADD;
2099: RETURN 'E';
2100: END IF;
2101: l_dummy := 'X';
2102: ELSIF(p_entity_type = 'HZ_CUST_ACCOUNT_ROLES') THEN
2105: CLOSE is_cust_acct_role_exist;
2106: IF(p_parent_obj_type = 'CUST_ACCT_SITE') THEN
2107: IF(l_parent_id IS NULL OR l_acct_site_id <> p_parent_id) THEN
2108: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2109: FND_MSG_PUB.ADD;
2110: RETURN 'E';
2111: END IF;
2112: ELSIF(p_parent_obj_type = 'CUST_ACCT') THEN
2113: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id) THEN
2111: END IF;
2112: ELSIF(p_parent_obj_type = 'CUST_ACCT') THEN
2113: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id) THEN
2114: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2115: FND_MSG_PUB.ADD;
2116: RETURN 'E';
2117: END IF;
2118: END IF;
2119: l_dummy := 'X';
2141: FETCH is_contact_point_exist INTO l_parent_id, l_parent_table;
2142: CLOSE is_contact_point_exist;
2143: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id OR l_parent_table <> l_input_parent_table) THEN
2144: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2145: FND_MSG_PUB.ADD;
2146: RETURN 'E';
2147: END IF;
2148: END IF;
2149: END IF;
2485: WHEN l_bus_object.business_object_code(i) = 'PHONE' THEN
2486: IF(p_phone_objs IS NULL OR p_phone_objs.COUNT < 1) THEN
2487: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
2488: fnd_message.set_token('OBJECT' ,'PHONE');
2489: fnd_msg_pub.add;
2490: RETURN FALSE;
2491: ELSE
2492: FOR j IN 1..p_phone_objs.COUNT LOOP
2493: IF(l_phone_cpref AND
2494: (p_phone_objs(j).contact_pref_objs IS NULL OR
2495: p_phone_objs(j).contact_pref_objs.COUNT < 1)) THEN
2496: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2497: fnd_message.set_token('ENTITY' ,'PHONE-CONTACT_PREFERENCE');
2498: fnd_msg_pub.add;
2499: RETURN FALSE;
2500: END IF;
2501: END LOOP;
2502: END IF;
2503: WHEN l_bus_object.business_object_code(i) = 'EMAIL' THEN
2504: IF(p_email_objs IS NULL OR p_email_objs.COUNT < 1) THEN
2505: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
2506: fnd_message.set_token('OBJECT' ,'EMAIL');
2507: fnd_msg_pub.add;
2508: RETURN FALSE;
2509: ELSE
2510: FOR j IN 1..p_email_objs.COUNT LOOP
2511: IF(l_email_cpref AND
2512: (p_email_objs(j).contact_pref_objs IS NULL OR
2513: p_email_objs(j).contact_pref_objs.COUNT < 1)) THEN
2514: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2515: fnd_message.set_token('ENTITY' ,'EMAIL-CONTACT_PREFERENCE');
2516: fnd_msg_pub.add;
2517: RETURN FALSE;
2518: END IF;
2519: END LOOP;
2520: END IF;
2521: WHEN l_bus_object.business_object_code(i) = 'TLX' THEN
2522: IF(p_telex_objs IS NULL OR p_telex_objs.COUNT < 1) THEN
2523: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
2524: fnd_message.set_token('OBJECT' ,'TELEX');
2525: fnd_msg_pub.add;
2526: RETURN FALSE;
2527: ELSE
2528: FOR j IN 1..p_telex_objs.COUNT LOOP
2529: IF(l_telex_cpref AND
2530: (p_telex_objs(j).contact_pref_objs IS NULL OR
2531: p_telex_objs(j).contact_pref_objs.COUNT < 1)) THEN
2532: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2533: fnd_message.set_token('ENTITY' ,'TLX-CONTACT_PREFERENCE');
2534: fnd_msg_pub.add;
2535: RETURN FALSE;
2536: END IF;
2537: END LOOP;
2538: END IF;
2539: WHEN l_bus_object.business_object_code(i) = 'WEB' THEN
2540: IF(p_web_objs IS NULL OR p_web_objs.COUNT < 1) THEN
2541: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
2542: fnd_message.set_token('OBJECT' ,'WEB');
2543: fnd_msg_pub.add;
2544: RETURN FALSE;
2545: ELSE
2546: FOR j IN 1..p_web_objs.COUNT LOOP
2547: IF(l_web_cpref AND
2548: (p_web_objs(j).contact_pref_objs IS NULL OR
2549: p_web_objs(j).contact_pref_objs.COUNT < 1)) THEN
2550: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2551: fnd_message.set_token('ENTITY' ,'WEB-CONTACT_PREFERENCE');
2552: fnd_msg_pub.add;
2553: RETURN FALSE;
2554: END IF;
2555: END LOOP;
2556: END IF;
2557: WHEN l_bus_object.business_object_code(i) = 'EDI' THEN
2558: IF(p_edi_objs IS NULL OR p_edi_objs.COUNT < 1) THEN
2559: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
2560: fnd_message.set_token('OBJECT' ,'EDI');
2561: fnd_msg_pub.add;
2562: RETURN FALSE;
2563: ELSE
2564: FOR j IN 1..p_edi_objs.COUNT LOOP
2565: IF(l_edi_cpref AND
2566: (p_edi_objs(j).contact_pref_objs IS NULL OR
2567: p_edi_objs(j).contact_pref_objs.COUNT < 1)) THEN
2568: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2569: fnd_message.set_token('ENTITY' ,'EDI-CONTACT_PREFERENCE');
2570: fnd_msg_pub.add;
2571: RETURN FALSE;
2572: END IF;
2573: END LOOP;
2574: END IF;
2575: WHEN l_bus_object.business_object_code(i) = 'EFT' THEN
2576: IF(p_eft_objs IS NULL OR p_eft_objs.COUNT < 1) THEN
2577: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
2578: fnd_message.set_token('OBJECT' ,'EFT');
2579: fnd_msg_pub.add;
2580: RETURN FALSE;
2581: ELSE
2582: FOR j IN 1..p_eft_objs.COUNT LOOP
2583: IF(l_eft_cpref AND
2584: (p_eft_objs(j).contact_pref_objs IS NULL OR
2585: p_eft_objs(j).contact_pref_objs.COUNT < 1)) THEN
2586: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2587: fnd_message.set_token('ENTITY' ,'EFT-CONTACT_PREFERENCE');
2588: fnd_msg_pub.add;
2589: RETURN FALSE;
2590: END IF;
2591: END LOOP;
2592: END IF;
2593: WHEN l_bus_object.business_object_code(i) = 'SMS' THEN
2594: IF(p_sms_objs IS NULL OR p_sms_objs.COUNT < 1) THEN
2595: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
2596: fnd_message.set_token('OBJECT' ,'SMS');
2597: fnd_msg_pub.add;
2598: RETURN FALSE;
2599: ELSE
2600: FOR j IN 1..p_sms_objs.COUNT LOOP
2601: IF(l_sms_cpref AND
2602: (p_sms_objs(j).contact_pref_objs IS NULL OR
2603: p_sms_objs(j).contact_pref_objs.COUNT < 1)) THEN
2604: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2605: fnd_message.set_token('ENTITY' ,'SMS-CONTACT_PREFERENCE');
2606: fnd_msg_pub.add;
2607: RETURN FALSE;
2608: END IF;
2609: END LOOP;
2610: END IF;
2661:
2662: IF(p_ps_objs IS NULL OR p_ps_objs.COUNT < 1) THEN
2663: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
2664: fnd_message.set_token('OBJECT' ,'PARTY_SITE');
2665: fnd_msg_pub.add;
2666: RETURN FALSE;
2667: END IF;
2668:
2669: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
2725: FOR i IN 1..p_ps_objs.COUNT LOOP
2726: IF(p_ps_objs(i).location_obj IS NULL) THEN
2727: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
2728: fnd_message.set_token('OBJECT' ,'LOCATION');
2729: fnd_msg_pub.add;
2730: RETURN FALSE;
2731: END IF;
2732: IF(l_psu AND
2733: (p_ps_objs(i).party_site_use_objs IS NULL OR
2733: (p_ps_objs(i).party_site_use_objs IS NULL OR
2734: p_ps_objs(i).party_site_use_objs.COUNT < 1)) THEN
2735: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2736: fnd_message.set_token('OBJECT' ,'PARTY_SITE_USE');
2737: fnd_msg_pub.add;
2738: RETURN FALSE;
2739: END IF;
2740: IF(l_cpref AND
2741: (p_ps_objs(i).contact_pref_objs IS NULL OR
2741: (p_ps_objs(i).contact_pref_objs IS NULL OR
2742: p_ps_objs(i).contact_pref_objs.COUNT < 1)) THEN
2743: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2744: fnd_message.set_token('OBJECT' ,'PARTY_SITE: CONTACT_PREFERENCE');
2745: fnd_msg_pub.add;
2746: RETURN FALSE;
2747: END IF;
2748: IF(l_ps_ext AND
2749: (p_ps_objs(i).ext_attributes_objs IS NULL OR
2749: (p_ps_objs(i).ext_attributes_objs IS NULL OR
2750: p_ps_objs(i).ext_attributes_objs.COUNT < 1)) THEN
2751: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2752: fnd_message.set_token('OBJECT' ,'PARTY_SITE: EXTENSIBILITY');
2753: fnd_msg_pub.add;
2754: RETURN FALSE;
2755: END IF;
2756: IF(l_loc_ext AND
2757: (p_ps_objs(i).location_obj.ext_attributes_objs IS NULL OR
2757: (p_ps_objs(i).location_obj.ext_attributes_objs IS NULL OR
2758: p_ps_objs(i).location_obj.ext_attributes_objs.COUNT < 1)) THEN
2759: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2760: fnd_message.set_token('OBJECT' ,'LOCATION: EXTENSIBILITY');
2761: fnd_msg_pub.add;
2762: RETURN FALSE;
2763: END IF;
2764: IF(l_phone_code IS NOT NULL OR l_telex_code IS NOT NULL OR
2765: l_email_code IS NOT NULL OR l_web_code IS NOT NULL) THEN
2928: (p_person_obj.preference_objs IS NULL OR
2929: p_person_obj.preference_objs.COUNT < 1)) THEN
2930: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2931: fnd_message.set_token('OBJECT' ,'PARTY_PREFERENCE');
2932: fnd_msg_pub.add;
2933: RETURN FALSE;
2934: END IF;
2935: IF(l_class AND
2936: (p_person_obj.class_objs IS NULL OR
2936: (p_person_obj.class_objs IS NULL OR
2937: p_person_obj.class_objs.COUNT < 1)) THEN
2938: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2939: fnd_message.set_token('OBJECT' ,'CLASSIFICATION');
2940: fnd_msg_pub.add;
2941: RETURN FALSE;
2942: END IF;
2943: IF(l_lang AND
2944: (p_person_obj.language_objs IS NULL OR
2944: (p_person_obj.language_objs IS NULL OR
2945: p_person_obj.language_objs.COUNT < 1)) THEN
2946: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2947: fnd_message.set_token('OBJECT' ,'LANGUAGE');
2948: fnd_msg_pub.add;
2949: RETURN FALSE;
2950: END IF;
2951: IF(l_edu AND
2952: (p_person_obj.education_objs IS NULL OR
2952: (p_person_obj.education_objs IS NULL OR
2953: p_person_obj.education_objs.COUNT < 1)) THEN
2954: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2955: fnd_message.set_token('OBJECT' ,'EDUCATION');
2956: fnd_msg_pub.add;
2957: RETURN FALSE;
2958: END IF;
2959: IF(l_citiz AND
2960: (p_person_obj.citizenship_objs IS NULL OR
2960: (p_person_obj.citizenship_objs IS NULL OR
2961: p_person_obj.citizenship_objs.COUNT < 1)) THEN
2962: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2963: fnd_message.set_token('OBJECT' ,'CITIZENSHIP');
2964: fnd_msg_pub.add;
2965: RETURN FALSE;
2966: END IF;
2967: IF(l_emp_hist AND
2968: (p_person_obj.employ_hist_objs IS NULL OR
2968: (p_person_obj.employ_hist_objs IS NULL OR
2969: p_person_obj.employ_hist_objs.COUNT < 1)) THEN
2970: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2971: fnd_message.set_token('OBJECT' ,'EMPLOYMENT_HISTORY');
2972: fnd_msg_pub.add;
2973: RETURN FALSE;
2974: FOR j IN 1..p_person_obj.employ_hist_objs.COUNT LOOP
2975: IF(l_work_class AND
2976: (p_person_obj.employ_hist_objs(j).work_class_objs IS NULL OR
2976: (p_person_obj.employ_hist_objs(j).work_class_objs IS NULL OR
2977: p_person_obj.employ_hist_objs(j).work_class_objs.COUNT < 1)) THEN
2978: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2979: fnd_message.set_token('OBJECT' ,'WORK_CLASS');
2980: fnd_msg_pub.add;
2981: RETURN FALSE;
2982: END IF;
2983: END LOOP;
2984: END IF;
2986: (p_person_obj.interest_objs IS NULL OR
2987: p_person_obj.interest_objs.COUNT < 1)) THEN
2988: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2989: fnd_message.set_token('OBJECT' ,'PERSON_INTEREST');
2990: fnd_msg_pub.add;
2991: RETURN FALSE;
2992: END IF;
2993: IF(l_cert AND
2994: (p_person_obj.certification_objs IS NULL OR
2994: (p_person_obj.certification_objs IS NULL OR
2995: p_person_obj.certification_objs.COUNT < 1)) THEN
2996: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
2997: fnd_message.set_token('OBJECT' ,'CERTIFICATION');
2998: fnd_msg_pub.add;
2999: RETURN FALSE;
3000: END IF;
3001: IF(l_fin_prof AND
3002: (p_person_obj.financial_prof_objs IS NULL OR
3002: (p_person_obj.financial_prof_objs IS NULL OR
3003: p_person_obj.financial_prof_objs.COUNT < 1)) THEN
3004: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3005: fnd_message.set_token('OBJECT' ,'FINANCIAL_PROFILE');
3006: fnd_msg_pub.add;
3007: RETURN FALSE;
3008: END IF;
3009: IF(l_rel AND
3010: (p_person_obj.relationship_objs IS NULL OR
3010: (p_person_obj.relationship_objs IS NULL OR
3011: p_person_obj.relationship_objs.COUNT < 1)) THEN
3012: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3013: fnd_message.set_token('OBJECT' ,'RELATIONSHIP');
3014: fnd_msg_pub.add;
3015: RETURN FALSE;
3016: END IF;
3017: IF(l_cpref AND
3018: (p_person_obj.contact_pref_objs IS NULL OR
3018: (p_person_obj.contact_pref_objs IS NULL OR
3019: p_person_obj.contact_pref_objs.COUNT < 1)) THEN
3020: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3021: fnd_message.set_token('OBJECT' ,'PERSON: CONTACT_PREFERENCE');
3022: fnd_msg_pub.add;
3023: RETURN FALSE;
3024: END IF;
3025: IF(l_ext AND
3026: (p_person_obj.ext_attributes_objs IS NULL OR
3026: (p_person_obj.ext_attributes_objs IS NULL OR
3027: p_person_obj.ext_attributes_objs.COUNT < 1)) THEN
3028: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3029: fnd_message.set_token('OBJECT' ,'PERSON: EXTENSIBILITY');
3030: fnd_msg_pub.add;
3031: RETURN FALSE;
3032: END IF;
3033: IF(l_phone_code IS NOT NULL OR l_email_code IS NOT NULL OR
3034: l_web_code IS NOT NULL OR l_sms_code IS NOT NULL) THEN
3106:
3107: IF(p_oc_objs IS NULL OR p_oc_objs.COUNT < 1) THEN
3108: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
3109: fnd_message.set_token('OBJECT' ,'ORG_CONTACT');
3110: fnd_msg_pub.add;
3111: RETURN FALSE;
3112: END IF;
3113:
3114: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
3172: FOR i IN 1..p_oc_objs.COUNT LOOP
3173: IF(p_oc_objs(i).person_profile_obj IS NULL) THEN
3174: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3175: fnd_message.set_token('OBJECT' ,'PERSON_CONTACT');
3176: fnd_msg_pub.add;
3177: RETURN FALSE;
3178: END IF;
3179:
3180: IF(l_ocr AND
3181: (p_oc_objs(i).org_contact_role_objs IS NULL OR
3182: p_oc_objs(i).org_contact_role_objs.COUNT < 1)) THEN
3183: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3184: fnd_message.set_token('OBJECT' ,'ORG_CONTACT_ROLE');
3185: fnd_msg_pub.add;
3186: RETURN FALSE;
3187: END IF;
3188: IF(l_cpref AND
3189: (p_oc_objs(i).contact_pref_objs IS NULL OR
3189: (p_oc_objs(i).contact_pref_objs IS NULL OR
3190: p_oc_objs(i).contact_pref_objs.COUNT < 1)) THEN
3191: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3192: fnd_message.set_token('OBJECT' ,'ORG_CONTACT: CONTACT_PREFERENCE');
3193: fnd_msg_pub.add;
3194: RETURN FALSE;
3195: END IF;
3196:
3197: IF(l_phone_code IS NOT NULL OR l_telex_code IS NOT NULL OR
3372: (p_organization_obj.preference_objs IS NULL OR
3373: p_organization_obj.preference_objs.COUNT < 1)) THEN
3374: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3375: fnd_message.set_token('OBJECT' ,'PARTY_PREFERENCE');
3376: fnd_msg_pub.add;
3377: RETURN FALSE;
3378: END IF;
3379: IF(l_credit AND
3380: (p_organization_obj.credit_rating_objs IS NULL OR
3380: (p_organization_obj.credit_rating_objs IS NULL OR
3381: p_organization_obj.credit_rating_objs.COUNT < 1)) THEN
3382: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3383: fnd_message.set_token('OBJECT' ,'CREDIT_RATING');
3384: fnd_msg_pub.add;
3385: RETURN FALSE;
3386: END IF;
3387: IF(l_rel AND
3388: (p_organization_obj.relationship_objs IS NULL OR
3388: (p_organization_obj.relationship_objs IS NULL OR
3389: p_organization_obj.relationship_objs.COUNT < 1)) THEN
3390: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3391: fnd_message.set_token('OBJECT' ,'RELATIONSHIP');
3392: fnd_msg_pub.add;
3393: RETURN FALSE;
3394: END IF;
3395: IF(l_class AND
3396: (p_organization_obj.class_objs IS NULL OR
3396: (p_organization_obj.class_objs IS NULL OR
3397: p_organization_obj.class_objs.COUNT < 1)) THEN
3398: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3399: fnd_message.set_token('OBJECT' ,'CLASSIFICATION');
3400: fnd_msg_pub.add;
3401: RETURN FALSE;
3402: END IF;
3403: IF(l_fin_report AND
3404: (p_organization_obj.financial_report_objs IS NULL OR
3404: (p_organization_obj.financial_report_objs IS NULL OR
3405: p_organization_obj.financial_report_objs.COUNT < 1)) THEN
3406: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3407: fnd_message.set_token('OBJECT' ,'FINANCIAL_REPORT');
3408: fnd_msg_pub.add;
3409: RETURN FALSE;
3410:
3411: -- financial report always require financial number
3412: FOR j IN 1..p_organization_obj.financial_report_objs.COUNT LOOP
3413: IF(p_organization_obj.financial_report_objs(j).financial_number_objs IS NULL OR
3414: p_organization_obj.financial_report_objs(j).financial_number_objs.COUNT < 1) THEN
3415: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3416: fnd_message.set_token('OBJECT' ,'FINANCIAL_NUMBER');
3417: fnd_msg_pub.add;
3418: RETURN FALSE;
3419: END IF;
3420: END LOOP;
3421: END IF;
3423: (p_organization_obj.certification_objs IS NULL OR
3424: p_organization_obj.certification_objs.COUNT < 1)) THEN
3425: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3426: fnd_message.set_token('OBJECT' ,'CERTIFICATION');
3427: fnd_msg_pub.add;
3428: RETURN FALSE;
3429: END IF;
3430: IF(l_fin_prof AND
3431: (p_organization_obj.financial_prof_objs IS NULL OR
3431: (p_organization_obj.financial_prof_objs IS NULL OR
3432: p_organization_obj.financial_prof_objs.COUNT < 1)) THEN
3433: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3434: fnd_message.set_token('OBJECT' ,'FINANCIAL_PROFILE');
3435: fnd_msg_pub.add;
3436: RETURN FALSE;
3437: END IF;
3438: IF(l_cpref AND
3439: (p_organization_obj.contact_pref_objs IS NULL OR
3439: (p_organization_obj.contact_pref_objs IS NULL OR
3440: p_organization_obj.contact_pref_objs.COUNT < 1)) THEN
3441: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3442: fnd_message.set_token('OBJECT' ,'ORG: CONTACT_PREFERENCE');
3443: fnd_msg_pub.add;
3444: RETURN FALSE;
3445: END IF;
3446: IF(l_ext AND
3447: (p_organization_obj.ext_attributes_objs IS NULL OR
3447: (p_organization_obj.ext_attributes_objs IS NULL OR
3448: p_organization_obj.ext_attributes_objs.COUNT < 1)) THEN
3449: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3450: fnd_message.set_token('OBJECT' ,'ORG: EXTENSIBILITY');
3451: fnd_msg_pub.add;
3452: RETURN FALSE;
3453: END IF;
3454:
3455: IF(l_phone_code IS NOT NULL OR l_telex_code IS NOT NULL OR
3525:
3526: IF(p_cac_objs IS NULL OR p_cac_objs.COUNT < 1) THEN
3527: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
3528: fnd_message.set_token('OBJECT' ,'CUST_ACCT_CONTACT');
3529: fnd_msg_pub.add;
3530: RETURN FALSE;
3531: END IF;
3532:
3533: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
3549: (p_cac_objs(i).contact_role_objs IS NULL OR
3550: p_cac_objs(i).contact_role_objs.COUNT < 1)) THEN
3551: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3552: fnd_message.set_token('OBJECT' ,'ROLE_RESPONSIBILITY');
3553: fnd_msg_pub.add;
3554: RETURN FALSE;
3555: END IF;
3556: END LOOP;
3557:
3598:
3599: IF(p_cas_objs IS NULL OR p_cas_objs.COUNT < 1) THEN
3600: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
3601: fnd_message.set_token('OBJECT' ,'CUST_ACCT_SITE');
3602: fnd_msg_pub.add;
3603: RETURN FALSE;
3604: END IF;
3605:
3606: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
3659: (p_cas_objs(i).cust_acct_site_use_objs IS NULL OR
3660: p_cas_objs(i).cust_acct_site_use_objs.COUNT < 1)) THEN
3661: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3662: fnd_message.set_token('OBJECT' ,'CUST_ACCT_SITE_USE');
3663: fnd_msg_pub.add;
3664: RETURN FALSE;
3665:
3666: FOR j IN 1..p_cas_objs(i).cust_acct_site_use_objs.COUNT LOOP
3667: IF(l_cp AND p_cas_objs(i).cust_acct_site_use_objs(j).site_use_profile_obj IS NULL) THEN
3666: FOR j IN 1..p_cas_objs(i).cust_acct_site_use_objs.COUNT LOOP
3667: IF(l_cp AND p_cas_objs(i).cust_acct_site_use_objs(j).site_use_profile_obj IS NULL) THEN
3668: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3669: fnd_message.set_token('OBJECT' ,'SITE_USE_PROFILE');
3670: fnd_msg_pub.add;
3671: RETURN FALSE;
3672: END IF;
3673: IF(l_cpa AND
3674: (p_cas_objs(i).cust_acct_site_use_objs(j).site_use_profile_obj.cust_profile_amt_objs IS NULL OR
3674: (p_cas_objs(i).cust_acct_site_use_objs(j).site_use_profile_obj.cust_profile_amt_objs IS NULL OR
3675: p_cas_objs(i).cust_acct_site_use_objs(j).site_use_profile_obj.cust_profile_amt_objs.COUNT < 1)) THEN
3676: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3677: fnd_message.set_token('OBJECT' ,'SITE_USE_PROFILE_AMOUNT');
3678: fnd_msg_pub.add;
3679: RETURN FALSE;
3680: END IF;
3681: -- for bank account use and payment method
3682: IF(l_bau AND
3683: (p_cas_objs(i).cust_acct_site_use_objs(j).bank_acct_use_objs IS NULL OR
3684: p_cas_objs(i).cust_acct_site_use_objs(j).bank_acct_use_objs.COUNT < 1)) THEN
3685: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3686: fnd_message.set_token('OBJECT' ,'BANK_ACCOUNT');
3687: fnd_msg_pub.add;
3688: RETURN FALSE;
3689: END IF;
3690: IF(l_pm AND
3691: (p_cas_objs(i).cust_acct_site_use_objs(j).payment_method_obj IS NULL)) THEN
3690: IF(l_pm AND
3691: (p_cas_objs(i).cust_acct_site_use_objs(j).payment_method_obj IS NULL)) THEN
3692: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3693: fnd_message.set_token('OBJECT' ,'PAYMENT_METHOD');
3694: fnd_msg_pub.add;
3695: RETURN FALSE;
3696: END IF;
3697: END LOOP;
3698: END IF;
3743:
3744: IF(p_ca_objs IS NULL OR p_ca_objs.COUNT < 1) THEN
3745: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
3746: fnd_message.set_token('OBJECT' ,'CUST_ACCT');
3747: fnd_msg_pub.add;
3748: RETURN FALSE;
3749: END IF;
3750:
3751: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
3826: (p_ca_objs(i).acct_relate_objs IS NULL OR
3827: p_ca_objs(i).acct_relate_objs.COUNT < 1)) THEN
3828: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3829: fnd_message.set_token('OBJECT' ,'CUSTOMER_ACCOUNT_RELATE');
3830: fnd_msg_pub.add;
3831: RETURN FALSE;
3832: END IF;
3833:
3834: -- for bank account use and payment method
3836: (p_ca_objs(i).bank_acct_use_objs IS NULL OR
3837: p_ca_objs(i).bank_acct_use_objs.COUNT < 1)) THEN
3838: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3839: fnd_message.set_token('OBJECT' ,'BANK_ACCOUNT');
3840: fnd_msg_pub.add;
3841: RETURN FALSE;
3842: END IF;
3843: IF(l_pm AND
3844: (p_ca_objs(i).payment_method_obj IS NULL)) THEN
3843: IF(l_pm AND
3844: (p_ca_objs(i).payment_method_obj IS NULL)) THEN
3845: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3846: fnd_message.set_token('OBJECT' ,'PAYMENT_METHOD');
3847: fnd_msg_pub.add;
3848: RETURN FALSE;
3849: END IF;
3850:
3851: IF(l_cp AND p_ca_objs(i).cust_profile_obj IS NULL) THEN
3855: (p_ca_objs(i).cust_profile_obj.cust_profile_amt_objs IS NULL OR
3856: p_ca_objs(i).cust_profile_obj.cust_profile_amt_objs.COUNT < 1)) THEN
3857: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
3858: fnd_message.set_token('OBJECT' ,'CUSTOMER_PROFILE_AMOUNT');
3859: fnd_msg_pub.add;
3860: RETURN FALSE;
3861: END IF;
3862: END IF;
3863: END LOOP;
4350:
4351: IF(p_cas_v2_objs IS NULL OR p_cas_v2_objs.COUNT < 1) THEN
4352: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
4353: fnd_message.set_token('OBJECT' ,'CUST_ACCT_SITE');
4354: fnd_msg_pub.add;
4355: RETURN FALSE;
4356: END IF;
4357:
4358: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
4411: (p_cas_v2_objs(i).cust_acct_site_use_objs IS NULL OR
4412: p_cas_v2_objs(i).cust_acct_site_use_objs.COUNT < 1)) THEN
4413: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
4414: fnd_message.set_token('OBJECT' ,'CUST_ACCT_SITE_USE');
4415: fnd_msg_pub.add;
4416: RETURN FALSE;
4417:
4418: FOR j IN 1..p_cas_v2_objs(i).cust_acct_site_use_objs.COUNT LOOP
4419: IF(l_cp AND p_cas_v2_objs(i).cust_acct_site_use_objs(j).site_use_profile_obj IS NULL) THEN
4418: FOR j IN 1..p_cas_v2_objs(i).cust_acct_site_use_objs.COUNT LOOP
4419: IF(l_cp AND p_cas_v2_objs(i).cust_acct_site_use_objs(j).site_use_profile_obj IS NULL) THEN
4420: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
4421: fnd_message.set_token('OBJECT' ,'SITE_USE_PROFILE');
4422: fnd_msg_pub.add;
4423: RETURN FALSE;
4424: END IF;
4425: IF(l_cpa AND
4426: (p_cas_v2_objs(i).cust_acct_site_use_objs(j).site_use_profile_obj.cust_profile_amt_objs IS NULL OR
4426: (p_cas_v2_objs(i).cust_acct_site_use_objs(j).site_use_profile_obj.cust_profile_amt_objs IS NULL OR
4427: p_cas_v2_objs(i).cust_acct_site_use_objs(j).site_use_profile_obj.cust_profile_amt_objs.COUNT < 1)) THEN
4428: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
4429: fnd_message.set_token('OBJECT' ,'SITE_USE_PROFILE_AMOUNT');
4430: fnd_msg_pub.add;
4431: RETURN FALSE;
4432: END IF;
4433: -- for bank account use and payment method
4434: IF(l_bau AND
4435: (p_cas_v2_objs(i).cust_acct_site_use_objs(j).bank_acct_use_objs IS NULL OR
4436: p_cas_v2_objs(i).cust_acct_site_use_objs(j).bank_acct_use_objs.COUNT < 1)) THEN
4437: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
4438: fnd_message.set_token('OBJECT' ,'BANK_ACCOUNT');
4439: fnd_msg_pub.add;
4440: RETURN FALSE;
4441: END IF;
4442: IF(l_pm AND
4443: (p_cas_v2_objs(i).cust_acct_site_use_objs(j).payment_method_objs IS NULL OR
4443: (p_cas_v2_objs(i).cust_acct_site_use_objs(j).payment_method_objs IS NULL OR
4444: p_cas_v2_objs(i).cust_acct_site_use_objs(j).payment_method_objs.COUNT < 1)) THEN
4445: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
4446: fnd_message.set_token('OBJECT' ,'PAYMENT_METHOD');
4447: fnd_msg_pub.add;
4448: RETURN FALSE;
4449: END IF;
4450: END LOOP;
4451: END IF;
4496:
4497: IF(p_ca_v2_objs IS NULL OR p_ca_v2_objs.COUNT < 1) THEN
4498: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_OBJ');
4499: fnd_message.set_token('OBJECT' ,'CUST_ACCT');
4500: fnd_msg_pub.add;
4501: RETURN FALSE;
4502: END IF;
4503:
4504: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
4579: (p_ca_v2_objs(i).acct_relate_objs IS NULL OR
4580: p_ca_v2_objs(i).acct_relate_objs.COUNT < 1)) THEN
4581: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
4582: fnd_message.set_token('OBJECT' ,'CUSTOMER_ACCOUNT_RELATE');
4583: fnd_msg_pub.add;
4584: RETURN FALSE;
4585: END IF;
4586:
4587: -- for bank account use and payment method
4589: (p_ca_v2_objs(i).bank_acct_use_objs IS NULL OR
4590: p_ca_v2_objs(i).bank_acct_use_objs.COUNT < 1)) THEN
4591: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
4592: fnd_message.set_token('OBJECT' ,'BANK_ACCOUNT');
4593: fnd_msg_pub.add;
4594: RETURN FALSE;
4595: END IF;
4596: IF(l_pm AND
4597: (p_ca_v2_objs(i).payment_method_objs IS NULL OR
4597: (p_ca_v2_objs(i).payment_method_objs IS NULL OR
4598: p_ca_v2_objs(i).payment_method_objs.COUNT < 1)) THEN
4599: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
4600: fnd_message.set_token('OBJECT' ,'PAYMENT_METHOD');
4601: fnd_msg_pub.add;
4602: RETURN FALSE;
4603: END IF;
4604:
4605: IF(l_cp AND p_ca_v2_objs(i).cust_profile_obj IS NULL) THEN
4609: (p_ca_v2_objs(i).cust_profile_obj.cust_profile_amt_objs IS NULL OR
4610: p_ca_v2_objs(i).cust_profile_obj.cust_profile_amt_objs.COUNT < 1)) THEN
4611: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
4612: fnd_message.set_token('OBJECT' ,'CUSTOMER_PROFILE_AMOUNT');
4613: fnd_msg_pub.add;
4614: RETURN FALSE;
4615: END IF;
4616: END IF;
4617: END LOOP;