DBA Data[Home] [Help]

APPS.HZ_ACCOUNT_MERGE_PUB dependencies on HZ_UTILITY_V2PUB

Line 56: hz_utility_v2pub.debug(p_message=>'validate_account(+)',

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:

Line 196: hz_utility_v2pub.debug(p_message=>'validate_account(-)',

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:

Line 211: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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;

Line 217: hz_utility_v2pub.debug(p_message=>'validate_account(-)',

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

Line 230: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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;

Line 236: hz_utility_v2pub.debug(p_message=>'validate_account(-)',

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

Line 253: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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;

Line 259: hz_utility_v2pub.debug(p_message=>'validate_account(-)',

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;

Line 297: hz_utility_v2pub.debug(p_message=>'validate_account_site(+)',

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:

Line 445: hz_utility_v2pub.debug(p_message=>'validate_account_site(-)',

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:

Line 460: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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;

Line 466: hz_utility_v2pub.debug(p_message=>'validate_account_site(-)',

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

Line 479: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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;

Line 485: hz_utility_v2pub.debug(p_message=>'validate_account_site(-)',

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

Line 502: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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;

Line 508: hz_utility_v2pub.debug(p_message=>'validate_account_site(-)',

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:

Line 544: hz_utility_v2pub.debug(p_message=>'validate_account_site_use(+)',

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:

Line 673: hz_utility_v2pub.debug(p_message=>'validate_account_site_use(-)',

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:

Line 688: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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;

Line 694: hz_utility_v2pub.debug(p_message=>'validate_account_site_use(-)',

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

Line 707: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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;

Line 713: hz_utility_v2pub.debug(p_message=>'validate_account_site_use(-)',

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

Line 730: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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;

Line 736: hz_utility_v2pub.debug(p_message=>'validate_account_site_use(-)',

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:

Line 830: hz_utility_v2pub.debug(p_message=>'create_account_merge_request(+)',

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:

Line 1343: , HZ_UTILITY_V2PUB.CREATED_BY

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

Line 1345: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY

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

Line 1346: , HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN

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

Line 1472: , HZ_UTILITY_V2PUB.CREATED_BY /*CREATED_BY*/

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*/

Line 1474: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY /*LAST_UPDATED_BY*/

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*/

Line 1475: , HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN /*LAST_UPDATE_LOGIN*/

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*/

Line 1564: , HZ_UTILITY_V2PUB.CREATED_BY /*CREATED_BY*/

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*/

Line 1566: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY /*LAST_UPDATED_BY*/

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*/

Line 1567: , HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN /*LAST_UPDATE_LOGIN*/

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*/

Line 1661: , HZ_UTILITY_V2PUB.CREATED_BY /*CREATED_BY*/

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*/

Line 1663: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY /*LAST_UPDATED_BY*/

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*/

Line 1664: , HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN /*LAST_UPDATE_LOGIN*/

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*/

Line 1733: , HZ_UTILITY_V2PUB.CREATED_BY /*CREATED_BY*/

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*/

Line 1735: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY /*LAST_UPDATED_BY*/

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*/

Line 1736: , HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN /*LAST_UPDATE_LOGIN*/

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*/

Line 1883: hz_utility_v2pub.debug(p_message=>'create_account_merge_request(-)',

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:

Line 1899: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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;

Line 1905: hz_utility_v2pub.debug(p_message=>'create_account_merge_request(-)',

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

Line 1918: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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;

Line 1924: hz_utility_v2pub.debug(p_message=>'create_account_merge_request(-)',

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

Line 1941: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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;

Line 1947: hz_utility_v2pub.debug(p_message=>'create_account_merge_request(-)',

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: