DBA Data[Home] [Help]

APPS.AP_INVOICE_LINES_PKG dependencies on AP_INVOICE_LINES_PKG

Line 1: PACKAGE BODY AP_INVOICE_LINES_PKG as

1: PACKAGE BODY AP_INVOICE_LINES_PKG as
2: /* $Header: apinlinb.pls 120.109.12020000.4 2012/11/23 12:03:45 cmaredup ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_INVOICE_LINES_PKG';
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_INVOICE_LINES_PKG';

1: PACKAGE BODY AP_INVOICE_LINES_PKG as
2: /* $Header: apinlinb.pls 120.109.12020000.4 2012/11/23 12:03:45 cmaredup ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_INVOICE_LINES_PKG';
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
6: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
7: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
8: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

Line 20: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_INVOICE_LINES_PKG.';

16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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

Line 48: X_dist_tab IN OUT NOCOPY AP_INVOICE_LINES_PKG.dist_tab_type,

44: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
45: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
46: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
47: X_line_source IN VARCHAR2,
48: X_dist_tab IN OUT NOCOPY AP_INVOICE_LINES_PKG.dist_tab_type,
49: X_dist_set_total_percent IN NUMBER,
50: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
51: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
52: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,

Line 185: 'AP_INVOICE_LINES_PKG.generate_dist_tab_for_dist_set<-'

181:
182: -- Update the calling sequence
183: --
184: current_calling_sequence :=
185: 'AP_INVOICE_LINES_PKG.generate_dist_tab_for_dist_set<-'
186: ||X_calling_sequence;
187: l_api_name := 'Generate_Dist_Tab_For_Dist_Set';
188:
189: --Bug 10182226: Populate line base amount.

Line 1256: y_dist_tab AP_INVOICE_LINES_PKG.dist_tab_type;

1252: l_msg_count NUMBER;
1253: l_msg_data VARCHAR2(30);
1254: l_error_code VARCHAR2(4000); --Bug7539216
1255:
1256: y_dist_tab AP_INVOICE_LINES_PKG.dist_tab_type;
1257:
1258: current_calling_sequence VARCHAR2(1000);
1259: debug_info VARCHAR2(2000);
1260: debug_context VARCHAR2(1000);

Line 1266: current_calling_sequence := 'AP_INVOICE_LINES_PKG.insert_from_dist_set<-'

1262:
1263: BEGIN
1264: -- Update the calling sequence
1265: --
1266: current_calling_sequence := 'AP_INVOICE_LINES_PKG.insert_from_dist_set<-'
1267: ||X_calling_sequence;
1268: --------------------------------------------------------------
1269: -- Step 1 - Validate that distribution set was passed or
1270: -- get it from the line IF line already exists.

Line 2068: AP_INVOICE_LINES_PKG.get_max_dist_line_num(

2064: 'N' accrual_posted_flag,
2065: 'U' assets_addition_flag,
2066: tax_dist.assets_tracking_flag assets_tracking_flag, --Bug14772756
2067: 'N' cash_posted_flag,
2068: AP_INVOICE_LINES_PKG.get_max_dist_line_num(
2069: p_line_rec.invoice_id,
2070: tax_dist.invoice_line_number)+1
2071: distribution_line_number,
2072: tax_dist.dist_code_combination_id dist_code_combination_id,

Line 2502: l_curr_calling_sequence := 'AP_INVOICE_LINES_PKG.Discard_Inv_Line <-' ||

2498:
2499:
2500: l_api_name := 'Discard_Inv_Line';
2501:
2502: l_curr_calling_sequence := 'AP_INVOICE_LINES_PKG.Discard_Inv_Line <-' ||
2503: P_calling_sequence;
2504:
2505: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2506: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_INVOICE_LINES_PKG.Discard_Inv_Line(+)');

Line 2506: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_INVOICE_LINES_PKG.Discard_Inv_Line(+)');

2502: l_curr_calling_sequence := 'AP_INVOICE_LINES_PKG.Discard_Inv_Line <-' ||
2503: P_calling_sequence;
2504:
2505: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2506: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_INVOICE_LINES_PKG.Discard_Inv_Line(+)');
2507: END IF;
2508:
2509: -- Added additional columns for bug 8361741
2510: SELECT ai.invoice_type_lookup_code,

Line 2798: if not ap_invoice_lines_pkg.reverse_charge_distributions

2794: l_debug_info := 'Reverse charge distributions';
2795: Print (l_api_name,l_debug_info);
2796: ----------------------------------------------------------------------------
2797:
2798: if not ap_invoice_lines_pkg.reverse_charge_distributions
2799: (p_inv_line_rec => l_chrg_line_rec
2800: ,p_calling_mode => p_calling_mode
2801: ,x_error_code => l_error_code
2802: ,x_debug_info => l_debug_info

Line 4210: l_max_line_num := AP_INVOICE_LINES_PKG.get_max_dist_line_num(

4206:
4207: IF ( l_distribution_count <> 0 ) THEN
4208:
4209: l_debug_info := 'Get the maximum distribution line number';
4210: l_max_line_num := AP_INVOICE_LINES_PKG.get_max_dist_line_num(
4211: p_line_rec.invoice_id,
4212: p_line_rec.line_number);
4213:
4214: -- Bug fix 4748638

Line 5050: 'AP_INVOICE_LINES_PKG.Discard_Inv_Line(-)');

5046: END IF;
5047:
5048: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5049: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
5050: 'AP_INVOICE_LINES_PKG.Discard_Inv_Line(-)');
5051: END IF;
5052:
5053: p_error_code := NULL;
5054: RETURN (TRUE);

Line 5104: l_curr_calling_sequence := 'AP_INVOICE_LINES_PKG.Reverse_Charge_Distributions <-' || p_calling_sequence;

5100: l_api_name := 'Reverse_Charge_Distributions';
5101: ------------------------------------------------------
5102: Print (l_api_name,'Reverse_Charge_Distributions (+)');
5103: ------------------------------------------------------
5104: l_curr_calling_sequence := 'AP_INVOICE_LINES_PKG.Reverse_Charge_Distributions <-' || p_calling_sequence;
5105:
5106: l_max_line_num := AP_INVOICE_LINES_PKG.get_max_dist_line_num
5107: (p_inv_line_rec.invoice_id,
5108: p_inv_line_rec.line_number);

Line 5106: l_max_line_num := AP_INVOICE_LINES_PKG.get_max_dist_line_num

5102: Print (l_api_name,'Reverse_Charge_Distributions (+)');
5103: ------------------------------------------------------
5104: l_curr_calling_sequence := 'AP_INVOICE_LINES_PKG.Reverse_Charge_Distributions <-' || p_calling_sequence;
5105:
5106: l_max_line_num := AP_INVOICE_LINES_PKG.get_max_dist_line_num
5107: (p_inv_line_rec.invoice_id,
5108: p_inv_line_rec.line_number);
5109:
5110: --Bug 8733916

Line 5710: END AP_INVOICE_LINES_PKG;

5706: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||p_api_name,p_debug_info);
5707: END IF;
5708: END Print;
5709:
5710: END AP_INVOICE_LINES_PKG;
5711: