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.

[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on FND_LOG

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

33: --========================================================================
34: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'oks.plsql.import.' || G_PKG_NAME;
35: G_WORKER_REQ_ID CONSTANT NUMBER := FND_GLOBAL.conc_request_id;
36: G_MODULE_HEAD CONSTANT VARCHAR2(60) := G_MODULE_NAME || '(Req Id = '||G_WORKER_REQ_ID||').';
37: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
38: G_UNEXPECTED_LOG CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
39: fnd_log.TEST(fnd_log.level_unexpected, G_MODULE_HEAD);
40: G_ERROR_LOG CONSTANT BOOLEAN := G_UNEXPECTED_LOG AND fnd_log.level_error >= G_LOG_LEVEL;
41: G_EXCEPTION_LOG CONSTANT BOOLEAN := G_ERROR_LOG AND fnd_log.level_exception >= G_LOG_LEVEL;

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

34: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'oks.plsql.import.' || G_PKG_NAME;
35: G_WORKER_REQ_ID CONSTANT NUMBER := FND_GLOBAL.conc_request_id;
36: G_MODULE_HEAD CONSTANT VARCHAR2(60) := G_MODULE_NAME || '(Req Id = '||G_WORKER_REQ_ID||').';
37: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
38: G_UNEXPECTED_LOG CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
39: fnd_log.TEST(fnd_log.level_unexpected, G_MODULE_HEAD);
40: G_ERROR_LOG CONSTANT BOOLEAN := G_UNEXPECTED_LOG AND fnd_log.level_error >= G_LOG_LEVEL;
41: G_EXCEPTION_LOG CONSTANT BOOLEAN := G_ERROR_LOG AND fnd_log.level_exception >= G_LOG_LEVEL;
42: G_EVENT_LOG CONSTANT BOOLEAN := G_EXCEPTION_LOG AND fnd_log.level_event >= G_LOG_LEVEL;

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

35: G_WORKER_REQ_ID CONSTANT NUMBER := FND_GLOBAL.conc_request_id;
36: G_MODULE_HEAD CONSTANT VARCHAR2(60) := G_MODULE_NAME || '(Req Id = '||G_WORKER_REQ_ID||').';
37: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
38: G_UNEXPECTED_LOG CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
39: fnd_log.TEST(fnd_log.level_unexpected, G_MODULE_HEAD);
40: G_ERROR_LOG CONSTANT BOOLEAN := G_UNEXPECTED_LOG AND fnd_log.level_error >= G_LOG_LEVEL;
41: G_EXCEPTION_LOG CONSTANT BOOLEAN := G_ERROR_LOG AND fnd_log.level_exception >= G_LOG_LEVEL;
42: G_EVENT_LOG CONSTANT BOOLEAN := G_EXCEPTION_LOG AND fnd_log.level_event >= G_LOG_LEVEL;
43: G_PROCEDURE_LOG CONSTANT BOOLEAN := G_EVENT_LOG AND fnd_log.level_procedure >= G_LOG_LEVEL;

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

36: G_MODULE_HEAD CONSTANT VARCHAR2(60) := G_MODULE_NAME || '(Req Id = '||G_WORKER_REQ_ID||').';
37: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
38: G_UNEXPECTED_LOG CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
39: fnd_log.TEST(fnd_log.level_unexpected, G_MODULE_HEAD);
40: G_ERROR_LOG CONSTANT BOOLEAN := G_UNEXPECTED_LOG AND fnd_log.level_error >= G_LOG_LEVEL;
41: G_EXCEPTION_LOG CONSTANT BOOLEAN := G_ERROR_LOG AND fnd_log.level_exception >= G_LOG_LEVEL;
42: G_EVENT_LOG CONSTANT BOOLEAN := G_EXCEPTION_LOG AND fnd_log.level_event >= G_LOG_LEVEL;
43: G_PROCEDURE_LOG CONSTANT BOOLEAN := G_EVENT_LOG AND fnd_log.level_procedure >= G_LOG_LEVEL;
44: G_STMT_LOG CONSTANT BOOLEAN := G_PROCEDURE_LOG AND fnd_log.level_statement >= G_LOG_LEVEL;

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

37: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
38: G_UNEXPECTED_LOG CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
39: fnd_log.TEST(fnd_log.level_unexpected, G_MODULE_HEAD);
40: G_ERROR_LOG CONSTANT BOOLEAN := G_UNEXPECTED_LOG AND fnd_log.level_error >= G_LOG_LEVEL;
41: G_EXCEPTION_LOG CONSTANT BOOLEAN := G_ERROR_LOG AND fnd_log.level_exception >= G_LOG_LEVEL;
42: G_EVENT_LOG CONSTANT BOOLEAN := G_EXCEPTION_LOG AND fnd_log.level_event >= G_LOG_LEVEL;
43: G_PROCEDURE_LOG CONSTANT BOOLEAN := G_EVENT_LOG AND fnd_log.level_procedure >= G_LOG_LEVEL;
44: G_STMT_LOG CONSTANT BOOLEAN := G_PROCEDURE_LOG AND fnd_log.level_statement >= G_LOG_LEVEL;
45:

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

38: G_UNEXPECTED_LOG CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
39: fnd_log.TEST(fnd_log.level_unexpected, G_MODULE_HEAD);
40: G_ERROR_LOG CONSTANT BOOLEAN := G_UNEXPECTED_LOG AND fnd_log.level_error >= G_LOG_LEVEL;
41: G_EXCEPTION_LOG CONSTANT BOOLEAN := G_ERROR_LOG AND fnd_log.level_exception >= G_LOG_LEVEL;
42: G_EVENT_LOG CONSTANT BOOLEAN := G_EXCEPTION_LOG AND fnd_log.level_event >= G_LOG_LEVEL;
43: G_PROCEDURE_LOG CONSTANT BOOLEAN := G_EVENT_LOG AND fnd_log.level_procedure >= G_LOG_LEVEL;
44: G_STMT_LOG CONSTANT BOOLEAN := G_PROCEDURE_LOG AND fnd_log.level_statement >= G_LOG_LEVEL;
45:
46: --=========================

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

39: fnd_log.TEST(fnd_log.level_unexpected, G_MODULE_HEAD);
40: G_ERROR_LOG CONSTANT BOOLEAN := G_UNEXPECTED_LOG AND fnd_log.level_error >= G_LOG_LEVEL;
41: G_EXCEPTION_LOG CONSTANT BOOLEAN := G_ERROR_LOG AND fnd_log.level_exception >= G_LOG_LEVEL;
42: G_EVENT_LOG CONSTANT BOOLEAN := G_EXCEPTION_LOG AND fnd_log.level_event >= G_LOG_LEVEL;
43: G_PROCEDURE_LOG CONSTANT BOOLEAN := G_EVENT_LOG AND fnd_log.level_procedure >= G_LOG_LEVEL;
44: G_STMT_LOG CONSTANT BOOLEAN := G_PROCEDURE_LOG AND fnd_log.level_statement >= G_LOG_LEVEL;
45:
46: --=========================
47: -- PROCEDURES AND FUNCTIONS

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

40: G_ERROR_LOG CONSTANT BOOLEAN := G_UNEXPECTED_LOG AND fnd_log.level_error >= G_LOG_LEVEL;
41: G_EXCEPTION_LOG CONSTANT BOOLEAN := G_ERROR_LOG AND fnd_log.level_exception >= G_LOG_LEVEL;
42: G_EVENT_LOG CONSTANT BOOLEAN := G_EXCEPTION_LOG AND fnd_log.level_event >= G_LOG_LEVEL;
43: G_PROCEDURE_LOG CONSTANT BOOLEAN := G_EVENT_LOG AND fnd_log.level_procedure >= G_LOG_LEVEL;
44: G_STMT_LOG CONSTANT BOOLEAN := G_PROCEDURE_LOG AND fnd_log.level_statement >= G_LOG_LEVEL;
45:
46: --=========================
47: -- PROCEDURES AND FUNCTIONS
48: --=========================

Line 70: fnd_log.string(fnd_log.level_procedure,

66: l_qp_mc VARCHAR2(1);
67:
68: BEGIN
69: IF G_PROCEDURE_LOG THEN
70: fnd_log.string(fnd_log.level_procedure,
71: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
72: 'Entering with '||
73: 'P_batch_id = '|| P_batch_id ||','||
74: 'P_rowid_from = '|| P_rowid_from ||','||

Line 1022: fnd_log.string(fnd_log.level_statement,

1018: AND (INTERFACE_STATUS IS NULL OR INTERFACE_STATUS = 'R');
1019:
1020: SELECT count(1) INTO l_stg_count FROM OKS_INT_HEADER_STG_TEMP;
1021:
1022: fnd_log.string(fnd_log.level_statement,
1023: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
1024: 'Number of records in interface table being processed = ' || l_int_count ||', '||
1025: 'Number of records inserted into staging table = '|| l_stg_count);
1026: END IF;

Line 2243: fnd_log.string(fnd_log.level_procedure,

2239: AND HOI.ORG_INFORMATION_CONTEXT (+) = 'CLASS'
2240: AND HOI.ORG_INFORMATION1 (+) = 'INV';
2241:
2242: /*IF G_PROCEDURE_LOG THEN
2243: fnd_log.string(fnd_log.level_procedure,
2244: G_MODULE_HEAD || l_routine || '.' || l_stmt_num,
2245: 'Exit.');
2246: END IF; */
2247: EXCEPTION

Line 2275: fnd_log.string(fnd_log.level_procedure,

2271: l_qp_mc VARCHAR2(1); --skuchima 11880769
2272:
2273: BEGIN
2274: IF G_PROCEDURE_LOG THEN
2275: fnd_log.string(fnd_log.level_procedure,
2276: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2277: 'Begin');
2278: END IF;
2279:

Line 2916: fnd_log.string(fnd_log.level_statement,

2912:
2913: SELECT count(1) INTO l_stg_count FROM OKS_INT_LINE_STG_TEMP;
2914: /* to avoid gscc failure */
2915: IF G_STMT_LOG THEN
2916: fnd_log.string(fnd_log.level_statement,
2917: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2918: 'Number of records in interface table being processed = ' || l_int_count ||', '||
2919: 'Number of records inserted into staging table = '|| l_stg_count);
2920: END IF;

Line 3757: fnd_log.string(fnd_log.level_procedure,

3753: AND LST.USAGE_TERMINATION_METHOD = UTM.LOOKUP_CODE (+)
3754: AND UTM.LOOKUP_TYPE (+) = 'OKS_TRM_MTHD';
3755:
3756: /* IF G_PROCEDURE_LOG THEN
3757: fnd_log.string(fnd_log.level_procedure,
3758: G_MODULE_HEAD || l_routine || '.' || l_stmt_num,
3759: 'Exit.');
3760: END IF; */
3761:

Line 3787: fnd_log.string(fnd_log.level_procedure,

3783: l_int_count NUMBER := 0;
3784: l_stg_count NUMBER := 0;
3785: BEGIN
3786: IF G_PROCEDURE_LOG THEN
3787: fnd_log.string(fnd_log.level_procedure,
3788: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
3789: 'Begin');
3790: END IF;
3791:

Line 4728: fnd_log.string(fnd_log.level_statement,

4724:
4725: SELECT count(1) INTO l_stg_count FROM OKS_INT_COVERED_LEVEL_STG_TEMP;
4726: /* to avoid gscc failure */
4727: IF G_STMT_LOG THEN
4728: fnd_log.string(fnd_log.level_statement,
4729: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
4730: 'Number of records in interface table being processed = ' || l_int_count ||', '||
4731: 'Number of records inserted into staging table = '|| l_stg_count);
4732: END IF;

Line 4735: fnd_log.string(fnd_log.level_procedure,

4731: 'Number of records inserted into staging table = '|| l_stg_count);
4732: END IF;
4733: END IF;
4734: IF G_PROCEDURE_LOG THEN
4735: fnd_log.string(fnd_log.level_procedure,
4736: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
4737: 'Exit.');
4738: END IF;
4739: EXCEPTION

Line 4765: fnd_log.string(fnd_log.level_procedure,

4761: l_int_count NUMBER := 0;
4762: l_stg_count NUMBER := 0;
4763: BEGIN
4764: IF G_PROCEDURE_LOG THEN
4765: fnd_log.string(fnd_log.level_procedure,
4766: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
4767: 'Begin');
4768: END IF;
4769:

Line 5273: fnd_log.string(fnd_log.level_statement,

5269:
5270: SELECT count(1) INTO l_stg_count FROM OKS_INT_USAGE_COUNTER_STG_TEMP;
5271: /* to avoid gscc failure */
5272: IF G_STMT_LOG THEN
5273: fnd_log.string(fnd_log.level_statement,
5274: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5275: 'Number of records in interface table being processed = ' || l_int_count ||', '||
5276: 'Number of records inserted into staging table = '|| l_stg_count);
5277: END IF;

Line 5281: fnd_log.string(fnd_log.level_procedure,

5277: END IF;
5278: END IF;
5279:
5280: IF G_PROCEDURE_LOG THEN
5281: fnd_log.string(fnd_log.level_procedure,
5282: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5283: 'Exit.');
5284: END IF;
5285: EXCEPTION

Line 5310: fnd_log.string(fnd_log.level_procedure,

5306: l_int_count NUMBER := 0;
5307: l_stg_count NUMBER := 0;
5308: BEGIN
5309: IF G_PROCEDURE_LOG THEN
5310: fnd_log.string(fnd_log.level_procedure,
5311: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5312: 'Begin');
5313: END IF;
5314:

Line 5502: fnd_log.string(fnd_log.level_statement,

5498: WHERE HEADER_INTERFACE_ID = OSCI.HEADER_INTERFACE_ID);
5499:
5500: SELECT count(1) INTO l_stg_count FROM OKS_INT_SALES_CREDIT_STG_TEMP;
5501:
5502: fnd_log.string(fnd_log.level_statement,
5503: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5504: 'Number of records in interface table being processed = ' || l_int_count ||', '||
5505: 'Number of records inserted into staging table = '|| l_stg_count);
5506: END IF;

Line 5509: fnd_log.string(fnd_log.level_procedure,

5505: 'Number of records inserted into staging table = '|| l_stg_count);
5506: END IF;
5507:
5508: IF G_PROCEDURE_LOG THEN
5509: fnd_log.string(fnd_log.level_procedure,
5510: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5511: 'Exit.');
5512: END IF;
5513: EXCEPTION

Line 5539: fnd_log.string(fnd_log.level_procedure,

5535: l_header_notes_count NUMBER := 0;
5536: l_line_notes_count NUMBER := 0;
5537: BEGIN
5538: IF G_PROCEDURE_LOG THEN
5539: fnd_log.string(fnd_log.level_procedure,
5540: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5541: 'Begin');
5542: END IF;
5543:

Line 5781: fnd_log.string(fnd_log.level_statement,

5777: WHERE EXISTS (SELECT 'X' FROM OKS_INT_HEADER_STG_TEMP
5778: WHERE HEADER_INTERFACE_ID = ONI.HEADER_INTERFACE_ID)
5779: AND ONI.LINE_INTERFACE_ID IS NULL;
5780:
5781: fnd_log.string(fnd_log.level_statement,
5782: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5783: 'Number of header notes = ' || l_header_notes_count ||', '||
5784: 'Number of line notes = '|| l_line_notes_count);
5785: END IF;

Line 5788: fnd_log.string(fnd_log.level_procedure,

5784: 'Number of line notes = '|| l_line_notes_count);
5785: END IF;
5786:
5787: IF G_PROCEDURE_LOG THEN
5788: fnd_log.string(fnd_log.level_procedure,
5789: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5790: 'Exit.');
5791: END IF;
5792: EXCEPTION

Line 5820: fnd_log.string(fnd_log.level_procedure,

5816: l_stmt_num NUMBER := 0;
5817: l_routine CONSTANT VARCHAR2(30) := 'Validate_Contracts';
5818: BEGIN
5819: IF G_PROCEDURE_LOG THEN
5820: fnd_log.string(fnd_log.level_procedure,
5821: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5822: 'Entering with '||
5823: 'P_batch_id = '|| P_batch_id ||','||
5824: 'P_rowid_from = '|| P_rowid_from ||','||

Line 5851: fnd_log.string(fnd_log.level_procedure,

5847: Validate_Sales_Credits;
5848: Validate_notes;
5849:
5850: IF G_PROCEDURE_LOG THEN
5851: fnd_log.string(fnd_log.level_procedure,
5852: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5853: 'Exit.');
5854: END IF;
5855: EXCEPTION