DBA Data[Home] [Help]

APPS.FV_GEN_ARTRX_REIMB_PROC dependencies on FV_UTILITY

Line 139: fv_utility.log_mesg('Parameters: ');

135:
136:
137: BEGIN
138:
139: fv_utility.log_mesg('Parameters: ');
140: fv_utility.log_mesg('p_period_name: '||p_period_name);
141:
142: g_org_id := mo_global.get_current_org_id;
143:

Line 140: fv_utility.log_mesg('p_period_name: '||p_period_name);

136:
137: BEGIN
138:
139: fv_utility.log_mesg('Parameters: ');
140: fv_utility.log_mesg('p_period_name: '||p_period_name);
141:
142: g_org_id := mo_global.get_current_org_id;
143:
144: fv_utility.log_mesg('Org Id: '||g_org_id);

Line 144: fv_utility.log_mesg('Org Id: '||g_org_id);

140: fv_utility.log_mesg('p_period_name: '||p_period_name);
141:
142: g_org_id := mo_global.get_current_org_id;
143:
144: fv_utility.log_mesg('Org Id: '||g_org_id);
145:
146: g_period_name := p_period_name;
147: g_invoice_date :=fnd_date.canonical_to_date(p_invoice_date);
148:

Line 161: fv_utility.log_mesg('period year: '||g_period_year);

157: WHERE application_id = 101
158: AND set_of_books_id = g_ledger_id
159: AND period_name = g_period_name;
160:
161: fv_utility.log_mesg('period year: '||g_period_year);
162: fv_utility.log_mesg('period num: '||g_period_num);
163: fv_utility.log_mesg('p_invoice_date: '||p_invoice_date);
164: fv_utility.log_mesg('Ledger: '||g_ledger_name);
165: fv_utility.log_mesg('-----------------------------');

Line 162: fv_utility.log_mesg('period num: '||g_period_num);

158: AND set_of_books_id = g_ledger_id
159: AND period_name = g_period_name;
160:
161: fv_utility.log_mesg('period year: '||g_period_year);
162: fv_utility.log_mesg('period num: '||g_period_num);
163: fv_utility.log_mesg('p_invoice_date: '||p_invoice_date);
164: fv_utility.log_mesg('Ledger: '||g_ledger_name);
165: fv_utility.log_mesg('-----------------------------');
166:

Line 163: fv_utility.log_mesg('p_invoice_date: '||p_invoice_date);

159: AND period_name = g_period_name;
160:
161: fv_utility.log_mesg('period year: '||g_period_year);
162: fv_utility.log_mesg('period num: '||g_period_num);
163: fv_utility.log_mesg('p_invoice_date: '||p_invoice_date);
164: fv_utility.log_mesg('Ledger: '||g_ledger_name);
165: fv_utility.log_mesg('-----------------------------');
166:
167: select CHART_OF_ACCOUNTS_ID

Line 164: fv_utility.log_mesg('Ledger: '||g_ledger_name);

160:
161: fv_utility.log_mesg('period year: '||g_period_year);
162: fv_utility.log_mesg('period num: '||g_period_num);
163: fv_utility.log_mesg('p_invoice_date: '||p_invoice_date);
164: fv_utility.log_mesg('Ledger: '||g_ledger_name);
165: fv_utility.log_mesg('-----------------------------');
166:
167: select CHART_OF_ACCOUNTS_ID
168: into g_coa_id

Line 165: fv_utility.log_mesg('-----------------------------');

161: fv_utility.log_mesg('period year: '||g_period_year);
162: fv_utility.log_mesg('period num: '||g_period_num);
163: fv_utility.log_mesg('p_invoice_date: '||p_invoice_date);
164: fv_utility.log_mesg('Ledger: '||g_ledger_name);
165: fv_utility.log_mesg('-----------------------------');
166:
167: select CHART_OF_ACCOUNTS_ID
168: into g_coa_id
169: from gl_ledgers

Line 172: fv_utility.log_mesg('g_coa_id: '||g_coa_id);

168: into g_coa_id
169: from gl_ledgers
170: where ledger_id = g_ledger_id;
171:
172: fv_utility.log_mesg('g_coa_id: '||g_coa_id);
173:
174:
175: BEGIN
176: SELECT REC_DUE_TRANSACTION_TYPE_ID,

Line 216: FV_UTILITY.get_segment_col_names(g_coa_id,

212: -- exception
213: BEGIN
214: log(C_STATE_LEVEL, l_module, 'bfy segment: '||g_bfy_segment);
215: -- finding the Account and Balancing segments
216: FV_UTILITY.get_segment_col_names(g_coa_id,
217: g_gl_nat_acc_segment,
218: g_gl_balancing_segment,
219: l_error_code,
220: l_error_message);

Line 507: --fv_utility.log_mesg('To be billed: '||l_amt_not_billed);

503: --Check if there are any advances. If there are advances and l_amt_not_billed
504: --greater than the advances, create ar trx for the advance amount, then create
505: --ar trx for l_amt_not_billed less advance amount
506: IF l_amt_not_billed > 0 THEN
507: --fv_utility.log_mesg('To be billed: '||l_amt_not_billed);
508: ---if there is advance
509: IF ABS(g_tot_advances) <> 0 THEN
510: ---if difference of expenses and revenues is greater than advance
511: IF ABS(g_tot_advances) <= l_amt_not_billed THEN

Line 954: fv_utility.log_mesg('Ar Transaction: '||g_coll_hdr_tbl(1).trx_number);

950: SELECT g_liq_adv_prefix||fv_gen_coll_ar_trx_s.nextval
951: INTO g_coll_hdr_tbl(1).trx_number
952: FROM DUAL;
953:
954: fv_utility.log_mesg('Ar Transaction: '||g_coll_hdr_tbl(1).trx_number);
955:
956: --Transaction type defined for Liquidate Advance in the
957: --define Federal options Form. FV_OPERATING_UNITS_ALL
958:

Line 982: fv_utility.log_mesg('Ar Transaction: '||g_rec_hdr_tbl(1).trx_number);

978: SELECT g_rec_due_prefix||fv_gen_rec_ar_trx_s.nextval
979: INTO g_rec_hdr_tbl(1).trx_number
980: FROM DUAL;
981:
982: fv_utility.log_mesg('Ar Transaction: '||g_rec_hdr_tbl(1).trx_number);
983:
984: --Transaction type defined for Receivables Due in the
985: --define Federal options Form. FV_OPERATING_UNITS_ALL
986: