DBA Data[Home] [Help]

APPS.AP_BANK_CHARGE_PKG dependencies on FND_MSG_PUB

Line 5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;

1: PACKAGE BODY AP_BANK_CHARGE_PKG AS
2: /* $Header: apsudbcb.pls 120.6 2007/12/24 07:20:13 ppodhiya ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_BANK_CHARGE_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;
9: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;

Line 6: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;

2: /* $Header: apsudbcb.pls 120.6 2007/12/24 07:20:13 ppodhiya ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_BANK_CHARGE_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;
9: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
10: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;

Line 7: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_BANK_CHARGE_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;
9: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
10: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
11: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;

Line 8: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_BANK_CHARGE_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;
9: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
10: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
11: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
12:

Line 9: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;

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;
9: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
10: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
11: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
12:
13: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 10: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;

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;
9: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
10: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
11: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
12:
13: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 911: FND_MSG_PUB.ADD;

907: EXCEPTION
908: WHEN NO_BANK_CHARGES THEN
909: p_tolerance_limit := NULL;
910: FND_MESSAGE.SET_NAME('SQLAP', 'AP_NO_CHARGE_FOUND');
911: FND_MSG_PUB.ADD;
912: --APP_EXCEPTION.RAISE_EXCEPTION;
913: WHEN NO_DATA_FOUND THEN
914: FND_MESSAGE.SET_NAME('SQLAP', 'AP_NO_CHARGE_FOUND');
915: FND_MSG_PUB.ADD;

Line 915: FND_MSG_PUB.ADD;

911: FND_MSG_PUB.ADD;
912: --APP_EXCEPTION.RAISE_EXCEPTION;
913: WHEN NO_DATA_FOUND THEN
914: FND_MESSAGE.SET_NAME('SQLAP', 'AP_NO_CHARGE_FOUND');
915: FND_MSG_PUB.ADD;
916: p_tolerance_limit := NULL;
917: --APP_EXCEPTION.RAISE_EXCEPTION;
918: WHEN OTHERS THEN
919: IF (SQLCODE <> -20001) THEN

Line 925: FND_MSG_PUB.ADD;

921: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
922: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
923: END IF;
924: p_tolerance_limit := NULL;
925: FND_MSG_PUB.ADD;
926: --APP_EXCEPTION.RAISE_EXCEPTION;
927:
928:
929: END GET_BANK_CHARGE;

Line 1285: FND_MSG_PUB.ADD;

1281: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
1282: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
1283: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
1284: END IF;
1285: FND_MSG_PUB.ADD;
1286:
1287: END CHECK_BANK_CHARGE;
1288:
1289:

Line 1554: FND_MSG_PUB.initialize;

1550: END IF;
1551:
1552: -- Initialize message list if p_init_msg_list is set to TRUE.
1553: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1554: FND_MSG_PUB.initialize;
1555: END IF;
1556:
1557: l_debug_info := 'Calling AP Void Pkg.Iby_Void_Check';
1558: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1712: FND_MSG_PUB.ADD;

1708: ||' l_currency_code = '||l_currency_code
1709: ||' l_amt_due = '||to_char(l_amt_due)
1710: ||' l_payment_date = '||to_char(l_payment_date) );
1711: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1712: FND_MSG_PUB.ADD;
1713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1714: --APP_EXCEPTION.RAISE_EXCEPTION;
1715:
1716: END;

Line 1814: FND_MSG_PUB.ADD;

1810: ||' l_currency_code = '||l_currency_code
1811: ||' l_amt_due = '||to_char(l_amt_due)
1812: ||' l_payment_date = '||to_char(l_payment_date) );
1813: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1814: FND_MSG_PUB.ADD;
1815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1816: --APP_EXCEPTION.RAISE_EXCEPTION;
1817:
1818:

Line 2040: FND_MSG_PUB.Count_And_Get

2036:
2037: WHEN FND_API.G_EXC_ERROR THEN
2038: ROLLBACK TO AP_JAPANBANKCHARGEHOOK;
2039: x_return_status := FND_API.G_RET_STS_ERROR ;
2040: FND_MSG_PUB.Count_And_Get
2041: ( p_count => x_msg_count,
2042: p_data => x_msg_data
2043: );
2044: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2047: FND_MSG_PUB.Count_And_Get

2043: );
2044: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2045: ROLLBACK TO AP_JAPANBANKCHARGEHOOK;
2046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2047: FND_MSG_PUB.Count_And_Get
2048: ( p_count => x_msg_count,
2049: p_data => x_msg_data
2050: );
2051:

Line 2058: FND_MSG_PUB.Count_And_Get

2054: x_return_status := FND_API.G_RET_STS_ERROR ;
2055: IF x_msg_data is NOT NULL THEN
2056: x_msg_count := 1;
2057: ELSE
2058: FND_MSG_PUB.Count_And_Get
2059: ( p_count => x_msg_count,
2060: p_data => x_msg_data
2061: );
2062: END IF;

Line 2075: IF FND_MSG_PUB.Check_Msg_Level

2071: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2072: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2073: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2074:
2075: IF FND_MSG_PUB.Check_Msg_Level
2076: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2077: FND_MSG_PUB.Add_Exc_Msg
2078: ( G_PKG_NAME,
2079: l_api_name

Line 2076: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2072: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2073: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2074:
2075: IF FND_MSG_PUB.Check_Msg_Level
2076: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2077: FND_MSG_PUB.Add_Exc_Msg
2078: ( G_PKG_NAME,
2079: l_api_name
2080: );

Line 2077: FND_MSG_PUB.Add_Exc_Msg

2073: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2074:
2075: IF FND_MSG_PUB.Check_Msg_Level
2076: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2077: FND_MSG_PUB.Add_Exc_Msg
2078: ( G_PKG_NAME,
2079: l_api_name
2080: );
2081: END IF;

Line 2082: FND_MSG_PUB.Count_And_Get

2078: ( G_PKG_NAME,
2079: l_api_name
2080: );
2081: END IF;
2082: FND_MSG_PUB.Count_And_Get
2083: ( p_count => x_msg_count,
2084: p_data => x_msg_data
2085: );
2086: