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 35: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 66: fnd_log.string(fnd_log.level_procedure,

62: l_recur_bill_occurance NUMBER := 0 ;
63:
64: BEGIN
65: IF G_PROCEDURE_LOG THEN
66: fnd_log.string(fnd_log.level_procedure,
67: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
68: 'Entering ');
69:
70: END IF;

Line 293: fnd_log.string(fnd_log.level_statement,

289: WHERE INNER_Q2.SEQ <= INNER_Q1.NUM_STREAMS;
290:
291: /* IF G_STMT_LOG THEN
292:
293: fnd_log.string(fnd_log.level_statement,
294: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
295: 'Number of records successfully inserted = ' || l_int_count );
296: END IF; */
297:

Line 559: fnd_log.string(fnd_log.level_statement,

555:
556: WHERE INNER_Q2.SEQ <= INNER_Q1.LEVEL_PERIODS)SUBS_SCH_DT;
557:
558: /*IF G_STMT_LOG THEN
559: fnd_log.string(fnd_log.level_statement,
560: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
561: 'Number of records successfully inserted = ' || l_int_count );
562: END IF; */
563:

Line 566: fnd_log.string(fnd_log.level_procedure,

562: END IF; */
563:
564:
565: /* IF G_PROCEDURE_LOG THEN
566: fnd_log.string(fnd_log.level_procedure,
567: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
568: 'Exit.');
569:
570: END IF; */

Line 603: fnd_log.string(fnd_log.level_procedure,

599: l_recur_bill_occurance NUMBER := 0 ;
600: BEGIN
601:
602: IF G_PROCEDURE_LOG THEN
603: fnd_log.string(fnd_log.level_procedure,
604: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
605: 'Entering ');
606:
607: END IF;

Line 810: fnd_log.string(fnd_log.level_statement,

806: WHERE INNER_Q2.SEQ <= INNER_Q1.NUM_STREAMS;
807:
808: l_int_count := SQL%ROWCOUNT;
809: /* IF G_STMT_LOG THEN
810: fnd_log.string(fnd_log.level_statement,
811: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
812: 'Number of records successfully inserted = ' || l_int_count );
813:
814: END IF; */

Line 822: fnd_log.string(fnd_log.level_statement,

818: SELECT MAX(RECUR_BILL_OCCURANCES) INTO l_recur_bill_occurance FROM OKS_INT_LINE_STG_TEMP ;
819:
820: /* IF G_STMT_LOG THEN
821:
822: fnd_log.string(fnd_log.level_statement,
823: G_MODULE_HEAD || l_routine || '.' || l_stmt_num,
824: 'Value of max Recur Bill Occurance = ' || l_recur_bill_occurance );
825: END IF; */
826:

Line 1259: fnd_log.string(fnd_log.level_statement,

1255:
1256: /* l_int_count := SQL%ROWCOUNT;
1257: IF G_STMT_LOG THEN
1258: null;
1259: fnd_log.string(fnd_log.level_statement,
1260: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
1261: 'Number of records successfully inserted = ' || l_int_count );
1262: END IF;*/
1263:

Line 1491: fnd_log.string(fnd_log.level_statement,

1487: WHERE INNER_Q2.SEQ <= INNER_Q1.LEVEL_PERIODS)USG_SCH_DT;
1488:
1489:
1490: /*IF G_STMT_LOG THEN
1491: fnd_log.string(fnd_log.level_statement,
1492: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
1493: 'Number of records successfully inserted = ' || l_int_count );
1494: END IF; */
1495:

Line 1497: fnd_log.string(fnd_log.level_procedure,

1493: 'Number of records successfully inserted = ' || l_int_count );
1494: END IF; */
1495:
1496: /* IF G_PROCEDURE_LOG THEN
1497: fnd_log.string(fnd_log.level_procedure,
1498: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
1499: 'Exit.');
1500: null;
1501: END IF; */

Line 1534: fnd_log.string(fnd_log.level_procedure,

1530: l_recur_bill_occurance NUMBER := 0 ;
1531: BEGIN
1532:
1533: IF G_PROCEDURE_LOG THEN
1534: fnd_log.string(fnd_log.level_procedure,
1535: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
1536: 'Entering ');
1537:
1538: END IF;

Line 1744: fnd_log.string(fnd_log.level_statement,

1740: WHERE INNER_Q2.SEQ <= INNER_Q1.NUM_STREAMS;
1741:
1742: l_int_count := SQL%ROWCOUNT;
1743: /* IF G_STMT_LOG THEN
1744: fnd_log.string(fnd_log.level_statement,
1745: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
1746: 'Number of records successfully inserted = ' || l_int_count );
1747:
1748: END IF; */

Line 1756: fnd_log.string(fnd_log.level_statement,

1752: SELECT MAX(RECUR_BILL_OCCURANCES) INTO l_recur_bill_occurance FROM OKS_INT_LINE_STG_TEMP ;
1753:
1754: /* IF G_STMT_LOG THEN
1755:
1756: fnd_log.string(fnd_log.level_statement,
1757: G_MODULE_HEAD || l_routine || '.' || l_stmt_num,
1758: 'Value of max Recur Bill Occurance = ' || l_recur_bill_occurance );
1759: END IF; */
1760:

Line 2205: fnd_log.string(fnd_log.level_statement,

2201: l_int_count := SQL%ROWCOUNT;
2202:
2203: /*IF G_STMT_LOG THEN
2204:
2205: fnd_log.string(fnd_log.level_statement,
2206: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2207: 'Number of records successfully inserted = ' || l_int_count );
2208: END IF; */
2209:

Line 2416: fnd_log.string(fnd_log.level_statement,

2412: AND COV_LVL_ELEM.DATE_START(+) >= LIN_SCH_DT.DATE_START
2413: AND COV_LVL_ELEM.DATE_END(+) <= LIN_SCH_DT.DATE_END ) SCH_LIN_INSERT;
2414:
2415: /* IF G_STMT_LOG THEN
2416: fnd_log.string(fnd_log.level_statement,
2417: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2418: 'Number of records successfully inserted = ' || l_int_count );
2419: END IF; */
2420:

Line 2422: fnd_log.string(fnd_log.level_procedure,

2418: 'Number of records successfully inserted = ' || l_int_count );
2419: END IF; */
2420:
2421: /* IF G_PROCEDURE_LOG THEN
2422: fnd_log.string(fnd_log.level_procedure,
2423: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2424: 'Exit.');
2425: null;
2426: END IF; */

Line 2458: fnd_log.string(fnd_log.level_procedure,

2454: l_stg_count NUMBER := 0;
2455: l_recur_bill_occurance NUMBER := 0 ;
2456: BEGIN
2457: IF G_PROCEDURE_LOG THEN
2458: fnd_log.string(fnd_log.level_procedure,
2459: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2460: 'Entering ');
2461:
2462: END IF;

Line 2475: fnd_log.string(fnd_log.level_statement,

2471: l_stmt_num := 30;
2472: Generate_bil_sch_Usage_lines;
2473:
2474: IF G_STMT_LOG THEN
2475: fnd_log.string(fnd_log.level_statement,
2476: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2477: 'Number of records successfully inserted = ' || l_int_count );
2478: END IF;
2479:

Line 2481: fnd_log.string(fnd_log.level_procedure,

2477: 'Number of records successfully inserted = ' || l_int_count );
2478: END IF;
2479:
2480: IF G_PROCEDURE_LOG THEN
2481: fnd_log.string(fnd_log.level_procedure,
2482: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2483: 'Exit.');
2484: null;
2485: END IF;

Line 2560: fnd_log.string(fnd_log.level_procedure,

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

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

2593:
2594: END LOOP; -- FOR i IN 1..l_loop_count
2595:
2596: IF G_EXCEPTION_LOG THEN
2597: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, G_MODULE_HEAD || l_routine , l_msg_data || 'Return Status ' || l_return_status);
2598: END IF;
2599:
2600: EXIT WHEN get_line_cnt_details%NOTFOUND;
2601:

Line 2608: fnd_log.string(fnd_log.level_statement,

2604: CLOSE get_line_cnt_details;
2605:
2606: IF G_STMT_LOG THEN
2607:
2608: fnd_log.string(fnd_log.level_statement,
2609: G_MODULE_HEAD || l_routine || '.' || l_stmt_num,
2610: ' Succesffully Created Preventive Maintainence Schedules ' );
2611: END IF;
2612:

Line 2614: fnd_log.string(fnd_log.level_procedure,

2610: ' Succesffully Created Preventive Maintainence Schedules ' );
2611: END IF;
2612:
2613: IF G_PROCEDURE_LOG THEN
2614: fnd_log.string(fnd_log.level_procedure,
2615: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2616: 'Exit.');
2617: END IF;
2618:

Line 2721: fnd_log.string(fnd_log.level_procedure,

2717:
2718: BEGIN
2719:
2720: IF G_PROCEDURE_LOG THEN
2721: fnd_log.string(fnd_log.level_procedure,
2722: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2723: 'Entering .' );
2724: END IF;
2725:

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

2784:
2785: END LOOP; -- FOR i IN 1..l_loop_count
2786:
2787: IF G_EXCEPTION_LOG THEN
2788: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, G_MODULE_HEAD || l_routine , l_msg_data || 'Return Status ' || l_return_status);
2789: END IF;
2790:
2791: EXIT WHEN get_hdr_notes%NOTFOUND;
2792:

Line 2799: fnd_log.string(fnd_log.level_statement,

2795: CLOSE get_hdr_notes;
2796:
2797: IF G_STMT_LOG THEN
2798:
2799: fnd_log.string(fnd_log.level_statement,
2800: G_MODULE_HEAD || l_routine || '.' || l_stmt_num,
2801: ' Succesffully Created JTF Notes for headers ' );
2802: END IF;
2803:

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

2861:
2862: END LOOP; -- FOR i IN 1..l_loop_count
2863:
2864: IF G_EXCEPTION_LOG THEN
2865: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, G_MODULE_HEAD || l_routine , l_msg_data || 'Return Status ' || l_return_status);
2866: END IF;
2867:
2868: EXIT WHEN get_line_notes%NOTFOUND;
2869:

Line 2876: fnd_log.string(fnd_log.level_statement,

2872: CLOSE get_line_notes;
2873:
2874: IF G_STMT_LOG THEN
2875:
2876: fnd_log.string(fnd_log.level_statement,
2877: G_MODULE_HEAD || l_routine || '.' || l_stmt_num,
2878: ' Succesffully Created JTF Notes for Lines ' );
2879: END IF;
2880:

Line 2882: fnd_log.string(fnd_log.level_procedure,

2878: ' Succesffully Created JTF Notes for Lines ' );
2879: END IF;
2880:
2881: IF G_PROCEDURE_LOG THEN
2882: fnd_log.string(fnd_log.level_procedure,
2883: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2884: 'Exit.');
2885: END IF;
2886:

Line 2961: fnd_log.string(fnd_log.level_procedure,

2957:
2958: BEGIN
2959:
2960: IF G_PROCEDURE_LOG THEN
2961: fnd_log.string(fnd_log.level_procedure,
2962: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2963: 'Entering .' );
2964: END IF;
2965:

Line 2997: fnd_log.string(fnd_log.level_statement,

2993: x_ctr_grp_id_template => l_ctr_grp_id_template,
2994: x_ctr_grp_id_instance => l_ctr_grp_id_instance);
2995:
2996: IF G_STMT_LOG THEN
2997: fnd_log.string(fnd_log.level_statement,
2998: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
2999: 'Auto instatianted Counters for Record number' || i || ' Return Status is '
3000: || l_return_status );
3001: END IF;

Line 3019: fnd_log.string(fnd_log.level_statement,

3015: x_msg_data => l_msg_data,
3016: p_instcnd_inp_rec => l_instcnd_inp_rec);
3017:
3018: IF G_STMT_LOG THEN
3019: fnd_log.string(fnd_log.level_statement,
3020: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
3021: 'Instantiated events for Record number' || i || ' Return Status is '
3022: || l_return_status );
3023: END IF;

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

3024:
3025: END LOOP; -- FOR i IN 1..l_loop_count
3026:
3027: IF G_EXCEPTION_LOG THEN
3028: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, G_MODULE_HEAD || l_routine , l_msg_data || 'Return Status ' || l_return_status);
3029: END IF;
3030:
3031: EXIT WHEN get_line_itm_id%NOTFOUND ;
3032:

Line 3038: fnd_log.string(fnd_log.level_procedure,

3034:
3035: CLOSE get_line_itm_id;
3036:
3037: IF G_PROCEDURE_LOG THEN
3038: fnd_log.string(fnd_log.level_procedure,
3039: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
3040: 'Exit.');
3041: END IF;
3042:

Line 3074: fnd_log.string(fnd_log.level_procedure,

3070: l_routine CONSTANT VARCHAR2(30) := 'Import_Post_Insert';
3071: BEGIN
3072:
3073: IF G_PROCEDURE_LOG THEN
3074: fnd_log.string(fnd_log.level_procedure,
3075: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
3076: 'Entering .' );
3077:
3078: END IF;

Line 3090: fnd_log.string(fnd_log.level_procedure,

3086: Create_JTF_notes ;
3087: Instantiate_srvc_ctr_events;
3088:
3089: IF G_PROCEDURE_LOG THEN
3090: fnd_log.string(fnd_log.level_procedure,
3091: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
3092: 'Exit.');
3093: END IF;
3094: