DBA Data[Home] [Help]

APPS.FND_LOG_REPOSITORY dependencies on FND_LOG_REPOSITORY

Line 1: package body FND_LOG_REPOSITORY as

1: package body FND_LOG_REPOSITORY as
2: /* $Header: AFUTLGRB.pls 120.12 2006/09/18 14:19:08 pferguso ship $ */
3:
4: --
5: -- PRIVATE TYPES, VARIABLES

Line 56: ** FND_LOG_REPOSITORY.String_Unchecked_Internal2

52: /*
53: ** For GET_CONTEXT Function
54: ** Types for storing context info before calling autonomous
55: ** logging procedures, like
56: ** FND_LOG_REPOSITORY.String_Unchecked_Internal2
57: */
58: type CONTEXT_REC is record (
59: a_col varchar2(30),
60: a_val varchar2(4000) );

Line 124: --insert into DEBUG_FND_LOG_REPOSITORY(MSG) values(p_msg);

120: --UTL_FILE.PUT_LINE(config_file, l_msg);
121: --UTL_FILE.fclose(config_file);
122:
123: ------Debug using DB
124: --insert into DEBUG_FND_LOG_REPOSITORY(MSG) values(p_msg);
125: --commit;
126: --dbms_output.put_line(p_msg);
127: l_msg := null;
128: end DEBUG;

Line 193: ** FND_LOG_REPOSITORY.INIT_TRANSACTION_INTERNAL

189: end IS_ALERTING_ENABLED;
190:
191:
192: /*
193: ** FND_LOG_REPOSITORY.INIT_TRANSACTION_INTERNAL
194: **
195: ** Description:
196: ** Initializes a log transaction. A log transaction
197: ** corresponds to an instance or invocation of a single

Line 262: ** FND_LOG_REPOSITORY.String_Unchecked_Internal2

258:
259: /*
260: ** GET_CONTEXT- Gathers context info within the session,
261: ** before calling autonomous logging procedures, like
262: ** FND_LOG_REPOSITORY.String_Unchecked_Internal2
263: */
264: PROCEDURE GET_CONTEXT (SESSION_ID IN NUMBER DEFAULT NULL,
265: USER_ID IN NUMBER DEFAULT NULL,
266: NODE IN VARCHAR2 DEFAULT NULL,

Line 412: ** FND_LOG_REPOSITORY.Init_Transaction_Internal

408:
409: /*
410: ** GET_TRANSACTION_CONTEXT- Gathers transaction context info within
411: ** the session, before calling autonomous procedures, like
412: ** FND_LOG_REPOSITORY.Init_Transaction_Internal
413: */
414: PROCEDURE GET_TRANSACTION_CONTEXT ( SESSION_ID IN NUMBER DEFAULT NULL,
415: USER_ID IN NUMBER DEFAULT NULL,
416: RESP_APPL_ID IN NUMBER DEFAULT NULL,

Line 612: 'FND_LOG_REPOSITORY.POST_EXCEPTION', FALSE);

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;
616: end;

Line 749: 'FND_LOG_REPOSITORY.POST_EXCEPTION', FALSE);

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:
753: end POST_EXCEPTION;

Line 880: STR_UNCHKED_INT_WITH_CONTEXT(6, 'fnd.plsql.fnd_log_repository', 'Buffered Logging Failed! ' ||

876: when others then
877: AFLOG_BUFFER_MODE_X := 0;
878: G_BUFFER_POS := 1;
879: DELETE_BUFFERED_TABLES;
880: STR_UNCHKED_INT_WITH_CONTEXT(6, 'fnd.plsql.fnd_log_repository', 'Buffered Logging Failed! ' ||
881: 'Please report to Oracle Development. sqlcode=' || sqlcode ||
882: '; sqlerrm=' || sqlerrm);
883: return l_log_seq;
884: end FLUSH;

Line 1342: ** FND_LOG_REPOSITORY.METRIC_INTERNAL

1338: where fla.log_sequence = P_LOG_SEQUENCE for UPDATE;
1339: end GET_BLOB_INTERNAL;
1340:
1341: /*
1342: ** FND_LOG_REPOSITORY.METRIC_INTERNAL
1343: ** Description:
1344: ** Private -- Should only be called by METRIC_INTERNAL_WITH_CONTEXT
1345: ** Writes a metric value out to the FND tables in an autonomous
1346: ** transaction.

Line 1419: FND_LOG_REPOSITORY.G_METRIC_DATE := FND_CONC_DATE.STRING_TO_DATE(DATE_VC);

1415: PROCEDURE METRIC_STRING_TO_DATE(DATE_VC IN VARCHAR2 DEFAULT NULL) is
1416: begin
1417:
1418: if (DATE_VC IS NOT NULL) then
1419: FND_LOG_REPOSITORY.G_METRIC_DATE := FND_CONC_DATE.STRING_TO_DATE(DATE_VC);
1420: if (FND_LOG_REPOSITORY.G_METRIC_DATE IS NULL) then
1421: select SYSDATE
1422: into FND_LOG_REPOSITORY.G_METRIC_DATE
1423: from dual;

Line 1420: if (FND_LOG_REPOSITORY.G_METRIC_DATE IS NULL) then

1416: begin
1417:
1418: if (DATE_VC IS NOT NULL) then
1419: FND_LOG_REPOSITORY.G_METRIC_DATE := FND_CONC_DATE.STRING_TO_DATE(DATE_VC);
1420: if (FND_LOG_REPOSITORY.G_METRIC_DATE IS NULL) then
1421: select SYSDATE
1422: into FND_LOG_REPOSITORY.G_METRIC_DATE
1423: from dual;
1424: end if;

Line 1422: into FND_LOG_REPOSITORY.G_METRIC_DATE

1418: if (DATE_VC IS NOT NULL) then
1419: FND_LOG_REPOSITORY.G_METRIC_DATE := FND_CONC_DATE.STRING_TO_DATE(DATE_VC);
1420: if (FND_LOG_REPOSITORY.G_METRIC_DATE IS NULL) then
1421: select SYSDATE
1422: into FND_LOG_REPOSITORY.G_METRIC_DATE
1423: from dual;
1424: end if;
1425: else
1426: select SYSDATE

Line 1427: into FND_LOG_REPOSITORY.G_METRIC_DATE

1423: from dual;
1424: end if;
1425: else
1426: select SYSDATE
1427: into FND_LOG_REPOSITORY.G_METRIC_DATE
1428: from dual;
1429: end if;
1430:
1431: end METRIC_STRING_TO_DATE;

Line 1497: l_metric_value_date := FND_LOG_REPOSITORY.G_METRIC_DATE;

1493: l_type := 'N';
1494: else
1495: l_type := 'D';
1496: if (METRIC_VALUE_DATE is NULL) then
1497: l_metric_value_date := FND_LOG_REPOSITORY.G_METRIC_DATE;
1498: else
1499: l_metric_value_date := METRIC_VALUE_DATE;
1500: end if;
1501:

Line 1531: ** FND_LOG_REPOSITORY.METRICS_EVENT_INTERNAL

1527:
1528: end METRIC_INTERNAL_WITH_CONTEXT;
1529:
1530: /*
1531: ** FND_LOG_REPOSITORY.METRICS_EVENT_INTERNAL
1532: ** Description:
1533: ** Private -- Should only be called by METRICS_EVENT_INT_WITH_CONTEXT
1534: ** Posts the pending metrics for the current component
1535: ** session to the Business Event system and updates the pending

Line 1585: 'FND_LOG_REPOSITORY.METRIC_EVENT_INTERNAL', FALSE);

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:
1589: end METRICS_EVENT_INTERNAL;

Line 1592: ** FND_LOG_REPOSITORY.METRICS_EVENT_INT_WITH_CONTEXT

1588:
1589: end METRICS_EVENT_INTERNAL;
1590:
1591: /*
1592: ** FND_LOG_REPOSITORY.METRICS_EVENT_INT_WITH_CONTEXT
1593: ** Description:
1594: ** A wrapper API that calls Metrics_Event_Internal using the
1595: ** context values from internal cache of the context values.
1596: ** This routine is only to be called from the AOL implementations of

Line 1619: ** FND_LOG_REPOSITORY.INIT_TRANS_INT_WITH_CONTEXT

1615:
1616:
1617:
1618: /*
1619: ** FND_LOG_REPOSITORY.INIT_TRANS_INT_WITH_CONTEXT
1620: ** Description:
1621: ** A wrapper API that calls Init_Transaction_Internal using the
1622: ** context values from internal cache of the context values.
1623: ** This routine is only to be called from the AOL implementations of

Line 2441: end FND_LOG_REPOSITORY;

2437: * Proxy Alerting related Procedures - End
2438: *===========================================================================*/
2439:
2440:
2441: end FND_LOG_REPOSITORY;