DBA Data[Home] [Help]

APPS.OKL_CONTRACT_PROD_OPTNS_PUB dependencies on FND_MSG_PUB

Line 34: FND_MSG_PUB.initialize;

30: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
31: END IF;
32: -- Initialize message list if p_init_msg_list is set to TRUE.
33: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
34: FND_MSG_PUB.initialize;
35: END IF;
36: l_cspv_rec := p_cspv_rec;
37: g_cspv_rec := l_cspv_rec;
38: -- Customer pre processing section

Line 64: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

60: EXCEPTION
61: When FND_API.G_EXC_ERROR then
62: ROLLBACK TO create_contract_option_pub;
63: x_return_status := FND_API.G_RET_STS_ERROR;
64: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
65: p_data => x_msg_data);
66: When FND_API.G_EXC_UNEXPECTED_ERROR then
67: ROLLBACK TO create_contract_option_pub;
68: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 69: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

65: p_data => x_msg_data);
66: When FND_API.G_EXC_UNEXPECTED_ERROR then
67: ROLLBACK TO create_contract_option_pub;
68: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
69: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
70: p_data => x_msg_data);
71: When OTHERS then
72: ROLLBACK TO create_contract_option_pub;
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 74: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'create_contract_option_pub');

70: p_data => x_msg_data);
71: When OTHERS then
72: ROLLBACK TO create_contract_option_pub;
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
74: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'create_contract_option_pub');
75: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
76: p_count => x_msg_count,
77: p_data => x_msg_data);
78: END create_contract_option;

Line 75: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

71: When OTHERS then
72: ROLLBACK TO create_contract_option_pub;
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
74: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'create_contract_option_pub');
75: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
76: p_count => x_msg_count,
77: p_data => x_msg_data);
78: END create_contract_option;
79:

Line 131: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

127: EXCEPTION
128: WHEN FND_API.G_EXC_ERROR THEN
129: ROLLBACK TO create_contract_option_pub;
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
132: p_data => x_msg_data);
133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
134: ROLLBACK TO create_contract_option_pub;
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 136: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

132: p_data => x_msg_data);
133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
134: ROLLBACK TO create_contract_option_pub;
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
137: p_data => x_msg_data);
138: WHEN OTHERS then
139: ROLLBACK TO create_contract_option_pub;
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 141: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'create_contract_option_pub');

137: p_data => x_msg_data);
138: WHEN OTHERS then
139: ROLLBACK TO create_contract_option_pub;
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
141: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'create_contract_option_pub');
142: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
143: p_count => x_msg_count,
144: p_data => x_msg_data);
145: END create_contract_option;

Line 142: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

138: WHEN OTHERS then
139: ROLLBACK TO create_contract_option_pub;
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
141: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'create_contract_option_pub');
142: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
143: p_count => x_msg_count,
144: p_data => x_msg_data);
145: END create_contract_option;
146:

Line 178: FND_MSG_PUB.initialize;

174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: END IF;
176: -- Initialize message list if p_init_msg_list is set to TRUE.
177: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
178: FND_MSG_PUB.initialize;
179: END IF;
180: l_cspv_rec := p_cspv_rec;
181: g_cspv_rec := l_cspv_rec;
182: -- Customer pre processing section

Line 208: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

204: EXCEPTION
205: When FND_API.G_EXC_ERROR then
206: ROLLBACK TO update_contract_option_pub;
207: x_return_status := FND_API.G_RET_STS_ERROR;
208: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
209: p_data => x_msg_data);
210: When FND_API.G_EXC_UNEXPECTED_ERROR then
211: ROLLBACK TO update_contract_option_pub;
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 213: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

209: p_data => x_msg_data);
210: When FND_API.G_EXC_UNEXPECTED_ERROR then
211: ROLLBACK TO update_contract_option_pub;
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
214: p_data => x_msg_data);
215: When OTHERS then
216: ROLLBACK TO update_contract_option_pub;
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 218: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'update_contract_option_pub');

214: p_data => x_msg_data);
215: When OTHERS then
216: ROLLBACK TO update_contract_option_pub;
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'update_contract_option_pub');
219: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
220: p_count => x_msg_count,
221: p_data => x_msg_data);
222: END update_contract_option;

Line 219: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

215: When OTHERS then
216: ROLLBACK TO update_contract_option_pub;
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'update_contract_option_pub');
219: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
220: p_count => x_msg_count,
221: p_data => x_msg_data);
222: END update_contract_option;
223:

Line 275: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

271: EXCEPTION
272: WHEN FND_API.G_EXC_ERROR THEN
273: ROLLBACK TO update_contract_option_pub;
274: x_return_status := FND_API.G_RET_STS_ERROR;
275: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
276: p_data => x_msg_data);
277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
278: ROLLBACK TO update_contract_option_pub;
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 280: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

276: p_data => x_msg_data);
277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
278: ROLLBACK TO update_contract_option_pub;
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
281: p_data => x_msg_data);
282: WHEN OTHERS then
283: ROLLBACK TO update_contract_option_pub;
284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 285: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'update_contract_option_pub');

281: p_data => x_msg_data);
282: WHEN OTHERS then
283: ROLLBACK TO update_contract_option_pub;
284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
285: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'update_contract_option_pub');
286: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
287: p_count => x_msg_count,
288: p_data => x_msg_data);
289: END update_contract_option;

Line 286: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

282: WHEN OTHERS then
283: ROLLBACK TO update_contract_option_pub;
284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
285: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'update_contract_option_pub');
286: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
287: p_count => x_msg_count,
288: p_data => x_msg_data);
289: END update_contract_option;
290:

Line 321: FND_MSG_PUB.initialize;

317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: END IF;
319: -- Initialize message list if p_init_msg_list is set to TRUE.
320: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
321: FND_MSG_PUB.initialize;
322: END IF;
323: l_cspv_rec := p_cspv_rec;
324: g_cspv_rec := l_cspv_rec;
325: -- Customer pre processing section

Line 349: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

345: EXCEPTION
346: When FND_API.G_EXC_ERROR then
347: ROLLBACK TO delete_contract_option_pub;
348: x_return_status := FND_API.G_RET_STS_ERROR;
349: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
350: p_data => x_msg_data);
351: When FND_API.G_EXC_UNEXPECTED_ERROR then
352: ROLLBACK TO delete_contract_option_pub;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 354: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

350: p_data => x_msg_data);
351: When FND_API.G_EXC_UNEXPECTED_ERROR then
352: ROLLBACK TO delete_contract_option_pub;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
355: p_data => x_msg_data);
356: When OTHERS then
357: ROLLBACK TO delete_contract_option_pub;
358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 359: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'delete_contract_option_pub');

355: p_data => x_msg_data);
356: When OTHERS then
357: ROLLBACK TO delete_contract_option_pub;
358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
359: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'delete_contract_option_pub');
360: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
361: p_count => x_msg_count,
362: p_data => x_msg_data);
363: END delete_contract_option;

Line 360: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

356: When OTHERS then
357: ROLLBACK TO delete_contract_option_pub;
358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
359: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'delete_contract_option_pub');
360: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
361: p_count => x_msg_count,
362: p_data => x_msg_data);
363: END delete_contract_option;
364:

Line 414: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

410: EXCEPTION
411: WHEN FND_API.G_EXC_ERROR THEN
412: ROLLBACK TO delete_contract_option_pub;
413: x_return_status := FND_API.G_RET_STS_ERROR;
414: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
415: p_data => x_msg_data);
416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
417: ROLLBACK TO delete_contract_option_pub;
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 419: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

415: p_data => x_msg_data);
416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
417: ROLLBACK TO delete_contract_option_pub;
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
419: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
420: p_data => x_msg_data);
421: WHEN OTHERS then
422: ROLLBACK TO delete_contract_option_pub;
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 424: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'delete_contract_option_pub');

420: p_data => x_msg_data);
421: WHEN OTHERS then
422: ROLLBACK TO delete_contract_option_pub;
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'delete_contract_option_pub');
425: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
426: p_count => x_msg_count,
427: p_data => x_msg_data);
428: END delete_contract_option;

Line 425: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

421: WHEN OTHERS then
422: ROLLBACK TO delete_contract_option_pub;
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'delete_contract_option_pub');
425: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
426: p_count => x_msg_count,
427: p_data => x_msg_data);
428: END delete_contract_option;
429:

Line 461: FND_MSG_PUB.initialize;

457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
458: END IF;
459: -- Initialize message list if p_init_msg_list is set to TRUE.
460: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
461: FND_MSG_PUB.initialize;
462: END IF;
463: l_cspv_rec := p_cspv_rec;
464: g_cspv_rec := l_cspv_rec;
465: -- Customer pre processing section

Line 489: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

485: EXCEPTION
486: When FND_API.G_EXC_ERROR then
487: ROLLBACK TO validate_contract_option_pub;
488: x_return_status := FND_API.G_RET_STS_ERROR;
489: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
490: p_data => x_msg_data);
491: When FND_API.G_EXC_UNEXPECTED_ERROR then
492: ROLLBACK TO validate_contract_option_pub;
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 494: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

490: p_data => x_msg_data);
491: When FND_API.G_EXC_UNEXPECTED_ERROR then
492: ROLLBACK TO validate_contract_option_pub;
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
494: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
495: p_data => x_msg_data);
496: When OTHERS then
497: ROLLBACK TO validate_contract_option_pub;
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 499: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'validate_contract_option_pub');

495: p_data => x_msg_data);
496: When OTHERS then
497: ROLLBACK TO validate_contract_option_pub;
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
499: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'validate_contract_option_pub');
500: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
501: p_count => x_msg_count,
502: p_data => x_msg_data);
503: END validate_contract_option;

Line 500: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

496: When OTHERS then
497: ROLLBACK TO validate_contract_option_pub;
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
499: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'validate_contract_option_pub');
500: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
501: p_count => x_msg_count,
502: p_data => x_msg_data);
503: END validate_contract_option;
504:

Line 554: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

550: EXCEPTION
551: WHEN FND_API.G_EXC_ERROR THEN
552: ROLLBACK TO validate_contract_option_pub;
553: x_return_status := FND_API.G_RET_STS_ERROR;
554: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
555: p_data => x_msg_data);
556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
557: ROLLBACK TO validate_contract_option_pub;
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 559: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

555: p_data => x_msg_data);
556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
557: ROLLBACK TO validate_contract_option_pub;
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
560: p_data => x_msg_data);
561: WHEN OTHERS then
562: ROLLBACK TO validate_contract_option_pub;
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 564: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'validate_contract_option_pub');

560: p_data => x_msg_data);
561: WHEN OTHERS then
562: ROLLBACK TO validate_contract_option_pub;
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'validate_contract_option_pub');
565: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
566: p_count => x_msg_count,
567: p_data => x_msg_data);
568: END validate_contract_option;

Line 565: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

561: WHEN OTHERS then
562: ROLLBACK TO validate_contract_option_pub;
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'validate_contract_option_pub');
565: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
566: p_count => x_msg_count,
567: p_data => x_msg_data);
568: END validate_contract_option;
569:

Line 601: FND_MSG_PUB.initialize;

597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: END IF;
599: -- Initialize message list if p_init_msg_list is set to TRUE.
600: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
601: FND_MSG_PUB.initialize;
602: END IF;
603: l_cspv_rec := p_cspv_rec;
604: -- Business API call section
605: l_cspv_rec.id := p_cspv_rec.id;

Line 624: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

620: EXCEPTION
621: When FND_API.G_EXC_ERROR then
622: ROLLBACK TO lock_contract_option_pub;
623: x_return_status := FND_API.G_RET_STS_ERROR;
624: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
625: p_data => x_msg_data);
626: When FND_API.G_EXC_UNEXPECTED_ERROR then
627: ROLLBACK TO lock_contract_option_pub;
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 629: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

625: p_data => x_msg_data);
626: When FND_API.G_EXC_UNEXPECTED_ERROR then
627: ROLLBACK TO lock_contract_option_pub;
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
630: p_data => x_msg_data);
631: When OTHERS then
632: ROLLBACK TO lock_contract_option_pub;
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 634: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'lock_contract_option_pub');

630: p_data => x_msg_data);
631: When OTHERS then
632: ROLLBACK TO lock_contract_option_pub;
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'lock_contract_option_pub');
635: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
636: p_count => x_msg_count,
637: p_data => x_msg_data);
638: END lock_contract_option;

Line 635: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

631: When OTHERS then
632: ROLLBACK TO lock_contract_option_pub;
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'lock_contract_option_pub');
635: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
636: p_count => x_msg_count,
637: p_data => x_msg_data);
638: END lock_contract_option;
639:

Line 689: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

685: EXCEPTION
686: WHEN FND_API.G_EXC_ERROR THEN
687: ROLLBACK TO lock_contract_option_pub;
688: x_return_status := FND_API.G_RET_STS_ERROR;
689: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
690: p_data => x_msg_data);
691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
692: ROLLBACK TO lock_contract_option_pub;
693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 694: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

690: p_data => x_msg_data);
691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
692: ROLLBACK TO lock_contract_option_pub;
693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
694: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
695: p_data => x_msg_data);
696: WHEN OTHERS then
697: ROLLBACK TO lock_contract_option_pub;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 699: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'lock_contract_option_pub');

695: p_data => x_msg_data);
696: WHEN OTHERS then
697: ROLLBACK TO lock_contract_option_pub;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'lock_contract_option_pub');
700: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
701: p_count => x_msg_count,
702: p_data => x_msg_data);
703: END lock_contract_option;

Line 700: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

696: WHEN OTHERS then
697: ROLLBACK TO lock_contract_option_pub;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'lock_contract_option_pub');
700: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
701: p_count => x_msg_count,
702: p_data => x_msg_data);
703: END lock_contract_option;
704: END OKL_CONTRACT_PROD_OPTNS_PUB;