DBA Data[Home] [Help]

APPS.PO_MASS_UPDATE dependencies on FND_API

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

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

Line 288: p_init_msg_list => FND_API.G_FALSE,

284: x_progress := '005';
285:
286: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
287: p_api_version => 1.0,
288: p_init_msg_list => FND_API.G_FALSE,
289: p_commit => FND_API.G_FALSE,
290: p_bus_docs_tbl => l_busdocs_tbl,
291: p_original_internal_contact_id => x_old_buyer_id,
292: p_new_internal_contact_id => x_new_buyer_id,

Line 289: p_commit => FND_API.G_FALSE,

285:
286: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
287: p_api_version => 1.0,
288: p_init_msg_list => FND_API.G_FALSE,
289: p_commit => FND_API.G_FALSE,
290: p_bus_docs_tbl => l_busdocs_tbl,
291: p_original_internal_contact_id => x_old_buyer_id,
292: p_new_internal_contact_id => x_new_buyer_id,
293: x_msg_data => l_msg_data,

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

293: x_msg_data => l_msg_data,
294: x_msg_count => l_msg_count,
295: x_return_status => l_return_status);
296:
297: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
298: -- get message to log and raise error
299: FND_MSG_PUB.Count_and_Get(p_count => l_msg_count
300: ,p_data => l_msg_data);
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

297: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
298: -- get message to log and raise error
299: FND_MSG_PUB.Count_and_Get(p_count => l_msg_count
300: ,p_data => l_msg_data);
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: END IF;
303:
304: END IF;
305: /* CONTERMS FPJ END */

Line 333: p_init_msg_list => FND_API.G_FALSE,

329: IF (l_busdocs_tbl.COUNT >= 1) THEN
330:
331: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
332: p_api_version => 1.0,
333: p_init_msg_list => FND_API.G_FALSE,
334: p_commit => FND_API.G_FALSE,
335: p_bus_docs_tbl => l_busdocs_tbl,
336: p_original_internal_contact_id => x_old_buyer_id,
337: p_new_internal_contact_id => x_new_buyer_id,

Line 334: p_commit => FND_API.G_FALSE,

330:
331: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
332: p_api_version => 1.0,
333: p_init_msg_list => FND_API.G_FALSE,
334: p_commit => FND_API.G_FALSE,
335: p_bus_docs_tbl => l_busdocs_tbl,
336: p_original_internal_contact_id => x_old_buyer_id,
337: p_new_internal_contact_id => x_new_buyer_id,
338: x_msg_data => l_msg_data,

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

338: x_msg_data => l_msg_data,
339: x_msg_count => l_msg_count,
340: x_return_status => l_return_status);
341:
342: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
343: -- get message to log and raise error
344: FND_MSG_PUB.Count_and_Get(p_count => l_msg_count
345: ,p_data => l_msg_data);
346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

342: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
343: -- get message to log and raise error
344: FND_MSG_PUB.Count_and_Get(p_count => l_msg_count
345: ,p_data => l_msg_data);
346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
347: END IF;
348: END IF;
349: /* CONTERMS FPJ END */
350:

Line 421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

417: COMMIT;
418:
419: EXCEPTION
420: /* CONTERMS FPJ START */
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
422: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
423: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
424: IF (g_fnd_debug='Y') THEN
425: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN