DBA Data[Home] [Help]

APPS.PO_MASS_UPDATE dependencies on FND_API

Line 107: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

103:
104: l_row_index PLS_INTEGER := 0; --separate row count for POs with conterms
105:
106: -- out parameters for the contracts group API
107: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
108: l_msg_count NUMBER;
109: l_msg_data VARCHAR2(2000);
110: /* CONTERMS FPJ */
111:

Line 270: p_init_msg_list => FND_API.G_FALSE,

266: x_progress := '005';
267:
268: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
269: p_api_version => 1.0,
270: p_init_msg_list => FND_API.G_FALSE,
271: p_commit => FND_API.G_FALSE,
272: p_bus_docs_tbl => l_busdocs_tbl,
273: p_original_internal_contact_id => x_old_buyer_id,
274: p_new_internal_contact_id => x_new_buyer_id,

Line 271: p_commit => FND_API.G_FALSE,

267:
268: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
269: p_api_version => 1.0,
270: p_init_msg_list => FND_API.G_FALSE,
271: p_commit => FND_API.G_FALSE,
272: p_bus_docs_tbl => l_busdocs_tbl,
273: p_original_internal_contact_id => x_old_buyer_id,
274: p_new_internal_contact_id => x_new_buyer_id,
275: x_msg_data => l_msg_data,

Line 279: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

275: x_msg_data => l_msg_data,
276: x_msg_count => l_msg_count,
277: x_return_status => l_return_status);
278:
279: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
280: -- get message to log and raise error
281: FND_MSG_PUB.Count_and_Get(p_count => l_msg_count
282: ,p_data => l_msg_data);
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

279: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
280: -- get message to log and raise error
281: FND_MSG_PUB.Count_and_Get(p_count => l_msg_count
282: ,p_data => l_msg_data);
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;
285:
286: END IF;
287: /* CONTERMS FPJ END */

Line 315: p_init_msg_list => FND_API.G_FALSE,

311: IF (l_busdocs_tbl.COUNT >= 1) THEN
312:
313: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
314: p_api_version => 1.0,
315: p_init_msg_list => FND_API.G_FALSE,
316: p_commit => FND_API.G_FALSE,
317: p_bus_docs_tbl => l_busdocs_tbl,
318: p_original_internal_contact_id => x_old_buyer_id,
319: p_new_internal_contact_id => x_new_buyer_id,

Line 316: p_commit => FND_API.G_FALSE,

312:
313: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
314: p_api_version => 1.0,
315: p_init_msg_list => FND_API.G_FALSE,
316: p_commit => FND_API.G_FALSE,
317: p_bus_docs_tbl => l_busdocs_tbl,
318: p_original_internal_contact_id => x_old_buyer_id,
319: p_new_internal_contact_id => x_new_buyer_id,
320: x_msg_data => l_msg_data,

Line 324: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

320: x_msg_data => l_msg_data,
321: x_msg_count => l_msg_count,
322: x_return_status => l_return_status);
323:
324: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
325: -- get message to log and raise error
326: FND_MSG_PUB.Count_and_Get(p_count => l_msg_count
327: ,p_data => l_msg_data);
328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

324: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
325: -- get message to log and raise error
326: FND_MSG_PUB.Count_and_Get(p_count => l_msg_count
327: ,p_data => l_msg_data);
328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: END IF;
330: END IF;
331: /* CONTERMS FPJ END */
332:

Line 386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

382: COMMIT;
383:
384: EXCEPTION
385: /* CONTERMS FPJ START */
386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
387: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
388: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
389: IF (g_fnd_debug='Y') THEN
390: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN