eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_TERMS_TMPL_APPROVAL_PVT dependencies on FND_API

Line 27: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

23:
24: ------------------------------------------------------------------------------
25: -- GLOBAL CONSTANTS
26: ------------------------------------------------------------------------------
27: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
28: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
29:
30: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
31: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 28: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

24: ------------------------------------------------------------------------------
25: -- GLOBAL CONSTANTS
26: ------------------------------------------------------------------------------
27: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
28: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
29:
30: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
31: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
32: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 30: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

26: ------------------------------------------------------------------------------
27: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
28: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
29:
30: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
31: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
32: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
33:
34: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

Line 31: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

27: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
28: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
29:
30: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
31: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
32: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
33:
34: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
35: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';

Line 32: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

28: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
29:
30: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
31: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
32: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
33:
34: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
35: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
36: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';

Line 357: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

353: */
354:
355: PROCEDURE start_approval (
356: p_api_version IN Number,
357: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
358: p_commit IN Varchar2 default FND_API.G_FALSE,
359: p_template_id IN Number,
360: p_object_version_number IN Number default NULL,
361: x_return_status OUT NOCOPY Varchar2,

Line 358: p_commit IN Varchar2 default FND_API.G_FALSE,

354:
355: PROCEDURE start_approval (
356: p_api_version IN Number,
357: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
358: p_commit IN Varchar2 default FND_API.G_FALSE,
359: p_template_id IN Number,
360: p_object_version_number IN Number default NULL,
361: x_return_status OUT NOCOPY Varchar2,
362: x_msg_data OUT NOCOPY Varchar2,

Line 426: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

422: -- Standard Start of API savepoint
423: SAVEPOINT g_start_approval_PVT;
424:
425: -- Standard call to check for call compatibility.
426: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: END IF;
429:
430: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

423: SAVEPOINT g_start_approval_PVT;
424:
425: -- Standard call to check for call compatibility.
426: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: END IF;
429:
430: -- Initialize message list if p_init_msg_list is set to TRUE.
431: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 431: IF FND_API.to_Boolean( p_init_msg_list ) THEN

427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: END IF;
429:
430: -- Initialize message list if p_init_msg_list is set to TRUE.
431: IF FND_API.to_Boolean( p_init_msg_list ) THEN
432: FND_MSG_PUB.initialize;
433: END IF;
434:
435: -- Initialize API return status to success

Line 436: x_return_status := FND_API.G_RET_STS_SUCCESS;

432: FND_MSG_PUB.initialize;
433: END IF;
434:
435: -- Initialize API return status to success
436: x_return_status := FND_API.G_RET_STS_SUCCESS;
437:
438:
439: /*IF (l_debug = 'Y') THEN
440: okc_debug.log('600: opening tmpl_exits_csr', 2);

Line 465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

461: x_return_status := G_RET_STS_ERROR;
462: END IF;
463: CLOSE tmpl_exists_csr;
464: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
466: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
467: RAISE FND_API.G_EXC_ERROR;
468: END IF;
469:

Line 467: RAISE FND_API.G_EXC_ERROR;

463: CLOSE tmpl_exists_csr;
464: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
466: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
467: RAISE FND_API.G_EXC_ERROR;
468: END IF;
469:
470: x_return_status := Lock_Row(
471: p_template_id => p_template_id,

Line 488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

484: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_APP_INVALID_STATUS','STATUS',okc_util.decode_lookup('OKC_TERMS_TMPL_STATUS',l_tmpl_rec.status_code));
485: x_return_status := G_RET_STS_ERROR;
486: END IF;
487: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
489: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
490: RAISE FND_API.G_EXC_ERROR;
491: END IF;
492:

Line 490: RAISE FND_API.G_EXC_ERROR;

486: END IF;
487: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
489: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
490: RAISE FND_API.G_EXC_ERROR;
491: END IF;
492:
493: -- 11.5.10+ changes
494: -- Insert records in OKC_TMPL_DRAFT_CLAUSES if p_check_for_drafts = Y

Line 499: p_init_msg_list => FND_API.G_FALSE,

495: IF (p_check_for_drafts = 'Y') THEN
496:
497: OKC_TERMS_UTIL_PVT.create_tmpl_clauses_to_submit (
498: p_api_version => 1,
499: p_init_msg_list => FND_API.G_FALSE,
500: p_template_id => p_template_id,
501: p_org_id => l_tmpl_org_id,
502: x_drafts_present => l_drafts_present,
503: x_return_status => x_return_status,

Line 507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

503: x_return_status => x_return_status,
504: x_msg_count => x_msg_count,
505: x_msg_data => x_msg_data);
506: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
508: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
509: RAISE FND_API.G_EXC_ERROR;
510: END IF;
511:

Line 509: RAISE FND_API.G_EXC_ERROR;

505: x_msg_data => x_msg_data);
506: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
508: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
509: RAISE FND_API.G_EXC_ERROR;
510: END IF;
511:
512: END IF;
513:

Line 517: p_init_msg_list => FND_API.G_FALSE,

513:
514:
515: l_deliverables_exist := okc_terms_util_grp.Is_Deliverable_Exist(
516: p_api_version => 1,
517: p_init_msg_list => FND_API.G_FALSE,
518: x_return_status => x_return_status,
519: x_msg_data => x_msg_data,
520: x_msg_count => x_msg_count,
521: p_doc_type => 'TEMPLATE',

Line 548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

544:
545: END IF;
546:
547: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
549: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
550: RAISE FND_API.G_EXC_ERROR;
551: END IF;
552:

Line 550: RAISE FND_API.G_EXC_ERROR;

546:
547: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
549: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
550: RAISE FND_API.G_EXC_ERROR;
551: END IF;
552:
553: x_qa_return_status := 'S';
554: OKC_TERMS_QA_GRP.QA_Doc (

Line 556: p_init_msg_list => FND_API.G_FALSE,

552:
553: x_qa_return_status := 'S';
554: OKC_TERMS_QA_GRP.QA_Doc (
555: p_api_version => 1,
556: p_init_msg_list => FND_API.G_FALSE,
557: p_commit => FND_API.G_FALSE,
558: x_return_status => x_return_status,
559: x_msg_count => x_msg_count,
560: x_msg_data => x_msg_data,

Line 557: p_commit => FND_API.G_FALSE,

553: x_qa_return_status := 'S';
554: OKC_TERMS_QA_GRP.QA_Doc (
555: p_api_version => 1,
556: p_init_msg_list => FND_API.G_FALSE,
557: p_commit => FND_API.G_FALSE,
558: x_return_status => x_return_status,
559: x_msg_count => x_msg_count,
560: x_msg_data => x_msg_data,
561:

Line 585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

581: x_return_status := G_RET_STS_ERROR;
582: END IF;
583: */
584: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
586: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
587: RAISE FND_API.G_EXC_ERROR;
588: END IF;
589:

Line 587: RAISE FND_API.G_EXC_ERROR;

583: */
584: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
586: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
587: RAISE FND_API.G_EXC_ERROR;
588: END IF;
589:
590: -- 11.5.10+ changes
591: -- check for various conditions to see if we need proceed further

Line 637: p_init_msg_list => FND_API.G_FALSE,

633:
634:
635: change_clause_status (
636: p_api_version => 1,
637: p_init_msg_list => FND_API.G_FALSE,
638: p_commit => FND_API.G_FALSE,
639:
640: x_return_status => x_return_status,
641: x_msg_data => x_msg_data,

Line 638: p_commit => FND_API.G_FALSE,

634:
635: change_clause_status (
636: p_api_version => 1,
637: p_init_msg_list => FND_API.G_FALSE,
638: p_commit => FND_API.G_FALSE,
639:
640: x_return_status => x_return_status,
641: x_msg_data => x_msg_data,
642: x_msg_count => x_msg_count,

Line 650: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

646: p_status => 'PENDING_APPROVAL',
647:
648: -- the call to OKC_TERMS_QA_GRP.QA_Doc will ensure that
649: -- all article validation has been done
650: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
651: x_validation_results => l_art_validation_results);
652:
653: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

650: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
651: x_validation_results => l_art_validation_results);
652:
653: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
655: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
656: -- get the validation results as a simple string
657: -- and add to fnd message stack
658: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, 'change_clause_status', get_error_string(l_art_validation_results));

Line 659: RAISE FND_API.G_EXC_ERROR;

655: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
656: -- get the validation results as a simple string
657: -- and add to fnd message stack
658: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, 'change_clause_status', get_error_string(l_art_validation_results));
659: RAISE FND_API.G_EXC_ERROR;
660: END IF;
661:
662: UPDATE okc_terms_templates_all
663: SET status_code = 'PENDING_APPROVAL',

Line 833: WHEN FND_API.G_EXC_ERROR THEN

829: END IF;
830:
831: EXCEPTION
832:
833: WHEN FND_API.G_EXC_ERROR THEN
834:
835: /*IF (l_debug = 'Y') THEN
836: okc_debug.log('800: Leaving start_approval: OKC_API.G_EXCEPTION_ERROR Exception', 2);
837: END IF;*/

Line 848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

844: ROLLBACK TO g_start_approval_pvt;
845: x_return_status := G_RET_STS_ERROR ;
846: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
847:
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: /*IF (l_debug = 'Y') THEN
850: okc_debug.log('900: Leaving start_approval: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
851: END IF;*/
852:

Line 949: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

945: x_return_status => x_return_status,
946: x_msg_data => x_msg_data,
947: x_msg_count => x_msg_count);
948:
949: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
950: -- some clause validation failed
951: RAISE templ_publish_exception;
952: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
953: -- unexpected error

Line 952: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

948:
949: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
950: -- some clause validation failed
951: RAISE templ_publish_exception;
952: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
953: -- unexpected error
954: RAISE templ_publish_exception;
955: END IF;
956: END IF;

Line 960: p_init_msg_list => FND_API.G_FALSE,

956: END IF;
957:
958: CHANGE_CLAUSE_STATUS (
959: p_api_version => 1,
960: p_init_msg_list => FND_API.G_FALSE,
961: p_commit => FND_API.G_FALSE,
962: p_template_id => l_tmpl_id,
963: p_wf_seq_id => l_tmpl_wf_seq_id,
964: p_status => 'APPROVED',

Line 961: p_commit => FND_API.G_FALSE,

957:
958: CHANGE_CLAUSE_STATUS (
959: p_api_version => 1,
960: p_init_msg_list => FND_API.G_FALSE,
961: p_commit => FND_API.G_FALSE,
962: p_template_id => l_tmpl_id,
963: p_wf_seq_id => l_tmpl_wf_seq_id,
964: p_status => 'APPROVED',
965: x_validation_results => l_validation_results,

Line 971: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

967: x_msg_data => x_msg_data,
968: x_msg_count => x_msg_count);
969:
970:
971: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
972: -- some clause validation failed
973: RAISE clause_sts_exception_1;
974: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
975: -- unexpected error

Line 974: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

970:
971: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
972: -- some clause validation failed
973: RAISE clause_sts_exception_1;
974: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
975: -- unexpected error
976: RAISE clause_sts_exception_2;
977: END IF;
978:

Line 984: p_init_msg_list => FND_API.G_FALSE,

980: (l_tmpl_status = 'REJECTED' AND l_tmpl_wc = 'Y')) THEN
981:
982: OKC_TERMS_UTIL_PVT.merge_template_working_copy(
983: p_api_version => 1,
984: p_init_msg_list => FND_API.G_FALSE,
985: p_commit => FND_API.G_FALSE,
986: p_template_id => l_tmpl_id,
987: x_return_status => x_return_status,
988: x_msg_data => x_msg_data,

Line 985: p_commit => FND_API.G_FALSE,

981:
982: OKC_TERMS_UTIL_PVT.merge_template_working_copy(
983: p_api_version => 1,
984: p_init_msg_list => FND_API.G_FALSE,
985: p_commit => FND_API.G_FALSE,
986: p_template_id => l_tmpl_id,
987: x_return_status => x_return_status,
988: x_msg_data => x_msg_data,
989: x_msg_count => x_msg_count,

Line 1126: p_init_msg_list => FND_API.G_FALSE,

1122: x_return_status := 'S';
1123:
1124: CHANGE_CLAUSE_STATUS (
1125: p_api_version => 1,
1126: p_init_msg_list => FND_API.G_FALSE,
1127: p_commit => FND_API.G_FALSE,
1128: p_template_id => l_tmpl_id,
1129: p_wf_seq_id => l_tmpl_wf_seq_id,
1130: p_status => 'REJECTED',

Line 1127: p_commit => FND_API.G_FALSE,

1123:
1124: CHANGE_CLAUSE_STATUS (
1125: p_api_version => 1,
1126: p_init_msg_list => FND_API.G_FALSE,
1127: p_commit => FND_API.G_FALSE,
1128: p_template_id => l_tmpl_id,
1129: p_wf_seq_id => l_tmpl_wf_seq_id,
1130: p_status => 'REJECTED',
1131: x_validation_results => l_validation_results,

Line 1136: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1132: x_return_status => x_return_status,
1133: x_msg_data => x_msg_data,
1134: x_msg_count => x_msg_count);
1135:
1136: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1137: -- some clause validation failed
1138: RAISE clause_sts_exception_1;
1139: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1140: -- unexpected error

Line 1139: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1135:
1136: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1137: -- some clause validation failed
1138: RAISE clause_sts_exception_1;
1139: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1140: -- unexpected error
1141: RAISE clause_sts_exception_2;
1142: END IF;
1143:

Line 1466: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1462: are returned in this table
1463: */
1464: PROCEDURE change_clause_status (
1465: p_api_version IN NUMBER,
1466: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1467: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1468:
1469: x_return_status OUT NOCOPY VARCHAR2,
1470: x_msg_data OUT NOCOPY VARCHAR2,

Line 1467: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1463: */
1464: PROCEDURE change_clause_status (
1465: p_api_version IN NUMBER,
1466: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1467: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1468:
1469: x_return_status OUT NOCOPY VARCHAR2,
1470: x_msg_data OUT NOCOPY VARCHAR2,
1471: x_msg_count OUT NOCOPY NUMBER,

Line 1476: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

1472:
1473: p_template_id IN NUMBER,
1474: p_wf_seq_id IN NUMBER DEFAULT NULL,
1475: p_status IN VARCHAR2,
1476: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1477: x_validation_results OUT NOCOPY OKC_ART_BLK_PVT.validation_tbl_type)
1478:
1479: IS
1480:

Line 1511: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1507: -- Standard Start of API savepoint
1508: SAVEPOINT change_clause_status_pvt;
1509:
1510: -- Standard call to check for call compatibility.
1511: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1513: END IF;
1514:
1515: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1508: SAVEPOINT change_clause_status_pvt;
1509:
1510: -- Standard call to check for call compatibility.
1511: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1513: END IF;
1514:
1515: -- Initialize message list if p_init_msg_list is set to TRUE.
1516: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1516: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1513: END IF;
1514:
1515: -- Initialize message list if p_init_msg_list is set to TRUE.
1516: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1517: FND_MSG_PUB.initialize;
1518: END IF;
1519:
1520: -- Initialize API return status to success

Line 1521: x_return_status := FND_API.G_RET_STS_SUCCESS;

1517: FND_MSG_PUB.initialize;
1518: END IF;
1519:
1520: -- Initialize API return status to success
1521: x_return_status := FND_API.G_RET_STS_SUCCESS;
1522: l_article_version_id_tbl := OKC_ART_BLK_PVT.NUM_TBL_TYPE();
1523:
1524: IF (p_status NOT IN ('PENDING_APPROVAL', 'APPROVED', 'REJECTED')) THEN
1525: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1525: x_return_status := FND_API.G_RET_STS_ERROR;

1521: x_return_status := FND_API.G_RET_STS_SUCCESS;
1522: l_article_version_id_tbl := OKC_ART_BLK_PVT.NUM_TBL_TYPE();
1523:
1524: IF (p_status NOT IN ('PENDING_APPROVAL', 'APPROVED', 'REJECTED')) THEN
1525: x_return_status := FND_API.G_RET_STS_ERROR;
1526: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
1527: FND_MESSAGE.set_token('ARG_NAME', 'p_status');
1528: FND_MESSAGE.set_token('ARG_VALUE', p_status);
1529: FND_MSG_PUB.add;

Line 1530: RAISE FND_API.G_EXC_ERROR;

1526: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
1527: FND_MESSAGE.set_token('ARG_NAME', 'p_status');
1528: FND_MESSAGE.set_token('ARG_VALUE', p_status);
1529: FND_MSG_PUB.add;
1530: RAISE FND_API.G_EXC_ERROR;
1531: END IF;
1532:
1533: OPEN l_tmpl_csr(p_template_id);
1534: FETCH l_tmpl_csr INTO l_current_org_id;

Line 1536: x_return_status := FND_API.G_RET_STS_ERROR;

1532:
1533: OPEN l_tmpl_csr(p_template_id);
1534: FETCH l_tmpl_csr INTO l_current_org_id;
1535: IF l_tmpl_csr%NOTFOUND THEN
1536: x_return_status := FND_API.G_RET_STS_ERROR;
1537: CLOSE l_tmpl_csr;
1538: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
1539: FND_MESSAGE.set_token('ARG_NAME', 'p_template_id');
1540: FND_MESSAGE.set_token('ARG_VALUE', p_template_id);

Line 1542: RAISE FND_API.G_EXC_ERROR;

1538: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
1539: FND_MESSAGE.set_token('ARG_NAME', 'p_template_id');
1540: FND_MESSAGE.set_token('ARG_VALUE', p_template_id);
1541: FND_MSG_PUB.add;
1542: RAISE FND_API.G_EXC_ERROR;
1543: END IF;
1544:
1545: OPEN l_tmpl_clauses_csr(p_template_id, p_wf_seq_id);
1546: LOOP

Line 1558: p_init_msg_list => FND_API.G_FALSE,

1554:
1555: IF (p_status = 'PENDING_APPROVAL') THEN
1556: OKC_ART_BLK_PVT.PENDING_APPROVAL_BLK(
1557: p_api_version => 1,
1558: p_init_msg_list => FND_API.G_FALSE,
1559: p_commit => FND_API.G_FALSE,
1560: p_validation_level => p_validation_level,
1561:
1562: x_return_status => x_return_status,

Line 1559: p_commit => FND_API.G_FALSE,

1555: IF (p_status = 'PENDING_APPROVAL') THEN
1556: OKC_ART_BLK_PVT.PENDING_APPROVAL_BLK(
1557: p_api_version => 1,
1558: p_init_msg_list => FND_API.G_FALSE,
1559: p_commit => FND_API.G_FALSE,
1560: p_validation_level => p_validation_level,
1561:
1562: x_return_status => x_return_status,
1563: x_msg_count => x_msg_count,

Line 1572: p_init_msg_list => FND_API.G_FALSE,

1568: x_validation_results => x_validation_results);
1569: ELSIF(p_status = 'APPROVED') THEN
1570: OKC_ART_BLK_PVT.APPROVE_BLK(
1571: p_api_version => 1,
1572: p_init_msg_list => FND_API.G_FALSE,
1573: p_commit => FND_API.G_FALSE,
1574:
1575: x_return_status => x_return_status,
1576: x_msg_count => x_msg_count,

Line 1573: p_commit => FND_API.G_FALSE,

1569: ELSIF(p_status = 'APPROVED') THEN
1570: OKC_ART_BLK_PVT.APPROVE_BLK(
1571: p_api_version => 1,
1572: p_init_msg_list => FND_API.G_FALSE,
1573: p_commit => FND_API.G_FALSE,
1574:
1575: x_return_status => x_return_status,
1576: x_msg_count => x_msg_count,
1577: x_msg_data => x_msg_data,

Line 1585: p_init_msg_list => FND_API.G_FALSE,

1581: x_validation_results => x_validation_results);
1582: ELSIF(p_status = 'REJECTED') THEN
1583: OKC_ART_BLK_PVT.REJECT_BLK(
1584: p_api_version => 1,
1585: p_init_msg_list => FND_API.G_FALSE,
1586: p_commit => FND_API.G_FALSE,
1587:
1588: x_return_status => x_return_status,
1589: x_msg_count => x_msg_count,

Line 1586: p_commit => FND_API.G_FALSE,

1582: ELSIF(p_status = 'REJECTED') THEN
1583: OKC_ART_BLK_PVT.REJECT_BLK(
1584: p_api_version => 1,
1585: p_init_msg_list => FND_API.G_FALSE,
1586: p_commit => FND_API.G_FALSE,
1587:
1588: x_return_status => x_return_status,
1589: x_msg_count => x_msg_count,
1590: x_msg_data => x_msg_data,

Line 1597: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1593: p_art_ver_tbl => l_article_version_id_tbl,
1594: x_validation_results => x_validation_results);
1595: END IF;
1596:
1597: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1598: RAISE FND_API.G_EXC_ERROR ;
1599: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1601: END IF;

Line 1598: RAISE FND_API.G_EXC_ERROR ;

1594: x_validation_results => x_validation_results);
1595: END IF;
1596:
1597: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1598: RAISE FND_API.G_EXC_ERROR ;
1599: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1601: END IF;
1602:

Line 1599: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1595: END IF;
1596:
1597: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1598: RAISE FND_API.G_EXC_ERROR ;
1599: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1601: END IF;
1602:
1603: END LOOP;

Line 1600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1596:
1597: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1598: RAISE FND_API.G_EXC_ERROR ;
1599: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1601: END IF;
1602:
1603: END LOOP;
1604:

Line 1613: IF(FND_API.to_boolean(p_commit)) THEN

1609:
1610: -- Standard call to get message count and if count is 1, get message info.
1611: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1612:
1613: IF(FND_API.to_boolean(p_commit)) THEN
1614: COMMIT;
1615: END IF;
1616:
1617: /*IF (l_debug = 'Y') THEN

Line 1628: WHEN FND_API.G_EXC_ERROR THEN

1624: END IF;
1625:
1626: EXCEPTION
1627:
1628: WHEN FND_API.G_EXC_ERROR THEN
1629:
1630: /*IF (l_debug = 'Y') THEN
1631: okc_debug.log('800: Leaving change_clause_status: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1632: END IF;*/

Line 1650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1646: ROLLBACK TO change_clause_status_pvt;
1647: x_return_status := G_RET_STS_ERROR ;
1648: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1649:
1650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1651: /*IF (l_debug = 'Y') THEN
1652: okc_debug.log('900: Leaving change_clause_status: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1653: END IF;*/
1654:

Line 1867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1863: FETCH adoption_type_meaning_csr INTO adoption_type_desc;
1864: CLOSE adoption_type_meaning_csr;
1865:
1866: if (org_name is null ) then
1867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1868: end if ;
1869:
1870: if (adoption_type_desc is null ) then
1871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1868: end if ;
1869:
1870: if (adoption_type_desc is null ) then
1871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1872: end if ;
1873:
1874: wf_engine.setItemAttrText(itemtype, itemkey, 'ADOPTION_DESC', adoption_type_desc);
1875: wf_engine.setItemAttrText(itemtype, itemkey, 'ADOPTION_TYPE', operation);

Line 1893: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1889:
1890: RETURN;
1891: END IF; --if func mode is 'RUN'
1892: EXCEPTION
1893: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1894: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'set_notified ', itemtype,
1895: itemkey, to_char(actid), funcmode);
1896: RAISE;
1897: WHEN OTHERS THEN

Line 2056: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2052: -- in table OKC_TMPL_DRAFT_CLAUSES will have the selected_yn flag set to Y
2053: --
2054: PROCEDURE select_draft_clauses(
2055: p_api_version IN NUMBER,
2056: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2057: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2058:
2059: x_return_status OUT NOCOPY VARCHAR2,
2060: x_msg_data OUT NOCOPY VARCHAR2,

Line 2057: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2053: --
2054: PROCEDURE select_draft_clauses(
2055: p_api_version IN NUMBER,
2056: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2057: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2058:
2059: x_return_status OUT NOCOPY VARCHAR2,
2060: x_msg_data OUT NOCOPY VARCHAR2,
2061: x_msg_count OUT NOCOPY NUMBER,

Line 2083: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

2079: -- Standard Start of API savepoint
2080: SAVEPOINT select_draft_clauses_pvt;
2081:
2082: -- Standard call to check for call compatibility.
2083: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2085: END IF;
2086:
2087: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2080: SAVEPOINT select_draft_clauses_pvt;
2081:
2082: -- Standard call to check for call compatibility.
2083: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2085: END IF;
2086:
2087: -- Initialize message list if p_init_msg_list is set to TRUE.
2088: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2088: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2085: END IF;
2086:
2087: -- Initialize message list if p_init_msg_list is set to TRUE.
2088: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2089: FND_MSG_PUB.initialize;
2090: END IF;
2091:
2092: -- Initialize API return status to success

Line 2093: x_return_status := FND_API.G_RET_STS_SUCCESS;

2089: FND_MSG_PUB.initialize;
2090: END IF;
2091:
2092: -- Initialize API return status to success
2093: x_return_status := FND_API.G_RET_STS_SUCCESS;
2094:
2095: UPDATE OKC_TMPL_DRAFT_CLAUSES
2096: SET selected_yn = 'Y'
2097: WHERE template_id = (

Line 2104: IF(FND_API.to_boolean(p_commit)) THEN

2100:
2101: -- Standard call to get message count and if count is 1, get message info.
2102: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2103:
2104: IF(FND_API.to_boolean(p_commit)) THEN
2105: COMMIT;
2106: END IF;
2107:
2108: /*IF (l_debug = 'Y') THEN

Line 2119: WHEN FND_API.G_EXC_ERROR THEN

2115: END IF;
2116:
2117: EXCEPTION
2118:
2119: WHEN FND_API.G_EXC_ERROR THEN
2120:
2121: /*IF (l_debug = 'Y') THEN
2122: okc_debug.log('800: Leaving select_draft_clauses: OKC_API.G_EXCEPTION_ERROR Exception', 2);
2123: END IF;*/

Line 2134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2130: ROLLBACK TO change_clause_status_pvt;
2131: x_return_status := G_RET_STS_ERROR ;
2132: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2133:
2134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2135: /*IF (l_debug = 'Y') THEN
2136: okc_debug.log('900: Leaving select_draft_clauses: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2137: END IF;*/
2138: