DBA Data[Home] [Help]

APPS.OKC_ARTWF_PVT dependencies on FND_API

Line 486: p_init_msg_list => FND_API.G_TRUE,

482: end if;
483: --
484: OKC_ARTICLE_STATUS_CHANGE_PVT.pending_approval(
485: p_api_version => 1.0,
486: p_init_msg_list => FND_API.G_TRUE,
487: x_return_status => x_result,
488: x_msg_count => x_msg_count,
489: x_msg_data => x_msg_data,
490: p_current_org_id => p_org_id,

Line 496: if x_result = fnd_api.G_RET_STS_UNEXP_ERROR

492: p_article_version_id => p_article_version_id,
493: p_article_title => c_tab(write_ptr).article_title,
494: p_article_version_number => c_tab(write_ptr).article_version_number
495: );
496: if x_result = fnd_api.G_RET_STS_UNEXP_ERROR
497: or
498: x_result = fnd_api.G_RET_STS_ERROR then
499: raise fnd_api.G_EXC_ERROR;
500: end if;

Line 498: x_result = fnd_api.G_RET_STS_ERROR then

494: p_article_version_number => c_tab(write_ptr).article_version_number
495: );
496: if x_result = fnd_api.G_RET_STS_UNEXP_ERROR
497: or
498: x_result = fnd_api.G_RET_STS_ERROR then
499: raise fnd_api.G_EXC_ERROR;
500: end if;
501: --
502: x_result := fnd_api.G_RET_STS_SUCCESS;

Line 499: raise fnd_api.G_EXC_ERROR;

495: );
496: if x_result = fnd_api.G_RET_STS_UNEXP_ERROR
497: or
498: x_result = fnd_api.G_RET_STS_ERROR then
499: raise fnd_api.G_EXC_ERROR;
500: end if;
501: --
502: x_result := fnd_api.G_RET_STS_SUCCESS;
503: commit;

Line 502: x_result := fnd_api.G_RET_STS_SUCCESS;

498: x_result = fnd_api.G_RET_STS_ERROR then
499: raise fnd_api.G_EXC_ERROR;
500: end if;
501: --
502: x_result := fnd_api.G_RET_STS_SUCCESS;
503: commit;
504: return;
505:
506: exception

Line 517: when fnd_api.G_EXC_ERROR then

513: c_tab(error_ptr-1).global_yn := null;
514: c_tab(error_ptr-1).ikey := 'OKC_ARTICLE_WRONG_STATUS4APPROVAL';
515: error_ptr := error_ptr-1;
516: close cv;
517: when fnd_api.G_EXC_ERROR then
518: c_tab(error_ptr-1).org_id := p_org_id;
519: c_tab(error_ptr-1).article_id := null;
520: c_tab(error_ptr-1).article_version_id := p_article_version_id;
521: c_tab(error_ptr-1).article_status := 'APPROVAL_ERROR';

Line 569: p_init_msg_list => FND_API.G_TRUE,

565: end if;
566: --
567: OKC_ARTICLE_STATUS_CHANGE_PVT.pending_approval(
568: p_api_version => 1.0,
569: p_init_msg_list => FND_API.G_TRUE,
570: x_return_status => x_result,
571: x_msg_count => x_msg_count,
572: x_msg_data => x_msg_data,
573: p_current_org_id => p_org_id,

Line 579: if x_result = fnd_api.G_RET_STS_UNEXP_ERROR

575: p_article_version_id => p_article_version_id,
576: p_article_title => c_tab(write_ptr).article_title,
577: p_article_version_number => c_tab(write_ptr).article_version_number
578: );
579: if x_result = fnd_api.G_RET_STS_UNEXP_ERROR
580: or
581: x_result = fnd_api.G_RET_STS_ERROR then
582: raise fnd_api.G_EXC_ERROR;
583: end if;

Line 581: x_result = fnd_api.G_RET_STS_ERROR then

577: p_article_version_number => c_tab(write_ptr).article_version_number
578: );
579: if x_result = fnd_api.G_RET_STS_UNEXP_ERROR
580: or
581: x_result = fnd_api.G_RET_STS_ERROR then
582: raise fnd_api.G_EXC_ERROR;
583: end if;
584: --
585: x_result := fnd_api.G_RET_STS_SUCCESS;

Line 582: raise fnd_api.G_EXC_ERROR;

578: );
579: if x_result = fnd_api.G_RET_STS_UNEXP_ERROR
580: or
581: x_result = fnd_api.G_RET_STS_ERROR then
582: raise fnd_api.G_EXC_ERROR;
583: end if;
584: --
585: x_result := fnd_api.G_RET_STS_SUCCESS;
586: commit;

Line 585: x_result := fnd_api.G_RET_STS_SUCCESS;

581: x_result = fnd_api.G_RET_STS_ERROR then
582: raise fnd_api.G_EXC_ERROR;
583: end if;
584: --
585: x_result := fnd_api.G_RET_STS_SUCCESS;
586: commit;
587: return;
588:
589: exception

Line 600: x_result := fnd_api.G_RET_STS_ERROR;

596: c_tab(error_ptr-1).global_yn := null;
597: c_tab(error_ptr-1).ikey := 'OKC_ARTICLE_WRONG_STATUS4ADOPTION';
598: error_ptr := error_ptr-1;
599: close ca;
600: x_result := fnd_api.G_RET_STS_ERROR;
601: when fnd_api.G_EXC_ERROR then
602: c_tab(error_ptr-1).org_id := p_org_id;
603: c_tab(error_ptr-1).article_id := null;
604: c_tab(error_ptr-1).article_version_id := p_article_version_id;

Line 601: when fnd_api.G_EXC_ERROR then

597: c_tab(error_ptr-1).ikey := 'OKC_ARTICLE_WRONG_STATUS4ADOPTION';
598: error_ptr := error_ptr-1;
599: close ca;
600: x_result := fnd_api.G_RET_STS_ERROR;
601: when fnd_api.G_EXC_ERROR then
602: c_tab(error_ptr-1).org_id := p_org_id;
603: c_tab(error_ptr-1).article_id := null;
604: c_tab(error_ptr-1).article_version_id := p_article_version_id;
605: c_tab(error_ptr-1).article_status := 'ADOPTION_ERROR';

Line 621: x_result := fnd_api.G_RET_STS_ERROR;

617: c_tab(error_ptr-1).global_yn := null;
618: c_tab(error_ptr-1).ikey := 'OKC_ARTICLE_UNEXPECTED_ERROR';
619: error_ptr := error_ptr-1;
620: close ca;
621: x_result := fnd_api.G_RET_STS_ERROR;
622: end;
623: end;
624:
625: -- check the version and print result (for testing - don't use in apps code)

Line 1356: if x_result = fnd_api.G_RET_STS_SUCCESS then

1352: wf_result := 'NOK';
1353: fnd_msg_pub.initialize;
1354: clean;
1355: check_status(org_id, article_version_id, x_result, x_msg_count, x_msg_data);
1356: if x_result = fnd_api.G_RET_STS_SUCCESS then
1357: start_wf_processes(wf_result);
1358: end if;
1359: result := wf_result;
1360: exception