DBA Data[Home] [Help]

APPS.IGW_SUBJECT_INFORMATION_PVT dependencies on FND_MSG_PUB

Line 33: fnd_msg_pub.initialize;

29: SAVEPOINT create_subject_information;
30: END IF;
31:
32: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
33: fnd_msg_pub.initialize;
34: end if;
35:
36:
37: IGW_SUBJECT_INFORMATION_TBH.INSERT_ROW (

Line 48: l_msg_count := FND_MSG_PUB.count_msg;

44: X_RETURN_STATUS => l_return_status);
45:
46: x_return_status := l_return_status;
47:
48: l_msg_count := FND_MSG_PUB.count_msg;
49:
50: If l_msg_count > 0 THEN
51: x_msg_count := l_msg_count;
52: If l_msg_count = 1 THEN

Line 53: fnd_msg_pub.get

49:
50: If l_msg_count > 0 THEN
51: x_msg_count := l_msg_count;
52: If l_msg_count = 1 THEN
53: fnd_msg_pub.get
54: (p_encoded => FND_API.G_TRUE ,
55: p_msg_index => 1,
56: p_data => l_data,
57: p_msg_index_out => l_msg_index_out );

Line 71: Fnd_Msg_Pub.Count_And_Get

67: rollback to create_subject_information;
68: end if;
69: x_return_status := fnd_api.g_ret_sts_unexp_error;
70:
71: Fnd_Msg_Pub.Count_And_Get
72: ( p_count => x_msg_count,
73: p_data => x_msg_data);
74:
75:

Line 81: Fnd_Msg_Pub.Count_And_Get

77: IF p_commit = fnd_api.g_true then
78: rollback TO create_subject_information;
79: end if;
80: x_return_status := 'E';
81: Fnd_Msg_Pub.Count_And_Get
82: ( p_count => x_msg_count,
83: p_data => x_msg_data);
84:
85: when others then

Line 90: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SUBJECT_INFORMATION_PVT',

86: if p_commit = fnd_api.g_true then
87: rollback to create_subject_information;
88: end if;
89: x_return_status := fnd_api.g_ret_sts_unexp_error;
90: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SUBJECT_INFORMATION_PVT',
91: p_procedure_name => 'CREATE_SUBJECT_INFORMATION');
92:
93: Fnd_Msg_Pub.Count_And_Get
94: ( p_count => x_msg_count,

Line 93: Fnd_Msg_Pub.Count_And_Get

89: x_return_status := fnd_api.g_ret_sts_unexp_error;
90: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SUBJECT_INFORMATION_PVT',
91: p_procedure_name => 'CREATE_SUBJECT_INFORMATION');
92:
93: Fnd_Msg_Pub.Count_And_Get
94: ( p_count => x_msg_count,
95: p_data => x_msg_data);
96:
97: END CREATE_SUBJECT_INFORMATION;

Line 131: fnd_msg_pub.initialize;

127: SAVEPOINT update_study_title;
128: END IF;
129:
130: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
131: fnd_msg_pub.initialize;
132: end if;
133:
134: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
135:

Line 140: l_msg_count := FND_MSG_PUB.count_msg;

136: CHECK_LOCK(p_rowid
137: ,p_record_version_number
138: ,x_return_status );
139:
140: l_msg_count := FND_MSG_PUB.count_msg;
141: If l_msg_count > 0 THEN
142: x_msg_count := l_msg_count;
143: If l_msg_count = 1 THEN
144: fnd_msg_pub.get

Line 144: fnd_msg_pub.get

140: l_msg_count := FND_MSG_PUB.count_msg;
141: If l_msg_count > 0 THEN
142: x_msg_count := l_msg_count;
143: If l_msg_count = 1 THEN
144: fnd_msg_pub.get
145: (p_encoded => FND_API.G_TRUE ,
146: p_msg_index => 1,
147: p_data => l_data,
148: p_msg_index_out => l_msg_index_out );

Line 170: l_msg_count := FND_MSG_PUB.count_msg;

166:
167: end if;
168:
169:
170: l_msg_count := FND_MSG_PUB.count_msg;
171: If l_msg_count > 0 THEN
172: x_msg_count := l_msg_count;
173: If l_msg_count = 1 THEN
174: fnd_msg_pub.get

Line 174: fnd_msg_pub.get

170: l_msg_count := FND_MSG_PUB.count_msg;
171: If l_msg_count > 0 THEN
172: x_msg_count := l_msg_count;
173: If l_msg_count = 1 THEN
174: fnd_msg_pub.get
175: (p_encoded => FND_API.G_TRUE ,
176: p_msg_index => 1,
177: p_data => l_data,
178: p_msg_index_out => l_msg_index_out );

Line 197: Fnd_Msg_Pub.Count_And_Get

193: IF p_commit = FND_API.G_TRUE THEN
194: ROLLBACK TO update_study_title;
195: END IF;
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
197: Fnd_Msg_Pub.Count_And_Get
198: ( p_count => x_msg_count,
199: p_data => x_msg_data);
200:
201: WHEN FND_API.G_EXC_ERROR THEN

Line 206: Fnd_Msg_Pub.Count_And_Get

202: IF p_commit = FND_API.G_TRUE THEN
203: ROLLBACK TO update_study_title;
204: END IF;
205: x_return_status := 'E';
206: Fnd_Msg_Pub.Count_And_Get
207: ( p_count => x_msg_count,
208: p_data => x_msg_data);
209:
210: WHEN OTHERS THEN

Line 215: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SUBJECT_INFORMATION_PVT',

211: IF p_commit = FND_API.G_TRUE THEN
212: ROLLBACK TO update_study_title;
213: END IF;
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
215: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SUBJECT_INFORMATION_PVT',
216: p_procedure_name => 'UPDATE_SUBJECT_INFORMATION');
217: Fnd_Msg_Pub.Count_And_Get
218: ( p_count => x_msg_count,
219: p_data => x_msg_data);

Line 217: Fnd_Msg_Pub.Count_And_Get

213: END IF;
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
215: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SUBJECT_INFORMATION_PVT',
216: p_procedure_name => 'UPDATE_SUBJECT_INFORMATION');
217: Fnd_Msg_Pub.Count_And_Get
218: ( p_count => x_msg_count,
219: p_data => x_msg_data);
220:
221: END UPDATE_SUBJECT_INFORMATION;

Line 248: fnd_msg_pub.initialize;

244: END IF;
245:
246: -- initialize message list if p_init_msg_list is set to true
247: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
248: fnd_msg_pub.initialize;
249: end if;
250:
251: CHECK_LOCK (x_rowid => x_rowid
252: ,p_record_version_number => p_record_version_number

Line 255: l_msg_count := FND_MSG_PUB.count_msg;

251: CHECK_LOCK (x_rowid => x_rowid
252: ,p_record_version_number => p_record_version_number
253: ,x_return_status => x_return_status) ;
254:
255: l_msg_count := FND_MSG_PUB.count_msg;
256: If l_msg_count > 0 THEN
257: x_msg_count := l_msg_count;
258: If l_msg_count = 1 THEN
259: fnd_msg_pub.get

Line 259: fnd_msg_pub.get

255: l_msg_count := FND_MSG_PUB.count_msg;
256: If l_msg_count > 0 THEN
257: x_msg_count := l_msg_count;
258: If l_msg_count = 1 THEN
259: fnd_msg_pub.get
260: (p_encoded => FND_API.G_TRUE ,
261: p_msg_index => 1,
262: p_data => l_data,
263: p_msg_index_out => l_msg_index_out );

Line 279: l_msg_count := FND_MSG_PUB.count_msg;

275: x_return_status => x_return_status);
276:
277: end if;
278:
279: l_msg_count := FND_MSG_PUB.count_msg;
280: If l_msg_count > 0 THEN
281: x_msg_count := l_msg_count;
282: If l_msg_count = 1 THEN
283: fnd_msg_pub.get

Line 283: fnd_msg_pub.get

279: l_msg_count := FND_MSG_PUB.count_msg;
280: If l_msg_count > 0 THEN
281: x_msg_count := l_msg_count;
282: If l_msg_count = 1 THEN
283: fnd_msg_pub.get
284: (p_encoded => FND_API.G_TRUE ,
285: p_msg_index => 1,
286: p_data => l_data,
287: p_msg_index_out => l_msg_index_out );

Line 308: Fnd_Msg_Pub.Count_And_Get

304: IF p_commit = FND_API.G_TRUE THEN
305: ROLLBACK TO delete_study_title;
306: END IF;
307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
308: Fnd_Msg_Pub.Count_And_Get
309: ( p_count => x_msg_count,
310: p_data => x_msg_data);
311:
312: WHEN FND_API.G_EXC_ERROR THEN

Line 317: Fnd_Msg_Pub.Count_And_Get

313: IF p_commit = FND_API.G_TRUE THEN
314: ROLLBACK TO update_study_title;
315: END IF;
316: x_return_status := 'E';
317: Fnd_Msg_Pub.Count_And_Get
318: ( p_count => x_msg_count,
319: p_data => x_msg_data);
320:
321: WHEN OTHERS THEN

Line 326: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SUBJECT_INFORMATION_PVT',

322: IF p_commit = FND_API.G_TRUE THEN
323: ROLLBACK TO update_study_title;
324: END IF;
325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
326: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SUBJECT_INFORMATION_PVT',
327: p_procedure_name => 'DELETE_SUBJECT_INFORMATION');
328: Fnd_Msg_Pub.Count_And_Get
329: ( p_count => x_msg_count,
330: p_data => x_msg_data);

Line 328: Fnd_Msg_Pub.Count_And_Get

324: END IF;
325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
326: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SUBJECT_INFORMATION_PVT',
327: p_procedure_name => 'DELETE_SUBJECT_INFORMATION');
328: Fnd_Msg_Pub.Count_And_Get
329: ( p_count => x_msg_count,
330: p_data => x_msg_data);
331: END;
332:

Line 351: FND_MSG_PUB.Add;

347: EXCEPTION
348: WHEN NO_DATA_FOUND THEN
349: x_return_status := FND_API.G_RET_STS_ERROR;
350: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
351: FND_MSG_PUB.Add;
352: raise fnd_api.g_exc_error;
353:
354: WHEN OTHERS THEN
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 356: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SUBJECT_INFORMATION_PVT',

352: raise fnd_api.g_exc_error;
353:
354: WHEN OTHERS THEN
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SUBJECT_INFORMATION_PVT',
357: p_procedure_name => 'CHECK_LOCK');
358: raise fnd_api.g_exc_unexpected_error;
359:
360: