DBA Data[Home] [Help]

APPS.FND_LOG_REPOSITORY dependencies on FND_MESSAGE

Line 571: FND_MESSAGE.PARSE_ENCODED(l_enc_msg,

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:

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

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

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

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

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;

Line 611: FND_MESSAGE.SET_TOKEN ('ROUTINE',

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;

Line 642: fnd_message.set_encoded(l_enc_msg);

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

Line 644: l_msg_text := fnd_message.get;

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

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

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

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

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

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;

Line 748: FND_MESSAGE.SET_TOKEN ('ROUTINE',

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:

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

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

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

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

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;

Line 1584: FND_MESSAGE.SET_TOKEN ('ROUTINE',

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: