DBA Data[Home] [Help]

APPS.IGI_IAC_WEBADI_PKG dependencies on IGI_IAC_WEBADI_PKG

Line 1: PACKAGE BODY IGI_IAC_WEBADI_PKG AS

1: PACKAGE BODY IGI_IAC_WEBADI_PKG AS
2: -- $Header: igiiasab.pls 120.10.12000000.1 2007/08/01 16:18:55 npandya noship $
3: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4:
5: l_state_level number:=FND_LOG.LEVEL_STATEMENT;

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

1464: l_message := Fnd_Message.Get;
1465: -- Debug(l_message);
1466: -- bug 3299718, start block
1467: IF (l_state_level >= l_debug_level) THEN
1468: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg1',
1469: l_message);
1470: END IF;
1471: -- bug 3299718, end block
1472:

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

1476: l_message := Fnd_Message.Get;
1477: -- Debug(l_message);
1478: -- bug 3299718, start block
1479: IF (l_state_level >= l_debug_level) THEN
1480: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg2',
1481: l_message);
1482: END IF;
1483: -- bug 3299718, end block
1484:

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

1487: l_message := Fnd_Message.Get;
1488: -- Debug(l_message);
1489: -- bug 3299718, start block
1490: IF (l_state_level >= l_debug_level) THEN
1491: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg3',
1492: l_message);
1493: END IF;
1494: -- bug 3299718, end block
1495: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_REVAL_ID');

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

1497: l_message := Fnd_Message.Get;
1498: -- Debug(l_message);
1499: -- bug 3299718, start block
1500: IF (l_state_level >= l_debug_level) THEN
1501: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg4',
1502: l_message);
1503: END IF;
1504: -- bug 3299718, end block
1505: End if;

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

1562: l_message := Fnd_Message.Get;
1563: -- Debug(l_message);
1564: -- bug 3299718, start block
1565: IF (l_state_level >= l_debug_level) THEN
1566: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg5',
1567: l_message);
1568: END IF;
1569: -- bug 3299718, end block
1570:

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

1575: l_message := Fnd_Message.Get;
1576: -- Debug(l_message);
1577: -- bug 3299718, start block
1578: IF (l_state_level >= l_debug_level) THEN
1579: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg6',
1580: l_message);
1581: END IF;
1582: -- bug 3299718, end block
1583:

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

1589: -- Debug(l_message);
1590:
1591: -- bug 3299718, start block
1592: IF (l_state_level >= l_debug_level) THEN
1593: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg7',
1594: l_message);
1595: END IF;
1596: -- bug 3299718, end block
1597:

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

1601: -- commenting out as no longer required
1602: IF (l_error_level >= l_debug_level) THEN
1603: fnd_message.set_name('IGI', 'IGI_IAC_UPL_PREVIEW_EXISTS');
1604: l_mesg1 := fnd_message.get;
1605: FND_LOG.MESSAGE(l_error_level,'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Preview Exists', TRUE);
1606: -- fnd_file.put_line required for display to user
1607: fnd_file.put_line(fnd_file.log, l_mesg1);
1608:
1609: -- list of assets

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

1611: FOR l_preview_exists IN c_preview_exists(l_book_type_code) LOOP
1612: fnd_message.set_name('IGI', 'IGI_IAC_UPL_PREVIEW_ASSETS');
1613: fnd_message.set_token('ASSET_NUM', l_preview_exists.asset_number, FALSE);
1614: l_mesg1 := fnd_message.get;
1615: FND_LOG.MESSAGE(l_error_level,'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Preview Exists', TRUE);
1616: -- fnd_file.put_line required for display to user
1617: fnd_file.put_line(fnd_file.log, l_mesg1);
1618: END LOOP;
1619: END IF;

Line 1635: End IGI_IAC_WEBADI_PKG;

1631: When Others then
1632: errbuf := SQLERRM;
1633: retcode :=2;
1634: End Transfer_Data;
1635: End IGI_IAC_WEBADI_PKG;