DBA Data[Home] [Help]

APPS.FND_LOG_REPOSITORY dependencies on FND_MESSAGE

Line 593: FND_MESSAGE.PARSE_ENCODED(l_enc_msg,

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:

Line 630: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');

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

Line 631: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, 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:

Line 632: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);

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;

Line 633: FND_MESSAGE.SET_TOKEN ('ROUTINE',

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;

Line 664: fnd_message.set_encoded(l_enc_msg);

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 || '"');

Line 666: l_msg_text := fnd_message.get;

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 || '"');

Line 767: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');

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

Line 768: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, 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;

Line 769: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);

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;

Line 770: FND_MESSAGE.SET_TOKEN ('ROUTINE',

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:

Line 1603: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');

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

Line 1604: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, 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;

Line 1605: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);

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;

Line 1606: FND_MESSAGE.SET_TOKEN ('ROUTINE',

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: