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_VALIDATE 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(60) := 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(60) := 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(60) := 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(60) := 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 59: fnd_log.string(fnd_log.level_procedure,

55: l_int_count NUMBER := 0;
56: l_stg_count NUMBER := 0;
57: BEGIN
58: IF G_PROCEDURE_LOG THEN
59: fnd_log.string(fnd_log.level_procedure,
60: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
61: 'Entering with '||
62: 'P_batch_id = '|| P_batch_id ||','||
63: 'P_rowid_from = '|| P_rowid_from ||','||

Line 992: fnd_log.string(fnd_log.level_statement,

988: AND (INTERFACE_STATUS IS NULL OR INTERFACE_STATUS = 'R');
989:
990: SELECT count(1) INTO l_stg_count FROM OKS_INT_HEADER_STG_TEMP;
991:
992: fnd_log.string(fnd_log.level_statement,
993: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
994: 'Number of records in interface table being processed = ' || l_int_count ||', '||
995: 'Number of records inserted into staging table = '|| l_stg_count);
996: END IF;

Line 2213: fnd_log.string(fnd_log.level_procedure,

2209: AND HOI.ORG_INFORMATION_CONTEXT (+) = 'CLASS'
2210: AND HOI.ORG_INFORMATION1 (+) = 'INV';
2211:
2212: /*IF G_PROCEDURE_LOG THEN
2213: fnd_log.string(fnd_log.level_procedure,
2214: G_MODULE_HEAD || l_routine || '.' || l_stmt_num,
2215: 'Exit.');
2216: END IF; */
2217: EXCEPTION

Line 2243: fnd_log.string(fnd_log.level_procedure,

2239: l_int_count NUMBER := 0;
2240: l_stg_count NUMBER := 0;
2241: BEGIN
2242: IF G_PROCEDURE_LOG THEN
2243: fnd_log.string(fnd_log.level_procedure,
2244: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2245: 'Begin');
2246: END IF;
2247:

Line 2864: fnd_log.string(fnd_log.level_statement,

2860:
2861: SELECT count(1) INTO l_stg_count FROM OKS_INT_LINE_STG_TEMP;
2862: /* to avoid gscc failure */
2863: IF G_STMT_LOG THEN
2864: fnd_log.string(fnd_log.level_statement,
2865: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2866: 'Number of records in interface table being processed = ' || l_int_count ||', '||
2867: 'Number of records inserted into staging table = '|| l_stg_count);
2868: END IF;

Line 3705: fnd_log.string(fnd_log.level_procedure,

3701: AND LST.USAGE_TERMINATION_METHOD = UTM.LOOKUP_CODE (+)
3702: AND UTM.LOOKUP_TYPE (+) = 'OKS_TRM_MTHD';
3703:
3704: /* IF G_PROCEDURE_LOG THEN
3705: fnd_log.string(fnd_log.level_procedure,
3706: G_MODULE_HEAD || l_routine || '.' || l_stmt_num,
3707: 'Exit.');
3708: END IF; */
3709:

Line 3735: fnd_log.string(fnd_log.level_procedure,

3731: l_int_count NUMBER := 0;
3732: l_stg_count NUMBER := 0;
3733: BEGIN
3734: IF G_PROCEDURE_LOG THEN
3735: fnd_log.string(fnd_log.level_procedure,
3736: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
3737: 'Begin');
3738: END IF;
3739:

Line 4602: fnd_log.string(fnd_log.level_statement,

4598:
4599: SELECT count(1) INTO l_stg_count FROM OKS_INT_COVERED_LEVEL_STG_TEMP;
4600: /* to avoid gscc failure */
4601: IF G_STMT_LOG THEN
4602: fnd_log.string(fnd_log.level_statement,
4603: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
4604: 'Number of records in interface table being processed = ' || l_int_count ||', '||
4605: 'Number of records inserted into staging table = '|| l_stg_count);
4606: END IF;

Line 4609: fnd_log.string(fnd_log.level_procedure,

4605: 'Number of records inserted into staging table = '|| l_stg_count);
4606: END IF;
4607: END IF;
4608: IF G_PROCEDURE_LOG THEN
4609: fnd_log.string(fnd_log.level_procedure,
4610: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
4611: 'Exit.');
4612: END IF;
4613: EXCEPTION

Line 4639: fnd_log.string(fnd_log.level_procedure,

4635: l_int_count NUMBER := 0;
4636: l_stg_count NUMBER := 0;
4637: BEGIN
4638: IF G_PROCEDURE_LOG THEN
4639: fnd_log.string(fnd_log.level_procedure,
4640: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
4641: 'Begin');
4642: END IF;
4643:

Line 5147: fnd_log.string(fnd_log.level_statement,

5143:
5144: SELECT count(1) INTO l_stg_count FROM OKS_INT_USAGE_COUNTER_STG_TEMP;
5145: /* to avoid gscc failure */
5146: IF G_STMT_LOG THEN
5147: fnd_log.string(fnd_log.level_statement,
5148: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5149: 'Number of records in interface table being processed = ' || l_int_count ||', '||
5150: 'Number of records inserted into staging table = '|| l_stg_count);
5151: END IF;

Line 5155: fnd_log.string(fnd_log.level_procedure,

5151: END IF;
5152: END IF;
5153:
5154: IF G_PROCEDURE_LOG THEN
5155: fnd_log.string(fnd_log.level_procedure,
5156: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5157: 'Exit.');
5158: END IF;
5159: EXCEPTION

Line 5184: fnd_log.string(fnd_log.level_procedure,

5180: l_int_count NUMBER := 0;
5181: l_stg_count NUMBER := 0;
5182: BEGIN
5183: IF G_PROCEDURE_LOG THEN
5184: fnd_log.string(fnd_log.level_procedure,
5185: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5186: 'Begin');
5187: END IF;
5188:

Line 5358: fnd_log.string(fnd_log.level_statement,

5354: WHERE HEADER_INTERFACE_ID = OSCI.HEADER_INTERFACE_ID);
5355:
5356: SELECT count(1) INTO l_stg_count FROM OKS_INT_SALES_CREDIT_STG_TEMP;
5357:
5358: fnd_log.string(fnd_log.level_statement,
5359: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5360: 'Number of records in interface table being processed = ' || l_int_count ||', '||
5361: 'Number of records inserted into staging table = '|| l_stg_count);
5362: END IF;

Line 5365: fnd_log.string(fnd_log.level_procedure,

5361: 'Number of records inserted into staging table = '|| l_stg_count);
5362: END IF;
5363:
5364: IF G_PROCEDURE_LOG THEN
5365: fnd_log.string(fnd_log.level_procedure,
5366: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5367: 'Exit.');
5368: END IF;
5369: EXCEPTION

Line 5395: fnd_log.string(fnd_log.level_procedure,

5391: l_header_notes_count NUMBER := 0;
5392: l_line_notes_count NUMBER := 0;
5393: BEGIN
5394: IF G_PROCEDURE_LOG THEN
5395: fnd_log.string(fnd_log.level_procedure,
5396: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5397: 'Begin');
5398: END IF;
5399:

Line 5637: fnd_log.string(fnd_log.level_statement,

5633: WHERE EXISTS (SELECT 'X' FROM OKS_INT_HEADER_STG_TEMP
5634: WHERE HEADER_INTERFACE_ID = ONI.HEADER_INTERFACE_ID)
5635: AND ONI.LINE_INTERFACE_ID IS NULL;
5636:
5637: fnd_log.string(fnd_log.level_statement,
5638: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5639: 'Number of header notes = ' || l_header_notes_count ||', '||
5640: 'Number of line notes = '|| l_line_notes_count);
5641: END IF;

Line 5644: fnd_log.string(fnd_log.level_procedure,

5640: 'Number of line notes = '|| l_line_notes_count);
5641: END IF;
5642:
5643: IF G_PROCEDURE_LOG THEN
5644: fnd_log.string(fnd_log.level_procedure,
5645: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5646: 'Exit.');
5647: END IF;
5648: EXCEPTION

Line 5676: fnd_log.string(fnd_log.level_procedure,

5672: l_stmt_num NUMBER := 0;
5673: l_routine CONSTANT VARCHAR2(30) := 'Validate_Contracts';
5674: BEGIN
5675: IF G_PROCEDURE_LOG THEN
5676: fnd_log.string(fnd_log.level_procedure,
5677: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5678: 'Entering with '||
5679: 'P_batch_id = '|| P_batch_id ||','||
5680: 'P_rowid_from = '|| P_rowid_from ||','||

Line 5707: fnd_log.string(fnd_log.level_procedure,

5703: Validate_Sales_Credits;
5704: Validate_notes;
5705:
5706: IF G_PROCEDURE_LOG THEN
5707: fnd_log.string(fnd_log.level_procedure,
5708: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5709: 'Exit.');
5710: END IF;
5711: EXCEPTION