DBA Data[Home] [Help]

APPS.IGW_STUDY_TITLES_PVT dependencies on FND_MSG_PUB

Line 35: fnd_msg_pub.initialize;

31: savepoint create_study_title;
32: end if;
33:
34: if fnd_api.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
35: fnd_msg_pub.initialize;
36: end if;
37:
38: l_proposal_id := p_proposal_id;
39:

Line 56: l_msg_count := FND_MSG_PUB.count_msg;

52: END IF;
53: END IF;
54: */
55:
56: l_msg_count := FND_MSG_PUB.count_msg;
57: If l_msg_count > 0 THEN
58: x_msg_count := l_msg_count;
59: If l_msg_count = 1 THEN
60: fnd_msg_pub.get

Line 60: fnd_msg_pub.get

56: l_msg_count := FND_MSG_PUB.count_msg;
57: If l_msg_count > 0 THEN
58: x_msg_count := l_msg_count;
59: If l_msg_count = 1 THEN
60: fnd_msg_pub.get
61: (p_encoded => FND_API.G_TRUE ,
62: p_msg_index => 1,
63: p_data => l_data,
64: p_msg_index_out => l_msg_index_out );

Line 93: l_msg_count := FND_MSG_PUB.count_msg;

89: X_RETURN_STATUS => l_return_status);
90:
91: x_return_status := l_return_status;
92:
93: l_msg_count := FND_MSG_PUB.count_msg;
94:
95: If l_msg_count > 0 THEN
96: x_msg_count := l_msg_count;
97: If l_msg_count = 1 THEN

Line 98: fnd_msg_pub.get

94:
95: If l_msg_count > 0 THEN
96: x_msg_count := l_msg_count;
97: If l_msg_count = 1 THEN
98: fnd_msg_pub.get
99: (p_encoded => FND_API.G_TRUE ,
100: p_msg_index => 1,
101: p_data => l_data,
102: p_msg_index_out => l_msg_index_out );

Line 114: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,

110: IF p_commit = FND_API.G_TRUE THEN
111: ROLLBACK TO create_study_title;
112: END IF;
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
115: p_data => x_msg_data);
116:
117: WHEN FND_API.G_EXC_ERROR THEN
118: IF p_commit = FND_API.G_TRUE THEN

Line 122: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,

118: IF p_commit = FND_API.G_TRUE THEN
119: ROLLBACK TO create_study_title;
120: END IF;
121: x_return_status := 'E';
122: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
123: p_data => x_msg_data);
124: WHEN OTHERS THEN
125: IF p_commit = FND_API.G_TRUE THEN
126: ROLLBACK TO create_study_title;

Line 129: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_STUDY_TITLES_PVT',

125: IF p_commit = FND_API.G_TRUE THEN
126: ROLLBACK TO create_study_title;
127: END IF;
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
129: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_STUDY_TITLES_PVT',
130: p_procedure_name => 'CREATE_STUDY_TITLE');
131: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
132: p_data => x_msg_data);
133: END CREATE_STUDY_TITLE;

Line 131: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,

127: END IF;
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
129: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_STUDY_TITLES_PVT',
130: p_procedure_name => 'CREATE_STUDY_TITLE');
131: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
132: p_data => x_msg_data);
133: END CREATE_STUDY_TITLE;
134:
135: ------------------------------------------------------------------------------------------------

Line 168: fnd_msg_pub.initialize;

164: SAVEPOINT update_study_title;
165: END IF;
166:
167: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
168: fnd_msg_pub.initialize;
169: end if;
170:
171: l_proposal_id := p_proposal_id;
172:

Line 189: l_msg_count := FND_MSG_PUB.count_msg;

185: END IF;
186: END IF;
187: */
188:
189: l_msg_count := FND_MSG_PUB.count_msg;
190: If l_msg_count > 0 THEN
191: x_msg_count := l_msg_count;
192: If l_msg_count = 1 THEN
193: fnd_msg_pub.get

Line 193: fnd_msg_pub.get

189: l_msg_count := FND_MSG_PUB.count_msg;
190: If l_msg_count > 0 THEN
191: x_msg_count := l_msg_count;
192: If l_msg_count = 1 THEN
193: fnd_msg_pub.get
194: (p_encoded => FND_API.G_TRUE ,
195: p_msg_index => 1,
196: p_data => l_data,
197: p_msg_index_out => l_msg_index_out );

Line 210: l_msg_count := FND_MSG_PUB.count_msg;

206: CHECK_LOCK(p_rowid
207: ,p_record_version_number
208: ,x_return_status );
209:
210: l_msg_count := FND_MSG_PUB.count_msg;
211: If l_msg_count > 0 THEN
212: x_msg_count := l_msg_count;
213: If l_msg_count = 1 THEN
214: fnd_msg_pub.get

Line 214: fnd_msg_pub.get

210: l_msg_count := FND_MSG_PUB.count_msg;
211: If l_msg_count > 0 THEN
212: x_msg_count := l_msg_count;
213: If l_msg_count = 1 THEN
214: fnd_msg_pub.get
215: (p_encoded => FND_API.G_TRUE ,
216: p_msg_index => 1,
217: p_data => l_data,
218: p_msg_index_out => l_msg_index_out );

Line 241: l_msg_count := FND_MSG_PUB.count_msg;

237:
238: end if;
239:
240:
241: l_msg_count := FND_MSG_PUB.count_msg;
242: If l_msg_count > 0 THEN
243: x_msg_count := l_msg_count;
244: If l_msg_count = 1 THEN
245: fnd_msg_pub.get

Line 245: fnd_msg_pub.get

241: l_msg_count := FND_MSG_PUB.count_msg;
242: If l_msg_count > 0 THEN
243: x_msg_count := l_msg_count;
244: If l_msg_count = 1 THEN
245: fnd_msg_pub.get
246: (p_encoded => FND_API.G_TRUE ,
247: p_msg_index => 1,
248: p_data => l_data,
249: p_msg_index_out => l_msg_index_out );

Line 268: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,

264: IF p_commit = FND_API.G_TRUE THEN
265: ROLLBACK TO update_study_title;
266: END IF;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
269: p_data => x_msg_data);
270:
271: WHEN FND_API.G_EXC_ERROR THEN
272: IF p_commit = FND_API.G_TRUE THEN

Line 276: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,

272: IF p_commit = FND_API.G_TRUE THEN
273: ROLLBACK TO update_study_title;
274: END IF;
275: x_return_status := 'E';
276: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
277: p_data => x_msg_data);
278:
279: WHEN OTHERS THEN
280: IF p_commit = FND_API.G_TRUE THEN

Line 284: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_STUDY_TITLES_PVT',

280: IF p_commit = FND_API.G_TRUE THEN
281: ROLLBACK TO update_study_title;
282: END IF;
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_STUDY_TITLES_PVT',
285: p_procedure_name => 'UPDATE_STUDY_TITLE');
286: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
287: p_data => x_msg_data);
288:

Line 286: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,

282: END IF;
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_STUDY_TITLES_PVT',
285: p_procedure_name => 'UPDATE_STUDY_TITLE');
286: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
287: p_data => x_msg_data);
288:
289: END UPDATE_STUDY_TITLE;
290: -------------------------------------------------------------------------------------------

Line 316: fnd_msg_pub.initialize;

312: END IF;
313:
314: -- initialize message list if p_init_msg_list is set to true
315: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
316: fnd_msg_pub.initialize;
317: end if;
318:
319: CHECK_LOCK (x_rowid => x_rowid
320: ,p_record_version_number => p_record_version_number

Line 323: l_msg_count := FND_MSG_PUB.count_msg;

319: CHECK_LOCK (x_rowid => x_rowid
320: ,p_record_version_number => p_record_version_number
321: ,x_return_status => x_return_status) ;
322:
323: l_msg_count := FND_MSG_PUB.count_msg;
324: If l_msg_count > 0 THEN
325: x_msg_count := l_msg_count;
326: If l_msg_count = 1 THEN
327: fnd_msg_pub.get

Line 327: fnd_msg_pub.get

323: l_msg_count := FND_MSG_PUB.count_msg;
324: If l_msg_count > 0 THEN
325: x_msg_count := l_msg_count;
326: If l_msg_count = 1 THEN
327: fnd_msg_pub.get
328: (p_encoded => FND_API.G_TRUE ,
329: p_msg_index => 1,
330: p_data => l_data,
331: p_msg_index_out => l_msg_index_out );

Line 348: l_msg_count := FND_MSG_PUB.count_msg;

344: x_return_status => x_return_status);
345:
346: end if;
347:
348: l_msg_count := FND_MSG_PUB.count_msg;
349: If l_msg_count > 0 THEN
350: x_msg_count := l_msg_count;
351: If l_msg_count = 1 THEN
352: fnd_msg_pub.get

Line 352: fnd_msg_pub.get

348: l_msg_count := FND_MSG_PUB.count_msg;
349: If l_msg_count > 0 THEN
350: x_msg_count := l_msg_count;
351: If l_msg_count = 1 THEN
352: fnd_msg_pub.get
353: (p_encoded => FND_API.G_TRUE ,
354: p_msg_index => 1,
355: p_data => l_data,
356: p_msg_index_out => l_msg_index_out );

Line 377: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,

373: IF p_commit = FND_API.G_TRUE THEN
374: ROLLBACK TO delete_study_title;
375: END IF;
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
378: p_data => x_msg_data);
379:
380: WHEN FND_API.G_EXC_ERROR THEN
381: IF p_commit = FND_API.G_TRUE THEN

Line 385: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,

381: IF p_commit = FND_API.G_TRUE THEN
382: ROLLBACK TO update_study_title;
383: END IF;
384: x_return_status := 'E';
385: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
386: p_data => x_msg_data);
387:
388: WHEN OTHERS THEN
389: IF p_commit = FND_API.G_TRUE THEN

Line 393: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_STUDY_TITLES_PVT',

389: IF p_commit = FND_API.G_TRUE THEN
390: ROLLBACK TO update_study_title;
391: END IF;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_STUDY_TITLES_PVT',
394: p_procedure_name => 'DELETE_STUDY_TITLE');
395: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
396: p_data => x_msg_data);
397: END;

Line 395: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,

391: END IF;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_STUDY_TITLES_PVT',
394: p_procedure_name => 'DELETE_STUDY_TITLE');
395: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
396: p_data => x_msg_data);
397: END;
398:
399:

Line 417: FND_MSG_PUB.Add;

413: EXCEPTION
414: WHEN NO_DATA_FOUND THEN
415: x_return_status := FND_API.G_RET_STS_ERROR;
416: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
417: FND_MSG_PUB.Add;
418: raise fnd_api.g_exc_error;
419:
420: WHEN OTHERS THEN
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 422: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_STUDY_TITLES_PVT',

418: raise fnd_api.g_exc_error;
419:
420: WHEN OTHERS THEN
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_STUDY_TITLES_PVT',
423: p_procedure_name => 'CHECK_LOCK');
424: raise fnd_api.g_exc_unexpected_error;
425:
426: