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.LNS_DISTRIBUTIONS_PUB dependencies on FND_MESSAGE

Line 149: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACCOUNTING_EVENT_ERROR');

145: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status = ' || l_return_status);
146: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_event_id = ' || l_event_id);
147:
148: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
149: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACCOUNTING_EVENT_ERROR');
150: FND_MSG_PUB.ADD;
151: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153: END IF;

Line 194: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');

190: -- we want to commit ONLY in the case of SUCCESS or ADVISORY
191: if (l_return_status <> 'S') then
192:
193: x_return_status := FND_API.G_RET_STS_ERROR;
194: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
195: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to PSA_BC_XLA_PUB.Budgetary_Control failed with Status Code = ' || l_status_code);
196: FND_MSG_PUB.ADD;
197: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
198: RAISE FND_API.G_EXC_ERROR;

Line 195: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to PSA_BC_XLA_PUB.Budgetary_Control failed with Status Code = ' || l_status_code);

191: if (l_return_status <> 'S') then
192:
193: x_return_status := FND_API.G_RET_STS_ERROR;
194: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
195: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to PSA_BC_XLA_PUB.Budgetary_Control failed with Status Code = ' || l_status_code);
196: FND_MSG_PUB.ADD;
197: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
198: RAISE FND_API.G_EXC_ERROR;
199:

Line 471: FND_MESSAGE.SET_NAME('LNS', 'LNS_CHK_FUND_DISB_INVALID');

467: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || 'l_disbusement_id = ' || l_disbursement_id);
468:
469: -- Bug#6711479 We can't check funds without valid disbursement
470: IF (l_disbursement_id IS NULL) THEN
471: FND_MESSAGE.SET_NAME('LNS', 'LNS_CHK_FUND_DISB_INVALID');
472: FND_MSG_PUB.ADD;
473: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
474: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREATE_DISB_SCHED');
475: FND_MSG_PUB.ADD;

Line 474: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREATE_DISB_SCHED');

470: IF (l_disbursement_id IS NULL) THEN
471: FND_MESSAGE.SET_NAME('LNS', 'LNS_CHK_FUND_DISB_INVALID');
472: FND_MSG_PUB.ADD;
473: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
474: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREATE_DISB_SCHED');
475: FND_MSG_PUB.ADD;
476: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;

Line 514: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACCOUNTING_EVENT_ERROR');

510: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'x_return_status = ' || x_return_status);
511: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'x_event_id ' || x_event_id);
512:
513: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
514: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACCOUNTING_EVENT_ERROR');
515: FND_MSG_PUB.ADD;
516: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END IF;

Line 571: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');

567: -- we want to commit ONLY in the case of SUCCESS or ADVISORY
568: if (l_return_status <> 'S' ) then
569:
570: l_return_status := FND_API.G_RET_STS_ERROR;
571: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
572: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to PSA_BC_XLA_PUB.Budgetary_Control failed with Status Code = ' || l_status_code);
573: FND_MSG_PUB.ADD;
574: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
575: RAISE FND_API.G_EXC_ERROR;

Line 572: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to PSA_BC_XLA_PUB.Budgetary_Control failed with Status Code = ' || l_status_code);

568: if (l_return_status <> 'S' ) then
569:
570: l_return_status := FND_API.G_RET_STS_ERROR;
571: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
572: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to PSA_BC_XLA_PUB.Budgetary_Control failed with Status Code = ' || l_status_code);
573: FND_MSG_PUB.ADD;
574: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
575: RAISE FND_API.G_EXC_ERROR;
576:

Line 580: FND_MESSAGE.SET_NAME('LNS', 'LNS_FUND_CHK_PARTIAL');

576:
577: else
578: if l_status_code NOT IN ('SUCCESS','ADVISORY') then
579: IF (l_status_code = 'PARTIAL') THEN
580: FND_MESSAGE.SET_NAME('LNS', 'LNS_FUND_CHK_PARTIAL');
581: FND_MSG_PUB.ADD;
582: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
583: RAISE FND_API.G_EXC_ERROR;
584: ELSE

Line 585: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');

581: FND_MSG_PUB.ADD;
582: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
583: RAISE FND_API.G_EXC_ERROR;
584: ELSE
585: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
586: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to PSA_BC_XLA_PUB.Budgetary_Control failed with Status Code = ' || l_status_code);
587: FND_MSG_PUB.ADD;
588: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
589: RAISE FND_API.G_EXC_ERROR;

Line 586: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to PSA_BC_XLA_PUB.Budgetary_Control failed with Status Code = ' || l_status_code);

582: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
583: RAISE FND_API.G_EXC_ERROR;
584: ELSE
585: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
586: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to PSA_BC_XLA_PUB.Budgetary_Control failed with Status Code = ' || l_status_code);
587: FND_MSG_PUB.ADD;
588: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
589: RAISE FND_API.G_EXC_ERROR;
590: END IF;

Line 613: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');

609: ,X_MSG_DATA => l_msg_data);
610: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'update loan status = ' || l_return_status);
611:
612: if l_return_status <> 'S' then
613: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
614: FND_MSG_PUB.ADD;
615: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
616: RAISE FND_API.G_EXC_ERROR;
617: end if;

Line 746: FND_MESSAGE.SET_NAME('LNS', 'LNS_DEFAULT_DIST_NOT_FOUND');

742: end loop;
743:
744: else
745:
746: FND_MESSAGE.SET_NAME('LNS', 'LNS_DEFAULT_DIST_NOT_FOUND');
747: FND_MSG_PUB.ADD;
748: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
749: RAISE FND_API.G_EXC_ERROR;
750:

Line 1036: FND_MESSAGE.SET_NAME('LNS', 'LNS_DEFAULT_DIST_NOT_FOUND');

1032: close sql_cur;
1033:
1034: exception
1035: when no_data_found then
1036: FND_MESSAGE.SET_NAME('LNS', 'LNS_DEFAULT_DIST_NOT_FOUND');
1037: FND_MSG_PUB.ADD;
1038: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1039: RAISE FND_API.G_EXC_ERROR;
1040: End; -- c_default_info cursor

Line 1173: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACCOUNTING_EVENT_ERROR');

1169: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_event_id = ' || l_event_id);
1170: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'x_return_status = ' || x_return_status);
1171:
1172: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1173: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACCOUNTING_EVENT_ERROR');
1174: FND_MSG_PUB.ADD;
1175: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: ELSE

Line 1281: FND_MESSAGE.SET_NAME('LNS', 'LNS_MFAR_CONFIGURATION_ERROR');

1277:
1278: Exception
1279: When others then
1280: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'failed to retrieve replacement natural account');
1281: FND_MESSAGE.SET_NAME('LNS', 'LNS_MFAR_CONFIGURATION_ERROR');
1282: FND_MSG_PUB.ADD;
1283: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1284: RAISE FND_API.G_EXC_ERROR;
1285:

Line 1348: FND_MESSAGE.SET_NAME('LNS', 'LNS_ERR_BUILDING_SEGMENTS');

1344: ,p_original_cc_id
1345: ,l_num_segments
1346: ,l_original_segments))
1347: Then
1348: FND_MESSAGE.SET_NAME('LNS', 'LNS_ERR_BUILDING_SEGMENTS');
1349: FND_MSG_PUB.ADD;
1350: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1351: RAISE FND_API.G_EXC_ERROR;
1352: END IF;

Line 1385: FND_MESSAGE.SET_NAME('LNS', 'LNS_CODE_COMBINATION_ERROR');

1381: l_num_segments,
1382: l_new_segments,
1383: l_new_cc_id))
1384: Then
1385: FND_MESSAGE.SET_NAME('LNS', 'LNS_CODE_COMBINATION_ERROR');
1386: FND_MSG_PUB.ADD;
1387: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1388: RAISE FND_API.G_EXC_ERROR;
1389:

Line 1465: FND_MESSAGE.SET_NAME('LNS', 'LNS_MFAR_CONFIGURATION_ERROR');

1461: close c_mfar_nat_acct;
1462:
1463: Exception
1464: When others then
1465: FND_MESSAGE.SET_NAME('LNS', 'LNS_MFAR_CONFIGURATION_ERROR');
1466: FND_MSG_PUB.ADD;
1467: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1468: RAISE FND_API.G_EXC_ERROR;
1469: End;

Line 1481: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_NATURAL_ACCOUNT_SEGMENT');

1477: ,structure_number=> l_ledger_details.chart_of_accounts_id
1478: ,flex_qual_name => 'GL_ACCOUNT'
1479: ,segment_number => l_nat_acct_seg_number))
1480: THEN
1481: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_NATURAL_ACCOUNT_SEGMENT');
1482: FND_MSG_PUB.ADD;
1483: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1484: RAISE FND_API.G_EXC_ERROR;
1485:

Line 1950: FND_MESSAGE.SET_NAME('LNS', 'LNS_LEDGER_DETAILS_FAIL');

1946: return l_ledger_details;
1947:
1948: exception
1949: when others then
1950: FND_MESSAGE.SET_NAME('LNS', 'LNS_LEDGER_DETAILS_FAIL');
1951: FND_MSG_PUB.ADD;
1952: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1953: RAISE FND_API.G_EXC_ERROR;
1954: end;

Line 2578: FND_MESSAGE.Set_Name('LNS', 'LNS_AR_RECEIVABLES_UNACC');

2574: close c_num_receivables_acc;
2575: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'num is: ' || l_num_receivables_acc);
2576:
2577: if l_num_receivables_acc <> l_num_receivables_ers then
2578: FND_MESSAGE.Set_Name('LNS', 'LNS_AR_RECEIVABLES_UNACC');
2579: FND_MSG_PUB.Add;
2580: RAISE FND_API.G_EXC_ERROR;
2581: end if;
2582: */

Line 2588: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_INVALID_RECEIVABLES');

2584: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'comparing origination receivables to billing receivables count');
2585: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan recivables origination Count = ' || l_loan_receivables_orig.count );
2586: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan recivables billing Count = ' || l_loan_receivables_bill.count);
2587: if l_loan_receivables_orig.count <> l_loan_receivables_bill.count then
2588: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_INVALID_RECEIVABLES');
2589: FND_MSG_PUB.Add;
2590: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2591: RAISE FND_API.G_EXC_ERROR;
2592: end if;

Line 2603: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_LOAN_REC_CCIDS_UNMATCH');

2599: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'comparing origination receivables to billing receivables cc_ids');
2600: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan recivables origination cc_id = ' || l_loan_receivables_orig(j).code_combination_id );
2601: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan recivables billing cc_id = ' || l_loan_receivables_bill(j).code_combination_id);
2602: if l_loan_receivables_orig(j).code_combination_id <> l_loan_receivables_bill(j).code_combination_id then
2603: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_LOAN_REC_CCIDS_UNMATCH');
2604: FND_MSG_PUB.Add;
2605: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2606: RAISE FND_API.G_EXC_ERROR;
2607: end if;

Line 2615: FND_MESSAGE.Set_Name('LNS', 'LNS_UNIQUE_CC_IDS');

2611: if (l_loan_receivables_orig(j).code_combination_id = l_loan_receivables_orig(j+1).code_combination_id) OR
2612: (l_loan_clearing_orig(j).code_combination_id = l_loan_clearing_orig(j+1).code_combination_id)
2613: then
2614: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'found duplicate IDs');
2615: FND_MESSAGE.Set_Name('LNS', 'LNS_UNIQUE_CC_IDS');
2616: FND_MSG_PUB.Add;
2617: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2618: RAISE FND_API.G_EXC_ERROR;
2619: end if;

Line 2629: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_LOAN_REC_PER_UNMATCH');

2625: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'comparing origination receivables to billing receivables percentages');
2626: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan recivables origination percent = ' || l_loan_receivables_orig(j).distribution_percent );
2627: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan recivables billing percent = ' || l_loan_receivables_bill(j).distribution_percent);
2628: if l_loan_receivables_orig(j).distribution_percent <> l_loan_receivables_bill(j).distribution_percent then
2629: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_LOAN_REC_PER_UNMATCH');
2630: FND_MSG_PUB.Add;
2631: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2632: RAISE FND_API.G_EXC_ERROR;
2633: end if;

Line 2647: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_ORIG_REC_PER_INVALID');

2643: -- D. The distribution percentage for the Loans Clearing accounts in Origination must add to 100%
2644: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'checking origination receivables total percentages');
2645: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan recivables total percent = ' || l_dist_percent_rec_orig);
2646: if l_dist_percent_rec_orig <> 100 then
2647: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_ORIG_REC_PER_INVALID');
2648: FND_MSG_PUB.Add;
2649: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2650: RAISE FND_API.G_EXC_ERROR;
2651: end if;

Line 2658: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_BILL_REC_PER_INVALID');

2654: /*
2655: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'checking billing receivables total percentages');
2656: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan recivables total percent: ' || l_dist_percent_rec_bill);
2657: if l_dist_percent_rec_bill <> 100 then
2658: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_BILL_REC_PER_INVALID');
2659: FND_MSG_PUB.Add;
2660: RAISE FND_API.G_EXC_ERROR;
2661: end if;
2662: */

Line 2668: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_ORIG_CLR_PER_INVALID');

2664: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'checking origination clearing total percentages');
2665: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan clearing total percent = ' || l_dist_percent_clear_orig);
2666: /*
2667: if l_dist_percent_clear_orig <> 100 then
2668: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_ORIG_CLR_PER_INVALID');
2669: FND_MSG_PUB.Add;
2670: RAISE FND_API.G_EXC_ERROR;
2671: end if;
2672: */

Line 2678: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_MULT_PRIN_RECEIVABLE');

2674: -- account
2675: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'checking principal receivables count');
2676: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'principal receivables count = ' || l_prin_receivables_bill.count);
2677: if l_prin_receivables_bill.count <> 1 then
2678: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_MULT_PRIN_RECEIVABLE');
2679: FND_MSG_PUB.Add;
2680: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2681: RAISE FND_API.G_EXC_ERROR;
2682: end if;

Line 2689: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_MULT_INT_RECEIVABLE');

2685: -- account
2686: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'checking Interest receivables count');
2687: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Interest receivables count = ' || l_int_receivables_bill.count);
2688: if l_int_receivables_bill.count <> 1 then
2689: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_MULT_INT_RECEIVABLE');
2690: FND_MSG_PUB.Add;
2691: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2692: RAISE FND_API.G_EXC_ERROR;
2693: end if;

Line 2699: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_NO_INTEREST_INCOME');

2695: -- I. There may be multiple Interest Income accounts
2696: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'checking Interest Income count');
2697: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Interest Income count = ' || l_int_income_bill.count);
2698: if l_int_income_bill.count < 1 then
2699: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_NO_INTEREST_INCOME');
2700: FND_MSG_PUB.Add;
2701: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2702: RAISE FND_API.G_EXC_ERROR;
2703: end if;

Line 2713: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_INT_INCOME_PER_INVALID');

2709:
2710: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'checking Interest Income percentage');
2711: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Interest Income percentage = ' || l_dist_percent_int_income);
2712: if l_dist_percent_int_income <> 100 then
2713: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_INT_INCOME_PER_INVALID');
2714: FND_MSG_PUB.Add;
2715: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2716: RAISE FND_API.G_EXC_ERROR;
2717: end if;

Line 3532: FND_MESSAGE.SET_NAME('LNS', 'LNS_DEFAULT_DIST_NOT_FOUND');

3528: ,x_msg_data => l_msg_data);
3529:
3530: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_return_status = ' || l_return_status);
3531: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3532: FND_MESSAGE.SET_NAME('LNS', 'LNS_DEFAULT_DIST_NOT_FOUND');
3533: FND_MSG_PUB.ADD;
3534: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3535: RAISE FND_API.G_EXC_ERROR;
3536: end if;

Line 3562: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_SUBSIDY_RATE');

3558: fetch c_subsidy_rate into l_subsidy_rate;
3559: close c_subsidy_rate;
3560: exception
3561: when no_data_found then
3562: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_SUBSIDY_RATE');
3563: FND_MSG_PUB.ADD;
3564: RAISE FND_API.G_EXC_ERROR;
3565: end;
3566:

Line 3584: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');

3580: ,X_MSG_COUNT => l_msg_count
3581: ,X_MSG_DATA => l_msg_data);
3582: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' update loan status = ' || l_return_status);
3583: if l_return_status <> 'S' then
3584: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
3585: FND_MSG_PUB.ADD;
3586: RAISE FND_API.G_EXC_ERROR;
3587: end if;
3588: */

Line 3658: FND_MESSAGE.SET_NAME('LNS', 'LNS_CHK_UPG_FAIL');

3654: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_return_status = ' || l_return_status);
3655: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_upgrade_status = ' || l_upgrade_status);
3656:
3657: if l_return_status <> 'S' then
3658: FND_MESSAGE.SET_NAME('LNS', 'LNS_CHK_UPG_FAIL');
3659: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_trx_number);
3660: FND_MSG_PUB.ADD;
3661: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3662: RAISE FND_API.G_EXC_ERROR;

Line 3659: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_trx_number);

3655: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_upgrade_status = ' || l_upgrade_status);
3656:
3657: if l_return_status <> 'S' then
3658: FND_MESSAGE.SET_NAME('LNS', 'LNS_CHK_UPG_FAIL');
3659: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_trx_number);
3660: FND_MSG_PUB.ADD;
3661: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3662: RAISE FND_API.G_EXC_ERROR;
3663: else

Line 3665: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_TRX');

3661: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3662: RAISE FND_API.G_EXC_ERROR;
3663: else
3664: if l_upgrade_status <> 'Y' then
3665: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_TRX');
3666: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_trx_number);
3667: FND_MSG_PUB.ADD;
3668: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3669: RAISE FND_API.G_EXC_ERROR;

Line 3666: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_trx_number);

3662: RAISE FND_API.G_EXC_ERROR;
3663: else
3664: if l_upgrade_status <> 'Y' then
3665: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_TRX');
3666: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_trx_number);
3667: FND_MSG_PUB.ADD;
3668: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3669: RAISE FND_API.G_EXC_ERROR;
3670: end if;

Line 3729: FND_MESSAGE.SET_NAME('LNS', 'LNS_ONLINE_ACCOUNTING_FAILED');

3725:
3726: l_error_counter := l_error_counter + 1;
3727:
3728: if l_error_counter = 1 then
3729: FND_MESSAGE.SET_NAME('LNS', 'LNS_ONLINE_ACCOUNTING_FAILED');
3730: FND_MSG_PUB.Add;
3731: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3732: end if;
3733:

Line 3734: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACC_DOC_FAIL');

3730: FND_MSG_PUB.Add;
3731: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3732: end if;
3733:
3734: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACC_DOC_FAIL');
3735: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_invoice_number);
3736: FND_MESSAGE.SET_TOKEN('DOC_TYPE', l_entity_code);
3737: FND_MESSAGE.SET_TOKEN('ACC_ERR', l_error_message);
3738: FND_MSG_PUB.Add;

Line 3735: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_invoice_number);

3731: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3732: end if;
3733:
3734: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACC_DOC_FAIL');
3735: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_invoice_number);
3736: FND_MESSAGE.SET_TOKEN('DOC_TYPE', l_entity_code);
3737: FND_MESSAGE.SET_TOKEN('ACC_ERR', l_error_message);
3738: FND_MSG_PUB.Add;
3739: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 3736: FND_MESSAGE.SET_TOKEN('DOC_TYPE', l_entity_code);

3732: end if;
3733:
3734: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACC_DOC_FAIL');
3735: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_invoice_number);
3736: FND_MESSAGE.SET_TOKEN('DOC_TYPE', l_entity_code);
3737: FND_MESSAGE.SET_TOKEN('ACC_ERR', l_error_message);
3738: FND_MSG_PUB.Add;
3739: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3740:

Line 3737: FND_MESSAGE.SET_TOKEN('ACC_ERR', l_error_message);

3733:
3734: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACC_DOC_FAIL');
3735: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_invoice_number);
3736: FND_MESSAGE.SET_TOKEN('DOC_TYPE', l_entity_code);
3737: FND_MESSAGE.SET_TOKEN('ACC_ERR', l_error_message);
3738: FND_MSG_PUB.Add;
3739: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3740:
3741: END LOOP;

Line 3762: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_NATURAL_ACCOUNT_SEGMENT');

3758: ,structure_number=> l_ledger_details.chart_of_accounts_id
3759: ,flex_qual_name => 'GL_ACCOUNT'
3760: ,segment_number => l_nat_acct_seg_number))
3761: THEN
3762: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_NATURAL_ACCOUNT_SEGMENT');
3763: FND_MSG_PUB.ADD;
3764: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3765: RAISE FND_API.G_EXC_ERROR;
3766: END IF;

Line 3806: FND_MESSAGE.SET_NAME('LNS', 'LNS_INHERIT_DIST_NOT_FOUND');

3802: end loop; -- loan clearing loop
3803: exception
3804: when others then
3805: --logMessage(FND_LOG.LEVEL_UNEX, G_PKG_NAME, 'Failed to inherit receivables distributions');
3806: FND_MESSAGE.SET_NAME('LNS', 'LNS_INHERIT_DIST_NOT_FOUND');
3807: FND_MSG_PUB.ADD;
3808: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3809: RAISE FND_API.G_EXC_ERROR;
3810: end;

Line 3884: FND_MESSAGE.SET_NAME('LNS', 'LNS_INHERIT_DIST_NOT_FOUND');

3880:
3881: exception
3882: when others then
3883: -- logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'failed to inherit receivables distributions');
3884: FND_MESSAGE.SET_NAME('LNS', 'LNS_INHERIT_DIST_NOT_FOUND');
3885: FND_MSG_PUB.ADD;
3886: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3887: RAISE FND_API.G_EXC_ERROR;
3888: end;

Line 4040: FND_MESSAGE.SET_NAME('LNS', 'LNS_DEFAULT_DIST_NOT_FOUND');

4036: ,x_msg_data => l_msg_data);
4037:
4038: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_return_status = ' || l_return_status);
4039: if l_return_status <> 'S' then
4040: FND_MESSAGE.SET_NAME('LNS', 'LNS_DEFAULT_DIST_NOT_FOUND');
4041: FND_MSG_PUB.ADD;
4042: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4043: RAISE FND_API.G_EXC_ERROR;
4044: end if;

Line 4251: --FND_MESSAGE.SET_NAME('XLA', 'XLA_ONLINE_ACCT_SUCCESS');

4247: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_accounting_batch_id = ' || l_accounting_batch_id);
4248:
4249: if l_retcode = 0 then
4250:
4251: --FND_MESSAGE.SET_NAME('XLA', 'XLA_ONLINE_ACCT_SUCCESS');
4252: --FND_MSG_PUB.Add;
4253: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'online accounting SUCCESS! ');
4254:
4255: elsif l_retcode = 2 then

Line 4257: FND_MESSAGE.SET_NAME('XLA', 'XLA_ONLINE_ACCTG_ERROR');

4253: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'online accounting SUCCESS! ');
4254:
4255: elsif l_retcode = 2 then
4256:
4257: FND_MESSAGE.SET_NAME('XLA', 'XLA_ONLINE_ACCTG_ERROR');
4258: FND_MSG_PUB.Add;
4259: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4260: RAISE FND_API.G_EXC_ERROR;
4261:

Line 4280: FND_MESSAGE.SET_NAME('XLA', 'XLA_ONLINE_ACCT_WARNING');

4276:
4277: l_error_counter := l_error_counter + 1;
4278:
4279: if l_error_counter = 1 then
4280: FND_MESSAGE.SET_NAME('XLA', 'XLA_ONLINE_ACCT_WARNING');
4281: FND_MSG_PUB.Add;
4282: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4283: end if;
4284:

Line 4285: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACC_DOC_FAIL');

4281: FND_MSG_PUB.Add;
4282: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4283: end if;
4284:
4285: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACC_DOC_FAIL');
4286: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_invoice_number);
4287: FND_MESSAGE.SET_TOKEN('DOC_TYPE', l_entity_code);
4288: FND_MESSAGE.SET_TOKEN('ACC_ERR', l_error_message);
4289: FND_MSG_PUB.Add;

Line 4286: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_invoice_number);

4282: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4283: end if;
4284:
4285: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACC_DOC_FAIL');
4286: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_invoice_number);
4287: FND_MESSAGE.SET_TOKEN('DOC_TYPE', l_entity_code);
4288: FND_MESSAGE.SET_TOKEN('ACC_ERR', l_error_message);
4289: FND_MSG_PUB.Add;
4290: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 4287: FND_MESSAGE.SET_TOKEN('DOC_TYPE', l_entity_code);

4283: end if;
4284:
4285: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACC_DOC_FAIL');
4286: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_invoice_number);
4287: FND_MESSAGE.SET_TOKEN('DOC_TYPE', l_entity_code);
4288: FND_MESSAGE.SET_TOKEN('ACC_ERR', l_error_message);
4289: FND_MSG_PUB.Add;
4290: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4291:

Line 4288: FND_MESSAGE.SET_TOKEN('ACC_ERR', l_error_message);

4284:
4285: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACC_DOC_FAIL');
4286: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_invoice_number);
4287: FND_MESSAGE.SET_TOKEN('DOC_TYPE', l_entity_code);
4288: FND_MESSAGE.SET_TOKEN('ACC_ERR', l_error_message);
4289: FND_MSG_PUB.Add;
4290: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4291:
4292: END LOOP;

Line 4403: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');

4399: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_ID = ' || P_LOAN_ID);
4400: if P_LOAN_ID is null then
4401:
4402: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan must be set.');
4403: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
4404: FND_MSG_PUB.Add;
4405: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4406: RAISE FND_API.G_EXC_ERROR;
4407:

Line 4441: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACCOUNTING_EVENT_ERROR');

4437: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'event_id = ' || x_event_id);
4438: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status = ' || l_return_status);
4439:
4440: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4441: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACCOUNTING_EVENT_ERROR');
4442: FND_MSG_PUB.ADD;
4443: --l_last_api_called := 'LNS_XLA_EVENTS.create_event';
4444: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4541: FND_MESSAGE.SET_NAME('LNS', 'LNS_BILLING_REQUEST_FAILED');

4537: null);
4538:
4539: if l_request_id = 0 then
4540: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4541: FND_MESSAGE.SET_NAME('LNS', 'LNS_BILLING_REQUEST_FAILED');
4542: FND_MSG_PUB.Add;
4543: l_last_api_called := 'FND_REQUEST.SUBMIT_REQUEST for 0th installment billing';
4544: RAISE FND_API.G_EXC_ERROR;
4545: else

Line 4638: FND_MESSAGE.SET_NAME('LNS', 'LNS_DEFAULT_DIST_NOT_FOUND');

4634: ,x_msg_data => l_msg_data);
4635:
4636: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_return_status = ' || l_return_status);
4637: if l_return_status <> 'S' then
4638: FND_MESSAGE.SET_NAME('LNS', 'LNS_DEFAULT_DIST_NOT_FOUND');
4639: FND_MSG_PUB.ADD;
4640: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4641: RAISE FND_API.G_EXC_ERROR;
4642: end if;