DBA Data[Home] [Help]

APPS.AP_ACCTG_PREPAY_DIST_PKG dependencies on FND_LOG_MESSAGES

Line 38: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

34: l_curr_calling_sequence VARCHAR2(2000);
35:
36: -- Logging Infra:
37: l_procedure_name CONSTANT VARCHAR2(30) := 'Update_Gain_Loss_Ind';
38: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
39: l_gain_loss_indicator ap_prepay_history_all.gain_loss_indicator%type;
40: l_gain_loss_indicator_parent ap_prepay_history_all.gain_loss_indicator%type; -- bug9175969
41: l_reversal_adj VARCHAR2(1);
42:

Line 228: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

224: l_group_number NUMBER;
225:
226: -- Logging:
227: l_procedure_name CONSTANT VARCHAR2(30) := 'Prepay_Hist_Insert';
228: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
229:
230:
231: -- bug9038462,
232: -- 1. changed both parts of the union to ensure

Line 456: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

452:
453:
454: -- Logging Infra:
455: l_procedure_name CONSTANT VARCHAR2(30) := 'Prepay_Dist_Appl';
456: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
457:
458: -- BUG # 7688509
459: -- condition: historical_flag =Y
460: -- and event is 'INVOICE ADJUSTMENT'

Line 1026: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1022: l_prepay_dist_cnt NUMBER;
1023:
1024: -- Logging Infra:
1025: l_procedure_name CONSTANT VARCHAR2(30) := 'Prepay_Dist_Cascade_Adj';
1026: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1027:
1028: -- Bug 6698125. Added adj cursor to get the prepay history record
1029: -- related to prepayment adjustment type events.
1030: CURSOR Prepay_History_Adj

Line 1783: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1779: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;
1780:
1781: -- Logging Infra:
1782: l_procedure_name CONSTANT VARCHAR2(30) := 'Prepay_Dist_Proc';
1783: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1784: l_total_inv_amount NUMBER; --Bug9106549
1785: l_total_awt_amount NUMBER; --Bug9106549
1786:
1787:

Line 2270: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2266: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;
2267:
2268: -- Logging Infra:
2269: l_procedure_name CONSTANT VARCHAR2(30) := 'Prepay_Dist_Tax_Diff';
2270: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2271:
2272:
2273: BEGIN
2274:

Line 2472: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2468: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;
2469:
2470: -- Logging Infra:
2471: l_procedure_name CONSTANT VARCHAR2(30) := 'Prepay_Dist_ERV';
2472: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2473:
2474: BEGIN
2475:
2476:

Line 2643: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2639: l_curr_calling_sequence VARCHAR2(2000);
2640:
2641: -- Logging Infra:
2642: l_procedure_name CONSTANT VARCHAR2(30) := 'Prepay_Dist_Reverse';
2643: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2644:
2645:
2646: BEGIN
2647:

Line 2875: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2871: l_curr_calling_sequence VARCHAR2(2000);
2872:
2873: -- Logging Infra:
2874: l_procedure_name CONSTANT VARCHAR2(30) := 'Prepay_Dist_Insert';
2875: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2876:
2877: BEGIN
2878:
2879: l_curr_calling_sequence := 'AP_ACCTG_PREPAY_DIST_PKG.Prepay_Dist_Insert<- ' ||

Line 3006: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3002: l_curr_calling_sequence VARCHAR2(2000);
3003:
3004: -- Logging Infra:
3005: l_procedure_name CONSTANT VARCHAR2(30) := 'Delete_Hist_Dists';
3006: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3007:
3008: BEGIN
3009:
3010: l_curr_calling_sequence := 'AP_Acctg_Prepay_Dist_Pkg.Delete_hist_dists<- ' ||

Line 3100: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3096: l_curr_calling_sequence VARCHAR2(2000);
3097:
3098: -- Logging Infra:
3099: l_procedure_name CONSTANT VARCHAR2(30) := 'Upg_Dist_Links_Insert';
3100: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3101:
3102:
3103: BEGIN
3104: