52:
53: BEGIN
54:
55: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
56: hz_utility_v2pub.debug(p_message=>'validate_account(+)',
57: p_prefix=>l_debug_prefix,
58: p_msg_level=>fnd_log.level_procedure);
59: END IF;
60:
192:
193: END IF;
194:
195: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
196: hz_utility_v2pub.debug(p_message=>'validate_account(-)',
197: p_prefix=>l_debug_prefix,
198: p_msg_level=>fnd_log.level_procedure);
199: END IF;
200:
207: p_data => x_msg_data);
208:
209: -- Debug info.
210: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
211: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
212: p_msg_data=>x_msg_data,
213: p_msg_type=>'ERROR',
214: p_msg_level=>fnd_log.level_error);
215: END IF;
213: p_msg_type=>'ERROR',
214: p_msg_level=>fnd_log.level_error);
215: END IF;
216: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
217: hz_utility_v2pub.debug(p_message=>'validate_account(-)',
218: p_prefix=>l_debug_prefix,
219: p_msg_level=>fnd_log.level_procedure);
220: END IF;
221: WHEN fnd_api.g_exc_unexpected_error THEN
226: p_data => x_msg_data);
227:
228: -- Debug info.
229: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
230: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
231: p_msg_data=>x_msg_data,
232: p_msg_type=>'UNEXPECTED ERROR',
233: p_msg_level=>fnd_log.level_error);
234: END IF;
232: p_msg_type=>'UNEXPECTED ERROR',
233: p_msg_level=>fnd_log.level_error);
234: END IF;
235: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
236: hz_utility_v2pub.debug(p_message=>'validate_account(-)',
237: p_prefix=>l_debug_prefix,
238: p_msg_level=>fnd_log.level_procedure);
239: END IF;
240: WHEN OTHERS THEN
249: p_data => x_msg_data);
250:
251: -- Debug info.
252: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
253: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
254: p_msg_data=>x_msg_data,
255: p_msg_type=>'SQL ERROR',
256: p_msg_level=>fnd_log.level_error);
257: END IF;
255: p_msg_type=>'SQL ERROR',
256: p_msg_level=>fnd_log.level_error);
257: END IF;
258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
259: hz_utility_v2pub.debug(p_message=>'validate_account(-)',
260: p_prefix=>l_debug_prefix,
261: p_msg_level=>fnd_log.level_procedure);
262: END IF;
263: END validate_account;
293:
294: BEGIN
295:
296: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
297: hz_utility_v2pub.debug(p_message=>'validate_account_site(+)',
298: p_prefix=>l_debug_prefix,
299: p_msg_level=>fnd_log.level_procedure);
300: END IF;
301:
441:
442: p_site_osr := l_osr;
443:
444: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
445: hz_utility_v2pub.debug(p_message=>'validate_account_site(-)',
446: p_prefix=>l_debug_prefix,
447: p_msg_level=>fnd_log.level_procedure);
448: END IF;
449:
456: p_data => x_msg_data);
457:
458: -- Debug info.
459: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
460: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
461: p_msg_data=>x_msg_data,
462: p_msg_type=>'ERROR',
463: p_msg_level=>fnd_log.level_error);
464: END IF;
462: p_msg_type=>'ERROR',
463: p_msg_level=>fnd_log.level_error);
464: END IF;
465: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
466: hz_utility_v2pub.debug(p_message=>'validate_account_site(-)',
467: p_prefix=>l_debug_prefix,
468: p_msg_level=>fnd_log.level_procedure);
469: END IF;
470: WHEN fnd_api.g_exc_unexpected_error THEN
475: p_data => x_msg_data);
476:
477: -- Debug info.
478: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
479: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
480: p_msg_data=>x_msg_data,
481: p_msg_type=>'UNEXPECTED ERROR',
482: p_msg_level=>fnd_log.level_error);
483: END IF;
481: p_msg_type=>'UNEXPECTED ERROR',
482: p_msg_level=>fnd_log.level_error);
483: END IF;
484: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
485: hz_utility_v2pub.debug(p_message=>'validate_account_site(-)',
486: p_prefix=>l_debug_prefix,
487: p_msg_level=>fnd_log.level_procedure);
488: END IF;
489: WHEN OTHERS THEN
498: p_data => x_msg_data);
499:
500: -- Debug info.
501: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
502: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
503: p_msg_data=>x_msg_data,
504: p_msg_type=>'SQL ERROR',
505: p_msg_level=>fnd_log.level_error);
506: END IF;
504: p_msg_type=>'SQL ERROR',
505: p_msg_level=>fnd_log.level_error);
506: END IF;
507: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
508: hz_utility_v2pub.debug(p_message=>'validate_account_site(-)',
509: p_prefix=>l_debug_prefix,
510: p_msg_level=>fnd_log.level_procedure);
511: END IF;
512:
540:
541: BEGIN
542:
543: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
544: hz_utility_v2pub.debug(p_message=>'validate_account_site_use(+)',
545: p_prefix=>l_debug_prefix,
546: p_msg_level=>fnd_log.level_procedure);
547: END IF;
548:
669: g_site_use_location(p_site_use_id) := l_location;
670: g_primary_flag(p_site_use_id) := l_primary_flag;
671:
672: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
673: hz_utility_v2pub.debug(p_message=>'validate_account_site_use(-)',
674: p_prefix=>l_debug_prefix,
675: p_msg_level=>fnd_log.level_procedure);
676: END IF;
677:
684: p_data => x_msg_data);
685:
686: -- Debug info.
687: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
688: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
689: p_msg_data=>x_msg_data,
690: p_msg_type=>'ERROR',
691: p_msg_level=>fnd_log.level_error);
692: END IF;
690: p_msg_type=>'ERROR',
691: p_msg_level=>fnd_log.level_error);
692: END IF;
693: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
694: hz_utility_v2pub.debug(p_message=>'validate_account_site_use(-)',
695: p_prefix=>l_debug_prefix,
696: p_msg_level=>fnd_log.level_procedure);
697: END IF;
698: WHEN fnd_api.g_exc_unexpected_error THEN
703: p_data => x_msg_data);
704:
705: -- Debug info.
706: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
707: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
708: p_msg_data=>x_msg_data,
709: p_msg_type=>'UNEXPECTED ERROR',
710: p_msg_level=>fnd_log.level_error);
711: END IF;
709: p_msg_type=>'UNEXPECTED ERROR',
710: p_msg_level=>fnd_log.level_error);
711: END IF;
712: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
713: hz_utility_v2pub.debug(p_message=>'validate_account_site_use(-)',
714: p_prefix=>l_debug_prefix,
715: p_msg_level=>fnd_log.level_procedure);
716: END IF;
717: WHEN OTHERS THEN
726: p_data => x_msg_data);
727:
728: -- Debug info.
729: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
730: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
731: p_msg_data=>x_msg_data,
732: p_msg_type=>'SQL ERROR',
733: p_msg_level=>fnd_log.level_error);
734: END IF;
732: p_msg_type=>'SQL ERROR',
733: p_msg_level=>fnd_log.level_error);
734: END IF;
735: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
736: hz_utility_v2pub.debug(p_message=>'validate_account_site_use(-)',
737: p_prefix=>l_debug_prefix,
738: p_msg_level=>fnd_log.level_procedure);
739: END IF;
740:
826:
827: BEGIN
828:
829: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
830: hz_utility_v2pub.debug(p_message=>'create_account_merge_request(+)',
831: p_prefix=>l_debug_prefix,
832: p_msg_level=>fnd_log.level_procedure);
833: END IF;
834:
1339: , PRIORITY
1340: , ORG_ID)
1341: VALUES(l_header_id
1342: , sysdate
1343: , HZ_UTILITY_V2PUB.CREATED_BY
1344: , sysdate
1345: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1346: , HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
1347: , l_account_merge_request_obj.merge_to_account.account_id
1341: VALUES(l_header_id
1342: , sysdate
1343: , HZ_UTILITY_V2PUB.CREATED_BY
1344: , sysdate
1345: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1346: , HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
1347: , l_account_merge_request_obj.merge_to_account.account_id
1348: , l_to_customer_name
1349: , l_account_merge_request_obj.merge_to_account.account_number
1342: , sysdate
1343: , HZ_UTILITY_V2PUB.CREATED_BY
1344: , sysdate
1345: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1346: , HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
1347: , l_account_merge_request_obj.merge_to_account.account_id
1348: , l_to_customer_name
1349: , l_account_merge_request_obj.merge_to_account.account_number
1350: , l_to_party_osr
1468: , CUSTOMER_SITE_NUMBER
1469: , ORG_ID)
1470: VALUES( ra_customer_merges_s.nextval /*CUSTOMER_MERGE_ID*/
1471: , sysdate /*CREATION_DATE*/
1472: , HZ_UTILITY_V2PUB.CREATED_BY /*CREATED_BY*/
1473: , sysdate /*LAST_UPDATE_DATE*/
1474: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY /*LAST_UPDATED_BY*/
1475: , HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN /*LAST_UPDATE_LOGIN*/
1476: , 'SAVED' /*PROCESS_FLAG*/
1470: VALUES( ra_customer_merges_s.nextval /*CUSTOMER_MERGE_ID*/
1471: , sysdate /*CREATION_DATE*/
1472: , HZ_UTILITY_V2PUB.CREATED_BY /*CREATED_BY*/
1473: , sysdate /*LAST_UPDATE_DATE*/
1474: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY /*LAST_UPDATED_BY*/
1475: , HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN /*LAST_UPDATE_LOGIN*/
1476: , 'SAVED' /*PROCESS_FLAG*/
1477: , l_account_merge_request_obj.merge_to_account.account_id /*CUSTOMER_ID*/
1478: , l_to_customer_name /*CUSTOMER_NAME*/
1471: , sysdate /*CREATION_DATE*/
1472: , HZ_UTILITY_V2PUB.CREATED_BY /*CREATED_BY*/
1473: , sysdate /*LAST_UPDATE_DATE*/
1474: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY /*LAST_UPDATED_BY*/
1475: , HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN /*LAST_UPDATE_LOGIN*/
1476: , 'SAVED' /*PROCESS_FLAG*/
1477: , l_account_merge_request_obj.merge_to_account.account_id /*CUSTOMER_ID*/
1478: , l_to_customer_name /*CUSTOMER_NAME*/
1479: , l_account_merge_request_obj.merge_to_account.account_number /*CUSTOMER_NUMBER*/
1560: , CUSTOMER_SITE_NUMBER
1561: , ORG_ID)
1562: VALUES( ra_customer_merges_s.nextval /*CUSTOMER_MERGE_ID*/
1563: , sysdate /*CREATION_DATE*/
1564: , HZ_UTILITY_V2PUB.CREATED_BY /*CREATED_BY*/
1565: , sysdate /*LAST_UPDATE_DATE*/
1566: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY /*LAST_UPDATED_BY*/
1567: , HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN /*LAST_UPDATE_LOGIN*/
1568: , 'SAVED' /*PROCESS_FLAG*/
1562: VALUES( ra_customer_merges_s.nextval /*CUSTOMER_MERGE_ID*/
1563: , sysdate /*CREATION_DATE*/
1564: , HZ_UTILITY_V2PUB.CREATED_BY /*CREATED_BY*/
1565: , sysdate /*LAST_UPDATE_DATE*/
1566: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY /*LAST_UPDATED_BY*/
1567: , HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN /*LAST_UPDATE_LOGIN*/
1568: , 'SAVED' /*PROCESS_FLAG*/
1569: , l_account_merge_request_obj.merge_to_account.account_id /*CUSTOMER_ID*/
1570: , l_to_customer_name /*CUSTOMER_NAME*/
1563: , sysdate /*CREATION_DATE*/
1564: , HZ_UTILITY_V2PUB.CREATED_BY /*CREATED_BY*/
1565: , sysdate /*LAST_UPDATE_DATE*/
1566: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY /*LAST_UPDATED_BY*/
1567: , HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN /*LAST_UPDATE_LOGIN*/
1568: , 'SAVED' /*PROCESS_FLAG*/
1569: , l_account_merge_request_obj.merge_to_account.account_id /*CUSTOMER_ID*/
1570: , l_to_customer_name /*CUSTOMER_NAME*/
1571: , l_account_merge_request_obj.merge_to_account.account_number /*CUSTOMER_NUMBER*/
1657: , CUSTOMER_CREATESAME
1658: , ORG_ID)
1659: VALUES( ra_customer_merges_s.nextval /*CUSTOMER_MERGE_ID*/
1660: , sysdate /*CREATION_DATE*/
1661: , HZ_UTILITY_V2PUB.CREATED_BY /*CREATED_BY*/
1662: , sysdate /*LAST_UPDATE_DATE*/
1663: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY /*LAST_UPDATED_BY*/
1664: , HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN /*LAST_UPDATE_LOGIN*/
1665: , 'SAVED' /*PROCESS_FLAG*/
1659: VALUES( ra_customer_merges_s.nextval /*CUSTOMER_MERGE_ID*/
1660: , sysdate /*CREATION_DATE*/
1661: , HZ_UTILITY_V2PUB.CREATED_BY /*CREATED_BY*/
1662: , sysdate /*LAST_UPDATE_DATE*/
1663: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY /*LAST_UPDATED_BY*/
1664: , HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN /*LAST_UPDATE_LOGIN*/
1665: , 'SAVED' /*PROCESS_FLAG*/
1666: , l_account_merge_request_obj.merge_to_account.account_id /*CUSTOMER_ID*/
1667: , l_to_customer_name /*CUSTOMER_NAME*/
1660: , sysdate /*CREATION_DATE*/
1661: , HZ_UTILITY_V2PUB.CREATED_BY /*CREATED_BY*/
1662: , sysdate /*LAST_UPDATE_DATE*/
1663: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY /*LAST_UPDATED_BY*/
1664: , HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN /*LAST_UPDATE_LOGIN*/
1665: , 'SAVED' /*PROCESS_FLAG*/
1666: , l_account_merge_request_obj.merge_to_account.account_id /*CUSTOMER_ID*/
1667: , l_to_customer_name /*CUSTOMER_NAME*/
1668: , l_account_merge_request_obj.merge_to_account.account_number /*CUSTOMER_NUMBER*/
1729: , CUSTOMER_SITE_NUMBER
1730: , ORG_ID)
1731: select ra_customer_merges_s.nextval /*CUSTOMER_MERGE_ID*/
1732: , sysdate /*CREATION_DATE*/
1733: , HZ_UTILITY_V2PUB.CREATED_BY /*CREATED_BY*/
1734: , sysdate /*LAST_UPDATE_DATE*/
1735: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY /*LAST_UPDATED_BY*/
1736: , HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN /*LAST_UPDATE_LOGIN*/
1737: , 'SAVED' /*PROCESS_FLAG*/
1731: select ra_customer_merges_s.nextval /*CUSTOMER_MERGE_ID*/
1732: , sysdate /*CREATION_DATE*/
1733: , HZ_UTILITY_V2PUB.CREATED_BY /*CREATED_BY*/
1734: , sysdate /*LAST_UPDATE_DATE*/
1735: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY /*LAST_UPDATED_BY*/
1736: , HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN /*LAST_UPDATE_LOGIN*/
1737: , 'SAVED' /*PROCESS_FLAG*/
1738: , l_account_merge_request_obj.merge_to_account.account_id /*CUSTOMER_ID*/
1739: , l_to_customer_name /*CUSTOMER_NAME*/
1732: , sysdate /*CREATION_DATE*/
1733: , HZ_UTILITY_V2PUB.CREATED_BY /*CREATED_BY*/
1734: , sysdate /*LAST_UPDATE_DATE*/
1735: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY /*LAST_UPDATED_BY*/
1736: , HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN /*LAST_UPDATE_LOGIN*/
1737: , 'SAVED' /*PROCESS_FLAG*/
1738: , l_account_merge_request_obj.merge_to_account.account_id /*CUSTOMER_ID*/
1739: , l_to_customer_name /*CUSTOMER_NAME*/
1740: , l_account_merge_request_obj.merge_to_account.account_number /*CUSTOMER_NUMBER*/
1879:
1880: END IF; --p_submit_request
1881:
1882: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1883: hz_utility_v2pub.debug(p_message=>'create_account_merge_request(-)',
1884: p_prefix=>l_debug_prefix,
1885: p_msg_level=>fnd_log.level_procedure);
1886: END IF;
1887:
1895: p_data => x_msg_data);
1896:
1897: -- Debug info.
1898: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1899: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1900: p_msg_data=>x_msg_data,
1901: p_msg_type=>'ERROR',
1902: p_msg_level=>fnd_log.level_error);
1903: END IF;
1901: p_msg_type=>'ERROR',
1902: p_msg_level=>fnd_log.level_error);
1903: END IF;
1904: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1905: hz_utility_v2pub.debug(p_message=>'create_account_merge_request(-)',
1906: p_prefix=>l_debug_prefix,
1907: p_msg_level=>fnd_log.level_procedure);
1908: END IF;
1909: WHEN fnd_api.g_exc_unexpected_error THEN
1914: p_data => x_msg_data);
1915:
1916: -- Debug info.
1917: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1918: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1919: p_msg_data=>x_msg_data,
1920: p_msg_type=>'UNEXPECTED ERROR',
1921: p_msg_level=>fnd_log.level_error);
1922: END IF;
1920: p_msg_type=>'UNEXPECTED ERROR',
1921: p_msg_level=>fnd_log.level_error);
1922: END IF;
1923: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1924: hz_utility_v2pub.debug(p_message=>'create_account_merge_request(-)',
1925: p_prefix=>l_debug_prefix,
1926: p_msg_level=>fnd_log.level_procedure);
1927: END IF;
1928: WHEN OTHERS THEN
1937: p_data => x_msg_data);
1938:
1939: -- Debug info.
1940: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1941: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1942: p_msg_data=>x_msg_data,
1943: p_msg_type=>'SQL ERROR',
1944: p_msg_level=>fnd_log.level_error);
1945: END IF;
1943: p_msg_type=>'SQL ERROR',
1944: p_msg_level=>fnd_log.level_error);
1945: END IF;
1946: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1947: hz_utility_v2pub.debug(p_message=>'create_account_merge_request(-)',
1948: p_prefix=>l_debug_prefix,
1949: p_msg_level=>fnd_log.level_procedure);
1950: END IF;
1951: