DBA Data[Home] [Help]

APPS.AP_ACCTG_PAY_DIST_PKG dependencies on FND_LOG_MESSAGES

Line 46: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

42: l_when_to_account_gain_loss ap_system_parameters_all.when_to_account_gain_loss%TYPE;
43:
44: -- Logging Infra:
45: l_procedure_name CONSTANT VARCHAR2(30) := 'Update_Gain_Loss_Ind';
46: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
47: CURSOR gain_loss_cur( p_payment_history_id NUMBER, p_accounting_event_id NUMBER )
48: IS
49: SELECT SUM( NVL( aphd.paid_base_amount, 0 ) ) inv_pay_amt
50: , SUM( NVL( aphd.invoice_dist_base_amount, 0 ) ) inv_amt

Line 320: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

316: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;
317:
318: -- Logging Infra:
319: l_procedure_name CONSTANT VARCHAR2(30) := 'Primary_Pay_Events';
320: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
321:
322: -- bug fix 6674279
323: b_generate_pay_dist BOOLEAN;
324: l_sum_per_event NUMBER;

Line 1188: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1184: --Bug 8524600
1185: l_cross_txn_amt NUMBER; --bug 9936620
1186: -- Logging Infra:
1187: l_procedure_name CONSTANT VARCHAR2(30) := 'Manual_Pay_Adj_Events';
1188: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1189:
1190: BEGIN
1191:
1192: l_curr_calling_sequence := 'AP_ACCTG_PAY_DIST_PKG.Manual_Pay_Adj_Events<-' ||

Line 1559: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1555: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
1556:
1557: -- Logging Infra:
1558: l_procedure_name CONSTANT VARCHAR2(30) := 'Cancel_Primary_Pay_Events';
1559: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1560:
1561: BEGIN
1562:
1563: l_curr_calling_sequence := 'AP_ACCTG_PAY_DIST_PKG.Cancel_Primary_Pay_Events<-' ||

Line 1745: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1741: AND AIP.REVERSAL_INV_PMT_ID IS NULL; --bug 9005225
1742:
1743: -- Logging Infra:
1744: l_procedure_name CONSTANT VARCHAR2(30) := 'Pay_Dist_Cascade_Adj_Events';
1745: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1746:
1747:
1748: BEGIN
1749:

Line 2596: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2592: --Bug 9282465 end
2593: l_inv_adj_amount NUMBER := 0; --bug 9495429
2594: -- Logging Infra:
2595: l_procedure_name CONSTANT VARCHAR2(30) := 'Pay_Dist_Proc';
2596: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2597:
2598: BEGIN
2599:
2600: l_curr_calling_sequence := 'AP_ACCTG_PAY_DIST_PKG.Pay_Dist_Proc<- ' ||

Line 3822: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3818: l_pd_rec AP_PAYMENT_HIST_DISTS%ROWTYPE;
3819:
3820: -- Logging Infra:
3821: l_procedure_name CONSTANT VARCHAR2(30) := 'Pay_Dist_Discount';
3822: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3823: l_total_dist_amount NUMBER; -- Added for bug 7577312
3824:
3825: BEGIN
3826:

Line 4265: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4261: l_pd_rec AP_PAYMENT_HIST_DISTS%ROWTYPE;
4262:
4263: -- Logging Infra:
4264: l_procedure_name CONSTANT VARCHAR2(30) := 'Pay_Dist_ERV';
4265: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4266:
4267: BEGIN
4268:
4269:

Line 4459: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4455: ORDER BY Amount; /* Bug13385106 */
4456:
4457: -- Logging Infra:
4458: l_procedure_name CONSTANT VARCHAR2(30) := 'Pay_Dist_Err_Chrg';
4459: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4460:
4461:
4462: BEGIN
4463:

Line 4666: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4662: l_curr_calling_sequence VARCHAR2(2000);
4663:
4664: -- Logging Infra:
4665: l_procedure_name CONSTANT VARCHAR2(30) := 'Pay_Dist_Reverse';
4666: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4667:
4668: l_transaction_type AP_PAYMENT_HISTORY_ALL.TRANSACTION_TYPE%TYPE;
4669: l_payment_history_id AP_PAYMENT_HISTORY_ALL.PAYMENT_HISTORY_ID%TYPE;
4670: l_accounting_event_id AP_PAYMENT_HISTORY_ALL.ACCOUNTING_EVENT_ID%TYPE;

Line 5272: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

5268: l_curr_calling_sequence VARCHAR2(2000);
5269:
5270: -- Logging Infra:
5271: l_procedure_name CONSTANT VARCHAR2(30) := 'Pay_Dist_Insert';
5272: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5273:
5274:
5275: BEGIN
5276:

Line 5397: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

5393: l_curr_calling_sequence VARCHAR2(2000);
5394:
5395: -- Logging Infra:
5396: l_procedure_name CONSTANT VARCHAR2(30) := 'Upg_Dist_Links_Insert';
5397: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5398:
5399:
5400: BEGIN
5401: