eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_IMPORT_CONTRACTS_WORKER dependencies on FND_LOG

Line 28: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;

24: --========================================================================
25: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'oks.plsql.import.' || G_PKG_NAME;
26: G_WORKER_REQ_ID CONSTANT NUMBER := FND_GLOBAL.conc_request_id;
27: G_MODULE_HEAD CONSTANT VARCHAR2(200) := G_MODULE_NAME || '(Req Id = '||G_WORKER_REQ_ID||').';
28: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
29: G_UNEXPECTED_LOG CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
30: fnd_log.TEST(fnd_log.level_unexpected, G_MODULE_HEAD);
31: G_ERROR_LOG CONSTANT BOOLEAN := G_UNEXPECTED_LOG AND fnd_log.level_error >= G_LOG_LEVEL;
32: G_EXCEPTION_LOG CONSTANT BOOLEAN := G_ERROR_LOG AND fnd_log.level_exception >= G_LOG_LEVEL;

Line 29: G_UNEXPECTED_LOG CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND

25: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'oks.plsql.import.' || G_PKG_NAME;
26: G_WORKER_REQ_ID CONSTANT NUMBER := FND_GLOBAL.conc_request_id;
27: G_MODULE_HEAD CONSTANT VARCHAR2(200) := G_MODULE_NAME || '(Req Id = '||G_WORKER_REQ_ID||').';
28: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
29: G_UNEXPECTED_LOG CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
30: fnd_log.TEST(fnd_log.level_unexpected, G_MODULE_HEAD);
31: G_ERROR_LOG CONSTANT BOOLEAN := G_UNEXPECTED_LOG AND fnd_log.level_error >= G_LOG_LEVEL;
32: G_EXCEPTION_LOG CONSTANT BOOLEAN := G_ERROR_LOG AND fnd_log.level_exception >= G_LOG_LEVEL;
33: G_EVENT_LOG CONSTANT BOOLEAN := G_EXCEPTION_LOG AND fnd_log.level_event >= G_LOG_LEVEL;

Line 30: fnd_log.TEST(fnd_log.level_unexpected, G_MODULE_HEAD);

26: G_WORKER_REQ_ID CONSTANT NUMBER := FND_GLOBAL.conc_request_id;
27: G_MODULE_HEAD CONSTANT VARCHAR2(200) := G_MODULE_NAME || '(Req Id = '||G_WORKER_REQ_ID||').';
28: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
29: G_UNEXPECTED_LOG CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
30: fnd_log.TEST(fnd_log.level_unexpected, G_MODULE_HEAD);
31: G_ERROR_LOG CONSTANT BOOLEAN := G_UNEXPECTED_LOG AND fnd_log.level_error >= G_LOG_LEVEL;
32: G_EXCEPTION_LOG CONSTANT BOOLEAN := G_ERROR_LOG AND fnd_log.level_exception >= G_LOG_LEVEL;
33: G_EVENT_LOG CONSTANT BOOLEAN := G_EXCEPTION_LOG AND fnd_log.level_event >= G_LOG_LEVEL;
34: G_PROCEDURE_LOG CONSTANT BOOLEAN := G_EVENT_LOG AND fnd_log.level_procedure >= G_LOG_LEVEL;

Line 31: G_ERROR_LOG CONSTANT BOOLEAN := G_UNEXPECTED_LOG AND fnd_log.level_error >= G_LOG_LEVEL;

27: G_MODULE_HEAD CONSTANT VARCHAR2(200) := G_MODULE_NAME || '(Req Id = '||G_WORKER_REQ_ID||').';
28: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
29: G_UNEXPECTED_LOG CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
30: fnd_log.TEST(fnd_log.level_unexpected, G_MODULE_HEAD);
31: G_ERROR_LOG CONSTANT BOOLEAN := G_UNEXPECTED_LOG AND fnd_log.level_error >= G_LOG_LEVEL;
32: G_EXCEPTION_LOG CONSTANT BOOLEAN := G_ERROR_LOG AND fnd_log.level_exception >= G_LOG_LEVEL;
33: G_EVENT_LOG CONSTANT BOOLEAN := G_EXCEPTION_LOG AND fnd_log.level_event >= G_LOG_LEVEL;
34: G_PROCEDURE_LOG CONSTANT BOOLEAN := G_EVENT_LOG AND fnd_log.level_procedure >= G_LOG_LEVEL;
35: G_STMT_LOG CONSTANT BOOLEAN := G_PROCEDURE_LOG AND fnd_log.level_statement >= G_LOG_LEVEL;

Line 32: G_EXCEPTION_LOG CONSTANT BOOLEAN := G_ERROR_LOG AND fnd_log.level_exception >= G_LOG_LEVEL;

28: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
29: G_UNEXPECTED_LOG CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
30: fnd_log.TEST(fnd_log.level_unexpected, G_MODULE_HEAD);
31: G_ERROR_LOG CONSTANT BOOLEAN := G_UNEXPECTED_LOG AND fnd_log.level_error >= G_LOG_LEVEL;
32: G_EXCEPTION_LOG CONSTANT BOOLEAN := G_ERROR_LOG AND fnd_log.level_exception >= G_LOG_LEVEL;
33: G_EVENT_LOG CONSTANT BOOLEAN := G_EXCEPTION_LOG AND fnd_log.level_event >= G_LOG_LEVEL;
34: G_PROCEDURE_LOG CONSTANT BOOLEAN := G_EVENT_LOG AND fnd_log.level_procedure >= G_LOG_LEVEL;
35: G_STMT_LOG CONSTANT BOOLEAN := G_PROCEDURE_LOG AND fnd_log.level_statement >= G_LOG_LEVEL;
36:

Line 33: G_EVENT_LOG CONSTANT BOOLEAN := G_EXCEPTION_LOG AND fnd_log.level_event >= G_LOG_LEVEL;

29: G_UNEXPECTED_LOG CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
30: fnd_log.TEST(fnd_log.level_unexpected, G_MODULE_HEAD);
31: G_ERROR_LOG CONSTANT BOOLEAN := G_UNEXPECTED_LOG AND fnd_log.level_error >= G_LOG_LEVEL;
32: G_EXCEPTION_LOG CONSTANT BOOLEAN := G_ERROR_LOG AND fnd_log.level_exception >= G_LOG_LEVEL;
33: G_EVENT_LOG CONSTANT BOOLEAN := G_EXCEPTION_LOG AND fnd_log.level_event >= G_LOG_LEVEL;
34: G_PROCEDURE_LOG CONSTANT BOOLEAN := G_EVENT_LOG AND fnd_log.level_procedure >= G_LOG_LEVEL;
35: G_STMT_LOG CONSTANT BOOLEAN := G_PROCEDURE_LOG AND fnd_log.level_statement >= G_LOG_LEVEL;
36:
37: --=========================

Line 34: G_PROCEDURE_LOG CONSTANT BOOLEAN := G_EVENT_LOG AND fnd_log.level_procedure >= G_LOG_LEVEL;

30: fnd_log.TEST(fnd_log.level_unexpected, G_MODULE_HEAD);
31: G_ERROR_LOG CONSTANT BOOLEAN := G_UNEXPECTED_LOG AND fnd_log.level_error >= G_LOG_LEVEL;
32: G_EXCEPTION_LOG CONSTANT BOOLEAN := G_ERROR_LOG AND fnd_log.level_exception >= G_LOG_LEVEL;
33: G_EVENT_LOG CONSTANT BOOLEAN := G_EXCEPTION_LOG AND fnd_log.level_event >= G_LOG_LEVEL;
34: G_PROCEDURE_LOG CONSTANT BOOLEAN := G_EVENT_LOG AND fnd_log.level_procedure >= G_LOG_LEVEL;
35: G_STMT_LOG CONSTANT BOOLEAN := G_PROCEDURE_LOG AND fnd_log.level_statement >= G_LOG_LEVEL;
36:
37: --=========================
38: -- PROCEDURES AND FUNCTIONS

Line 35: G_STMT_LOG CONSTANT BOOLEAN := G_PROCEDURE_LOG AND fnd_log.level_statement >= G_LOG_LEVEL;

31: G_ERROR_LOG CONSTANT BOOLEAN := G_UNEXPECTED_LOG AND fnd_log.level_error >= G_LOG_LEVEL;
32: G_EXCEPTION_LOG CONSTANT BOOLEAN := G_ERROR_LOG AND fnd_log.level_exception >= G_LOG_LEVEL;
33: G_EVENT_LOG CONSTANT BOOLEAN := G_EXCEPTION_LOG AND fnd_log.level_event >= G_LOG_LEVEL;
34: G_PROCEDURE_LOG CONSTANT BOOLEAN := G_EVENT_LOG AND fnd_log.level_procedure >= G_LOG_LEVEL;
35: G_STMT_LOG CONSTANT BOOLEAN := G_PROCEDURE_LOG AND fnd_log.level_statement >= G_LOG_LEVEL;
36:
37: --=========================
38: -- PROCEDURES AND FUNCTIONS
39: --=========================

Line 54: fnd_log.string(fnd_log.level_procedure,

50: l_routine CONSTANT VARCHAR2(30) := 'PreInsert_Rollup_errors';
51: BEGIN
52:
53: IF G_PROCEDURE_LOG THEN
54: fnd_log.string(fnd_log.level_procedure,
55: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
56: 'Entering.');
57: END IF;
58:

Line 69: fnd_log.string(fnd_log.level_procedure,

65: ELSE 'S'
66: END);
67:
68: IF G_PROCEDURE_LOG THEN
69: fnd_log.string(fnd_log.level_procedure,
70: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
71: 'Exit.');
72: END IF;
73: EXCEPTION

Line 106: fnd_log.string(fnd_log.level_procedure,

102: l_routine CONSTANT VARCHAR2(30) := 'Rollup_errors';
103: BEGIN
104:
105: IF G_PROCEDURE_LOG THEN
106: fnd_log.string(fnd_log.level_procedure,
107: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
108: 'Entering with ' ||
109: 'P_mode = ' || P_mode ||','||
110: 'P_parent_request_id = ' || P_parent_request_id ||','||

Line 150: fnd_log.string(fnd_log.level_procedure,

146:
147: X_rows_processed := SQL%ROWCOUNT;
148:
149: IF G_PROCEDURE_LOG THEN
150: fnd_log.string(fnd_log.level_procedure,
151: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
152: 'Exit with ' ||
153: 'X_rows_processed = '|| X_rows_processed);
154: END IF;

Line 183: fnd_log.string(fnd_log.level_procedure,

179:
180: BEGIN
181:
182: IF G_PROCEDURE_LOG THEN
183: fnd_log.string(fnd_log.level_procedure,
184: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
185: 'Entering with ' ||
186: 'P_mode = ' || P_mode ||','||
187: 'P_parent_request_id = ' || P_parent_request_id ||','||

Line 308: fnd_log.string(fnd_log.level_procedure,

304: count(distinct INTERFACE_ID) over (partition by INTERFACE_SOURCE_TABLE) INVALID_COUNT
305: FROM OKS_INT_ERROR_STG_TEMP) INVALID_Q;
306:
307: IF G_PROCEDURE_LOG THEN
308: fnd_log.string(fnd_log.level_procedure,
309: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
310: 'Exit.');
311: END IF;
312: EXCEPTION

Line 336: fnd_log.string(fnd_log.level_procedure,

332: l_routine CONSTANT VARCHAR2(30) := 'Truncate_stg_tables';
333: BEGIN
334:
335: IF G_PROCEDURE_LOG THEN
336: fnd_log.string(fnd_log.level_procedure,
337: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
338: 'Entering.');
339: END IF;
340:

Line 358: fnd_log.string(fnd_log.level_procedure,

354: DELETE FROM OKS_INT_ERROR_STG_TEMP;
355: DELETE FROM OKS_INT_SALES_CREDIT_STG_TEMP;
356:
357: IF G_PROCEDURE_LOG THEN
358: fnd_log.string(fnd_log.level_procedure,
359: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
360: 'Exit.');
361: END IF;
362:

Line 416: fnd_log.string(fnd_log.level_procedure,

412: --
413: -- Worker processing for OKS_HEADERS_INTERFACE table
414: --
415: IF G_PROCEDURE_LOG THEN
416: fnd_log.string(fnd_log.level_procedure,
417: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
418: 'Entering with ' ||
419: 'P_mode = ' || P_mode ||','||
420: 'P_parent_request_id = ' || P_parent_request_id ||','||

Line 441: fnd_log.string(fnd_log.level_error,

437: l_table_owner);
438:
439: if ((l_retstatus = FALSE) OR (l_table_owner is null)) then
440: IF G_ERROR_LOG THEN
441: fnd_log.string(fnd_log.level_error,
442: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
443: 'Cannot get schema name for product : '||l_product);
444: END IF;
445: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);

Line 449: fnd_log.string(fnd_log.level_statement,

445: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
446: end if;
447:
448: IF G_STMT_LOG THEN
449: fnd_log.string(fnd_log.level_statement,
450: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
451: 'Table Owner ' || l_table_owner);
452: END IF;
453:

Line 535: fnd_log.string(fnd_log.level_procedure,

531: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
532: X_errbuf := ' ';
533:
534: IF G_PROCEDURE_LOG THEN
535: fnd_log.string(fnd_log.level_procedure,
536: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
537: 'Exit with ' ||
538: 'X_errbuf = ' || X_errbuf ||','||
539: 'X_retcode = ' || X_retcode);

Line 553: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, G_MODULE_HEAD || l_routine , l_msg_data);

549: X_retcode := '2';
550: X_errbuf := l_msg_data;
551:
552: IF G_EXCEPTION_LOG THEN
553: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, G_MODULE_HEAD || l_routine , l_msg_data);
554: END IF;
555:
556: WHEN OTHERS THEN
557: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');

Line 569: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

565: ,p_data => l_msg_data
566: );
567:
568: IF G_EXCEPTION_LOG THEN
569: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
570: , G_MODULE_HEAD || l_routine ||'.others_exc'
571: , 'others: ' || X_errbuf || ' ' || substr(l_msg_data, 1,250)
572: );
573: END IF;