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.IGIRRPI dependencies on IGIRRPI

Line 1: PACKAGE BODY IGIRRPI AS

1: PACKAGE BODY IGIRRPI AS
2: -- $Header: igirrpib.pls 120.18.12010000.5 2009/01/19 14:50:03 gaprasad ship $
3:
4:
5: l_state_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 2: -- $Header: igirrpib.pls 120.18.12010000.5 2009/01/19 14:50:03 gaprasad ship $

1: PACKAGE BODY IGIRRPI AS
2: -- $Header: igirrpib.pls 120.18.12010000.5 2009/01/19 14:50:03 gaprasad ship $
3:
4:
5: l_state_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: l_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 452: WriteToLogFile (l_state_level,'igi.plsql.igirrpi.next_scheduled_dates ',' --> New Next Due Date '|| pp_new_next_due_date );

448:
449:
450: END LOOP;
451:
452: WriteToLogFile (l_state_level,'igi.plsql.igirrpi.next_scheduled_dates ',' --> New Next Due Date '|| pp_new_next_due_date );
453: WriteToLogFile (l_state_level,'igi.plsql.igirrpi.next_scheduled_dates ',' --> Cur Next Due Date '|| pp_cur_next_due_date );
454: WriteToLogFile (l_state_level,'igi.plsql.igirrpi.next_scheduled_dates', ' --> New Prev Due Date '|| pp_new_prev_due_date );
455: EXCEPTION
456: WHEN OTHERS THEN

Line 453: WriteToLogFile (l_state_level,'igi.plsql.igirrpi.next_scheduled_dates ',' --> Cur Next Due Date '|| pp_cur_next_due_date );

449:
450: END LOOP;
451:
452: WriteToLogFile (l_state_level,'igi.plsql.igirrpi.next_scheduled_dates ',' --> New Next Due Date '|| pp_new_next_due_date );
453: WriteToLogFile (l_state_level,'igi.plsql.igirrpi.next_scheduled_dates ',' --> Cur Next Due Date '|| pp_cur_next_due_date );
454: WriteToLogFile (l_state_level,'igi.plsql.igirrpi.next_scheduled_dates', ' --> New Prev Due Date '|| pp_new_prev_due_date );
455: EXCEPTION
456: WHEN OTHERS THEN
457: pp_new_next_due_date := l_new_next_due_date_old;

Line 454: WriteToLogFile (l_state_level,'igi.plsql.igirrpi.next_scheduled_dates', ' --> New Prev Due Date '|| pp_new_prev_due_date );

450: END LOOP;
451:
452: WriteToLogFile (l_state_level,'igi.plsql.igirrpi.next_scheduled_dates ',' --> New Next Due Date '|| pp_new_next_due_date );
453: WriteToLogFile (l_state_level,'igi.plsql.igirrpi.next_scheduled_dates ',' --> Cur Next Due Date '|| pp_cur_next_due_date );
454: WriteToLogFile (l_state_level,'igi.plsql.igirrpi.next_scheduled_dates', ' --> New Prev Due Date '|| pp_new_prev_due_date );
455: EXCEPTION
456: WHEN OTHERS THEN
457: pp_new_next_due_date := l_new_next_due_date_old;
458: pp_new_prev_due_date := l_new_prev_due_date_old;

Line 681: WriteToLogFile ( l_state_level,'igi.plsql.igirrpi.billing_charge_ratio',' Factor due start date : '|| p_factor );

677: l_no_of_days := add_months(p_from_date, 12 * p_bill_factor) - p_from_date;
678: end if;
679:
680:
681: WriteToLogFile ( l_state_level,'igi.plsql.igirrpi.billing_charge_ratio',' Factor due start date : '|| p_factor );
682: WriteToLogFile ( l_state_level,'igi.plsql.igirrpi.billing_charge_ratio',' factor due to components : '|| l_factor );
683: WriteToLogFile ( l_state_level,'igi.plsql.igirrpi.billing_charge_ratio',' Number of Days : '|| l_no_of_days );
684:
685: --bug3564100 sdixit: round (p_to_date - p_from_date) difference to smoothen out

Line 682: WriteToLogFile ( l_state_level,'igi.plsql.igirrpi.billing_charge_ratio',' factor due to components : '|| l_factor );

678: end if;
679:
680:
681: WriteToLogFile ( l_state_level,'igi.plsql.igirrpi.billing_charge_ratio',' Factor due start date : '|| p_factor );
682: WriteToLogFile ( l_state_level,'igi.plsql.igirrpi.billing_charge_ratio',' factor due to components : '|| l_factor );
683: WriteToLogFile ( l_state_level,'igi.plsql.igirrpi.billing_charge_ratio',' Number of Days : '|| l_no_of_days );
684:
685: --bug3564100 sdixit: round (p_to_date - p_from_date) difference to smoothen out
686: --the small error due to end date time component being 23:59:59 and not 24:00:00

Line 683: WriteToLogFile ( l_state_level,'igi.plsql.igirrpi.billing_charge_ratio',' Number of Days : '|| l_no_of_days );

679:
680:
681: WriteToLogFile ( l_state_level,'igi.plsql.igirrpi.billing_charge_ratio',' Factor due start date : '|| p_factor );
682: WriteToLogFile ( l_state_level,'igi.plsql.igirrpi.billing_charge_ratio',' factor due to components : '|| l_factor );
683: WriteToLogFile ( l_state_level,'igi.plsql.igirrpi.billing_charge_ratio',' Number of Days : '|| l_no_of_days );
684:
685: --bug3564100 sdixit: round (p_to_date - p_from_date) difference to smoothen out
686: --the small error due to end date time component being 23:59:59 and not 24:00:00
687: l_ratio := p_factor * l_factor * round(p_to_date - p_from_date) / l_no_of_days;

Line 1052: WriteToLogFile (l_state_level, 'igi.plsql.igirrpi.item_interface_lines.Msg1',

1048: l_rail.description := rtrim(pp_comment);
1049: l_rail.interface_line_attribute4 := pp_line_number ;
1050: l_rail.uom_name := pp_ld.unit_of_measure;
1051:
1052: WriteToLogFile (l_state_level, 'igi.plsql.igirrpi.item_interface_lines.Msg1',
1053: 'Item Amount to be invoiced '|| l_rail.amount );
1054: /** Insert normal LINE for this ITEM **/
1055:
1056: INSERT INTO ra_interface_lines_all ( accounting_rule_id

Line 1216: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg1',

1212: l_break_info := null;
1213: l_rail_old := pp_rail;
1214: l_line_number_old := pp_line_number;
1215:
1216: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg1',
1217: 'BEGIN Price Break Processing');
1218: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg2',
1219: 'Start Date '||l_Break_start_date||' End Date '||l_break_end_date);
1220:

Line 1218: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg2',

1214: l_line_number_old := pp_line_number;
1215:
1216: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg1',
1217: 'BEGIN Price Break Processing');
1218: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg2',
1219: 'Start Date '||l_Break_start_date||' End Date '||l_break_end_date);
1220:
1221: IF pp_from_date = pp_to_date or pp_ratio = 0
1222: OR pp_from_date is null or pp_to_date is null THEN

Line 1223: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg3',

1219: 'Start Date '||l_Break_start_date||' End Date '||l_break_end_date);
1220:
1221: IF pp_from_date = pp_to_date or pp_ratio = 0
1222: OR pp_from_date is null or pp_to_date is null THEN
1223: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg3',
1224: 'END Price Break Processing : Incorrect Parameters.');
1225: return;
1226: END IF;
1227:

Line 1228: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg4',

1224: 'END Price Break Processing : Incorrect Parameters.');
1225: return;
1226: END IF;
1227:
1228: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg4',
1229: 'Previous Effective date '|| pp_ld.previous_effective_date );
1230: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg5',
1231: 'Previous Price '|| pp_ld.previous_price );
1232: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg6',

Line 1230: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg5',

1226: END IF;
1227:
1228: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg4',
1229: 'Previous Effective date '|| pp_ld.previous_effective_date );
1230: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg5',
1231: 'Previous Price '|| pp_ld.previous_price );
1232: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg6',
1233: 'Current Effective date '|| pp_ld.current_effective_Date );
1234: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg7',

Line 1232: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg6',

1228: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg4',
1229: 'Previous Effective date '|| pp_ld.previous_effective_date );
1230: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg5',
1231: 'Previous Price '|| pp_ld.previous_price );
1232: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg6',
1233: 'Current Effective date '|| pp_ld.current_effective_Date );
1234: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg7',
1235: 'Current Price '|| pp_ld.price );
1236: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg8',

Line 1234: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg7',

1230: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg5',
1231: 'Previous Price '|| pp_ld.previous_price );
1232: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg6',
1233: 'Current Effective date '|| pp_ld.current_effective_Date );
1234: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg7',
1235: 'Current Price '|| pp_ld.price );
1236: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg8',
1237: 'Revised Effective date '|| pp_ld.revised_effective_date );
1238: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg9',

Line 1236: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg8',

1232: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg6',
1233: 'Current Effective date '|| pp_ld.current_effective_Date );
1234: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg7',
1235: 'Current Price '|| pp_ld.price );
1236: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg8',
1237: 'Revised Effective date '|| pp_ld.revised_effective_date );
1238: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg9',
1239: 'Revised Price '|| pp_ld.revised_price );
1240:

Line 1238: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg9',

1234: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg7',
1235: 'Current Price '|| pp_ld.price );
1236: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg8',
1237: 'Revised Effective date '|| pp_ld.revised_effective_date );
1238: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg9',
1239: 'Revised Price '|| pp_ld.revised_price );
1240:
1241: --aa
1242: IF pp_from_date <= nvl(pp_ld.current_effective_date, pp_from_date+1) THEN /**main **/

Line 1243: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg10',

1239: 'Revised Price '|| pp_ld.revised_price );
1240:
1241: --aa
1242: IF pp_from_date <= nvl(pp_ld.current_effective_date, pp_from_date+1) THEN /**main **/
1243: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg10',
1244: 'From Date is Equal to or prior to the Current Eff Date');
1245: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg11',
1246: 'pp_to_date '||pp_to_date||' '||'effdat'||pp_ld.current_effective_date);
1247: --bb

Line 1245: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg11',

1241: --aa
1242: IF pp_from_date <= nvl(pp_ld.current_effective_date, pp_from_date+1) THEN /**main **/
1243: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg10',
1244: 'From Date is Equal to or prior to the Current Eff Date');
1245: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg11',
1246: 'pp_to_date '||pp_to_date||' '||'effdat'||pp_ld.current_effective_date);
1247: --bb
1248: IF pp_to_date >= pp_ld.current_effective_date THEN
1249: pp_line_number := pp_line_number +1;

Line 1253: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg12',

1249: pp_line_number := pp_line_number +1;
1250: l_break_start_date := pp_from_date;
1251: l_break_end_date := pp_ld.current_effective_date - 1;
1252:
1253: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg12',
1254: 'l_break_end_date'||l_break_end_date);
1255:
1256: l_break_start_date :=
1257: to_date(to_char(l_break_start_date,DEF_DATE_FORMAT)||BEGIN_DATE_TIME,RPI_DATE_FORMAT);

Line 1259: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg13',

1255:
1256: l_break_start_date :=
1257: to_date(to_char(l_break_start_date,DEF_DATE_FORMAT)||BEGIN_DATE_TIME,RPI_DATE_FORMAT);
1258:
1259: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg13',
1260: 'l_break_start_date'||l_break_start_date);
1261:
1262: l_break_end_date :=
1263: to_date(to_char(l_break_end_date,DEF_DATE_FORMAT)||END_DATE_TIME,RPI_DATE_FORMAT);

Line 1266: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg14',

1262: l_break_end_date :=
1263: to_date(to_char(l_break_end_date,DEF_DATE_FORMAT)||END_DATE_TIME,RPI_DATE_FORMAT);
1264:
1265:
1266: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg14',
1267: 'l_break_end_date'||l_break_end_date);
1268:
1269: l_break_number := l_break_number + 1;
1270: l_break_ratio := pp_ratio * ( ( l_break_end_date - l_break_start_date)

Line 1278: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg16',

1274: FROM_DATE_INFO||to_char(l_break_start_date)||
1275: TO_DATE_INFO||to_char(l_break_end_date);
1276:
1277: IF l_break_price * l_break_ratio <> 0 then
1278: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg16',
1279: 'in Break #1 before interface');
1280:
1281: ITEM_Interface_lines ( pp_rail
1282: , l_break_price * l_break_ratio

Line 1292: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg17',

1288: , pp_from_date
1289: , pp_to_date
1290: ) ;
1291: END IF;
1292: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg17',
1293: 'in cc');
1294: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg18',
1295: 'pp_to_date='||pp_to_date||' '||'effdat'||pp_ld.revised_effective_date);
1296:

Line 1294: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg18',

1290: ) ;
1291: END IF;
1292: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg17',
1293: 'in cc');
1294: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg18',
1295: 'pp_to_date='||pp_to_date||' '||'effdat'||pp_ld.revised_effective_date);
1296:
1297: IF pp_to_date >= pp_ld.revised_effective_date THEN
1298: pp_line_number := pp_line_number +1;

Line 1316: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg19',

1312: l_break_price := pp_ld.price;
1313: l_break_info := pp_ld.desc_2||
1314: FROM_DATE_INFO||to_char(l_break_start_date)||
1315: TO_DATE_INFO||to_char(l_break_end_date);
1316: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg19',
1317: 'Break #2 '||l_break_info );
1318: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg20',
1319: 'diff='||to_char(l_break_end_date-l_break_start_date));
1320:

Line 1318: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg20',

1314: FROM_DATE_INFO||to_char(l_break_start_date)||
1315: TO_DATE_INFO||to_char(l_break_end_date);
1316: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg19',
1317: 'Break #2 '||l_break_info );
1318: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg20',
1319: 'diff='||to_char(l_break_end_date-l_break_start_date));
1320:
1321:
1322: ITEM_Interface_lines ( pp_rail

Line 1332: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg21',

1328: , pp_ld
1329: , pp_from_date
1330: , pp_to_date
1331: ) ;
1332: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg21',
1333: 'pp_to_date='||to_char(pp_to_date,'dd-mm-yyyy hh24:mi:ss'));
1334: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg22',
1335: 'l_break_end_date='||to_char(l_break_end_date,'dd-mm-yyyy hh24:mi:ss'));
1336: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg23',

Line 1334: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg22',

1330: , pp_to_date
1331: ) ;
1332: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg21',
1333: 'pp_to_date='||to_char(pp_to_date,'dd-mm-yyyy hh24:mi:ss'));
1334: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg22',
1335: 'l_break_end_date='||to_char(l_break_end_date,'dd-mm-yyyy hh24:mi:ss'));
1336: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg23',
1337: 'pp_ld.revised_effective_date='||to_char(pp_ld.revised_effective_date,'dd-mm-yyyy hh24:mi:ss'));
1338:

Line 1336: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg23',

1332: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg21',
1333: 'pp_to_date='||to_char(pp_to_date,'dd-mm-yyyy hh24:mi:ss'));
1334: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg22',
1335: 'l_break_end_date='||to_char(l_break_end_date,'dd-mm-yyyy hh24:mi:ss'));
1336: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg23',
1337: 'pp_ld.revised_effective_date='||to_char(pp_ld.revised_effective_date,'dd-mm-yyyy hh24:mi:ss'));
1338:
1339: IF pp_to_date > l_break_end_date
1340: and pp_from_date <> pp_ld.revised_effective_date THEN --4525139

Line 1349: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg24',

1345: to_date(to_char(l_break_start_date,DEF_DATE_FORMAT)||BEGIN_DATE_TIME,RPI_DATE_FORMAT);
1346: l_break_end_date :=
1347: to_date(to_char(l_break_end_date,DEF_DATE_FORMAT)||END_DATE_TIME,RPI_DATE_FORMAT);
1348: l_break_number := l_break_number + 1;
1349: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg24',
1350: 'diff='||to_char(l_break_end_date-l_break_start_date));
1351: l_break_ratio := pp_ratio * ( ( l_break_end_date - l_break_start_date)
1352: / ( pp_to_date - pp_from_date) );
1353: l_break_price := pp_ld.revised_price;

Line 1357: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg25',

1353: l_break_price := pp_ld.revised_price;
1354: l_break_info := pp_ld.desc_2||
1355: FROM_DATE_INFO||to_char(l_break_start_date)||
1356: TO_DATE_INFO||to_char(l_break_end_date);
1357: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg25',
1358: 'Break #3 '|| l_break_info );
1359: if l_break_price * l_break_ratio <> 0 then
1360:
1361:

Line 1389: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg26',

1385: l_break_price := pp_ld.price;
1386: l_break_info := pp_ld.desc_2||
1387: FROM_DATE_INFO||to_char(l_break_start_date)||
1388: TO_DATE_INFO||to_char(l_break_end_date);
1389: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg26',
1390: 'Break #4 '|| l_break_info );
1391: if l_break_price * l_break_ratio <> 0 then
1392:
1393:

Line 1407: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg27',

1403: ) ;
1404: end if;
1405: END IF; -- cc
1406: ELSE -- bb
1407: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg27',
1408: ' From date is being processed here.');
1409: pp_line_number := pp_line_number +1;
1410: l_break_start_date := pp_from_date;
1411: l_break_end_date := pp_to_date;

Line 1422: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg28',

1418: l_break_info := pp_ld.desc_2||
1419: FROM_DATE_INFO||to_char(l_break_start_date)||
1420: TO_DATE_INFO||to_char(l_break_end_date);
1421: l_break_price := pp_ld.previous_price;
1422: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg28',
1423: 'Break #6 '|| l_break_info );
1424: if l_break_price * l_break_ratio <> 0 then
1425:
1426:

Line 1446: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg29',

1442: IF pp_from_date <= nvl(pp_ld.revised_effective_date-1,pp_to_date) -- aa
1443: AND pp_from_date > pp_ld.current_effective_date
1444: THEN
1445: -- dd
1446: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg29',
1447: 'From Date is Equal to or prior to the Rev Eff Date -1');
1448:
1449: IF pp_to_date >= pp_ld.revised_effective_date-1 and
1450: pp_ld.revised_effective_date is not null

Line 1466: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg30',

1462: l_break_price := pp_ld.price;
1463: l_break_info := pp_ld.desc_2||
1464: FROM_DATE_INFO||to_char(l_break_start_date)||
1465: TO_DATE_INFO||to_char(l_break_end_date);
1466: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg30',
1467: 'Break #7 '||l_break_info );
1468: if l_break_price * l_break_ratio <> 0 then
1469:
1470: ITEM_Interface_lines ( pp_rail

Line 1497: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg31',

1493: l_break_price := pp_ld.revised_price;
1494: l_break_info := pp_ld.desc_2||
1495: FROM_DATE_INFO||to_char(l_break_start_date)||
1496: TO_DATE_INFO||to_char(l_break_end_date);
1497: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg31',
1498: 'Break #8 '||l_break_info );
1499: if l_break_price * l_break_ratio <> 0 then
1500:
1501:

Line 1524: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg32',

1520: l_break_end_date :=
1521: to_date(to_char(l_break_end_date,DEF_DATE_FORMAT)||END_DATE_TIME,RPI_DATE_FORMAT);
1522: l_break_ratio := pp_ratio * ( ( l_break_end_date - l_break_start_date)
1523: / ( pp_to_date - pp_from_date) );
1524: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg32',
1525: 'Ratio for NPBUCP is '||l_Break_ratio);
1526: l_break_price := pp_ld.price;
1527: l_break_info := pp_ld.desc_2||
1528: FROM_DATE_INFO||to_char(l_break_start_date)||

Line 1530: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg33',

1526: l_break_price := pp_ld.price;
1527: l_break_info := pp_ld.desc_2||
1528: FROM_DATE_INFO||to_char(l_break_start_date)||
1529: TO_DATE_INFO||to_char(l_break_end_date);
1530: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg33',
1531: 'Break #9 '||l_break_info );
1532: if l_break_price * l_break_ratio <> 0 then
1533:
1534:

Line 1565: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg34',

1561: l_break_price := pp_ld.revised_price;
1562: l_break_info := pp_ld.desc_2||
1563: FROM_DATE_INFO||to_char(l_break_start_date)||
1564: TO_DATE_INFO||to_char(l_break_end_date);
1565: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg34',
1566: 'Break #10'||l_break_info);
1567: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg35',
1568: 'price in 10='||l_break_price*l_break_ratio);
1569:

Line 1567: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg35',

1563: FROM_DATE_INFO||to_char(l_break_start_date)||
1564: TO_DATE_INFO||to_char(l_break_end_date);
1565: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg34',
1566: 'Break #10'||l_break_info);
1567: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg35',
1568: 'price in 10='||l_break_price*l_break_ratio);
1569:
1570: if l_break_price * l_break_ratio <> 0 then
1571:

Line 1586: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg36',

1582: ) ;
1583:
1584: end if;
1585: END IF; -- aa
1586: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg36',
1587: 'END (Successful) Price Break Processing');
1588:
1589: EXCEPTION WHEN OTHERS THEN
1590:

Line 1593: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg37',

1589: EXCEPTION WHEN OTHERS THEN
1590:
1591: pp_rail := l_rail_old;
1592: pp_line_number := l_line_number_old;
1593: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_price_breaks.Msg37',
1594: 'END (Error) Price Break Processing');
1595: RAISE_APPLICATION_ERROR (-20301, SQLERRM );
1596: END PROCESS_PRICE_BREAKS;
1597: --

Line 1857: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg1',

1853: , pp_new_component => l_component
1854: );
1855:
1856: pp_date_range_idx := 1;
1857: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg1',
1858: 'New Next Due date '|| l_final_date );
1859: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg2',
1860: 'New Prev Due date '|| l_prev_date);
1861: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg3',

Line 1859: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg2',

1855:
1856: pp_date_range_idx := 1;
1857: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg1',
1858: 'New Next Due date '|| l_final_date );
1859: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg2',
1860: 'New Prev Due date '|| l_prev_date);
1861: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg3',
1862: 'Curr Prev Due date '|| pp_sc_prev_due_date);
1863: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg4',

Line 1861: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg3',

1857: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg1',
1858: 'New Next Due date '|| l_final_date );
1859: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg2',
1860: 'New Prev Due date '|| l_prev_date);
1861: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg3',
1862: 'Curr Prev Due date '|| pp_sc_prev_due_date);
1863: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg4',
1864: 'Curr Next Due date '|| pp_sc_next_due_date);
1865: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg5',

Line 1863: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg4',

1859: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg2',
1860: 'New Prev Due date '|| l_prev_date);
1861: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg3',
1862: 'Curr Prev Due date '|| pp_sc_prev_due_date);
1863: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg4',
1864: 'Curr Next Due date '|| pp_sc_next_due_date);
1865: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg5',
1866: 'Start date '|| pp_sc_start_date );
1867: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg6',

Line 1865: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg5',

1861: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg3',
1862: 'Curr Prev Due date '|| pp_sc_prev_due_date);
1863: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg4',
1864: 'Curr Next Due date '|| pp_sc_next_due_date);
1865: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg5',
1866: 'Start date '|| pp_sc_start_date );
1867: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg6',
1868: 'End date '|| pp_sc_end_date );
1869:

Line 1867: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg6',

1863: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg4',
1864: 'Curr Next Due date '|| pp_sc_next_due_date);
1865: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg5',
1866: 'Start date '|| pp_sc_start_date );
1867: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg6',
1868: 'End date '|| pp_sc_end_date );
1869:
1870:
1871: if nvl(pp_sc_advance_arrears_ind,'ADVANCE') = 'ADVANCE'

Line 1873: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg7',

1869:
1870:
1871: if nvl(pp_sc_advance_arrears_ind,'ADVANCE') = 'ADVANCE'
1872: then
1873: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg7',
1874: 'End date = '||pp_sc_end_date);
1875: IF pp_sc_end_date < l_final_date THEN
1876: l_final_date := pp_sc_end_date+1;
1877: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg8',

Line 1877: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg8',

1873: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg7',
1874: 'End date = '||pp_sc_end_date);
1875: IF pp_sc_end_date < l_final_date THEN
1876: l_final_date := pp_sc_end_date+1;
1877: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg8',
1878: 'Final date = '||l_final_date);
1879: END IF;
1880:
1881: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg9',

Line 1881: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg9',

1877: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg8',
1878: 'Final date = '||l_final_date);
1879: END IF;
1880:
1881: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg9',
1882: pp_sc_next_due_date||' '||l_final_date ||' a ' );
1883:
1884: IF (pp_sc_next_due_date < pp_sc_start_date) THEN
1885: pp_date_range_table(pp_date_range_idx).start_date := pp_sc_start_date;

Line 1897: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg10',

1893: else /* for arrears */
1894:
1895: pp_date_range_table(pp_date_range_idx).start_date := l_prev_date;
1896: pp_date_range_table(pp_date_range_idx).actual_start_date := l_prev_date;
1897: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg10',
1898: 'Prev due date '|| l_prev_date );
1899: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg11',
1900: 'Start date '|| pp_sc_start_date );
1901:

Line 1899: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg11',

1895: pp_date_range_table(pp_date_range_idx).start_date := l_prev_date;
1896: pp_date_range_table(pp_date_range_idx).actual_start_date := l_prev_date;
1897: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg10',
1898: 'Prev due date '|| l_prev_date );
1899: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg11',
1900: 'Start date '|| pp_sc_start_date );
1901:
1902: if (pp_sc_start_date > l_prev_date) -- and (pp_sc_prev_due_date is null)
1903: then

Line 1905: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg12',

1901:
1902: if (pp_sc_start_date > l_prev_date) -- and (pp_sc_prev_due_date is null)
1903: then
1904: pp_date_range_table(pp_date_range_idx).start_date := pp_sc_start_date;
1905: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg12',
1906: 'start date '|| pp_sc_start_date );
1907: end if;
1908:
1909: /* Bug 2436978 ssemwal added if condition for end date validation */

Line 1912: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg13',

1908:
1909: /* Bug 2436978 ssemwal added if condition for end date validation */
1910: IF pp_sc_end_date < pp_sc_next_due_date THEN
1911: pp_date_range_table(pp_date_range_idx).end_date := pp_sc_end_date;
1912: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_date_ranges.Msg13',
1913: 'Final date = '||pp_sc_end_date);
1914: ELSE
1915: pp_date_range_table(pp_date_range_idx).end_date := pp_sc_next_due_date - 1;
1916: END IF;

Line 1959: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg1',

1955:
1956: l_quarter_days := 0;
1957: l_date_range_idx_old := pp_date_range_idx;
1958: l_date_range_table_old := pp_date_range_table;
1959: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg1',
1960: 'BEGIN Process Standing Charges');
1961: /** Initialize the interface lines grouping information **/
1962: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg2',
1963: 'Charge reference '|| pp_sc.charge_reference );

Line 1962: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg2',

1958: l_date_range_table_old := pp_date_range_table;
1959: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg1',
1960: 'BEGIN Process Standing Charges');
1961: /** Initialize the interface lines grouping information **/
1962: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg2',
1963: 'Charge reference '|| pp_sc.charge_reference );
1964: l_rail.interface_line_attribute1 := pp_sc.standing_charge_id;
1965: l_rail.interface_line_attribute2 := pp_generate_sequence ;
1966: l_rail.interface_line_attribute3 := pp_ld.charge_item_number ;

Line 2020: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg3',

2016: IF l_rail.accounting_rule_id is not null
2017: then
2018: l_rail.invoicing_rule_id := Get_invoicing_rule
2019: ( pp_sc.advance_arrears_ind );
2020: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg3',
2021: 'Charge reference '|| pp_sc.charge_reference );
2022: /* Added by Panaraya for bug 2439363 - Start */
2023: IF (nvl(pp_sc.advance_arrears_ind,'ARREARS')= ARREARS_STATUS ) THEN
2024: l_rail.gl_date := null;

Line 2049: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg3',

2045: l_rail.gl_date := pp_sc.standing_charge_date;
2046: END IF;
2047: END IF;
2048: /** Now start computing the date ranges **/
2049: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg3',
2050: '*** Begin of Process date ranges *** ');
2051:
2052: PROCESS_DATE_RANGES( pp_sc_period_name => pp_sc.sc_period_name
2053: , pp_sc_advance_arrears_ind => nvl(pp_sc.advance_arrears_ind,pp_sc.default_invoicing_rule)

Line 2062: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg4',

2058: , pp_date_range_idx => pp_date_range_idx
2059: , pp_date_range_table => pp_date_range_table
2060: );
2061:
2062: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg4',
2063: '*** End of Process date ranges *** ');
2064:
2065: declare
2066: l_binary_idx binary_integer ;

Line 2104: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg5',

2100:
2101: l_binary_idx := pp_date_range_table.FIRST;
2102: l_days_ratio := 0;
2103: l_line_number := 1;
2104: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg5',
2105: '*** Binary idx *** '|| l_binary_idx );
2106: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg6',
2107: '*** End idx *** '|| pp_date_range_idx );
2108:

Line 2106: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg6',

2102: l_days_ratio := 0;
2103: l_line_number := 1;
2104: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg5',
2105: '*** Binary idx *** '|| l_binary_idx );
2106: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg6',
2107: '*** End idx *** '|| pp_date_range_idx );
2108:
2109: while l_binary_idx <= pp_date_range_idx loop
2110:

Line 2111: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg7',

2107: '*** End idx *** '|| pp_date_range_idx );
2108:
2109: while l_binary_idx <= pp_date_range_idx loop
2110:
2111: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg7',
2112: 'LHS 2 '|| pp_date_range_table(l_binary_idx).start_date
2113: || ' RHS 2 '|| pp_date_range_table(l_binary_idx).end_date );
2114:
2115: /* Bug 2403906 vgadde 14/06/2002 modified < to <= to process standing charges with billing frequency DAY */

Line 2119: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg8',

2115: /* Bug 2403906 vgadde 14/06/2002 modified < to <= to process standing charges with billing frequency DAY */
2116: if pp_date_range_table(l_binary_idx).start_date <=
2117: pp_date_range_table(l_binary_idx).end_date then
2118:
2119: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg8',
2120: ' Actual Date '|| pp_date_range_table(l_binary_idx).actual_start_date );
2121: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg9',
2122: ' Start Date '|| pp_date_range_table(l_binary_idx).start_date );
2123: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg10',

Line 2121: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg9',

2117: pp_date_range_table(l_binary_idx).end_date then
2118:
2119: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg8',
2120: ' Actual Date '|| pp_date_range_table(l_binary_idx).actual_start_date );
2121: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg9',
2122: ' Start Date '|| pp_date_range_table(l_binary_idx).start_date );
2123: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg10',
2124: ' End date '|| pp_date_range_table(l_binary_idx).end_date );
2125:

Line 2123: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg10',

2119: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg8',
2120: ' Actual Date '|| pp_date_range_table(l_binary_idx).actual_start_date );
2121: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg9',
2122: ' Start Date '|| pp_date_range_table(l_binary_idx).start_date );
2123: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg10',
2124: ' End date '|| pp_date_range_table(l_binary_idx).end_date );
2125:
2126: l_days_ratio := Get_Days_Ratio ( pp_date_range_table(l_binary_idx).start_date,
2127: pp_date_range_table(l_binary_idx).actual_start_date,

Line 2131: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg11',

2127: pp_date_range_table(l_binary_idx).actual_start_date,
2128: pp_date_range_table(l_binary_idx).end_date )
2129: ;
2130:
2131: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg11',
2132: '** Days Ratio *** '|| l_days_ratio );
2133:
2134:
2135: Next_Due_Dates ( to_date(to_char(pp_date_range_table(l_binary_idx).start_date,DEF_DATE_FORMAT)

Line 2158: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg12',

2154: , l_billing_factor
2155: , l_billing_component
2156: ) ;
2157:
2158: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg12',
2159: '** Billing Schedule ** '|| l_billing_schedule );
2160:
2161: if l_billing_schedule = 0 then
2162: l_days_ratio := 1;

Line 2181: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg13',

2177: , l_billing_factor
2178: , l_billing_component
2179: );
2180:
2181: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg13',
2182: ' RATIO '|| io_ratio );
2183:
2184:
2185:

Line 2203: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg14',

2199: l_binary_idx := l_binary_idx + 1;
2200: end loop;
2201:
2202: end;
2203: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.process_charges.Msg14',
2204: 'END (Successful) Process Standing Charges');
2205: EXCEPTION
2206: WHEN OTHERS THEN
2207:

Line 2253: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.auto_invoice.Msg1',

2249: null;
2250: ELSE
2251: fnd_message.set_name( 'IGI', 'IGI_RPI_IS_DISABLED');
2252: lv_mesg := fnd_message.get;
2253: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.auto_invoice.Msg1',
2254: lv_mesg);
2255: retcode := 2;
2256: errbuf := lv_mesg;
2257: RETURN;

Line 2260: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.auto_invoice.Msg2',

2256: errbuf := lv_mesg;
2257: RETURN;
2258: END IF;
2259:
2260: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.auto_invoice.Msg2',
2261: 'BEGIN Generate Interface Data.');
2262: /** issue a savepoint **/
2263: savepoint rpi_txns;
2264: /** Load the Global Custom Values **/

Line 2277: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.auto_invoice.Msg3',

2273: FROM sys.dual ;
2274: END;
2275:
2276: BEGIN
2277: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.auto_invoice.Msg3',
2278: 'Next due date : '|| p_run_date );
2279:
2280: FOR std_rec IN c_stand_charges ( p_run_date, p_set_of_books_id, p_batch_source_id ) LOOP
2281:

Line 2282: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.auto_invoice.Msg4',

2278: 'Next due date : '|| p_run_date );
2279:
2280: FOR std_rec IN c_stand_charges ( p_run_date, p_set_of_books_id, p_batch_source_id ) LOOP
2281:
2282: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.auto_invoice.Msg4',
2283: 'Processing Charge : '|| std_rec.charge_reference);
2284:
2285:
2286:

Line 2294: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.auto_invoice.Msg5',

2290:
2291:
2292: l_line_count := l_line_count + 1;
2293: l_total_lines := l_total_lines + 1;
2294: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.auto_invoice.Msg5',
2295: 'Line count : '|| l_line_count );
2296: l_date_range_table.delete;
2297: l_date_range_idx := 0;
2298:

Line 2344: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.auto_invoice.Msg6',

2340: ELSE
2341: rollback to rpi_txns;
2342: END IF;
2343: -- Signal Normal completion.
2344: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.auto_invoice.Msg6',
2345: 'END (Successful) Generate Interface Data.');
2346: errbuf := null;
2347: retcode := 0;
2348:

Line 2351: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.auto_invoice.Msg7',

2347: retcode := 0;
2348:
2349: EXCEPTION WHEN OTHERS THEN
2350: rollback;
2351: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.auto_invoice.Msg7',
2352: 'END (Error) Generate Interface Data.');
2353: errbuf := SQLERRM;
2354: retcode := 2;
2355:

Line 2365: END IGIRRPI;

2361: rev_idx := 0;
2362: TRANSACTION_CODE := 'PERIODICS';
2363: FROM_DATE_INFO := ' From Date ';
2364: TO_DATE_INFO := ' To Date ';
2365: END IGIRRPI;