eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_APPROVAL_PKG dependencies on AP_APPROVAL_PKG

Line 1: PACKAGE BODY AP_APPROVAL_PKG AS

1: PACKAGE BODY AP_APPROVAL_PKG AS
2: /* $Header: apaprvlb.pls 120.231.12020000.14 2013/03/14 07:44:25 cmaredup ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_APPROVAL_PKG';
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;

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

1: PACKAGE BODY AP_APPROVAL_PKG AS
2: /* $Header: apaprvlb.pls 120.231.12020000.14 2013/03/14 07:44:25 cmaredup ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_APPROVAL_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_APPROVAL_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_APPROVAL_PKG.';
21:
22: /*===========================================================================
23: | Private Global Variable specification
24: *==========================================================================*/

Line 919: l_invoice_rec AP_APPROVAL_PKG.Invoice_Rec;

915: l_recouped_amount NUMBER;
916: l_tolerance_id NUMBER;
917: l_service_tolerance_id NUMBER;
918:
919: l_invoice_rec AP_APPROVAL_PKG.Invoice_Rec;
920:
921: l_api_name CONSTANT VARCHAR2(200) := 'Approve';
922:
923: -- Bug 6648094

Line 948: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;

944: l_zx_lines_det_fac_count NUMBER := 0; -- Bug16390854
945:
946: BEGIN
947:
948: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
949:
950: IF (p_debug_switch = 'Y') THEN
951: g_debug_mode := 'Y';
952: END IF;

Line 954: -- Print_Debug (l_api_name, 'AP_APPROVAL_PKG.APPROVE.BEGIN');

950: IF (p_debug_switch = 'Y') THEN
951: g_debug_mode := 'Y';
952: END IF;
953:
954: -- Print_Debug (l_api_name, 'AP_APPROVAL_PKG.APPROVE.BEGIN');
955: IF g_debug_mode = 'Y' THEN
956: AP_Debug_Pkg.Print(g_debug_mode, 'AP_APPROVAL_PKG.APPROVE.BEGIN' );
957: END IF;
958:

Line 956: AP_Debug_Pkg.Print(g_debug_mode, 'AP_APPROVAL_PKG.APPROVE.BEGIN' );

952: END IF;
953:
954: -- Print_Debug (l_api_name, 'AP_APPROVAL_PKG.APPROVE.BEGIN');
955: IF g_debug_mode = 'Y' THEN
956: AP_Debug_Pkg.Print(g_debug_mode, 'AP_APPROVAL_PKG.APPROVE.BEGIN' );
957: END IF;
958:
959: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
960: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_APPROVAL_PKG.APPROVE.BEGIN');

Line 960: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_APPROVAL_PKG.APPROVE.BEGIN');

956: AP_Debug_Pkg.Print(g_debug_mode, 'AP_APPROVAL_PKG.APPROVE.BEGIN' );
957: END IF;
958:
959: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
960: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_APPROVAL_PKG.APPROVE.BEGIN');
961: END IF;
962:
963:
964: ----------------------------------------------------------------

Line 1251: AP_APPROVAL_PKG.Generate_Distributions

1247: ----------------------------------------------------------------
1248:
1249: --bugfix:6684139/6699825
1250: IF (l_invoice_line_count > 0) THEN
1251: AP_APPROVAL_PKG.Generate_Distributions
1252: (p_invoice_rec => l_invoice_rec,
1253: p_base_currency_code => l_base_currency_code,
1254: p_inv_batch_id => p_invoice_batch_id, /*Bug#7036685 : Passed p_invoice_batch_id to
1255: p_inv_batch_id parameter instead of NULL*/

Line 1296: AP_APPROVAL_PKG.Generate_Manual_Awt_Dist

1292: AND ail.line_type_lookup_code = 'AWT'
1293: AND ail.line_source = 'MANUAL LINE ENTRY';
1294:
1295: IF (l_manual_awt_exist > 0) THEN
1296: AP_APPROVAL_PKG.Generate_Manual_Awt_Dist
1297: (p_invoice_rec => l_invoice_rec,
1298: p_base_currency_code => l_base_currency_code,
1299: p_inv_batch_id => p_invoice_batch_id,
1300: p_run_option => NULL,

Line 1309: AP_APPROVAL_PKG.POPULATE_GDF_FOR_FV

1305: -- Bug 8346277 end
1306: END IF; /* nvl(p_conc_flag, 'N')... */
1307:
1308: --GTAS Project Bug#13464635 Begin
1309: AP_APPROVAL_PKG.POPULATE_GDF_FOR_FV
1310: (p_invoice_id => p_invoice_id,
1311: P_curr_calling_sequence => l_curr_calling_sequence);
1312: --End Bug#13464635
1313:

Line 2511: -- Print_Debug (l_api_name, 'AP_APPROVAL_PKG.APPROVE.END');

2507: COMMIT;
2508: END IF;
2509: END IF;
2510:
2511: -- Print_Debug (l_api_name, 'AP_APPROVAL_PKG.APPROVE.END');
2512: IF g_debug_mode = 'Y' THEN
2513: AP_Debug_Pkg.Print(g_debug_mode, 'AP_APPROVAL_PKG.APPROVE.END' );
2514: END IF;
2515:

Line 2513: AP_Debug_Pkg.Print(g_debug_mode, 'AP_APPROVAL_PKG.APPROVE.END' );

2509: END IF;
2510:
2511: -- Print_Debug (l_api_name, 'AP_APPROVAL_PKG.APPROVE.END');
2512: IF g_debug_mode = 'Y' THEN
2513: AP_Debug_Pkg.Print(g_debug_mode, 'AP_APPROVAL_PKG.APPROVE.END' );
2514: END IF;
2515:
2516: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2517: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_APPROVAL_PKG.APPROVE.END');

Line 2517: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_APPROVAL_PKG.APPROVE.END');

2513: AP_Debug_Pkg.Print(g_debug_mode, 'AP_APPROVAL_PKG.APPROVE.END' );
2514: END IF;
2515:
2516: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2517: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_APPROVAL_PKG.APPROVE.END');
2518: END IF;
2519:
2520: EXCEPTION
2521: --Bug9021265

Line 2711: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||

2707: l_curr_calling_sequence VARCHAR2(2000);
2708: l_debug_info VARCHAR2(1000);
2709: BEGIN
2710:
2711: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
2712: p_calling_sequence;
2713:
2714: -- Select stmt added for bug 6684139
2715: SELECT count(*)

Line 2769: p_set_of_books_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).set_of_books_id;

2765: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2766: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_debug_loc,l_debug_info);
2767: END IF;
2768:
2769: p_set_of_books_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).set_of_books_id;
2770: p_recalc_pay_sched_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).recalc_pay_schedule_flag;
2771: p_sys_xrate_gain_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_gain_ccid;
2772: p_sys_xrate_loss_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_loss_ccid;
2773: p_base_currency_code := AP_APPROVAL_PKG.G_Options_Table(p_org_id).base_currency_code;

Line 2770: p_recalc_pay_sched_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).recalc_pay_schedule_flag;

2766: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_debug_loc,l_debug_info);
2767: END IF;
2768:
2769: p_set_of_books_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).set_of_books_id;
2770: p_recalc_pay_sched_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).recalc_pay_schedule_flag;
2771: p_sys_xrate_gain_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_gain_ccid;
2772: p_sys_xrate_loss_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_loss_ccid;
2773: p_base_currency_code := AP_APPROVAL_PKG.G_Options_Table(p_org_id).base_currency_code;
2774: p_inv_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).inv_encumbrance_type_id;

Line 2771: p_sys_xrate_gain_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_gain_ccid;

2767: END IF;
2768:
2769: p_set_of_books_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).set_of_books_id;
2770: p_recalc_pay_sched_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).recalc_pay_schedule_flag;
2771: p_sys_xrate_gain_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_gain_ccid;
2772: p_sys_xrate_loss_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_loss_ccid;
2773: p_base_currency_code := AP_APPROVAL_PKG.G_Options_Table(p_org_id).base_currency_code;
2774: p_inv_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).inv_encumbrance_type_id;
2775: p_purch_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).purch_encumbrance_type_id;

Line 2772: p_sys_xrate_loss_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_loss_ccid;

2768:
2769: p_set_of_books_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).set_of_books_id;
2770: p_recalc_pay_sched_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).recalc_pay_schedule_flag;
2771: p_sys_xrate_gain_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_gain_ccid;
2772: p_sys_xrate_loss_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_loss_ccid;
2773: p_base_currency_code := AP_APPROVAL_PKG.G_Options_Table(p_org_id).base_currency_code;
2774: p_inv_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).inv_encumbrance_type_id;
2775: p_purch_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).purch_encumbrance_type_id;
2776: p_receipt_acc_days := AP_APPROVAL_PKG.G_Options_Table(p_org_id).receipt_acceptance_days;

Line 2773: p_base_currency_code := AP_APPROVAL_PKG.G_Options_Table(p_org_id).base_currency_code;

2769: p_set_of_books_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).set_of_books_id;
2770: p_recalc_pay_sched_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).recalc_pay_schedule_flag;
2771: p_sys_xrate_gain_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_gain_ccid;
2772: p_sys_xrate_loss_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_loss_ccid;
2773: p_base_currency_code := AP_APPROVAL_PKG.G_Options_Table(p_org_id).base_currency_code;
2774: p_inv_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).inv_encumbrance_type_id;
2775: p_purch_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).purch_encumbrance_type_id;
2776: p_receipt_acc_days := AP_APPROVAL_PKG.G_Options_Table(p_org_id).receipt_acceptance_days;
2777: p_gl_date_from_receipt_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).gl_date_from_receipt_flag;

Line 2774: p_inv_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).inv_encumbrance_type_id;

2770: p_recalc_pay_sched_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).recalc_pay_schedule_flag;
2771: p_sys_xrate_gain_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_gain_ccid;
2772: p_sys_xrate_loss_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_loss_ccid;
2773: p_base_currency_code := AP_APPROVAL_PKG.G_Options_Table(p_org_id).base_currency_code;
2774: p_inv_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).inv_encumbrance_type_id;
2775: p_purch_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).purch_encumbrance_type_id;
2776: p_receipt_acc_days := AP_APPROVAL_PKG.G_Options_Table(p_org_id).receipt_acceptance_days;
2777: p_gl_date_from_receipt_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).gl_date_from_receipt_flag;
2778:

Line 2775: p_purch_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).purch_encumbrance_type_id;

2771: p_sys_xrate_gain_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_gain_ccid;
2772: p_sys_xrate_loss_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_loss_ccid;
2773: p_base_currency_code := AP_APPROVAL_PKG.G_Options_Table(p_org_id).base_currency_code;
2774: p_inv_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).inv_encumbrance_type_id;
2775: p_purch_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).purch_encumbrance_type_id;
2776: p_receipt_acc_days := AP_APPROVAL_PKG.G_Options_Table(p_org_id).receipt_acceptance_days;
2777: p_gl_date_from_receipt_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).gl_date_from_receipt_flag;
2778:
2779: END IF;

Line 2776: p_receipt_acc_days := AP_APPROVAL_PKG.G_Options_Table(p_org_id).receipt_acceptance_days;

2772: p_sys_xrate_loss_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_loss_ccid;
2773: p_base_currency_code := AP_APPROVAL_PKG.G_Options_Table(p_org_id).base_currency_code;
2774: p_inv_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).inv_encumbrance_type_id;
2775: p_purch_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).purch_encumbrance_type_id;
2776: p_receipt_acc_days := AP_APPROVAL_PKG.G_Options_Table(p_org_id).receipt_acceptance_days;
2777: p_gl_date_from_receipt_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).gl_date_from_receipt_flag;
2778:
2779: END IF;
2780:

Line 2777: p_gl_date_from_receipt_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).gl_date_from_receipt_flag;

2773: p_base_currency_code := AP_APPROVAL_PKG.G_Options_Table(p_org_id).base_currency_code;
2774: p_inv_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).inv_encumbrance_type_id;
2775: p_purch_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).purch_encumbrance_type_id;
2776: p_receipt_acc_days := AP_APPROVAL_PKG.G_Options_Table(p_org_id).receipt_acceptance_days;
2777: p_gl_date_from_receipt_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).gl_date_from_receipt_flag;
2778:
2779: END IF;
2780:
2781: p_system_user := 5;

Line 2797: p_price_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).price_tolerance;

2793:
2794: IF p_invoice_type <> 'PAYMENT REQUEST' THEN
2795:
2796: IF p_tolerance_id IS NOT NULL THEN
2797: p_price_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).price_tolerance;
2798: p_qty_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).quantity_tolerance;
2799: p_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).qty_received_tolerance;
2800: p_max_qty_ord_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_ord_tolerance;
2801: p_max_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_rec_tolerance;

Line 2798: p_qty_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).quantity_tolerance;

2794: IF p_invoice_type <> 'PAYMENT REQUEST' THEN
2795:
2796: IF p_tolerance_id IS NOT NULL THEN
2797: p_price_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).price_tolerance;
2798: p_qty_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).quantity_tolerance;
2799: p_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).qty_received_tolerance;
2800: p_max_qty_ord_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_ord_tolerance;
2801: p_max_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_rec_tolerance;
2802: p_goods_ship_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).ship_amt_tolerance;

Line 2799: p_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).qty_received_tolerance;

2795:
2796: IF p_tolerance_id IS NOT NULL THEN
2797: p_price_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).price_tolerance;
2798: p_qty_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).quantity_tolerance;
2799: p_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).qty_received_tolerance;
2800: p_max_qty_ord_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_ord_tolerance;
2801: p_max_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_rec_tolerance;
2802: p_goods_ship_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).ship_amt_tolerance;
2803: p_goods_rate_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).rate_amt_tolerance;

Line 2800: p_max_qty_ord_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_ord_tolerance;

2796: IF p_tolerance_id IS NOT NULL THEN
2797: p_price_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).price_tolerance;
2798: p_qty_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).quantity_tolerance;
2799: p_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).qty_received_tolerance;
2800: p_max_qty_ord_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_ord_tolerance;
2801: p_max_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_rec_tolerance;
2802: p_goods_ship_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).ship_amt_tolerance;
2803: p_goods_rate_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).rate_amt_tolerance;
2804: p_goods_total_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).total_amt_tolerance;

Line 2801: p_max_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_rec_tolerance;

2797: p_price_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).price_tolerance;
2798: p_qty_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).quantity_tolerance;
2799: p_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).qty_received_tolerance;
2800: p_max_qty_ord_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_ord_tolerance;
2801: p_max_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_rec_tolerance;
2802: p_goods_ship_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).ship_amt_tolerance;
2803: p_goods_rate_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).rate_amt_tolerance;
2804: p_goods_total_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).total_amt_tolerance;
2805: END IF;

Line 2802: p_goods_ship_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).ship_amt_tolerance;

2798: p_qty_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).quantity_tolerance;
2799: p_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).qty_received_tolerance;
2800: p_max_qty_ord_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_ord_tolerance;
2801: p_max_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_rec_tolerance;
2802: p_goods_ship_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).ship_amt_tolerance;
2803: p_goods_rate_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).rate_amt_tolerance;
2804: p_goods_total_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).total_amt_tolerance;
2805: END IF;
2806:

Line 2803: p_goods_rate_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).rate_amt_tolerance;

2799: p_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).qty_received_tolerance;
2800: p_max_qty_ord_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_ord_tolerance;
2801: p_max_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_rec_tolerance;
2802: p_goods_ship_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).ship_amt_tolerance;
2803: p_goods_rate_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).rate_amt_tolerance;
2804: p_goods_total_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).total_amt_tolerance;
2805: END IF;
2806:
2807: IF p_services_tolerance_id IS NOT NULL THEN

Line 2804: p_goods_total_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).total_amt_tolerance;

2800: p_max_qty_ord_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_ord_tolerance;
2801: p_max_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_rec_tolerance;
2802: p_goods_ship_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).ship_amt_tolerance;
2803: p_goods_rate_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).rate_amt_tolerance;
2804: p_goods_total_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).total_amt_tolerance;
2805: END IF;
2806:
2807: IF p_services_tolerance_id IS NOT NULL THEN
2808: p_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amount_tolerance;

Line 2808: p_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amount_tolerance;

2804: p_goods_total_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).total_amt_tolerance;
2805: END IF;
2806:
2807: IF p_services_tolerance_id IS NOT NULL THEN
2808: p_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amount_tolerance;
2809: p_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amt_received_tolerance;
2810: p_max_amt_ord_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_ord_tolerance;
2811: p_max_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_rec_tolerance;
2812: p_services_ship_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_ship_amt_tolerance;

Line 2809: p_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amt_received_tolerance;

2805: END IF;
2806:
2807: IF p_services_tolerance_id IS NOT NULL THEN
2808: p_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amount_tolerance;
2809: p_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amt_received_tolerance;
2810: p_max_amt_ord_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_ord_tolerance;
2811: p_max_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_rec_tolerance;
2812: p_services_ship_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_ship_amt_tolerance;
2813: p_services_rate_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_rate_amt_tolerance;

Line 2810: p_max_amt_ord_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_ord_tolerance;

2806:
2807: IF p_services_tolerance_id IS NOT NULL THEN
2808: p_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amount_tolerance;
2809: p_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amt_received_tolerance;
2810: p_max_amt_ord_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_ord_tolerance;
2811: p_max_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_rec_tolerance;
2812: p_services_ship_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_ship_amt_tolerance;
2813: p_services_rate_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_rate_amt_tolerance;
2814: p_services_total_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_total_amt_tolerance;

Line 2811: p_max_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_rec_tolerance;

2807: IF p_services_tolerance_id IS NOT NULL THEN
2808: p_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amount_tolerance;
2809: p_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amt_received_tolerance;
2810: p_max_amt_ord_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_ord_tolerance;
2811: p_max_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_rec_tolerance;
2812: p_services_ship_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_ship_amt_tolerance;
2813: p_services_rate_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_rate_amt_tolerance;
2814: p_services_total_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_total_amt_tolerance;
2815: END IF;

Line 2812: p_services_ship_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_ship_amt_tolerance;

2808: p_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amount_tolerance;
2809: p_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amt_received_tolerance;
2810: p_max_amt_ord_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_ord_tolerance;
2811: p_max_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_rec_tolerance;
2812: p_services_ship_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_ship_amt_tolerance;
2813: p_services_rate_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_rate_amt_tolerance;
2814: p_services_total_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_total_amt_tolerance;
2815: END IF;
2816:

Line 2813: p_services_rate_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_rate_amt_tolerance;

2809: p_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amt_received_tolerance;
2810: p_max_amt_ord_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_ord_tolerance;
2811: p_max_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_rec_tolerance;
2812: p_services_ship_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_ship_amt_tolerance;
2813: p_services_rate_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_rate_amt_tolerance;
2814: p_services_total_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_total_amt_tolerance;
2815: END IF;
2816:
2817: END IF;

Line 2814: p_services_total_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_total_amt_tolerance;

2810: p_max_amt_ord_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_ord_tolerance;
2811: p_max_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_rec_tolerance;
2812: p_services_ship_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_ship_amt_tolerance;
2813: p_services_rate_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_rate_amt_tolerance;
2814: p_services_total_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_total_amt_tolerance;
2815: END IF;
2816:
2817: END IF;
2818:

Line 2868: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||

2864: l_debug_info VARCHAR2(1000);
2865: l_api_name CONSTANT VARCHAR2(200) := 'Approval_Init';
2866: BEGIN
2867:
2868: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
2869: p_calling_sequence;
2870:
2871: l_undistributed_line_exists := 'N';
2872:

Line 2962: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||

2958: l_curr_calling_sequence VARCHAR2(2000);
2959: l_debug_info VARCHAR2(1000);
2960: BEGIN
2961:
2962: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
2963: p_calling_sequence;
2964:
2965: IF (p_run_option = 'New') THEN
2966:

Line 3093: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||

3089: l_dummy VARCHAR2(100);
3090:
3091: BEGIN
3092:
3093: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||
3094: '<-'||p_calling_sequence;
3095:
3096: p_insufficient_data_exist := FALSE;
3097:

Line 3272: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||

3268: l_err varchar2(2000);
3269:
3270: BEGIN
3271:
3272: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
3273: p_curr_calling_sequence;
3274:
3275: ----------------------------------------------------------------------
3276: l_debug_info := 'Input Parameters: '||' invoice id: ' ||p_inv_line_rec.invoice_id

Line 3790: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||

3786: l_vendor_site_reg_expired varchar2(1);
3787:
3788: BEGIN
3789:
3790: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
3791: p_calling_sequence;
3792:
3793: ---------------------------------------------------
3794: l_debug_info := 'Execute_General_Checks: '

Line 4098: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||

4094: l_debug_info VARCHAR2(1000);
4095:
4096: BEGIN
4097:
4098: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
4099: p_calling_sequence;
4100:
4101: IF (g_debug_mode = 'Y') THEN
4102: l_debug_info := 'General check - check invalid dist account';

Line 4247: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||

4243: l_debug_info VARCHAR2(1000);
4244:
4245: BEGIN
4246:
4247: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
4248: p_calling_sequence;
4249:
4250: OPEN PO_Required_Cur;
4251: FETCH PO_Required_Cur INTO l_test_var;

Line 4347: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||

4343: l_debug_info VARCHAR2(1000);
4344:
4345: BEGIN
4346:
4347: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
4348: p_calling_sequence;
4349:
4350: OPEN No_Rate_Cur;
4351: FETCH No_Rate_Cur INTO l_test_var;

Line 4445: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||

4441: l_debug_info VARCHAR2(1000);
4442:
4443: BEGIN
4444:
4445: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
4446: p_calling_sequence;
4447:
4448: -- bug 9468749
4449: PA_AP_VAL_PKG.validate_unprocessed_ded(p_invoice_id , l_proj_comm );

Line 4587: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||

4583: l_dist_count NUMBER;
4584:
4585: BEGIN
4586:
4587: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||
4588: '<-'||p_calling_sequence;
4589:
4590:
4591: l_dist_count := 0;

Line 4715: l_curr_calling_sequence := 'AP_APPROVAL_PKG.CHECK_CCR_VENDOR <-'||p_calling_sequence;

4711: l_api_name CONSTANT VARCHAR2(200) := 'CHECK_CCR_VENDOR';
4712:
4713:
4714: Begin
4715: l_curr_calling_sequence := 'AP_APPROVAL_PKG.CHECK_CCR_VENDOR <-'||p_calling_sequence;
4716:
4717: l_debug_info := 'Before checking vendor is a CCR registered or not ';
4718:
4719: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4896: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||

4892: l_return_message VARCHAR2(1000); --bug 7271262
4893:
4894: BEGIN
4895:
4896: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||
4897: '<-'||p_calling_sequence;
4898:
4899: p_line_variance_hold_exist := FALSE;
4900: l_line_count := 0;

Line 5051: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||

5047: l_invoice_type AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE; --Bug#10416960
5048:
5049: BEGIN
5050:
5051: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||
5052: '<-'||p_calling_sequence;
5053:
5054: -----------------------------------------------------
5055: l_debug_info := 'Update Invoice Lines Base Amount';

Line 5155: l_base_amt := AP_APPROVAL_PKG.get_adjusted_base_amount(

5151: AND line_number = l_round_inv_line_numbers(i);
5152:
5153: -- get the calculated adjusted base amount and rounding amount
5154: -- get rounding amount for the next line if required
5155: l_base_amt := AP_APPROVAL_PKG.get_adjusted_base_amount(
5156: p_base_amount => l_base_amt,
5157: p_rounding_amt => l_modified_line_rounding_amt,
5158: p_next_line_rounding_amt => l_rounded_amt,
5159: p_amount => l_amt); -- Bug 12686348

Line 5245: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||

5241: l_amt NUMBER; -- Bug 12686348
5242:
5243: BEGIN
5244:
5245: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||
5246: '<-'||p_calling_sequence;
5247:
5248: ------------------------------------------------------
5249: l_debug_info := 'Update Distribution Base Amounts';

Line 5321: l_base_amt := AP_APPROVAL_PKG.get_adjusted_base_amount(

5317: AND invoice_distribution_id = l_round_dist_id_list(i);
5318:
5319: -- get the calculated adjusted base amount and rounding amount
5320: -- get rounding amount for the next dist, if required
5321: l_base_amt := AP_APPROVAL_PKG.get_adjusted_base_amount(
5322: p_base_amount => l_base_amt,
5323: p_rounding_amt => l_modified_dist_rounding_amt,
5324: p_next_line_rounding_amt => l_rounded_amt,
5325: p_amount => l_amt); -- Bug 12686348

Line 5397: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||

5393: l_debug_info VARCHAR2(1000);
5394:
5395: BEGIN
5396:
5397: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
5398: p_calling_sequence;
5399:
5400: -------------------------------------------------
5401: l_debug_info := 'Accounting Event Generation';

Line 5540: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||

5536: l_curr_calling_sequence VARCHAR2(2000);
5537:
5538: BEGIN
5539:
5540: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||
5541: '<-'||p_calling_sequence;
5542:
5543: OPEN Prepay_Var_Cur;
5544: LOOP

Line 5662: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||

5658:
5659: BEGIN
5660:
5661:
5662: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||
5663: '<-'||p_calling_sequence;
5664: /*-----------------------------------------------------------------+
5665: | Check invoice amount limit |
5666: +-----------------------------------------------------------------*/

Line 5817: l_curr_calling_sequence := 'AP_APPROVAL_PKG.Check_Manual_AWT_Segments'||'<-'

5813:
5814:
5815: BEGIN
5816:
5817: l_curr_calling_sequence := 'AP_APPROVAL_PKG.Check_Manual_AWT_Segments'||'<-'
5818: ||p_calling_sequence;
5819:
5820: OPEN c_manual_awt_dist_segs;
5821: LOOP

Line 5889: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||

5885: l_debug_info VARCHAR2(1000);
5886:
5887: BEGIN
5888:
5889: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
5890: p_calling_sequence;
5891:
5892: SELECT count(*)
5893: INTO l_matched_count

Line 5989: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;

5985: l_withhold_date_basis VARCHAR2(20); -- bug 9293773
5986:
5987: BEGIN
5988:
5989: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
5990:
5991: l_withhold_error_exists := 'N';
5992:
5993: ----------------------------------------------------

Line 6245: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||

6241:
6242: BEGIN
6243:
6244:
6245: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
6246: p_calling_sequence;
6247:
6248: ------------------------------------------------------------
6249: l_debug_info := 'Set selected dists match_status_flag to tested';

Line 6437: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||

6433: l_curr_calling_sequence VARCHAR2(2000);
6434: l_debug_info VARCHAR2(1000);
6435: BEGIN
6436:
6437: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
6438: p_calling_sequence;
6439:
6440: l_debug_info := 'p_hold_lookup_code,p_should_have_hold,p_hold_reason,p_system_user '||p_hold_lookup_code||','||p_should_have_hold||','||p_hold_reason||','||p_system_user;
6441: -- Print_Debug(l_debug_loc, l_debug_info);

Line 6621: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;

6617: BEGIN
6618:
6619: -- Update the calling sequence --
6620:
6621: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
6622:
6623: p_status := 'NOT ON HOLD';
6624:
6625: if g_holds_tab.count > 0 then

Line 6733: l_current_calling_sequence := 'AP_APPROVAL_PKG.UPDATE_SCHEDULES <- '|| p_calling_sequence;

6729: l_current_calling_sequence VARCHAR2(2000);
6730: l_debug_info VARCHAR2(1000);
6731:
6732: BEGIN
6733: l_current_calling_sequence := 'AP_APPROVAL_PKG.UPDATE_SCHEDULES <- '|| p_calling_sequence;
6734:
6735: l_debug_info := 'Begin UPDATE_SCHEDULES procedure';
6736: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6737: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

Line 6882: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||

6878: l_old_wf_status AP_HOLDS_ALL.WF_STATUS%TYPE ; -- Bug 8323412
6879: l_hold_id AP_HOLDS_ALL.HOLD_ID%TYPE ; -- Bug 8323412
6880: BEGIN
6881:
6882: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
6883: p_calling_sequence;
6884:
6885: -------------------------------------------
6886: l_debug_info := 'Getting Release Info For Hold';

Line 7069: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||

7065: l_org_id NUMBER(15); --8691645
7066:
7067: BEGIN
7068:
7069: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
7070: p_calling_sequence;
7071:
7072: -------------------------------------------
7073: l_debug_info := 'Inserting Into AP_HOLDS';

Line 7274: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||

7270: l_curr_calling_sequence VARCHAR2(2000);
7271: l_debug_info VARCHAR2(1000);
7272: BEGIN
7273:
7274: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
7275: p_calling_sequence;
7276:
7277: FOR num IN 1..100 LOOP
7278:

Line 7336: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||

7332: l_debug_info VARCHAR2(1000);
7333: invalid_hold EXCEPTION;
7334: BEGIN
7335:
7336: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
7337: p_calling_sequence;
7338:
7339: -------------------------------------------
7340: l_debug_info := 'Check hold_code to retrieve release code';

Line 7542: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||

7538: l_curr_calling_sequence VARCHAR2(2000);
7539: l_debug_info VARCHAR2(1000);
7540: BEGIN
7541:
7542: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
7543: p_calling_sequence;
7544:
7545: -------------------------------------------
7546: l_debug_info := 'Retrieving new invoice statuses';

Line 7736: l_curr_calling_sequence := 'AP_APPROVAL_PKG.Exclude_Tax_From_Discount<-'||P_curr_calling_sequence;

7732: l_prepay_excl_tax_amt number;
7733: BEGIN
7734:
7735: l_debug_loc := 'Exclude_Tax_Freight_From_Disc';
7736: l_curr_calling_sequence := 'AP_APPROVAL_PKG.Exclude_Tax_From_Discount<-'||P_curr_calling_sequence;
7737:
7738: l_payment_status := 'N';
7739: l_prepayment_app_exists := 'N';
7740: l_total_amount_positive := 'N';

Line 8364: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;

8360: -- AP_LOGGING_PKG.AP_Begin_Block(l_debug_loc);
8361:
8362: -- Update the calling sequence --
8363:
8364: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
8365:
8366: -- Initialize local variables
8367: -- BUG 4340061 : For the lines which have been already been validated but the invoice has been placed on hold.
8368:

Line 8484: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;

8480: l_wt_amt_to_subtract NUMBER := 0;
8481: BEGIN
8482:
8483:
8484: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
8485:
8486:
8487: SELECT (0 - sum(nvl(amount,0)))
8488: INTO l_automatic_awt_amount

Line 8595: l_curr_calling_sequence := 'AP_APPROVAL_PKG.createPaymentSchedules <- '||P_calling_sequence;

8591: l_curr_calling_sequence VARCHAR2(2000);
8592:
8593: BEGIN
8594:
8595: l_curr_calling_sequence := 'AP_APPROVAL_PKG.createPaymentSchedules <- '||P_calling_sequence;
8596:
8597: select count(*)
8598: into l_schedule_count
8599: from ap_payment_schedules_all

Line 9245: l_invoice_rec AP_APPROVAL_PKG.Invoice_Rec;

9241: l_calling_sequence VARCHAR2(20);
9242:
9243: l_retained_amount NUMBER;
9244: l_recouped_amount NUMBER;
9245: l_invoice_rec AP_APPROVAL_PKG.Invoice_Rec;
9246: l_invoice_date AP_INVOICES.invoice_date%TYPE;
9247: l_invoice_currency_code AP_INVOICES.invoice_currency_code%TYPE;
9248: l_exchange_rate AP_INVOICES.exchange_rate%TYPE;
9249: l_exchange_rate_type AP_INVOICES.exchange_rate_type%TYPE;

Line 9280: AND I.validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID

9276: FROM ap_invoices_all I,
9277: ap_supplier_sites_all S,
9278: ap_system_parameters_all ASP --Bug8524767
9279: WHERE I.vendor_site_id = S.vendor_site_id (+)
9280: AND I.validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID
9281: AND ASP.org_id = I.org_id
9282: ORDER BY I.org_id;
9283:
9284: --Bug9436217

Line 9285: l_selected_invoices_cursor AP_APPROVAL_PKG.Invoices_Table;

9281: AND ASP.org_id = I.org_id
9282: ORDER BY I.org_id;
9283:
9284: --Bug9436217
9285: l_selected_invoices_cursor AP_APPROVAL_PKG.Invoices_Table;
9286: l_blk_err_dist varchar2(1):='N';
9287: --Bug9436217
9288:
9289: l_api_name CONSTANT VARCHAR2(200) := 'Batch_Approval';

Line 9296: WHERE I.validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID

9292: --bug7902867 cusror modified removed ap_supplier_sites_all in join
9293: CURSOR SELC_INV_CURSOR_BULK_ERROR IS
9294: SELECT I.invoice_id, i.invoice_num, i.org_id
9295: FROM ap_invoices_all I
9296: WHERE I.validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID
9297: ORDER BY I.org_id;
9298:
9299: TYPE selc_inv_cursor_blk_err is table of selc_inv_cursor_bulk_error%rowtype;
9300:

Line 9361: -- Print_Debug(l_api_name, 'AP_APPROVAL_PKG.BATCH_APPROVAL.BEGIN');

9357: g_debug_mode := 'Y';
9358: END IF;
9359:
9360: ---------------------------------------------------------------------
9361: -- Print_Debug(l_api_name, 'AP_APPROVAL_PKG.BATCH_APPROVAL.BEGIN');
9362: IF g_debug_mode = 'Y' THEN
9363: AP_Debug_Pkg.Print(g_debug_mode, 'AP_APPROVAL_PKG.BATCH_APPROVAL.BEGIN' );
9364: END IF;
9365:

Line 9363: AP_Debug_Pkg.Print(g_debug_mode, 'AP_APPROVAL_PKG.BATCH_APPROVAL.BEGIN' );

9359:
9360: ---------------------------------------------------------------------
9361: -- Print_Debug(l_api_name, 'AP_APPROVAL_PKG.BATCH_APPROVAL.BEGIN');
9362: IF g_debug_mode = 'Y' THEN
9363: AP_Debug_Pkg.Print(g_debug_mode, 'AP_APPROVAL_PKG.BATCH_APPROVAL.BEGIN' );
9364: END IF;
9365:
9366: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
9367: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_APPROVAL_PKG.BATCH_APPROVAL.BEGIN');

Line 9367: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_APPROVAL_PKG.BATCH_APPROVAL.BEGIN');

9363: AP_Debug_Pkg.Print(g_debug_mode, 'AP_APPROVAL_PKG.BATCH_APPROVAL.BEGIN' );
9364: END IF;
9365:
9366: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
9367: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_APPROVAL_PKG.BATCH_APPROVAL.BEGIN');
9368: END IF;
9369: ---------------------------------------------------------------------
9370:
9371: ap_approval_pkg.g_validation_request_id := p_conc_request_id;

Line 9371: ap_approval_pkg.g_validation_request_id := p_conc_request_id;

9367: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_APPROVAL_PKG.BATCH_APPROVAL.BEGIN');
9368: END IF;
9369: ---------------------------------------------------------------------
9370:
9371: ap_approval_pkg.g_validation_request_id := p_conc_request_id;
9372: g_org_holds.delete;
9373:
9374: ---------------------------------------------------------------------
9375: -- Print_Debug(l_api_name, 'Setting null input parameters');

Line 9448: AP_Approval_PKG.Cache_Options(l_curr_calling_sequence);

9444: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
9445: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Cache System Options');
9446: END IF;
9447: ---------------------------------------------------------------------
9448: AP_Approval_PKG.Cache_Options(l_curr_calling_sequence);
9449:
9450:
9451: IF (l_invoice_id <> -1) THEN
9452:

Line 9599: AP_APPROVAL_PKG.Generate_Distributions

9595: l_invoice_rec.org_id := l_org_id;
9596: g_org_id := l_org_id;
9597:
9598:
9599: AP_APPROVAL_PKG.Generate_Distributions
9600: (p_invoice_rec => l_invoice_rec,
9601: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_org_id).base_currency_code,
9602: p_inv_batch_id => p_inv_batch_id,
9603: p_run_option => p_run_option,

Line 9601: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_org_id).base_currency_code,

9597:
9598:
9599: AP_APPROVAL_PKG.Generate_Distributions
9600: (p_invoice_rec => l_invoice_rec,
9601: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_org_id).base_currency_code,
9602: p_inv_batch_id => p_inv_batch_id,
9603: p_run_option => p_run_option,
9604: p_calling_sequence => l_curr_calling_sequence,
9605: x_error_code => l_error_code);

Line 9665: AP_APPROVAL_PKG.Generate_Manual_Awt_Dist

9661: AND ail.line_type_lookup_code = 'AWT'
9662: AND ail.line_source = 'MANUAL LINE ENTRY';
9663:
9664: IF (l_manual_awt_exist > 0) THEN
9665: AP_APPROVAL_PKG.Generate_Manual_Awt_Dist
9666: (p_invoice_rec => l_invoice_rec,
9667: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_org_id).base_currency_code,
9668: p_inv_batch_id => p_inv_batch_id,
9669: p_run_option => p_run_option,

Line 9667: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_org_id).base_currency_code,

9663:
9664: IF (l_manual_awt_exist > 0) THEN
9665: AP_APPROVAL_PKG.Generate_Manual_Awt_Dist
9666: (p_invoice_rec => l_invoice_rec,
9667: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_org_id).base_currency_code,
9668: p_inv_batch_id => p_inv_batch_id,
9669: p_run_option => p_run_option,
9670: p_calling_sequence => l_curr_calling_sequence,
9671: x_error_code => l_error_code,

Line 9677: AP_APPROVAL_PKG.APPROVE(

9673: END IF;
9674: -- Bug 11830074 end
9675:
9676: --Removed the hardcoded value of p_budget_control, bug6356402
9677: AP_APPROVAL_PKG.APPROVE(
9678: '',
9679: '',
9680: '',
9681: '',

Line 10046: SET validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID

10042: --Bug9436217
10043:
10044: FORALL k IN 1..l_selected_invoice_ids.COUNT
10045: UPDATE ap_invoices_all
10046: SET validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID
10047: WHERE invoice_id = l_selected_invoice_ids(k)
10048: AND validation_request_id IS NULL;
10049:
10050: --Bug9436217

Line 10072: SAVEPOINT AP_APPROVAL_PKG_SP_ETAX;

10068: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Calculate Tax');
10069: END IF;
10070: ---------------------------------------------------------------------
10071:
10072: SAVEPOINT AP_APPROVAL_PKG_SP_ETAX;
10073:
10074: --bug 9738293
10075: --Changed the calling method for Bulk tax calulation . ETAX API will be called till there is no
10076: -- error in ZX error table or they return success.

Line 10114: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_ETAX;

10110: BULK COLLECT INTO l_r_inv_err;
10111: CLOSE r_inv_err;
10112:
10113:
10114: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_ETAX;
10115:
10116:
10117: FORALL i in 1..l_r_inv_err.count
10118: Update ap_invoices_all set validation_request_id = NULL where invoice_id = l_r_inv_err(i);

Line 10125: SAVEPOINT AP_APPROVAL_PKG_SP_ETAX; --bug10140354 Added Savepoint

10121: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
10122: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' Rows updated ' || sql%rowcount);
10123: END IF ;
10124:
10125: SAVEPOINT AP_APPROVAL_PKG_SP_ETAX; --bug10140354 Added Savepoint
10126:
10127:
10128: l_conc_status := 'WARNING';
10129:

Line 10149: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_ETAX;

10145: --bug 9738293
10146:
10147: IF (NOT l_success) THEN -- Marker 1
10148:
10149: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_ETAX;
10150:
10151: -- Moved logging inside IF
10152: FND_FILE.PUT_LINE(FND_FILE.LOG,'(SERIAL CALCULATE) START SYSDATE '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')); --Bug16390854
10153:

Line 10192: SAVEPOINT AP_APPROVAL_PKG_SP_INV;

10188: --Bug9436217
10189:
10190: LOOP
10191:
10192: SAVEPOINT AP_APPROVAL_PKG_SP_INV;
10193:
10194: --Bug9436217
10195: BEGIN
10196: mo_global.set_policy_context('S', l_selected_invoices_cursor(i).org_id);

Line 10265: AP_APPROVAL_PKG.Generate_Distributions

10261:
10262: --Bug9436217
10263:
10264:
10265: AP_APPROVAL_PKG.Generate_Distributions
10266: (p_invoice_rec => l_invoice_rec,
10267: --Bug9436217
10268: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_selected_invoices_cursor(i).org_id).base_currency_code,
10269: --Bug9436217

Line 10268: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_selected_invoices_cursor(i).org_id).base_currency_code,

10264:
10265: AP_APPROVAL_PKG.Generate_Distributions
10266: (p_invoice_rec => l_invoice_rec,
10267: --Bug9436217
10268: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_selected_invoices_cursor(i).org_id).base_currency_code,
10269: --Bug9436217
10270: p_inv_batch_id => p_inv_batch_id,
10271: p_run_option => p_run_option,
10272: p_calling_sequence => l_curr_calling_sequence,

Line 10341: AP_APPROVAL_PKG.Generate_Manual_Awt_Dist

10337: AND ail.line_type_lookup_code = 'AWT'
10338: AND ail.line_source = 'MANUAL LINE ENTRY';
10339:
10340: IF (l_manual_awt_exist > 0) THEN
10341: AP_APPROVAL_PKG.Generate_Manual_Awt_Dist
10342: (p_invoice_rec => l_selected_invoices_cursor(i),
10343: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_selected_invoices_cursor(i).org_id).base_currency_code,
10344: p_inv_batch_id => p_inv_batch_id,
10345: p_run_option => p_run_option,

Line 10343: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_selected_invoices_cursor(i).org_id).base_currency_code,

10339:
10340: IF (l_manual_awt_exist > 0) THEN
10341: AP_APPROVAL_PKG.Generate_Manual_Awt_Dist
10342: (p_invoice_rec => l_selected_invoices_cursor(i),
10343: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_selected_invoices_cursor(i).org_id).base_currency_code,
10344: p_inv_batch_id => p_inv_batch_id,
10345: p_run_option => p_run_option,
10346: p_calling_sequence => l_curr_calling_sequence,
10347: x_error_code => l_error_code,

Line 10352: AP_APPROVAL_PKG.APPROVE(

10348: p_calling_mode => l_calling_mode);
10349: END IF;
10350: -- Bug 11830074 end
10351: --Removed the hardcoded value of p_budget_control, bug6356402
10352: AP_APPROVAL_PKG.APPROVE(
10353: '',
10354: '',
10355: '',
10356: '',

Line 10397: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_INV;

10393:
10394: EXCEPTION
10395: WHEN TAX_EXCEPTION_HANDLED THEN
10396:
10397: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_INV;
10398:
10399: ap_utilities_pkg.ap_get_message(l_approval_error);
10400: fnd_file.put_line (fnd_file.log, ' ');
10401: --Bug9436217

Line 10423: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_INV;

10419:
10420:
10421: WHEN OTHERS THEN
10422:
10423: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_INV;
10424:
10425: ap_utilities_pkg.ap_get_message(l_approval_error);
10426: fnd_file.put_line (fnd_file.log, ' ');
10427: --Bug9436217

Line 10452: WHERE validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID;

10448: --Bug9436217
10449:
10450: UPDATE ap_invoices_all
10451: SET validation_request_id = NULL
10452: WHERE validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID;
10453:
10454:
10455:
10456: CLOSE SELECTED_INVOICES_CURSOR;

Line 10521: BULK COLLECT INTO AP_APPROVAL_PKG.G_SELECTED_INVOICES

10517:
10518: OPEN SELECTED_INVOICES_CURSOR;
10519: LOOP
10520: FETCH SELECTED_INVOICES_CURSOR
10521: BULK COLLECT INTO AP_APPROVAL_PKG.G_SELECTED_INVOICES
10522: LIMIT l_commit_size;
10523:
10524: EXIT WHEN SELECTED_INVOICES_CURSOR%NOTFOUND
10525: AND AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT <= 0;

Line 10525: AND AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT <= 0;

10521: BULK COLLECT INTO AP_APPROVAL_PKG.G_SELECTED_INVOICES
10522: LIMIT l_commit_size;
10523:
10524: EXIT WHEN SELECTED_INVOICES_CURSOR%NOTFOUND
10525: AND AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT <= 0;
10526:
10527: FOR i IN 1..AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT
10528: LOOP
10529: -- Set Policy

Line 10527: FOR i IN 1..AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT

10523:
10524: EXIT WHEN SELECTED_INVOICES_CURSOR%NOTFOUND
10525: AND AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT <= 0;
10526:
10527: FOR i IN 1..AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT
10528: LOOP
10529: -- Set Policy
10530: IF AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id <> nvl(l_old_org_id, -3115) THEN
10531:

Line 10530: IF AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id <> nvl(l_old_org_id, -3115) THEN

10526:
10527: FOR i IN 1..AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT
10528: LOOP
10529: -- Set Policy
10530: IF AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id <> nvl(l_old_org_id, -3115) THEN
10531:
10532: mo_global.set_policy_context
10533: ('S', AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id);
10534:

Line 10533: ('S', AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id);

10529: -- Set Policy
10530: IF AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id <> nvl(l_old_org_id, -3115) THEN
10531:
10532: mo_global.set_policy_context
10533: ('S', AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id);
10534:
10535: l_old_org_id := AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id;
10536:
10537: END IF;

Line 10535: l_old_org_id := AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id;

10531:
10532: mo_global.set_policy_context
10533: ('S', AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id);
10534:
10535: l_old_org_id := AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id;
10536:
10537: END IF;
10538:
10539: -- Initialize Invoice Holds Array

Line 10541: p_invoice_id => AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_id,

10537: END IF;
10538:
10539: -- Initialize Invoice Holds Array
10540: Initialize_Invoice_Holds(
10541: p_invoice_id => AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_id,
10542: p_calling_sequence => l_curr_calling_sequence);
10543:
10544: g_org_id := AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id;
10545:

Line 10544: g_org_id := AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id;

10540: Initialize_Invoice_Holds(
10541: p_invoice_id => AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_id,
10542: p_calling_sequence => l_curr_calling_sequence);
10543:
10544: g_org_id := AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id;
10545:
10546: AP_APPROVAL_PKG.Generate_Distributions
10547: (p_invoice_rec => AP_APPROVAL_PKG.G_SELECTED_INVOICES(i),
10548: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(g_org_id).base_currency_code,

Line 10546: AP_APPROVAL_PKG.Generate_Distributions

10542: p_calling_sequence => l_curr_calling_sequence);
10543:
10544: g_org_id := AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id;
10545:
10546: AP_APPROVAL_PKG.Generate_Distributions
10547: (p_invoice_rec => AP_APPROVAL_PKG.G_SELECTED_INVOICES(i),
10548: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(g_org_id).base_currency_code,
10549: p_inv_batch_id => p_inv_batch_id,
10550: p_run_option => p_run_option,

Line 10547: (p_invoice_rec => AP_APPROVAL_PKG.G_SELECTED_INVOICES(i),

10543:
10544: g_org_id := AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id;
10545:
10546: AP_APPROVAL_PKG.Generate_Distributions
10547: (p_invoice_rec => AP_APPROVAL_PKG.G_SELECTED_INVOICES(i),
10548: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(g_org_id).base_currency_code,
10549: p_inv_batch_id => p_inv_batch_id,
10550: p_run_option => p_run_option,
10551: p_calling_sequence => l_curr_calling_sequence,

Line 10548: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(g_org_id).base_currency_code,

10544: g_org_id := AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id;
10545:
10546: AP_APPROVAL_PKG.Generate_Distributions
10547: (p_invoice_rec => AP_APPROVAL_PKG.G_SELECTED_INVOICES(i),
10548: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(g_org_id).base_currency_code,
10549: p_inv_batch_id => p_inv_batch_id,
10550: p_run_option => p_run_option,
10551: p_calling_sequence => l_curr_calling_sequence,
10552: x_error_code => l_error_code);

Line 10556: AP_APPROVAL_PKG.G_SELECTED_INVOICES.DELETE;

10552: x_error_code => l_error_code);
10553:
10554: END LOOP;
10555:
10556: AP_APPROVAL_PKG.G_SELECTED_INVOICES.DELETE;
10557:
10558: END LOOP;
10559: CLOSE SELECTED_INVOICES_CURSOR;
10560:

Line 10572: SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;

10568: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Generate Tax Distributions');
10569: END IF;
10570: ---------------------------------------------------------------------
10571:
10572: SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;
10573:
10574: --bug 9738293
10575: --Changed the calling method for Bulk tax distributions . ETAX API will be called till there is no
10576: -- error in ZX error table or they return success.

Line 10607: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST ;

10603: BULK COLLECT INTO l_r_inv_err;
10604: CLOSE r_inv_err;
10605:
10606:
10607: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST ;
10608:
10609: FORALL i in 1..l_r_inv_err.count
10610: Update ap_invoices_all set validation_request_id = NULL where invoice_id = l_r_inv_err(i);
10611:

Line 10617: SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST; --bug10140354 Added Savepoint

10613: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
10614: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' Rows updated ' || sql%rowcount);
10615: END IF ;
10616:
10617: SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST; --bug10140354 Added Savepoint
10618:
10619:
10620:
10621: l_conc_status := 'WARNING';

Line 10641: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;

10637: --bug 9738293
10638:
10639: IF (NOT l_success) THEN -- Marker 3
10640:
10641: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;
10642:
10643: ---------------------------------------------------------------------
10644: -- Print_Debug (l_api_name, 'Set Concurrent Request Warning');
10645: IF g_debug_mode = 'Y' THEN

Line 10688: SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;

10684: FOR i IN 1..l_selected_invoices_cursor.COUNT LOOP
10685:
10686: --Bug9436217
10687:
10688: SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;
10689:
10690: BEGIN
10691: --Bug9436217
10692: mo_global.set_policy_context('S',l_selected_invoices_cursor(i).org_id);

Line 10769: AP_APPROVAL_PKG.Generate_Manual_Awt_Dist

10765: AND ail.line_type_lookup_code = 'AWT'
10766: AND ail.line_source = 'MANUAL LINE ENTRY';
10767:
10768: IF (l_manual_awt_exist > 0) THEN
10769: AP_APPROVAL_PKG.Generate_Manual_Awt_Dist
10770: (p_invoice_rec => l_selected_invoices_cursor(i),
10771: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_selected_invoices_cursor(i).org_id).base_currency_code,
10772: p_inv_batch_id => p_inv_batch_id,
10773: p_run_option => p_run_option,

Line 10771: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_selected_invoices_cursor(i).org_id).base_currency_code,

10767:
10768: IF (l_manual_awt_exist > 0) THEN
10769: AP_APPROVAL_PKG.Generate_Manual_Awt_Dist
10770: (p_invoice_rec => l_selected_invoices_cursor(i),
10771: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_selected_invoices_cursor(i).org_id).base_currency_code,
10772: p_inv_batch_id => p_inv_batch_id,
10773: p_run_option => p_run_option,
10774: p_calling_sequence => l_curr_calling_sequence,
10775: x_error_code => l_error_code,

Line 10780: AP_APPROVAL_PKG.APPROVE(

10776: p_calling_mode => l_calling_mode);
10777: END IF;
10778: -- Bug 11830074 end
10779: --Removed the hardcoded value of p_budget_control, bug6356402
10780: AP_APPROVAL_PKG.APPROVE(
10781: '',
10782: '',
10783: '',
10784: '',

Line 10826: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;

10822:
10823: EXCEPTION
10824: WHEN TAX_DIST_EXCEPTION_HANDLED THEN
10825:
10826: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;
10827:
10828: ap_utilities_pkg.ap_get_message(l_approval_error);
10829:
10830: fnd_file.put_line (fnd_file.log, ' ');

Line 10859: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;

10855: --Bug9436217
10856:
10857: WHEN OTHERS THEN
10858:
10859: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;
10860:
10861: ap_utilities_pkg.ap_get_message(l_approval_error);
10862:
10863: fnd_file.put_line (fnd_file.log, ' ');

Line 10898: WHERE validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID;

10894: --Bug9436217
10895:
10896: UPDATE ap_invoices_all
10897: SET validation_request_id = NULL
10898: WHERE validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID;
10899:
10900: CLOSE SELECTED_INVOICES_CURSOR ;
10901:
10902: --Bug9436217

Line 10961: AP_APPROVAL_PKG.G_SELECTED_INVOICES.DELETE;

10957: ---------------------------------------------------------------------
10958:
10959: --Bug9436217
10960: IF l_blk_err_dist = 'N' THEN --Marker 4
10961: AP_APPROVAL_PKG.G_SELECTED_INVOICES.DELETE;
10962: --Bug9436217
10963: OPEN SELECTED_INVOICES_CURSOR;
10964: LOOP
10965: FETCH SELECTED_INVOICES_CURSOR

Line 10966: BULK COLLECT INTO AP_APPROVAL_PKG.G_SELECTED_INVOICES

10962: --Bug9436217
10963: OPEN SELECTED_INVOICES_CURSOR;
10964: LOOP
10965: FETCH SELECTED_INVOICES_CURSOR
10966: BULK COLLECT INTO AP_APPROVAL_PKG.G_SELECTED_INVOICES
10967: LIMIT l_commit_size;
10968:
10969: EXIT WHEN SELECTED_INVOICES_CURSOR%NOTFOUND
10970: and AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT <= 0;

Line 10970: and AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT <= 0;

10966: BULK COLLECT INTO AP_APPROVAL_PKG.G_SELECTED_INVOICES
10967: LIMIT l_commit_size;
10968:
10969: EXIT WHEN SELECTED_INVOICES_CURSOR%NOTFOUND
10970: and AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT <= 0;
10971:
10972: FOR i IN 1..AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT LOOP
10973:
10974: -- Set Policy

Line 10972: FOR i IN 1..AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT LOOP

10968:
10969: EXIT WHEN SELECTED_INVOICES_CURSOR%NOTFOUND
10970: and AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT <= 0;
10971:
10972: FOR i IN 1..AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT LOOP
10973:
10974: -- Set Policy
10975: IF AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id <> nvl(l_old_org_id, -3115) THEN
10976:

Line 10975: IF AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id <> nvl(l_old_org_id, -3115) THEN

10971:
10972: FOR i IN 1..AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT LOOP
10973:
10974: -- Set Policy
10975: IF AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id <> nvl(l_old_org_id, -3115) THEN
10976:
10977: mo_global.set_policy_context('S', AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id);
10978:
10979: l_old_org_id := AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id;

Line 10977: mo_global.set_policy_context('S', AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id);

10973:
10974: -- Set Policy
10975: IF AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id <> nvl(l_old_org_id, -3115) THEN
10976:
10977: mo_global.set_policy_context('S', AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id);
10978:
10979: l_old_org_id := AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id;
10980:
10981: END IF;

Line 10979: l_old_org_id := AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id;

10975: IF AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id <> nvl(l_old_org_id, -3115) THEN
10976:
10977: mo_global.set_policy_context('S', AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id);
10978:
10979: l_old_org_id := AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id;
10980:
10981: END IF;
10982:
10983: -- Set Calling Mode

Line 10984: IF AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_type_lookup_code = 'PAYMENT REQUEST' THEN

10980:
10981: END IF;
10982:
10983: -- Set Calling Mode
10984: IF AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_type_lookup_code = 'PAYMENT REQUEST' THEN
10985: l_calling_mode := 'PAYMENT REQUEST';
10986: ELSE
10987: l_calling_mode := 'APPROVE';
10988:

Line 10991: AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).tolerance_id,

10987: l_calling_mode := 'APPROVE';
10988:
10989: -- Cache Templates
10990: Cache_Tolerance_Templates(
10991: AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).tolerance_id,
10992: AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).services_tolerance_id,
10993: l_calling_sequence);
10994: END IF;
10995:

Line 10992: AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).services_tolerance_id,

10988:
10989: -- Cache Templates
10990: Cache_Tolerance_Templates(
10991: AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).tolerance_id,
10992: AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).services_tolerance_id,
10993: l_calling_sequence);
10994: END IF;
10995:
10996: -- Call Approve

Line 10998: AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_id) THEN

10994: END IF;
10995:
10996: -- Call Approve
10997: IF validate_period(
10998: AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_id) THEN
10999: -- Bug 11830074 start
11000: l_manual_awt_exist:=0;
11001: SELECT COUNT(*)
11002: INTO l_manual_awt_exist

Line 11004: WHERE ail.invoice_id = AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_id

11000: l_manual_awt_exist:=0;
11001: SELECT COUNT(*)
11002: INTO l_manual_awt_exist
11003: FROM ap_invoice_lines_all ail
11004: WHERE ail.invoice_id = AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_id
11005: AND ail.line_type_lookup_code = 'AWT'
11006: AND ail.line_source = 'MANUAL LINE ENTRY';
11007:
11008: IF (l_manual_awt_exist > 0) THEN

Line 11009: AP_APPROVAL_PKG.Generate_Manual_Awt_Dist

11005: AND ail.line_type_lookup_code = 'AWT'
11006: AND ail.line_source = 'MANUAL LINE ENTRY';
11007:
11008: IF (l_manual_awt_exist > 0) THEN
11009: AP_APPROVAL_PKG.Generate_Manual_Awt_Dist
11010: (p_invoice_rec => AP_APPROVAL_PKG.G_SELECTED_INVOICES(i),
11011: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id).base_currency_code,
11012: p_inv_batch_id => p_inv_batch_id,
11013: p_run_option => p_run_option,

Line 11010: (p_invoice_rec => AP_APPROVAL_PKG.G_SELECTED_INVOICES(i),

11006: AND ail.line_source = 'MANUAL LINE ENTRY';
11007:
11008: IF (l_manual_awt_exist > 0) THEN
11009: AP_APPROVAL_PKG.Generate_Manual_Awt_Dist
11010: (p_invoice_rec => AP_APPROVAL_PKG.G_SELECTED_INVOICES(i),
11011: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id).base_currency_code,
11012: p_inv_batch_id => p_inv_batch_id,
11013: p_run_option => p_run_option,
11014: p_calling_sequence => l_curr_calling_sequence,

Line 11011: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id).base_currency_code,

11007:
11008: IF (l_manual_awt_exist > 0) THEN
11009: AP_APPROVAL_PKG.Generate_Manual_Awt_Dist
11010: (p_invoice_rec => AP_APPROVAL_PKG.G_SELECTED_INVOICES(i),
11011: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id).base_currency_code,
11012: p_inv_batch_id => p_inv_batch_id,
11013: p_run_option => p_run_option,
11014: p_calling_sequence => l_curr_calling_sequence,
11015: x_error_code => l_error_code,

Line 11021: AP_APPROVAL_PKG.approve(

11017: END IF;
11018: -- Bug 11830074 end
11019:
11020: --Removed the hardcoded value of p_budget_control, bug6356402
11021: AP_APPROVAL_PKG.approve(
11022: '',
11023: '',
11024: '',
11025: '',

Line 11028: AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_id,

11024: '',
11025: '',
11026: '',
11027: '',
11028: AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_id,
11029: '',
11030: '',
11031: '',
11032: 'Y',

Line 11043: fnd_message.set_token('INV_NUM', AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_num);

11039: );
11040:
11041: ELSE
11042: fnd_message.set_name('SQLAP', 'AP_INV_NEVER_OPEN_PERIOD');
11043: fnd_message.set_token('INV_NUM', AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_num);
11044: fnd_file.put_line(fnd_file.log, fnd_message.get);
11045: END IF;
11046:
11047: END LOOP;

Line 11059: AP_APPROVAL_PKG.G_SELECTED_INVOICES.DELETE;

11055: AND validation_request_id IS NOT NULL;
11056:
11057: --Bug9436217
11058:
11059: AP_APPROVAL_PKG.G_SELECTED_INVOICES.DELETE;
11060:
11061: END LOOP;
11062:
11063: CLOSE SELECTED_INVOICES_CURSOR;

Line 11125: -- Print_Debug(l_api_name, 'AP_APPROVAL_PKG.BATCH_APPROVAL.END');

11121: END IF;
11122:
11123:
11124: ---------------------------------------------------------------------
11125: -- Print_Debug(l_api_name, 'AP_APPROVAL_PKG.BATCH_APPROVAL.END');
11126: IF g_debug_mode = 'Y' THEN
11127: AP_Debug_Pkg.Print(g_debug_mode, 'AP_APPROVAL_PKG.BATCH_APPROVAL.END' );
11128: END IF;
11129:

Line 11127: AP_Debug_Pkg.Print(g_debug_mode, 'AP_APPROVAL_PKG.BATCH_APPROVAL.END' );

11123:
11124: ---------------------------------------------------------------------
11125: -- Print_Debug(l_api_name, 'AP_APPROVAL_PKG.BATCH_APPROVAL.END');
11126: IF g_debug_mode = 'Y' THEN
11127: AP_Debug_Pkg.Print(g_debug_mode, 'AP_APPROVAL_PKG.BATCH_APPROVAL.END' );
11128: END IF;
11129:
11130: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
11131: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_APPROVAL_PKG.BATCH_APPROVAL.END');

Line 11131: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_APPROVAL_PKG.BATCH_APPROVAL.END');

11127: AP_Debug_Pkg.Print(g_debug_mode, 'AP_APPROVAL_PKG.BATCH_APPROVAL.END' );
11128: END IF;
11129:
11130: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
11131: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_APPROVAL_PKG.BATCH_APPROVAL.END');
11132: END IF;
11133: ---------------------------------------------------------------------
11134:
11135: RETURN(TRUE);

Line 11259: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;

11255: l_curr_calling_sequence VARCHAR2(2000);
11256: l_debug_info VARCHAR2(1000);
11257: BEGIN
11258:
11259: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
11260:
11261: ------------------------------------------------------------
11262: l_debug_info := 'Retrieving system parameters for approval';
11263: -- Print_Debug(l_debug_loc,l_debug_info);

Line 11278: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).chart_of_accounts_id

11274: LOOP
11275: FETCH C_Options_Query INTO l_options_rec;
11276: EXIT WHEN C_Options_Query%NOTFOUND;
11277:
11278: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).chart_of_accounts_id
11279: := l_options_rec.chart_of_accounts_id;
11280: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).set_of_books_id
11281: := l_options_rec.set_of_books_id;
11282: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).automatic_offsets_flag

Line 11280: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).set_of_books_id

11276: EXIT WHEN C_Options_Query%NOTFOUND;
11277:
11278: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).chart_of_accounts_id
11279: := l_options_rec.chart_of_accounts_id;
11280: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).set_of_books_id
11281: := l_options_rec.set_of_books_id;
11282: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).automatic_offsets_flag
11283: := l_options_rec.automatic_offsets_flag;
11284: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).recalc_pay_schedule_flag

Line 11282: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).automatic_offsets_flag

11278: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).chart_of_accounts_id
11279: := l_options_rec.chart_of_accounts_id;
11280: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).set_of_books_id
11281: := l_options_rec.set_of_books_id;
11282: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).automatic_offsets_flag
11283: := l_options_rec.automatic_offsets_flag;
11284: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).recalc_pay_schedule_flag
11285: := l_options_rec.recalc_pay_schedule_flag;
11286: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).liability_post_lookup_code

Line 11284: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).recalc_pay_schedule_flag

11280: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).set_of_books_id
11281: := l_options_rec.set_of_books_id;
11282: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).automatic_offsets_flag
11283: := l_options_rec.automatic_offsets_flag;
11284: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).recalc_pay_schedule_flag
11285: := l_options_rec.recalc_pay_schedule_flag;
11286: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).liability_post_lookup_code
11287: := l_options_rec.liability_post_lookup_code;
11288: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).rate_var_gain_ccid

Line 11286: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).liability_post_lookup_code

11282: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).automatic_offsets_flag
11283: := l_options_rec.automatic_offsets_flag;
11284: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).recalc_pay_schedule_flag
11285: := l_options_rec.recalc_pay_schedule_flag;
11286: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).liability_post_lookup_code
11287: := l_options_rec.liability_post_lookup_code;
11288: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).rate_var_gain_ccid
11289: := l_options_rec.rate_var_gain_ccid;
11290: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).rate_var_loss_ccid

Line 11288: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).rate_var_gain_ccid

11284: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).recalc_pay_schedule_flag
11285: := l_options_rec.recalc_pay_schedule_flag;
11286: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).liability_post_lookup_code
11287: := l_options_rec.liability_post_lookup_code;
11288: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).rate_var_gain_ccid
11289: := l_options_rec.rate_var_gain_ccid;
11290: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).rate_var_loss_ccid
11291: := l_options_rec.rate_var_loss_ccid;
11292: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).base_currency_code

Line 11290: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).rate_var_loss_ccid

11286: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).liability_post_lookup_code
11287: := l_options_rec.liability_post_lookup_code;
11288: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).rate_var_gain_ccid
11289: := l_options_rec.rate_var_gain_ccid;
11290: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).rate_var_loss_ccid
11291: := l_options_rec.rate_var_loss_ccid;
11292: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).base_currency_code
11293: := l_options_rec.base_currency_code;
11294: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).match_on_tax_flag

Line 11292: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).base_currency_code

11288: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).rate_var_gain_ccid
11289: := l_options_rec.rate_var_gain_ccid;
11290: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).rate_var_loss_ccid
11291: := l_options_rec.rate_var_loss_ccid;
11292: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).base_currency_code
11293: := l_options_rec.base_currency_code;
11294: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).match_on_tax_flag
11295: := l_options_rec.match_on_tax_flag;
11296: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).enforce_tax_from_account

Line 11294: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).match_on_tax_flag

11290: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).rate_var_loss_ccid
11291: := l_options_rec.rate_var_loss_ccid;
11292: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).base_currency_code
11293: := l_options_rec.base_currency_code;
11294: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).match_on_tax_flag
11295: := l_options_rec.match_on_tax_flag;
11296: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).enforce_tax_from_account
11297: := l_options_rec.enforce_tax_from_account;
11298: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).inv_encumbrance_type_id

Line 11296: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).enforce_tax_from_account

11292: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).base_currency_code
11293: := l_options_rec.base_currency_code;
11294: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).match_on_tax_flag
11295: := l_options_rec.match_on_tax_flag;
11296: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).enforce_tax_from_account
11297: := l_options_rec.enforce_tax_from_account;
11298: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).inv_encumbrance_type_id
11299: := l_options_rec.inv_encumbrance_type_id;
11300: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).purch_encumbrance_type_id

Line 11298: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).inv_encumbrance_type_id

11294: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).match_on_tax_flag
11295: := l_options_rec.match_on_tax_flag;
11296: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).enforce_tax_from_account
11297: := l_options_rec.enforce_tax_from_account;
11298: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).inv_encumbrance_type_id
11299: := l_options_rec.inv_encumbrance_type_id;
11300: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).purch_encumbrance_type_id
11301: := l_options_rec.purch_encumbrance_type_id;
11302: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).receipt_acceptance_days

Line 11300: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).purch_encumbrance_type_id

11296: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).enforce_tax_from_account
11297: := l_options_rec.enforce_tax_from_account;
11298: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).inv_encumbrance_type_id
11299: := l_options_rec.inv_encumbrance_type_id;
11300: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).purch_encumbrance_type_id
11301: := l_options_rec.purch_encumbrance_type_id;
11302: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).receipt_acceptance_days
11303: := l_options_rec.receipt_acceptance_days;
11304: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).gl_date_from_receipt_flag

Line 11302: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).receipt_acceptance_days

11298: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).inv_encumbrance_type_id
11299: := l_options_rec.inv_encumbrance_type_id;
11300: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).purch_encumbrance_type_id
11301: := l_options_rec.purch_encumbrance_type_id;
11302: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).receipt_acceptance_days
11303: := l_options_rec.receipt_acceptance_days;
11304: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).gl_date_from_receipt_flag
11305: := l_options_rec.gl_date_from_receipt_flag;
11306: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).accounting_method_option

Line 11304: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).gl_date_from_receipt_flag

11300: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).purch_encumbrance_type_id
11301: := l_options_rec.purch_encumbrance_type_id;
11302: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).receipt_acceptance_days
11303: := l_options_rec.receipt_acceptance_days;
11304: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).gl_date_from_receipt_flag
11305: := l_options_rec.gl_date_from_receipt_flag;
11306: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).accounting_method_option
11307: := l_options_rec.accounting_method_option;
11308: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).secondary_accounting_method

Line 11306: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).accounting_method_option

11302: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).receipt_acceptance_days
11303: := l_options_rec.receipt_acceptance_days;
11304: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).gl_date_from_receipt_flag
11305: := l_options_rec.gl_date_from_receipt_flag;
11306: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).accounting_method_option
11307: := l_options_rec.accounting_method_option;
11308: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).secondary_accounting_method
11309: := l_options_rec.secondary_accounting_method;
11310: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).cash_basis_enc_nr_tax

Line 11308: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).secondary_accounting_method

11304: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).gl_date_from_receipt_flag
11305: := l_options_rec.gl_date_from_receipt_flag;
11306: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).accounting_method_option
11307: := l_options_rec.accounting_method_option;
11308: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).secondary_accounting_method
11309: := l_options_rec.secondary_accounting_method;
11310: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).cash_basis_enc_nr_tax
11311: := l_options_rec.cash_basis_enc_nr_tax;
11312: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).non_recoverable_tax_flag

Line 11310: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).cash_basis_enc_nr_tax

11306: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).accounting_method_option
11307: := l_options_rec.accounting_method_option;
11308: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).secondary_accounting_method
11309: := l_options_rec.secondary_accounting_method;
11310: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).cash_basis_enc_nr_tax
11311: := l_options_rec.cash_basis_enc_nr_tax;
11312: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).non_recoverable_tax_flag
11313: := l_options_rec.non_recoverable_tax_flag;
11314: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).disc_is_inv_less_tax_flag

Line 11312: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).non_recoverable_tax_flag

11308: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).secondary_accounting_method
11309: := l_options_rec.secondary_accounting_method;
11310: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).cash_basis_enc_nr_tax
11311: := l_options_rec.cash_basis_enc_nr_tax;
11312: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).non_recoverable_tax_flag
11313: := l_options_rec.non_recoverable_tax_flag;
11314: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).disc_is_inv_less_tax_flag
11315: := l_options_rec.disc_is_inv_less_tax_flag;
11316: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).org_id

Line 11314: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).disc_is_inv_less_tax_flag

11310: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).cash_basis_enc_nr_tax
11311: := l_options_rec.cash_basis_enc_nr_tax;
11312: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).non_recoverable_tax_flag
11313: := l_options_rec.non_recoverable_tax_flag;
11314: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).disc_is_inv_less_tax_flag
11315: := l_options_rec.disc_is_inv_less_tax_flag;
11316: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).org_id
11317: := l_options_rec.org_id;
11318: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).System_User

Line 11316: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).org_id

11312: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).non_recoverable_tax_flag
11313: := l_options_rec.non_recoverable_tax_flag;
11314: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).disc_is_inv_less_tax_flag
11315: := l_options_rec.disc_is_inv_less_tax_flag;
11316: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).org_id
11317: := l_options_rec.org_id;
11318: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).System_User
11319: := l_options_rec.System_User;
11320: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).user_id

Line 11318: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).System_User

11314: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).disc_is_inv_less_tax_flag
11315: := l_options_rec.disc_is_inv_less_tax_flag;
11316: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).org_id
11317: := l_options_rec.org_id;
11318: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).System_User
11319: := l_options_rec.System_User;
11320: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).user_id
11321: := l_options_rec.user_id;
11322:

Line 11320: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).user_id

11316: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).org_id
11317: := l_options_rec.org_id;
11318: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).System_User
11319: := l_options_rec.System_User;
11320: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).user_id
11321: := l_options_rec.user_id;
11322:
11323: END LOOP;
11324: CLOSE C_Options_Query;

Line 11353: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;

11349: l_curr_calling_sequence VARCHAR2(2000);
11350: l_debug_info VARCHAR2(1000);
11351: BEGIN
11352:
11353: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
11354:
11355: ------------------------------------------------------------
11356: l_debug_info := 'Retrieving Supplier Site Tolerances';
11357: -- Print_Debug(l_debug_loc,l_debug_info);

Line 11431: (p_invoice_rec IN AP_APPROVAL_PKG.Invoice_Rec,

11427: APP_EXCEPTION.RAISE_EXCEPTION;
11428: END Cache_Tolerance_Templates;
11429:
11430: PROCEDURE Generate_Distributions
11431: (p_invoice_rec IN AP_APPROVAL_PKG.Invoice_Rec,
11432: p_base_currency_code IN VARCHAR2,
11433: p_inv_batch_id IN NUMBER,
11434: p_run_option IN VARCHAR2,
11435: p_calling_sequence IN VARCHAR2,

Line 11496: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;

11492: -- bug6783517 ends
11493:
11494: BEGIN
11495:
11496: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
11497:
11498: ----------------------------------------------------------------
11499: l_debug_info := 'Check Line Variance at invoice header level';
11500: -- Print_Debug(l_debug_loc, l_debug_info);

Line 12172: (p_invoice_rec IN AP_APPROVAL_PKG.Invoice_Rec,

12168:
12169: --Bug 8346277
12170: --For Manual AWT Line Added new procedure.
12171: PROCEDURE Generate_Manual_Awt_Dist
12172: (p_invoice_rec IN AP_APPROVAL_PKG.Invoice_Rec,
12173: p_base_currency_code IN VARCHAR2,
12174: p_inv_batch_id IN NUMBER,
12175: p_run_option IN VARCHAR2,
12176: p_calling_sequence IN VARCHAR2,

Line 12230: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;

12226: t_holds_tab holds_tab_type;
12227:
12228: BEGIN
12229:
12230: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
12231:
12232:
12233: ----------------------------------------------------------------
12234: l_debug_info := 'Bulk Collect Invoice Lines';

Line 12512: l_current_calling_sequence := 'AP_APPROVAL_PKG.BATCH_APPROVAL_FOR_VENDOR <- '||

12508: where APS.vendor_id = p_vendor_id;
12509:
12510: Begin
12511:
12512: l_current_calling_sequence := 'AP_APPROVAL_PKG.BATCH_APPROVAL_FOR_VENDOR <- '||
12513: P_CALLING_SEQUENCE;
12514: OPEN vndr_list_to_process;
12515: FETCH vndr_list_to_process
12516: BULK COLLECT INTO l_vendor_id_list;

Line 12617: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

12613: (p_calling_mode= 'NO DIST IN TAB' or
12614: (p_calling_mode='CANCEL' AND l_check_encumbrance = 0))) THEN --BUG11659334
12615:
12616: l_debug_info := 'Before releasing any Insufficient funds holds';
12617: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
12618: P_invoice_id,
12619: null,
12620: null,
12621: 'INSUFFICIENT FUNDS',

Line 12631: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

12627: p_release_count,
12628: p_calling_sequence);
12629:
12630: l_debug_info := 'Before releasing any Cant Funds Check holds';
12631: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
12632: P_invoice_id,
12633: null,
12634: null,
12635: 'CANT FUNDS CHECK',

Line 12645: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

12641: p_release_count,
12642: p_calling_sequence);
12643:
12644: l_debug_info := 'Before releasing any Encumbrance Acctg Failed holds';
12645: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
12646: P_invoice_id,
12647: null,
12648: null,
12649: 'Encumbrance Acctg Fail',

Line 12680: l_debug_loc VARCHAR2(1000) := 'AP_APPROVAL_PKG.POPULATE_GDF_FOR_FV';

12676: P_curr_calling_sequence IN VARCHAR2) IS
12677:
12678:
12679: l_curr_calling_sequence VARCHAR2(2000);
12680: l_debug_loc VARCHAR2(1000) := 'AP_APPROVAL_PKG.POPULATE_GDF_FOR_FV';
12681: l_debug_info VARCHAR2(1000);
12682: l_invoce_type AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;
12683:
12684: BEGIN

Line 12802: l_curr_calling_sequence := 'AP_APPROVAL_PKG.CHECK_GDF_VALID <-'||p_calling_sequence;

12798: l_api_name CONSTANT VARCHAR2(200) := 'CHECK_GDF_VALID'; --Bug16247029
12799:
12800: BEGIN
12801:
12802: l_curr_calling_sequence := 'AP_APPROVAL_PKG.CHECK_GDF_VALID <-'||p_calling_sequence;
12803: l_debug_info := 'Before initializing holds';
12804:
12805: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
12806: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, l_debug_info);

Line 12861: END AP_APPROVAL_PKG;

12857: End CHECK_GDF_VALID;
12858:
12859: --End Bug#13464635
12860:
12861: END AP_APPROVAL_PKG;