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.13 2011/07/29 18:40:58 bgoyal 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.13 2011/07/29 18:40:58 bgoyal 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 964: FND_MSG_PUB.ADD;

960: EXCEPTION
961: WHEN NO_BANK_CHARGES THEN
962: p_tolerance_limit := NULL;
963: FND_MESSAGE.SET_NAME('SQLAP', 'AP_NO_CHARGE_FOUND');
964: FND_MSG_PUB.ADD;
965: --APP_EXCEPTION.RAISE_EXCEPTION;
966: WHEN NO_DATA_FOUND THEN
967: FND_MESSAGE.SET_NAME('SQLAP', 'AP_NO_CHARGE_FOUND');
968: FND_MSG_PUB.ADD;

Line 968: FND_MSG_PUB.ADD;

964: FND_MSG_PUB.ADD;
965: --APP_EXCEPTION.RAISE_EXCEPTION;
966: WHEN NO_DATA_FOUND THEN
967: FND_MESSAGE.SET_NAME('SQLAP', 'AP_NO_CHARGE_FOUND');
968: FND_MSG_PUB.ADD;
969: p_tolerance_limit := NULL;
970: --APP_EXCEPTION.RAISE_EXCEPTION;
971: WHEN OTHERS THEN
972: IF (SQLCODE <> -20001) THEN

Line 978: FND_MSG_PUB.ADD;

974: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
975: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
976: END IF;
977: p_tolerance_limit := NULL;
978: FND_MSG_PUB.ADD;
979: --APP_EXCEPTION.RAISE_EXCEPTION;
980:
981:
982: END GET_BANK_CHARGE;

Line 1383: FND_MSG_PUB.ADD;

1379: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
1380: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
1381: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
1382: END IF;
1383: FND_MSG_PUB.ADD;
1384:
1385: END CHECK_BANK_CHARGE;
1386:
1387:

Line 1663: FND_MSG_PUB.initialize;

1659: END IF;
1660:
1661: -- Initialize message list if p_init_msg_list is set to TRUE.
1662: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1663: FND_MSG_PUB.initialize;
1664: END IF;
1665:
1666: l_debug_info := 'Calling AP Void Pkg.Iby_Void_Check';
1667: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1827: FND_MSG_PUB.ADD;

1823: ||' l_currency_code = '||l_currency_code
1824: ||' l_amt_due = '||to_char(l_amt_due)
1825: ||' l_payment_date = '||to_char(l_payment_date) );
1826: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1827: FND_MSG_PUB.ADD;
1828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1829: --APP_EXCEPTION.RAISE_EXCEPTION;
1830:
1831: END;

Line 1929: FND_MSG_PUB.ADD;

1925: ||' l_currency_code = '||l_currency_code
1926: ||' l_amt_due = '||to_char(l_amt_due)
1927: ||' l_payment_date = '||to_char(l_payment_date) );
1928: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1929: FND_MSG_PUB.ADD;
1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1931: --APP_EXCEPTION.RAISE_EXCEPTION;
1932:
1933:

Line 2158: FND_MSG_PUB.Count_And_Get

2154:
2155: WHEN FND_API.G_EXC_ERROR THEN
2156: ROLLBACK TO AP_JAPANBANKCHARGEHOOK;
2157: x_return_status := FND_API.G_RET_STS_ERROR ;
2158: FND_MSG_PUB.Count_And_Get
2159: ( p_count => x_msg_count,
2160: p_data => x_msg_data
2161: );
2162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2165: FND_MSG_PUB.Count_And_Get

2161: );
2162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2163: ROLLBACK TO AP_JAPANBANKCHARGEHOOK;
2164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2165: FND_MSG_PUB.Count_And_Get
2166: ( p_count => x_msg_count,
2167: p_data => x_msg_data
2168: );
2169:

Line 2176: FND_MSG_PUB.Count_And_Get

2172: x_return_status := FND_API.G_RET_STS_ERROR ;
2173: IF x_msg_data is NOT NULL THEN
2174: x_msg_count := 1;
2175: ELSE
2176: FND_MSG_PUB.Count_And_Get
2177: ( p_count => x_msg_count,
2178: p_data => x_msg_data
2179: );
2180: END IF;

Line 2193: IF FND_MSG_PUB.Check_Msg_Level

2189: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2190: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2191: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2192:
2193: IF FND_MSG_PUB.Check_Msg_Level
2194: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2195: FND_MSG_PUB.Add_Exc_Msg
2196: ( G_PKG_NAME,
2197: l_api_name

Line 2194: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2190: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2191: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2192:
2193: IF FND_MSG_PUB.Check_Msg_Level
2194: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2195: FND_MSG_PUB.Add_Exc_Msg
2196: ( G_PKG_NAME,
2197: l_api_name
2198: );

Line 2195: FND_MSG_PUB.Add_Exc_Msg

2191: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2192:
2193: IF FND_MSG_PUB.Check_Msg_Level
2194: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2195: FND_MSG_PUB.Add_Exc_Msg
2196: ( G_PKG_NAME,
2197: l_api_name
2198: );
2199: END IF;

Line 2200: FND_MSG_PUB.Count_And_Get

2196: ( G_PKG_NAME,
2197: l_api_name
2198: );
2199: END IF;
2200: FND_MSG_PUB.Count_And_Get
2201: ( p_count => x_msg_count,
2202: p_data => x_msg_data
2203: );
2204: