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

Line 6: --following variables added for bug 3199481: fnd logging changes: sdixit

2: -- $Header: igircajb.pls 120.8.12000000.5 2007/11/27 11:05:50 pshivara ship $
3:
4: DebugMode BOOLEAN;
5:
6: --following variables added for bug 3199481: fnd logging changes: sdixit
7: l_debug_level number;
8: l_state_level number;
9: l_proc_level number;
10: l_event_level number;

Line 159: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.GetAdjustments',TRUE);

155:
156: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
157: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
158: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
159: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.GetAdjustments',TRUE);
160: END IF;
161:
162: RAISE;
163: END;

Line 352: FND_LOG.MESSAGE ( l_unexp_level,'igi.pls.igircajb.IGIRCABJB.GetTxnDistributions',TRUE);

348:
349: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
350: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
351: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
352: FND_LOG.MESSAGE ( l_unexp_level,'igi.pls.igircajb.IGIRCABJB.GetTxnDistributions',TRUE);
353: END IF;
354:
355: RAISE;
356: END;

Line 506: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJB.GetRxptHistory',TRUE);

502:
503: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
504: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
505: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
506: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJB.GetRxptHistory',TRUE);
507: END IF;
508:
509: RAISE;
510: END;

Line 774: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.GetRecApplications',TRUE);

770:
771: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
772: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
773: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
774: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.GetRecApplications',TRUE);
775: END IF;
776: RAISE;
777: END;
778: --

Line 906: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJB.GetMiscCashDates',TRUE);

902:
903: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
904: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
905: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
906: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJB.GetMiscCashDates',TRUE);
907: END IF;
908:
909: RAISE;
910: END;

Line 964: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.CheckBalance',TRUE);

960:
961: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
962: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
963: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
964: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.CheckBalance',TRUE);
965: END IF;
966:
967: RAISE;
968: END;

Line 974: FND_LOG.STRING (l_proc_level , 'igi.plsql.igircajb.IGIRCABJP.Report',

970: PROCEDURE Report( p_Report IN ReportParametersType ) IS
971: BEGIN
972:
973: IF (l_proc_level >= l_debug_level ) THEN
974: FND_LOG.STRING (l_proc_level , 'igi.plsql.igircajb.IGIRCABJP.Report',
975: ' Begin Accrual reconciliation program ');
976: END IF;
977:
978: GetAdjustments ( p_Report );

Line 988: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.Report',

984: IF p_Report.ChkBalance = 'Y' AND
985: p_Report.PostedStatus <> 'POSTED'
986: THEN
987: IF (l_state_level >= l_debug_level ) THEN
988: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.Report',
989: ' >> Check the Balance ');
990: END IF;
991: CheckBalance( p_Report );
992: END IF;

Line 995: FND_LOG.STRING (l_proc_level , 'igi.plsql.igircajb.IGIRCABJP.Report',

991: CheckBalance( p_Report );
992: END IF;
993:
994: IF (l_proc_level >= l_debug_level ) THEN
995: FND_LOG.STRING (l_proc_level , 'igi.plsql.igircajb.IGIRCABJP.Report',
996: ' End Accrual reconciliation program ');
997: END IF;
998:
999: EXCEPTION

Line 1007: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.Report',TRUE);

1003:
1004: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1005: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1006: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1007: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.Report',TRUE);
1008: END IF;
1009:
1010: RAISE_APPLICATION_ERROR( -20000, sqlerrm||'$Revision: 120.8.12000000.5 $:Report( p_Report ):' );
1011: END;

Line 1065: --bug 3199481 fnd logging changes: sdixit: start block

1061: RETURN (l_RequestId);
1062:
1063: EXCEPTION
1064: WHEN OTHERS THEN
1065: --bug 3199481 fnd logging changes: sdixit: start block
1066: --standard way to handle when-others as per FND logging guidelines
1067: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1068: --retcode := 2;
1069: --errbuf := Fnd_message.get;

Line 1066: --standard way to handle when-others as per FND logging guidelines

1062:
1063: EXCEPTION
1064: WHEN OTHERS THEN
1065: --bug 3199481 fnd logging changes: sdixit: start block
1066: --standard way to handle when-others as per FND logging guidelines
1067: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1068: --retcode := 2;
1069: --errbuf := Fnd_message.get;
1070:

Line 1076: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJB.SubmitReconcileReport',TRUE);

1072:
1073: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1074: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1075: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1076: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJB.SubmitReconcileReport',TRUE);
1077: END IF;
1078: --bug 3199481 fnd logging changes: sdixit: end block
1079:
1080: RETURN (l_RequestId);

Line 1078: --bug 3199481 fnd logging changes: sdixit: end block

1074: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1075: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1076: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJB.SubmitReconcileReport',TRUE);
1077: END IF;
1078: --bug 3199481 fnd logging changes: sdixit: end block
1079:
1080: RETURN (l_RequestId);
1081: end;
1082:

Line 1128: --bug 3199481 fnd logging changes: sdixit: start block

1124: commit;
1125: --
1126: EXCEPTION
1127: WHEN OTHERS THEN
1128: --bug 3199481 fnd logging changes: sdixit: start block
1129: --WriteToLogFile( 'Error Submitting Output Reports' );
1130: --standard way to handle when-others as per FND logging guidelines
1131:
1132: IF ( l_unexp_level >= l_debug_level ) THEN

Line 1130: --standard way to handle when-others as per FND logging guidelines

1126: EXCEPTION
1127: WHEN OTHERS THEN
1128: --bug 3199481 fnd logging changes: sdixit: start block
1129: --WriteToLogFile( 'Error Submitting Output Reports' );
1130: --standard way to handle when-others as per FND logging guidelines
1131:
1132: IF ( l_unexp_level >= l_debug_level ) THEN
1133:
1134: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

Line 1137: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.ReportQutput',TRUE);

1133:
1134: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1135: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1136: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1137: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.ReportQutput',TRUE);
1138: END IF;
1139: --bug 3199481 fnd logging changes: sdixit: end block
1140: RAISE;
1141: end;

Line 1139: --bug 3199481 fnd logging changes: sdixit: end block

1135: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1136: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1137: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.ReportQutput',TRUE);
1138: END IF;
1139: --bug 3199481 fnd logging changes: sdixit: end block
1140: RAISE;
1141: end;
1142:
1143: PROCEDURE ReportCBR

Line 1223: FND_LOG.STRING (l_proc_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1219: --
1220: -- Variables set by parameters passed through from post procedure
1221: --
1222: IF (l_proc_level>= l_debug_level ) THEN
1223: FND_LOG.STRING (l_proc_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1224: 'Start procedure IGIRCABJP.ReportCBR');
1225: END IF;
1226:
1227: l_Report.GlDateFrom := GetStartDate( p_PeriodFrom, p_setofBooksid );

Line 1270: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1266: THEN l_report.ReqId := 0;
1267: END IF;
1268:
1269: IF (l_state_level >= l_debug_level ) THEN
1270: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1271: ' ConcRequestID '|| l_Report.ReqID );
1272: END IF;
1273:
1274: --

Line 1294: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1290:
1291: IF l_Report.CashSetOfBooksId is null THEN
1292:
1293: IF (l_state_level >= l_debug_level ) THEN
1294: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1295: 'Accrual Set Of books '|| p_SetOfBooksID );
1296: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1297: 'Cash Set of Books ID is not input');
1298: END IF;

Line 1296: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1292:
1293: IF (l_state_level >= l_debug_level ) THEN
1294: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1295: 'Accrual Set Of books '|| p_SetOfBooksID );
1296: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1297: 'Cash Set of Books ID is not input');
1298: END IF;
1299:
1300: errbuf := 'Cash Set of Books Parameter is not input';

Line 1320: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1316: , l_Report.NxtCustTrxLineGlDistId
1317: FROM dual;
1318:
1319: IF (l_state_level >= l_debug_level ) THEN
1320: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1321: '----------------BEGIN PARAMETERS-----------------------------------');
1322: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1323: ' NxtCashReceiptHistoryId '|| l_Report.NxtCashReceiptHistoryId );
1324: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

Line 1322: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1318:
1319: IF (l_state_level >= l_debug_level ) THEN
1320: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1321: '----------------BEGIN PARAMETERS-----------------------------------');
1322: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1323: ' NxtCashReceiptHistoryId '|| l_Report.NxtCashReceiptHistoryId );
1324: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1325: ' NxtReceivableApplicationId '|| l_Report.NxtReceivableApplicationId );
1326: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

Line 1324: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1320: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1321: '----------------BEGIN PARAMETERS-----------------------------------');
1322: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1323: ' NxtCashReceiptHistoryId '|| l_Report.NxtCashReceiptHistoryId );
1324: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1325: ' NxtReceivableApplicationId '|| l_Report.NxtReceivableApplicationId );
1326: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1327: ' NxtMiscCashDistributionId '|| l_Report.NxtMiscCashDistributionId );
1328: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

Line 1326: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1322: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1323: ' NxtCashReceiptHistoryId '|| l_Report.NxtCashReceiptHistoryId );
1324: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1325: ' NxtReceivableApplicationId '|| l_Report.NxtReceivableApplicationId );
1326: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1327: ' NxtMiscCashDistributionId '|| l_Report.NxtMiscCashDistributionId );
1328: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1329: ' NxtAdjustmentId '|| l_Report.NxtAdjustmentId );
1330: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

Line 1328: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1324: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1325: ' NxtReceivableApplicationId '|| l_Report.NxtReceivableApplicationId );
1326: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1327: ' NxtMiscCashDistributionId '|| l_Report.NxtMiscCashDistributionId );
1328: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1329: ' NxtAdjustmentId '|| l_Report.NxtAdjustmentId );
1330: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1331: ' NxtCustTrxLineGlDistId '|| l_Report.NxtCustTrxLineGlDistId );
1332: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

Line 1330: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1326: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1327: ' NxtMiscCashDistributionId '|| l_Report.NxtMiscCashDistributionId );
1328: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1329: ' NxtAdjustmentId '|| l_Report.NxtAdjustmentId );
1330: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1331: ' NxtCustTrxLineGlDistId '|| l_Report.NxtCustTrxLineGlDistId );
1332: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1333: ' Posted Status '||p_PostedStatus);
1334: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

Line 1332: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1328: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1329: ' NxtAdjustmentId '|| l_Report.NxtAdjustmentId );
1330: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1331: ' NxtCustTrxLineGlDistId '|| l_Report.NxtCustTrxLineGlDistId );
1332: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1333: ' Posted Status '||p_PostedStatus);
1334: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1335: ' ----------------END PARAMETERS-----------------------------------');
1336: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

Line 1334: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1330: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1331: ' NxtCustTrxLineGlDistId '|| l_Report.NxtCustTrxLineGlDistId );
1332: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1333: ' Posted Status '||p_PostedStatus);
1334: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1335: ' ----------------END PARAMETERS-----------------------------------');
1336: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1337: ' l_Report.GlDateFrom '|| l_Report.GlDateFrom );
1338:

Line 1336: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1332: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1333: ' Posted Status '||p_PostedStatus);
1334: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1335: ' ----------------END PARAMETERS-----------------------------------');
1336: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1337: ' l_Report.GlDateFrom '|| l_Report.GlDateFrom );
1338:
1339: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1340: ' l_Report.GlDateTo '|| l_Report.GlDateTo );

Line 1339: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1335: ' ----------------END PARAMETERS-----------------------------------');
1336: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1337: ' l_Report.GlDateFrom '|| l_Report.GlDateFrom );
1338:
1339: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1340: ' l_Report.GlDateTo '|| l_Report.GlDateTo );
1341:
1342: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1343: ' l_Report.SetOfBooksId '|| l_Report.SetOfBooksId );

Line 1342: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1338:
1339: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1340: ' l_Report.GlDateTo '|| l_Report.GlDateTo );
1341:
1342: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1343: ' l_Report.SetOfBooksId '|| l_Report.SetOfBooksId );
1344:
1345: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1346: ' l_Report.CashSetOfBooksId '|| l_Report.CashSetOfBooksId );

Line 1345: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1341:
1342: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1343: ' l_Report.SetOfBooksId '|| l_Report.SetOfBooksId );
1344:
1345: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1346: ' l_Report.CashSetOfBooksId '|| l_Report.CashSetOfBooksId );
1347:
1348: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1349: ' l_Report.StartPeriod '|| l_Report.StartPeriod );

Line 1348: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1344:
1345: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1346: ' l_Report.CashSetOfBooksId '|| l_Report.CashSetOfBooksId );
1347:
1348: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1349: ' l_Report.StartPeriod '|| l_Report.StartPeriod );
1350:
1351: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1352: ' l_Report.EndPeriod '|| l_Report.EndPeriod );

Line 1351: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1347:
1348: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1349: ' l_Report.StartPeriod '|| l_Report.StartPeriod );
1350:
1351: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1352: ' l_Report.EndPeriod '|| l_Report.EndPeriod );
1353:
1354: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1355: ' l_Report.Currency '|| l_Report.Currency );

Line 1354: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1350:
1351: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1352: ' l_Report.EndPeriod '|| l_Report.EndPeriod );
1353:
1354: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1355: ' l_Report.Currency '|| l_Report.Currency );
1356:
1357: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1358: ' l_Report.FuncCurr '|| l_Report.FuncCurr );

Line 1357: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1353:
1354: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1355: ' l_Report.Currency '|| l_Report.Currency );
1356:
1357: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1358: ' l_Report.FuncCurr '|| l_Report.FuncCurr );
1359:
1360: END IF;
1361:

Line 1377: FND_LOG.STRING (l_state_level ,'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1373: ;
1374: END IF;
1375:
1376: IF (l_state_level >= l_debug_level ) THEN
1377: FND_LOG.STRING (l_state_level ,'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1378: 'Synchronize AR data with ARC data -> IGIRCBID.prepare');
1379: END IF;
1380:
1381: /* Commented below code for bug 6647672 */

Line 1387: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1383: l_Report.SetOfBooksId, l_Report.CashSetOfBooksId); */
1384:
1385:
1386: IF (l_state_level >= l_debug_level ) THEN
1387: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1388: 'Get accrual data into IGI_AR_JOURNAL_INTERIM ');
1389: END IF;
1390:
1391: IF l_Report.PostedDateFrom IS NULL THEN

Line 1405: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1401: Report( l_Report ); -- Get Accrual Data
1402: l_accrual_ct := CountInterimJournals ( l_Report.reqid );
1403:
1404: IF (l_state_level >= l_debug_level ) THEN
1405: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1406: 'Number of records processed Primary Ledger (accrual) is '||to_char(l_accrual_ct) );
1407: END IF;
1408:
1409: /* Commented below code for bug 6647672 */

Line 1417: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1413: l_cash_ct := CountInterimJournals ( l_Report.reqid );
1414: l_cash_ct := l_cash_ct - l_accrual_ct;
1415:
1416: IF (l_state_level >= l_debug_level ) THEN
1417: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1418: 'Number of records processed Secondary Ledger (Cash) is '||to_char(l_cash_ct) );
1419: END IF; */
1420:
1421: IF (l_state_level >= l_debug_level ) THEN

Line 1422: FND_LOG.STRING (l_state_level ,'igi.plsql.igircajb.IGIRCABJP.ReportCBR','');

1418: 'Number of records processed Secondary Ledger (Cash) is '||to_char(l_cash_ct) );
1419: END IF; */
1420:
1421: IF (l_state_level >= l_debug_level ) THEN
1422: FND_LOG.STRING (l_state_level ,'igi.plsql.igircajb.IGIRCABJP.ReportCBR','');
1423: FND_LOG.STRING (l_state_level ,'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1424: 'Create data into CBR interface table -> IGI_CBR_ARC_INTERFACE_PKG.Insert_rows');
1425: END IF;
1426:

Line 1423: FND_LOG.STRING (l_state_level ,'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1419: END IF; */
1420:
1421: IF (l_state_level >= l_debug_level ) THEN
1422: FND_LOG.STRING (l_state_level ,'igi.plsql.igircajb.IGIRCABJP.ReportCBR','');
1423: FND_LOG.STRING (l_state_level ,'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1424: 'Create data into CBR interface table -> IGI_CBR_ARC_INTERFACE_PKG.Insert_rows');
1425: END IF;
1426:
1427:

Line 1431: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1427:
1428: IGI_CBR_ARC_INTERFACE_PKG.Insert_Rows (l_Report.reqid, l_Report.CashSetOfBooksId);
1429:
1430: IF (l_state_level >= l_debug_level ) THEN
1431: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1432: 'Submit the Reports');
1433: END IF;
1434:
1435: ReportOutput (l_Report);

Line 1438: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',

1434:
1435: ReportOutput (l_Report);
1436:
1437: IF (l_state_level >= l_debug_level ) THEN
1438: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1439: 'Delete records from IGI_AR_JOURNAL_INTERIM (IF not debug)');
1440: END IF;
1441:
1442:

Line 1469: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.ReportCBR',TRUE);

1465:
1466: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1467: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1468: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1469: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.ReportCBR',TRUE);
1470: END IF;
1471:
1472: RAISE;
1473: END;

Line 1478: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1474: BEGIN
1475:
1476: DebugMode := FALSE;
1477:
1478: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1479: l_state_level := FND_LOG.LEVEL_STATEMENT;
1480: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
1481: l_event_level := FND_LOG.LEVEL_EVENT;
1482: l_excep_level := FND_LOG.LEVEL_EXCEPTION;

Line 1479: l_state_level := FND_LOG.LEVEL_STATEMENT;

1475:
1476: DebugMode := FALSE;
1477:
1478: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1479: l_state_level := FND_LOG.LEVEL_STATEMENT;
1480: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
1481: l_event_level := FND_LOG.LEVEL_EVENT;
1482: l_excep_level := FND_LOG.LEVEL_EXCEPTION;
1483: l_error_level := FND_LOG.LEVEL_ERROR;

Line 1480: l_proc_level := FND_LOG.LEVEL_PROCEDURE;

1476: DebugMode := FALSE;
1477:
1478: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1479: l_state_level := FND_LOG.LEVEL_STATEMENT;
1480: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
1481: l_event_level := FND_LOG.LEVEL_EVENT;
1482: l_excep_level := FND_LOG.LEVEL_EXCEPTION;
1483: l_error_level := FND_LOG.LEVEL_ERROR;
1484: l_unexp_level := FND_LOG.LEVEL_UNEXPECTED;

Line 1481: l_event_level := FND_LOG.LEVEL_EVENT;

1477:
1478: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1479: l_state_level := FND_LOG.LEVEL_STATEMENT;
1480: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
1481: l_event_level := FND_LOG.LEVEL_EVENT;
1482: l_excep_level := FND_LOG.LEVEL_EXCEPTION;
1483: l_error_level := FND_LOG.LEVEL_ERROR;
1484: l_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
1485:

Line 1482: l_excep_level := FND_LOG.LEVEL_EXCEPTION;

1478: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1479: l_state_level := FND_LOG.LEVEL_STATEMENT;
1480: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
1481: l_event_level := FND_LOG.LEVEL_EVENT;
1482: l_excep_level := FND_LOG.LEVEL_EXCEPTION;
1483: l_error_level := FND_LOG.LEVEL_ERROR;
1484: l_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
1485:
1486: END IGIRCABJP;

Line 1483: l_error_level := FND_LOG.LEVEL_ERROR;

1479: l_state_level := FND_LOG.LEVEL_STATEMENT;
1480: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
1481: l_event_level := FND_LOG.LEVEL_EVENT;
1482: l_excep_level := FND_LOG.LEVEL_EXCEPTION;
1483: l_error_level := FND_LOG.LEVEL_ERROR;
1484: l_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
1485:
1486: END IGIRCABJP;

Line 1484: l_unexp_level := FND_LOG.LEVEL_UNEXPECTED;

1480: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
1481: l_event_level := FND_LOG.LEVEL_EVENT;
1482: l_excep_level := FND_LOG.LEVEL_EXCEPTION;
1483: l_error_level := FND_LOG.LEVEL_ERROR;
1484: l_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
1485:
1486: END IGIRCABJP;