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_POST_INSERT 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_recur_bill_occurance NUMBER := 0 ;
56:
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 ');
62:
63: END IF;

Line 267: fnd_log.string(fnd_log.level_statement,

263: WHERE INNER_Q2.SEQ <= INNER_Q1.NUM_STREAMS;
264:
265: /* IF G_STMT_LOG THEN
266:
267: fnd_log.string(fnd_log.level_statement,
268: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
269: 'Number of records successfully inserted = ' || l_int_count );
270: END IF; */
271:

Line 455: fnd_log.string(fnd_log.level_statement,

451:
452: WHERE INNER_Q2.SEQ <= INNER_Q1.LEVEL_PERIODS)SUBS_SCH_DT;
453:
454: /*IF G_STMT_LOG THEN
455: fnd_log.string(fnd_log.level_statement,
456: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
457: 'Number of records successfully inserted = ' || l_int_count );
458: END IF; */
459:

Line 462: fnd_log.string(fnd_log.level_procedure,

458: END IF; */
459:
460:
461: /* IF G_PROCEDURE_LOG THEN
462: fnd_log.string(fnd_log.level_procedure,
463: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
464: 'Exit.');
465:
466: END IF; */

Line 499: fnd_log.string(fnd_log.level_procedure,

495: l_recur_bill_occurance NUMBER := 0 ;
496: BEGIN
497:
498: IF G_PROCEDURE_LOG THEN
499: fnd_log.string(fnd_log.level_procedure,
500: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
501: 'Entering ');
502:
503: END IF;

Line 686: fnd_log.string(fnd_log.level_statement,

682: WHERE INNER_Q2.SEQ <= INNER_Q1.NUM_STREAMS;
683:
684: l_int_count := SQL%ROWCOUNT;
685: /* IF G_STMT_LOG THEN
686: fnd_log.string(fnd_log.level_statement,
687: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
688: 'Number of records successfully inserted = ' || l_int_count );
689:
690: END IF; */

Line 698: fnd_log.string(fnd_log.level_statement,

694: SELECT MAX(RECUR_BILL_OCCURANCES) INTO l_recur_bill_occurance FROM OKS_INT_LINE_STG_TEMP ;
695:
696: /* IF G_STMT_LOG THEN
697:
698: fnd_log.string(fnd_log.level_statement,
699: G_MODULE_HEAD || l_routine || '.' || l_stmt_num,
700: 'Value of max Recur Bill Occurance = ' || l_recur_bill_occurance );
701: END IF; */
702:

Line 1062: fnd_log.string(fnd_log.level_statement,

1058:
1059: /* l_int_count := SQL%ROWCOUNT;
1060: IF G_STMT_LOG THEN
1061: null;
1062: fnd_log.string(fnd_log.level_statement,
1063: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
1064: 'Number of records successfully inserted = ' || l_int_count );
1065: END IF;*/
1066:

Line 1241: fnd_log.string(fnd_log.level_statement,

1237: WHERE INNER_Q2.SEQ <= INNER_Q1.LEVEL_PERIODS)USG_SCH_DT;
1238:
1239:
1240: /*IF G_STMT_LOG THEN
1241: fnd_log.string(fnd_log.level_statement,
1242: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
1243: 'Number of records successfully inserted = ' || l_int_count );
1244: END IF; */
1245:

Line 1247: fnd_log.string(fnd_log.level_procedure,

1243: 'Number of records successfully inserted = ' || l_int_count );
1244: END IF; */
1245:
1246: /* IF G_PROCEDURE_LOG THEN
1247: fnd_log.string(fnd_log.level_procedure,
1248: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
1249: 'Exit.');
1250: null;
1251: END IF; */

Line 1284: fnd_log.string(fnd_log.level_procedure,

1280: l_recur_bill_occurance NUMBER := 0 ;
1281: BEGIN
1282:
1283: IF G_PROCEDURE_LOG THEN
1284: fnd_log.string(fnd_log.level_procedure,
1285: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
1286: 'Entering ');
1287:
1288: END IF;

Line 1474: fnd_log.string(fnd_log.level_statement,

1470: WHERE INNER_Q2.SEQ <= INNER_Q1.NUM_STREAMS;
1471:
1472: l_int_count := SQL%ROWCOUNT;
1473: /* IF G_STMT_LOG THEN
1474: fnd_log.string(fnd_log.level_statement,
1475: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
1476: 'Number of records successfully inserted = ' || l_int_count );
1477:
1478: END IF; */

Line 1486: fnd_log.string(fnd_log.level_statement,

1482: SELECT MAX(RECUR_BILL_OCCURANCES) INTO l_recur_bill_occurance FROM OKS_INT_LINE_STG_TEMP ;
1483:
1484: /* IF G_STMT_LOG THEN
1485:
1486: fnd_log.string(fnd_log.level_statement,
1487: G_MODULE_HEAD || l_routine || '.' || l_stmt_num,
1488: 'Value of max Recur Bill Occurance = ' || l_recur_bill_occurance );
1489: END IF; */
1490:

Line 1861: fnd_log.string(fnd_log.level_statement,

1857: l_int_count := SQL%ROWCOUNT;
1858:
1859: /*IF G_STMT_LOG THEN
1860:
1861: fnd_log.string(fnd_log.level_statement,
1862: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
1863: 'Number of records successfully inserted = ' || l_int_count );
1864: END IF; */
1865:

Line 2018: fnd_log.string(fnd_log.level_statement,

2014: AND COV_LVL_ELEM.DATE_START(+) >= LIN_SCH_DT.DATE_START
2015: AND COV_LVL_ELEM.DATE_END(+) <= LIN_SCH_DT.DATE_END ) SCH_LIN_INSERT;
2016:
2017: /* IF G_STMT_LOG THEN
2018: fnd_log.string(fnd_log.level_statement,
2019: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2020: 'Number of records successfully inserted = ' || l_int_count );
2021: END IF; */
2022:

Line 2024: fnd_log.string(fnd_log.level_procedure,

2020: 'Number of records successfully inserted = ' || l_int_count );
2021: END IF; */
2022:
2023: /* IF G_PROCEDURE_LOG THEN
2024: fnd_log.string(fnd_log.level_procedure,
2025: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2026: 'Exit.');
2027: null;
2028: END IF; */

Line 2060: fnd_log.string(fnd_log.level_procedure,

2056: l_stg_count NUMBER := 0;
2057: l_recur_bill_occurance NUMBER := 0 ;
2058: BEGIN
2059: IF G_PROCEDURE_LOG THEN
2060: fnd_log.string(fnd_log.level_procedure,
2061: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2062: 'Entering ');
2063:
2064: END IF;

Line 2077: fnd_log.string(fnd_log.level_statement,

2073: l_stmt_num := 30;
2074: Generate_bil_sch_Usage_lines;
2075:
2076: IF G_STMT_LOG THEN
2077: fnd_log.string(fnd_log.level_statement,
2078: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2079: 'Number of records successfully inserted = ' || l_int_count );
2080: END IF;
2081:

Line 2083: fnd_log.string(fnd_log.level_procedure,

2079: 'Number of records successfully inserted = ' || l_int_count );
2080: END IF;
2081:
2082: IF G_PROCEDURE_LOG THEN
2083: fnd_log.string(fnd_log.level_procedure,
2084: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2085: 'Exit.');
2086: null;
2087: END IF;

Line 2162: fnd_log.string(fnd_log.level_procedure,

2158:
2159: BEGIN
2160:
2161: IF G_PROCEDURE_LOG THEN
2162: fnd_log.string(fnd_log.level_procedure,
2163: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2164: 'Entering .' );
2165: END IF;
2166:

Line 2199: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, G_MODULE_HEAD || l_routine , l_msg_data || 'Return Status ' || l_return_status);

2195:
2196: END LOOP; -- FOR i IN 1..l_loop_count
2197:
2198: IF G_EXCEPTION_LOG THEN
2199: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, G_MODULE_HEAD || l_routine , l_msg_data || 'Return Status ' || l_return_status);
2200: END IF;
2201:
2202: EXIT WHEN get_line_cnt_details%NOTFOUND;
2203:

Line 2210: fnd_log.string(fnd_log.level_statement,

2206: CLOSE get_line_cnt_details;
2207:
2208: IF G_STMT_LOG THEN
2209:
2210: fnd_log.string(fnd_log.level_statement,
2211: G_MODULE_HEAD || l_routine || '.' || l_stmt_num,
2212: ' Succesffully Created Preventive Maintainence Schedules ' );
2213: END IF;
2214:

Line 2216: fnd_log.string(fnd_log.level_procedure,

2212: ' Succesffully Created Preventive Maintainence Schedules ' );
2213: END IF;
2214:
2215: IF G_PROCEDURE_LOG THEN
2216: fnd_log.string(fnd_log.level_procedure,
2217: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2218: 'Exit.');
2219: END IF;
2220:

Line 2323: fnd_log.string(fnd_log.level_procedure,

2319:
2320: BEGIN
2321:
2322: IF G_PROCEDURE_LOG THEN
2323: fnd_log.string(fnd_log.level_procedure,
2324: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2325: 'Entering .' );
2326: END IF;
2327:

Line 2390: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, G_MODULE_HEAD || l_routine , l_msg_data || 'Return Status ' || l_return_status);

2386:
2387: END LOOP; -- FOR i IN 1..l_loop_count
2388:
2389: IF G_EXCEPTION_LOG THEN
2390: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, G_MODULE_HEAD || l_routine , l_msg_data || 'Return Status ' || l_return_status);
2391: END IF;
2392:
2393: EXIT WHEN get_hdr_notes%NOTFOUND;
2394:

Line 2401: fnd_log.string(fnd_log.level_statement,

2397: CLOSE get_hdr_notes;
2398:
2399: IF G_STMT_LOG THEN
2400:
2401: fnd_log.string(fnd_log.level_statement,
2402: G_MODULE_HEAD || l_routine || '.' || l_stmt_num,
2403: ' Succesffully Created JTF Notes for headers ' );
2404: END IF;
2405:

Line 2467: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, G_MODULE_HEAD || l_routine , l_msg_data || 'Return Status ' || l_return_status);

2463:
2464: END LOOP; -- FOR i IN 1..l_loop_count
2465:
2466: IF G_EXCEPTION_LOG THEN
2467: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, G_MODULE_HEAD || l_routine , l_msg_data || 'Return Status ' || l_return_status);
2468: END IF;
2469:
2470: EXIT WHEN get_line_notes%NOTFOUND;
2471:

Line 2478: fnd_log.string(fnd_log.level_statement,

2474: CLOSE get_line_notes;
2475:
2476: IF G_STMT_LOG THEN
2477:
2478: fnd_log.string(fnd_log.level_statement,
2479: G_MODULE_HEAD || l_routine || '.' || l_stmt_num,
2480: ' Succesffully Created JTF Notes for Lines ' );
2481: END IF;
2482:

Line 2484: fnd_log.string(fnd_log.level_procedure,

2480: ' Succesffully Created JTF Notes for Lines ' );
2481: END IF;
2482:
2483: IF G_PROCEDURE_LOG THEN
2484: fnd_log.string(fnd_log.level_procedure,
2485: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2486: 'Exit.');
2487: END IF;
2488:

Line 2563: fnd_log.string(fnd_log.level_procedure,

2559:
2560: BEGIN
2561:
2562: IF G_PROCEDURE_LOG THEN
2563: fnd_log.string(fnd_log.level_procedure,
2564: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2565: 'Entering .' );
2566: END IF;
2567:

Line 2599: fnd_log.string(fnd_log.level_statement,

2595: x_ctr_grp_id_template => l_ctr_grp_id_template,
2596: x_ctr_grp_id_instance => l_ctr_grp_id_instance);
2597:
2598: IF G_STMT_LOG THEN
2599: fnd_log.string(fnd_log.level_statement,
2600: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2601: 'Auto instatianted Counters for Record number' || i || ' Return Status is '
2602: || l_return_status );
2603: END IF;

Line 2621: fnd_log.string(fnd_log.level_statement,

2617: x_msg_data => l_msg_data,
2618: p_instcnd_inp_rec => l_instcnd_inp_rec);
2619:
2620: IF G_STMT_LOG THEN
2621: fnd_log.string(fnd_log.level_statement,
2622: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2623: 'Instantiated events for Record number' || i || ' Return Status is '
2624: || l_return_status );
2625: END IF;

Line 2630: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, G_MODULE_HEAD || l_routine , l_msg_data || 'Return Status ' || l_return_status);

2626:
2627: END LOOP; -- FOR i IN 1..l_loop_count
2628:
2629: IF G_EXCEPTION_LOG THEN
2630: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, G_MODULE_HEAD || l_routine , l_msg_data || 'Return Status ' || l_return_status);
2631: END IF;
2632:
2633: EXIT WHEN get_line_itm_id%NOTFOUND ;
2634:

Line 2640: fnd_log.string(fnd_log.level_procedure,

2636:
2637: CLOSE get_line_itm_id;
2638:
2639: IF G_PROCEDURE_LOG THEN
2640: fnd_log.string(fnd_log.level_procedure,
2641: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2642: 'Exit.');
2643: END IF;
2644:

Line 2676: fnd_log.string(fnd_log.level_procedure,

2672: l_routine CONSTANT VARCHAR2(30) := 'Import_Post_Insert';
2673: BEGIN
2674:
2675: IF G_PROCEDURE_LOG THEN
2676: fnd_log.string(fnd_log.level_procedure,
2677: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2678: 'Entering .' );
2679:
2680: END IF;

Line 2692: fnd_log.string(fnd_log.level_procedure,

2688: Create_JTF_notes ;
2689: Instantiate_srvc_ctr_events;
2690:
2691: IF G_PROCEDURE_LOG THEN
2692: fnd_log.string(fnd_log.level_procedure,
2693: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2694: 'Exit.');
2695: END IF;
2696: