5: | Global Data Types |
6: * ======================================================================*/
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_NEW_SERVICES_PKG';
9: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
10: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
11: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
12: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
13: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
6: * ======================================================================*/
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_NEW_SERVICES_PKG';
9: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
10: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
11: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
12: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
13: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
14: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_NEW_SERVICES_PKG';
9: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
10: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
11: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
12: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
13: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
14: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
15: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_NEW_SERVICES_PKG';
9: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
10: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
11: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
12: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
13: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
14: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
15: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
16:
9: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
10: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
11: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
12: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
13: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
14: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
15: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
16:
17: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
10: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
11: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
12: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
13: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
14: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
15: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
16:
17: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
18: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
99: l_init_msg_list := p_init_msg_list;
100: END IF;
101:
102: IF FND_API.to_Boolean(l_init_msg_list) THEN
103: FND_MSG_PUB.initialize;
104: END IF;
105:
106: /*-----------------------------------------+
107: | Initialize return status to SUCCESS |
237: WHEN FND_API.G_EXC_ERROR THEN
238: ROLLBACK TO freeze_tax_dists_for_itms_PVT;
239: x_return_status := FND_API.G_RET_STS_ERROR ;
240: /*---------------------------------------------------------+
241: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
242: | in the message stack. If there is only one message in |
243: | the stack it retrieves this message |
244: +---------------------------------------------------------*/
245: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
241: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
242: | in the message stack. If there is only one message in |
243: | the stack it retrieves this message |
244: +---------------------------------------------------------*/
245: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
246: p_count => x_msg_count,
247: p_data => x_msg_data
248: );
249:
254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
255: ROLLBACK TO freeze_tax_dists_for_itms_PVT;
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
257: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
258: FND_MSG_PUB.Add;
259: /*---------------------------------------------------------+
260: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
261: | in the message stack. If there is only one message in |
262: | the stack it retrieves this message |
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
257: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
258: FND_MSG_PUB.Add;
259: /*---------------------------------------------------------+
260: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
261: | in the message stack. If there is only one message in |
262: | the stack it retrieves this message |
263: +---------------------------------------------------------*/
264: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
260: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
261: | in the message stack. If there is only one message in |
262: | the stack it retrieves this message |
263: +---------------------------------------------------------*/
264: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
265: p_count => x_msg_count,
266: p_data => x_msg_data
267: );
268: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
272: WHEN OTHERS THEN
273: ROLLBACK TO freeze_tax_dists_for_itms_PVT;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
275: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
276: FND_MSG_PUB.Add;
277: /*---------------------------------------------------------+
278: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
279: | in the message stack. If there is only one message in |
280: | the stack it retrieves this message |
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
275: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
276: FND_MSG_PUB.Add;
277: /*---------------------------------------------------------+
278: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
279: | in the message stack. If there is only one message in |
280: | the stack it retrieves this message |
281: +---------------------------------------------------------*/
282: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
278: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
279: | in the message stack. If there is only one message in |
280: | the stack it retrieves this message |
281: +---------------------------------------------------------*/
282: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
283: p_count => x_msg_count,
284: p_data => x_msg_data
285: );
286: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN