567: (P_MESSAGE_NAME IS NOT NULL)) then
568: l_msg_app := P_MESSAGE_APP;
569: l_msg_name := P_MESSAGE_NAME;
570: else
571: FND_MESSAGE.PARSE_ENCODED(l_enc_msg,
572: l_msg_app,
573: l_msg_name);
574: end if;
575:
604: and fnm.MESSAGE_NAME = l_msg_name
605: and fnm.LANGUAGE_CODE = l_base_lang;
606: exception
607: when others then
608: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
609: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
610: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
611: FND_MESSAGE.SET_TOKEN ('ROUTINE',
612: 'FND_LOG_REPOSITORY.POST_EXCEPTION', FALSE);
605: and fnm.LANGUAGE_CODE = l_base_lang;
606: exception
607: when others then
608: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
609: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
610: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
611: FND_MESSAGE.SET_TOKEN ('ROUTINE',
612: 'FND_LOG_REPOSITORY.POST_EXCEPTION', FALSE);
613:
606: exception
607: when others then
608: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
609: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
610: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
611: FND_MESSAGE.SET_TOKEN ('ROUTINE',
612: 'FND_LOG_REPOSITORY.POST_EXCEPTION', FALSE);
613:
614: rollback;
607: when others then
608: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
609: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
610: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
611: FND_MESSAGE.SET_TOKEN ('ROUTINE',
612: 'FND_LOG_REPOSITORY.POST_EXCEPTION', FALSE);
613:
614: rollback;
615: return FALSE;
638: where parameter = 'NLS_SORT';
639:
640: dbms_session.set_nls('NLS_LANGUAGE', 'AMERICAN');
641:
642: fnd_message.set_encoded(l_enc_msg);
643:
644: l_msg_text := fnd_message.get;
645:
646: dbms_session.set_nls('NLS_LANGUAGE', '"' || l_cur_lang || '"');
640: dbms_session.set_nls('NLS_LANGUAGE', 'AMERICAN');
641:
642: fnd_message.set_encoded(l_enc_msg);
643:
644: l_msg_text := fnd_message.get;
645:
646: dbms_session.set_nls('NLS_LANGUAGE', '"' || l_cur_lang || '"');
647: dbms_session.set_nls('NLS_DATE_LANGUAGE', '"' || l_cur_date_lang || '"');
648: dbms_session.set_nls('NLS_SORT', '"' || l_cur_sort || '"');
741:
742:
743: exception
744: when others then
745: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
746: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
747: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
748: FND_MESSAGE.SET_TOKEN ('ROUTINE',
749: 'FND_LOG_REPOSITORY.POST_EXCEPTION', FALSE);
742:
743: exception
744: when others then
745: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
746: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
747: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
748: FND_MESSAGE.SET_TOKEN ('ROUTINE',
749: 'FND_LOG_REPOSITORY.POST_EXCEPTION', FALSE);
750: rollback;
743: exception
744: when others then
745: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
746: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
747: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
748: FND_MESSAGE.SET_TOKEN ('ROUTINE',
749: 'FND_LOG_REPOSITORY.POST_EXCEPTION', FALSE);
750: rollback;
751: return FALSE;
744: when others then
745: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
746: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
747: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
748: FND_MESSAGE.SET_TOKEN ('ROUTINE',
749: 'FND_LOG_REPOSITORY.POST_EXCEPTION', FALSE);
750: rollback;
751: return FALSE;
752:
1577: to_char(l_event_key) );
1578: commit;
1579: exception
1580: when others then
1581: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
1582: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
1583: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
1584: FND_MESSAGE.SET_TOKEN ('ROUTINE',
1585: 'FND_LOG_REPOSITORY.METRIC_EVENT_INTERNAL', FALSE);
1578: commit;
1579: exception
1580: when others then
1581: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
1582: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
1583: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
1584: FND_MESSAGE.SET_TOKEN ('ROUTINE',
1585: 'FND_LOG_REPOSITORY.METRIC_EVENT_INTERNAL', FALSE);
1586: rollback;
1579: exception
1580: when others then
1581: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
1582: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
1583: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
1584: FND_MESSAGE.SET_TOKEN ('ROUTINE',
1585: 'FND_LOG_REPOSITORY.METRIC_EVENT_INTERNAL', FALSE);
1586: rollback;
1587: end;
1580: when others then
1581: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
1582: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
1583: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
1584: FND_MESSAGE.SET_TOKEN ('ROUTINE',
1585: 'FND_LOG_REPOSITORY.METRIC_EVENT_INTERNAL', FALSE);
1586: rollback;
1587: end;
1588: