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_CONTRACT_DOCS_PVT dependencies on OKC_API

Line 11: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

7:
8: ---------------------------------------------------------------------------
9: -- GLOBAL MESSAGE CONSTANTS
10: ---------------------------------------------------------------------------
11: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
12: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
13: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
14: G_NEW_RECORD_DELETED CONSTANT VARCHAR2(200) := 'OKC_LOCK_RECORD_DELETED';
15: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;

Line 12: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;

8: ---------------------------------------------------------------------------
9: -- GLOBAL MESSAGE CONSTANTS
10: ---------------------------------------------------------------------------
11: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
12: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
13: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
14: G_NEW_RECORD_DELETED CONSTANT VARCHAR2(200) := 'OKC_LOCK_RECORD_DELETED';
15: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
16: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line 13: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;

9: -- GLOBAL MESSAGE CONSTANTS
10: ---------------------------------------------------------------------------
11: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
12: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
13: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
14: G_NEW_RECORD_DELETED CONSTANT VARCHAR2(200) := 'OKC_LOCK_RECORD_DELETED';
15: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
16: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

Line 15: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;

11: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
12: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
13: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
14: G_NEW_RECORD_DELETED CONSTANT VARCHAR2(200) := 'OKC_LOCK_RECORD_DELETED';
15: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
16: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

Line 16: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

12: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
13: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
14: G_NEW_RECORD_DELETED CONSTANT VARCHAR2(200) := 'OKC_LOCK_RECORD_DELETED';
15: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
16: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
20: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

Line 17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

13: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
14: G_NEW_RECORD_DELETED CONSTANT VARCHAR2(200) := 'OKC_LOCK_RECORD_DELETED';
15: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
16: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
20: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
21: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

14: G_NEW_RECORD_DELETED CONSTANT VARCHAR2(200) := 'OKC_LOCK_RECORD_DELETED';
15: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
16: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
20: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
21: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
22: ---------------------------------------------------------------------------

Line 19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

15: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
16: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
20: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
21: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
22: ---------------------------------------------------------------------------
23: -- VALIDATION LEVELS

Line 20: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

16: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
20: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
21: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
22: ---------------------------------------------------------------------------
23: -- VALIDATION LEVELS
24: ---------------------------------------------------------------------------

Line 21: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
20: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
21: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
22: ---------------------------------------------------------------------------
23: -- VALIDATION LEVELS
24: ---------------------------------------------------------------------------
25: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;

Line 25: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;

21: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
22: ---------------------------------------------------------------------------
23: -- VALIDATION LEVELS
24: ---------------------------------------------------------------------------
25: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;
26: G_VALID_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_VALID_VALUE_VALID_LEVEL;
27: G_LOOKUP_CODE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_LOOKUP_CODE_VALID_LEVEL;
28: G_FOREIGN_KEY_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_FOREIGN_KEY_VALID_LEVEL;
29: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;

Line 26: G_VALID_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_VALID_VALUE_VALID_LEVEL;

22: ---------------------------------------------------------------------------
23: -- VALIDATION LEVELS
24: ---------------------------------------------------------------------------
25: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;
26: G_VALID_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_VALID_VALUE_VALID_LEVEL;
27: G_LOOKUP_CODE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_LOOKUP_CODE_VALID_LEVEL;
28: G_FOREIGN_KEY_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_FOREIGN_KEY_VALID_LEVEL;
29: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;
30: ---------------------------------------------------------------------------

Line 27: G_LOOKUP_CODE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_LOOKUP_CODE_VALID_LEVEL;

23: -- VALIDATION LEVELS
24: ---------------------------------------------------------------------------
25: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;
26: G_VALID_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_VALID_VALUE_VALID_LEVEL;
27: G_LOOKUP_CODE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_LOOKUP_CODE_VALID_LEVEL;
28: G_FOREIGN_KEY_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_FOREIGN_KEY_VALID_LEVEL;
29: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;
30: ---------------------------------------------------------------------------
31: -- GLOBAL VARIABLES

Line 28: G_FOREIGN_KEY_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_FOREIGN_KEY_VALID_LEVEL;

24: ---------------------------------------------------------------------------
25: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;
26: G_VALID_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_VALID_VALUE_VALID_LEVEL;
27: G_LOOKUP_CODE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_LOOKUP_CODE_VALID_LEVEL;
28: G_FOREIGN_KEY_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_FOREIGN_KEY_VALID_LEVEL;
29: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;
30: ---------------------------------------------------------------------------
31: -- GLOBAL VARIABLES
32: ---------------------------------------------------------------------------

Line 29: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;

25: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;
26: G_VALID_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_VALID_VALUE_VALID_LEVEL;
27: G_LOOKUP_CODE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_LOOKUP_CODE_VALID_LEVEL;
28: G_FOREIGN_KEY_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_FOREIGN_KEY_VALID_LEVEL;
29: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;
30: ---------------------------------------------------------------------------
31: -- GLOBAL VARIABLES
32: ---------------------------------------------------------------------------
33: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_DOCS_PVT';

Line 35: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

31: -- GLOBAL VARIABLES
32: ---------------------------------------------------------------------------
33: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_DOCS_PVT';
34: G_MODULE CONSTANT VARCHAR2(200) := 'okc.plsql.'||G_PKG_NAME||'.';
35: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
36: G_ENTITY_NAME CONSTANT VARCHAR2(200) := 'Contract Document';
37:
38:
39: ------------------------------------------------------------------------------

Line 170: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

166: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
167: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving get_rec because of EXCEPTION: '||sqlerrm);
168: END IF;
169:
170: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
171: p_msg_name => G_UNEXPECTED_ERROR,
172: p_token1 => G_SQLCODE_TOKEN,
173: p_token1_value => sqlcode,
174: p_token2 => G_SQLERRM_TOKEN,

Line 388: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

384: WHEN OTHERS THEN
385: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
386: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm);
387: END IF;
388: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
389: p_msg_name => G_UNEXPECTED_ERROR,
390: p_token1 => G_SQLCODE_TOKEN,
391: p_token1_value => sqlcode,
392: p_token2 => G_SQLERRM_TOKEN,

Line 446: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'BUSINESS_DOCUMENT_TYPE');

442: IF ( p_business_document_type IS NULL) THEN
443: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
444: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: - attribute BUSINESS_DOCUMENT_TYPE is invalid');
445: END IF;
446: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'BUSINESS_DOCUMENT_TYPE');
447: l_return_status := G_RET_STS_ERROR;
448: END IF;
449:
450: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 457: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'BUSINESS_DOCUMENT_ID');

453: IF ( p_business_document_id IS NULL) THEN
454: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
455: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: - attribute BUSINESS_DOCUMENT_ID is invalid');
456: END IF;
457: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'BUSINESS_DOCUMENT_ID');
458: l_return_status := G_RET_STS_ERROR;
459: END IF;
460:
461: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 468: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'BUSINESS_DOCUMENT_VERSION');

464: IF ( p_business_document_version IS NULL) THEN
465: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
466: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: - attribute BUSINESS_DOCUMENT_VERSION is invalid');
467: END IF;
468: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'BUSINESS_DOCUMENT_VERSION');
469: l_return_status := G_RET_STS_ERROR;
470: END IF;
471:
472: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 479: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ATTACHED_DOCUMENT_ID');

475: IF ( p_attached_document_id IS NULL) THEN
476: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
477: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: - attribute ATTACHED_DOCUMENT_ID is invalid');
478: END IF;
479: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ATTACHED_DOCUMENT_ID');
480: l_return_status := G_RET_STS_ERROR;
481: END IF;
482:
483: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 490: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'EXTERNAL_VISIBILITY_FLAG');

486: IF ( p_external_visibility_flag IS NULL) THEN
487: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
488: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: - attribute EXTERNAL_VISIBILITY_FLAG is invalid');
489: END IF;
490: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'EXTERNAL_VISIBILITY_FLAG');
491: l_return_status := G_RET_STS_ERROR;
492: END IF;
493:
494: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 501: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'EFFECTIVE_FROM_TYPE');

497: IF ( p_effective_from_type IS NULL) THEN
498: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
499: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: - attribute EFFECTIVE_FROM_TYPE is invalid');
500: END IF;
501: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'EFFECTIVE_FROM_TYPE');
502: l_return_status := G_RET_STS_ERROR;
503: END IF;
504:
505: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 512: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'EFFECTIVE_FROM_ID');

508: IF ( p_effective_from_id IS NULL) THEN
509: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
510: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: - attribute EFFECTIVE_FROM_ID is invalid');
511: END IF;
512: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'EFFECTIVE_FROM_ID');
513: l_return_status := G_RET_STS_ERROR;
514: END IF;
515:
516: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 523: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'EFFECTIVE_FROM_VERSION');

519: IF ( p_effective_from_version IS NULL) THEN
520: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
521: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: - attribute EFFECTIVE_FROM_VERSION is invalid');
522: END IF;
523: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'EFFECTIVE_FROM_VERSION');
524: l_return_status := G_RET_STS_ERROR;
525: END IF;
526:
527: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 534: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'INCLUDE_FOR_APPROVAL_FLAG');

530: IF ( p_include_for_approval_flag IS NULL) THEN
531: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
532: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: - attribute INCLUDE_FOR_APPROVAL_FLAG is invalid');
533: END IF;
534: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'INCLUDE_FOR_APPROVAL_FLAG');
535: l_return_status := G_RET_STS_ERROR;
536: END IF;
537:
538: END IF;

Line 552: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'PRIMARY_CONTRACT_DOC_FLAG');

548: IF ( p_primary_contract_doc_flag NOT IN ('Y','N') AND p_primary_contract_doc_flag IS NOT NULL) THEN
549: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
550: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: - attribute PRIMARY_CONTRACT_DOC_FLAG is invalid');
551: END IF;
552: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'PRIMARY_CONTRACT_DOC_FLAG');
553: l_return_status := G_RET_STS_ERROR;
554: END IF;
555:
556: IF ( p_mergeable_doc_flag NOT IN ('Y','N') AND p_mergeable_doc_flag IS NOT NULL) THEN

Line 560: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'mergeable_doc_flag');

556: IF ( p_mergeable_doc_flag NOT IN ('Y','N') AND p_mergeable_doc_flag IS NOT NULL) THEN
557: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
558: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: - attribute mergeable_doc_flag is invalid');
559: END IF;
560: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'mergeable_doc_flag');
561: l_return_status := G_RET_STS_ERROR;
562: END IF;
563:
564: END IF;

Line 592: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

588: WHEN OTHERS THEN
589: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
590: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm);
591: END IF;
592: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
593: p_msg_name => G_UNEXPECTED_ERROR,
594: p_token1 => G_SQLCODE_TOKEN,
595: p_token1_value => sqlcode,
596: p_token2 => G_SQLERRM_TOKEN,

Line 693: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

689: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
690: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm);
691: END IF;
692:
693: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
694: p_msg_name => G_UNEXPECTED_ERROR,
695: p_token1 => G_SQLCODE_TOKEN,
696: p_token1_value => sqlcode,
697: p_token2 => G_SQLERRM_TOKEN,

Line 851: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

847: WHEN OTHERS THEN
848: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
849: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm);
850: END IF;
851: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
852: p_msg_name => G_UNEXPECTED_ERROR,
853: p_token1 => G_SQLCODE_TOKEN,
854: p_token1_value => sqlcode,
855: p_token2 => G_SQLERRM_TOKEN,

Line 965: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

961: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
962: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3800: Leaving Insert_Row:OTHERS Exception');
963: END IF;
964:
965: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
966: p_msg_name => G_UNEXPECTED_ERROR,
967: p_token1 => G_SQLCODE_TOKEN,
968: p_token1_value => sqlcode,
969: p_token2 => G_SQLERRM_TOKEN,

Line 1128: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1124: WHEN OTHERS THEN
1125: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1126: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm);
1127: END IF;
1128: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1129: p_msg_name => G_UNEXPECTED_ERROR,
1130: p_token1 => G_SQLCODE_TOKEN,
1131: p_token1_value => sqlcode,
1132: p_token2 => G_SQLERRM_TOKEN,

Line 1191: Okc_Api.Set_Message(G_FND_APP,G_UNABLE_TO_RESERVE_REC);

1187:
1188: IF (lock_csr%ISOPEN) THEN
1189: CLOSE lock_csr;
1190: END IF;
1191: Okc_Api.Set_Message(G_FND_APP,G_UNABLE_TO_RESERVE_REC);
1192: RETURN( G_RET_STS_ERROR );
1193: END;
1194:
1195: IF ( l_row_notfound ) THEN

Line 1205: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1201: CLOSE lchk_csr;
1202:
1203: IF (l_row_notfound) THEN
1204: l_pk_string := p_business_document_type || ':' || p_business_document_id || ':' || p_business_document_version || ':' || p_attached_document_id;
1205: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1206: p_msg_name => G_NEW_RECORD_DELETED,
1207: p_token1 => 'ENTITYNAME',
1208: p_token1_value => G_ENTITY_NAME,
1209: p_token2 => 'PKEY',

Line 1213: -- Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);

1209: p_token2 => 'PKEY',
1210: p_token2_value => l_pk_string,
1211: p_token3 => 'OVN',
1212: p_token3_value => l_object_version_number);
1213: -- Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
1214:
1215: ELSIF l_object_version_number > p_object_version_number THEN
1216: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1217: ELSIF l_object_version_number = -1 THEN

Line 1216: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);

1212: p_token3_value => l_object_version_number);
1213: -- Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
1214:
1215: ELSIF l_object_version_number > p_object_version_number THEN
1216: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1217: ELSIF l_object_version_number = -1 THEN
1218: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1219: ELSE -- it can be the only above condition. It can happen after restore version
1220: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);

Line 1218: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

1214:
1215: ELSIF l_object_version_number > p_object_version_number THEN
1216: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1217: ELSIF l_object_version_number = -1 THEN
1218: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1219: ELSE -- it can be the only above condition. It can happen after restore version
1220: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1221: END IF;
1222: ELSE

Line 1220: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);

1216: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1217: ELSIF l_object_version_number = -1 THEN
1218: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1219: ELSE -- it can be the only above condition. It can happen after restore version
1220: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1221: END IF;
1222: ELSE
1223: l_return_status := G_RET_STS_SUCCESS;
1224: END IF;

Line 1246: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1242: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1243: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm);
1244: END IF;
1245:
1246: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1247: p_msg_name => G_UNEXPECTED_ERROR,
1248: p_token1 => G_SQLCODE_TOKEN,
1249: p_token1_value => sqlcode,
1250: p_token2 => G_SQLERRM_TOKEN,

Line 1315: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1311: WHEN OTHERS THEN
1312: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1313: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6300: Leaving Lock_Row because of EXCEPTION: '||sqlerrm);
1314: END IF;
1315: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1316: p_msg_name => G_UNEXPECTED_ERROR,
1317: p_token1 => G_SQLCODE_TOKEN,
1318: p_token1_value => sqlcode,
1319: p_token2 => G_SQLERRM_TOKEN,

Line 1396: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1392: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1393: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm);
1394: END IF;
1395:
1396: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1397: p_msg_name => G_UNEXPECTED_ERROR,
1398: p_token1 => G_SQLCODE_TOKEN,
1399: p_token1_value => sqlcode,
1400: p_token2 => G_SQLERRM_TOKEN,

Line 1634: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1630: WHEN OTHERS THEN
1631: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1632: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm);
1633: END IF;
1634: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1635: p_msg_name => G_UNEXPECTED_ERROR,
1636: p_token1 => G_SQLCODE_TOKEN,
1637: p_token1_value => sqlcode,
1638: p_token2 => G_SQLERRM_TOKEN,

Line 1679: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1675: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1676: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm);
1677: END IF;
1678:
1679: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1680: p_msg_name => G_UNEXPECTED_ERROR,
1681: p_token1 => G_SQLCODE_TOKEN,
1682: p_token1_value => sqlcode,
1683: p_token2 => G_SQLERRM_TOKEN,

Line 1755: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1751: WHEN OTHERS THEN
1752: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1753: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm);
1754: END IF;
1755: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1756: p_msg_name => G_UNEXPECTED_ERROR,
1757: p_token1 => G_SQLCODE_TOKEN,
1758: p_token1_value => sqlcode,
1759: p_token2 => G_SQLERRM_TOKEN,

Line 1849: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1845: END IF;
1846:
1847: ROLLBACK TO reset_bus_doc_ver_to_current;
1848:
1849: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1850: p_msg_name => G_UNEXPECTED_ERROR,
1851: p_token1 => G_SQLCODE_TOKEN,
1852: p_token1_value => sqlcode,
1853: p_token2 => G_SQLERRM_TOKEN,