19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_INVOICE_LINES_PKG.';
21:
22: --Bug14383132: Start
23: l_user_id ap_invoices_all.created_by%TYPE := FND_GLOBAL.user_id;
24: l_reverse_dist_count NUMBER := 0; --Bug14383132
25: l_sa_reverse_dist_count NUMBER:= 0; --Bug14383132
26:
27: FUNCTION TAX_DISTRIBUTIONS_EXIST
622: X_invoice_lines_rec.set_of_books_id,
623: 'CREATE_COMB_NO_AT',
624: l_unbuilt_flex,
625: l_reason_unbuilt_flex,
626: FND_GLOBAL.RESP_APPL_ID,
627: FND_GLOBAL.RESP_ID,
628: FND_GLOBAL.USER_ID,
629: current_calling_sequence))) then
630: X_error_code := 'AP_ACCOUNT_OVERLAY_INVALID';
623: 'CREATE_COMB_NO_AT',
624: l_unbuilt_flex,
625: l_reason_unbuilt_flex,
626: FND_GLOBAL.RESP_APPL_ID,
627: FND_GLOBAL.RESP_ID,
628: FND_GLOBAL.USER_ID,
629: current_calling_sequence))) then
630: X_error_code := 'AP_ACCOUNT_OVERLAY_INVALID';
631: CLOSE dist_set_lines_cur;
624: l_unbuilt_flex,
625: l_reason_unbuilt_flex,
626: FND_GLOBAL.RESP_APPL_ID,
627: FND_GLOBAL.RESP_ID,
628: FND_GLOBAL.USER_ID,
629: current_calling_sequence))) then
630: X_error_code := 'AP_ACCOUNT_OVERLAY_INVALID';
631: CLOSE dist_set_lines_cur;
632: RETURN(FALSE);
4133: SET amount_paid = nvl(amount_paid,0) - abs(l_recouped_amount) ,
4134: payment_status_flag =
4135: AP_INVOICES_UTILITY_PKG.get_payment_status(p_line_rec.invoice_id ),
4136: last_update_date = SYSDATE,
4137: last_updated_by = fnd_global.user_id,
4138: last_update_login = p_line_rec.last_update_login
4139: WHERE invoice_id = p_line_rec.invoice_id; */
4140:
4141:
4145: p_prepay_line_num => NULL,
4146: p_apply_amount => l_recouped_amount,
4147: p_appl_type => 'UNAPPLICATION',
4148: p_payment_currency_code => l_payment_currency_code,
4149: p_user_id => FND_GLOBAL.user_id,
4150: p_last_update_login => p_line_rec.last_update_login,
4151: p_calling_sequence => p_calling_sequence,
4152: p_calling_mode => 'RECOUPMENT',
4153: p_error_message => l_error_message);
4471: 'N', -- accrual_posted_flag,
4472: 'N', -- cash_posted_flag,
4473: p_Last_Update_Login, -- last_update_login
4474: sysdate, -- creation_date,
4475: FND_GLOBAL.user_id, -- created_by,
4476: -1 * Stat_Amount, -- stat_amount
4477: attribute11, -- attribute11,
4478: attribute12, -- attribute12,
4479: attribute13, -- attribute13,
4504: reference_2, -- reference_2
4505: other_invoice_id, -- other_invoice_id
4506: awt_invoice_id, -- awt_invoice_id
4507: awt_origin_group_id, -- awt_origin_group_id
4508: FND_GLOBAL.prog_appl_id, -- program_application_id
4509: FND_GLOBAL.conc_program_id, -- program_id
4510: SYSDATE, -- program_update_date,
4511: FND_GLOBAL.conc_request_id, -- request_id
4512: tax_recoverable_flag, -- tax_recoverable_flag
4505: other_invoice_id, -- other_invoice_id
4506: awt_invoice_id, -- awt_invoice_id
4507: awt_origin_group_id, -- awt_origin_group_id
4508: FND_GLOBAL.prog_appl_id, -- program_application_id
4509: FND_GLOBAL.conc_program_id, -- program_id
4510: SYSDATE, -- program_update_date,
4511: FND_GLOBAL.conc_request_id, -- request_id
4512: tax_recoverable_flag, -- tax_recoverable_flag
4513: award_id, -- award_id
4507: awt_origin_group_id, -- awt_origin_group_id
4508: FND_GLOBAL.prog_appl_id, -- program_application_id
4509: FND_GLOBAL.conc_program_id, -- program_id
4510: SYSDATE, -- program_update_date,
4511: FND_GLOBAL.conc_request_id, -- request_id
4512: tax_recoverable_flag, -- tax_recoverable_flag
4513: award_id, -- award_id
4514: start_expense_date, -- start_expense_date
4515: merchant_document_number, -- merchant_document_number
4721: AP_EXTENDED_WITHHOLDING_PKG.Ap_Ext_Withholding_Prepay (
4722: p_prepay_dist_id => l_key_value_list3(l_loop_counter),
4723: p_invoice_id => p_line_rec.invoice_id,
4724: p_inv_dist_id => l_key_value_list(l_loop_counter),
4725: p_user_id => fnd_global.user_id,
4726: p_last_update_login => p_last_update_login,
4727: p_calling_sequence => p_calling_sequence );
4728: END IF;
4729:
4886: NULL,
4887: l_unapplied_tax_amt_pay_curr,
4888: 'UNAPPLICATION',
4889: l_payment_currency_code,
4890: FND_GLOBAL.user_id,
4891: p_last_update_login,
4892: p_calling_sequence,
4893: NULL,
4894: l_error_message);
5272: Invoice_Line_Number, -- invoice_line_number
5273: Dist_Code_Combination_Id, -- dist_code_combination_id
5274: ap_invoice_distributions_s.NEXTVAL, -- distribution_id
5275: sysdate, -- last_update_date
5276: fnd_global.user_id, -- last_updated_by
5277: /* Bug 5584997, Getting the accounting_date from line rec */
5278: DECODE(P_calling_mode,'UNAPPLY_PREPAY',p_inv_line_rec.accounting_date,
5279: ap_utilities_pkg.get_reversal_gl_date(p_inv_line_rec.accounting_date, org_id)),
5280: -- accounting_date
5316: DECODE(Pa_Addition_Flag, 'E', 'E', 'R', 'R', 'N'), -- pa_addition_flag bug10012305
5317: DECODE( encumbered_flag, 'R', 'R', 'N'), -- encumbered_flag,
5318: 'N', -- accrual_posted_flag,
5319: 'N', -- cash_posted_flag,
5320: fnd_global.login_id, -- last_update_login
5321: sysdate, -- creation_date,
5322: FND_GLOBAL.user_id, -- created_by,
5323: -1 * Stat_Amount, -- stat_amount
5324: attribute11, -- attribute11,
5318: 'N', -- accrual_posted_flag,
5319: 'N', -- cash_posted_flag,
5320: fnd_global.login_id, -- last_update_login
5321: sysdate, -- creation_date,
5322: FND_GLOBAL.user_id, -- created_by,
5323: -1 * Stat_Amount, -- stat_amount
5324: attribute11, -- attribute11,
5325: attribute12, -- attribute12,
5326: attribute13, -- attribute13,
5351: reference_2, -- reference_2
5352: other_invoice_id, -- other_invoice_id
5353: awt_invoice_id, -- awt_invoice_id
5354: awt_origin_group_id, -- awt_origin_group_id
5355: FND_GLOBAL.prog_appl_id, -- program_application_id
5356: FND_GLOBAL.conc_program_id, -- program_id
5357: SYSDATE, -- program_update_date,
5358: FND_GLOBAL.conc_request_id, -- request_id
5359: tax_recoverable_flag, -- tax_recoverable_flag
5352: other_invoice_id, -- other_invoice_id
5353: awt_invoice_id, -- awt_invoice_id
5354: awt_origin_group_id, -- awt_origin_group_id
5355: FND_GLOBAL.prog_appl_id, -- program_application_id
5356: FND_GLOBAL.conc_program_id, -- program_id
5357: SYSDATE, -- program_update_date,
5358: FND_GLOBAL.conc_request_id, -- request_id
5359: tax_recoverable_flag, -- tax_recoverable_flag
5360: award_id, -- award_id
5354: awt_origin_group_id, -- awt_origin_group_id
5355: FND_GLOBAL.prog_appl_id, -- program_application_id
5356: FND_GLOBAL.conc_program_id, -- program_id
5357: SYSDATE, -- program_update_date,
5358: FND_GLOBAL.conc_request_id, -- request_id
5359: tax_recoverable_flag, -- tax_recoverable_flag
5360: award_id, -- award_id
5361: start_expense_date, -- start_expense_date
5362: merchant_document_number, -- merchant_document_number