DBA Data[Home] [Help]

APPS.OKL_CREATE_KLE_PUB dependencies on FND_MSG_PUB

Line 76: FND_MSG_PUB.initialize;

72: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
73: END IF;
74: -- Initialize message list if p_init_msg_list is set to TRUE.
75: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
76: FND_MSG_PUB.initialize;
77: END IF;
78: l_klev_fin_rec := p_klev_rec;
79: l_clev_fin_rec := p_clev_rec;
80: g_klev_fin_rec := l_klev_fin_rec;

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

107: EXCEPTION
108: When FND_API.G_EXC_ERROR then
109: ROLLBACK TO Update_fin_cap_cost_pub;
110: x_return_status := FND_API.G_RET_STS_ERROR;
111: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
112: p_data => x_msg_data);
113: When FND_API.G_EXC_UNEXPECTED_ERROR then
114: ROLLBACK TO Update_fin_cap_cost_pub;
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

112: p_data => x_msg_data);
113: When FND_API.G_EXC_UNEXPECTED_ERROR then
114: ROLLBACK TO Update_fin_cap_cost_pub;
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
116: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
117: p_data => x_msg_data);
118: When OTHERS then
119: ROLLBACK TO Update_fin_cap_cost_pub;
120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 121: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_CREATE_KLE_PUB');

117: p_data => x_msg_data);
118: When OTHERS then
119: ROLLBACK TO Update_fin_cap_cost_pub;
120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
121: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_CREATE_KLE_PUB');
122: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
123: p_count => x_msg_count,
124: p_data => x_msg_data);
125: END Update_fin_cap_cost;

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

118: When OTHERS then
119: ROLLBACK TO Update_fin_cap_cost_pub;
120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
121: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_CREATE_KLE_PUB');
122: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
123: p_count => x_msg_count,
124: p_data => x_msg_data);
125: END Update_fin_cap_cost;
126:

Line 162: FND_MSG_PUB.initialize;

158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
159: END IF;
160: -- Initialize message list if p_init_msg_list is set to TRUE.
161: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
162: FND_MSG_PUB.initialize;
163: END IF;
164: l_klev_tbl := p_klev_tbl;
165: l_clev_tbl := p_clev_tbl;
166: l_cimv_tbl := p_cimv_tbl;

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

201: EXCEPTION
202: When FND_API.G_EXC_ERROR then
203: ROLLBACK TO Create_add_on_line_pub;
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
206: p_data => x_msg_data);
207: When FND_API.G_EXC_UNEXPECTED_ERROR then
208: ROLLBACK TO Create_add_on_line_pub;
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

206: p_data => x_msg_data);
207: When FND_API.G_EXC_UNEXPECTED_ERROR then
208: ROLLBACK TO Create_add_on_line_pub;
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
211: p_data => x_msg_data);
212: When OTHERS then
213: ROLLBACK TO Create_add_on_line_pub;
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 215: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_CREATE_KLE_PUB');

211: p_data => x_msg_data);
212: When OTHERS then
213: ROLLBACK TO Create_add_on_line_pub;
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
215: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_CREATE_KLE_PUB');
216: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
217: p_count => x_msg_count,
218: p_data => x_msg_data);
219: END create_add_on_line;

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

212: When OTHERS then
213: ROLLBACK TO Create_add_on_line_pub;
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
215: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_CREATE_KLE_PUB');
216: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
217: p_count => x_msg_count,
218: p_data => x_msg_data);
219: END create_add_on_line;
220: -------------------------------------------------------------------------------------------------------

Line 260: FND_MSG_PUB.initialize;

256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258: -- Initialize message list if p_init_msg_list is set to TRUE.
259: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
260: FND_MSG_PUB.initialize;
261: END IF;
262: l_klev_tbl := p_klev_tbl;
263: l_clev_tbl := p_clev_tbl;
264: l_cimv_tbl := p_cimv_tbl;

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

334: EXCEPTION
335: When FND_API.G_EXC_ERROR then
336: ROLLBACK TO Update_add_on_line_pub;
337: x_return_status := FND_API.G_RET_STS_ERROR;
338: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
339: p_data => x_msg_data);
340: When FND_API.G_EXC_UNEXPECTED_ERROR then
341: ROLLBACK TO Update_add_on_line_pub;
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

339: p_data => x_msg_data);
340: When FND_API.G_EXC_UNEXPECTED_ERROR then
341: ROLLBACK TO Update_add_on_line_pub;
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
344: p_data => x_msg_data);
345: When OTHERS then
346: ROLLBACK TO Update_add_on_line_pub;
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 348: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_CREATE_KLE_PUB');

344: p_data => x_msg_data);
345: When OTHERS then
346: ROLLBACK TO Update_add_on_line_pub;
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
348: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_CREATE_KLE_PUB');
349: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
350: p_count => x_msg_count,
351: p_data => x_msg_data);
352:

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

345: When OTHERS then
346: ROLLBACK TO Update_add_on_line_pub;
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
348: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_CREATE_KLE_PUB');
349: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
350: p_count => x_msg_count,
351: p_data => x_msg_data);
352:
353: END update_add_on_line;

Line 389: FND_MSG_PUB.initialize;

385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
386: END IF;
387: -- Initialize message list if p_init_msg_list is set to TRUE.
388: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
389: FND_MSG_PUB.initialize;
390: END IF;
391: l_klev_tbl := p_klev_tbl;
392: l_clev_tbl := p_clev_tbl;
393: g_klev_tbl := l_klev_tbl;

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

442: EXCEPTION
443: When FND_API.G_EXC_ERROR then
444: ROLLBACK TO delete_add_on_line_pub;
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
447: p_data => x_msg_data);
448: When FND_API.G_EXC_UNEXPECTED_ERROR then
449: ROLLBACK TO delete_add_on_line_pub;
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

447: p_data => x_msg_data);
448: When FND_API.G_EXC_UNEXPECTED_ERROR then
449: ROLLBACK TO delete_add_on_line_pub;
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
451: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
452: p_data => x_msg_data);
453: When OTHERS then
454: ROLLBACK TO delete_add_on_line_pub;
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 456: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_CREATE_KLE_PUB');

452: p_data => x_msg_data);
453: When OTHERS then
454: ROLLBACK TO delete_add_on_line_pub;
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
456: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_CREATE_KLE_PUB');
457: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
458: p_count => x_msg_count,
459: p_data => x_msg_data);
460:

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

453: When OTHERS then
454: ROLLBACK TO delete_add_on_line_pub;
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
456: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_CREATE_KLE_PUB');
457: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
458: p_count => x_msg_count,
459: p_data => x_msg_data);
460:
461: END delete_add_on_line;

Line 508: FND_MSG_PUB.initialize;

504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
505: END IF;
506: -- Initialize message list if p_init_msg_list is set to TRUE.
507: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
508: FND_MSG_PUB.initialize;
509: END IF;
510: l_clev_fin_rec := p_clev_fin_rec;
511: l_klev_fin_rec := p_klev_fin_rec;
512: l_cimv_model_rec := p_cimv_model_rec;

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

561: EXCEPTION
562: When FND_API.G_EXC_ERROR then
563: ROLLBACK TO Create_all_line_pub;
564: x_return_status := FND_API.G_RET_STS_ERROR;
565: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
566: p_data => x_msg_data);
567: When FND_API.G_EXC_UNEXPECTED_ERROR then
568: ROLLBACK TO Create_all_line_pub;
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

566: p_data => x_msg_data);
567: When FND_API.G_EXC_UNEXPECTED_ERROR then
568: ROLLBACK TO Create_all_line_pub;
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
571: p_data => x_msg_data);
572: When OTHERS then
573: ROLLBACK TO Create_all_line_pub;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 575: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_CREATE_KLE_PUB');

571: p_data => x_msg_data);
572: When OTHERS then
573: ROLLBACK TO Create_all_line_pub;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_CREATE_KLE_PUB');
576: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
577: p_count => x_msg_count,
578: p_data => x_msg_data);
579: END Create_all_line;

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

572: When OTHERS then
573: ROLLBACK TO Create_all_line_pub;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_CREATE_KLE_PUB');
576: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
577: p_count => x_msg_count,
578: p_data => x_msg_data);
579: END Create_all_line;
580: -----------------------------------------------------------------------------------------------

Line 628: FND_MSG_PUB.initialize;

624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
625: END IF;
626: -- Initialize message list if p_init_msg_list is set to TRUE.
627: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
628: FND_MSG_PUB.initialize;
629: END IF;
630: l_clev_fin_rec := p_clev_fin_rec;
631: l_klev_fin_rec := p_klev_fin_rec;
632: l_clev_model_rec := p_clev_model_rec;

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

689: EXCEPTION
690: When FND_API.G_EXC_ERROR then
691: ROLLBACK TO update_all_line_pub;
692: x_return_status := FND_API.G_RET_STS_ERROR;
693: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
694: p_data => x_msg_data);
695: When FND_API.G_EXC_UNEXPECTED_ERROR then
696: ROLLBACK TO update_all_line_pub;
697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

694: p_data => x_msg_data);
695: When FND_API.G_EXC_UNEXPECTED_ERROR then
696: ROLLBACK TO update_all_line_pub;
697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
698: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
699: p_data => x_msg_data);
700: When OTHERS then
701: ROLLBACK TO update_all_line_pub;
702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 703: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_update_KLE_PUB');

699: p_data => x_msg_data);
700: When OTHERS then
701: ROLLBACK TO update_all_line_pub;
702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
703: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_update_KLE_PUB');
704: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
705: p_count => x_msg_count,
706: p_data => x_msg_data);
707: END update_all_line;

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

700: When OTHERS then
701: ROLLBACK TO update_all_line_pub;
702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
703: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_update_KLE_PUB');
704: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
705: p_count => x_msg_count,
706: p_data => x_msg_data);
707: END update_all_line;
708: -----------------------------------------------------------------------------------------------

Line 754: FND_MSG_PUB.initialize;

750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
751: END IF;
752: -- Initialize message list if p_init_msg_list is set to TRUE.
753: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
754: FND_MSG_PUB.initialize;
755: END IF;
756: l_clev_ib_rec := p_clev_ib_rec;
757: l_itiv_ib_tbl := p_itiv_ib_tbl;
758:

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

805: EXCEPTION
806: When FND_API.G_EXC_ERROR then
807: ROLLBACK TO create_inst_ib_line_pub;
808: x_return_status := FND_API.G_RET_STS_ERROR;
809: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
810: p_data => x_msg_data);
811: When FND_API.G_EXC_UNEXPECTED_ERROR then
812: ROLLBACK TO create_inst_ib_line_pub;
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

810: p_data => x_msg_data);
811: When FND_API.G_EXC_UNEXPECTED_ERROR then
812: ROLLBACK TO create_inst_ib_line_pub;
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
814: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
815: p_data => x_msg_data);
816: When OTHERS then
817: ROLLBACK TO create_inst_ib_line_pub;
818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 819: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_update_KLE_PUB');

815: p_data => x_msg_data);
816: When OTHERS then
817: ROLLBACK TO create_inst_ib_line_pub;
818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
819: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_update_KLE_PUB');
820: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
821: p_count => x_msg_count,
822: p_data => x_msg_data);
823: END create_ints_ib_line;

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

816: When OTHERS then
817: ROLLBACK TO create_inst_ib_line_pub;
818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
819: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_update_KLE_PUB');
820: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
821: p_count => x_msg_count,
822: p_data => x_msg_data);
823: END create_ints_ib_line;
824:

Line 860: FND_MSG_PUB.initialize;

856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: END IF;
858: -- Initialize message list if p_init_msg_list is set to TRUE.
859: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
860: FND_MSG_PUB.initialize;
861: END IF;
862: l_itiv_ib_tbl := p_itiv_ib_tbl;
863: g_itiv_ib_tbl := l_itiv_ib_tbl;
864:

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

891: EXCEPTION
892: When FND_API.G_EXC_ERROR then
893: ROLLBACK TO update_ints_ib_line_pub;
894: x_return_status := FND_API.G_RET_STS_ERROR;
895: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
896: p_data => x_msg_data);
897: When FND_API.G_EXC_UNEXPECTED_ERROR then
898: ROLLBACK TO update_ints_ib_line_pub;
899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

896: p_data => x_msg_data);
897: When FND_API.G_EXC_UNEXPECTED_ERROR then
898: ROLLBACK TO update_ints_ib_line_pub;
899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
900: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
901: p_data => x_msg_data);
902: When OTHERS then
903: ROLLBACK TO update_ints_ib_line_pub;
904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 905: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_update_KLE_PUB');

901: p_data => x_msg_data);
902: When OTHERS then
903: ROLLBACK TO update_ints_ib_line_pub;
904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
905: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_update_KLE_PUB');
906: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
907: p_count => x_msg_count,
908: p_data => x_msg_data);
909: END update_ints_ib_line;

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

902: When OTHERS then
903: ROLLBACK TO update_ints_ib_line_pub;
904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
905: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_update_KLE_PUB');
906: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
907: p_count => x_msg_count,
908: p_data => x_msg_data);
909: END update_ints_ib_line;
910: -----------------------------------------------------------------------------------------------

Line 950: FND_MSG_PUB.initialize;

946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
947: END IF;
948: -- Initialize message list if p_init_msg_list is set to TRUE.
949: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
950: FND_MSG_PUB.initialize;
951: END IF;
952: l_clev_ib_tbl := p_clev_ib_tbl;
953: g_clev_ib_tbl := l_clev_ib_tbl;
954:

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

989: EXCEPTION
990: When FND_API.G_EXC_ERROR then
991: ROLLBACK TO delete_inst_ib_line_pub;
992: x_return_status := FND_API.G_RET_STS_ERROR;
993: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
994: p_data => x_msg_data);
995: When FND_API.G_EXC_UNEXPECTED_ERROR then
996: ROLLBACK TO delete_inst_ib_line_pub;
997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

994: p_data => x_msg_data);
995: When FND_API.G_EXC_UNEXPECTED_ERROR then
996: ROLLBACK TO delete_inst_ib_line_pub;
997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
998: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
999: p_data => x_msg_data);
1000: When OTHERS then
1001: ROLLBACK TO delete_inst_ib_line_pub;
1002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1003: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_update_KLE_PUB');

999: p_data => x_msg_data);
1000: When OTHERS then
1001: ROLLBACK TO delete_inst_ib_line_pub;
1002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1003: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_update_KLE_PUB');
1004: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1005: p_count => x_msg_count,
1006: p_data => x_msg_data);
1007: END delete_ints_ib_line;

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

1000: When OTHERS then
1001: ROLLBACK TO delete_inst_ib_line_pub;
1002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1003: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_update_KLE_PUB');
1004: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1005: p_count => x_msg_count,
1006: p_data => x_msg_data);
1007: END delete_ints_ib_line;
1008: -----------------------------------------------------------------------------------------------

Line 1035: FND_MSG_PUB.initialize;

1031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1032: END IF;
1033: -- Initialize message list if p_init_msg_list is set to TRUE.
1034: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
1035: FND_MSG_PUB.initialize;
1036: END IF;
1037: l_cplv_rec := p_cplv_rec;
1038: g_cplv_rec := l_cplv_rec;
1039: -- Customer pre processing section

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

1058: EXCEPTION
1059: When FND_API.G_EXC_ERROR then
1060: ROLLBACK TO Create_party_roles_pub;
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1063: p_data => x_msg_data);
1064: When FND_API.G_EXC_UNEXPECTED_ERROR then
1065: ROLLBACK TO Create_party_roles_pub;
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1063: p_data => x_msg_data);
1064: When FND_API.G_EXC_UNEXPECTED_ERROR then
1065: ROLLBACK TO Create_party_roles_pub;
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1067: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1068: p_data => x_msg_data);
1069: When OTHERS then
1070: ROLLBACK TO Create_party_roles_pub;
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1072: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_CREATE_KLE_PUB');

1068: p_data => x_msg_data);
1069: When OTHERS then
1070: ROLLBACK TO Create_party_roles_pub;
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1072: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_CREATE_KLE_PUB');
1073: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1074: p_count => x_msg_count,
1075: p_data => x_msg_data);
1076: END Create_party_roles_rec;

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

1069: When OTHERS then
1070: ROLLBACK TO Create_party_roles_pub;
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1072: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_CREATE_KLE_PUB');
1073: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1074: p_count => x_msg_count,
1075: p_data => x_msg_data);
1076: END Create_party_roles_rec;
1077: -----------------------------------------------------------------------------------------------

Line 1103: FND_MSG_PUB.initialize;

1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1100: END IF;
1101: -- Initialize message list if p_init_msg_list is set to TRUE.
1102: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
1103: FND_MSG_PUB.initialize;
1104: END IF;
1105: l_cplv_rec := p_cplv_rec;
1106: g_cplv_rec := l_cplv_rec;
1107: -- Customer pre processing section

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

1128: EXCEPTION
1129: When FND_API.G_EXC_ERROR then
1130: ROLLBACK TO Update_party_roles_pub;
1131: x_return_status := FND_API.G_RET_STS_ERROR;
1132: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1133: p_data => x_msg_data);
1134: When FND_API.G_EXC_UNEXPECTED_ERROR then
1135: ROLLBACK TO Update_party_roles_pub;
1136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1133: p_data => x_msg_data);
1134: When FND_API.G_EXC_UNEXPECTED_ERROR then
1135: ROLLBACK TO Update_party_roles_pub;
1136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1137: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1138: p_data => x_msg_data);
1139: When OTHERS then
1140: ROLLBACK TO Update_party_roles_pub;
1141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1142: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_CREATE_KLE_PUB');

1138: p_data => x_msg_data);
1139: When OTHERS then
1140: ROLLBACK TO Update_party_roles_pub;
1141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1142: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_CREATE_KLE_PUB');
1143: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1144: p_count => x_msg_count,
1145: p_data => x_msg_data);
1146: END update_party_roles_rec;

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

1139: When OTHERS then
1140: ROLLBACK TO Update_party_roles_pub;
1141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1142: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_CREATE_KLE_PUB');
1143: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1144: p_count => x_msg_count,
1145: p_data => x_msg_data);
1146: END update_party_roles_rec;
1147: -----------------------------------------------------------------------------------------------

Line 1180: FND_MSG_PUB.initialize;

1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END IF;
1178: -- Initialize message list if p_init_msg_list is set to TRUE.
1179: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
1180: FND_MSG_PUB.initialize;
1181: END IF;
1182: l_txdv_tbl := p_txdv_tbl;
1183: g_txdv_tbl := l_txdv_tbl;
1184: -- Customer pre processing section

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

1203: EXCEPTION
1204: When FND_API.G_EXC_ERROR then
1205: ROLLBACK TO Create_asset_line_details_pub;
1206: x_return_status := FND_API.G_RET_STS_ERROR;
1207: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1208: p_data => x_msg_data);
1209: When FND_API.G_EXC_UNEXPECTED_ERROR then
1210: ROLLBACK TO Create_asset_line_details_pub;
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1208: p_data => x_msg_data);
1209: When FND_API.G_EXC_UNEXPECTED_ERROR then
1210: ROLLBACK TO Create_asset_line_details_pub;
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1212: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1213: p_data => x_msg_data);
1214: When OTHERS then
1215: ROLLBACK TO Create_asset_line_details_pub;
1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1217: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'Create_asset_line_details_pub');

1213: p_data => x_msg_data);
1214: When OTHERS then
1215: ROLLBACK TO Create_asset_line_details_pub;
1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1217: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'Create_asset_line_details_pub');
1218: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1219: p_count => x_msg_count,
1220: p_data => x_msg_data);
1221: END Create_asset_line_details;

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

1214: When OTHERS then
1215: ROLLBACK TO Create_asset_line_details_pub;
1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1217: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'Create_asset_line_details_pub');
1218: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1219: p_count => x_msg_count,
1220: p_data => x_msg_data);
1221: END Create_asset_line_details;
1222:

Line 1256: FND_MSG_PUB.initialize;

1252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1253: END IF;
1254: -- Initialize message list if p_init_msg_list is set to TRUE.
1255: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
1256: FND_MSG_PUB.initialize;
1257: END IF;
1258: l_txdv_tbl := p_txdv_tbl;
1259: g_txdv_tbl := l_txdv_tbl;
1260: -- Customer pre processing section

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

1279: EXCEPTION
1280: When FND_API.G_EXC_ERROR then
1281: ROLLBACK TO update_asset_line_details_pub;
1282: x_return_status := FND_API.G_RET_STS_ERROR;
1283: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1284: p_data => x_msg_data);
1285: When FND_API.G_EXC_UNEXPECTED_ERROR then
1286: ROLLBACK TO update_asset_line_details_pub;
1287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1284: p_data => x_msg_data);
1285: When FND_API.G_EXC_UNEXPECTED_ERROR then
1286: ROLLBACK TO update_asset_line_details_pub;
1287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1288: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1289: p_data => x_msg_data);
1290: When OTHERS then
1291: ROLLBACK TO update_asset_line_details_pub;
1292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1293: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'update_asset_line_details_pub');

1289: p_data => x_msg_data);
1290: When OTHERS then
1291: ROLLBACK TO update_asset_line_details_pub;
1292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1293: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'update_asset_line_details_pub');
1294: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1295: p_count => x_msg_count,
1296: p_data => x_msg_data);
1297: END update_asset_line_details;

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

1290: When OTHERS then
1291: ROLLBACK TO update_asset_line_details_pub;
1292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1293: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'update_asset_line_details_pub');
1294: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1295: p_count => x_msg_count,
1296: p_data => x_msg_data);
1297: END update_asset_line_details;
1298: