589: (P_MESSAGE_NAME IS NOT NULL)) then
590: l_msg_app := P_MESSAGE_APP;
591: l_msg_name := P_MESSAGE_NAME;
592: else
593: FND_MESSAGE.PARSE_ENCODED(l_enc_msg,
594: l_msg_app,
595: l_msg_name);
596: end if;
597:
626: and fnm.MESSAGE_NAME = l_msg_name
627: and fnm.LANGUAGE_CODE = l_base_lang;
628: exception
629: when others then
630: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
631: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
632: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
633: FND_MESSAGE.SET_TOKEN ('ROUTINE',
634: 'FND_LOG_REPOSITORY.POST_EXCEPTION', FALSE);
627: and fnm.LANGUAGE_CODE = l_base_lang;
628: exception
629: when others then
630: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
631: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
632: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
633: FND_MESSAGE.SET_TOKEN ('ROUTINE',
634: 'FND_LOG_REPOSITORY.POST_EXCEPTION', FALSE);
635:
628: exception
629: when others then
630: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
631: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
632: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
633: FND_MESSAGE.SET_TOKEN ('ROUTINE',
634: 'FND_LOG_REPOSITORY.POST_EXCEPTION', FALSE);
635:
636: rollback;
629: when others then
630: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
631: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
632: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
633: FND_MESSAGE.SET_TOKEN ('ROUTINE',
634: 'FND_LOG_REPOSITORY.POST_EXCEPTION', FALSE);
635:
636: rollback;
637: return FALSE;
660: where parameter = 'NLS_SORT';
661:
662: dbms_session.set_nls('NLS_LANGUAGE', 'AMERICAN');
663:
664: fnd_message.set_encoded(l_enc_msg);
665:
666: l_msg_text := fnd_message.get;
667:
668: dbms_session.set_nls('NLS_LANGUAGE', '"' || l_cur_lang || '"');
662: dbms_session.set_nls('NLS_LANGUAGE', 'AMERICAN');
663:
664: fnd_message.set_encoded(l_enc_msg);
665:
666: l_msg_text := fnd_message.get;
667:
668: dbms_session.set_nls('NLS_LANGUAGE', '"' || l_cur_lang || '"');
669: dbms_session.set_nls('NLS_DATE_LANGUAGE', '"' || l_cur_date_lang || '"');
670: dbms_session.set_nls('NLS_SORT', '"' || l_cur_sort || '"');
763:
764:
765: exception
766: when others then
767: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
768: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
769: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
770: FND_MESSAGE.SET_TOKEN ('ROUTINE',
771: 'FND_LOG_REPOSITORY.POST_EXCEPTION', FALSE);
764:
765: exception
766: when others then
767: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
768: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
769: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
770: FND_MESSAGE.SET_TOKEN ('ROUTINE',
771: 'FND_LOG_REPOSITORY.POST_EXCEPTION', FALSE);
772: rollback;
765: exception
766: when others then
767: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
768: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
769: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
770: FND_MESSAGE.SET_TOKEN ('ROUTINE',
771: 'FND_LOG_REPOSITORY.POST_EXCEPTION', FALSE);
772: rollback;
773: return FALSE;
766: when others then
767: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
768: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
769: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
770: FND_MESSAGE.SET_TOKEN ('ROUTINE',
771: 'FND_LOG_REPOSITORY.POST_EXCEPTION', FALSE);
772: rollback;
773: return FALSE;
774:
1599: to_char(l_event_key) );
1600: commit;
1601: exception
1602: when others then
1603: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
1604: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
1605: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
1606: FND_MESSAGE.SET_TOKEN ('ROUTINE',
1607: 'FND_LOG_REPOSITORY.METRIC_EVENT_INTERNAL', FALSE);
1600: commit;
1601: exception
1602: when others then
1603: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
1604: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
1605: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
1606: FND_MESSAGE.SET_TOKEN ('ROUTINE',
1607: 'FND_LOG_REPOSITORY.METRIC_EVENT_INTERNAL', FALSE);
1608: rollback;
1601: exception
1602: when others then
1603: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
1604: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
1605: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
1606: FND_MESSAGE.SET_TOKEN ('ROUTINE',
1607: 'FND_LOG_REPOSITORY.METRIC_EVENT_INTERNAL', FALSE);
1608: rollback;
1609: end;
1602: when others then
1603: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
1604: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
1605: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
1606: FND_MESSAGE.SET_TOKEN ('ROUTINE',
1607: 'FND_LOG_REPOSITORY.METRIC_EVENT_INTERNAL', FALSE);
1608: rollback;
1609: end;
1610: