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.12010000.3 2010/03/17 18:18:29 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 634: 'FND_LOG_REPOSITORY.POST_EXCEPTION', FALSE);

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

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

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

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

898: when others then
899: AFLOG_BUFFER_MODE_X := 0;
900: G_BUFFER_POS := 1;
901: DELETE_BUFFERED_TABLES;
902: STR_UNCHKED_INT_WITH_CONTEXT(6, 'fnd.plsql.fnd_log_repository', 'Buffered Logging Failed! ' ||
903: 'Please report to Oracle Development. sqlcode=' || sqlcode ||
904: '; sqlerrm=' || sqlerrm);
905: return l_log_seq;
906: end FLUSH;

Line 1364: ** FND_LOG_REPOSITORY.METRIC_INTERNAL

1360: where fla.log_sequence = P_LOG_SEQUENCE for UPDATE;
1361: end GET_BLOB_INTERNAL;
1362:
1363: /*
1364: ** FND_LOG_REPOSITORY.METRIC_INTERNAL
1365: ** Description:
1366: ** Private -- Should only be called by METRIC_INTERNAL_WITH_CONTEXT
1367: ** Writes a metric value out to the FND tables in an autonomous
1368: ** transaction.

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

1437: PROCEDURE METRIC_STRING_TO_DATE(DATE_VC IN VARCHAR2 DEFAULT NULL) is
1438: begin
1439:
1440: if (DATE_VC IS NOT NULL) then
1441: FND_LOG_REPOSITORY.G_METRIC_DATE := FND_CONC_DATE.STRING_TO_DATE(DATE_VC);
1442: if (FND_LOG_REPOSITORY.G_METRIC_DATE IS NULL) then
1443: select SYSDATE
1444: into FND_LOG_REPOSITORY.G_METRIC_DATE
1445: from dual;

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

1438: begin
1439:
1440: if (DATE_VC IS NOT NULL) then
1441: FND_LOG_REPOSITORY.G_METRIC_DATE := FND_CONC_DATE.STRING_TO_DATE(DATE_VC);
1442: if (FND_LOG_REPOSITORY.G_METRIC_DATE IS NULL) then
1443: select SYSDATE
1444: into FND_LOG_REPOSITORY.G_METRIC_DATE
1445: from dual;
1446: end if;

Line 1444: into FND_LOG_REPOSITORY.G_METRIC_DATE

1440: if (DATE_VC IS NOT NULL) then
1441: FND_LOG_REPOSITORY.G_METRIC_DATE := FND_CONC_DATE.STRING_TO_DATE(DATE_VC);
1442: if (FND_LOG_REPOSITORY.G_METRIC_DATE IS NULL) then
1443: select SYSDATE
1444: into FND_LOG_REPOSITORY.G_METRIC_DATE
1445: from dual;
1446: end if;
1447: else
1448: select SYSDATE

Line 1449: into FND_LOG_REPOSITORY.G_METRIC_DATE

1445: from dual;
1446: end if;
1447: else
1448: select SYSDATE
1449: into FND_LOG_REPOSITORY.G_METRIC_DATE
1450: from dual;
1451: end if;
1452:
1453: end METRIC_STRING_TO_DATE;

Line 1519: l_metric_value_date := FND_LOG_REPOSITORY.G_METRIC_DATE;

1515: l_type := 'N';
1516: else
1517: l_type := 'D';
1518: if (METRIC_VALUE_DATE is NULL) then
1519: l_metric_value_date := FND_LOG_REPOSITORY.G_METRIC_DATE;
1520: else
1521: l_metric_value_date := METRIC_VALUE_DATE;
1522: end if;
1523:

Line 1553: ** FND_LOG_REPOSITORY.METRICS_EVENT_INTERNAL

1549:
1550: end METRIC_INTERNAL_WITH_CONTEXT;
1551:
1552: /*
1553: ** FND_LOG_REPOSITORY.METRICS_EVENT_INTERNAL
1554: ** Description:
1555: ** Private -- Should only be called by METRICS_EVENT_INT_WITH_CONTEXT
1556: ** Posts the pending metrics for the current component
1557: ** session to the Business Event system and updates the pending

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

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

Line 1614: ** FND_LOG_REPOSITORY.METRICS_EVENT_INT_WITH_CONTEXT

1610:
1611: end METRICS_EVENT_INTERNAL;
1612:
1613: /*
1614: ** FND_LOG_REPOSITORY.METRICS_EVENT_INT_WITH_CONTEXT
1615: ** Description:
1616: ** A wrapper API that calls Metrics_Event_Internal using the
1617: ** context values from internal cache of the context values.
1618: ** This routine is only to be called from the AOL implementations of

Line 1641: ** FND_LOG_REPOSITORY.INIT_TRANS_INT_WITH_CONTEXT

1637:
1638:
1639:
1640: /*
1641: ** FND_LOG_REPOSITORY.INIT_TRANS_INT_WITH_CONTEXT
1642: ** Description:
1643: ** A wrapper API that calls Init_Transaction_Internal using the
1644: ** context values from internal cache of the context values.
1645: ** This routine is only to be called from the AOL implementations of

Line 2559: end FND_LOG_REPOSITORY;

2555: end;
2556:
2557:
2558:
2559: end FND_LOG_REPOSITORY;