APPS.PA_PJP_PVT dependencies on PA_PJP_PVT

Line 1: package body PA_PJP_PVT as

1: package body PA_PJP_PVT as
2: /* $Header: PARPJPVB.pls 120.2 2009/02/04 00:40:56 sugupta noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'PA_PJP_PVT';
5: G_APP_NAME CONSTANT VARCHAR2(3) := 'FPA';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'PA_PJP_PVT';

1: package body PA_PJP_PVT as
2: /* $Header: PARPJPVB.pls 120.2 2009/02/04 00:40:56 sugupta noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'PA_PJP_PVT';
5: G_APP_NAME CONSTANT VARCHAR2(3) := 'FPA';
6: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
7: L_API_NAME CONSTANT VARCHAR2(35) := 'PJP';
8:

Line 26: 'fpa.sql.PA_PJP_PVT.Submit_Project_Aw',

22:
23: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
24: FND_LOG.String(
25: FND_LOG.LEVEL_PROCEDURE,
26: 'fpa.sql.PA_PJP_PVT.Submit_Project_Aw',
27: 'Entering');
28: END IF;
29:
30: x_return_status := 'E';

Line 36: 'fpa.sql.PA_PJP_PVT.Submit_Project_Aw',

32: -- Checking for PJP license.
33: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
34: FND_LOG.String(
35: FND_LOG.LEVEL_PROCEDURE,
36: 'fpa.sql.PA_PJP_PVT.Submit_Project_Aw',
37: 'Checking for PJP License');
38: END IF;
39:
40: if (fnd_profile.value('PJP_PRODUCT_LICENSED')) = 'Y' then

Line 45: 'fpa.sql.PA_PJP_PVT.Submit_Project_Aw',

41:
42: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
43: FND_LOG.String(
44: FND_LOG.LEVEL_PROCEDURE,
45: 'fpa.sql.PA_PJP_PVT.Submit_Project_Aw',
46: 'PJP is licensed');
47: END IF;
48:
49: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 72: 'fpa.sql.PA_PJP_PVT.Submit_Project_Aw',

68:
69: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
70: FND_LOG.String(
71: FND_LOG.LEVEL_PROCEDURE,
72: 'fpa.sql.PA_PJP_PVT.Submit_Project_Aw',
73: 'PJP is NOT licensed');
74: END IF;
75:
76: end if;

Line 81: 'fpa.sql.PA_PJP_PVT.Submit_Project_Aw',

77:
78: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
79: FND_LOG.String(
80: FND_LOG.LEVEL_PROCEDURE,
81: 'fpa.sql.PA_PJP_PVT.Submit_Project_Aw',
82: 'Returning');
83: END IF;
84:
85:

Line 92: 'fpa.sql.FPA_PJP_PVT.Submit_Project_Aw',

88: WHEN OTHERS then
89: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
90: FND_LOG.String
91: ( FND_LOG.LEVEL_ERROR,
92: 'fpa.sql.FPA_PJP_PVT.Submit_Project_Aw',
93: 'WHEN OTHERS '||SQLERRM);
94: END IF;
95:
96: END Submit_Project_Aw;

Line 113: 'fpa.sql.PA_PJP_PVT.proj_scorecard_link_enabled.Begin',

109:
110: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
111: FND_LOG.String(
112: FND_LOG.LEVEL_PROCEDURE,
113: 'fpa.sql.PA_PJP_PVT.proj_scorecard_link_enabled.Begin',
114: 'Entering');
115: END IF;
116:
117: L_SQL_STAT := 'BEGIN :1 := Fpa_Process_Pvt.proj_scorecard_link_enabled(:2, :3); END;';

Line 125: 'fpa.sql.PA_PJP_PVT.proj_scorecard_link_enabled.Begin',

121:
122: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
123: FND_LOG.String(
124: FND_LOG.LEVEL_PROCEDURE,
125: 'fpa.sql.PA_PJP_PVT.proj_scorecard_link_enabled.Begin',
126: 'Returning l_return_flag '||l_return_flag);
127: END IF;
128:
129: RETURN l_RETURN_FLAG;

Line 137: 'fpa.sql.FPA_PJP_PVT.proj_scorecard_link_enabled',

133: WHEN OTHERS then
134: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
135: FND_LOG.String
136: ( FND_LOG.LEVEL_ERROR,
137: 'fpa.sql.FPA_PJP_PVT.proj_scorecard_link_enabled',
138: 'WHEN OTHERS '||SQLERRM);
139: END IF;
140:
141: RETURN l_return_flag;

Line 146: END PA_PJP_PVT;

142:
143: END proj_scorecard_link_enabled;
144:
145:
146: END PA_PJP_PVT;