DBA Data[Home] [Help]

APPS.IGI_IAC_WEBADI_PKG dependencies on FND_LOG

Line 3: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY IGI_IAC_WEBADI_PKG AS
2: -- $Header: igiiasab.pls 120.12 2011/10/25 11:53:40 aarsridh ship $
3: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4:
5: l_state_level number:=FND_LOG.LEVEL_STATEMENT;
6: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
7: l_event_level number:=FND_LOG.LEVEL_EVENT;

Line 5: l_state_level number:=FND_LOG.LEVEL_STATEMENT;

1: PACKAGE BODY IGI_IAC_WEBADI_PKG AS
2: -- $Header: igiiasab.pls 120.12 2011/10/25 11:53:40 aarsridh ship $
3: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4:
5: l_state_level number:=FND_LOG.LEVEL_STATEMENT;
6: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
7: l_event_level number:=FND_LOG.LEVEL_EVENT;
8: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;
9: l_error_level number:=FND_LOG.LEVEL_ERROR;

Line 6: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;

2: -- $Header: igiiasab.pls 120.12 2011/10/25 11:53:40 aarsridh ship $
3: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4:
5: l_state_level number:=FND_LOG.LEVEL_STATEMENT;
6: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
7: l_event_level number:=FND_LOG.LEVEL_EVENT;
8: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;
9: l_error_level number:=FND_LOG.LEVEL_ERROR;
10: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;

Line 7: l_event_level number:=FND_LOG.LEVEL_EVENT;

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

Line 8: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;

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

Line 9: l_error_level number:=FND_LOG.LEVEL_ERROR;

5: l_state_level number:=FND_LOG.LEVEL_STATEMENT;
6: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
7: l_event_level number:=FND_LOG.LEVEL_EVENT;
8: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;
9: l_error_level number:=FND_LOG.LEVEL_ERROR;
10: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;
11:
12: Cursor C_File_Transferred(
13: cp_file_name IN igi_iac_upload_headers.file_name%type) Is

Line 10: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;

6: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
7: l_event_level number:=FND_LOG.LEVEL_EVENT;
8: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;
9: l_error_level number:=FND_LOG.LEVEL_ERROR;
10: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;
11:
12: Cursor C_File_Transferred(
13: cp_file_name IN igi_iac_upload_headers.file_name%type) Is
14: Select 'X'

Line 1486: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg1',

1482: l_message := Fnd_Message.Get;
1483: -- Debug(l_message);
1484: -- bug 3299718, start block
1485: IF (l_state_level >= l_debug_level) THEN
1486: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg1',
1487: l_message);
1488: END IF;
1489: -- bug 3299718, end block
1490:

Line 1498: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg2',

1494: l_message := Fnd_Message.Get;
1495: -- Debug(l_message);
1496: -- bug 3299718, start block
1497: IF (l_state_level >= l_debug_level) THEN
1498: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg2',
1499: l_message);
1500: END IF;
1501: -- bug 3299718, end block
1502:

Line 1509: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg3',

1505: l_message := Fnd_Message.Get;
1506: -- Debug(l_message);
1507: -- bug 3299718, start block
1508: IF (l_state_level >= l_debug_level) THEN
1509: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg3',
1510: l_message);
1511: END IF;
1512: -- bug 3299718, end block
1513: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_REVAL_ID');

Line 1519: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg4',

1515: l_message := Fnd_Message.Get;
1516: -- Debug(l_message);
1517: -- bug 3299718, start block
1518: IF (l_state_level >= l_debug_level) THEN
1519: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg4',
1520: l_message);
1521: END IF;
1522: -- bug 3299718, end block
1523: End if;

Line 1584: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg5',

1580: l_message := Fnd_Message.Get;
1581: -- Debug(l_message);
1582: -- bug 3299718, start block
1583: IF (l_state_level >= l_debug_level) THEN
1584: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg5',
1585: l_message);
1586: END IF;
1587: -- bug 3299718, end block
1588:

Line 1597: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg6',

1593: l_message := Fnd_Message.Get;
1594: -- Debug(l_message);
1595: -- bug 3299718, start block
1596: IF (l_state_level >= l_debug_level) THEN
1597: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg6',
1598: l_message);
1599: END IF;
1600: -- bug 3299718, end block
1601:

Line 1611: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg7',

1607: -- Debug(l_message);
1608:
1609: -- bug 3299718, start block
1610: IF (l_state_level >= l_debug_level) THEN
1611: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg7',
1612: l_message);
1613: END IF;
1614: -- bug 3299718, end block
1615:

Line 1623: FND_LOG.MESSAGE(l_error_level,'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Preview Exists', TRUE);

1619: -- commenting out as no longer required
1620: IF (l_error_level >= l_debug_level) THEN
1621: fnd_message.set_name('IGI', 'IGI_IAC_UPL_PREVIEW_EXISTS');
1622: l_mesg1 := fnd_message.get;
1623: FND_LOG.MESSAGE(l_error_level,'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Preview Exists', TRUE);
1624: -- fnd_file.put_line required for display to user
1625: fnd_file.put_line(fnd_file.log, l_mesg1);
1626:
1627: -- list of assets

Line 1633: FND_LOG.MESSAGE(l_error_level,'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Preview Exists', TRUE);

1629: FOR l_preview_exists IN c_preview_exists(l_book_type_code) LOOP
1630: fnd_message.set_name('IGI', 'IGI_IAC_UPL_PREVIEW_ASSETS');
1631: fnd_message.set_token('ASSET_NUM', l_preview_exists.asset_number, FALSE);
1632: l_mesg1 := fnd_message.get;
1633: FND_LOG.MESSAGE(l_error_level,'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Preview Exists', TRUE);
1634: -- fnd_file.put_line required for display to user
1635: fnd_file.put_line(fnd_file.log, l_mesg1);
1636: END LOOP;
1637: END IF;