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.EAM_COMMON_UTILITIES_PVT dependencies on FND_MSG_PUB

Line 86: fnd_msg_pub.initialize;

82:
83: l_stmt_num := 30;
84: -- Initialize message list if p_init_msg_list is set to TRUE.
85: IF fnd_api.to_boolean(p_init_msg_list) THEN
86: fnd_msg_pub.initialize;
87: END IF;
88:
89: l_stmt_num := 40;
90: -- Initialize API return status to success

Line 102: fnd_msg_pub.add;

98: IF (p_organization_id IS NULL) THEN
99:
100: fnd_message.set_name('EAM', 'EAM_INPUT_PARAMS_NULL');
101: fnd_message.set_token('EAM_DEBUG',l_full_name||'('||l_stmt_num||')');
102: fnd_msg_pub.add;
103: RAISE fnd_api.g_exc_error;
104: END IF;
105:
106: l_organization_id := p_organization_id;

Line 116: fnd_msg_pub.add;

112: IF (c_org_code%NOTFOUND) THEN
113:
114: fnd_message.set_name('EAM', 'EAM_ORG_CODE_NULL');
115: fnd_message.set_token('EAM_DEBUG',l_full_name||'('||l_stmt_num||')');
116: fnd_msg_pub.add;
117: RAISE fnd_api.g_exc_error;
118: END IF;
119: CLOSE c_org_code;
120:

Line 132: fnd_msg_pub.count_and_get(

128: END IF;
129:
130: l_stmt_num := 999;
131: -- Standard call to get message count and if count is 1, get message info.
132: fnd_msg_pub.count_and_get(
133: p_count => x_msg_count
134: ,p_data => x_msg_data);
135: EXCEPTION
136: WHEN fnd_api.g_exc_error THEN

Line 139: fnd_msg_pub.count_and_get(

135: EXCEPTION
136: WHEN fnd_api.g_exc_error THEN
137: ROLLBACK TO get_org_code_pvt;
138: x_return_status := fnd_api.g_ret_sts_error;
139: fnd_msg_pub.count_and_get(
140: p_count => x_msg_count
141: ,p_data => x_msg_data);
142: WHEN fnd_api.g_exc_unexpected_error THEN
143: ROLLBACK TO get_org_code_pvt;

Line 146: fnd_msg_pub.count_and_get(

142: WHEN fnd_api.g_exc_unexpected_error THEN
143: ROLLBACK TO get_org_code_pvt;
144: x_return_status := fnd_api.g_ret_sts_unexp_error;
145:
146: fnd_msg_pub.count_and_get(
147: p_count => x_msg_count
148: ,p_data => x_msg_data);
149: WHEN OTHERS THEN
150: ROLLBACK TO get_org_code_pvt;

Line 152: IF fnd_msg_pub.check_msg_level(

148: ,p_data => x_msg_data);
149: WHEN OTHERS THEN
150: ROLLBACK TO get_org_code_pvt;
151: x_return_status := fnd_api.g_ret_sts_unexp_error;
152: IF fnd_msg_pub.check_msg_level(
153: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
154: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
155: END IF;
156:

Line 153: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

149: WHEN OTHERS THEN
150: ROLLBACK TO get_org_code_pvt;
151: x_return_status := fnd_api.g_ret_sts_unexp_error;
152: IF fnd_msg_pub.check_msg_level(
153: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
154: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
155: END IF;
156:
157: fnd_msg_pub.count_and_get(

Line 154: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

150: ROLLBACK TO get_org_code_pvt;
151: x_return_status := fnd_api.g_ret_sts_unexp_error;
152: IF fnd_msg_pub.check_msg_level(
153: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
154: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
155: END IF;
156:
157: fnd_msg_pub.count_and_get(
158: p_count => x_msg_count

Line 157: fnd_msg_pub.count_and_get(

153: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
154: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
155: END IF;
156:
157: fnd_msg_pub.count_and_get(
158: p_count => x_msg_count
159: ,p_data => x_msg_data);
160: END get_org_code;
161:

Line 200: fnd_msg_pub.initialize;

196:
197: l_stmt_num := 30;
198: -- Initialize message list if p_init_msg_list is set to TRUE.
199: IF fnd_api.to_boolean(p_init_msg_list) THEN
200: fnd_msg_pub.initialize;
201: END IF;
202:
203: l_stmt_num := 40;
204: -- Initialize API return status to success

Line 218: fnd_msg_pub.add;

214: IF (p_organization_id IS NULL OR p_concatenated_segments IS NULL) THEN
215:
216: fnd_message.set_name('EAM', 'EAM_INPUT_PARAMS_NULL');
217: fnd_message.set_token('EAM_DEBUG',l_full_name||'('||l_stmt_num||')');
218: fnd_msg_pub.add;
219: RAISE fnd_api.g_exc_error;
220: END IF;
221:
222: l_organization_id := p_organization_id;

Line 246: fnd_msg_pub.count_and_get(

242: END IF;
243:
244: l_stmt_num := 999;
245: -- Standard call to get message count and if count is 1, get message info.
246: fnd_msg_pub.count_and_get(
247: p_count => x_msg_count
248: ,p_data => x_msg_data);
249: EXCEPTION
250: WHEN fnd_api.g_exc_error THEN

Line 253: fnd_msg_pub.count_and_get(

249: EXCEPTION
250: WHEN fnd_api.g_exc_error THEN
251: ROLLBACK TO get_org_code_pvt;
252: x_return_status := fnd_api.g_ret_sts_error;
253: fnd_msg_pub.count_and_get(
254: p_count => x_msg_count
255: ,p_data => x_msg_data);
256: WHEN fnd_api.g_exc_unexpected_error THEN
257: ROLLBACK TO get_org_code_pvt;

Line 259: fnd_msg_pub.count_and_get(

255: ,p_data => x_msg_data);
256: WHEN fnd_api.g_exc_unexpected_error THEN
257: ROLLBACK TO get_org_code_pvt;
258: x_return_status := fnd_api.g_ret_sts_unexp_error;
259: fnd_msg_pub.count_and_get(
260: p_count => x_msg_count
261: ,p_data => x_msg_data);
262: WHEN OTHERS THEN
263: ROLLBACK TO get_org_code_pvt;

Line 266: IF fnd_msg_pub.check_msg_level(

262: WHEN OTHERS THEN
263: ROLLBACK TO get_org_code_pvt;
264: x_return_status := fnd_api.g_ret_sts_unexp_error;
265:
266: IF fnd_msg_pub.check_msg_level(
267: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
268: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
269: END IF;
270:

Line 267: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

263: ROLLBACK TO get_org_code_pvt;
264: x_return_status := fnd_api.g_ret_sts_unexp_error;
265:
266: IF fnd_msg_pub.check_msg_level(
267: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
268: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
269: END IF;
270:
271: fnd_msg_pub.count_and_get(

Line 268: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

264: x_return_status := fnd_api.g_ret_sts_unexp_error;
265:
266: IF fnd_msg_pub.check_msg_level(
267: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
268: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
269: END IF;
270:
271: fnd_msg_pub.count_and_get(
272: p_count => x_msg_count

Line 271: fnd_msg_pub.count_and_get(

267: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
268: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
269: END IF;
270:
271: fnd_msg_pub.count_and_get(
272: p_count => x_msg_count
273: ,p_data => x_msg_data);
274: END get_item_id;
275:

Line 320: fnd_msg_pub.initialize;

316:
317: l_stmt_num := 30;
318: -- Initialize message list if p_init_msg_list is set to TRUE.
319: IF fnd_api.to_boolean(p_init_msg_list) THEN
320: fnd_msg_pub.initialize;
321: END IF;
322:
323: l_stmt_num := 40;
324: -- Initialize API return status to success

Line 337: fnd_msg_pub.add;

333: IF (p_organization_id IS NULL) THEN
334:
335: fnd_message.set_name('EAM', 'EAM_INPUT_PARAMS_NULL');
336: fnd_message.set_token('EAM_DEBUG',l_full_name||'('||l_stmt_num||')');
337: fnd_msg_pub.add;
338: RAISE fnd_api.g_exc_error;
339: END IF;
340:
341: l_organization_id := p_organization_id;

Line 366: fnd_msg_pub.count_and_get(

362: END IF;
363:
364: l_stmt_num := 999;
365: -- Standard call to get message count and if count is 1, get message info.
366: fnd_msg_pub.count_and_get(
367: p_count => x_msg_count
368: ,p_data => x_msg_data);
369: EXCEPTION
370: WHEN fnd_api.g_exc_error THEN

Line 373: fnd_msg_pub.count_and_get(

369: EXCEPTION
370: WHEN fnd_api.g_exc_error THEN
371: ROLLBACK TO get_current_period_pvt;
372: x_return_status := fnd_api.g_ret_sts_error;
373: fnd_msg_pub.count_and_get(
374: p_count => x_msg_count
375: ,p_data => x_msg_data);
376: WHEN fnd_api.g_exc_unexpected_error THEN
377: ROLLBACK TO get_current_period_pvt;

Line 379: fnd_msg_pub.count_and_get(

375: ,p_data => x_msg_data);
376: WHEN fnd_api.g_exc_unexpected_error THEN
377: ROLLBACK TO get_current_period_pvt;
378: x_return_status := fnd_api.g_ret_sts_unexp_error;
379: fnd_msg_pub.count_and_get(
380: p_count => x_msg_count
381: ,p_data => x_msg_data);
382: WHEN OTHERS THEN
383: ROLLBACK TO get_current_period_pvt;

Line 386: IF fnd_msg_pub.check_msg_level(

382: WHEN OTHERS THEN
383: ROLLBACK TO get_current_period_pvt;
384: x_return_status := fnd_api.g_ret_sts_unexp_error;
385:
386: IF fnd_msg_pub.check_msg_level(
387: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
388: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
389: END IF;
390:

Line 387: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

383: ROLLBACK TO get_current_period_pvt;
384: x_return_status := fnd_api.g_ret_sts_unexp_error;
385:
386: IF fnd_msg_pub.check_msg_level(
387: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
388: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
389: END IF;
390:
391: fnd_msg_pub.count_and_get(

Line 388: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

384: x_return_status := fnd_api.g_ret_sts_unexp_error;
385:
386: IF fnd_msg_pub.check_msg_level(
387: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
388: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
389: END IF;
390:
391: fnd_msg_pub.count_and_get(
392: p_count => x_msg_count

Line 391: fnd_msg_pub.count_and_get(

387: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
388: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
389: END IF;
390:
391: fnd_msg_pub.count_and_get(
392: p_count => x_msg_count
393: ,p_data => x_msg_data);
394: END get_current_period;
395:

Line 437: fnd_msg_pub.initialize;

433:
434: l_stmt_num := 30;
435: -- Initialize message list if p_init_msg_list is set to TRUE.
436: IF fnd_api.to_boolean(p_init_msg_list) THEN
437: fnd_msg_pub.initialize;
438: END IF;
439:
440: l_stmt_num := 40;
441: -- Initialize API return status to success

Line 454: fnd_msg_pub.add;

450: IF (p_organization_id IS NULL) THEN
451:
452: fnd_message.set_name('EAM', 'EAM_INPUT_PARAMS_NULL');
453: fnd_message.set_token('EAM_DEBUG',l_full_name||'('||l_stmt_num||')');
454: fnd_msg_pub.add;
455: RAISE fnd_api.g_exc_error;
456: END IF;
457:
458: l_organization_id := p_organization_id;

Line 475: fnd_msg_pub.count_and_get(

471: END IF;
472:
473: l_stmt_num := 999;
474: -- Standard call to get message count and if count is 1, get message info.
475: fnd_msg_pub.count_and_get(
476: p_count => x_msg_count
477: ,p_data => x_msg_data);
478: EXCEPTION
479: WHEN fnd_api.g_exc_error THEN

Line 482: fnd_msg_pub.count_and_get(

478: EXCEPTION
479: WHEN fnd_api.g_exc_error THEN
480: ROLLBACK TO get_currency_pvt;
481: x_return_status := fnd_api.g_ret_sts_error;
482: fnd_msg_pub.count_and_get(
483: p_count => x_msg_count
484: ,p_data => x_msg_data);
485: WHEN fnd_api.g_exc_unexpected_error THEN
486: ROLLBACK TO get_currency_pvt;

Line 488: fnd_msg_pub.count_and_get(

484: ,p_data => x_msg_data);
485: WHEN fnd_api.g_exc_unexpected_error THEN
486: ROLLBACK TO get_currency_pvt;
487: x_return_status := fnd_api.g_ret_sts_unexp_error;
488: fnd_msg_pub.count_and_get(
489: p_count => x_msg_count
490: ,p_data => x_msg_data);
491: WHEN OTHERS THEN
492: ROLLBACK TO get_currency_pvt;

Line 495: IF fnd_msg_pub.check_msg_level(

491: WHEN OTHERS THEN
492: ROLLBACK TO get_currency_pvt;
493: x_return_status := fnd_api.g_ret_sts_unexp_error;
494:
495: IF fnd_msg_pub.check_msg_level(
496: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
497: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
498: END IF;
499:

Line 496: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

492: ROLLBACK TO get_currency_pvt;
493: x_return_status := fnd_api.g_ret_sts_unexp_error;
494:
495: IF fnd_msg_pub.check_msg_level(
496: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
497: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
498: END IF;
499:
500: fnd_msg_pub.count_and_get(

Line 497: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

493: x_return_status := fnd_api.g_ret_sts_unexp_error;
494:
495: IF fnd_msg_pub.check_msg_level(
496: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
497: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
498: END IF;
499:
500: fnd_msg_pub.count_and_get(
501: p_count => x_msg_count

Line 500: fnd_msg_pub.count_and_get(

496: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
497: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
498: END IF;
499:
500: fnd_msg_pub.count_and_get(
501: p_count => x_msg_count
502: ,p_data => x_msg_data);
503: END get_currency;
504:

Line 555: fnd_msg_pub.initialize;

551:
552: l_stmt_num := 30;
553: -- Initialize message list if p_init_msg_list is set to TRUE.
554: IF fnd_api.to_boolean(p_init_msg_list) THEN
555: fnd_msg_pub.initialize;
556: END IF;
557:
558: l_stmt_num := 40;
559: -- Initialize API return status to success

Line 881: fnd_msg_pub.count_and_get(

877: END IF;
878:
879: l_stmt_num := 999;
880: -- Standard call to get message count and if count is 1, get message info.
881: fnd_msg_pub.count_and_get(
882: p_encoded => fnd_api.g_false
883: ,p_count => x_msg_count
884: ,p_data => x_msg_data);
885:

Line 891: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

887: WHEN fnd_api.g_exc_error THEN
888: ROLLBACK TO get_next_asset_number_pvt;
889: x_return_status := fnd_api.g_ret_sts_error;
890: x_asset_number := NULL;
891: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
892: fnd_msg_pub.count_and_get(
893: p_encoded => fnd_api.g_false
894: ,p_count => x_msg_count
895: ,p_data => x_msg_data);

Line 892: fnd_msg_pub.count_and_get(

888: ROLLBACK TO get_next_asset_number_pvt;
889: x_return_status := fnd_api.g_ret_sts_error;
890: x_asset_number := NULL;
891: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
892: fnd_msg_pub.count_and_get(
893: p_encoded => fnd_api.g_false
894: ,p_count => x_msg_count
895: ,p_data => x_msg_data);
896: WHEN fnd_api.g_exc_unexpected_error THEN

Line 900: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

896: WHEN fnd_api.g_exc_unexpected_error THEN
897: ROLLBACK TO get_next_asset_number_pvt;
898: x_return_status := fnd_api.g_ret_sts_unexp_error;
899: x_asset_number := NULL;
900: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
901: fnd_msg_pub.count_and_get(
902: p_encoded => fnd_api.g_false
903: ,p_count => x_msg_count
904: ,p_data => x_msg_data);

Line 901: fnd_msg_pub.count_and_get(

897: ROLLBACK TO get_next_asset_number_pvt;
898: x_return_status := fnd_api.g_ret_sts_unexp_error;
899: x_asset_number := NULL;
900: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
901: fnd_msg_pub.count_and_get(
902: p_encoded => fnd_api.g_false
903: ,p_count => x_msg_count
904: ,p_data => x_msg_data);
905: WHEN OTHERS THEN

Line 909: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

905: WHEN OTHERS THEN
906: ROLLBACK TO get_next_asset_number_pvt;
907: x_return_status := fnd_api.g_ret_sts_unexp_error;
908: x_asset_number := NULL;
909: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
910: IF fnd_msg_pub.check_msg_level(
911: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
912: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
913: END IF;

Line 910: IF fnd_msg_pub.check_msg_level(

906: ROLLBACK TO get_next_asset_number_pvt;
907: x_return_status := fnd_api.g_ret_sts_unexp_error;
908: x_asset_number := NULL;
909: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
910: IF fnd_msg_pub.check_msg_level(
911: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
912: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
913: END IF;
914:

Line 911: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

907: x_return_status := fnd_api.g_ret_sts_unexp_error;
908: x_asset_number := NULL;
909: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
910: IF fnd_msg_pub.check_msg_level(
911: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
912: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
913: END IF;
914:
915: fnd_msg_pub.count_and_get(

Line 912: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

908: x_asset_number := NULL;
909: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
910: IF fnd_msg_pub.check_msg_level(
911: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
912: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
913: END IF;
914:
915: fnd_msg_pub.count_and_get(
916: p_encoded => fnd_api.g_false

Line 915: fnd_msg_pub.count_and_get(

911: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
912: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
913: END IF;
914:
915: fnd_msg_pub.count_and_get(
916: p_encoded => fnd_api.g_false
917: ,p_count => x_msg_count
918: ,p_data => x_msg_data);
919:

Line 989: IF fnd_msg_pub.check_msg_level(

985: EXCEPTION
986: WHEN OTHERS THEN
987: rollback;
988: x_return_status := fnd_api.g_ret_sts_unexp_error;
989: IF fnd_msg_pub.check_msg_level(
990: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
991: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
992: END IF;
993:

Line 990: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

986: WHEN OTHERS THEN
987: rollback;
988: x_return_status := fnd_api.g_ret_sts_unexp_error;
989: IF fnd_msg_pub.check_msg_level(
990: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
991: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
992: END IF;
993:
994: fnd_msg_pub.count_and_get(

Line 991: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

987: rollback;
988: x_return_status := fnd_api.g_ret_sts_unexp_error;
989: IF fnd_msg_pub.check_msg_level(
990: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
991: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
992: END IF;
993:
994: fnd_msg_pub.count_and_get(
995: p_count => x_msg_count

Line 994: fnd_msg_pub.count_and_get(

990: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
991: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
992: END IF;
993:
994: fnd_msg_pub.count_and_get(
995: p_count => x_msg_count
996: ,p_data => x_msg_data);
997:
998: END verify_org;

Line 1605: fnd_msg_pub.initialize;

1601:
1602: l_stmt_num := 30;
1603: -- Initialize message list if p_init_msg_list is set to TRUE.
1604: IF fnd_api.to_boolean(p_init_msg_list) THEN
1605: fnd_msg_pub.initialize;
1606: END IF;
1607:
1608: l_stmt_num := 40;
1609: -- Initialize API return status to success

Line 2040: fnd_msg_pub.count_and_get(

2036: END IF;
2037:
2038: l_stmt_num := 999;
2039: -- Standard call to get message count and if count is 1, get message info.
2040: fnd_msg_pub.count_and_get(
2041: p_encoded => fnd_api.g_false
2042: ,p_count => x_msg_count
2043: ,p_data => x_msg_data);
2044:

Line 2049: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

2045: EXCEPTION
2046: WHEN fnd_api.g_exc_error THEN
2047: ROLLBACK TO get_work_order_count_pvt;
2048: x_return_status := fnd_api.g_ret_sts_error;
2049: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2050: fnd_msg_pub.count_and_get(
2051: p_encoded => fnd_api.g_false
2052: ,p_count => x_msg_count
2053: ,p_data => x_msg_data);

Line 2050: fnd_msg_pub.count_and_get(

2046: WHEN fnd_api.g_exc_error THEN
2047: ROLLBACK TO get_work_order_count_pvt;
2048: x_return_status := fnd_api.g_ret_sts_error;
2049: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2050: fnd_msg_pub.count_and_get(
2051: p_encoded => fnd_api.g_false
2052: ,p_count => x_msg_count
2053: ,p_data => x_msg_data);
2054: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2057: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

2053: ,p_data => x_msg_data);
2054: WHEN fnd_api.g_exc_unexpected_error THEN
2055: ROLLBACK TO get_work_order_count_pvt;
2056: x_return_status := fnd_api.g_ret_sts_unexp_error;
2057: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2058: fnd_msg_pub.count_and_get(
2059: p_encoded => fnd_api.g_false
2060: ,p_count => x_msg_count
2061: ,p_data => x_msg_data);

Line 2058: fnd_msg_pub.count_and_get(

2054: WHEN fnd_api.g_exc_unexpected_error THEN
2055: ROLLBACK TO get_work_order_count_pvt;
2056: x_return_status := fnd_api.g_ret_sts_unexp_error;
2057: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2058: fnd_msg_pub.count_and_get(
2059: p_encoded => fnd_api.g_false
2060: ,p_count => x_msg_count
2061: ,p_data => x_msg_data);
2062: WHEN OTHERS THEN

Line 2065: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

2061: ,p_data => x_msg_data);
2062: WHEN OTHERS THEN
2063: ROLLBACK TO get_work_order_count_pvt;
2064: x_return_status := fnd_api.g_ret_sts_unexp_error;
2065: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2066: IF fnd_msg_pub.check_msg_level(
2067: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2068: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2069: END IF;

Line 2066: IF fnd_msg_pub.check_msg_level(

2062: WHEN OTHERS THEN
2063: ROLLBACK TO get_work_order_count_pvt;
2064: x_return_status := fnd_api.g_ret_sts_unexp_error;
2065: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2066: IF fnd_msg_pub.check_msg_level(
2067: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2068: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2069: END IF;
2070:

Line 2067: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2063: ROLLBACK TO get_work_order_count_pvt;
2064: x_return_status := fnd_api.g_ret_sts_unexp_error;
2065: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2066: IF fnd_msg_pub.check_msg_level(
2067: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2068: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2069: END IF;
2070:
2071: fnd_msg_pub.count_and_get(

Line 2068: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

2064: x_return_status := fnd_api.g_ret_sts_unexp_error;
2065: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2066: IF fnd_msg_pub.check_msg_level(
2067: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2068: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2069: END IF;
2070:
2071: fnd_msg_pub.count_and_get(
2072: p_encoded => fnd_api.g_false

Line 2071: fnd_msg_pub.count_and_get(

2067: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2068: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2069: END IF;
2070:
2071: fnd_msg_pub.count_and_get(
2072: p_encoded => fnd_api.g_false
2073: ,p_count => x_msg_count
2074: ,p_data => x_msg_data);
2075:

Line 2173: fnd_msg_pub.initialize;

2169:
2170: l_stmt_num := 30;
2171: -- Initialize message list if p_init_msg_list is set to TRUE.
2172: IF fnd_api.to_boolean(p_init_msg_list) THEN
2173: fnd_msg_pub.initialize;
2174: END IF;
2175:
2176: l_stmt_num := 40;
2177: -- Initialize API return status to success

Line 2278: fnd_msg_pub.count_and_get(

2274: END IF;
2275:
2276: l_stmt_num := 999;
2277: -- Standard call to get message count and if count is 1, get message info.
2278: fnd_msg_pub.count_and_get(
2279: p_encoded => fnd_api.g_false
2280: ,p_count => x_msg_count
2281: ,p_data => x_msg_data);
2282:

Line 2287: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

2283: EXCEPTION
2284: WHEN fnd_api.g_exc_error THEN
2285: ROLLBACK TO insert_into_wori_pvt;
2286: x_return_status := fnd_api.g_ret_sts_error;
2287: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2288: fnd_msg_pub.count_and_get(
2289: p_encoded => fnd_api.g_false
2290: ,p_count => x_msg_count
2291: ,p_data => x_msg_data);

Line 2288: fnd_msg_pub.count_and_get(

2284: WHEN fnd_api.g_exc_error THEN
2285: ROLLBACK TO insert_into_wori_pvt;
2286: x_return_status := fnd_api.g_ret_sts_error;
2287: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2288: fnd_msg_pub.count_and_get(
2289: p_encoded => fnd_api.g_false
2290: ,p_count => x_msg_count
2291: ,p_data => x_msg_data);
2292: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2295: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

2291: ,p_data => x_msg_data);
2292: WHEN fnd_api.g_exc_unexpected_error THEN
2293: ROLLBACK TO insert_into_wori_pvt;
2294: x_return_status := fnd_api.g_ret_sts_unexp_error;
2295: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2296: fnd_msg_pub.count_and_get(
2297: p_encoded => fnd_api.g_false
2298: ,p_count => x_msg_count
2299: ,p_data => x_msg_data);

Line 2296: fnd_msg_pub.count_and_get(

2292: WHEN fnd_api.g_exc_unexpected_error THEN
2293: ROLLBACK TO insert_into_wori_pvt;
2294: x_return_status := fnd_api.g_ret_sts_unexp_error;
2295: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2296: fnd_msg_pub.count_and_get(
2297: p_encoded => fnd_api.g_false
2298: ,p_count => x_msg_count
2299: ,p_data => x_msg_data);
2300: WHEN OTHERS THEN

Line 2303: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

2299: ,p_data => x_msg_data);
2300: WHEN OTHERS THEN
2301: ROLLBACK TO insert_into_wori_pvt;
2302: x_return_status := fnd_api.g_ret_sts_unexp_error;
2303: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2304: IF fnd_msg_pub.check_msg_level(
2305: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2306: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2307: END IF;

Line 2304: IF fnd_msg_pub.check_msg_level(

2300: WHEN OTHERS THEN
2301: ROLLBACK TO insert_into_wori_pvt;
2302: x_return_status := fnd_api.g_ret_sts_unexp_error;
2303: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2304: IF fnd_msg_pub.check_msg_level(
2305: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2306: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2307: END IF;
2308:

Line 2305: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2301: ROLLBACK TO insert_into_wori_pvt;
2302: x_return_status := fnd_api.g_ret_sts_unexp_error;
2303: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2304: IF fnd_msg_pub.check_msg_level(
2305: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2306: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2307: END IF;
2308:
2309: fnd_msg_pub.count_and_get(

Line 2306: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

2302: x_return_status := fnd_api.g_ret_sts_unexp_error;
2303: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2304: IF fnd_msg_pub.check_msg_level(
2305: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2306: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2307: END IF;
2308:
2309: fnd_msg_pub.count_and_get(
2310: p_encoded => fnd_api.g_false

Line 2309: fnd_msg_pub.count_and_get(

2305: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2306: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2307: END IF;
2308:
2309: fnd_msg_pub.count_and_get(
2310: p_encoded => fnd_api.g_false
2311: ,p_count => x_msg_count
2312: ,p_data => x_msg_data);
2313:

Line 2419: fnd_msg_pub.initialize;

2415:
2416: l_stmt_num := 30;
2417: -- Initialize message list if p_init_msg_list is set to TRUE.
2418: IF fnd_api.to_boolean(p_init_msg_list) THEN
2419: fnd_msg_pub.initialize;
2420: END IF;
2421:
2422: l_stmt_num := 40;
2423: -- Initialize API return status to success

Line 2479: fnd_msg_pub.add;

2475: end;
2476:
2477: if (l_hr_exists = 'Y') then
2478: fnd_message.set_name('EAM','EAM_HIERARCHY_EXISTS');
2479: fnd_msg_pub.add;
2480: RAISE fnd_api.g_exc_error;
2481: end if;
2482:
2483: -- ROUTES CHECK

Line 2504: fnd_msg_pub.add;

2500:
2501:
2502: if (nvl(l_routes_exists,'N') = 'Y') then
2503: fnd_message.set_name('EAM','EAM_ROUTE_EXISTS');
2504: fnd_msg_pub.add;
2505: RAISE fnd_api.g_exc_error;
2506: end if;
2507:
2508: -- WORK REQUEST AND WORK ORDER CHECK

Line 2534: fnd_msg_pub.add;

2530: end;
2531:
2532: if (nvl(l_wo_exists,'N') = 'Y') then
2533: fnd_message.set_name('EAM','EAM_WO_EXISTS');
2534: fnd_msg_pub.add;
2535: RAISE fnd_api.g_exc_error;
2536: end if;
2537:
2538: -- check open Service Reqests

Line 2559: fnd_msg_pub.add;

2555: end;
2556:
2557: if (nvl(l_sr_exists,'N') = 'Y') then
2558: fnd_message.set_name('EAM','EAM_SR_EXISTS');
2559: fnd_msg_pub.add;
2560: RAISE fnd_api.g_exc_error;
2561: end if;
2562: eam_asset_number_pvt.update_asset(
2563: P_API_VERSION => 1.0

Line 2579: fnd_msg_pub.count_and_get(

2575: EXCEPTION
2576: WHEN fnd_api.g_exc_error THEN
2577: ROLLBACK TO asset_util_pvt;
2578: x_return_status := fnd_api.g_ret_sts_error;
2579: fnd_msg_pub.count_and_get(
2580: p_encoded => fnd_api.g_false
2581: ,p_count => x_msg_count
2582: ,p_data => x_msg_data);
2583: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2586: fnd_msg_pub.count_and_get(

2582: ,p_data => x_msg_data);
2583: WHEN fnd_api.g_exc_unexpected_error THEN
2584: ROLLBACK TO asset_util_pvt;
2585: x_return_status := fnd_api.g_ret_sts_unexp_error;
2586: fnd_msg_pub.count_and_get(
2587: p_encoded => fnd_api.g_false
2588: ,p_count => x_msg_count
2589: ,p_data => x_msg_data);
2590:

Line 2595: IF fnd_msg_pub.check_msg_level(

2591: WHEN OTHERS THEN
2592: ROLLBACK TO asset_util_pvt;
2593: x_return_status := fnd_api.g_ret_sts_unexp_error;
2594:
2595: IF fnd_msg_pub.check_msg_level(
2596: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2597: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
2598: END IF;
2599:

Line 2596: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2592: ROLLBACK TO asset_util_pvt;
2593: x_return_status := fnd_api.g_ret_sts_unexp_error;
2594:
2595: IF fnd_msg_pub.check_msg_level(
2596: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2597: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
2598: END IF;
2599:
2600: fnd_msg_pub.count_and_get(

Line 2597: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');

2593: x_return_status := fnd_api.g_ret_sts_unexp_error;
2594:
2595: IF fnd_msg_pub.check_msg_level(
2596: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2597: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
2598: END IF;
2599:
2600: fnd_msg_pub.count_and_get(
2601: p_encoded => fnd_api.g_false

Line 2600: fnd_msg_pub.count_and_get(

2596: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2597: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
2598: END IF;
2599:
2600: fnd_msg_pub.count_and_get(
2601: p_encoded => fnd_api.g_false
2602: ,p_count => x_msg_count
2603: ,p_data => x_msg_data);
2604:

Line 2635: FND_MSG_PUB.Count_And_Get('T', l_msg_count_1, l_msg_data_1);

2631: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, p_module,
2632: 'Last Message = ' || REPLACE(p_msg_data, CHR(0), ' ')); --null p_msg_data is OK
2633: end if;
2634: end if;
2635: FND_MSG_PUB.Count_And_Get('T', l_msg_count_1, l_msg_data_1);
2636: if ((l_msg_count_1 is not null) and (l_msg_count_1 > 0) and
2637: ((p_msg_count is null) or (l_msg_count_1 <> p_msg_count))) then
2638: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2639: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, p_module,

Line 2643: l_msg_data_1 := fnd_msg_pub.get(fnd_msg_pub.G_FIRST, FND_API.G_FALSE); --set encoded to true

2639: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, p_module,
2640: 'Message Count (from message Stack)= ' || l_msg_count_1);
2641: end if;
2642: end if;
2643: l_msg_data_1 := fnd_msg_pub.get(fnd_msg_pub.G_FIRST, FND_API.G_FALSE); --set encoded to true
2644: if (l_msg_count_1 is not null and l_msg_count_1 > 0) then
2645: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2646: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, p_module,
2647: 'Message #1 (from message stack) =' || l_msg_data_1);

Line 2650: l_msg_data_1 := fnd_msg_pub.get(fnd_msg_pub.G_NEXT, FND_API.G_FALSE); --set encoded to true

2646: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, p_module,
2647: 'Message #1 (from message stack) =' || l_msg_data_1);
2648: end if;
2649: for i in 2..l_msg_count_1 LOOP
2650: l_msg_data_1 := fnd_msg_pub.get(fnd_msg_pub.G_NEXT, FND_API.G_FALSE); --set encoded to true
2651: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2652: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, p_module,
2653: 'Message #' || to_char(i) || ' (from message stack) =' || l_msg_data_1);
2654: end if;

Line 2968: fnd_msg_pub.initialize;

2964: END IF;
2965:
2966: -- Initialize message list if p_init_msg_list is set to TRUE.
2967: IF fnd_api.to_boolean(p_init_msg_list) THEN
2968: fnd_msg_pub.initialize;
2969: END IF;
2970:
2971: -- Initialize API return status to success
2972: l_stmt_num := 10;

Line 2992: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

2988:
2989: EXCEPTION
2990:
2991: WHEN NO_DATA_FOUND THEN
2992: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2993: THEN
2994: FND_MSG_PUB.add_exc_msg
2995: ( 'EAM_COMMON_UTILITIES_PVT'
2996: , '.Create_Asset : Statement -'||to_char(l_stmt_num)

Line 2994: FND_MSG_PUB.add_exc_msg

2990:
2991: WHEN NO_DATA_FOUND THEN
2992: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2993: THEN
2994: FND_MSG_PUB.add_exc_msg
2995: ( 'EAM_COMMON_UTILITIES_PVT'
2996: , '.Create_Asset : Statement -'||to_char(l_stmt_num)
2997: );
2998: END IF;

Line 3052: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3048:
3049: EXCEPTION
3050:
3051: WHEN NO_DATA_FOUND THEN
3052: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3053: FND_MSG_PUB.add_exc_msg
3054: ( 'EAM_COMMON_UTILITIES_PVT'
3055: , '.Create_Asset : Statement -'||to_char(l_stmt_num)
3056: );

Line 3053: FND_MSG_PUB.add_exc_msg

3049: EXCEPTION
3050:
3051: WHEN NO_DATA_FOUND THEN
3052: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3053: FND_MSG_PUB.add_exc_msg
3054: ( 'EAM_COMMON_UTILITIES_PVT'
3055: , '.Create_Asset : Statement -'||to_char(l_stmt_num)
3056: );
3057: END IF;

Line 3080: fnd_msg_pub.count_and_get(

3076: COMMIT WORK;
3077: END IF;
3078:
3079: -- Standard call to get message count and if count is 1, get message info.
3080: fnd_msg_pub.count_and_get(
3081: p_count => x_msg_count
3082: ,p_data => x_msg_data);
3083:
3084:

Line 3089: fnd_msg_pub.count_and_get(

3085: EXCEPTION
3086: WHEN fnd_api.g_exc_error THEN
3087: ROLLBACK TO create_asset;
3088: x_return_status := fnd_api.g_ret_sts_error;
3089: fnd_msg_pub.count_and_get(
3090: p_count => x_msg_count
3091: ,p_data => x_msg_data);
3092: WHEN fnd_api.g_exc_unexpected_error THEN
3093: ROLLBACK TO create_asset;

Line 3095: fnd_msg_pub.count_and_get(

3091: ,p_data => x_msg_data);
3092: WHEN fnd_api.g_exc_unexpected_error THEN
3093: ROLLBACK TO create_asset;
3094: x_return_status := fnd_api.g_ret_sts_unexp_error;
3095: fnd_msg_pub.count_and_get(
3096: p_count => x_msg_count
3097: ,p_data => x_msg_data);
3098: WHEN OTHERS THEN
3099: ROLLBACK TO create_asset;

Line 3102: IF fnd_msg_pub.check_msg_level(

3098: WHEN OTHERS THEN
3099: ROLLBACK TO create_asset;
3100: x_return_status := fnd_api.g_ret_sts_unexp_error;
3101:
3102: IF fnd_msg_pub.check_msg_level(
3103: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3104: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
3105: END IF;
3106:

Line 3103: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3099: ROLLBACK TO create_asset;
3100: x_return_status := fnd_api.g_ret_sts_unexp_error;
3101:
3102: IF fnd_msg_pub.check_msg_level(
3103: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3104: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
3105: END IF;
3106:
3107: fnd_msg_pub.count_and_get(

Line 3104: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);

3100: x_return_status := fnd_api.g_ret_sts_unexp_error;
3101:
3102: IF fnd_msg_pub.check_msg_level(
3103: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3104: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
3105: END IF;
3106:
3107: fnd_msg_pub.count_and_get(
3108: p_count => x_msg_count

Line 3107: fnd_msg_pub.count_and_get(

3103: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3104: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
3105: END IF;
3106:
3107: fnd_msg_pub.count_and_get(
3108: p_count => x_msg_count
3109: ,p_data => x_msg_data);
3110:
3111: end create_asset;

Line 3196: fnd_msg_pub.add;

3192: end;
3193:
3194: if (l_hr_exists = 'Y') then
3195: fnd_message.set_name('EAM','EAM_HIERARCHY_EXISTS');
3196: fnd_msg_pub.add;
3197: l_result := false;
3198:
3199: end if;
3200: end if;

Line 3222: fnd_msg_pub.add;

3218:
3219:
3220: if (l_routes_exists = 'Y') then
3221: fnd_message.set_name('EAM','EAM_ROUTE_EXISTS');
3222: fnd_msg_pub.add;
3223: l_result := false;
3224: end if;
3225:
3226: -- Check for existing work orders only for serialized items. Bug 9836939.

Line 3253: fnd_msg_pub.add;

3249: end;
3250:
3251: if (l_wo_exists = 'Y') then
3252: fnd_message.set_name('EAM','EAM_WO_EXISTS');
3253: fnd_msg_pub.add;
3254: l_result := false;
3255: end if;
3256:
3257: END IF; -- End if block for serial number control check.

Line 3273: fnd_msg_pub.add;

3269: end;
3270:
3271: if (l_network_asset_flag = 'Y') then
3272: fnd_message.set_name('EAM','EAM_ROUTE_DEACTIVATE');
3273: fnd_msg_pub.add;
3274: l_result := false;
3275: end if;
3276:
3277: return l_result;

Line 3498: fnd_msg_pub.initialize;

3494: END IF;
3495:
3496: -- Initialize message list if p_init_msg_list is set to TRUE.
3497: IF fnd_api.to_boolean(p_init_msg_list) THEN
3498: fnd_msg_pub.initialize;
3499: END IF;
3500:
3501: -- Initialize API return status to success
3502: l_stmt_num := 10;

Line 3557: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

3553:
3554: EXCEPTION
3555:
3556: WHEN NO_DATA_FOUND THEN
3557: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3558: THEN
3559: FND_MSG_PUB.add_exc_msg
3560: ( 'EAM_COMMON_UTILITIES_PVT'
3561: , '.Adjust_WORU : Statement -'||to_char(l_stmt_num)

Line 3559: FND_MSG_PUB.add_exc_msg

3555:
3556: WHEN NO_DATA_FOUND THEN
3557: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3558: THEN
3559: FND_MSG_PUB.add_exc_msg
3560: ( 'EAM_COMMON_UTILITIES_PVT'
3561: , '.Adjust_WORU : Statement -'||to_char(l_stmt_num)
3562: );
3563: END IF;

Line 3702: fnd_msg_pub.count_and_get(

3698: COMMIT WORK;
3699: END IF;
3700:
3701: -- Standard call to get message count and if count is 1, get message info.
3702: fnd_msg_pub.count_and_get(
3703: p_count => x_msg_count
3704: ,p_data => x_msg_data);
3705:
3706:

Line 3711: fnd_msg_pub.count_and_get(

3707: EXCEPTION
3708: WHEN SHRINK_WITH_ASSIGNMENTS THEN
3709: rollback to adjust_woru;
3710: x_return_status := fnd_api.g_ret_sts_error;
3711: fnd_msg_pub.count_and_get(
3712: p_count => x_msg_count
3713: ,p_data => x_msg_data);
3714:
3715: WHEN fnd_api.g_exc_error THEN

Line 3718: fnd_msg_pub.count_and_get(

3714:
3715: WHEN fnd_api.g_exc_error THEN
3716: ROLLBACK TO adjust_woru;
3717: x_return_status := fnd_api.g_ret_sts_error;
3718: fnd_msg_pub.count_and_get(
3719: p_count => x_msg_count
3720: ,p_data => x_msg_data);
3721: WHEN fnd_api.g_exc_unexpected_error THEN
3722: ROLLBACK TO adjust_woru;

Line 3724: fnd_msg_pub.count_and_get(

3720: ,p_data => x_msg_data);
3721: WHEN fnd_api.g_exc_unexpected_error THEN
3722: ROLLBACK TO adjust_woru;
3723: x_return_status := fnd_api.g_ret_sts_unexp_error;
3724: fnd_msg_pub.count_and_get(
3725: p_count => x_msg_count
3726: ,p_data => x_msg_data);
3727: WHEN OTHERS THEN
3728: ROLLBACK TO adjust_woru;

Line 3731: IF fnd_msg_pub.check_msg_level(

3727: WHEN OTHERS THEN
3728: ROLLBACK TO adjust_woru;
3729: x_return_status := fnd_api.g_ret_sts_unexp_error;
3730:
3731: IF fnd_msg_pub.check_msg_level(
3732: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3733: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
3734: END IF;
3735:

Line 3732: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3728: ROLLBACK TO adjust_woru;
3729: x_return_status := fnd_api.g_ret_sts_unexp_error;
3730:
3731: IF fnd_msg_pub.check_msg_level(
3732: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3733: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
3734: END IF;
3735:
3736: fnd_msg_pub.count_and_get(

Line 3733: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);

3729: x_return_status := fnd_api.g_ret_sts_unexp_error;
3730:
3731: IF fnd_msg_pub.check_msg_level(
3732: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3733: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
3734: END IF;
3735:
3736: fnd_msg_pub.count_and_get(
3737: p_count => x_msg_count

Line 3736: fnd_msg_pub.count_and_get(

3732: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3733: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
3734: END IF;
3735:
3736: fnd_msg_pub.count_and_get(
3737: p_count => x_msg_count
3738: ,p_data => x_msg_data);
3739:
3740: end adjust_woru;