APPS.PSA_IMPLEMENTATION dependencies on PSA_IMPLEMENTATION

Line 1: PACKAGE BODY PSA_IMPLEMENTATION AS

1: PACKAGE BODY PSA_IMPLEMENTATION AS
2: /* $Header: PSAMFIMB.pls 120.5 2006/09/13 13:11:04 agovil ship $ */
3:
4: --===========================FND_LOG.START=====================================
5: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 11: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFIMB.PSA_IMPLEMENTATION.';

7: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
8: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
10: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFIMB.PSA_IMPLEMENTATION.';
12: --===========================FND_LOG.END=======================================
13: --
14: FUNCTION get (p_org_id IN INTEGER,
15: p_psa_feature IN VARCHAR2,

Line 31: FROM psa_implementation_all

27: --
28: if g_mfar_enabled is null THEN
29: SELECT status
30: INTO p_enabled_flag
31: FROM psa_implementation_all
32: WHERE org_id = p_org_id
33: AND psa_feature = p_psa_feature;
34: g_mfar_enabled := p_enabled_flag;
35: --

Line 54: FROM psa_implementation_all

50: l_enabled_flag varchar2(1);
51: BEGIN
52: SELECT status
53: INTO l_enabled_flag
54: FROM psa_implementation_all
55: WHERE org_id = p_org_id
56: AND psa_feature = p_psa_feature;
57: --
58: IF l_enabled_flag = 'Y' THEN

Line 61: UPDATE psa_implementation_all

57: --
58: IF l_enabled_flag = 'Y' THEN
59: NULL;
60: ELSIF l_enabled_flag = 'N' THEN
61: UPDATE psa_implementation_all
62: SET status = 'Y'
63: WHERE org_id = p_org_id
64: AND psa_feature = p_psa_feature;
65: END IF;

Line 68: INSERT INTO psa_implementation_all(psa_feature

64: AND psa_feature = p_psa_feature;
65: END IF;
66: --
67: EXCEPTION WHEN no_data_found THEN
68: INSERT INTO psa_implementation_all(psa_feature
69: ,status
70: ,org_id)
71: VALUES (p_psa_feature
72: ,'Y'

Line 86: FROM psa_implementation_all

82: -- ========================= FND LOG ===========================
83: BEGIN
84: SELECT status
85: INTO l_enabled_flag
86: FROM psa_implementation_all
87: WHERE org_id = p_org_id
88: AND psa_feature = p_psa_feature;
89: --
90: IF l_enabled_flag = 'N' THEN

Line 93: UPDATE psa_implementation_all

89: --
90: IF l_enabled_flag = 'N' THEN
91: NULL;
92: ELSIF l_enabled_flag = 'Y' THEN
93: UPDATE psa_implementation_all
94: SET status = 'N'
95: WHERE org_id = p_org_id
96: AND psa_feature = p_psa_feature;
97: END IF;

Line 101: INSERT INTO psa_implementation_all(psa_feature

97: END IF;
98: --
99: EXCEPTION
100: WHEN no_data_found THEN
101: INSERT INTO psa_implementation_all(psa_feature
102: ,status
103: ,org_id)
104: VALUES (p_psa_feature
105: ,'N'

Line 109: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'Error Package - psa_implementation'||sqlerrm);

105: ,'N'
106: ,p_org_id);
107: WHEN others THEN
108: FND_MESSAGE.SET_NAME ('AR', 'GENERIC_MESSAGE');
109: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'Error Package - psa_implementation'||sqlerrm);
110: -- ========================= FND LOG ===========================
111: psa_utils.debug_other_msg(g_unexp_level,l_full_path,FALSE);
112: -- ========================= FND LOG ===========================
113: APP_EXCEPTION.RAISE_EXCEPTION;

Line 116: END PSA_IMPLEMENTATION;

112: -- ========================= FND LOG ===========================
113: APP_EXCEPTION.RAISE_EXCEPTION;
114: END;
115: --
116: END PSA_IMPLEMENTATION;