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.IGIRRGPP dependencies on FND_LOG

Line 4: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: Package Body IGIRRGPP AS
2: -- $Header: igirrgpb.pls 120.6.12000000.1 2007/08/31 05:53:13 mbremkum ship $
3:
4: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:
6: l_state_level number:=FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number:=FND_LOG.LEVEL_EVENT;

Line 6: l_state_level number:=FND_LOG.LEVEL_STATEMENT;

2: -- $Header: igirrgpb.pls 120.6.12000000.1 2007/08/31 05:53:13 mbremkum ship $
3:
4: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:
6: l_state_level number:=FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number:=FND_LOG.LEVEL_EVENT;
9: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number:=FND_LOG.LEVEL_ERROR;

Line 7: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;

3:
4: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:
6: l_state_level number:=FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number:=FND_LOG.LEVEL_EVENT;
9: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number:=FND_LOG.LEVEL_ERROR;
11: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;

Line 8: l_event_level number:=FND_LOG.LEVEL_EVENT;

4: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:
6: l_state_level number:=FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number:=FND_LOG.LEVEL_EVENT;
9: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number:=FND_LOG.LEVEL_ERROR;
11: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;
12:

Line 9: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;

5:
6: l_state_level number:=FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number:=FND_LOG.LEVEL_EVENT;
9: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number:=FND_LOG.LEVEL_ERROR;
11: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;
12:
13: --Commenting out WriteToLogFile as fnd_logging to be used bug 3199481 (Start)

Line 10: l_error_level number:=FND_LOG.LEVEL_ERROR;

6: l_state_level number:=FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number:=FND_LOG.LEVEL_EVENT;
9: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number:=FND_LOG.LEVEL_ERROR;
11: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;
12:
13: --Commenting out WriteToLogFile as fnd_logging to be used bug 3199481 (Start)
14: /*

Line 11: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;

7: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number:=FND_LOG.LEVEL_EVENT;
9: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number:=FND_LOG.LEVEL_ERROR;
11: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;
12:
13: --Commenting out WriteToLogFile as fnd_logging to be used bug 3199481 (Start)
14: /*
15: PROCEDURE WriteToLogFile(pp_mesg in varchar2) IS

Line 13: --Commenting out WriteToLogFile as fnd_logging to be used bug 3199481 (Start)

9: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number:=FND_LOG.LEVEL_ERROR;
11: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;
12:
13: --Commenting out WriteToLogFile as fnd_logging to be used bug 3199481 (Start)
14: /*
15: PROCEDURE WriteToLogFile(pp_mesg in varchar2) IS
16: IsDebugMode BOOLEAN := TRUE;
17: BEGIN

Line 25: --Commenting out WriteToLogFile as fnd_logging to be used bug 3199481 (End)

21: null;
22: END IF;
23: END WriteToLogFile;
24: */
25: --Commenting out WriteToLogFile as fnd_logging to be used bug 3199481 (End)
26:
27: PROCEDURE CreateLines ( pp_run_id in number
28: , pp_item_code_from in varchar2
29: , pp_item_code_to in varchar2

Line 165: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igirrgpp.createlines.Msg1',FALSE);

161: fnd_message.set_name('IGI','IGI_RPI_IS_DISABLED');
162: lv_mesg := fnd_message.get;
163: --Bug 3199481 (start)
164: If (l_unexp_level >= l_debug_level) then
165: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igirrgpp.createlines.Msg1',FALSE);
166: End if;
167: --Bug 3199481 (end)
168: raise_application_error ( -20000, lv_mesg);
169: return;

Line 407: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.updateprice.Msg1',

403:
404: --WriteToLogFile('Start of Processing of records for Update');
405: -- bug 3199481, start block
406: IF (l_state_level >= l_debug_level) THEN
407: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.updateprice.Msg1',
408: 'Start of Processing of records for Update');
409: END IF;
410: -- bug 3199481, end block
411:

Line 420: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg2',

416: l_org_id := l_ruh.org_id;
417: --WriteToLogFile('Updating status of Update Header to ERROR');
418: -- bug 3199481, start block
419: IF (l_state_level >= l_debug_level) THEN
420: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg2',
421: 'Updating status of Update Header to ERROR');
422: END IF;
423: -- bug 3199481, end block
424: update igi_rpi_update_hdr

Line 441: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg3',

437: --WriteToLogFile('Revised Effective Date :'||to_char(l_rul.revised_effective_date));
438:
439: -- bug 3199481, start block
440: IF (l_state_level >= l_debug_level) THEN
441: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg3',
442: 'Item Id :'|| to_char(l_rul.item_id));
443: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg4',
444: 'Standing Charge Id :'|| to_char(l_rul.Standing_charge_id));
445: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg5',

Line 443: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg4',

439: -- bug 3199481, start block
440: IF (l_state_level >= l_debug_level) THEN
441: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg3',
442: 'Item Id :'|| to_char(l_rul.item_id));
443: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg4',
444: 'Standing Charge Id :'|| to_char(l_rul.Standing_charge_id));
445: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg5',
446: 'Update Effective Date :'|| to_char(l_ruh.effective_date));
447: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg6',

Line 445: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg5',

441: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg3',
442: 'Item Id :'|| to_char(l_rul.item_id));
443: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg4',
444: 'Standing Charge Id :'|| to_char(l_rul.Standing_charge_id));
445: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg5',
446: 'Update Effective Date :'|| to_char(l_ruh.effective_date));
447: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg6',
448: 'Revised Price :'|| to_char(l_rul.revised_price));
449: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg7',

Line 447: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg6',

443: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg4',
444: 'Standing Charge Id :'|| to_char(l_rul.Standing_charge_id));
445: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg5',
446: 'Update Effective Date :'|| to_char(l_ruh.effective_date));
447: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg6',
448: 'Revised Price :'|| to_char(l_rul.revised_price));
449: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg7',
450: 'Revised Effective Date :'||to_char(l_rul.revised_effective_date));
451: END IF;

Line 449: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg7',

445: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg5',
446: 'Update Effective Date :'|| to_char(l_ruh.effective_date));
447: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg6',
448: 'Revised Price :'|| to_char(l_rul.revised_price));
449: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg7',
450: 'Revised Effective Date :'||to_char(l_rul.revised_effective_date));
451: END IF;
452: -- bug 3199481, end block
453:

Line 459: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg8',

455: IF (l_rul.revised_price is NULL) THEN
456: --WriteToLogFile('Updating revised price of Charge Item');
457: -- bug 3199481, start block
458: IF (l_state_level >= l_debug_level) THEN
459: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg8',
460: 'Updating revised price of Charge Item');
461: END IF;
462: -- bug 3199481, end block
463: update igi_rpi_items

Line 475: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg9',

471: ELSIF (l_ruh.effective_date > l_rul.revised_effective_date) THEN
472: --WriteToLogFile('Inserting record into audit table');
473: -- bug 3199481, start block
474: IF (l_state_level >= l_debug_level) THEN
475: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg9',
476: 'Inserting record into audit table');
477: END IF;
478: -- bug 3199481, end block
479: igi_rpi_audit_items_all_pkg.insert_row( X_rowid => l_rowid,

Line 492: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg10',

488:
489: --WriteToLogFile('Updating revised price of Charge Item');
490: -- bug 3199481, start block
491: IF (l_state_level >= l_debug_level) THEN
492: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg10',
493: 'Updating revised price of Charge Item');
494: END IF;
495: -- bug 3199481, end block
496: update igi_rpi_items

Line 510: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg11',

506: ELSE
507: --WriteToLogFile('Updating revised price of Standing Charge Line Item');
508: -- bug 3199481, start block
509: IF (l_state_level >= l_debug_level) THEN
510: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg11',
511: 'Updating revised price of Standing Charge Line Item');
512: END IF;
513: -- bug 3199481, end block
514: update igi_rpi_line_details

Line 532: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg12',

528: l_rowid := NULL;
529: --WriteToLogFile('Insert record into Line Item Price Audit table with the run id');
530: -- bug 3199481, start block
531: IF (l_state_level >= l_debug_level) THEN
532: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg12',
533: 'Insert record into Line Item Price Audit table with the run id');
534: END IF;
535: -- bug 3199481, end block
536: igi_rpi_line_audit_det_all_pkg.insert_row( X_rowid => l_rowid,

Line 557: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg13',

553:
554: --WriteToLogFile('Updating status of Update Header to COMPLETED');
555: -- bug 3199481, start block
556: IF (l_state_level >= l_debug_level) THEN
557: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg13',
558: 'Updating status of Update Header to COMPLETED');
559: END IF;
560: -- bug 3199481, end block
561: update igi_rpi_update_hdr

Line 568: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg14',

564:
565: END LOOP;
566: -- bug 3199481, start block
567: IF (l_state_level >= l_debug_level) THEN
568: FND_LOG.STRING(l_state_level, 'igi.plsql.igirrgpp.update_price.Msg14',
569: 'End of processing of Items for Price update');
570: END IF;
571: -- bug 3199481, end block
572: --WriteToLogFile('End of processing of Items for Price update');