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

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

5:
6: ---------------------------------------------------------------------------
7: -- GLOBAL MESSAGE CONSTANTS
8: ---------------------------------------------------------------------------
9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
10: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
11: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
12: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
13: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

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

6: ---------------------------------------------------------------------------
7: -- GLOBAL MESSAGE CONSTANTS
8: ---------------------------------------------------------------------------
9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
10: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
11: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
12: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
13: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
14: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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

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

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

8: ---------------------------------------------------------------------------
9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
10: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
11: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
12: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
13: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
14: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
15: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
16: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

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

9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
10: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
11: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
12: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
13: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
14: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
15: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
16: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
17: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

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

10: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
11: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
12: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
13: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
14: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
15: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
16: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
17: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
18: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

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

11: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
12: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
13: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
14: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
15: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
16: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
17: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
18: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
19: ---------------------------------------------------------------------------

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

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

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

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

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

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

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

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

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

19: ---------------------------------------------------------------------------
20: -- VALIDATION LEVELS
21: ---------------------------------------------------------------------------
22: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;
23: G_VALID_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_VALID_VALUE_VALID_LEVEL;
24: G_LOOKUP_CODE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_LOOKUP_CODE_VALID_LEVEL;
25: G_FOREIGN_KEY_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_FOREIGN_KEY_VALID_LEVEL;
26: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;
27: ---------------------------------------------------------------------------

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

20: -- VALIDATION LEVELS
21: ---------------------------------------------------------------------------
22: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;
23: G_VALID_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_VALID_VALUE_VALID_LEVEL;
24: G_LOOKUP_CODE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_LOOKUP_CODE_VALID_LEVEL;
25: G_FOREIGN_KEY_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_FOREIGN_KEY_VALID_LEVEL;
26: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;
27: ---------------------------------------------------------------------------
28: -- GLOBAL VARIABLES

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

21: ---------------------------------------------------------------------------
22: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;
23: G_VALID_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_VALID_VALUE_VALID_LEVEL;
24: G_LOOKUP_CODE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_LOOKUP_CODE_VALID_LEVEL;
25: G_FOREIGN_KEY_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_FOREIGN_KEY_VALID_LEVEL;
26: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;
27: ---------------------------------------------------------------------------
28: -- GLOBAL VARIABLES
29: ---------------------------------------------------------------------------

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

22: G_REQUIRED_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_REQUIRED_VALUE_VALID_LEVEL;
23: G_VALID_VALUE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_VALID_VALUE_VALID_LEVEL;
24: G_LOOKUP_CODE_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_LOOKUP_CODE_VALID_LEVEL;
25: G_FOREIGN_KEY_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_FOREIGN_KEY_VALID_LEVEL;
26: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;
27: ---------------------------------------------------------------------------
28: -- GLOBAL VARIABLES
29: ---------------------------------------------------------------------------
30: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ARTICLE_RELATIONSHIPS_PVT';

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

27: ---------------------------------------------------------------------------
28: -- GLOBAL VARIABLES
29: ---------------------------------------------------------------------------
30: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ARTICLE_RELATIONSHIPS_PVT';
31: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
32:
33: ------------------------------------------------------------------------------
34: -- GLOBAL CONSTANTS
35: ------------------------------------------------------------------------------

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

84: IF (l_debug = 'Y') THEN
85: Okc_Debug.Log('300: Leaving get_seq_id because of EXCEPTION: '||sqlerrm, 2);
86: END IF;
87:
88: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
89: p_msg_name => G_UNEXPECTED_ERROR,
90: p_token1 => G_SQLCODE_TOKEN,
91: p_token1_value => sqlcode,
92: p_token2 => G_SQLERRM_TOKEN,

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

163: IF (l_debug = 'Y') THEN
164: Okc_Debug.Log('600: Leaving get_rec because of EXCEPTION: '||sqlerrm, 2);
165: END IF;
166:
167: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
168: p_msg_name => G_UNEXPECTED_ERROR,
169: p_token1 => G_SQLCODE_TOKEN,
170: p_token1_value => sqlcode,
171: p_token2 => G_SQLERRM_TOKEN,

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

256: WHEN OTHERS THEN
257: IF (l_debug = 'Y') THEN
258: Okc_Debug.Log('1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm, 2);
259: END IF;
260: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
261: p_msg_name => G_UNEXPECTED_ERROR,
262: p_token1 => G_SQLCODE_TOKEN,
263: p_token1_value => sqlcode,
264: p_token2 => G_SQLERRM_TOKEN,

Line 318: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'SOURCE_ARTICLE_ID');

314: IF ( p_source_article_id IS NULL) THEN
315: IF (l_debug = 'Y') THEN
316: Okc_Debug.Log('1500: - attribute SOURCE_ARTICLE_ID is invalid', 2);
317: END IF;
318: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'SOURCE_ARTICLE_ID');
319: l_return_status := G_RET_STS_ERROR;
320: END IF;
321:
322: IF (l_debug = 'Y') THEN

Line 329: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'TARGET_ARTICLE_ID');

325: IF ( p_target_article_id IS NULL) THEN
326: IF (l_debug = 'Y') THEN
327: Okc_Debug.Log('1500: - attribute TARGET_ARTICLE_ID is invalid', 2);
328: END IF;
329: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'TARGET_ARTICLE_ID');
330: l_return_status := G_RET_STS_ERROR;
331: END IF;
332:
333: IF (l_debug = 'Y') THEN

Line 340: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ORG_ID');

336: IF ( p_org_id IS NULL) THEN
337: IF (l_debug = 'Y') THEN
338: Okc_Debug.Log('1500: - attribute ORG_ID is invalid', 2);
339: END IF;
340: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ORG_ID');
341: l_return_status := G_RET_STS_ERROR;
342: END IF;
343:
344: IF (l_debug = 'Y') THEN

Line 351: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'RELATIONSHIP_TYPE');

347: IF ( p_relationship_type IS NULL) THEN
348: IF (l_debug = 'Y') THEN
349: Okc_Debug.Log('1500: - attribute RELATIONSHIP_TYPE is invalid', 2);
350: END IF;
351: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'RELATIONSHIP_TYPE');
352: l_return_status := G_RET_STS_ERROR;
353: END IF;
354:
355: END IF;

Line 376: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'RELATIONSHIP_TYPE');

372: END IF;
373: IF p_relationship_type IS NOT NULL THEN
374: l_tmp_return_status := Okc_Util.Check_Lookup_Code('OKC_ARTICLE_RELATIONSHIP_TYPE',p_relationship_type);
375: IF (l_tmp_return_status <> G_RET_STS_SUCCESS) THEN
376: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'RELATIONSHIP_TYPE');
377: l_return_status := G_RET_STS_ERROR;
378: END IF;
379: END IF;
380:

Line 403: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SOURCE_ARTICLE_ID');

399: IF (l_dummy_var = '?') THEN
400: IF (l_debug = 'Y') THEN
401: Okc_Debug.Log('2300: - attribute SOURCE_ARTICLE_ID is invalid', 2);
402: END IF;
403: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SOURCE_ARTICLE_ID');
404: l_return_status := G_RET_STS_ERROR;
405: END IF;
406: END IF;
407:

Line 420: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TARGET_ARTICLE_ID');

416: IF (l_dummy_var = '?') THEN
417: IF (l_debug = 'Y') THEN
418: Okc_Debug.Log('2300: - attribute TARGET_ARTICLE_ID is invalid', 2);
419: END IF;
420: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TARGET_ARTICLE_ID');
421: l_return_status := G_RET_STS_ERROR;
422: END IF;
423: END IF;
424:

Line 437: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ORG_ID');

433: IF (l_dummy_var = '?') THEN
434: IF (l_debug = 'Y') THEN
435: Okc_Debug.Log('2300: - attribute ORG_ID is invalid', 2);
436: END IF;
437: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ORG_ID');
438: l_return_status := G_RET_STS_ERROR;
439: END IF;
440: END IF;
441:

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

450:
451: EXCEPTION
452: WHEN OTHERS THEN
453: Okc_Debug.Log('2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm, 2);
454: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
455: p_msg_name => G_UNEXPECTED_ERROR,
456: p_token1 => G_SQLCODE_TOKEN,
457: p_token1_value => sqlcode,
458: p_token2 => G_SQLERRM_TOKEN,

Line 582: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_SAME_ART_RELTNSHP');

578: IF p_source_article_id = p_target_article_id THEN
579: IF (l_debug='Y') THEN
580: OKC_Debug.Log('2800: - attribute SOURCE_ARTICLE_ID , TARGET_ARTICLE_ID can not be same',2);
581: END IF;
582: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_SAME_ART_RELTNSHP');
583: l_return_status := G_RET_STS_ERROR;
584: -- fix for bug#4006749 start
585: -- muteshev
586: elsif provision_flag_in_relations(p_source_article_id, p_target_article_id) = 'E' then

Line 587: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_INV_PROVISION_RELATION');

583: l_return_status := G_RET_STS_ERROR;
584: -- fix for bug#4006749 start
585: -- muteshev
586: elsif provision_flag_in_relations(p_source_article_id, p_target_article_id) = 'E' then
587: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_INV_PROVISION_RELATION');
588: l_return_status := G_RET_STS_ERROR;
589: -- fix for bug#4006749 end
590: END IF;
591:

Line 605: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_DUP_RELTNSHP');

601: IF l_rowfound THEN
602: IF (l_debug='Y') THEN
603: OKC_Debug.Log('2800: - attribute SOURCE_ARTICLE_ID , TARGET_ARTICLE_ID are not unique for Org',2);
604: END IF;
605: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_DUP_RELTNSHP');
606: l_return_status := G_RET_STS_ERROR;
607: END IF;
608: END IF;
609: /*+++++++++++++End of hand code +++++++++++++++++++*/

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

620: IF (l_debug = 'Y') THEN
621: Okc_Debug.Log('3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm, 2);
622: END IF;
623:
624: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
625: p_msg_name => G_UNEXPECTED_ERROR,
626: p_token1 => G_SQLCODE_TOKEN,
627: p_token1_value => sqlcode,
628: p_token2 => G_SQLERRM_TOKEN,

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

711: WHEN OTHERS THEN
712: IF (l_debug = 'Y') THEN
713: Okc_Debug.Log('3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);
714: END IF;
715: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
716: p_msg_name => G_UNEXPECTED_ERROR,
717: p_token1 => G_SQLCODE_TOKEN,
718: p_token1_value => sqlcode,
719: p_token2 => G_SQLERRM_TOKEN,

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

783: IF (l_debug = 'Y') THEN
784: Okc_Debug.Log('3800: Leaving Insert_Row:OTHERS Exception', 2);
785: END IF;
786:
787: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
788: p_msg_name => G_UNEXPECTED_ERROR,
789: p_token1 => G_SQLCODE_TOKEN,
790: p_token1_value => sqlcode,
791: p_token2 => G_SQLERRM_TOKEN,

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

912: WHEN OTHERS THEN
913: IF (l_debug = 'Y') THEN
914: Okc_Debug.Log('4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);
915: END IF;
916: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
917: p_msg_name => G_UNEXPECTED_ERROR,
918: p_token1 => G_SQLCODE_TOKEN,
919: p_token1_value => sqlcode,
920: p_token2 => G_SQLERRM_TOKEN,

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

978:
979: IF (lock_csr%ISOPEN) THEN
980: CLOSE lock_csr;
981: END IF;
982: Okc_Api.Set_Message(G_FND_APP,G_UNABLE_TO_RESERVE_REC);
983: RETURN( G_RET_STS_ERROR );
984: END;
985:
986: IF ( l_row_notfound ) THEN

Line 995: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);

991: l_row_notfound := lchk_csr%NOTFOUND;
992: CLOSE lchk_csr;
993:
994: IF (l_row_notfound) THEN
995: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
996: ELSIF l_object_version_number > p_object_version_number THEN
997: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
998: ELSIF l_object_version_number = -1 THEN
999: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

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

993:
994: IF (l_row_notfound) THEN
995: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
996: ELSIF l_object_version_number > p_object_version_number THEN
997: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
998: ELSIF l_object_version_number = -1 THEN
999: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1000: ELSE -- it can be the only above condition. It can happen after restore version
1001: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);

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

995: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
996: ELSIF l_object_version_number > p_object_version_number THEN
997: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
998: ELSIF l_object_version_number = -1 THEN
999: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1000: ELSE -- it can be the only above condition. It can happen after restore version
1001: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1002: END IF;
1003: ELSE

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

997: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
998: ELSIF l_object_version_number = -1 THEN
999: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1000: ELSE -- it can be the only above condition. It can happen after restore version
1001: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1002: END IF;
1003: ELSE
1004: l_return_status := G_RET_STS_SUCCESS;
1005: END IF;

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

1023: IF (l_debug = 'Y') THEN
1024: Okc_Debug.Log('5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
1025: END IF;
1026:
1027: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1028: p_msg_name => G_UNEXPECTED_ERROR,
1029: p_token1 => G_SQLCODE_TOKEN,
1030: p_token1_value => sqlcode,
1031: p_token2 => G_SQLERRM_TOKEN,

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

1089: WHEN OTHERS THEN
1090: IF (l_debug = 'Y') THEN
1091: Okc_Debug.Log('6300: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
1092: END IF;
1093: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1094: p_msg_name => G_UNEXPECTED_ERROR,
1095: p_token1 => G_SQLCODE_TOKEN,
1096: p_token1_value => sqlcode,
1097: p_token2 => G_SQLERRM_TOKEN,

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

1146: IF (l_debug = 'Y') THEN
1147: Okc_Debug.Log('6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
1148: END IF;
1149:
1150: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1151: p_msg_name => G_UNEXPECTED_ERROR,
1152: p_token1 => G_SQLCODE_TOKEN,
1153: p_token1_value => sqlcode,
1154: p_token2 => G_SQLERRM_TOKEN,

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

1302: WHEN OTHERS THEN
1303: IF (l_debug = 'Y') THEN
1304: Okc_Debug.Log('8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
1305: END IF;
1306: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1307: p_msg_name => G_UNEXPECTED_ERROR,
1308: p_token1 => G_SQLCODE_TOKEN,
1309: p_token1_value => sqlcode,
1310: p_token2 => G_SQLERRM_TOKEN,

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

1349: IF (l_debug = 'Y') THEN
1350: Okc_Debug.Log('8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
1351: END IF;
1352:
1353: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1354: p_msg_name => G_UNEXPECTED_ERROR,
1355: p_token1 => G_SQLCODE_TOKEN,
1356: p_token1_value => sqlcode,
1357: p_token2 => G_SQLERRM_TOKEN,

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

1423: WHEN OTHERS THEN
1424: IF (l_debug = 'Y') THEN
1425: Okc_Debug.Log('9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
1426: END IF;
1427: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1428: p_msg_name => G_UNEXPECTED_ERROR,
1429: p_token1 => G_SQLCODE_TOKEN,
1430: p_token1_value => sqlcode,
1431: p_token2 => G_SQLERRM_TOKEN,