DBA Data[Home] [Help]

APPS.ZX_NEW_SERVICES_PKG dependencies on FND_API

Line 85: IF NOT FND_API.Compatible_API_Call( l_api_version,

81:
82: /*--------------------------------------------------+
83: | Standard call to check for call compatibility |
84: +--------------------------------------------------*/
85: IF NOT FND_API.Compatible_API_Call( l_api_version,
86: p_api_version,
87: l_api_name,
88: G_PKG_NAME
89: ) THEN

Line 90: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

86: p_api_version,
87: l_api_name,
88: G_PKG_NAME
89: ) THEN
90: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
91: END IF;
92:
93: /*--------------------------------------------------------------+
94: | Initialize message list if p_init_msg_list is set to TRUE |

Line 97: l_init_msg_list := FND_API.G_FALSE;

93: /*--------------------------------------------------------------+
94: | Initialize message list if p_init_msg_list is set to TRUE |
95: +--------------------------------------------------------------*/
96: IF p_init_msg_list is null THEN
97: l_init_msg_list := FND_API.G_FALSE;
98: ELSE
99: l_init_msg_list := p_init_msg_list;
100: END IF;
101:

Line 102: IF FND_API.to_Boolean(l_init_msg_list) THEN

98: ELSE
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: /*-----------------------------------------+

Line 109: x_return_status := FND_API.G_RET_STS_SUCCESS;

105:
106: /*-----------------------------------------+
107: | Initialize return status to SUCCESS |
108: +-----------------------------------------*/
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110:
111: /*-----------------------------------------+
112: | Populate Global Variable |
113: +-----------------------------------------*/

Line 179: x_return_status := FND_API.G_RET_STS_SUCCESS;

175: 'ZX_NEW_SERVICES_PKG: '||l_api_name||'()+');
176: END IF;
177:
178: -- Initialize API return status to success
179: x_return_status := FND_API.G_RET_STS_SUCCESS;
180:
181: FORALL i IN NVL(p_trx_line_dist_id_tbl.FIRST,0) ..NVL(p_trx_line_dist_id_tbl.LAST, -1)
182: UPDATE ZX_REC_NREC_DIST
183: SET freeze_flag = 'Y',

Line 207: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

203: AND trx_id = p_transaction_rec.trx_id
204: AND trx_line_dist_id = p_trx_line_dist_id_tbl(i)
205: );
206:
207: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
208: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
209: FND_LOG.STRING(G_LEVEL_PROCEDURE,
210: G_MODULE_NAME||l_api_name,
211: 'Exception:' ||SQLCODE||';'||SQLERRM);

Line 216: RAISE FND_API.G_EXC_ERROR;

212: FND_LOG.STRING(G_LEVEL_PROCEDURE,
213: G_MODULE_NAME||l_api_name,
214: 'Return Status = '||l_return_status);
215: END IF;
216: RAISE FND_API.G_EXC_ERROR;
217: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
218: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
219: FND_LOG.STRING(G_LEVEL_PROCEDURE,
220: G_MODULE_NAME||l_api_name,

Line 217: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

213: G_MODULE_NAME||l_api_name,
214: 'Return Status = '||l_return_status);
215: END IF;
216: RAISE FND_API.G_EXC_ERROR;
217: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
218: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
219: FND_LOG.STRING(G_LEVEL_PROCEDURE,
220: G_MODULE_NAME||l_api_name,
221: 'Exception:' ||SQLCODE||';'||SQLERRM);

Line 227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

223: FND_LOG.STRING(G_LEVEL_PROCEDURE,
224: G_MODULE_NAME||l_api_name,
225: 'Return Status = '||l_return_status);
226: END IF;
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: END IF;
229:
230: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
231: FND_LOG.STRING(G_LEVEL_PROCEDURE,

Line 237: WHEN FND_API.G_EXC_ERROR THEN

233: 'ZX_NEW_SERVICES_PKG: '||l_api_name||'()-');
234: END IF;
235:
236: EXCEPTION
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.|

Line 239: x_return_status := FND_API.G_RET_STS_ERROR ;

235:
236: EXCEPTION
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 |

Line 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:

Line 254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

250: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
251: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
252: END IF;
253:
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;

Line 256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

252: END IF;
253:
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.|

Line 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

Line 274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

270: END IF;
271:
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.|

Line 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