eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PARTY_USG_ASSIGNMENT_PVT dependencies on HZ_UTILITY_V2PUB

Line 111: hz_utility_v2pub.debug (

107: l_debug_prefix := '';
108:
109: -- Debug info.
110: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
111: hz_utility_v2pub.debug (
112: p_message => c_api_name||' (+)',
113: p_prefix => l_debug_prefix,
114: p_msg_level => fnd_log.level_procedure);
115: END IF;

Line 118: IF hz_utility_v2pub.G_EXECUTE_API_CALLOUTS IN ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')

114: p_msg_level => fnd_log.level_procedure);
115: END IF;
116:
117: -- populate function for integration service
118: IF hz_utility_v2pub.G_EXECUTE_API_CALLOUTS IN ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')
119: THEN
120: hz_populate_bot_pkg.pop_hz_party_usg_assignments(
121: p_operation => p_create_update_flag,
122: P_party_usg_assignment_id => p_party_usg_assignment_id);

Line 127: hz_utility_v2pub.debug (

123: END IF;
124:
125: -- Debug info.
126: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
127: hz_utility_v2pub.debug (
128: p_message => c_api_name||' (-)',
129: p_prefix => l_debug_prefix,
130: p_msg_level => fnd_log.level_procedure);
131: END IF;

Line 340: hz_utility_v2pub.debug (

336: l_debug_prefix := '';
337:
338: -- Debug info.
339: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
340: hz_utility_v2pub.debug (
341: p_message => c_api_name||' (+)',
342: p_prefix => l_debug_prefix,
343: p_msg_level => fnd_log.level_procedure);
344: END IF;

Line 348: hz_utility_v2pub.debug(

344: END IF;
345:
346: -- Debug info.
347: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
348: hz_utility_v2pub.debug(
349: p_prefix => l_debug_prefix,
350: p_message => 'x_return_status = '||x_return_status,
351: p_msg_level => fnd_log.level_statement);
352: END IF;

Line 367: hz_utility_v2pub.validate_mandatory (

363: IF p_create_update_flag = 'C' THEN
364: --
365: -- mandatory: party_id
366: --
367: hz_utility_v2pub.validate_mandatory (
368: p_create_update_flag => p_create_update_flag,
369: p_column => 'party_id',
370: p_column_value => p_party_usg_assignment_rec.party_id,
371: x_return_status => x_return_status

Line 376: hz_utility_v2pub.debug(

372: );
373:
374: -- Debug info.
375: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
376: hz_utility_v2pub.debug(
377: p_prefix => l_debug_prefix,
378: p_message => 'party_id is a mandatory column. '||
379: 'x_return_status = '||x_return_status,
380: p_msg_level => fnd_log.level_statement);

Line 386: hz_utility_v2pub.validate_mandatory (

382:
383: --
384: -- mandatory: party_usage_code
385: --
386: hz_utility_v2pub.validate_mandatory (
387: p_create_update_flag => p_create_update_flag,
388: p_column => 'party_usage_code',
389: p_column_value => p_party_usg_assignment_rec.party_usage_code,
390: x_return_status => x_return_status

Line 395: hz_utility_v2pub.debug(

391: );
392:
393: -- Debug info.
394: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
395: hz_utility_v2pub.debug(
396: p_prefix => l_debug_prefix,
397: p_message => 'party_usage_code is a mandatory column. '||
398: 'x_return_status = '||x_return_status,
399: p_msg_level => fnd_log.level_statement);

Line 408: hz_utility_v2pub.validate_mandatory (

404: --
405: IF p_party_usg_assignment_rec.owner_table_name IS NOT NULL AND
406: p_party_usg_assignment_rec.owner_table_name <> fnd_api.G_MISS_CHAR
407: THEN
408: hz_utility_v2pub.validate_mandatory (
409: p_create_update_flag => p_create_update_flag,
410: p_column => 'owner_table_id',
411: p_column_value => p_party_usg_assignment_rec.owner_table_id,
412: x_return_status => x_return_status

Line 419: hz_utility_v2pub.validate_mandatory (

415:
416: IF p_party_usg_assignment_rec.owner_table_id IS NOT NULL AND
417: p_party_usg_assignment_rec.owner_table_id <> fnd_api.G_MISS_NUM
418: THEN
419: hz_utility_v2pub.validate_mandatory (
420: p_create_update_flag => p_create_update_flag,
421: p_column => 'owner_table_name',
422: p_column_value => p_party_usg_assignment_rec.owner_table_name,
423: x_return_status => x_return_status

Line 429: hz_utility_v2pub.debug(

425: END IF;
426:
427: -- Debug info.
428: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
429: hz_utility_v2pub.debug(
430: p_prefix => l_debug_prefix,
431: p_message => 'conditional mandatory: owner_table_name, owner_table_id. '||
432: 'x_return_status = '||x_return_status,
433: p_msg_level => fnd_log.level_statement);

Line 454: hz_utility_v2pub.debug(

450: END IF;
451:
452: -- Debug info.
453: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
454: hz_utility_v2pub.debug(
455: p_prefix => l_debug_prefix,
456: p_message => 'foreign key check when owner_table_name = HZ_RELATIONSHIPS. '||
457: 'x_return_status = '||x_return_status,
458: p_msg_level => fnd_log.level_statement);

Line 467: hz_utility_v2pub.validate_nonupdateable (

463: ELSE -- p_create_update_flag = 'U'
464: --
465: -- non-updateable: party_id
466: --
467: hz_utility_v2pub.validate_nonupdateable (
468: p_column => 'party_id',
469: p_column_value => p_party_usg_assignment_rec.party_id,
470: p_old_column_value => p_old_usg_assignment_rec.party_id,
471: x_return_status => x_return_status

Line 476: hz_utility_v2pub.debug(

472: );
473:
474: -- Debug info.
475: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
476: hz_utility_v2pub.debug(
477: p_prefix => l_debug_prefix,
478: p_message => 'party_id is a non-updateable column. '||
479: 'x_return_status = '||x_return_status,
480: p_msg_level => fnd_log.level_statement);

Line 486: hz_utility_v2pub.validate_nonupdateable (

482:
483: --
484: -- non-updateable: party_usage_code
485: --
486: hz_utility_v2pub.validate_nonupdateable (
487: p_column => 'party_usage_code',
488: p_column_value => p_party_usg_assignment_rec.party_usage_code,
489: p_old_column_value => p_old_usg_assignment_rec.party_usage_code,
490: x_return_status => x_return_status

Line 495: hz_utility_v2pub.debug(

491: );
492:
493: -- Debug info.
494: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
495: hz_utility_v2pub.debug(
496: p_prefix => l_debug_prefix,
497: p_message => 'party_usage_code is a non-updateable column. '||
498: 'x_return_status = '||x_return_status,
499: p_msg_level => fnd_log.level_statement);

Line 505: hz_utility_v2pub.validate_nonupdateable (

501:
502: --
503: -- non-updateable: owner_table_name
504: --
505: hz_utility_v2pub.validate_nonupdateable (
506: p_column => 'owner_table_name',
507: p_column_value => p_party_usg_assignment_rec.owner_table_name,
508: p_old_column_value => p_old_usg_assignment_rec.owner_table_name,
509: x_return_status => x_return_status

Line 514: hz_utility_v2pub.debug(

510: );
511:
512: -- Debug info.
513: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
514: hz_utility_v2pub.debug(
515: p_prefix => l_debug_prefix,
516: p_message => 'owner_table_name is a non-updateable column. '||
517: 'x_return_status = '||x_return_status,
518: p_msg_level => fnd_log.level_statement);

Line 524: hz_utility_v2pub.validate_nonupdateable (

520:
521: --
522: -- non-updateable: owner_table_id
523: --
524: hz_utility_v2pub.validate_nonupdateable (
525: p_column => 'owner_table_id',
526: p_column_value => p_party_usg_assignment_rec.owner_table_id,
527: p_old_column_value => p_old_usg_assignment_rec.owner_table_id,
528: x_return_status => x_return_status

Line 533: hz_utility_v2pub.debug(

529: );
530:
531: -- Debug info.
532: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
533: hz_utility_v2pub.debug(
534: p_prefix => l_debug_prefix,
535: p_message => 'owner_table_id is a non-updateable column. '||
536: 'x_return_status = '||x_return_status,
537: p_msg_level => fnd_log.level_statement);

Line 558: hz_utility_v2pub.debug(

554: END IF;
555:
556: -- Debug info.
557: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
558: hz_utility_v2pub.debug(
559: p_prefix => l_debug_prefix,
560: p_message => 'end date can not be earlier than start date. '||
561: 'x_return_status = '||x_return_status,
562: p_msg_level => fnd_log.level_statement);

Line 568: hz_utility_v2pub.validate_created_by_module (

564:
565: --
566: -- mandatory, non-updateable, lookup : created_by_module
567: --
568: hz_utility_v2pub.validate_created_by_module (
569: p_create_update_flag => p_create_update_flag,
570: p_created_by_module => p_party_usg_assignment_rec.created_by_module,
571: p_old_created_by_module => p_old_usg_assignment_rec.created_by_module,
572: x_return_status => x_return_status

Line 608: hz_utility_v2pub.debug(

604: db_party_usage_created_by := l_value_tbl(5);
605:
606: -- Debug info.
607: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
608: hz_utility_v2pub.debug(
609: p_prefix => l_debug_prefix,
610: p_message => 'foreign key validation for party_usage_code. '||
611: 'db_party_usage_status = '||db_party_usage_status||' '||
612: 'db_party_usage_type = '||db_party_usage_type||' '||

Line 629: hz_utility_v2pub.debug(

625: END IF;
626:
627: -- Debug info.
628: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
629: hz_utility_v2pub.debug(
630: p_prefix => l_debug_prefix,
631: p_message => 'foreign key validation for party_usage_code. '||
632: 'x_return_status = '||x_return_status,
633: p_msg_level => fnd_log.level_statement);

Line 649: hz_utility_v2pub.debug(

645: END IF;
646:
647: -- Debug info.
648: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
649: hz_utility_v2pub.debug(
650: p_prefix => l_debug_prefix,
651: p_message => 'inactive party_usage_code. '||
652: 'x_return_status = '||x_return_status,
653: p_msg_level => fnd_log.level_statement);

Line 673: hz_utility_v2pub.debug(

669: CLOSE c_party;
670:
671: -- Debug info.
672: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
673: hz_utility_v2pub.debug(
674: p_prefix => l_debug_prefix,
675: p_message => 'foreign key validation for party_id. '||
676: 'x_return_status = '||x_return_status||' '||
677: 'party_type = '||db_party_type,

Line 694: hz_utility_v2pub.debug(

690: END IF;
691:
692: -- Debug info.
693: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
694: hz_utility_v2pub.debug(
695: p_prefix => l_debug_prefix,
696: p_message => 'party type doesn''t match. '||
697: 'x_return_status = '||x_return_status,
698: p_msg_level => fnd_log.level_statement);

Line 730: hz_utility_v2pub.debug(

726: END IF;
727:
728: -- Debug info.
729: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
730: hz_utility_v2pub.debug(
731: p_prefix => l_debug_prefix,
732: p_message => 'created_by_module is created by . '||
733: 'l_created_by = '||l_created_by||' '||
734: 'x_return_status = '||x_return_status,

Line 768: hz_utility_v2pub.debug(

764: END IF;
765:
766: -- Debug info.
767: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
768: hz_utility_v2pub.debug(
769: p_prefix => l_debug_prefix,
770: p_message => 'manual update is Y. calling from public API. '||
771: 'x_return_status = '||x_return_status,
772: p_msg_level => fnd_log.level_statement);

Line 804: hz_utility_v2pub.debug(

800: l_continue = 'Y')
801: LOOP
802: -- Debug info.
803: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
804: hz_utility_v2pub.debug(
805: p_prefix => l_debug_prefix,
806: p_message => 'l_party_usage_codes_tbl('||i||') = '||
807: l_party_usage_codes_tbl(i),
808: p_msg_level => fnd_log.level_statement);

Line 838: hz_utility_v2pub.debug(

834: END IF;
835:
836: -- Debug info.
837: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
838: hz_utility_v2pub.debug(
839: p_prefix => l_debug_prefix,
840: p_message => 'check exclusive and co-exist rule. '||
841: 'x_return_status = '||x_return_status,
842: p_msg_level => fnd_log.level_statement);

Line 855: hz_utility_v2pub.debug (

851: END IF; -- LOW VALIDATION
852:
853: -- Debug info.
854: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
855: hz_utility_v2pub.debug (
856: p_message => c_api_name||' (-)',
857: p_prefix => l_debug_prefix,
858: p_msg_level => fnd_log.level_procedure);
859: END IF;

Line 927: hz_utility_v2pub.debug (

923: l_debug_prefix := '';
924:
925: -- Debug info.
926: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
927: hz_utility_v2pub.debug (
928: p_message => c_api_name||' (+)',
929: p_prefix => l_debug_prefix,
930: p_msg_level => fnd_log.level_procedure);
931: END IF;

Line 946: hz_utility_v2pub.debug(

942: p_party_usg_assignment_rec.owner_table_id <> fnd_api.G_MISS_NUM
943: THEN
944: -- Debug info.
945: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
946: hz_utility_v2pub.debug(
947: p_prefix => l_debug_prefix,
948: p_message => 'owner_table_name, owner_table_id are passed in for this usage. '||
949: 'Check duplicate assignment.',
950: p_msg_level => fnd_log.level_statement);

Line 976: hz_utility_v2pub.debug(

972: p_party_usg_assignment_rec.party_usage_code <> fnd_api.G_MISS_CHAR
973: THEN
974: -- Debug info.
975: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
976: hz_utility_v2pub.debug(
977: p_prefix => l_debug_prefix,
978: p_message => 'No date tracking for this usage '||
979: p_party_usg_assignment_rec.party_usage_code||'. '||
980: 'Check duplicate assignment.',

Line 1001: hz_utility_v2pub.debug(

997: END IF;
998:
999: -- Debug info.
1000: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1001: hz_utility_v2pub.debug(
1002: p_prefix => l_debug_prefix,
1003: p_message => 'l_has_duplicates = '||l_has_duplicates,
1004: p_msg_level => fnd_log.level_statement);
1005: END IF;

Line 1009: hz_utility_v2pub.debug (

1005: END IF;
1006:
1007: -- Debug info.
1008: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1009: hz_utility_v2pub.debug (
1010: p_message => c_api_name||' (-)',
1011: p_prefix => l_debug_prefix,
1012: p_msg_level => fnd_log.level_procedure);
1013: END IF;

Line 1073: hz_utility_v2pub.debug (

1069: l_debug_prefix := '';
1070:
1071: -- Debug info.
1072: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1073: hz_utility_v2pub.debug (
1074: p_message => c_api_name||' (+)',
1075: p_prefix => l_debug_prefix,
1076: p_msg_level => fnd_log.level_procedure);
1077: END IF;

Line 1105: hz_utility_v2pub.debug(

1101: END IF;
1102:
1103: -- Debug info.
1104: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1105: hz_utility_v2pub.debug(
1106: p_prefix => l_debug_prefix,
1107: p_message => 'effective_start_date = '||
1108: TO_CHAR(p_party_usg_assignment_rec.effective_start_date, 'YYYY/MM/DD')||' '||
1109: 'effective_end_date = '||

Line 1211: hz_utility_v2pub.debug (

1207: END IF;
1208:
1209: -- Debug info.
1210: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1211: hz_utility_v2pub.debug (
1212: p_message => c_api_name||' (-)',
1213: p_prefix => l_debug_prefix,
1214: p_msg_level => fnd_log.level_procedure);
1215: END IF;

Line 1273: hz_utility_v2pub.debug (

1269: l_debug_prefix := '';
1270:
1271: -- Debug info.
1272: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1273: hz_utility_v2pub.debug (
1274: p_message => c_api_name||' (+)',
1275: p_prefix => l_debug_prefix,
1276: p_msg_level => fnd_log.level_procedure);
1277: END IF;

Line 1313: hz_utility_v2pub.debug(

1309: END IF;
1310:
1311: -- Debug info.
1312: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1313: hz_utility_v2pub.debug(
1314: p_prefix => l_debug_prefix,
1315: p_message => 'effective_start_date = '||
1316: TO_CHAR(p_party_usg_assignment_rec.effective_start_date, 'YYYY/MM/DD')||' '||
1317: 'effective_end_date = '||

Line 1416: hz_utility_v2pub.debug (

1412: END LOOP;
1413:
1414: -- Debug info.
1415: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1416: hz_utility_v2pub.debug (
1417: p_message => c_api_name||' (-)',
1418: p_prefix => l_debug_prefix,
1419: p_msg_level => fnd_log.level_procedure);
1420: END IF;

Line 1503: hz_utility_v2pub.debug (

1499: l_debug_prefix := '';
1500:
1501: -- Debug info.
1502: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1503: hz_utility_v2pub.debug (
1504: p_message => c_api_name||' (+)',
1505: p_prefix => l_debug_prefix,
1506: p_msg_level => fnd_log.level_procedure);
1507: END IF;

Line 1573: hz_utility_v2pub.debug(

1569: END IF;
1570:
1571: -- Debug info.
1572: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1573: hz_utility_v2pub.debug(
1574: p_prefix => l_debug_prefix,
1575: p_message => 'G_SETUP_LOADED = '||G_SETUP_LOADED,
1576: p_msg_level => fnd_log.level_statement);
1577: END IF;

Line 1581: hz_utility_v2pub.debug (

1577: END IF;
1578:
1579: -- Debug info.
1580: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1581: hz_utility_v2pub.debug (
1582: p_message => c_api_name||' (-)',
1583: p_prefix => l_debug_prefix,
1584: p_msg_level => fnd_log.level_procedure);
1585: END IF;

Line 1620: hz_utility_v2pub.debug (

1616: l_debug_prefix := '';
1617:
1618: -- Debug info.
1619: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1620: hz_utility_v2pub.debug (
1621: p_message => c_api_name||' (+)',
1622: p_prefix => l_debug_prefix,
1623: p_msg_level => fnd_log.level_procedure);
1624: END IF;

Line 1669: hz_utility_v2pub.debug (

1665: p_party_usg_assignment_id => l_party_usg_assignment_id);
1666:
1667: -- Debug info.
1668: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1669: hz_utility_v2pub.debug (
1670: p_message => c_api_name||' (-)',
1671: p_prefix => l_debug_prefix,
1672: p_msg_level => fnd_log.level_procedure);
1673: END IF;

Line 1721: hz_utility_v2pub.debug (

1717: l_debug_prefix := '';
1718:
1719: -- Debug info.
1720: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1721: hz_utility_v2pub.debug (
1722: p_message => c_api_name||' (+)',
1723: p_prefix => l_debug_prefix,
1724: p_msg_level => fnd_log.level_procedure);
1725: END IF;

Line 1787: hz_utility_v2pub.debug (

1783: p_party_usg_assignment_id => p_party_usg_assignment_id);
1784:
1785: -- Debug info.
1786: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1787: hz_utility_v2pub.debug (
1788: p_message => c_api_name||' (-)',
1789: p_prefix => l_debug_prefix,
1790: p_msg_level => fnd_log.level_procedure);
1791: END IF;

Line 1908: hz_utility_v2pub.debug (

1904: l_debug_prefix := '';
1905:
1906: -- Debug info.
1907: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1908: hz_utility_v2pub.debug (
1909: p_message => c_api_name||' (+)',
1910: p_prefix => l_debug_prefix,
1911: p_msg_level => fnd_log.level_procedure
1912: );

Line 1949: hz_utility_v2pub.debug_return_messages (

1945: p_data => x_msg_data);
1946:
1947: -- Debug info.
1948: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1949: hz_utility_v2pub.debug_return_messages (
1950: p_msg_count => x_msg_count,
1951: p_msg_data => x_msg_data,
1952: p_msg_type => 'WARNING',
1953: p_msg_level => fnd_log.level_exception

Line 1958: hz_utility_v2pub.debug (

1954: );
1955: END IF;
1956:
1957: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1958: hz_utility_v2pub.debug (
1959: p_message => c_api_name||' (-)',
1960: p_prefix => l_debug_prefix,
1961: p_msg_level => fnd_log.level_procedure
1962: );

Line 1978: hz_utility_v2pub.debug_return_messages (

1974: );
1975:
1976: -- Debug info.
1977: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1978: hz_utility_v2pub.debug_return_messages (
1979: p_msg_count => x_msg_count,
1980: p_msg_data => x_msg_data,
1981: p_msg_type => 'ERROR',
1982: p_msg_level => fnd_log.level_error

Line 1987: hz_utility_v2pub.debug (

1983: );
1984: END IF;
1985:
1986: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1987: hz_utility_v2pub.debug (
1988: p_message => c_api_name||' (-)',
1989: p_prefix => l_debug_prefix,
1990: p_msg_level => fnd_log.level_procedure
1991: );

Line 2005: hz_utility_v2pub.debug_return_messages (

2001: );
2002:
2003: -- Debug info.
2004: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2005: hz_utility_v2pub.debug_return_messages (
2006: p_msg_count => x_msg_count,
2007: p_msg_data => x_msg_data,
2008: p_msg_type => 'UNEXPECTED ERROR',
2009: p_msg_level => fnd_log.level_error

Line 2014: hz_utility_v2pub.debug (

2010: );
2011: END IF;
2012:
2013: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
2014: hz_utility_v2pub.debug (
2015: p_message => c_api_name||' (-)',
2016: p_prefix => l_debug_prefix,
2017: p_msg_level => fnd_log.level_procedure
2018: );

Line 2037: hz_utility_v2pub.debug_return_messages (

2033: );
2034:
2035: -- Debug info.
2036: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2037: hz_utility_v2pub.debug_return_messages (
2038: p_msg_count => x_msg_count,
2039: p_msg_data => x_msg_data,
2040: p_msg_type => 'SQL ERROR',
2041: p_msg_level => fnd_log.level_error

Line 2046: hz_utility_v2pub.debug (

2042: );
2043: END IF;
2044:
2045: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
2046: hz_utility_v2pub.debug (
2047: p_message => c_api_name||' (-)',
2048: p_prefix => l_debug_prefix,
2049: p_msg_level => fnd_log.level_procedure
2050: );

Line 2115: hz_utility_v2pub.debug (

2111: l_debug_prefix := '';
2112:
2113: -- Debug info.
2114: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
2115: hz_utility_v2pub.debug (
2116: p_message => c_api_name||' (+)',
2117: p_prefix => l_debug_prefix,
2118: p_msg_level => fnd_log.level_procedure
2119: );

Line 2258: hz_utility_v2pub.debug_return_messages (

2254: p_data => x_msg_data);
2255:
2256: -- Debug info.
2257: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2258: hz_utility_v2pub.debug_return_messages (
2259: p_msg_count => x_msg_count,
2260: p_msg_data => x_msg_data,
2261: p_msg_type => 'WARNING',
2262: p_msg_level => fnd_log.level_exception

Line 2267: hz_utility_v2pub.debug (

2263: );
2264: END IF;
2265:
2266: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
2267: hz_utility_v2pub.debug (
2268: p_message => c_api_name||' (-)',
2269: p_prefix => l_debug_prefix,
2270: p_msg_level => fnd_log.level_procedure
2271: );

Line 2286: hz_utility_v2pub.debug_return_messages (

2282: );
2283:
2284: -- Debug info.
2285: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2286: hz_utility_v2pub.debug_return_messages (
2287: p_msg_count => x_msg_count,
2288: p_msg_data => x_msg_data,
2289: p_msg_type => 'ERROR',
2290: p_msg_level => fnd_log.level_error

Line 2295: hz_utility_v2pub.debug (

2291: );
2292: END IF;
2293:
2294: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
2295: hz_utility_v2pub.debug (
2296: p_message => c_api_name||' (-)',
2297: p_prefix => l_debug_prefix,
2298: p_msg_level => fnd_log.level_procedure
2299: );

Line 2312: hz_utility_v2pub.debug_return_messages (

2308: );
2309:
2310: -- Debug info.
2311: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2312: hz_utility_v2pub.debug_return_messages (
2313: p_msg_count => x_msg_count,
2314: p_msg_data => x_msg_data,
2315: p_msg_type => 'UNEXPECTED ERROR',
2316: p_msg_level => fnd_log.level_error

Line 2321: hz_utility_v2pub.debug (

2317: );
2318: END IF;
2319:
2320: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
2321: hz_utility_v2pub.debug (
2322: p_message => c_api_name||' (-)',
2323: p_prefix => l_debug_prefix,
2324: p_msg_level => fnd_log.level_procedure
2325: );

Line 2343: hz_utility_v2pub.debug_return_messages (

2339: );
2340:
2341: -- Debug info.
2342: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2343: hz_utility_v2pub.debug_return_messages (
2344: p_msg_count => x_msg_count,
2345: p_msg_data => x_msg_data,
2346: p_msg_type => 'SQL ERROR',
2347: p_msg_level => fnd_log.level_error

Line 2352: hz_utility_v2pub.debug (

2348: );
2349: END IF;
2350:
2351: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
2352: hz_utility_v2pub.debug (
2353: p_message => c_api_name||' (-)',
2354: p_prefix => l_debug_prefix,
2355: p_msg_level => fnd_log.level_procedure
2356: );

Line 2420: hz_utility_v2pub.debug (

2416: l_debug_prefix := '';
2417:
2418: -- Debug info.
2419: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
2420: hz_utility_v2pub.debug (
2421: p_message => c_api_name||' (+)',
2422: p_prefix => l_debug_prefix,
2423: p_msg_level => fnd_log.level_procedure
2424: );

Line 2478: hz_utility_v2pub.debug_return_messages (

2474: p_data => x_msg_data);
2475:
2476: -- Debug info.
2477: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2478: hz_utility_v2pub.debug_return_messages (
2479: p_msg_count => x_msg_count,
2480: p_msg_data => x_msg_data,
2481: p_msg_type => 'WARNING',
2482: p_msg_level => fnd_log.level_exception

Line 2487: hz_utility_v2pub.debug (

2483: );
2484: END IF;
2485:
2486: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
2487: hz_utility_v2pub.debug (
2488: p_message => c_api_name||' (-)',
2489: p_prefix => l_debug_prefix,
2490: p_msg_level => fnd_log.level_procedure
2491: );

Line 2507: hz_utility_v2pub.debug_return_messages (

2503: );
2504:
2505: -- Debug info.
2506: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2507: hz_utility_v2pub.debug_return_messages (
2508: p_msg_count => x_msg_count,
2509: p_msg_data => x_msg_data,
2510: p_msg_type => 'ERROR',
2511: p_msg_level => fnd_log.level_error

Line 2516: hz_utility_v2pub.debug (

2512: );
2513: END IF;
2514:
2515: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
2516: hz_utility_v2pub.debug (
2517: p_message => c_api_name||' (-)',
2518: p_prefix => l_debug_prefix,
2519: p_msg_level => fnd_log.level_procedure
2520: );

Line 2534: hz_utility_v2pub.debug_return_messages (

2530: );
2531:
2532: -- Debug info.
2533: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2534: hz_utility_v2pub.debug_return_messages (
2535: p_msg_count => x_msg_count,
2536: p_msg_data => x_msg_data,
2537: p_msg_type => 'UNEXPECTED ERROR',
2538: p_msg_level => fnd_log.level_error

Line 2543: hz_utility_v2pub.debug (

2539: );
2540: END IF;
2541:
2542: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
2543: hz_utility_v2pub.debug (
2544: p_message => c_api_name||' (-)',
2545: p_prefix => l_debug_prefix,
2546: p_msg_level => fnd_log.level_procedure
2547: );

Line 2566: hz_utility_v2pub.debug_return_messages (

2562: );
2563:
2564: -- Debug info.
2565: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2566: hz_utility_v2pub.debug_return_messages (
2567: p_msg_count => x_msg_count,
2568: p_msg_data => x_msg_data,
2569: p_msg_type => 'SQL ERROR',
2570: p_msg_level => fnd_log.level_error

Line 2575: hz_utility_v2pub.debug (

2571: );
2572: END IF;
2573:
2574: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
2575: hz_utility_v2pub.debug (
2576: p_message => c_api_name||' (-)',
2577: p_prefix => l_debug_prefix,
2578: p_msg_level => fnd_log.level_procedure
2579: );

Line 2639: hz_utility_v2pub.debug (

2635: l_debug_prefix := '';
2636:
2637: -- Debug info.
2638: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
2639: hz_utility_v2pub.debug (
2640: p_message => c_api_name||' (+)',
2641: p_prefix => l_debug_prefix,
2642: p_msg_level => fnd_log.level_procedure
2643: );

Line 2676: hz_utility_v2pub.debug (

2672: END IF;
2673: END IF;
2674:
2675: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
2676: hz_utility_v2pub.debug (
2677: p_message => c_api_name||' (-)',
2678: p_prefix => l_debug_prefix,
2679: p_msg_level => fnd_log.level_procedure
2680: );

Line 2789: hz_utility_v2pub.debug (

2785: l_allow_party_merge := 'Y';
2786:
2787: -- Debug info.
2788: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
2789: hz_utility_v2pub.debug (
2790: p_message => c_api_name||' (+)',
2791: p_prefix => l_debug_prefix,
2792: p_msg_level => fnd_log.level_procedure
2793: );

Line 2834: hz_utility_v2pub.debug(

2830: l_continue_i = 'Y')
2831: LOOP
2832: -- Debug info.
2833: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2834: hz_utility_v2pub.debug(
2835: p_prefix => l_debug_prefix,
2836: p_message => 'l_from_party_usage_codes_tbl('||i||') = '||
2837: l_from_party_usage_codes_tbl(i),
2838: p_msg_level => fnd_log.level_statement);

Line 2847: hz_utility_v2pub.debug(

2843: l_continue_j = 'Y')
2844: LOOP
2845: -- Debug info.
2846: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2847: hz_utility_v2pub.debug(
2848: p_prefix => l_debug_prefix,
2849: p_message => 'l_to_party_usage_codes_tbl('||j||') = '||
2850: l_to_party_usage_codes_tbl(j),
2851: p_msg_level => fnd_log.level_statement);

Line 2893: hz_utility_v2pub.debug_return_messages (

2889: p_data => x_msg_data);
2890:
2891: -- Debug info.
2892: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2893: hz_utility_v2pub.debug_return_messages (
2894: p_msg_count => x_msg_count,
2895: p_msg_data => x_msg_data,
2896: p_msg_type => 'ERROR',
2897: p_msg_level => fnd_log.level_exception

Line 2902: hz_utility_v2pub.debug (

2898: );
2899: END IF;
2900:
2901: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
2902: hz_utility_v2pub.debug (
2903: p_message => c_api_name||' (-)',
2904: p_prefix => l_debug_prefix,
2905: p_msg_level => fnd_log.level_procedure
2906: );

Line 2949: hz_utility_v2pub.debug (

2945:
2946: BEGIN
2947: -- Debug info.
2948: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
2949: hz_utility_v2pub.debug (
2950: p_message => c_api_name||' (+)',
2951: p_prefix => l_debug_prefix,
2952: p_msg_level => fnd_log.level_procedure
2953: );

Line 2976: hz_utility_v2pub.debug (

2972: END IF;
2973:
2974: -- Debug info.
2975: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
2976: hz_utility_v2pub.debug (
2977: p_message => c_api_name||' (-)',
2978: p_prefix => l_debug_prefix,
2979: p_msg_level => fnd_log.level_procedure
2980: );

Line 3046: hz_utility_v2pub.debug(

3042: END IF;
3043: CLOSE c_party;
3044:
3045: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3046: hz_utility_v2pub.debug(
3047: p_prefix => '',
3048: p_message => 'after validate supplier name uniqueness ... ' ||
3049: 'x_return_status = ' || x_return_status,
3050: p_msg_level => fnd_log.level_statement);