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 372: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

368: */
369:
370: PROCEDURE start_approval (
371: p_api_version IN Number,
372: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
373: p_commit IN Varchar2 default FND_API.G_FALSE,
374: p_template_id IN Number,
375: p_object_version_number IN Number default NULL,
376: x_return_status OUT NOCOPY Varchar2,

Line 373: p_commit IN Varchar2 default FND_API.G_FALSE,

369:
370: PROCEDURE start_approval (
371: p_api_version IN Number,
372: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
373: p_commit IN Varchar2 default FND_API.G_FALSE,
374: p_template_id IN Number,
375: p_object_version_number IN Number default NULL,
376: x_return_status OUT NOCOPY Varchar2,
377: x_msg_data OUT NOCOPY Varchar2,

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

437: -- Standard Start of API savepoint
438: SAVEPOINT g_start_approval_PVT;
439:
440: -- Standard call to check for call compatibility.
441: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
443: END IF;
444:
445: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

438: SAVEPOINT g_start_approval_PVT;
439:
440: -- Standard call to check for call compatibility.
441: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
443: END IF;
444:
445: -- Initialize message list if p_init_msg_list is set to TRUE.
446: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 446: IF FND_API.to_Boolean( p_init_msg_list ) THEN

442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
443: END IF;
444:
445: -- Initialize message list if p_init_msg_list is set to TRUE.
446: IF FND_API.to_Boolean( p_init_msg_list ) THEN
447: FND_MSG_PUB.initialize;
448: END IF;
449:
450: -- Initialize API return status to success

Line 451: x_return_status := FND_API.G_RET_STS_SUCCESS;

447: FND_MSG_PUB.initialize;
448: END IF;
449:
450: -- Initialize API return status to success
451: x_return_status := FND_API.G_RET_STS_SUCCESS;
452:
453:
454: /*IF (l_debug = 'Y') THEN
455: okc_debug.log('600: opening tmpl_exits_csr', 2);

Line 480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

476: x_return_status := G_RET_STS_ERROR;
477: END IF;
478: CLOSE tmpl_exists_csr;
479: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
481: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
482: RAISE FND_API.G_EXC_ERROR;
483: END IF;
484:

Line 482: RAISE FND_API.G_EXC_ERROR;

478: CLOSE tmpl_exists_csr;
479: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
481: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
482: RAISE FND_API.G_EXC_ERROR;
483: END IF;
484:
485: x_return_status := Lock_Row(
486: p_template_id => p_template_id,

Line 503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

499: 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));
500: x_return_status := G_RET_STS_ERROR;
501: END IF;
502: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
504: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
505: RAISE FND_API.G_EXC_ERROR;
506: END IF;
507:

Line 505: RAISE FND_API.G_EXC_ERROR;

501: END IF;
502: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
504: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
505: RAISE FND_API.G_EXC_ERROR;
506: END IF;
507:
508: -- 11.5.10+ changes
509: -- Insert records in OKC_TMPL_DRAFT_CLAUSES if p_check_for_drafts = Y

Line 514: p_init_msg_list => FND_API.G_FALSE,

510: IF (p_check_for_drafts = 'Y') THEN
511:
512: OKC_TERMS_UTIL_PVT.create_tmpl_clauses_to_submit (
513: p_api_version => 1,
514: p_init_msg_list => FND_API.G_FALSE,
515: p_template_id => p_template_id,
516: p_org_id => l_tmpl_org_id,
517: x_drafts_present => l_drafts_present,
518: x_return_status => x_return_status,

Line 522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

518: x_return_status => x_return_status,
519: x_msg_count => x_msg_count,
520: x_msg_data => x_msg_data);
521: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
523: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
524: RAISE FND_API.G_EXC_ERROR;
525: END IF;
526:

Line 524: RAISE FND_API.G_EXC_ERROR;

520: x_msg_data => x_msg_data);
521: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
523: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
524: RAISE FND_API.G_EXC_ERROR;
525: END IF;
526:
527: END IF;
528:

Line 532: p_init_msg_list => FND_API.G_FALSE,

528:
529:
530: l_deliverables_exist := okc_terms_util_grp.Is_Deliverable_Exist(
531: p_api_version => 1,
532: p_init_msg_list => FND_API.G_FALSE,
533: x_return_status => x_return_status,
534: x_msg_data => x_msg_data,
535: x_msg_count => x_msg_count,
536: p_doc_type => 'TEMPLATE',

Line 563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

559:
560: END IF;
561:
562: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
564: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
565: RAISE FND_API.G_EXC_ERROR;
566: END IF;
567:

Line 565: RAISE FND_API.G_EXC_ERROR;

561:
562: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
564: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
565: RAISE FND_API.G_EXC_ERROR;
566: END IF;
567:
568: x_qa_return_status := 'S';
569: OKC_TERMS_QA_GRP.QA_Doc (

Line 571: p_init_msg_list => FND_API.G_FALSE,

567:
568: x_qa_return_status := 'S';
569: OKC_TERMS_QA_GRP.QA_Doc (
570: p_api_version => 1,
571: p_init_msg_list => FND_API.G_FALSE,
572: p_commit => FND_API.G_FALSE,
573: x_return_status => x_return_status,
574: x_msg_count => x_msg_count,
575: x_msg_data => x_msg_data,

Line 572: p_commit => FND_API.G_FALSE,

568: x_qa_return_status := 'S';
569: OKC_TERMS_QA_GRP.QA_Doc (
570: p_api_version => 1,
571: p_init_msg_list => FND_API.G_FALSE,
572: p_commit => FND_API.G_FALSE,
573: x_return_status => x_return_status,
574: x_msg_count => x_msg_count,
575: x_msg_data => x_msg_data,
576:

Line 600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

596: x_return_status := G_RET_STS_ERROR;
597: END IF;
598: */
599: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
601: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
602: RAISE FND_API.G_EXC_ERROR;
603: END IF;
604:

Line 602: RAISE FND_API.G_EXC_ERROR;

598: */
599: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
601: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
602: RAISE FND_API.G_EXC_ERROR;
603: END IF;
604:
605: -- 11.5.10+ changes
606: -- check for various conditions to see if we need proceed further

Line 652: p_init_msg_list => FND_API.G_FALSE,

648:
649:
650: change_clause_status (
651: p_api_version => 1,
652: p_init_msg_list => FND_API.G_FALSE,
653: p_commit => FND_API.G_FALSE,
654:
655: x_return_status => x_return_status,
656: x_msg_data => x_msg_data,

Line 653: p_commit => FND_API.G_FALSE,

649:
650: change_clause_status (
651: p_api_version => 1,
652: p_init_msg_list => FND_API.G_FALSE,
653: p_commit => FND_API.G_FALSE,
654:
655: x_return_status => x_return_status,
656: x_msg_data => x_msg_data,
657: x_msg_count => x_msg_count,

Line 665: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

661: p_status => 'PENDING_APPROVAL',
662:
663: -- the call to OKC_TERMS_QA_GRP.QA_Doc will ensure that
664: -- all article validation has been done
665: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
666: x_validation_results => l_art_validation_results);
667:
668: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

665: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
666: x_validation_results => l_art_validation_results);
667:
668: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
670: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
671: -- get the validation results as a simple string
672: -- and add to fnd message stack
673: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, 'change_clause_status', get_error_string(l_art_validation_results));

Line 674: RAISE FND_API.G_EXC_ERROR;

670: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
671: -- get the validation results as a simple string
672: -- and add to fnd message stack
673: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, 'change_clause_status', get_error_string(l_art_validation_results));
674: RAISE FND_API.G_EXC_ERROR;
675: END IF;
676:
677: UPDATE okc_terms_templates_all
678: SET status_code = 'PENDING_APPROVAL',

Line 848: WHEN FND_API.G_EXC_ERROR THEN

844: END IF;
845:
846: EXCEPTION
847:
848: WHEN FND_API.G_EXC_ERROR THEN
849:
850: /*IF (l_debug = 'Y') THEN
851: okc_debug.log('800: Leaving start_approval: OKC_API.G_EXCEPTION_ERROR Exception', 2);
852: END IF;*/

Line 863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

859: ROLLBACK TO g_start_approval_pvt;
860: x_return_status := G_RET_STS_ERROR ;
861: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
862:
863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: /*IF (l_debug = 'Y') THEN
865: okc_debug.log('900: Leaving start_approval: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
866: END IF;*/
867:

Line 974: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

970: x_return_status => x_return_status,
971: x_msg_data => x_msg_data,
972: x_msg_count => x_msg_count);
973:
974: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
975: -- some clause validation failed
976: RAISE templ_publish_exception;
977: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
978: -- unexpected error

Line 977: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

973:
974: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
975: -- some clause validation failed
976: RAISE templ_publish_exception;
977: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
978: -- unexpected error
979: RAISE templ_publish_exception;
980: END IF;
981:

Line 1009: p_init_msg_list => FND_API.G_FALSE,

1005: END IF;
1006:
1007: CHANGE_CLAUSE_STATUS (
1008: p_api_version => 1,
1009: p_init_msg_list => FND_API.G_FALSE,
1010: p_commit => FND_API.G_FALSE,
1011: p_template_id => l_tmpl_id,
1012: p_wf_seq_id => l_tmpl_wf_seq_id,
1013: p_status => 'APPROVED',

Line 1010: p_commit => FND_API.G_FALSE,

1006:
1007: CHANGE_CLAUSE_STATUS (
1008: p_api_version => 1,
1009: p_init_msg_list => FND_API.G_FALSE,
1010: p_commit => FND_API.G_FALSE,
1011: p_template_id => l_tmpl_id,
1012: p_wf_seq_id => l_tmpl_wf_seq_id,
1013: p_status => 'APPROVED',
1014: x_validation_results => l_validation_results,

Line 1020: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1016: x_msg_data => x_msg_data,
1017: x_msg_count => x_msg_count);
1018:
1019:
1020: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1021: -- some clause validation failed
1022: RAISE clause_sts_exception_1;
1023: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1024: -- unexpected error

Line 1023: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1019:
1020: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1021: -- some clause validation failed
1022: RAISE clause_sts_exception_1;
1023: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1024: -- unexpected error
1025: RAISE clause_sts_exception_2;
1026: END IF;
1027:

Line 1033: p_init_msg_list => FND_API.G_FALSE,

1029: (l_tmpl_status = 'REJECTED' AND l_tmpl_wc = 'Y')) THEN
1030:
1031: OKC_TERMS_UTIL_PVT.merge_template_working_copy(
1032: p_api_version => 1,
1033: p_init_msg_list => FND_API.G_FALSE,
1034: p_commit => FND_API.G_FALSE,
1035: p_template_id => l_tmpl_id,
1036: x_return_status => x_return_status,
1037: x_msg_data => x_msg_data,

Line 1034: p_commit => FND_API.G_FALSE,

1030:
1031: OKC_TERMS_UTIL_PVT.merge_template_working_copy(
1032: p_api_version => 1,
1033: p_init_msg_list => FND_API.G_FALSE,
1034: p_commit => FND_API.G_FALSE,
1035: p_template_id => l_tmpl_id,
1036: x_return_status => x_return_status,
1037: x_msg_data => x_msg_data,
1038: x_msg_count => x_msg_count,

Line 1175: p_init_msg_list => FND_API.G_FALSE,

1171: x_return_status := 'S';
1172:
1173: CHANGE_CLAUSE_STATUS (
1174: p_api_version => 1,
1175: p_init_msg_list => FND_API.G_FALSE,
1176: p_commit => FND_API.G_FALSE,
1177: p_template_id => l_tmpl_id,
1178: p_wf_seq_id => l_tmpl_wf_seq_id,
1179: p_status => 'REJECTED',

Line 1176: p_commit => FND_API.G_FALSE,

1172:
1173: CHANGE_CLAUSE_STATUS (
1174: p_api_version => 1,
1175: p_init_msg_list => FND_API.G_FALSE,
1176: p_commit => FND_API.G_FALSE,
1177: p_template_id => l_tmpl_id,
1178: p_wf_seq_id => l_tmpl_wf_seq_id,
1179: p_status => 'REJECTED',
1180: x_validation_results => l_validation_results,

Line 1185: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1181: x_return_status => x_return_status,
1182: x_msg_data => x_msg_data,
1183: x_msg_count => x_msg_count);
1184:
1185: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1186: -- some clause validation failed
1187: RAISE clause_sts_exception_1;
1188: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1189: -- unexpected error

Line 1188: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1184:
1185: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1186: -- some clause validation failed
1187: RAISE clause_sts_exception_1;
1188: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1189: -- unexpected error
1190: RAISE clause_sts_exception_2;
1191: END IF;
1192:

Line 1515: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1511: are returned in this table
1512: */
1513: PROCEDURE change_clause_status (
1514: p_api_version IN NUMBER,
1515: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1516: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1517:
1518: x_return_status OUT NOCOPY VARCHAR2,
1519: x_msg_data OUT NOCOPY VARCHAR2,

Line 1516: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1512: */
1513: PROCEDURE change_clause_status (
1514: p_api_version IN NUMBER,
1515: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1516: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1517:
1518: x_return_status OUT NOCOPY VARCHAR2,
1519: x_msg_data OUT NOCOPY VARCHAR2,
1520: x_msg_count OUT NOCOPY NUMBER,

Line 1525: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

1521:
1522: p_template_id IN NUMBER,
1523: p_wf_seq_id IN NUMBER DEFAULT NULL,
1524: p_status IN VARCHAR2,
1525: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1526: x_validation_results OUT NOCOPY OKC_ART_BLK_PVT.validation_tbl_type)
1527:
1528: IS
1529:

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

1556: -- Standard Start of API savepoint
1557: SAVEPOINT change_clause_status_pvt;
1558:
1559: -- Standard call to check for call compatibility.
1560: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1562: END IF;
1563:
1564: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1557: SAVEPOINT change_clause_status_pvt;
1558:
1559: -- Standard call to check for call compatibility.
1560: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1562: END IF;
1563:
1564: -- Initialize message list if p_init_msg_list is set to TRUE.
1565: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1565: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1562: END IF;
1563:
1564: -- Initialize message list if p_init_msg_list is set to TRUE.
1565: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1566: FND_MSG_PUB.initialize;
1567: END IF;
1568:
1569: -- Initialize API return status to success

Line 1570: x_return_status := FND_API.G_RET_STS_SUCCESS;

1566: FND_MSG_PUB.initialize;
1567: END IF;
1568:
1569: -- Initialize API return status to success
1570: x_return_status := FND_API.G_RET_STS_SUCCESS;
1571: l_article_version_id_tbl := OKC_ART_BLK_PVT.NUM_TBL_TYPE();
1572:
1573: IF (p_status NOT IN ('PENDING_APPROVAL', 'APPROVED', 'REJECTED')) THEN
1574: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1574: x_return_status := FND_API.G_RET_STS_ERROR;

1570: x_return_status := FND_API.G_RET_STS_SUCCESS;
1571: l_article_version_id_tbl := OKC_ART_BLK_PVT.NUM_TBL_TYPE();
1572:
1573: IF (p_status NOT IN ('PENDING_APPROVAL', 'APPROVED', 'REJECTED')) THEN
1574: x_return_status := FND_API.G_RET_STS_ERROR;
1575: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
1576: FND_MESSAGE.set_token('ARG_NAME', 'p_status');
1577: FND_MESSAGE.set_token('ARG_VALUE', p_status);
1578: FND_MSG_PUB.add;

Line 1579: RAISE FND_API.G_EXC_ERROR;

1575: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
1576: FND_MESSAGE.set_token('ARG_NAME', 'p_status');
1577: FND_MESSAGE.set_token('ARG_VALUE', p_status);
1578: FND_MSG_PUB.add;
1579: RAISE FND_API.G_EXC_ERROR;
1580: END IF;
1581:
1582: OPEN l_tmpl_csr(p_template_id);
1583: FETCH l_tmpl_csr INTO l_current_org_id;

Line 1585: x_return_status := FND_API.G_RET_STS_ERROR;

1581:
1582: OPEN l_tmpl_csr(p_template_id);
1583: FETCH l_tmpl_csr INTO l_current_org_id;
1584: IF l_tmpl_csr%NOTFOUND THEN
1585: x_return_status := FND_API.G_RET_STS_ERROR;
1586: CLOSE l_tmpl_csr;
1587: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
1588: FND_MESSAGE.set_token('ARG_NAME', 'p_template_id');
1589: FND_MESSAGE.set_token('ARG_VALUE', p_template_id);

Line 1591: RAISE FND_API.G_EXC_ERROR;

1587: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
1588: FND_MESSAGE.set_token('ARG_NAME', 'p_template_id');
1589: FND_MESSAGE.set_token('ARG_VALUE', p_template_id);
1590: FND_MSG_PUB.add;
1591: RAISE FND_API.G_EXC_ERROR;
1592: END IF;
1593:
1594: OPEN l_tmpl_clauses_csr(p_template_id, p_wf_seq_id);
1595: LOOP

Line 1607: p_init_msg_list => FND_API.G_FALSE,

1603:
1604: IF (p_status = 'PENDING_APPROVAL') THEN
1605: OKC_ART_BLK_PVT.PENDING_APPROVAL_BLK(
1606: p_api_version => 1,
1607: p_init_msg_list => FND_API.G_FALSE,
1608: p_commit => FND_API.G_FALSE,
1609: p_validation_level => p_validation_level,
1610:
1611: x_return_status => x_return_status,

Line 1608: p_commit => FND_API.G_FALSE,

1604: IF (p_status = 'PENDING_APPROVAL') THEN
1605: OKC_ART_BLK_PVT.PENDING_APPROVAL_BLK(
1606: p_api_version => 1,
1607: p_init_msg_list => FND_API.G_FALSE,
1608: p_commit => FND_API.G_FALSE,
1609: p_validation_level => p_validation_level,
1610:
1611: x_return_status => x_return_status,
1612: x_msg_count => x_msg_count,

Line 1621: p_init_msg_list => FND_API.G_FALSE,

1617: x_validation_results => x_validation_results);
1618: ELSIF(p_status = 'APPROVED') THEN
1619: OKC_ART_BLK_PVT.APPROVE_BLK(
1620: p_api_version => 1,
1621: p_init_msg_list => FND_API.G_FALSE,
1622: p_commit => FND_API.G_FALSE,
1623:
1624: x_return_status => x_return_status,
1625: x_msg_count => x_msg_count,

Line 1622: p_commit => FND_API.G_FALSE,

1618: ELSIF(p_status = 'APPROVED') THEN
1619: OKC_ART_BLK_PVT.APPROVE_BLK(
1620: p_api_version => 1,
1621: p_init_msg_list => FND_API.G_FALSE,
1622: p_commit => FND_API.G_FALSE,
1623:
1624: x_return_status => x_return_status,
1625: x_msg_count => x_msg_count,
1626: x_msg_data => x_msg_data,

Line 1634: p_init_msg_list => FND_API.G_FALSE,

1630: x_validation_results => x_validation_results);
1631: ELSIF(p_status = 'REJECTED') THEN
1632: OKC_ART_BLK_PVT.REJECT_BLK(
1633: p_api_version => 1,
1634: p_init_msg_list => FND_API.G_FALSE,
1635: p_commit => FND_API.G_FALSE,
1636:
1637: x_return_status => x_return_status,
1638: x_msg_count => x_msg_count,

Line 1635: p_commit => FND_API.G_FALSE,

1631: ELSIF(p_status = 'REJECTED') THEN
1632: OKC_ART_BLK_PVT.REJECT_BLK(
1633: p_api_version => 1,
1634: p_init_msg_list => FND_API.G_FALSE,
1635: p_commit => FND_API.G_FALSE,
1636:
1637: x_return_status => x_return_status,
1638: x_msg_count => x_msg_count,
1639: x_msg_data => x_msg_data,

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

1642: p_art_ver_tbl => l_article_version_id_tbl,
1643: x_validation_results => x_validation_results);
1644: END IF;
1645:
1646: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1647: RAISE FND_API.G_EXC_ERROR ;
1648: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1650: END IF;

Line 1647: RAISE FND_API.G_EXC_ERROR ;

1643: x_validation_results => x_validation_results);
1644: END IF;
1645:
1646: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1647: RAISE FND_API.G_EXC_ERROR ;
1648: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1650: END IF;
1651:

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

1644: END IF;
1645:
1646: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1647: RAISE FND_API.G_EXC_ERROR ;
1648: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1650: END IF;
1651:
1652: END LOOP;

Line 1649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1645:
1646: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1647: RAISE FND_API.G_EXC_ERROR ;
1648: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1650: END IF;
1651:
1652: END LOOP;
1653:

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

1658:
1659: -- Standard call to get message count and if count is 1, get message info.
1660: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1661:
1662: IF(FND_API.to_boolean(p_commit)) THEN
1663: COMMIT;
1664: END IF;
1665:
1666: /*IF (l_debug = 'Y') THEN

Line 1677: WHEN FND_API.G_EXC_ERROR THEN

1673: END IF;
1674:
1675: EXCEPTION
1676:
1677: WHEN FND_API.G_EXC_ERROR THEN
1678:
1679: /*IF (l_debug = 'Y') THEN
1680: okc_debug.log('800: Leaving change_clause_status: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1681: END IF;*/

Line 1699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1695: ROLLBACK TO change_clause_status_pvt;
1696: x_return_status := G_RET_STS_ERROR ;
1697: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1698:
1699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1700: /*IF (l_debug = 'Y') THEN
1701: okc_debug.log('900: Leaving change_clause_status: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1702: END IF;*/
1703:

Line 1916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1912: FETCH adoption_type_meaning_csr INTO adoption_type_desc;
1913: CLOSE adoption_type_meaning_csr;
1914:
1915: if (org_name is null ) then
1916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1917: end if ;
1918:
1919: if (adoption_type_desc is null ) then
1920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1917: end if ;
1918:
1919: if (adoption_type_desc is null ) then
1920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1921: end if ;
1922:
1923: wf_engine.setItemAttrText(itemtype, itemkey, 'ADOPTION_DESC', adoption_type_desc);
1924: wf_engine.setItemAttrText(itemtype, itemkey, 'ADOPTION_TYPE', operation);

Line 1942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1938:
1939: RETURN;
1940: END IF; --if func mode is 'RUN'
1941: EXCEPTION
1942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1943: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'set_notified ', itemtype,
1944: itemkey, to_char(actid), funcmode);
1945: RAISE;
1946: WHEN OTHERS THEN

Line 2126: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2122: -- in table OKC_TMPL_DRAFT_CLAUSES will have the selected_yn flag set to Y
2123: --
2124: PROCEDURE select_draft_clauses(
2125: p_api_version IN NUMBER,
2126: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2127: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2128:
2129: x_return_status OUT NOCOPY VARCHAR2,
2130: x_msg_data OUT NOCOPY VARCHAR2,

Line 2127: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2123: --
2124: PROCEDURE select_draft_clauses(
2125: p_api_version IN NUMBER,
2126: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2127: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2128:
2129: x_return_status OUT NOCOPY VARCHAR2,
2130: x_msg_data OUT NOCOPY VARCHAR2,
2131: x_msg_count OUT NOCOPY NUMBER,

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

2149: -- Standard Start of API savepoint
2150: SAVEPOINT select_draft_clauses_pvt;
2151:
2152: -- Standard call to check for call compatibility.
2153: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2155: END IF;
2156:
2157: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2150: SAVEPOINT select_draft_clauses_pvt;
2151:
2152: -- Standard call to check for call compatibility.
2153: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2155: END IF;
2156:
2157: -- Initialize message list if p_init_msg_list is set to TRUE.
2158: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2158: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2155: END IF;
2156:
2157: -- Initialize message list if p_init_msg_list is set to TRUE.
2158: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2159: FND_MSG_PUB.initialize;
2160: END IF;
2161:
2162: -- Initialize API return status to success

Line 2163: x_return_status := FND_API.G_RET_STS_SUCCESS;

2159: FND_MSG_PUB.initialize;
2160: END IF;
2161:
2162: -- Initialize API return status to success
2163: x_return_status := FND_API.G_RET_STS_SUCCESS;
2164:
2165: UPDATE OKC_TMPL_DRAFT_CLAUSES
2166: SET selected_yn = 'Y'
2167: WHERE template_id = (

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

2170:
2171: -- Standard call to get message count and if count is 1, get message info.
2172: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2173:
2174: IF(FND_API.to_boolean(p_commit)) THEN
2175: COMMIT;
2176: END IF;
2177:
2178: /*IF (l_debug = 'Y') THEN

Line 2189: WHEN FND_API.G_EXC_ERROR THEN

2185: END IF;
2186:
2187: EXCEPTION
2188:
2189: WHEN FND_API.G_EXC_ERROR THEN
2190:
2191: /*IF (l_debug = 'Y') THEN
2192: okc_debug.log('800: Leaving select_draft_clauses: OKC_API.G_EXCEPTION_ERROR Exception', 2);
2193: END IF;*/

Line 2204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2200: ROLLBACK TO change_clause_status_pvt;
2201: x_return_status := G_RET_STS_ERROR ;
2202: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2203:
2204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2205: /*IF (l_debug = 'Y') THEN
2206: okc_debug.log('900: Leaving select_draft_clauses: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2207: END IF;*/
2208: