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_SECTIONS_GRP dependencies on FND_API

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

15:
16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21:
22: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;

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

16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21:
22: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 22: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;

18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21:
22: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
25:
26: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';

Line 23: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;

19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21:
22: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
25:
26: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
27: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';

Line 24: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21:
22: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
25:
26: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
27: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
28: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';

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

93:
94: -- Standard Start of API savepoint
95: SAVEPOINT g_validate_row_GRP;
96: -- Standard call to check for call compatibility.
97: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: END IF;
100: -- Initialize message list if p_init_msg_list is set to TRUE.
101: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

94: -- Standard Start of API savepoint
95: SAVEPOINT g_validate_row_GRP;
96: -- Standard call to check for call compatibility.
97: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: END IF;
100: -- Initialize message list if p_init_msg_list is set to TRUE.
101: IF FND_API.to_Boolean( p_init_msg_list ) THEN
102: FND_MSG_PUB.initialize;

Line 101: IF FND_API.to_Boolean( p_init_msg_list ) THEN

97: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: END IF;
100: -- Initialize message list if p_init_msg_list is set to TRUE.
101: IF FND_API.to_Boolean( p_init_msg_list ) THEN
102: FND_MSG_PUB.initialize;
103: END IF;
104: -- Initialize API return status to success
105: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 105: x_return_status := FND_API.G_RET_STS_SUCCESS;

101: IF FND_API.to_Boolean( p_init_msg_list ) THEN
102: FND_MSG_PUB.initialize;
103: END IF;
104: -- Initialize API return status to success
105: x_return_status := FND_API.G_RET_STS_SUCCESS;
106:
107: --------------------------------------------
108: -- Calling Simple API for Validation
109: --------------------------------------------

Line 148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

144: p_object_version_number => p_object_version_number
145: );
146: --------------------------------------------
147: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
149: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
150: RAISE FND_API.G_EXC_ERROR ;
151: END IF;
152: --------------------------------------------

Line 150: RAISE FND_API.G_EXC_ERROR ;

146: --------------------------------------------
147: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
149: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
150: RAISE FND_API.G_EXC_ERROR ;
151: END IF;
152: --------------------------------------------
153:
154: -- Standard call to get message count and if count is 1, get message info.

Line 167: WHEN FND_API.G_EXC_ERROR THEN

163: G_PKG_NAME, '200: Leaving validate_row' );
164: END IF;
165:
166: EXCEPTION
167: WHEN FND_API.G_EXC_ERROR THEN
168: /*IF (l_debug = 'Y') THEN
169: okc_debug.log('300: Leaving Validate_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
170: END IF;*/
171:

Line 180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

176: ROLLBACK TO g_validate_row_GRP;
177: x_return_status := G_RET_STS_ERROR ;
178: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
179:
180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
181: /*IF (l_debug = 'Y') THEN
182: okc_debug.log('400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
183: END IF;*/
184:

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

281:
282: -- Standard Start of API savepoint
283: SAVEPOINT g_create_section_GRP;
284: -- Standard call to check for call compatibility.
285: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;
288: -- Initialize message list if p_init_msg_list is set to TRUE.
289: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

282: -- Standard Start of API savepoint
283: SAVEPOINT g_create_section_GRP;
284: -- Standard call to check for call compatibility.
285: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;
288: -- Initialize message list if p_init_msg_list is set to TRUE.
289: IF FND_API.to_Boolean( p_init_msg_list ) THEN
290: FND_MSG_PUB.initialize;

Line 289: IF FND_API.to_Boolean( p_init_msg_list ) THEN

285: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;
288: -- Initialize message list if p_init_msg_list is set to TRUE.
289: IF FND_API.to_Boolean( p_init_msg_list ) THEN
290: FND_MSG_PUB.initialize;
291: END IF;
292:
293: -- Initialize API return status to success

Line 294: x_return_status := FND_API.G_RET_STS_SUCCESS;

290: FND_MSG_PUB.initialize;
291: END IF;
292:
293: -- Initialize API return status to success
294: x_return_status := FND_API.G_RET_STS_SUCCESS;
295:
296: IF p_mode='AMEND' THEN
297: l_amendment_description := p_amendment_description;
298: l_amendment_operation_code := G_AMEND_CODE_ADDED;

Line 349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

345: x_id => x_id
346: );
347: --------------------------------------------
348: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
350: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
351: RAISE FND_API.G_EXC_ERROR ;
352: END IF;
353: --------------------------------------------

Line 351: RAISE FND_API.G_EXC_ERROR ;

347: --------------------------------------------
348: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
350: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
351: RAISE FND_API.G_EXC_ERROR ;
352: END IF;
353: --------------------------------------------
354:
355: -- Standard check of p_commit

Line 356: IF FND_API.To_Boolean( p_commit ) THEN

352: END IF;
353: --------------------------------------------
354:
355: -- Standard check of p_commit
356: IF FND_API.To_Boolean( p_commit ) THEN
357: COMMIT WORK;
358: END IF;
359: -- Standard call to get message count and if count is 1, get message info.
360: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 372: WHEN FND_API.G_EXC_ERROR THEN

368: G_PKG_NAME, '700: Leaving create_section' );
369: END IF;
370:
371: EXCEPTION
372: WHEN FND_API.G_EXC_ERROR THEN
373: /*IF (l_debug = 'Y') THEN
374: okc_debug.log('800: Leaving create_section: OKC_API.G_EXCEPTION_ERROR Exception', 2);
375: END IF;*/
376:

Line 385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

381: ROLLBACK TO g_create_section_GRP;
382: x_return_status := G_RET_STS_ERROR ;
383: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
384:
385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
386: /*IF (l_debug = 'Y') THEN
387: okc_debug.log('900: Leaving create_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
388: END IF;*/
389:

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

505: -- Standard Start of API savepoint
506: SAVEPOINT g_update_section_GRP;
507:
508: -- Standard call to check for call compatibility.
509: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: END IF;
512:
513: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

506: SAVEPOINT g_update_section_GRP;
507:
508: -- Standard call to check for call compatibility.
509: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: END IF;
512:
513: -- Initialize message list if p_init_msg_list is set to TRUE.
514: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 514: IF FND_API.to_Boolean( p_init_msg_list ) THEN

510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: END IF;
512:
513: -- Initialize message list if p_init_msg_list is set to TRUE.
514: IF FND_API.to_Boolean( p_init_msg_list ) THEN
515: FND_MSG_PUB.initialize;
516: END IF;
517:
518: IF FND_API.To_Boolean( p_validate_commit ) THEN

Line 518: IF FND_API.To_Boolean( p_validate_commit ) THEN

514: IF FND_API.to_Boolean( p_init_msg_list ) THEN
515: FND_MSG_PUB.initialize;
516: END IF;
517:
518: IF FND_API.To_Boolean( p_validate_commit ) THEN
519:
520: IF p_document_id IS NULL OR p_document_type IS NULL THEN
521: OPEN l_document_id_csr;
522: FETCH l_document_id_csr into l_document_id,l_document_type;

Line 526: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (

522: FETCH l_document_id_csr into l_document_id,l_document_type;
523: CLOSE l_document_id_csr;
524: END IF;
525:
526: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
527: p_api_version => l_api_version,
528: p_init_msg_list => FND_API.G_FALSE,
529: p_doc_type => l_document_type,
530: p_doc_id => l_document_id,

Line 528: p_init_msg_list => FND_API.G_FALSE,

524: END IF;
525:
526: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
527: p_api_version => l_api_version,
528: p_init_msg_list => FND_API.G_FALSE,
529: p_doc_type => l_document_type,
530: p_doc_id => l_document_id,
531: p_validation_string => p_validation_string,
532: x_return_status => x_return_status,

Line 544: RAISE FND_API.G_EXC_ERROR ;

540: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
541: FND_LOG.STRING(G_PROC_LEVEL,
542: G_PKG_NAME, '700: Issue with document header Record.Cannot commit' );
543: END IF;
544: RAISE FND_API.G_EXC_ERROR ;
545: END IF;
546: END IF;
547:
548:

Line 550: x_return_status := FND_API.G_RET_STS_SUCCESS;

546: END IF;
547:
548:
549: -- Initialize API return status to success
550: x_return_status := FND_API.G_RET_STS_SUCCESS;
551:
552: IF p_mode='AMEND' THEN
553: l_amendment_description := p_amendment_description;
554:

Line 613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

609: p_object_version_number => p_object_version_number
610: );
611: --------------------------------------------
612: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
614: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
615: RAISE FND_API.G_EXC_ERROR ;
616: END IF;
617: --------------------------------------------

Line 615: RAISE FND_API.G_EXC_ERROR ;

611: --------------------------------------------
612: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
614: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
615: RAISE FND_API.G_EXC_ERROR ;
616: END IF;
617: --------------------------------------------
618:
619: -- Standard check of p_commit

Line 620: IF FND_API.To_Boolean( p_commit ) THEN

616: END IF;
617: --------------------------------------------
618:
619: -- Standard check of p_commit
620: IF FND_API.To_Boolean( p_commit ) THEN
621: COMMIT WORK;
622: END IF;
623: -- Standard call to get message count and if count is 1, get message info.
624: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 636: WHEN FND_API.G_EXC_ERROR THEN

632: G_PKG_NAME, '1800: Leaving update_section' );
633: END IF;
634:
635: EXCEPTION
636: WHEN FND_API.G_EXC_ERROR THEN
637: /*IF (l_debug = 'Y') THEN
638: okc_debug.log('1900: Leaving update_section: OKC_API.G_EXCEPTION_ERROR Exception', 2);
639: END IF;*/
640:

Line 654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

650: ROLLBACK TO g_update_section_GRP;
651: x_return_status := G_RET_STS_ERROR ;
652: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
653:
654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
655: /*IF (l_debug = 'Y') THEN
656: okc_debug.log('2000: Leaving update_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
657: END IF;*/
658:

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

840:
841: -- Standard Start of API savepoint
842: SAVEPOINT g_add_section_GRP;
843: -- Standard call to check for call compatibility.
844: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
846: END IF;
847: -- Initialize message list if p_init_msg_list is set to TRUE.
848: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

841: -- Standard Start of API savepoint
842: SAVEPOINT g_add_section_GRP;
843: -- Standard call to check for call compatibility.
844: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
846: END IF;
847: -- Initialize message list if p_init_msg_list is set to TRUE.
848: IF FND_API.to_Boolean( p_init_msg_list ) THEN
849: FND_MSG_PUB.initialize;

Line 848: IF FND_API.to_Boolean( p_init_msg_list ) THEN

844: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
846: END IF;
847: -- Initialize message list if p_init_msg_list is set to TRUE.
848: IF FND_API.to_Boolean( p_init_msg_list ) THEN
849: FND_MSG_PUB.initialize;
850: END IF;
851:
852: IF FND_API.To_Boolean( p_validate_commit ) AND

Line 852: IF FND_API.To_Boolean( p_validate_commit ) AND

848: IF FND_API.to_Boolean( p_init_msg_list ) THEN
849: FND_MSG_PUB.initialize;
850: END IF;
851:
852: IF FND_API.To_Boolean( p_validate_commit ) AND
853: NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
854: p_api_version => l_api_version,
855: p_init_msg_list => FND_API.G_FALSE,
856: p_doc_type => p_document_type,

Line 853: NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (

849: FND_MSG_PUB.initialize;
850: END IF;
851:
852: IF FND_API.To_Boolean( p_validate_commit ) AND
853: NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
854: p_api_version => l_api_version,
855: p_init_msg_list => FND_API.G_FALSE,
856: p_doc_type => p_document_type,
857: p_doc_id => p_document_id,

Line 855: p_init_msg_list => FND_API.G_FALSE,

851:
852: IF FND_API.To_Boolean( p_validate_commit ) AND
853: NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
854: p_api_version => l_api_version,
855: p_init_msg_list => FND_API.G_FALSE,
856: p_doc_type => p_document_type,
857: p_doc_id => p_document_id,
858: p_validation_string => p_validation_string,
859: x_return_status => x_return_status,

Line 871: RAISE FND_API.G_EXC_ERROR ;

867: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
868: FND_LOG.STRING(G_PROC_LEVEL,
869: G_PKG_NAME, '700: Issue with document header Record.Cannot commit' );
870: END IF;
871: RAISE FND_API.G_EXC_ERROR ;
872: END IF;
873:
874:
875: -- Initialize API return status to success

Line 876: x_return_status := FND_API.G_RET_STS_SUCCESS;

872: END IF;
873:
874:
875: -- Initialize API return status to success
876: x_return_status := FND_API.G_RET_STS_SUCCESS;
877:
878: IF p_ref_point NOT IN ('A','B','S') THEN
879: /*IF (l_debug = 'Y') THEN
880: okc_debug.log('800: Error: Ref point should be either A,B or S', 2);

Line 889: RAISE FND_API.G_EXC_ERROR ;

885: G_PKG_NAME, '800: Error: Ref point should be either A,B or S' );
886: END IF;
887:
888: Okc_Api.Set_Message( G_FND_APP, 'OKC_WRONG_REF_POINT');
889: RAISE FND_API.G_EXC_ERROR ;
890:
891: END IF;
892:
893:

Line 966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

962: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
963: FND_LOG.STRING(G_PROC_LEVEL,
964: G_PKG_NAME, '900: Error: Reference not found' );
965: END IF;
966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
967: END IF;
968: END IF;
969:
970:

Line 977: p_init_msg_list => FND_API.G_FALSE,

973: -- Calling API for Creating A Section
974: --------------------------------------------
975: OKC_TERMS_SECTIONS_GRP.create_section(
976: p_api_version => 1,
977: p_init_msg_list => FND_API.G_FALSE,
978: p_commit => FND_API.G_FALSE,
979: p_mode => p_mode,
980: p_validation_level => p_validation_level,
981: p_id => p_id,

Line 978: p_commit => FND_API.G_FALSE,

974: --------------------------------------------
975: OKC_TERMS_SECTIONS_GRP.create_section(
976: p_api_version => 1,
977: p_init_msg_list => FND_API.G_FALSE,
978: p_commit => FND_API.G_FALSE,
979: p_mode => p_mode,
980: p_validation_level => p_validation_level,
981: p_id => p_id,
982: p_section_sequence => l_sequence,

Line 1015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1011: );
1012:
1013: --------------------------------------------
1014: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1016: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1017: RAISE FND_API.G_EXC_ERROR ;
1018: END IF;
1019: --------------------------------------------

Line 1017: RAISE FND_API.G_EXC_ERROR ;

1013: --------------------------------------------
1014: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1016: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1017: RAISE FND_API.G_EXC_ERROR ;
1018: END IF;
1019: --------------------------------------------
1020: IF scn_tbl.COUNT > 0 THEN
1021: FOR k IN scn_tbl.FIRST..scn_tbl.LAST LOOP

Line 1078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1074:
1075:
1076: --------------------------------------------
1077: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1079: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1080: RAISE FND_API.G_EXC_ERROR ;
1081: END IF;
1082: --------------------------------------------

Line 1080: RAISE FND_API.G_EXC_ERROR ;

1076: --------------------------------------------
1077: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1079: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1080: RAISE FND_API.G_EXC_ERROR ;
1081: END IF;
1082: --------------------------------------------
1083: END IF;
1084: END LOOP;

Line 1088: IF FND_API.To_Boolean( p_commit ) THEN

1084: END LOOP;
1085: END IF;
1086:
1087: -- Standard check of p_commit
1088: IF FND_API.To_Boolean( p_commit ) THEN
1089: COMMIT WORK;
1090: END IF;
1091: -- Standard call to get message count and if count is 1, get message info.
1092: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 1104: WHEN FND_API.G_EXC_ERROR THEN

1100: G_PKG_NAME, '1100: Leaving add_section' );
1101: END IF;
1102:
1103: EXCEPTION
1104: WHEN FND_API.G_EXC_ERROR THEN
1105: /*IF (l_debug = 'Y') THEN
1106: okc_debug.log('1200: Leaving add_section: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1107: END IF;*/
1108:

Line 1134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1130: ROLLBACK TO g_add_section_GRP;
1131: x_return_status := G_RET_STS_ERROR ;
1132: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1133:
1134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1135: /*IF (l_debug = 'Y') THEN
1136: okc_debug.log('1300: Leaving add_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1137: END IF;*/
1138:

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

1231:
1232: -- Standard Start of API savepoint
1233: SAVEPOINT g_lock_row_GRP;
1234: -- Standard call to check for call compatibility.
1235: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1237: END IF;
1238: -- Initialize message list if p_init_msg_list is set to TRUE.
1239: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1232: -- Standard Start of API savepoint
1233: SAVEPOINT g_lock_row_GRP;
1234: -- Standard call to check for call compatibility.
1235: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1237: END IF;
1238: -- Initialize message list if p_init_msg_list is set to TRUE.
1239: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1240: FND_MSG_PUB.initialize;

Line 1239: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1235: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1237: END IF;
1238: -- Initialize message list if p_init_msg_list is set to TRUE.
1239: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1240: FND_MSG_PUB.initialize;
1241: END IF;
1242: -- Initialize API return status to success
1243: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1243: x_return_status := FND_API.G_RET_STS_SUCCESS;

1239: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1240: FND_MSG_PUB.initialize;
1241: END IF;
1242: -- Initialize API return status to success
1243: x_return_status := FND_API.G_RET_STS_SUCCESS;
1244:
1245: --------------------------------------------
1246: -- Calling Simple API for Locking A Row
1247: --------------------------------------------

Line 1255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1251: p_object_version_number => p_object_version_number
1252: );
1253: --------------------------------------------
1254: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1256: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1257: RAISE FND_API.G_EXC_ERROR ;
1258: END IF;
1259: --------------------------------------------

Line 1257: RAISE FND_API.G_EXC_ERROR ;

1253: --------------------------------------------
1254: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1256: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1257: RAISE FND_API.G_EXC_ERROR ;
1258: END IF;
1259: --------------------------------------------
1260:
1261: -- Standard call to get message count and if count is 1, get message info.

Line 1274: WHEN FND_API.G_EXC_ERROR THEN

1270: G_PKG_NAME, '1200: Leaving lock_row' );
1271: END IF;
1272:
1273: EXCEPTION
1274: WHEN FND_API.G_EXC_ERROR THEN
1275: /*IF (l_debug = 'Y') THEN
1276: okc_debug.log('1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1277: END IF;*/
1278:

Line 1287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1283: ROLLBACK TO g_lock_row_GRP;
1284: x_return_status := G_RET_STS_ERROR ;
1285: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1286:
1287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1288: /*IF (l_debug = 'Y') THEN
1289: okc_debug.log('1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1290: END IF;*/
1291:

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

1385:
1386: -- Standard Start of API savepoint
1387: SAVEPOINT g_delete_section_GRP;
1388: -- Standard call to check for call compatibility.
1389: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1391: END IF;
1392: -- Initialize message list if p_init_msg_list is set to TRUE.
1393: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1386: -- Standard Start of API savepoint
1387: SAVEPOINT g_delete_section_GRP;
1388: -- Standard call to check for call compatibility.
1389: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1391: END IF;
1392: -- Initialize message list if p_init_msg_list is set to TRUE.
1393: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1394: FND_MSG_PUB.initialize;

Line 1393: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1389: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1391: END IF;
1392: -- Initialize message list if p_init_msg_list is set to TRUE.
1393: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1394: FND_MSG_PUB.initialize;
1395: END IF;
1396:
1397: IF FND_API.To_Boolean( p_validate_commit ) THEN

Line 1397: IF FND_API.To_Boolean( p_validate_commit ) THEN

1393: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1394: FND_MSG_PUB.initialize;
1395: END IF;
1396:
1397: IF FND_API.To_Boolean( p_validate_commit ) THEN
1398:
1399: OPEN l_document_id_csr;
1400: FETCH l_document_id_csr into l_document_id,l_document_type;
1401: CLOSE l_document_id_csr;

Line 1403: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (

1399: OPEN l_document_id_csr;
1400: FETCH l_document_id_csr into l_document_id,l_document_type;
1401: CLOSE l_document_id_csr;
1402:
1403: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
1404: p_api_version => l_api_version,
1405: p_init_msg_list => FND_API.G_FALSE,
1406: p_doc_type => l_document_type,
1407: p_doc_id => l_document_id,

Line 1405: p_init_msg_list => FND_API.G_FALSE,

1401: CLOSE l_document_id_csr;
1402:
1403: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
1404: p_api_version => l_api_version,
1405: p_init_msg_list => FND_API.G_FALSE,
1406: p_doc_type => l_document_type,
1407: p_doc_id => l_document_id,
1408: p_validation_string => p_validation_string,
1409: x_return_status => x_return_status,

Line 1421: RAISE FND_API.G_EXC_ERROR ;

1417: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1418: FND_LOG.STRING(G_PROC_LEVEL,
1419: G_PKG_NAME, '2210: Issue with document header Record.Cannot commit' );
1420: END IF;
1421: RAISE FND_API.G_EXC_ERROR ;
1422: END IF;
1423: END IF;
1424:
1425: --Bug 3669528 Refresh settings to prevent function security caching problems

Line 1433: x_return_status := FND_API.G_RET_STS_SUCCESS;

1429: l_super_user_yn := 'N';
1430: END IF;
1431:
1432: -- Initialize API return status to success
1433: x_return_status := FND_API.G_RET_STS_SUCCESS;
1434:
1435: -- Following code will be deleteing all Subsection and its article.
1436:
1437: FOR cr IN l_subsection_csr(p_id) LOOP

Line 1452: p_init_msg_list => FND_API.G_FALSE,

1448: END IF;
1449:
1450: OKC_TERMS_SECTIONS_GRP.delete_section(
1451: p_api_version => p_api_version,
1452: p_init_msg_list => FND_API.G_FALSE,
1453: p_commit => FND_API.G_FALSE,
1454: x_return_status => x_return_status,
1455: x_msg_count => x_msg_count,
1456: x_msg_data => x_msg_data,

Line 1453: p_commit => FND_API.G_FALSE,

1449:
1450: OKC_TERMS_SECTIONS_GRP.delete_section(
1451: p_api_version => p_api_version,
1452: p_init_msg_list => FND_API.G_FALSE,
1453: p_commit => FND_API.G_FALSE,
1454: x_return_status => x_return_status,
1455: x_msg_count => x_msg_count,
1456: x_msg_data => x_msg_data,
1457: p_mode => p_mode,

Line 1464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1460: p_object_version_number => l_ovn
1461: );
1462: --------------------------------------------
1463: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1465: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1466: RAISE FND_API.G_EXC_ERROR ;
1467: END IF;
1468: --------------------------------------------

Line 1466: RAISE FND_API.G_EXC_ERROR ;

1462: --------------------------------------------
1463: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1465: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1466: RAISE FND_API.G_EXC_ERROR ;
1467: END IF;
1468: --------------------------------------------
1469:
1470: /*IF (l_debug = 'Y') THEN

Line 1498: p_init_msg_list => FND_API.G_FALSE,

1494:
1495:
1496: OKC_K_ARTICLES_GRP.delete_article(
1497: p_api_version => l_api_version,
1498: p_init_msg_list => FND_API.G_FALSE,
1499: p_validate_commit => FND_API.G_FALSE,
1500: p_validation_string => Null,
1501: p_commit => FND_API.G_FALSE,
1502: x_return_status => x_return_status,

Line 1499: p_validate_commit => FND_API.G_FALSE,

1495:
1496: OKC_K_ARTICLES_GRP.delete_article(
1497: p_api_version => l_api_version,
1498: p_init_msg_list => FND_API.G_FALSE,
1499: p_validate_commit => FND_API.G_FALSE,
1500: p_validation_string => Null,
1501: p_commit => FND_API.G_FALSE,
1502: x_return_status => x_return_status,
1503: x_msg_count => x_msg_count,

Line 1501: p_commit => FND_API.G_FALSE,

1497: p_api_version => l_api_version,
1498: p_init_msg_list => FND_API.G_FALSE,
1499: p_validate_commit => FND_API.G_FALSE,
1500: p_validation_string => Null,
1501: p_commit => FND_API.G_FALSE,
1502: x_return_status => x_return_status,
1503: x_msg_count => x_msg_count,
1504: x_msg_data => x_msg_data,
1505: p_mode => p_mode,

Line 1513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1509: p_object_version_number => l_article_rec.object_version_number );
1510:
1511:
1512: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1514: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1515: RAISE FND_API.G_EXC_ERROR ;
1516: END IF;
1517: END LOOP;

Line 1515: RAISE FND_API.G_EXC_ERROR ;

1511:
1512: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1514: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1515: RAISE FND_API.G_EXC_ERROR ;
1516: END IF;
1517: END LOOP;
1518:
1519: /*IF (l_debug = 'Y') THEN

Line 1555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1551: );
1552:
1553: --------------------------------------------
1554: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1556: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1557: RAISE FND_API.G_EXC_ERROR ;
1558: END IF;
1559: --------------------------------------------

Line 1557: RAISE FND_API.G_EXC_ERROR ;

1553: --------------------------------------------
1554: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1556: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1557: RAISE FND_API.G_EXC_ERROR ;
1558: END IF;
1559: --------------------------------------------
1560: ELSE
1561: l_delete_rec := TRUE;

Line 1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1571: p_object_version_number => p_object_version_number
1572: );
1573: --------------------------------------------
1574: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1576: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1577: RAISE FND_API.G_EXC_ERROR ;
1578: END IF;
1579: --------------------------------------------

Line 1577: RAISE FND_API.G_EXC_ERROR ;

1573: --------------------------------------------
1574: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1576: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1577: RAISE FND_API.G_EXC_ERROR ;
1578: END IF;
1579: --------------------------------------------
1580: END IF;
1581:

Line 1583: IF FND_API.To_Boolean( p_commit ) THEN

1579: --------------------------------------------
1580: END IF;
1581:
1582: -- Standard check of p_commit
1583: IF FND_API.To_Boolean( p_commit ) THEN
1584: COMMIT WORK;
1585: END IF;
1586: -- Standard call to get message count and if count is 1, get message info.
1587: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 1599: WHEN FND_API.G_EXC_ERROR THEN

1595: G_PKG_NAME, '2300: Leaving delete_section' );
1596: END IF;
1597:
1598: EXCEPTION
1599: WHEN FND_API.G_EXC_ERROR THEN
1600: /*IF (l_debug = 'Y') THEN
1601: okc_debug.log('2400: Leaving delete_section: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1602: END IF;*/
1603:

Line 1625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1621: ROLLBACK TO g_delete_section_GRP;
1622: x_return_status := G_RET_STS_ERROR ;
1623: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1624:
1625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1626: /*IF (l_debug = 'Y') THEN
1627: okc_debug.log('2500: Leaving delete_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1628: END IF;*/
1629: