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.140.12010000.28 2009/01/23 10:48:19 ctetala 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.140.12010000.28 2009/01/23 10:48:19 ctetala 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 734: l_invoice_rec AP_APPROVAL_PKG.Invoice_Rec;

730: l_recouped_amount NUMBER;
731: l_tolerance_id NUMBER;
732: l_service_tolerance_id NUMBER;
733:
734: l_invoice_rec AP_APPROVAL_PKG.Invoice_Rec;
735:
736: l_api_name CONSTANT VARCHAR2(200) := 'Approve';
737:
738: -- Bug 6648094

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

757: l_unpostable_holds_exist VARCHAR2(1) := 'N';
758:
759: BEGIN
760:
761: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
762:
763: IF (p_debug_switch = 'Y') THEN
764: g_debug_mode := 'Y';
765: END IF;

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

763: IF (p_debug_switch = 'Y') THEN
764: g_debug_mode := 'Y';
765: END IF;
766:
767: Print_Debug (l_api_name, 'AP_APPROVAL_PKG.APPROVE.BEGIN');
768:
769: ----------------------------------------------------------------
770: l_debug_info := 'Approving INVOICE_ID: '|| p_invoice_id;
771: Print_Debug (l_api_name, l_debug_info);

Line 976: AP_APPROVAL_PKG.Generate_Distributions

972: ----------------------------------------------------------------
973:
974: --bugfix:6684139/6699825
975: IF (l_invoice_line_count > 0) THEN
976: AP_APPROVAL_PKG.Generate_Distributions
977: (p_invoice_rec => l_invoice_rec,
978: p_base_currency_code => l_base_currency_code,
979: p_inv_batch_id => p_invoice_batch_id, /*Bug#7036685 : Passed p_invoice_batch_id to
980: p_inv_batch_id parameter instead of NULL*/

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

1752: COMMIT;
1753: END IF;
1754: END IF;
1755:
1756: Print_Debug (l_api_name, 'AP_APPROVAL_PKG.APPROVE.END');
1757:
1758: EXCEPTION
1759: -- Bug 7718385
1760: WHEN LCM_EXCEPTION THEN

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

1922: l_curr_calling_sequence VARCHAR2(2000);
1923: l_debug_info VARCHAR2(1000);
1924: BEGIN
1925:
1926: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
1927: p_calling_sequence;
1928:
1929: -- Select stmt added for bug 6684139
1930: SELECT count(*)

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

1966:
1967: l_debug_info := 'Set Options from Cache';
1968: Print_Debug (l_debug_loc, l_debug_info);
1969:
1970: p_set_of_books_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).set_of_books_id;
1971: p_recalc_pay_sched_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).recalc_pay_schedule_flag;
1972: p_sys_xrate_gain_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_gain_ccid;
1973: p_sys_xrate_loss_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_loss_ccid;
1974: p_base_currency_code := AP_APPROVAL_PKG.G_Options_Table(p_org_id).base_currency_code;

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

1967: l_debug_info := 'Set Options from Cache';
1968: Print_Debug (l_debug_loc, l_debug_info);
1969:
1970: p_set_of_books_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).set_of_books_id;
1971: p_recalc_pay_sched_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).recalc_pay_schedule_flag;
1972: p_sys_xrate_gain_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_gain_ccid;
1973: p_sys_xrate_loss_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_loss_ccid;
1974: p_base_currency_code := AP_APPROVAL_PKG.G_Options_Table(p_org_id).base_currency_code;
1975: p_inv_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).inv_encumbrance_type_id;

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

1968: Print_Debug (l_debug_loc, l_debug_info);
1969:
1970: p_set_of_books_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).set_of_books_id;
1971: p_recalc_pay_sched_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).recalc_pay_schedule_flag;
1972: p_sys_xrate_gain_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_gain_ccid;
1973: p_sys_xrate_loss_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_loss_ccid;
1974: p_base_currency_code := AP_APPROVAL_PKG.G_Options_Table(p_org_id).base_currency_code;
1975: p_inv_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).inv_encumbrance_type_id;
1976: p_purch_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).purch_encumbrance_type_id;

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

1969:
1970: p_set_of_books_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).set_of_books_id;
1971: p_recalc_pay_sched_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).recalc_pay_schedule_flag;
1972: p_sys_xrate_gain_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_gain_ccid;
1973: p_sys_xrate_loss_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_loss_ccid;
1974: p_base_currency_code := AP_APPROVAL_PKG.G_Options_Table(p_org_id).base_currency_code;
1975: p_inv_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).inv_encumbrance_type_id;
1976: p_purch_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).purch_encumbrance_type_id;
1977: p_receipt_acc_days := AP_APPROVAL_PKG.G_Options_Table(p_org_id).receipt_acceptance_days;

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

1970: p_set_of_books_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).set_of_books_id;
1971: p_recalc_pay_sched_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).recalc_pay_schedule_flag;
1972: p_sys_xrate_gain_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_gain_ccid;
1973: p_sys_xrate_loss_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_loss_ccid;
1974: p_base_currency_code := AP_APPROVAL_PKG.G_Options_Table(p_org_id).base_currency_code;
1975: p_inv_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).inv_encumbrance_type_id;
1976: p_purch_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).purch_encumbrance_type_id;
1977: p_receipt_acc_days := AP_APPROVAL_PKG.G_Options_Table(p_org_id).receipt_acceptance_days;
1978: p_gl_date_from_receipt_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).gl_date_from_receipt_flag;

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

1971: p_recalc_pay_sched_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).recalc_pay_schedule_flag;
1972: p_sys_xrate_gain_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_gain_ccid;
1973: p_sys_xrate_loss_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_loss_ccid;
1974: p_base_currency_code := AP_APPROVAL_PKG.G_Options_Table(p_org_id).base_currency_code;
1975: p_inv_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).inv_encumbrance_type_id;
1976: p_purch_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).purch_encumbrance_type_id;
1977: p_receipt_acc_days := AP_APPROVAL_PKG.G_Options_Table(p_org_id).receipt_acceptance_days;
1978: p_gl_date_from_receipt_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).gl_date_from_receipt_flag;
1979:

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

1972: p_sys_xrate_gain_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_gain_ccid;
1973: p_sys_xrate_loss_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_loss_ccid;
1974: p_base_currency_code := AP_APPROVAL_PKG.G_Options_Table(p_org_id).base_currency_code;
1975: p_inv_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).inv_encumbrance_type_id;
1976: p_purch_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).purch_encumbrance_type_id;
1977: p_receipt_acc_days := AP_APPROVAL_PKG.G_Options_Table(p_org_id).receipt_acceptance_days;
1978: p_gl_date_from_receipt_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).gl_date_from_receipt_flag;
1979:
1980: END IF;

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

1973: p_sys_xrate_loss_ccid := AP_APPROVAL_PKG.G_Options_Table(p_org_id).rate_var_loss_ccid;
1974: p_base_currency_code := AP_APPROVAL_PKG.G_Options_Table(p_org_id).base_currency_code;
1975: p_inv_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).inv_encumbrance_type_id;
1976: p_purch_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).purch_encumbrance_type_id;
1977: p_receipt_acc_days := AP_APPROVAL_PKG.G_Options_Table(p_org_id).receipt_acceptance_days;
1978: p_gl_date_from_receipt_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).gl_date_from_receipt_flag;
1979:
1980: END IF;
1981:

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

1974: p_base_currency_code := AP_APPROVAL_PKG.G_Options_Table(p_org_id).base_currency_code;
1975: p_inv_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).inv_encumbrance_type_id;
1976: p_purch_enc_type_id := AP_APPROVAL_PKG.G_Options_Table(p_org_id).purch_encumbrance_type_id;
1977: p_receipt_acc_days := AP_APPROVAL_PKG.G_Options_Table(p_org_id).receipt_acceptance_days;
1978: p_gl_date_from_receipt_flag := AP_APPROVAL_PKG.G_Options_Table(p_org_id).gl_date_from_receipt_flag;
1979:
1980: END IF;
1981:
1982: p_system_user := 5;

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

1987:
1988: IF p_invoice_type <> 'PAYMENT REQUEST' THEN
1989:
1990: IF p_tolerance_id IS NOT NULL THEN
1991: p_price_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).price_tolerance;
1992: p_qty_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).quantity_tolerance;
1993: p_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).qty_received_tolerance;
1994: p_max_qty_ord_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_ord_tolerance;
1995: p_max_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_rec_tolerance;

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

1988: IF p_invoice_type <> 'PAYMENT REQUEST' THEN
1989:
1990: IF p_tolerance_id IS NOT NULL THEN
1991: p_price_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).price_tolerance;
1992: p_qty_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).quantity_tolerance;
1993: p_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).qty_received_tolerance;
1994: p_max_qty_ord_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_ord_tolerance;
1995: p_max_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_rec_tolerance;
1996: p_goods_ship_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).ship_amt_tolerance;

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

1989:
1990: IF p_tolerance_id IS NOT NULL THEN
1991: p_price_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).price_tolerance;
1992: p_qty_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).quantity_tolerance;
1993: p_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).qty_received_tolerance;
1994: p_max_qty_ord_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_ord_tolerance;
1995: p_max_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_rec_tolerance;
1996: p_goods_ship_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).ship_amt_tolerance;
1997: p_goods_rate_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).rate_amt_tolerance;

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

1990: IF p_tolerance_id IS NOT NULL THEN
1991: p_price_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).price_tolerance;
1992: p_qty_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).quantity_tolerance;
1993: p_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).qty_received_tolerance;
1994: p_max_qty_ord_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_ord_tolerance;
1995: p_max_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_rec_tolerance;
1996: p_goods_ship_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).ship_amt_tolerance;
1997: p_goods_rate_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).rate_amt_tolerance;
1998: p_goods_total_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).total_amt_tolerance;

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

1991: p_price_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).price_tolerance;
1992: p_qty_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).quantity_tolerance;
1993: p_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).qty_received_tolerance;
1994: p_max_qty_ord_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_ord_tolerance;
1995: p_max_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_rec_tolerance;
1996: p_goods_ship_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).ship_amt_tolerance;
1997: p_goods_rate_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).rate_amt_tolerance;
1998: p_goods_total_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).total_amt_tolerance;
1999: END IF;

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

1992: p_qty_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).quantity_tolerance;
1993: p_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).qty_received_tolerance;
1994: p_max_qty_ord_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_ord_tolerance;
1995: p_max_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_rec_tolerance;
1996: p_goods_ship_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).ship_amt_tolerance;
1997: p_goods_rate_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).rate_amt_tolerance;
1998: p_goods_total_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).total_amt_tolerance;
1999: END IF;
2000:

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

1993: p_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).qty_received_tolerance;
1994: p_max_qty_ord_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_ord_tolerance;
1995: p_max_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_rec_tolerance;
1996: p_goods_ship_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).ship_amt_tolerance;
1997: p_goods_rate_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).rate_amt_tolerance;
1998: p_goods_total_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).total_amt_tolerance;
1999: END IF;
2000:
2001: IF p_services_tolerance_id IS NOT NULL THEN

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

1994: p_max_qty_ord_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_ord_tolerance;
1995: p_max_qty_rec_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).max_qty_rec_tolerance;
1996: p_goods_ship_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).ship_amt_tolerance;
1997: p_goods_rate_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).rate_amt_tolerance;
1998: p_goods_total_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).total_amt_tolerance;
1999: END IF;
2000:
2001: IF p_services_tolerance_id IS NOT NULL THEN
2002: p_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amount_tolerance;

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

1998: p_goods_total_amt_tolerance := AP_APPROVAL_PKG.G_GOODS_TOLERANCES(p_tolerance_id).total_amt_tolerance;
1999: END IF;
2000:
2001: IF p_services_tolerance_id IS NOT NULL THEN
2002: p_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amount_tolerance;
2003: p_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amt_received_tolerance;
2004: p_max_amt_ord_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_ord_tolerance;
2005: p_max_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_rec_tolerance;
2006: p_services_ship_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_ship_amt_tolerance;

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

1999: END IF;
2000:
2001: IF p_services_tolerance_id IS NOT NULL THEN
2002: p_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amount_tolerance;
2003: p_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amt_received_tolerance;
2004: p_max_amt_ord_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_ord_tolerance;
2005: p_max_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_rec_tolerance;
2006: p_services_ship_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_ship_amt_tolerance;
2007: p_services_rate_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_rate_amt_tolerance;

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

2000:
2001: IF p_services_tolerance_id IS NOT NULL THEN
2002: p_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amount_tolerance;
2003: p_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amt_received_tolerance;
2004: p_max_amt_ord_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_ord_tolerance;
2005: p_max_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_rec_tolerance;
2006: p_services_ship_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_ship_amt_tolerance;
2007: p_services_rate_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_rate_amt_tolerance;
2008: p_services_total_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_total_amt_tolerance;

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

2001: IF p_services_tolerance_id IS NOT NULL THEN
2002: p_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amount_tolerance;
2003: p_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amt_received_tolerance;
2004: p_max_amt_ord_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_ord_tolerance;
2005: p_max_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_rec_tolerance;
2006: p_services_ship_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_ship_amt_tolerance;
2007: p_services_rate_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_rate_amt_tolerance;
2008: p_services_total_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_total_amt_tolerance;
2009: END IF;

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

2002: p_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amount_tolerance;
2003: p_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amt_received_tolerance;
2004: p_max_amt_ord_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_ord_tolerance;
2005: p_max_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_rec_tolerance;
2006: p_services_ship_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_ship_amt_tolerance;
2007: p_services_rate_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_rate_amt_tolerance;
2008: p_services_total_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_total_amt_tolerance;
2009: END IF;
2010:

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

2003: p_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).amt_received_tolerance;
2004: p_max_amt_ord_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_ord_tolerance;
2005: p_max_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_rec_tolerance;
2006: p_services_ship_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_ship_amt_tolerance;
2007: p_services_rate_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_rate_amt_tolerance;
2008: p_services_total_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_total_amt_tolerance;
2009: END IF;
2010:
2011: END IF;

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

2004: p_max_amt_ord_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_ord_tolerance;
2005: p_max_amt_rec_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).max_amt_rec_tolerance;
2006: p_services_ship_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_ship_amt_tolerance;
2007: p_services_rate_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_rate_amt_tolerance;
2008: p_services_total_amt_tolerance := AP_APPROVAL_PKG.G_SERVICES_TOLERANCES(p_services_tolerance_id).ser_total_amt_tolerance;
2009: END IF;
2010:
2011: END IF;
2012:

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

2058: l_debug_info VARCHAR2(1000);
2059: l_api_name CONSTANT VARCHAR2(200) := 'Approval_Init';
2060: BEGIN
2061:
2062: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
2063: p_calling_sequence;
2064:
2065: l_undistributed_line_exists := 'N';
2066:

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

2145: l_curr_calling_sequence VARCHAR2(2000);
2146: l_debug_info VARCHAR2(1000);
2147: BEGIN
2148:
2149: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
2150: p_calling_sequence;
2151:
2152: IF (p_run_option = 'New') THEN
2153:

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

2258: l_dummy VARCHAR2(100);
2259:
2260: BEGIN
2261:
2262: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||
2263: '<-'||p_calling_sequence;
2264:
2265: p_insufficient_data_exist := FALSE;
2266:

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

2423: l_err varchar2(2000);
2424:
2425: BEGIN
2426:
2427: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
2428: p_curr_calling_sequence;
2429:
2430: ----------------------------------------------------------------------
2431: l_debug_info := 'Input Parameters: '||' invoice id: ' ||p_inv_line_rec.invoice_id

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

2812: l_debug_info VARCHAR2(1000);
2813:
2814: BEGIN
2815:
2816: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
2817: p_calling_sequence;
2818:
2819: ---------------------------------------------------
2820: l_debug_info := 'Execute_General_Checks: '

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

2991: l_debug_info VARCHAR2(1000);
2992:
2993: BEGIN
2994:
2995: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
2996: p_calling_sequence;
2997:
2998: IF (g_debug_mode = 'Y') THEN
2999: l_debug_info := 'General check - check invalid dist account';

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

3139: l_debug_info VARCHAR2(1000);
3140:
3141: BEGIN
3142:
3143: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
3144: p_calling_sequence;
3145:
3146: OPEN PO_Required_Cur;
3147: FETCH PO_Required_Cur INTO l_test_var;

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

3232: l_debug_info VARCHAR2(1000);
3233:
3234: BEGIN
3235:
3236: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
3237: p_calling_sequence;
3238:
3239: OPEN No_Rate_Cur;
3240: FETCH No_Rate_Cur INTO l_test_var;

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

3357: l_dist_count NUMBER;
3358:
3359: BEGIN
3360:
3361: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||
3362: '<-'||p_calling_sequence;
3363:
3364:
3365: l_dist_count := 0;

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

3511: l_return_message VARCHAR2(1000); --bug 7271262
3512:
3513: BEGIN
3514:
3515: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||
3516: '<-'||p_calling_sequence;
3517:
3518: p_line_variance_hold_exist := FALSE;
3519: l_line_count := 0;

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

3657: l_round_inv_line_numbers AP_INVOICES_UTILITY_PKG.inv_line_num_tab_type; --6892789
3658:
3659: BEGIN
3660:
3661: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||
3662: '<-'||p_calling_sequence;
3663:
3664: -----------------------------------------------------
3665: l_debug_info := 'Update Invoice Lines Base Amount';

Line 3743: l_base_amt := AP_APPROVAL_PKG.get_adjusted_base_amount(

3739: AND line_number = l_round_inv_line_numbers(i);
3740:
3741: -- get the calculated adjusted base amount and rounding amount
3742: -- get rounding amount for the next line if required
3743: l_base_amt := AP_APPROVAL_PKG.get_adjusted_base_amount(
3744: p_base_amount => l_base_amt,
3745: p_rounding_amt => l_modified_line_rounding_amt,
3746: p_next_line_rounding_amt => l_rounded_amt);
3747:

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

3825: l_round_dist_id_list AP_INVOICE_LINES_PKG.distribution_id_tab_type; --6892789
3826:
3827: BEGIN
3828:
3829: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||
3830: '<-'||p_calling_sequence;
3831:
3832: ------------------------------------------------------
3833: l_debug_info := 'Update Distribution Base Amounts';

Line 3896: l_base_amt := AP_APPROVAL_PKG.get_adjusted_base_amount(

3892: AND invoice_distribution_id = l_round_dist_id_list(i);
3893:
3894: -- get the calculated adjusted base amount and rounding amount
3895: -- get rounding amount for the next dist, if required
3896: l_base_amt := AP_APPROVAL_PKG.get_adjusted_base_amount(
3897: p_base_amount => l_base_amt,
3898: p_rounding_amt => l_modified_dist_rounding_amt,
3899: p_next_line_rounding_amt => l_rounded_amt);
3900:

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

3965: l_debug_info VARCHAR2(1000);
3966:
3967: BEGIN
3968:
3969: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
3970: p_calling_sequence;
3971:
3972: -------------------------------------------------
3973: l_debug_info := 'Accounting Event Generation';

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

4070: l_curr_calling_sequence VARCHAR2(2000);
4071:
4072: BEGIN
4073:
4074: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||
4075: '<-'||p_calling_sequence;
4076:
4077: OPEN Prepay_Var_Cur;
4078: LOOP

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

4170:
4171: BEGIN
4172:
4173:
4174: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||
4175: '<-'||p_calling_sequence;
4176: /*-----------------------------------------------------------------+
4177: | Check invoice amount limit |
4178: +-----------------------------------------------------------------*/

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

4311:
4312:
4313: BEGIN
4314:
4315: l_curr_calling_sequence := 'AP_APPROVAL_PKG.Check_Manual_AWT_Segments'||'<-'
4316: ||p_calling_sequence;
4317:
4318: OPEN c_manual_awt_dist_segs;
4319: LOOP

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

4383: l_debug_info VARCHAR2(1000);
4384:
4385: BEGIN
4386:
4387: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
4388: p_calling_sequence;
4389:
4390: SELECT count(*)
4391: INTO l_matched_count

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

4478: l_debug_info VARCHAR2(1000);
4479: l_calling_sequence VARCHAR2(20);
4480: BEGIN
4481:
4482: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
4483:
4484: l_withhold_error_exists := 'N';
4485:
4486: ----------------------------------------------------

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

4718:
4719: BEGIN
4720:
4721:
4722: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
4723: p_calling_sequence;
4724:
4725: ------------------------------------------------------------
4726: l_debug_info := 'Set selected dists match_status_flag to tested';

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

4895: l_curr_calling_sequence VARCHAR2(2000);
4896: l_debug_info VARCHAR2(1000);
4897: BEGIN
4898:
4899: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
4900: p_calling_sequence;
4901:
4902: 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;
4903: Print_Debug(l_debug_loc, l_debug_info);

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

5044: BEGIN
5045:
5046: -- Update the calling sequence --
5047:
5048: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
5049:
5050: p_status := 'NOT ON HOLD';
5051:
5052: if g_holds_tab.count > 0 then

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

5148: l_curr_calling_sequence VARCHAR2(2000);
5149: l_debug_info VARCHAR2(1000);
5150: BEGIN
5151:
5152: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
5153: p_calling_sequence;
5154:
5155: -------------------------------------------
5156: l_debug_info := 'Getting Release Info For Hold';

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

5267: l_initiate_workflow_flag VARCHAR2(1);
5268:
5269: BEGIN
5270:
5271: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
5272: p_calling_sequence;
5273:
5274: -------------------------------------------
5275: l_debug_info := 'Inserting Into AP_HOLDS';

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

5425: l_curr_calling_sequence VARCHAR2(2000);
5426: l_debug_info VARCHAR2(1000);
5427: BEGIN
5428:
5429: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
5430: p_calling_sequence;
5431:
5432: FOR num IN 1..100 LOOP
5433:

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

5487: l_debug_info VARCHAR2(1000);
5488: invalid_hold EXCEPTION;
5489: BEGIN
5490:
5491: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
5492: p_calling_sequence;
5493:
5494: -------------------------------------------
5495: l_debug_info := 'Check hold_code to retrieve release code';

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

5656: l_curr_calling_sequence VARCHAR2(2000);
5657: l_debug_info VARCHAR2(1000);
5658: BEGIN
5659:
5660: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
5661: p_calling_sequence;
5662:
5663: -------------------------------------------
5664: l_debug_info := 'Retrieving new invoice statuses';

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

5827: l_prepay_excl_tax_amt number;
5828: BEGIN
5829:
5830: l_debug_loc := 'Exclude_Tax_Freight_From_Disc';
5831: l_curr_calling_sequence := 'AP_APPROVAL_PKG.Exclude_Tax_From_Discount<-'||P_curr_calling_sequence;
5832:
5833: l_payment_status := 'N';
5834: l_prepayment_app_exists := 'N';
5835: l_total_amount_positive := 'N';

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

6383: -- AP_LOGGING_PKG.AP_Begin_Block(l_debug_loc);
6384:
6385: -- Update the calling sequence --
6386:
6387: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
6388:
6389: -- Initialize local variables
6390: -- BUG 4340061 : For the lines which have been already been validated but the invoice has been placed on hold.
6391:

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

6502: l_wt_amt_to_subtract NUMBER := 0;
6503: BEGIN
6504:
6505:
6506: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
6507:
6508:
6509: SELECT (0 - sum(nvl(amount,0)))
6510: INTO l_automatic_awt_amount

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

6613: l_curr_calling_sequence VARCHAR2(2000);
6614:
6615: BEGIN
6616:
6617: l_curr_calling_sequence := 'AP_APPROVAL_PKG.createPaymentSchedules <- '||P_calling_sequence;
6618:
6619: select count(*)
6620: into l_schedule_count
6621: from ap_payment_schedules_all

Line 7137: l_invoice_rec AP_APPROVAL_PKG.Invoice_Rec;

7133: l_calling_sequence VARCHAR2(20);
7134:
7135: l_retained_amount NUMBER;
7136: l_recouped_amount NUMBER;
7137: l_invoice_rec AP_APPROVAL_PKG.Invoice_Rec;
7138: l_invoice_date AP_INVOICES.invoice_date%TYPE;
7139: l_invoice_currency_code AP_INVOICES.invoice_currency_code%TYPE;
7140: l_exchange_rate AP_INVOICES.exchange_rate%TYPE;
7141: l_exchange_rate_type AP_INVOICES.exchange_rate_type%TYPE;

Line 7171: AND I.validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID

7167: s.services_tolerance_id
7168: FROM ap_invoices_all I,
7169: ap_supplier_sites_all S
7170: WHERE I.vendor_site_id = S.vendor_site_id (+)
7171: AND I.validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID
7172: ORDER BY I.org_id;
7173:
7174: l_api_name CONSTANT VARCHAR2(200) := 'Batch_Approval';
7175:

Line 7182: AND I.validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID

7178: SELECT I.invoice_id, i.invoice_num, i.org_id
7179: FROM ap_invoices_all I,
7180: ap_supplier_sites_all S
7181: WHERE I.vendor_site_id = S.vendor_site_id (+)
7182: AND I.validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID
7183: ORDER BY I.org_id;
7184:
7185: TYPE selc_inv_cursor_blk_err is table of selc_inv_cursor_bulk_error%rowtype;
7186:

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

7202: g_debug_mode := 'Y';
7203: END IF;
7204:
7205: ---------------------------------------------------------------------
7206: Print_Debug(l_api_name, 'AP_APPROVAL_PKG.BATCH_APPROVAL.BEGIN');
7207: ---------------------------------------------------------------------
7208:
7209: ap_approval_pkg.g_validation_request_id := p_conc_request_id;
7210: g_org_holds.delete;

Line 7209: ap_approval_pkg.g_validation_request_id := p_conc_request_id;

7205: ---------------------------------------------------------------------
7206: Print_Debug(l_api_name, 'AP_APPROVAL_PKG.BATCH_APPROVAL.BEGIN');
7207: ---------------------------------------------------------------------
7208:
7209: ap_approval_pkg.g_validation_request_id := p_conc_request_id;
7210: g_org_holds.delete;
7211:
7212: ---------------------------------------------------------------------
7213: Print_Debug(l_api_name, 'Setting null input parameters');

Line 7238: AP_Approval_PKG.Cache_Options(l_curr_calling_sequence);

7234:
7235: ---------------------------------------------------------------------
7236: Print_Debug(l_api_name, 'Cache System Options');
7237: ---------------------------------------------------------------------
7238: AP_Approval_PKG.Cache_Options(l_curr_calling_sequence);
7239:
7240:
7241: IF (l_invoice_id <> -1) THEN
7242:

Line 7328: AP_APPROVAL_PKG.Generate_Distributions

7324: l_invoice_rec.org_id := l_org_id;
7325: g_org_id := l_org_id;
7326:
7327:
7328: AP_APPROVAL_PKG.Generate_Distributions
7329: (p_invoice_rec => l_invoice_rec,
7330: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_org_id).base_currency_code,
7331: p_inv_batch_id => p_inv_batch_id,
7332: p_run_option => p_run_option,

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

7326:
7327:
7328: AP_APPROVAL_PKG.Generate_Distributions
7329: (p_invoice_rec => l_invoice_rec,
7330: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_org_id).base_currency_code,
7331: p_inv_batch_id => p_inv_batch_id,
7332: p_run_option => p_run_option,
7333: p_calling_sequence => l_curr_calling_sequence,
7334: x_error_code => l_error_code);

Line 7372: AP_APPROVAL_PKG.APPROVE(

7368: l_services_tolerance_id,
7369: l_calling_sequence);
7370:
7371: --Removed the hardcoded value of p_budget_control, bug6356402
7372: AP_APPROVAL_PKG.APPROVE(
7373: '',
7374: '',
7375: '',
7376: '',

Line 7551: SET validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID

7547: FOR k IN 1..l_selected_invoice_ids.count
7548: LOOP
7549:
7550: UPDATE ap_invoices_all
7551: SET validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID
7552: WHERE invoice_id = l_selected_invoice_ids(k)
7553: AND validation_request_id IS NULL;
7554:
7555: END LOOP;

Line 7569: SAVEPOINT AP_APPROVAL_PKG_SP_ETAX;

7565: ---------------------------------------------------------------------
7566: Print_Debug (l_api_name, 'Calculate Tax');
7567: ---------------------------------------------------------------------
7568:
7569: SAVEPOINT AP_APPROVAL_PKG_SP_ETAX;
7570:
7571: l_success := ap_etax_pkg.calling_etax(
7572: p_invoice_id => NULL,
7573: p_calling_mode => 'CALCULATE',

Line 7580: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_ETAX;

7576: p_calling_sequence => l_curr_calling_sequence);
7577:
7578: IF (NOT l_success) THEN -- Marker 1
7579:
7580: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_ETAX;
7581:
7582: l_blk_err := 'Y';
7583:
7584: ---------------------------------------------------------------------

Line 7604: WHERE validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID);

7600: SET validation_request_id = NULL
7601: WHERE validation_request_id IS NOT NULL
7602: AND invoice_id IN (SELECT invoice_id
7603: FROM ap_invoices_all
7604: WHERE validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID);
7605:
7606: FOR i IN 1..l_selc_inv_cursor_blk_err.count
7607: LOOP
7608:

Line 7609: SAVEPOINT AP_APPROVAL_PKG_SP_INV;

7605:
7606: FOR i IN 1..l_selc_inv_cursor_blk_err.count
7607: LOOP
7608:
7609: SAVEPOINT AP_APPROVAL_PKG_SP_INV;
7610:
7611: UPDATE ap_invoices_all
7612: SET validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID
7613: WHERE invoice_id = l_selc_inv_cursor_blk_err(i).invoice_id;

Line 7612: SET validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID

7608:
7609: SAVEPOINT AP_APPROVAL_PKG_SP_INV;
7610:
7611: UPDATE ap_invoices_all
7612: SET validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID
7613: WHERE invoice_id = l_selc_inv_cursor_blk_err(i).invoice_id;
7614:
7615: BEGIN
7616:

Line 7680: AP_APPROVAL_PKG.Generate_Distributions

7676: l_invoice_rec.org_id := l_org_id;
7677: g_org_id := l_org_id;
7678:
7679:
7680: AP_APPROVAL_PKG.Generate_Distributions
7681: (p_invoice_rec => l_invoice_rec,
7682: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_org_id).base_currency_code,
7683: p_inv_batch_id => p_inv_batch_id,
7684: p_run_option => p_run_option,

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

7678:
7679:
7680: AP_APPROVAL_PKG.Generate_Distributions
7681: (p_invoice_rec => l_invoice_rec,
7682: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_org_id).base_currency_code,
7683: p_inv_batch_id => p_inv_batch_id,
7684: p_run_option => p_run_option,
7685: p_calling_sequence => l_curr_calling_sequence,
7686: x_error_code => l_error_code);

Line 7723: AP_APPROVAL_PKG.APPROVE(

7719: l_services_tolerance_id,
7720: l_calling_sequence);
7721:
7722: --Removed the hardcoded value of p_budget_control, bug6356402
7723: AP_APPROVAL_PKG.APPROVE(
7724: '',
7725: '',
7726: '',
7727: '',

Line 7761: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_INV;

7757:
7758: EXCEPTION
7759: WHEN TAX_EXCEPTION_HANDLED THEN
7760:
7761: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_INV;
7762:
7763: ap_utilities_pkg.ap_get_message(l_approval_error);
7764: fnd_file.put_line (fnd_file.log, ' ');
7765: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '|| l_invoice_num);

Line 7773: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_INV;

7769:
7770:
7771: WHEN OTHERS THEN
7772:
7773: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_INV;
7774:
7775: ap_utilities_pkg.ap_get_message(l_approval_error);
7776: fnd_file.put_line (fnd_file.log, ' ');
7777: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '|| l_invoice_num);

Line 7799: BULK COLLECT INTO AP_APPROVAL_PKG.G_SELECTED_INVOICES

7795:
7796: OPEN SELECTED_INVOICES_CURSOR;
7797: LOOP
7798: FETCH SELECTED_INVOICES_CURSOR
7799: BULK COLLECT INTO AP_APPROVAL_PKG.G_SELECTED_INVOICES
7800: LIMIT l_commit_size;
7801:
7802: EXIT WHEN SELECTED_INVOICES_CURSOR%NOTFOUND
7803: AND AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT <= 0;

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

7799: BULK COLLECT INTO AP_APPROVAL_PKG.G_SELECTED_INVOICES
7800: LIMIT l_commit_size;
7801:
7802: EXIT WHEN SELECTED_INVOICES_CURSOR%NOTFOUND
7803: AND AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT <= 0;
7804:
7805: FOR i IN 1..AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT
7806: LOOP
7807: -- Set Policy

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

7801:
7802: EXIT WHEN SELECTED_INVOICES_CURSOR%NOTFOUND
7803: AND AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT <= 0;
7804:
7805: FOR i IN 1..AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT
7806: LOOP
7807: -- Set Policy
7808: IF AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id <> nvl(l_old_org_id, -3115) THEN
7809:

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

7804:
7805: FOR i IN 1..AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT
7806: LOOP
7807: -- Set Policy
7808: IF AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id <> nvl(l_old_org_id, -3115) THEN
7809:
7810: mo_global.set_policy_context
7811: ('S', AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id);
7812:

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

7807: -- Set Policy
7808: IF AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id <> nvl(l_old_org_id, -3115) THEN
7809:
7810: mo_global.set_policy_context
7811: ('S', AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id);
7812:
7813: l_old_org_id := AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id;
7814:
7815: END IF;

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

7809:
7810: mo_global.set_policy_context
7811: ('S', AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id);
7812:
7813: l_old_org_id := AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id;
7814:
7815: END IF;
7816:
7817: -- Initialize Invoice Holds Array

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

7815: END IF;
7816:
7817: -- Initialize Invoice Holds Array
7818: Initialize_Invoice_Holds(
7819: p_invoice_id => AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_id,
7820: p_calling_sequence => l_curr_calling_sequence);
7821:
7822: g_org_id := AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id;
7823:

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

7818: Initialize_Invoice_Holds(
7819: p_invoice_id => AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_id,
7820: p_calling_sequence => l_curr_calling_sequence);
7821:
7822: g_org_id := AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id;
7823:
7824: AP_APPROVAL_PKG.Generate_Distributions
7825: (p_invoice_rec => AP_APPROVAL_PKG.G_SELECTED_INVOICES(i),
7826: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(g_org_id).base_currency_code,

Line 7824: AP_APPROVAL_PKG.Generate_Distributions

7820: p_calling_sequence => l_curr_calling_sequence);
7821:
7822: g_org_id := AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id;
7823:
7824: AP_APPROVAL_PKG.Generate_Distributions
7825: (p_invoice_rec => AP_APPROVAL_PKG.G_SELECTED_INVOICES(i),
7826: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(g_org_id).base_currency_code,
7827: p_inv_batch_id => p_inv_batch_id,
7828: p_run_option => p_run_option,

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

7821:
7822: g_org_id := AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id;
7823:
7824: AP_APPROVAL_PKG.Generate_Distributions
7825: (p_invoice_rec => AP_APPROVAL_PKG.G_SELECTED_INVOICES(i),
7826: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(g_org_id).base_currency_code,
7827: p_inv_batch_id => p_inv_batch_id,
7828: p_run_option => p_run_option,
7829: p_calling_sequence => l_curr_calling_sequence,

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

7822: g_org_id := AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id;
7823:
7824: AP_APPROVAL_PKG.Generate_Distributions
7825: (p_invoice_rec => AP_APPROVAL_PKG.G_SELECTED_INVOICES(i),
7826: p_base_currency_code => AP_APPROVAL_PKG.G_OPTIONS_TABLE(g_org_id).base_currency_code,
7827: p_inv_batch_id => p_inv_batch_id,
7828: p_run_option => p_run_option,
7829: p_calling_sequence => l_curr_calling_sequence,
7830: x_error_code => l_error_code);

Line 7834: AP_APPROVAL_PKG.G_SELECTED_INVOICES.DELETE;

7830: x_error_code => l_error_code);
7831:
7832: END LOOP;
7833:
7834: AP_APPROVAL_PKG.G_SELECTED_INVOICES.DELETE;
7835:
7836: END LOOP;
7837: CLOSE SELECTED_INVOICES_CURSOR;
7838:

Line 7843: SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;

7839: ---------------------------------------------------------------------
7840: Print_Debug (l_api_name, 'Generate Tax Distributions');
7841: ---------------------------------------------------------------------
7842:
7843: SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;
7844:
7845: l_success := ap_etax_pkg.calling_etax (
7846: p_invoice_id => NULL,
7847: p_calling_mode => 'DISTRIBUTE',

Line 7855: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;

7851:
7852:
7853: IF (NOT l_success) THEN -- Marker 3
7854:
7855: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;
7856:
7857: ---------------------------------------------------------------------
7858: Print_Debug (l_api_name, 'Set Concurrent Request Warning');
7859: ---------------------------------------------------------------------

Line 7877: WHERE validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID);

7873: SET validation_request_id = NULL
7874: WHERE validation_request_id IS NOT NULL
7875: AND invoice_id IN (SELECT invoice_id
7876: FROM ap_invoices_all
7877: WHERE validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID);
7878:
7879: FOR i IN 1..l_selc_inv_cursor_blk_err.count
7880: LOOP
7881:

Line 7882: SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;

7878:
7879: FOR i IN 1..l_selc_inv_cursor_blk_err.count
7880: LOOP
7881:
7882: SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;
7883:
7884: UPDATE ap_invoices_all
7885: SET validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID
7886: WHERE invoice_id = l_selc_inv_cursor_blk_err(i).invoice_id;

Line 7885: SET validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID

7881:
7882: SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;
7883:
7884: UPDATE ap_invoices_all
7885: SET validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID
7886: WHERE invoice_id = l_selc_inv_cursor_blk_err(i).invoice_id;
7887:
7888: BEGIN
7889:

Line 7927: AP_APPROVAL_PKG.APPROVE(

7923: l_services_tolerance_id,
7924: l_calling_sequence);
7925:
7926: --Removed the hardcoded value of p_budget_control, bug6356402
7927: AP_APPROVAL_PKG.APPROVE(
7928: '',
7929: '',
7930: '',
7931: '',

Line 7966: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;

7962:
7963: EXCEPTION
7964: WHEN TAX_DIST_EXCEPTION_HANDLED THEN
7965:
7966: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;
7967:
7968: ap_utilities_pkg.ap_get_message(l_approval_error);
7969:
7970: fnd_file.put_line (fnd_file.log, ' ');

Line 7979: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;

7975: l_selc_inv_cursor_blk_err(i).invoice_num);
7976:
7977: WHEN OTHERS THEN
7978:
7979: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;
7980:
7981: ap_utilities_pkg.ap_get_message(l_approval_error);
7982:
7983: fnd_file.put_line (fnd_file.log, ' ');

Line 8003: BULK COLLECT INTO AP_APPROVAL_PKG.G_SELECTED_INVOICES

7999:
8000: OPEN SELECTED_INVOICES_CURSOR;
8001: LOOP
8002: FETCH SELECTED_INVOICES_CURSOR
8003: BULK COLLECT INTO AP_APPROVAL_PKG.G_SELECTED_INVOICES
8004: LIMIT l_commit_size;
8005:
8006: EXIT WHEN SELECTED_INVOICES_CURSOR%NOTFOUND
8007: and AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT <= 0;

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

8003: BULK COLLECT INTO AP_APPROVAL_PKG.G_SELECTED_INVOICES
8004: LIMIT l_commit_size;
8005:
8006: EXIT WHEN SELECTED_INVOICES_CURSOR%NOTFOUND
8007: and AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT <= 0;
8008:
8009: FOR i IN 1..AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT LOOP
8010:
8011: -- Set Policy

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

8005:
8006: EXIT WHEN SELECTED_INVOICES_CURSOR%NOTFOUND
8007: and AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT <= 0;
8008:
8009: FOR i IN 1..AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT LOOP
8010:
8011: -- Set Policy
8012: IF AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id <> nvl(l_old_org_id, -3115) THEN
8013:

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

8008:
8009: FOR i IN 1..AP_APPROVAL_PKG.G_SELECTED_INVOICES.COUNT LOOP
8010:
8011: -- Set Policy
8012: IF AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id <> nvl(l_old_org_id, -3115) THEN
8013:
8014: mo_global.set_policy_context('S', AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id);
8015:
8016: l_old_org_id := AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id;

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

8010:
8011: -- Set Policy
8012: IF AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id <> nvl(l_old_org_id, -3115) THEN
8013:
8014: mo_global.set_policy_context('S', AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id);
8015:
8016: l_old_org_id := AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id;
8017:
8018: END IF;

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

8012: IF AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id <> nvl(l_old_org_id, -3115) THEN
8013:
8014: mo_global.set_policy_context('S', AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id);
8015:
8016: l_old_org_id := AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).org_id;
8017:
8018: END IF;
8019:
8020: -- Set Calling Mode

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

8017:
8018: END IF;
8019:
8020: -- Set Calling Mode
8021: IF AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_type_lookup_code = 'PAYMENT REQUEST' THEN
8022: l_calling_mode := 'PAYMENT REQUEST';
8023: ELSE
8024: l_calling_mode := 'APPROVE';
8025:

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

8024: l_calling_mode := 'APPROVE';
8025:
8026: -- Cache Templates
8027: Cache_Tolerance_Templates(
8028: AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).tolerance_id,
8029: AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).services_tolerance_id,
8030: l_calling_sequence);
8031: END IF;
8032:

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

8025:
8026: -- Cache Templates
8027: Cache_Tolerance_Templates(
8028: AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).tolerance_id,
8029: AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).services_tolerance_id,
8030: l_calling_sequence);
8031: END IF;
8032:
8033: -- Call Approve

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

8031: END IF;
8032:
8033: -- Call Approve
8034: IF validate_period(
8035: AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_id) THEN
8036:
8037: --Removed the hardcoded value of p_budget_control, bug6356402
8038: AP_APPROVAL_PKG.approve(
8039: '',

Line 8038: AP_APPROVAL_PKG.approve(

8034: IF validate_period(
8035: AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_id) THEN
8036:
8037: --Removed the hardcoded value of p_budget_control, bug6356402
8038: AP_APPROVAL_PKG.approve(
8039: '',
8040: '',
8041: '',
8042: '',

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

8041: '',
8042: '',
8043: '',
8044: '',
8045: AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_id,
8046: '',
8047: '',
8048: '',
8049: 'Y',

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

8056: );
8057:
8058: ELSE
8059: fnd_message.set_name('SQLAP', 'AP_INV_NEVER_OPEN_PERIOD');
8060: fnd_message.set_token('INV_NUM', AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_num);
8061: fnd_file.put_line(fnd_file.log, fnd_message.get);
8062: END IF;
8063:
8064: -- Update Validation Request_ID to NULL;

Line 8067: WHERE invoice_id = AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_id;

8063:
8064: -- Update Validation Request_ID to NULL;
8065: UPDATE ap_invoices_all
8066: SET validation_request_id = NULL
8067: WHERE invoice_id = AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_id;
8068:
8069: END LOOP;
8070:
8071: AP_APPROVAL_PKG.G_SELECTED_INVOICES.DELETE;

Line 8071: AP_APPROVAL_PKG.G_SELECTED_INVOICES.DELETE;

8067: WHERE invoice_id = AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_id;
8068:
8069: END LOOP;
8070:
8071: AP_APPROVAL_PKG.G_SELECTED_INVOICES.DELETE;
8072:
8073: END LOOP;
8074:
8075: CLOSE SELECTED_INVOICES_CURSOR;

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

8109: END IF;
8110:
8111:
8112: ---------------------------------------------------------------------
8113: Print_Debug(l_api_name, 'AP_APPROVAL_PKG.BATCH_APPROVAL.END');
8114: ---------------------------------------------------------------------
8115:
8116: RETURN(TRUE);
8117:

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

8222: l_curr_calling_sequence VARCHAR2(2000);
8223: l_debug_info VARCHAR2(1000);
8224: BEGIN
8225:
8226: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
8227:
8228: ------------------------------------------------------------
8229: l_debug_info := 'Retrieving system parameters for approval';
8230: Print_Debug(l_debug_loc,l_debug_info);

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

8234: LOOP
8235: FETCH C_Options_Query INTO l_options_rec;
8236: EXIT WHEN C_Options_Query%NOTFOUND;
8237:
8238: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).chart_of_accounts_id
8239: := l_options_rec.chart_of_accounts_id;
8240: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).set_of_books_id
8241: := l_options_rec.set_of_books_id;
8242: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).automatic_offsets_flag

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

8236: EXIT WHEN C_Options_Query%NOTFOUND;
8237:
8238: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).chart_of_accounts_id
8239: := l_options_rec.chart_of_accounts_id;
8240: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).set_of_books_id
8241: := l_options_rec.set_of_books_id;
8242: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).automatic_offsets_flag
8243: := l_options_rec.automatic_offsets_flag;
8244: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).recalc_pay_schedule_flag

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

8238: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).chart_of_accounts_id
8239: := l_options_rec.chart_of_accounts_id;
8240: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).set_of_books_id
8241: := l_options_rec.set_of_books_id;
8242: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).automatic_offsets_flag
8243: := l_options_rec.automatic_offsets_flag;
8244: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).recalc_pay_schedule_flag
8245: := l_options_rec.recalc_pay_schedule_flag;
8246: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).liability_post_lookup_code

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

8240: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).set_of_books_id
8241: := l_options_rec.set_of_books_id;
8242: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).automatic_offsets_flag
8243: := l_options_rec.automatic_offsets_flag;
8244: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).recalc_pay_schedule_flag
8245: := l_options_rec.recalc_pay_schedule_flag;
8246: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).liability_post_lookup_code
8247: := l_options_rec.liability_post_lookup_code;
8248: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).rate_var_gain_ccid

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

8242: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).automatic_offsets_flag
8243: := l_options_rec.automatic_offsets_flag;
8244: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).recalc_pay_schedule_flag
8245: := l_options_rec.recalc_pay_schedule_flag;
8246: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).liability_post_lookup_code
8247: := l_options_rec.liability_post_lookup_code;
8248: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).rate_var_gain_ccid
8249: := l_options_rec.rate_var_gain_ccid;
8250: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).rate_var_loss_ccid

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

8244: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).recalc_pay_schedule_flag
8245: := l_options_rec.recalc_pay_schedule_flag;
8246: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).liability_post_lookup_code
8247: := l_options_rec.liability_post_lookup_code;
8248: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).rate_var_gain_ccid
8249: := l_options_rec.rate_var_gain_ccid;
8250: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).rate_var_loss_ccid
8251: := l_options_rec.rate_var_loss_ccid;
8252: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).base_currency_code

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

8246: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).liability_post_lookup_code
8247: := l_options_rec.liability_post_lookup_code;
8248: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).rate_var_gain_ccid
8249: := l_options_rec.rate_var_gain_ccid;
8250: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).rate_var_loss_ccid
8251: := l_options_rec.rate_var_loss_ccid;
8252: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).base_currency_code
8253: := l_options_rec.base_currency_code;
8254: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).match_on_tax_flag

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

8248: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).rate_var_gain_ccid
8249: := l_options_rec.rate_var_gain_ccid;
8250: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).rate_var_loss_ccid
8251: := l_options_rec.rate_var_loss_ccid;
8252: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).base_currency_code
8253: := l_options_rec.base_currency_code;
8254: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).match_on_tax_flag
8255: := l_options_rec.match_on_tax_flag;
8256: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).enforce_tax_from_account

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

8250: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).rate_var_loss_ccid
8251: := l_options_rec.rate_var_loss_ccid;
8252: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).base_currency_code
8253: := l_options_rec.base_currency_code;
8254: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).match_on_tax_flag
8255: := l_options_rec.match_on_tax_flag;
8256: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).enforce_tax_from_account
8257: := l_options_rec.enforce_tax_from_account;
8258: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).inv_encumbrance_type_id

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

8252: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).base_currency_code
8253: := l_options_rec.base_currency_code;
8254: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).match_on_tax_flag
8255: := l_options_rec.match_on_tax_flag;
8256: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).enforce_tax_from_account
8257: := l_options_rec.enforce_tax_from_account;
8258: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).inv_encumbrance_type_id
8259: := l_options_rec.inv_encumbrance_type_id;
8260: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).purch_encumbrance_type_id

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

8254: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).match_on_tax_flag
8255: := l_options_rec.match_on_tax_flag;
8256: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).enforce_tax_from_account
8257: := l_options_rec.enforce_tax_from_account;
8258: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).inv_encumbrance_type_id
8259: := l_options_rec.inv_encumbrance_type_id;
8260: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).purch_encumbrance_type_id
8261: := l_options_rec.purch_encumbrance_type_id;
8262: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).receipt_acceptance_days

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

8256: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).enforce_tax_from_account
8257: := l_options_rec.enforce_tax_from_account;
8258: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).inv_encumbrance_type_id
8259: := l_options_rec.inv_encumbrance_type_id;
8260: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).purch_encumbrance_type_id
8261: := l_options_rec.purch_encumbrance_type_id;
8262: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).receipt_acceptance_days
8263: := l_options_rec.receipt_acceptance_days;
8264: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).gl_date_from_receipt_flag

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

8258: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).inv_encumbrance_type_id
8259: := l_options_rec.inv_encumbrance_type_id;
8260: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).purch_encumbrance_type_id
8261: := l_options_rec.purch_encumbrance_type_id;
8262: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).receipt_acceptance_days
8263: := l_options_rec.receipt_acceptance_days;
8264: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).gl_date_from_receipt_flag
8265: := l_options_rec.gl_date_from_receipt_flag;
8266: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).accounting_method_option

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

8260: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).purch_encumbrance_type_id
8261: := l_options_rec.purch_encumbrance_type_id;
8262: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).receipt_acceptance_days
8263: := l_options_rec.receipt_acceptance_days;
8264: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).gl_date_from_receipt_flag
8265: := l_options_rec.gl_date_from_receipt_flag;
8266: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).accounting_method_option
8267: := l_options_rec.accounting_method_option;
8268: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).secondary_accounting_method

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

8262: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).receipt_acceptance_days
8263: := l_options_rec.receipt_acceptance_days;
8264: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).gl_date_from_receipt_flag
8265: := l_options_rec.gl_date_from_receipt_flag;
8266: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).accounting_method_option
8267: := l_options_rec.accounting_method_option;
8268: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).secondary_accounting_method
8269: := l_options_rec.secondary_accounting_method;
8270: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).cash_basis_enc_nr_tax

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

8264: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).gl_date_from_receipt_flag
8265: := l_options_rec.gl_date_from_receipt_flag;
8266: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).accounting_method_option
8267: := l_options_rec.accounting_method_option;
8268: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).secondary_accounting_method
8269: := l_options_rec.secondary_accounting_method;
8270: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).cash_basis_enc_nr_tax
8271: := l_options_rec.cash_basis_enc_nr_tax;
8272: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).non_recoverable_tax_flag

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

8266: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).accounting_method_option
8267: := l_options_rec.accounting_method_option;
8268: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).secondary_accounting_method
8269: := l_options_rec.secondary_accounting_method;
8270: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).cash_basis_enc_nr_tax
8271: := l_options_rec.cash_basis_enc_nr_tax;
8272: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).non_recoverable_tax_flag
8273: := l_options_rec.non_recoverable_tax_flag;
8274: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).disc_is_inv_less_tax_flag

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

8268: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).secondary_accounting_method
8269: := l_options_rec.secondary_accounting_method;
8270: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).cash_basis_enc_nr_tax
8271: := l_options_rec.cash_basis_enc_nr_tax;
8272: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).non_recoverable_tax_flag
8273: := l_options_rec.non_recoverable_tax_flag;
8274: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).disc_is_inv_less_tax_flag
8275: := l_options_rec.disc_is_inv_less_tax_flag;
8276: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).org_id

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

8270: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).cash_basis_enc_nr_tax
8271: := l_options_rec.cash_basis_enc_nr_tax;
8272: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).non_recoverable_tax_flag
8273: := l_options_rec.non_recoverable_tax_flag;
8274: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).disc_is_inv_less_tax_flag
8275: := l_options_rec.disc_is_inv_less_tax_flag;
8276: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).org_id
8277: := l_options_rec.org_id;
8278: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).System_User

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

8272: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).non_recoverable_tax_flag
8273: := l_options_rec.non_recoverable_tax_flag;
8274: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).disc_is_inv_less_tax_flag
8275: := l_options_rec.disc_is_inv_less_tax_flag;
8276: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).org_id
8277: := l_options_rec.org_id;
8278: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).System_User
8279: := l_options_rec.System_User;
8280: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).user_id

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

8274: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).disc_is_inv_less_tax_flag
8275: := l_options_rec.disc_is_inv_less_tax_flag;
8276: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).org_id
8277: := l_options_rec.org_id;
8278: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).System_User
8279: := l_options_rec.System_User;
8280: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).user_id
8281: := l_options_rec.user_id;
8282:

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

8276: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).org_id
8277: := l_options_rec.org_id;
8278: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).System_User
8279: := l_options_rec.System_User;
8280: AP_APPROVAL_PKG.G_OPTIONS_TABLE(l_options_rec.org_id).user_id
8281: := l_options_rec.user_id;
8282:
8283: END LOOP;
8284: CLOSE C_Options_Query;

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

8309: l_curr_calling_sequence VARCHAR2(2000);
8310: l_debug_info VARCHAR2(1000);
8311: BEGIN
8312:
8313: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
8314:
8315: ------------------------------------------------------------
8316: l_debug_info := 'Retrieving Supplier Site Tolerances';
8317: Print_Debug(l_debug_loc,l_debug_info);

Line 8384: (p_invoice_rec IN AP_APPROVAL_PKG.Invoice_Rec,

8380: APP_EXCEPTION.RAISE_EXCEPTION;
8381: END Cache_Tolerance_Templates;
8382:
8383: PROCEDURE Generate_Distributions
8384: (p_invoice_rec IN AP_APPROVAL_PKG.Invoice_Rec,
8385: p_base_currency_code IN VARCHAR2,
8386: p_inv_batch_id IN NUMBER,
8387: p_run_option IN VARCHAR2,
8388: p_calling_sequence IN VARCHAR2,

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

8441: -- bug6783517 ends
8442:
8443: BEGIN
8444:
8445: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
8446:
8447: ----------------------------------------------------------------
8448: l_debug_info := 'Check Line Variance at invoice header level';
8449: Print_Debug(l_debug_loc, l_debug_info);

Line 8990: END AP_APPROVAL_PKG;

8986: RETURN l_adjusted_base_amount;
8987: END IF;
8988: END;
8989:
8990: END AP_APPROVAL_PKG;