387: if g_debug then
388: hr_utility.set_location(l_proc, 41);
389: end if;
390: --
391: -- The FND FLEX KEYVAL package makes a call to FND MESSAGE
392: -- get encoded
393: hr_message.parse_encoded(p_encoded_error =>
394: FND_FLEX_KEYVAL.encoded_error_message);
395: if g_debug then
428: --
429: -- Now have the additional error information, raise a different error
430: -- using this information.
431: --
432: fnd_message.set_name('PER','HR_FLEX_VALUE_INVALID');
433: fnd_message.set_token('COLUMN',app_col_name);
434: fnd_message.set_token('VALUE',value);
435: fnd_message.set_token('PROMPT',l_flex_seg_error_prompt);
436: hr_multi_message.add
429: -- Now have the additional error information, raise a different error
430: -- using this information.
431: --
432: fnd_message.set_name('PER','HR_FLEX_VALUE_INVALID');
433: fnd_message.set_token('COLUMN',app_col_name);
434: fnd_message.set_token('VALUE',value);
435: fnd_message.set_token('PROMPT',l_flex_seg_error_prompt);
436: hr_multi_message.add
437: (p_associated_column1 => l_table_name || '.' || app_col_name);
430: -- using this information.
431: --
432: fnd_message.set_name('PER','HR_FLEX_VALUE_INVALID');
433: fnd_message.set_token('COLUMN',app_col_name);
434: fnd_message.set_token('VALUE',value);
435: fnd_message.set_token('PROMPT',l_flex_seg_error_prompt);
436: hr_multi_message.add
437: (p_associated_column1 => l_table_name || '.' || app_col_name);
438: elsif hr_message.last_message_app = 'FND' and
431: --
432: fnd_message.set_name('PER','HR_FLEX_VALUE_INVALID');
433: fnd_message.set_token('COLUMN',app_col_name);
434: fnd_message.set_token('VALUE',value);
435: fnd_message.set_token('PROMPT',l_flex_seg_error_prompt);
436: hr_multi_message.add
437: (p_associated_column1 => l_table_name || '.' || app_col_name);
438: elsif hr_message.last_message_app = 'FND' and
439: hr_message.last_message_name = 'FLEX-NULL SEGMENT' then
459: --
460: if g_debug then
461: hr_utility.set_location(l_proc, 55);
462: end if;
463: fnd_message.set_name('PER','HR_FLEX_VALUE_MISSING');
464: fnd_message.set_token('COLUMN',app_col_name);
465: fnd_message.set_token('PROMPT',l_flex_seg_error_prompt);
466: hr_multi_message.add
467: (p_associated_column1 => l_table_name || '.' || app_col_name);
460: if g_debug then
461: hr_utility.set_location(l_proc, 55);
462: end if;
463: fnd_message.set_name('PER','HR_FLEX_VALUE_MISSING');
464: fnd_message.set_token('COLUMN',app_col_name);
465: fnd_message.set_token('PROMPT',l_flex_seg_error_prompt);
466: hr_multi_message.add
467: (p_associated_column1 => l_table_name || '.' || app_col_name);
468: else
461: hr_utility.set_location(l_proc, 55);
462: end if;
463: fnd_message.set_name('PER','HR_FLEX_VALUE_MISSING');
464: fnd_message.set_token('COLUMN',app_col_name);
465: fnd_message.set_token('PROMPT',l_flex_seg_error_prompt);
466: hr_multi_message.add
467: (p_associated_column1 => l_table_name || '.' || app_col_name);
468: else
469: --
475: end if;
476: --
477: -- Raise the AOL error
478: --
479: fnd_message.set_name('FND',hr_message.last_message_name);
480: fnd_message.raise_error;
481: --
482: end if;
483: end if;
476: --
477: -- Raise the AOL error
478: --
479: fnd_message.set_name('FND',hr_message.last_message_name);
480: fnd_message.raise_error;
481: --
482: end if;
483: end if;
484: --
757: if g_debug then
758: hr_utility.set_location(l_proc, 81);
759: end if;
760: --
761: -- The FND FLEX KEYVAL package makes a call to FND MESSAGE
762: -- get encoded
763: hr_message.parse_encoded(p_encoded_error =>
764: FND_FLEX_KEYVAL.encoded_error_message);
765: if g_debug then
799: --
800: -- Now have the additional error information, raise a different error
801: -- using this information.
802: --
803: fnd_message.set_name('PER','HR_FLEX_VALUE_INVALID');
804: fnd_message.set_token('COLUMN',app_col_name);
805: fnd_message.set_token('VALUE',value);
806: fnd_message.set_token('PROMPT',l_flex_seg_error_prompt);
807: hr_multi_message.add
800: -- Now have the additional error information, raise a different error
801: -- using this information.
802: --
803: fnd_message.set_name('PER','HR_FLEX_VALUE_INVALID');
804: fnd_message.set_token('COLUMN',app_col_name);
805: fnd_message.set_token('VALUE',value);
806: fnd_message.set_token('PROMPT',l_flex_seg_error_prompt);
807: hr_multi_message.add
808: (p_associated_column1 => l_table_name || '.' || app_col_name);
801: -- using this information.
802: --
803: fnd_message.set_name('PER','HR_FLEX_VALUE_INVALID');
804: fnd_message.set_token('COLUMN',app_col_name);
805: fnd_message.set_token('VALUE',value);
806: fnd_message.set_token('PROMPT',l_flex_seg_error_prompt);
807: hr_multi_message.add
808: (p_associated_column1 => l_table_name || '.' || app_col_name);
809: elsif hr_message.last_message_app = 'FND' and
802: --
803: fnd_message.set_name('PER','HR_FLEX_VALUE_INVALID');
804: fnd_message.set_token('COLUMN',app_col_name);
805: fnd_message.set_token('VALUE',value);
806: fnd_message.set_token('PROMPT',l_flex_seg_error_prompt);
807: hr_multi_message.add
808: (p_associated_column1 => l_table_name || '.' || app_col_name);
809: elsif hr_message.last_message_app = 'FND' and
810: hr_message.last_message_name = 'FLEX-NULL SEGMENT' then
830: --
831: if g_debug then
832: hr_utility.set_location(l_proc, 95);
833: end if;
834: fnd_message.set_name('PER','HR_FLEX_VALUE_MISSING');
835: fnd_message.set_token('COLUMN',app_col_name);
836: fnd_message.set_token('PROMPT',l_flex_seg_error_prompt);
837: hr_multi_message.add
838: (p_associated_column1 => l_table_name || '.' || app_col_name);
831: if g_debug then
832: hr_utility.set_location(l_proc, 95);
833: end if;
834: fnd_message.set_name('PER','HR_FLEX_VALUE_MISSING');
835: fnd_message.set_token('COLUMN',app_col_name);
836: fnd_message.set_token('PROMPT',l_flex_seg_error_prompt);
837: hr_multi_message.add
838: (p_associated_column1 => l_table_name || '.' || app_col_name);
839: else
832: hr_utility.set_location(l_proc, 95);
833: end if;
834: fnd_message.set_name('PER','HR_FLEX_VALUE_MISSING');
835: fnd_message.set_token('COLUMN',app_col_name);
836: fnd_message.set_token('PROMPT',l_flex_seg_error_prompt);
837: hr_multi_message.add
838: (p_associated_column1 => l_table_name || '.' || app_col_name);
839: else
840: --
846: --
847: if g_debug then
848: hr_utility.set_location(l_proc, 100);
849: end if;
850: -- fnd_message.set_name('FND',hr_message.last_message_name); Fix for the bug 15845677
851: fnd_message.set_encoded(fnd_flex_keyval.encoded_error_message);
852: fnd_message.raise_error;
853: --
854: end if;
847: if g_debug then
848: hr_utility.set_location(l_proc, 100);
849: end if;
850: -- fnd_message.set_name('FND',hr_message.last_message_name); Fix for the bug 15845677
851: fnd_message.set_encoded(fnd_flex_keyval.encoded_error_message);
852: fnd_message.raise_error;
853: --
854: end if;
855: end if;
848: hr_utility.set_location(l_proc, 100);
849: end if;
850: -- fnd_message.set_name('FND',hr_message.last_message_name); Fix for the bug 15845677
851: fnd_message.set_encoded(fnd_flex_keyval.encoded_error_message);
852: fnd_message.raise_error;
853: --
854: end if;
855: end if;
856: --
1896:
1897: end loop;
1898: close get_seg_num;
1899: else
1900: fnd_message.raise_error;
1901: end if;
1902: --
1903: if g_debug then
1904: hr_utility.set_location(l_proc, 80);
2212: if hr_multi_message.exception_add then
2213: if g_debug then
2214: hr_utility.set_location('Leaving '|| l_proc, 160);
2215: end if;
2216: fnd_message.raise_error;
2217: end if;
2218: if g_debug then
2219: hr_utility.set_location('Leaving '|| l_proc, 170);
2220: end if;