APPS.PA_PAGE_LAYOUT_PKG dependencies on FND_API

Line 29: x_return_status := FND_API.G_RET_STS_SUCCESS;

25: FROM pa_page_layouts
26: WHERE page_id = l_page_id;
27:
28: begin
29: x_return_status := FND_API.G_RET_STS_SUCCESS;
30:
31:
32: -- SELECT pa_page_layouts_s.NEXTVAL
33: -- INTO l_page_id

Line 82: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

78: EXCEPTION
79: WHEN OTHERS THEN -- catch the exceptions here
80: -- Set the current program unit name in the error stack
81: -- PA_Error_Utils.Set_Error_Stack('PA_PROJECT_SUBTEAMS_PKG.Insert_Row');
82: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
83: RAISE;
84: end INSERT_PAGE_LAYOUT_ROW;
85:
86: procedure UPDATE_PAGE_LAYOUT_ROW (

Line 102: x_return_status := FND_API.G_RET_STS_SUCCESS;

98: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
99: ) is
100: BEGIN
101:
102: x_return_status := FND_API.G_RET_STS_SUCCESS;
103: update PA_PAGE_LAYOUTS set
104: PAGE_NAME = P_PAGE_NAME,
105: PAGE_TYPE_CODE = Nvl(p_page_type, page_type_code),
106: DESCRIPTION = P_DESCRIPTION,

Line 120: x_return_status := FND_API.G_RET_STS_ERROR;

116:
117:
118: if (sql%notfound) then
119: PA_UTILS.Add_Message ( p_app_short_name => 'PA',p_msg_name => 'PA_XC_RECORD_CHANGED');
120: x_return_status := FND_API.G_RET_STS_ERROR;
121: RETURN;
122: end if;
123:
124: EXCEPTION

Line 128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

124: EXCEPTION
125: WHEN OTHERS THEN -- catch the exceptins here
126: -- Set the current program unit name in the error stack
127: -- PA_Error_Utils.Set_Error_Stack('PA_PROJECT_SUBTEAMS_PKG.Update_Row');
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
129: RAISE;
130:
131: end UPDATE_PAGE_LAYOUT_ROW;
132:

Line 143: x_return_status := FND_API.G_RET_STS_SUCCESS;

139: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
140: ) is
141: BEGIN
142:
143: x_return_status := FND_API.G_RET_STS_SUCCESS;
144:
145: delete from PA_PAGE_LAYOUTS
146: where PAGE_ID = p_page_id
147: AND nvl(p_record_version_number, record_version_number) = record_version_number;

Line 152: -- x_return_status := FND_API.G_RET_STS_ERROR;

148:
149: --
150: -- IF (SQL%NOTFOUND) THEN
151: -- PA_UTILS.Add_Message ( p_app_short_name => 'PA', p_msg_name => 'PA_XC_RECORD_CHANGED');
152: -- x_return_status := FND_API.G_RET_STS_ERROR;
153: -- RETURN;
154: --END IF;
155:
156: EXCEPTION

Line 160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

156: EXCEPTION
157: WHEN OTHERS THEN
158: -- Set the current program unit name in the error stack
159:
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
161: RAISE;
162:
163:
164: end DELETE_PAGE_LAYOUT_ROW;

Line 190: x_return_status := FND_API.G_RET_STS_SUCCESS;

186: and REGION_SOURCE_CODE = P_REGION_SOURCE_CODE
187: ;
188: BEGIN
189:
190: x_return_status := FND_API.G_RET_STS_SUCCESS;
191:
192: insert into PA_PAGE_LAYOUT_REGIONS (
193: PAGE_ID,
194: REGION_SOURCE_TYPE,

Line 234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

230: EXCEPTION
231: WHEN OTHERS THEN -- catch the exceptions here
232: -- Set the current program unit name in the error stack
233: -- PA_Error_Utils.Set_Error_Stack('PA_PROJECT_SUBTEAMS_PKG.Insert_Row');
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
235: RAISE;
236: end INSERT_PAGE_REGION_ROW;
237:
238: procedure DELETE_PAGE_REGION_ROW (

Line 249: x_return_status := FND_API.G_RET_STS_SUCCESS;

245: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
246: ) is
247: BEGIN
248:
249: x_return_status := FND_API.G_RET_STS_SUCCESS;
250:
251:
252: delete from PA_PAGE_LAYOUT_REGIONS
253: where PAGE_ID = P_PAGE_ID

Line 262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

258: EXCEPTION
259: WHEN OTHERS THEN
260: -- Set the current program unit name in the error stack
261:
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
263: RAISE;
264:
265: end DELETE_PAGE_REGION_ROW;
266: