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.PA_PROJECT_SETS_PKG dependencies on FND_API

Line 36: x_return_status := FND_API.G_RET_STS_SUCCESS;

32: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
33: BEGIN
34:
35: -- Initialize the return status to success
36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37:
38: --Log Message
39: IF l_enable_log = 'Y' THEN
40: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SET_Pkg.insert_row.begin'

Line 142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

138: -- Set the excetption Message and the stack
139: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PKG.Insert_row'
140: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
141: --
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
143: RAISE;
144:
145: END Insert_Row;
146:

Line 180: x_return_status := FND_API.G_RET_STS_SUCCESS;

176: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
177: BEGIN
178:
179: -- Initialize the return status to success
180: x_return_status := FND_API.G_RET_STS_SUCCESS;
181:
182: --Log Message
183: IF l_enable_log = 'Y' THEN
184: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_Pkg.update_row.begin'

Line 190: SET party_id = decode(p_party_id, FND_API.G_MISS_NUM, party_id, p_party_id)

186: ,x_log_level => 5);
187: END IF;
188:
189: UPDATE pa_project_sets_b
190: SET party_id = decode(p_party_id, FND_API.G_MISS_NUM, party_id, p_party_id)
191: ,effective_start_date = decode(p_effective_start_date, FND_API.G_MISS_DATE, effective_start_date, p_effective_start_date)
192: ,effective_end_date = decode(p_effective_end_date, FND_API.G_MISS_DATE, effective_end_date, p_effective_end_date)
193: ,access_level = decode(p_access_level, FND_API.G_MISS_NUM, access_level, p_access_level)
194: ,record_version_number = record_version_number + 1

Line 191: ,effective_start_date = decode(p_effective_start_date, FND_API.G_MISS_DATE, effective_start_date, p_effective_start_date)

187: END IF;
188:
189: UPDATE pa_project_sets_b
190: SET party_id = decode(p_party_id, FND_API.G_MISS_NUM, party_id, p_party_id)
191: ,effective_start_date = decode(p_effective_start_date, FND_API.G_MISS_DATE, effective_start_date, p_effective_start_date)
192: ,effective_end_date = decode(p_effective_end_date, FND_API.G_MISS_DATE, effective_end_date, p_effective_end_date)
193: ,access_level = decode(p_access_level, FND_API.G_MISS_NUM, access_level, p_access_level)
194: ,record_version_number = record_version_number + 1
195: ,attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)

Line 192: ,effective_end_date = decode(p_effective_end_date, FND_API.G_MISS_DATE, effective_end_date, p_effective_end_date)

188:
189: UPDATE pa_project_sets_b
190: SET party_id = decode(p_party_id, FND_API.G_MISS_NUM, party_id, p_party_id)
191: ,effective_start_date = decode(p_effective_start_date, FND_API.G_MISS_DATE, effective_start_date, p_effective_start_date)
192: ,effective_end_date = decode(p_effective_end_date, FND_API.G_MISS_DATE, effective_end_date, p_effective_end_date)
193: ,access_level = decode(p_access_level, FND_API.G_MISS_NUM, access_level, p_access_level)
194: ,record_version_number = record_version_number + 1
195: ,attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)
196: ,attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1)

Line 193: ,access_level = decode(p_access_level, FND_API.G_MISS_NUM, access_level, p_access_level)

189: UPDATE pa_project_sets_b
190: SET party_id = decode(p_party_id, FND_API.G_MISS_NUM, party_id, p_party_id)
191: ,effective_start_date = decode(p_effective_start_date, FND_API.G_MISS_DATE, effective_start_date, p_effective_start_date)
192: ,effective_end_date = decode(p_effective_end_date, FND_API.G_MISS_DATE, effective_end_date, p_effective_end_date)
193: ,access_level = decode(p_access_level, FND_API.G_MISS_NUM, access_level, p_access_level)
194: ,record_version_number = record_version_number + 1
195: ,attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)
196: ,attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1)
197: ,attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2)

Line 195: ,attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)

191: ,effective_start_date = decode(p_effective_start_date, FND_API.G_MISS_DATE, effective_start_date, p_effective_start_date)
192: ,effective_end_date = decode(p_effective_end_date, FND_API.G_MISS_DATE, effective_end_date, p_effective_end_date)
193: ,access_level = decode(p_access_level, FND_API.G_MISS_NUM, access_level, p_access_level)
194: ,record_version_number = record_version_number + 1
195: ,attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)
196: ,attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1)
197: ,attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2)
198: ,attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3)
199: ,attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4)

Line 196: ,attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1)

192: ,effective_end_date = decode(p_effective_end_date, FND_API.G_MISS_DATE, effective_end_date, p_effective_end_date)
193: ,access_level = decode(p_access_level, FND_API.G_MISS_NUM, access_level, p_access_level)
194: ,record_version_number = record_version_number + 1
195: ,attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)
196: ,attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1)
197: ,attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2)
198: ,attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3)
199: ,attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4)
200: ,attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5)

Line 197: ,attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2)

193: ,access_level = decode(p_access_level, FND_API.G_MISS_NUM, access_level, p_access_level)
194: ,record_version_number = record_version_number + 1
195: ,attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)
196: ,attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1)
197: ,attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2)
198: ,attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3)
199: ,attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4)
200: ,attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5)
201: ,attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6)

Line 198: ,attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3)

194: ,record_version_number = record_version_number + 1
195: ,attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)
196: ,attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1)
197: ,attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2)
198: ,attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3)
199: ,attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4)
200: ,attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5)
201: ,attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6)
202: ,attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7)

Line 199: ,attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4)

195: ,attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)
196: ,attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1)
197: ,attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2)
198: ,attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3)
199: ,attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4)
200: ,attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5)
201: ,attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6)
202: ,attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7)
203: ,attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8)

Line 200: ,attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5)

196: ,attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1)
197: ,attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2)
198: ,attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3)
199: ,attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4)
200: ,attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5)
201: ,attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6)
202: ,attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7)
203: ,attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8)
204: ,attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9)

Line 201: ,attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6)

197: ,attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2)
198: ,attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3)
199: ,attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4)
200: ,attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5)
201: ,attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6)
202: ,attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7)
203: ,attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8)
204: ,attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9)
205: ,attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10)

Line 202: ,attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7)

198: ,attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3)
199: ,attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4)
200: ,attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5)
201: ,attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6)
202: ,attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7)
203: ,attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8)
204: ,attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9)
205: ,attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10)
206: ,attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11)

Line 203: ,attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8)

199: ,attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4)
200: ,attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5)
201: ,attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6)
202: ,attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7)
203: ,attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8)
204: ,attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9)
205: ,attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10)
206: ,attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11)
207: ,attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12)

Line 204: ,attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9)

200: ,attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5)
201: ,attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6)
202: ,attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7)
203: ,attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8)
204: ,attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9)
205: ,attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10)
206: ,attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11)
207: ,attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12)
208: ,attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13)

Line 205: ,attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10)

201: ,attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6)
202: ,attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7)
203: ,attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8)
204: ,attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9)
205: ,attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10)
206: ,attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11)
207: ,attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12)
208: ,attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13)
209: ,attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14)

Line 206: ,attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11)

202: ,attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7)
203: ,attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8)
204: ,attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9)
205: ,attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10)
206: ,attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11)
207: ,attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12)
208: ,attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13)
209: ,attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14)
210: ,attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15)

Line 207: ,attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12)

203: ,attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8)
204: ,attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9)
205: ,attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10)
206: ,attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11)
207: ,attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12)
208: ,attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13)
209: ,attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14)
210: ,attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15)
211: ,last_update_date = sysdate

Line 208: ,attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13)

204: ,attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9)
205: ,attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10)
206: ,attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11)
207: ,attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12)
208: ,attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13)
209: ,attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14)
210: ,attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15)
211: ,last_update_date = sysdate
212: ,last_updated_by = fnd_global.user_id

Line 209: ,attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14)

205: ,attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10)
206: ,attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11)
207: ,attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12)
208: ,attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13)
209: ,attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14)
210: ,attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15)
211: ,last_update_date = sysdate
212: ,last_updated_by = fnd_global.user_id
213: ,last_update_login = fnd_global.login_id

Line 210: ,attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15)

206: ,attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11)
207: ,attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12)
208: ,attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13)
209: ,attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14)
210: ,attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15)
211: ,last_update_date = sysdate
212: ,last_updated_by = fnd_global.user_id
213: ,last_update_login = fnd_global.login_id
214: WHERE project_set_id = p_project_set_id

Line 220: x_return_status := FND_API.G_RET_STS_ERROR;

216:
217: IF (sql%notfound) THEN
218: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
219: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: ELSE
222:
223: UPDATE pa_project_sets_tl
224: SET name = decode(p_project_set_name, FND_API.G_MISS_CHAR, name, p_project_set_name)

Line 224: SET name = decode(p_project_set_name, FND_API.G_MISS_CHAR, name, p_project_set_name)

220: x_return_status := FND_API.G_RET_STS_ERROR;
221: ELSE
222:
223: UPDATE pa_project_sets_tl
224: SET name = decode(p_project_set_name, FND_API.G_MISS_CHAR, name, p_project_set_name)
225: ,description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description)
226: ,last_update_date = sysdate
227: ,last_updated_by = fnd_global.user_id
228: ,last_update_login = fnd_global.login_id

Line 225: ,description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description)

221: ELSE
222:
223: UPDATE pa_project_sets_tl
224: SET name = decode(p_project_set_name, FND_API.G_MISS_CHAR, name, p_project_set_name)
225: ,description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description)
226: ,last_update_date = sysdate
227: ,last_updated_by = fnd_global.user_id
228: ,last_update_login = fnd_global.login_id
229: WHERE project_set_id = p_project_set_id

Line 233: x_return_status := FND_API.G_RET_STS_ERROR;

229: WHERE project_set_id = p_project_set_id
230: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);
231:
232: IF (sql%notfound) THEN
233: x_return_status := FND_API.G_RET_STS_ERROR;
234: END IF;
235:
236: END IF;
237:

Line 245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

241: -- Set the excetption Message and the stack
242: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PKG.update_row'
243: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
244: --
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
246: RAISE;
247:
248: END update_row;
249:

Line 261: x_return_status := FND_API.G_RET_STS_SUCCESS;

257: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
258: BEGIN
259:
260: -- Initialize the return status to success
261: x_return_status := FND_API.G_RET_STS_SUCCESS;
262:
263: DELETE FROM pa_project_sets_b
264: WHERE project_set_id = p_project_set_id
265: AND nvl(p_record_version_number, record_version_number) = record_version_number;

Line 270: x_return_status := FND_API.G_RET_STS_ERROR;

266:
267: IF (SQL%NOTFOUND) THEN
268: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
269: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: ELSE
272:
273: DELETE FROM pa_project_sets_tl
274: WHERE project_set_id = p_project_set_id;

Line 277: x_return_status := FND_API.G_RET_STS_ERROR;

273: DELETE FROM pa_project_sets_tl
274: WHERE project_set_id = p_project_set_id;
275:
276: IF (SQL%NOTFOUND) THEN
277: x_return_status := FND_API.G_RET_STS_ERROR;
278: END IF;
279:
280: END IF;
281:

Line 287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

283: WHEN OTHERS THEN
284: -- Set the exception Message and the stack
285: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_SETS_PKG.Delete_Row'
286: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
288: RAISE;
289: END Delete_Row;
290:
291:

Line 302: x_return_status := FND_API.G_RET_STS_SUCCESS;

298: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
299: BEGIN
300:
301: -- Initialize the return status to success
302: x_return_status := FND_API.G_RET_STS_SUCCESS;
303:
304: --Log Message
305: IF l_enable_log = 'Y' THEN
306: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SET_Pkg.insert_row_lines.begin'

Line 334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

330: -- Set the exception Message and the stack
331: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SET_LINES_PKG.Insert_row_lines'
332: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
333: --
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
335: RAISE;
336:
337: END Insert_Row_Lines;
338:

Line 350: x_return_status := FND_API.G_RET_STS_SUCCESS;

346: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
347: BEGIN
348:
349: -- Initialize the return status to success
350: x_return_status := FND_API.G_RET_STS_SUCCESS;
351:
352: --Log Message
353: IF l_enable_log = 'Y' THEN
354: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SET_Pkg.delete_row_lines.begin'

Line 371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

367: -- Set the exception Message and the stack
368: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SET_LINES_PKG.Delete_row_lines'
369: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
370: --
371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
372: RAISE;
373:
374: END Delete_Row_Lines;
375: