DBA Data[Home] [Help]

APPS.AP_PAYMENT_PUBLIC_PKG dependencies on FND_LOG

Line 8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4: -- =====================================================================
5: -- P U B L I C O B J E C T S
6: -- =====================================================================
7:
8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

Line 9: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

5: -- P U B L I C O B J E C T S
6: -- =====================================================================
7:
8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

6: -- =====================================================================
7:
8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

7:
8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
15: G_MODULE_NAME CONSTANT VARCHAR2(35) := 'AP.PLSQL.AP_PAYMENT_PUBLIC_PKG.';

Line 12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
15: G_MODULE_NAME CONSTANT VARCHAR2(35) := 'AP.PLSQL.AP_PAYMENT_PUBLIC_PKG.';
16:

Line 13: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

9: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
15: G_MODULE_NAME CONSTANT VARCHAR2(35) := 'AP.PLSQL.AP_PAYMENT_PUBLIC_PKG.';
16:
17: PROCEDURE Create_Netting_Payment(

Line 14: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
15: G_MODULE_NAME CONSTANT VARCHAR2(35) := 'AP.PLSQL.AP_PAYMENT_PUBLIC_PKG.';
16:
17: PROCEDURE Create_Netting_Payment(
18: P_Check_Rec IN

Line 707: l_debug_info FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

703: AND ps.payment_num = c_payment_num;
704:
705: l_discount_amount ap_payment_schedules_all.discount_amount_available%type;
706: Netting_Exception EXCEPTION;
707: l_debug_info FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
708: DBG_Loc VARCHAR2(50) := 'Get_Discount_For_Payment_Schedule';
709:
710: BEGIN
711: l_debug_info := 'Begin: Invoice id: '||P_Invoice_Id||' Payment Num: '||P_Payment_Num

Line 714: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,l_debug_info);

710: BEGIN
711: l_debug_info := 'Begin: Invoice id: '||P_Invoice_Id||' Payment Num: '||P_Payment_Num
712: || 'P_Date:' || P_Date;
713: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
714: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,l_debug_info);
715: END IF;
716:
717: OPEN discount_amt_cursor(P_Invoice_Id,P_Payment_Num,P_Date);
718: FETCH discount_amt_cursor INTO l_discount_amount;

Line 723: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,l_debug_info);

719: CLOSE discount_amt_cursor;
720:
721: l_debug_info := 'l_discount_amount: '||l_discount_amount;
722: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
723: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,l_debug_info);
724: END IF;
725:
726: RETURN nvl(l_discount_amount,0);
727:

Line 732: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,l_debug_info);

728: EXCEPTION
729: WHEN OTHERS THEN
730: l_debug_info := 'Error: '||SQLCODE|| '-'||SQLERRM;
731: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
732: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,l_debug_info);
733: END IF;
734: RAISE Netting_Exception;
735: END Get_Disc_For_Pmt_Schedule;
736:

Line 763: l_debug_info FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

759: l_amount_remaining ap_payment_schedules_all.amount_remaining%type;
760: l_discount_amount ap_payment_schedules_all.discount_amount_available%type;
761: l_discount_on_netted_amt ap_payment_schedules_all.discount_amount_available%type;
762: l_inv_curr ap_invoices_all.invoice_currency_code%type;
763: l_debug_info FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
764: DBG_Loc VARCHAR2(50) := 'Get_Discount_For_Netted_Amt';
765: Netting_Exception EXCEPTION;
766: BEGIN
767: l_debug_info := 'Begin: Invoice id: '||P_Invoice_Id||' Payment Num: '||P_Payment_Num ;

Line 769: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,l_debug_info);

765: Netting_Exception EXCEPTION;
766: BEGIN
767: l_debug_info := 'Begin: Invoice id: '||P_Invoice_Id||' Payment Num: '||P_Payment_Num ;
768: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
769: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,l_debug_info);
770: END IF;
771:
772: l_debug_info := 'P_Date '||P_Date||' P_Netted_Amt: '||P_Netted_Amt;
773: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 774: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,l_debug_info);

770: END IF;
771:
772: l_debug_info := 'P_Date '||P_Date||' P_Netted_Amt: '||P_Netted_Amt;
773: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
774: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,l_debug_info);
775: END IF;
776:
777: --Get Amount Remaining to be paid for the given Invoice and Payment Number
778: SELECT amount_remaining

Line 793: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,l_debug_info);

789:
790: l_debug_info := 'Amount Remaining: '||l_amount_remaining || 'l_discount_amount:' ||l_discount_amount
791: || 'l_discount_on_netted_amt:'||l_discount_on_netted_amt;
792: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
793: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,l_debug_info);
794: END IF;
795:
796: SELECT invoice_currency_code
797: INTO l_inv_curr

Line 805: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,l_debug_info);

801: l_discount_on_netted_amt := AP_UTILITIES_PKG.Ap_Round_Currency(l_discount_on_netted_amt,l_inv_curr);
802:
803: l_debug_info := 'After rounding: '||l_discount_on_netted_amt;
804: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
805: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,l_debug_info);
806: END IF;
807:
808:
809: RETURN nvl(l_discount_on_netted_amt,0);

Line 815: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,l_debug_info);

811: EXCEPTION
812: WHEN OTHERS THEN
813: l_debug_info := 'Error: '||SQLCODE|| '-'||SQLERRM;
814: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
815: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,l_debug_info);
816: END IF;
817: RAISE Netting_Exception;
818: END Get_Disc_For_Netted_Amt;
819: