[Home] [Help]
249: WHEN fnd_api.g_exc_error THEN
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,
291:
292: WHEN OTHERS THEN
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,
292: WHEN OTHERS THEN
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,
430: IF(px_id IS NOT NULL) THEN
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
504: OPEN is_cp_valid(l_owner_table_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;
518: -- if px_id pass in
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
528: IF(l_ss_flag = 'Y') THEN
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
535: -- if px_os/px_osr is valid
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;
552: -- else, get owner_table_id and assign it to 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
609: END IF;
610: WHEN OTHERS THEN
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,
610: WHEN OTHERS THEN
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,
2040: OPEN is_contact_point_exist(p_entity_id, p_cp_type);
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';
2050: OPEN is_party_site_exist(p_entity_id);
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';
2068: OPEN is_org_contact_exist(p_entity_id);
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';
2078: OPEN is_cust_account_exist(p_entity_id);
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';
2088: OPEN is_cust_acct_site_exist(p_entity_id);
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';
2098: OPEN is_cust_site_use_exist(p_entity_id);
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';
2109: FETCH is_cust_acct_role_exist INTO l_parent_id, l_acct_site_id;
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
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
2119: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2120: FND_MSG_PUB.ADD;
2121: RETURN 'E';
2122: END IF;
2123: END IF;
2145: OPEN is_contact_point_exist(l_owner_table_id, p_cp_type);
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;
2488: FOR i IN 1..l_bo_num LOOP
2489: CASE
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
2489: CASE
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
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;
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;
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
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
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;
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;
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
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
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;
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;
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
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
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;
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;
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
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
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;
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;
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
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
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;
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;
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
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
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;
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;
2664: l_email_code := NULL;
2665: l_web_code := NULL;
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;
2665: l_web_code := NULL;
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:
2728: END IF;
2729:
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;
2729:
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
2736: END IF;
2737: IF(l_psu AND
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;
2737: IF(l_psu AND
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
2744: END IF;
2745: IF(l_cpref AND
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;
2745: IF(l_cpref AND
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
2752: END IF;
2753: IF(l_ps_ext AND
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;
2753: IF(l_ps_ext AND
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
2760: END IF;
2761: IF(l_loc_ext AND
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;
2761: IF(l_loc_ext AND
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
2931:
2932: IF(l_pref AND
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;
2932: IF(l_pref AND
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
2939: END IF;
2940: IF(l_class AND
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;
2940: IF(l_class AND
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
2947: END IF;
2948: IF(l_lang AND
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;
2948: IF(l_lang AND
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
2955: END IF;
2956: IF(l_edu AND
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;
2956: IF(l_edu AND
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
2963: END IF;
2964: IF(l_citiz AND
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;
2964: IF(l_citiz AND
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
2971: END IF;
2972: IF(l_emp_hist AND
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
2972: IF(l_emp_hist AND
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
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
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;
2980: IF(l_work_class AND
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;
2990: IF(l_int AND
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;
2990: IF(l_int AND
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
2997: END IF;
2998: IF(l_cert AND
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;
2998: IF(l_cert AND
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
3005: END IF;
3006: IF(l_fin_prof AND
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;
3006: IF(l_fin_prof AND
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
3013: END IF;
3014: IF(l_rel AND
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;
3014: IF(l_rel AND
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
3021: END IF;
3022: IF(l_cpref AND
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;
3022: IF(l_cpref AND
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
3029: END IF;
3030: IF(l_ext AND
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;
3030: IF(l_ext AND
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
3109: l_cpref := FALSE;
3110: l_ps := FALSE;
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;
3110: l_ps := FALSE;
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:
3175: END IF;
3176:
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;
3176:
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:
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;
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
3192: END IF;
3193: IF(l_cpref AND
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;
3193: IF(l_cpref AND
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:
3375:
3376: IF(l_pref AND
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;
3376: IF(l_pref AND
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
3383: END IF;
3384: IF(l_credit AND
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;
3384: IF(l_credit AND
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
3391: END IF;
3392: IF(l_rel AND
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;
3392: IF(l_rel AND
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
3399: END IF;
3400: IF(l_class AND
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;
3400: IF(l_class AND
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
3407: END IF;
3408: IF(l_fin_report AND
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:
3408: IF(l_fin_report AND
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
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;
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;
3427: IF(l_cert AND
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;
3427: IF(l_cert AND
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
3434: END IF;
3435: IF(l_fin_prof AND
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;
3435: IF(l_fin_prof AND
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
3442: END IF;
3443: IF(l_cpref AND
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;
3443: IF(l_cpref AND
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
3450: END IF;
3451: IF(l_ext AND
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;
3451: IF(l_ext AND
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:
3528: BEGIN
3529: l_rr := FALSE;
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;
3529: l_rr := FALSE;
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:
3552: -- Check role responsibility objects
3553: IF(l_rr AND
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;
3553: IF(l_rr AND
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;
3601: l_bau := FALSE;
3602: l_pm := FALSE;
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;
3602: l_pm := FALSE;
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:
3662:
3663: IF(l_casu AND
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:
3663: IF(l_casu AND
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
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
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;
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
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
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
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;
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
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
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;
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
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
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;
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
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;
3746: l_bau := FALSE;
3747: l_pm := FALSE;
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;
3747: l_pm := FALSE;
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:
3829:
3830: IF(l_carel AND
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;
3830: IF(l_carel AND
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
3840: IF(l_bau AND
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;
3840: IF(l_bau AND
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
3846: RETURN FALSE;
3847: END IF;
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;
3847: END IF;
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:
3858: ELSE
3859: IF(l_cpa AND
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;
3859: IF(l_cpa AND
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;
4353: l_bau := FALSE;
4354: l_pm := FALSE;
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;
4354: l_pm := FALSE;
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:
4414:
4415: IF(l_casu AND
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:
4415: IF(l_casu AND
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
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
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;
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
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
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
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;
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
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
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;
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
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
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;
4447: IF(l_pm AND
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;
4499: l_bau := FALSE;
4500: l_pm := FALSE;
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;
4500: l_pm := FALSE;
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:
4582:
4583: IF(l_carel AND
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;
4583: IF(l_carel AND
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
4593: IF(l_bau AND
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;
4593: IF(l_bau AND
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
4600: END IF;
4601: IF(l_pm AND
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;
4601: IF(l_pm AND
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:
4612: ELSE
4613: IF(l_cpa AND
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;
4613: IF(l_cpa AND
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;