APPS.PA_PAGE_CONTENTS_PKG dependencies on FND_API

Line 27: x_return_status := FND_API.G_RET_STS_SUCCESS;

23: where Page_content_id = P_PAGE_CONTENT_ID;
24:
25: BEGIN
26:
27: x_return_status := FND_API.G_RET_STS_SUCCESS;
28:
29: --get the unique page content id from the Oracle Sequence
30: --SELECT pa.pa_page_contents_s.nextval
31: --INTO l_content_id

Line 80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

76: --x_page_content_id := l_content_id;
77:
78: EXCEPTION
79: WHEN OTHERS THEN
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
81: RAISE;
82:
83: end INSERT_PAGE_CONTENTS_ROW;
84:

Line 98: x_return_status := FND_API.G_RET_STS_SUCCESS;

94: x_msg_data OUT NOCOPY VARCHAR2
95: ) is
96: begin
97:
98: x_return_status := FND_API.G_RET_STS_SUCCESS;
99:
100: update PA_PAGE_CONTENTS set
101: PAGE_CONTENT = empty_clob(),
102: RECORD_VERSION_NUMBER = record_version_number +1,

Line 111: x_return_status := FND_API.G_RET_STS_ERROR;

107: --AND record_version_number = Nvl(p_record_version_number, record_version_number);
108:
109: if (sql%notfound) then
110: PA_UTILS.Add_Message ( p_app_short_name => 'PA',p_msg_name => 'PA_XC_RECORD_CHANGED');
111: x_return_status := FND_API.G_RET_STS_ERROR;
112: end if;
113:
114: EXCEPTION
115: WHEN OTHERS THEN

Line 116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

112: end if;
113:
114: EXCEPTION
115: WHEN OTHERS THEN
116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
117: RAISE;
118: end CLEAR_CLOB;
119:
120:

Line 136: x_return_status := FND_API.G_RET_STS_SUCCESS;

132: x_msg_count OUT NOCOPY NUMBER,
133: x_msg_data OUT NOCOPY VARCHAR2
134: ) is
135: begin
136: x_return_status := FND_API.G_RET_STS_SUCCESS;
137:
138: update PA_PAGE_CONTENTS set
139: OBJECT_TYPE = Nvl(p_object_type, object_type),
140: PK1_VALUE = Nvl(P_PK1_VALUE, PK1_VALUE),

Line 155: x_return_status := FND_API.G_RET_STS_ERROR;

151: AND record_version_number = Nvl(p_record_version_number, record_version_number);
152:
153: if (sql%notfound) then
154: PA_UTILS.Add_Message ( p_app_short_name => 'PA',p_msg_name => 'PA_XC_RECORD_CHANGED');
155: x_return_status := FND_API.G_RET_STS_ERROR;
156: end if;
157:
158: EXCEPTION
159: WHEN OTHERS THEN

Line 160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

156: end if;
157:
158: EXCEPTION
159: WHEN OTHERS THEN
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
161: RAISE;
162: end UPDATE_PAGE_CONTENTS_ROW;
163:
164:

Line 173: x_return_status := FND_API.G_RET_STS_SUCCESS;

169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2
171: ) is
172: begin
173: x_return_status := FND_API.G_RET_STS_SUCCESS;
174:
175: DELETE FROM PA_PAGE_CONTENTS
176: where page_content_id = P_PAGE_CONTENT_ID;
177:

Line 181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

177:
178:
179: EXCEPTION
180: WHEN OTHERS THEN
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
182: RAISE;
183: end DELETE_PAGE_CONTENTS_ROW;
184:
185: END PA_PAGE_CONTENTS_PKG;