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 FND_LOG

Line 110: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

106:
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);

Line 114: p_msg_level => fnd_log.level_procedure);

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;
116:
117: -- populate function for integration service
118: IF hz_utility_v2pub.G_EXECUTE_API_CALLOUTS IN ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')

Line 126: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

122: P_party_usg_assignment_id => p_party_usg_assignment_id);
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);

Line 130: p_msg_level => fnd_log.level_procedure);

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;
132:
133: END populate_bot;
134:

Line 339: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

335:
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);

Line 343: p_msg_level => fnd_log.level_procedure);

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;
345:
346: -- Debug info.
347: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 347: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

343: p_msg_level => fnd_log.level_procedure);
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);

Line 351: p_msg_level => fnd_log.level_statement);

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;
353:
354: --
355: -- HIGH VALIDATION

Line 375: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

371: x_return_status => x_return_status
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,

Line 380: p_msg_level => fnd_log.level_statement);

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);
381: END IF;
382:
383: --
384: -- mandatory: party_usage_code

Line 394: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

390: x_return_status => x_return_status
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,

Line 399: p_msg_level => fnd_log.level_statement);

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);
400: END IF;
401:
402: --
403: -- conditional mandatory: owner_table_name, owner_table_id

Line 428: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

424: );
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,

Line 433: p_msg_level => fnd_log.level_statement);

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);
434: END IF;
435:
436: --
437: -- foreign key: owner_table_name, owner_table_id.

Line 453: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

449: x_return_status := fnd_api.G_RET_STS_ERROR;
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,

Line 458: p_msg_level => fnd_log.level_statement);

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);
459: END IF;
460: END IF;
461: */
462:

Line 475: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

471: x_return_status => x_return_status
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,

Line 480: p_msg_level => fnd_log.level_statement);

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);
481: END IF;
482:
483: --
484: -- non-updateable: party_usage_code

Line 494: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

490: x_return_status => x_return_status
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,

Line 499: p_msg_level => fnd_log.level_statement);

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);
500: END IF;
501:
502: --
503: -- non-updateable: owner_table_name

Line 513: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

509: x_return_status => x_return_status
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,

Line 518: p_msg_level => fnd_log.level_statement);

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);
519: END IF;
520:
521: --
522: -- non-updateable: owner_table_id

Line 532: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

528: x_return_status => x_return_status
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,

Line 537: p_msg_level => fnd_log.level_statement);

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);
538: END IF;
539:
540: END IF; -- p_create_update_flag = 'U'
541:

Line 557: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

553: x_return_status := fnd_api.G_RET_STS_ERROR;
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,

Line 562: p_msg_level => fnd_log.level_statement);

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);
563: END IF;
564:
565: --
566: -- mandatory, non-updateable, lookup : created_by_module

Line 607: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

603: db_restrict_manual_update := l_value_tbl(4);
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||' '||

Line 615: p_msg_level => fnd_log.level_statement);

611: 'db_party_usage_status = '||db_party_usage_status||' '||
612: 'db_party_usage_type = '||db_party_usage_type||' '||
613: 'db_restrict_manual_assign = '||db_restrict_manual_assign||' '||
614: 'db_restrict_manual_update = '||db_restrict_manual_update,
615: p_msg_level => fnd_log.level_statement);
616: END IF;
617: ELSIF p_create_update_flag = 'C' THEN
618: --
619: -- invalid foreign key

Line 628: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

624: x_return_status := fnd_api.G_RET_STS_ERROR;
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,

Line 633: p_msg_level => fnd_log.level_statement);

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);
634: END IF;
635:
636: IF p_create_update_flag = 'C' THEN
637: --

Line 648: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

644: x_return_status := fnd_api.G_RET_STS_ERROR;
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,

Line 653: p_msg_level => fnd_log.level_statement);

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);
654: END IF;
655:
656: --
657: -- foreign key: party_id

Line 672: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

668: END IF;
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||' '||

Line 678: p_msg_level => fnd_log.level_statement);

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,
678: p_msg_level => fnd_log.level_statement);
679: END IF;
680:
681: --
682: -- party type doesn't match

Line 693: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

689: x_return_status := fnd_api.G_RET_STS_ERROR;
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,

Line 698: p_msg_level => fnd_log.level_statement);

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);
699: END IF;
700:
701: --
702: -- disallow certain usages be used by public API

Line 729: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

725: x_return_status := fnd_api.G_RET_STS_ERROR;
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||' '||

Line 735: p_msg_level => fnd_log.level_statement);

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,
735: p_msg_level => fnd_log.level_statement);
736: END IF;
737: END IF;
738:
739: -- Bug 4586451

Line 767: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

763: x_return_status := fnd_api.G_RET_STS_ERROR;
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,

Line 772: p_msg_level => fnd_log.level_statement);

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);
773: END IF;
774: END IF;
775:
776: END IF; -- MEDIUM VALIDATION

Line 803: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

799: WHILE (i <= l_party_usage_codes_tbl.count AND
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),

Line 808: p_msg_level => fnd_log.level_statement);

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);
809: END IF;
810:
811: IF NOT l_temp_party_usage_codes.exists(l_party_usage_codes_tbl(i)) AND
812: l_party_usage_codes_tbl(i) <> l_party_usage_code

Line 837: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

833: l_continue := 'N';
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,

Line 842: p_msg_level => fnd_log.level_statement);

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);
843: END IF;
844:
845: END IF;
846:

Line 854: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

850:
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);

Line 858: p_msg_level => fnd_log.level_procedure);

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;
860:
861: END validate_party_usg_assignment;
862:

Line 926: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

922:
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);

Line 930: p_msg_level => fnd_log.level_procedure);

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;
932:
933: l_has_duplicates := 'N';
934:

Line 945: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

941: p_party_usg_assignment_rec.owner_table_id IS NOT NULL AND
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.',

Line 950: p_msg_level => fnd_log.level_statement);

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);
951: END IF;
952:
953: OPEN c_duplicate_assignment0 (
954: p_party_usg_assignment_rec.party_id,

Line 975: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

971: p_party_usg_assignment_rec.party_usage_code IS NOT NULL AND
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||'. '||

Line 981: p_msg_level => fnd_log.level_statement);

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.',
981: p_msg_level => fnd_log.level_statement);
982: END IF;
983:
984: OPEN c_duplicate_assignment1 (
985: p_party_usg_assignment_rec.party_id,

Line 1000: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

996: CLOSE c_duplicate_assignment1;
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);

Line 1004: p_msg_level => fnd_log.level_statement);

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;
1006:
1007: -- Debug info.
1008: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

Line 1008: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1004: p_msg_level => fnd_log.level_statement);
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);

Line 1012: p_msg_level => fnd_log.level_procedure);

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;
1014:
1015: return l_has_duplicates;
1016:

Line 1072: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1068:
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);

Line 1076: p_msg_level => fnd_log.level_procedure);

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;
1078:
1079: -- load setup data
1080: IF G_SETUP_LOADED = 0 THEN

Line 1104: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1100: trunc(p_party_usg_assignment_rec.effective_end_date);
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')||' '||

Line 1111: p_msg_level => fnd_log.level_statement);

1107: p_message => 'effective_start_date = '||
1108: TO_CHAR(p_party_usg_assignment_rec.effective_start_date, 'YYYY/MM/DD')||' '||
1109: 'effective_end_date = '||
1110: TO_CHAR(p_party_usg_assignment_rec.effective_end_date, 'YYYY/MM/DD'),
1111: p_msg_level => fnd_log.level_statement);
1112: END IF;
1113:
1114: --
1115: -- Do validation

Line 1210: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1206: );
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);

Line 1214: p_msg_level => fnd_log.level_procedure);

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;
1216:
1217: END do_assign_party_usage;
1218:

Line 1272: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1268:
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);

Line 1276: p_msg_level => fnd_log.level_procedure);

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;
1278:
1279: -- load setup data
1280: IF G_SETUP_LOADED = 0 THEN

Line 1312: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1308: p_party_usg_assignment_rec.effective_end_date := D_FUTURE_DATE;
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')||' '||

Line 1319: p_msg_level => fnd_log.level_statement);

1315: p_message => 'effective_start_date = '||
1316: TO_CHAR(p_party_usg_assignment_rec.effective_start_date, 'YYYY/MM/DD')||' '||
1317: 'effective_end_date = '||
1318: TO_CHAR(p_party_usg_assignment_rec.effective_end_date, 'YYYY/MM/DD'),
1319: p_msg_level => fnd_log.level_statement);
1320: END IF;
1321:
1322: --
1323: -- Do validation

Line 1415: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1411: END IF;
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);

Line 1419: p_msg_level => fnd_log.level_procedure);

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;
1421:
1422: END do_update_usg_assignment;
1423:

Line 1502: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1498:
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);

Line 1506: p_msg_level => fnd_log.level_procedure);

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;
1508:
1509: G_PARTY_USAGE_CODES.delete;
1510: G_CREATED_BY_MODULES.delete;

Line 1572: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1568:
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);

Line 1576: p_msg_level => fnd_log.level_statement);

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;
1578:
1579: -- Debug info.
1580: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

Line 1580: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1576: p_msg_level => fnd_log.level_statement);
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);

Line 1584: p_msg_level => fnd_log.level_procedure);

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;
1586:
1587: END initialize;
1588:

Line 1619: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1615:
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);

Line 1623: p_msg_level => fnd_log.level_procedure);

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;
1625:
1626: HZ_PARTY_USG_ASSIGNMENTS_PKG.insert_row (
1627: x_party_id => p_party_usg_assignment_rec.party_id,

Line 1668: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1664: p_create_update_flag => 'I',
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);

Line 1672: p_msg_level => fnd_log.level_procedure);

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;
1674:
1675: END insert_row;
1676:

Line 1720: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1716:
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);

Line 1724: p_msg_level => fnd_log.level_procedure);

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;
1726:
1727: OPEN c_assignment(p_party_usg_assignment_id);
1728: FETCH c_assignment INTO l_object_version_number;

Line 1786: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1782: p_create_update_flag => 'U',
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);

Line 1790: p_msg_level => fnd_log.level_procedure);

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;
1792:
1793: END update_row;
1794:

Line 1907: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1903:
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

Line 1911: p_msg_level => fnd_log.level_procedure

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: );
1913: END IF;
1914:
1915: -- initialize message list if p_init_msg_list is set to TRUE.

Line 1948: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1944: p_count => x_msg_count,
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',

Line 1953: p_msg_level => fnd_log.level_exception

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
1954: );
1955: END IF;
1956:
1957: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

Line 1957: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1953: p_msg_level => fnd_log.level_exception
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

Line 1961: p_msg_level => fnd_log.level_procedure

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: );
1963: END IF;
1964:
1965: EXCEPTION

Line 1977: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1973: p_data => x_msg_data
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',

Line 1982: p_msg_level => fnd_log.level_error

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
1983: );
1984: END IF;
1985:
1986: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

Line 1986: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1982: p_msg_level => fnd_log.level_error
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

Line 1990: p_msg_level => fnd_log.level_procedure

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: );
1992: END IF;
1993:
1994: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

Line 2004: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

2000: p_data => x_msg_data
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',

Line 2009: p_msg_level => fnd_log.level_error

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
2010: );
2011: END IF;
2012:
2013: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

Line 2013: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

2009: p_msg_level => fnd_log.level_error
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

Line 2017: p_msg_level => fnd_log.level_procedure

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: );
2019: END IF;
2020:
2021: WHEN OTHERS THEN

Line 2036: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

2032: p_data => x_msg_data
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',

Line 2041: p_msg_level => fnd_log.level_error

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
2042: );
2043: END IF;
2044:
2045: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

Line 2045: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

2041: p_msg_level => fnd_log.level_error
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

Line 2049: p_msg_level => fnd_log.level_procedure

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: );
2051: END IF;
2052:
2053: END assign_party_usage;

Line 2114: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

2110:
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

Line 2118: p_msg_level => fnd_log.level_procedure

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: );
2120: END IF;
2121:
2122: -- initialize message list if p_init_msg_list is set to TRUE.

Line 2257: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

2253: p_count => x_msg_count,
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',

Line 2262: p_msg_level => fnd_log.level_exception

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
2263: );
2264: END IF;
2265:
2266: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

Line 2266: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

2262: p_msg_level => fnd_log.level_exception
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

Line 2270: p_msg_level => fnd_log.level_procedure

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: );
2272: END IF;
2273:
2274: EXCEPTION

Line 2285: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

2281: p_data => x_msg_data
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',

Line 2290: p_msg_level => fnd_log.level_error

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
2291: );
2292: END IF;
2293:
2294: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

Line 2294: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

2290: p_msg_level => fnd_log.level_error
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

Line 2298: p_msg_level => fnd_log.level_procedure

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: );
2300: END IF;
2301:
2302: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

Line 2311: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

2307: p_data => x_msg_data
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',

Line 2316: p_msg_level => fnd_log.level_error

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
2317: );
2318: END IF;
2319:
2320: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

Line 2320: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

2316: p_msg_level => fnd_log.level_error
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

Line 2324: p_msg_level => fnd_log.level_procedure

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: );
2326: END IF;
2327:
2328: WHEN OTHERS THEN

Line 2342: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

2338: p_data => x_msg_data
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',

Line 2347: p_msg_level => fnd_log.level_error

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
2348: );
2349: END IF;
2350:
2351: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

Line 2351: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

2347: p_msg_level => fnd_log.level_error
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

Line 2355: p_msg_level => fnd_log.level_procedure

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: );
2357: END IF;
2358:
2359: END get_usg_assignment;

Line 2419: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

2415:
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

Line 2423: p_msg_level => fnd_log.level_procedure

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: );
2425: END IF;
2426:
2427: -- initialize message list if p_init_msg_list is set to TRUE.

Line 2477: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

2473: p_count => x_msg_count,
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',

Line 2482: p_msg_level => fnd_log.level_exception

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
2483: );
2484: END IF;
2485:
2486: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

Line 2486: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

2482: p_msg_level => fnd_log.level_exception
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

Line 2490: p_msg_level => fnd_log.level_procedure

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: );
2492: END IF;
2493:
2494: EXCEPTION

Line 2506: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

2502: p_data => x_msg_data
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',

Line 2511: p_msg_level => fnd_log.level_error

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
2512: );
2513: END IF;
2514:
2515: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

Line 2515: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

2511: p_msg_level => fnd_log.level_error
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

Line 2519: p_msg_level => fnd_log.level_procedure

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: );
2521: END IF;
2522:
2523: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

Line 2533: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

2529: p_data => x_msg_data
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',

Line 2538: p_msg_level => fnd_log.level_error

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
2539: );
2540: END IF;
2541:
2542: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

Line 2542: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

2538: p_msg_level => fnd_log.level_error
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

Line 2546: p_msg_level => fnd_log.level_procedure

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: );
2548: END IF;
2549:
2550: WHEN OTHERS THEN

Line 2565: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

2561: p_data => x_msg_data
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',

Line 2570: p_msg_level => fnd_log.level_error

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
2571: );
2572: END IF;
2573:
2574: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

Line 2574: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

2570: p_msg_level => fnd_log.level_error
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

Line 2578: p_msg_level => fnd_log.level_procedure

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: );
2580: END IF;
2581:
2582: END update_usg_assignment;

Line 2638: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

2634:
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

Line 2642: p_msg_level => fnd_log.level_procedure

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: );
2644: END IF;
2645:
2646: l_party_usg_assignment_rec.party_id := p_party_id;

Line 2675: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

2671: p_data => x_msg_data);
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

Line 2679: p_msg_level => fnd_log.level_procedure

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: );
2681: END IF;
2682:
2683: END inactivate_usg_assignment;

Line 2788: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

2784: l_debug_prefix := '';
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

Line 2792: p_msg_level => fnd_log.level_procedure

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: );
2794: END IF;
2795:
2796: -- initialize message list if p_init_msg_list is set to TRUE.

Line 2833: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2829: WHILE (i <= l_from_party_usage_codes_tbl.count AND
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),

Line 2838: p_msg_level => fnd_log.level_statement);

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);
2839: END IF;
2840:
2841: l_continue_j := 'Y'; j := 1;
2842: WHILE (j <= l_to_party_usage_codes_tbl.count AND

Line 2846: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2842: WHILE (j <= l_to_party_usage_codes_tbl.count AND
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),

Line 2851: p_msg_level => fnd_log.level_statement);

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);
2852: END IF;
2853:
2854: --
2855: -- check exclusive rule

Line 2892: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

2888: p_count => x_msg_count,
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',

Line 2897: p_msg_level => fnd_log.level_exception

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
2898: );
2899: END IF;
2900:
2901: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

Line 2901: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

2897: p_msg_level => fnd_log.level_exception
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

Line 2905: p_msg_level => fnd_log.level_procedure

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: );
2907: END IF;
2908:
2909: RETURN l_allow_party_merge;

Line 2948: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

2944: x_msg_data VARCHAR2(2000);
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

Line 2952: p_msg_level => fnd_log.level_procedure

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: );
2954: END IF;
2955:
2956: -- get old assignment.

Line 2975: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

2971: l_has_duplicates := duplicates_exist(l_party_usg_assignment_rec, x_to_assignment_id);
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

Line 2979: p_msg_level => fnd_log.level_procedure

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: );
2981: END IF;
2982:
2983: END find_duplicates;

Line 3045: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3041: x_return_status := fnd_api.g_ret_sts_error;
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,

Line 3050: p_msg_level => fnd_log.level_statement);

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);
3051: END IF;
3052:
3053: END validate_supplier_name;
3054: