APPS.HZ_CONTACT_POINT_V2PUB dependencies on FND_MSG_PUB

Line 501: l_message_count := fnd_msg_pub.count_msg();

497: ELSE
498: l_country_code := NULL;
499: END IF;
500:
501: l_message_count := fnd_msg_pub.count_msg();
502:
503: -- Since phone_format cannot format raw_phone_number and phone_number
504: -- at same time, the input value of phone_number and phone_area_code
505: -- should be NULL or G_MISS before the call.

Line 535: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);

531: RAISE fnd_api.g_exc_unexpected_error;
532: END IF;
533: ELSE
534: FOR i IN 1..(l_msg_count - l_message_count) LOOP
535: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);
536: END LOOP;
537: x_return_status := fnd_api.g_ret_sts_success;
538: END IF;
539: END IF;

Line 688: l_message_count := fnd_msg_pub.count_msg();

684:
685: if l_phone_rec.phone_country_code IS NOT NULL AND
686: l_phone_rec.phone_country_code <> fnd_api.g_miss_char
687: then
688: l_message_count := fnd_msg_pub.count_msg();
689: hz_timezone_pub.get_phone_timezone_id(
690: p_api_version => 1.0,
691: p_init_msg_list => FND_API.G_FALSE,
692: p_phone_country_code => l_phone_rec.phone_country_code,

Line 704: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);

700: if l_return_status <> fnd_api.g_ret_sts_success
701: then -- we don't raise error
702: l_phone_rec.timezone_id := null;
703: FOR i IN 1..(l_msg_count - l_message_count) LOOP
704: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);
705: END LOOP;
706: l_return_status := FND_API.G_RET_STS_SUCCESS;
707: end if;
708: end if;

Line 1111: fnd_msg_pub.add;

1107: p_object_version_number = l_object_version_number))
1108: THEN
1109: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1110: fnd_message.set_token('TABLE', 'hz_contact_points');
1111: fnd_msg_pub.add;
1112: RAISE fnd_api.g_exc_error;
1113: END IF;
1114:
1115: p_object_version_number := NVL(l_object_version_number, 1) + 1;

Line 1123: fnd_msg_pub.add;

1119: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1120: fnd_message.set_token('RECORD', 'contact point');
1121: fnd_message.set_token('VALUE',
1122: NVL(TO_CHAR(p_contact_point_rec.contact_point_id), 'null'));
1123: fnd_msg_pub.add;
1124: RAISE fnd_api.g_exc_error;
1125: END;
1126:
1127: -- Debug info.

Line 1303: l_message_count := fnd_msg_pub.count_msg();

1299: -- Since phone_format cannot format raw_phone_number and phone_number
1300: -- at same time, the input value of phone_number and phone_area_code
1301: -- shoule be NULL or G_MISS before the call.
1302:
1303: l_message_count := fnd_msg_pub.count_msg();
1304:
1305: phone_format (
1306: p_raw_phone_number => l_phone_rec.raw_phone_number,
1307: p_territory_code => l_country_code,

Line 1342: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);

1338: RAISE fnd_api.g_exc_unexpected_error;
1339: END IF;
1340: ELSE
1341: FOR i IN 1..(l_msg_count - l_message_count) LOOP
1342: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);
1343: END LOOP;
1344: x_return_status := fnd_api.g_ret_sts_success;
1345: END IF;
1346: ELSE

Line 2446: fnd_msg_pub.initialize;

2442: END IF;
2443:
2444: -- Initialize message list if p_init_msg_list is set to TRUE.
2445: IF fnd_api.to_boolean(p_init_msg_list) THEN
2446: fnd_msg_pub.initialize;
2447: END IF;
2448:
2449: -- Initialize API return status to success.
2450: x_return_status := fnd_api.g_ret_sts_success;

Line 2457: fnd_msg_pub.add;

2453: IF p_contact_point_id IS NULL OR
2454: p_contact_point_id = fnd_api.g_miss_num THEN
2455: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
2456: fnd_message.set_token('COLUMN', 'contact_point_id');
2457: fnd_msg_pub.add;
2458: RAISE fnd_api.g_exc_error;
2459: END IF;
2460:
2461: x_contact_point_rec.contact_point_id := p_contact_point_id;

Line 2543: fnd_msg_pub.count_and_get(

2539: p_msg_level=>fnd_log.level_procedure);
2540: END IF;
2541:
2542: -- Standard call to get message count and if count is 1, get message info.
2543: fnd_msg_pub.count_and_get(
2544: p_encoded => fnd_api.g_false,
2545: p_count => x_msg_count,
2546: p_data => x_msg_data);
2547:

Line 2639: fnd_msg_pub.initialize;

2635: END IF;
2636:
2637: -- Initialize message list if p_init_msg_list is set to TRUE.
2638: IF fnd_api.to_boolean(p_init_msg_list) THEN
2639: fnd_msg_pub.initialize;
2640: END IF;
2641:
2642: -- Initialize API return status to success.
2643: x_return_status := fnd_api.g_ret_sts_success;

Line 2724: FND_MSG_PUB.ADD;

2720: ELSIF l_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' THEN
2721: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2722: hz_dss_util_pub.get_display_name(null, 'PARTY_SITE_CONTACT_POINTS'));
2723: END IF;
2724: FND_MSG_PUB.ADD;
2725: RAISE FND_API.G_EXC_ERROR;
2726: end if;
2727: END IF;
2728:

Line 2765: fnd_msg_pub.count_and_get(

2761: END IF;
2762: END IF;
2763:
2764: -- Standard call to get message count and if count is 1, get message info.
2765: fnd_msg_pub.count_and_get(
2766: p_encoded => fnd_api.g_false,
2767: p_count => x_msg_count,
2768: p_data => x_msg_data);
2769:

Line 2879: fnd_msg_pub.initialize;

2875: END IF;
2876:
2877: -- Initialize message list if p_init_msg_list is set to TRUE.
2878: IF fnd_api.to_boolean(p_init_msg_list) THEN
2879: fnd_msg_pub.initialize;
2880: END IF;
2881:
2882: -- Initialize API return status to success.
2883: x_return_status := fnd_api.g_ret_sts_success;

Line 2958: FND_MSG_PUB.ADD;

2954: ELSIF l_old_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' THEN
2955: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2956: hz_dss_util_pub.get_display_name(null, 'PARTY_SITE_CONTACT_POINTS'));
2957: END IF;
2958: FND_MSG_PUB.ADD;
2959: RAISE FND_API.G_EXC_ERROR;
2960: end if;
2961: END IF;
2962:

Line 3014: l_message_count := fnd_msg_pub.count_msg();

3010: l_phone_area_code := l_old_phone_rec.phone_area_code;
3011: else
3012: l_phone_area_code := l_phone_rec.phone_area_code;
3013: end if;
3014: l_message_count := fnd_msg_pub.count_msg();
3015: hz_timezone_pub.get_phone_timezone_id(
3016: p_api_version => 1.0,
3017: p_init_msg_list => FND_API.G_FALSE,
3018: p_phone_country_code => l_phone_country_code,

Line 3030: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);

3026: if l_return_status <> fnd_api.g_ret_sts_success
3027: then -- we don't raise error
3028: l_phone_rec.timezone_id := fnd_api.g_miss_num;
3029: FOR i IN 1..(l_msg_count - l_message_count) LOOP
3030: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);
3031: END LOOP;
3032: l_return_status := FND_API.G_RET_STS_SUCCESS;
3033: end if;
3034: end if;

Line 3096: fnd_msg_pub.count_and_get(

3092:
3093: END IF;
3094:
3095: -- Standard call to get message count and if count is 1, get message info.
3096: fnd_msg_pub.count_and_get(
3097: p_encoded => fnd_api.g_false,
3098: p_count => x_msg_count,
3099: p_data => x_msg_data);
3100:

Line 3219: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3215: WHEN fnd_api.g_exc_error THEN
3216: ROLLBACK TO create_contact_point;
3217: x_return_status := fnd_api.g_ret_sts_error;
3218:
3219: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3220: p_count => x_msg_count,
3221: p_data => x_msg_data);
3222:
3223: -- Debug info.

Line 3244: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3240: WHEN fnd_api.g_exc_unexpected_error THEN
3241: ROLLBACK TO create_contact_point;
3242: x_return_status := fnd_api.g_ret_sts_unexp_error;
3243:
3244: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3245: p_count => x_msg_count,
3246: p_data => x_msg_data);
3247:
3248: -- Debug info.

Line 3270: fnd_msg_pub.add;

3266: x_return_status := fnd_api.g_ret_sts_unexp_error;
3267:
3268: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3269: fnd_message.set_token('ERROR' ,SQLERRM);
3270: fnd_msg_pub.add;
3271:
3272: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3273: p_count => x_msg_count,
3274: p_data => x_msg_data);

Line 3272: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3268: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3269: fnd_message.set_token('ERROR' ,SQLERRM);
3270: fnd_msg_pub.add;
3271:
3272: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3273: p_count => x_msg_count,
3274: p_data => x_msg_data);
3275:
3276: -- Debug info.

Line 3386: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3382: WHEN fnd_api.g_exc_error THEN
3383: ROLLBACK TO create_edi_contact_point;
3384: x_return_status := fnd_api.g_ret_sts_error;
3385:
3386: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3387: p_count => x_msg_count,
3388: p_data => x_msg_data);
3389:
3390: -- Debug info.

Line 3410: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3406: WHEN fnd_api.g_exc_unexpected_error THEN
3407: ROLLBACK TO create_edi_contact_point;
3408: x_return_status := fnd_api.g_ret_sts_unexp_error;
3409:
3410: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3411: p_count => x_msg_count,
3412: p_data => x_msg_data);
3413:
3414: -- Debug info.

Line 3436: fnd_msg_pub.add;

3432: x_return_status := fnd_api.g_ret_sts_unexp_error;
3433:
3434: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3435: fnd_message.set_token('ERROR' ,SQLERRM);
3436: fnd_msg_pub.add;
3437:
3438: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3439: p_count => x_msg_count,
3440: p_data => x_msg_data);

Line 3438: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3434: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3435: fnd_message.set_token('ERROR' ,SQLERRM);
3436: fnd_msg_pub.add;
3437:
3438: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3439: p_count => x_msg_count,
3440: p_data => x_msg_data);
3441:
3442: -- Debug info.

Line 3552: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3548: WHEN fnd_api.g_exc_error THEN
3549: ROLLBACK TO create_web_contact_point;
3550: x_return_status := fnd_api.g_ret_sts_error;
3551:
3552: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3553: p_count => x_msg_count,
3554: p_data => x_msg_data);
3555:
3556: -- Debug info.

Line 3576: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3572: WHEN fnd_api.g_exc_unexpected_error THEN
3573: ROLLBACK TO create_web_contact_point;
3574: x_return_status := fnd_api.g_ret_sts_unexp_error;
3575:
3576: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3577: p_count => x_msg_count,
3578: p_data => x_msg_data);
3579:
3580: -- Debug info.

Line 3602: fnd_msg_pub.add;

3598: x_return_status := fnd_api.g_ret_sts_unexp_error;
3599:
3600: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3601: fnd_message.set_token('ERROR' ,SQLERRM);
3602: fnd_msg_pub.add;
3603:
3604: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3605: p_count => x_msg_count,
3606: p_data => x_msg_data);

Line 3604: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3600: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3601: fnd_message.set_token('ERROR' ,SQLERRM);
3602: fnd_msg_pub.add;
3603:
3604: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3605: p_count => x_msg_count,
3606: p_data => x_msg_data);
3607:
3608: -- Debug info.

Line 3721: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3717: WHEN fnd_api.g_exc_error THEN
3718: ROLLBACK TO create_eft_contact_point;
3719: x_return_status := fnd_api.g_ret_sts_error;
3720:
3721: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3722: p_count => x_msg_count,
3723: p_data => x_msg_data);
3724:
3725: -- Debug info.

Line 3745: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3741: WHEN fnd_api.g_exc_unexpected_error THEN
3742: ROLLBACK TO create_eft_contact_point;
3743: x_return_status := fnd_api.g_ret_sts_unexp_error;
3744:
3745: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3746: p_count => x_msg_count,
3747: p_data => x_msg_data);
3748:
3749: -- Debug info.

Line 3771: fnd_msg_pub.add;

3767: x_return_status := fnd_api.g_ret_sts_unexp_error;
3768:
3769: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3770: fnd_message.set_token('ERROR' ,SQLERRM);
3771: fnd_msg_pub.add;
3772:
3773: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3774: p_count => x_msg_count,
3775: p_data => x_msg_data);

Line 3773: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3769: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3770: fnd_message.set_token('ERROR' ,SQLERRM);
3771: fnd_msg_pub.add;
3772:
3773: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3774: p_count => x_msg_count,
3775: p_data => x_msg_data);
3776:
3777: -- Debug info.

Line 3888: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3884: WHEN fnd_api.g_exc_error THEN
3885: ROLLBACK TO create_phone_contact_point;
3886: x_return_status := fnd_api.g_ret_sts_error;
3887:
3888: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3889: p_count => x_msg_count,
3890: p_data => x_msg_data);
3891:
3892: -- Debug info.

Line 3912: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3908: WHEN fnd_api.g_exc_unexpected_error THEN
3909: ROLLBACK TO create_phone_contact_point;
3910: x_return_status := fnd_api.g_ret_sts_unexp_error;
3911:
3912: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3913: p_count => x_msg_count,
3914: p_data => x_msg_data);
3915:
3916: -- Debug info.

Line 3938: fnd_msg_pub.add;

3934: x_return_status := fnd_api.g_ret_sts_unexp_error;
3935:
3936: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3937: fnd_message.set_token('ERROR' ,SQLERRM);
3938: fnd_msg_pub.add;
3939:
3940: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3941: p_count => x_msg_count,
3942: p_data => x_msg_data);

Line 3940: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3936: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3937: fnd_message.set_token('ERROR' ,SQLERRM);
3938: fnd_msg_pub.add;
3939:
3940: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3941: p_count => x_msg_count,
3942: p_data => x_msg_data);
3943:
3944: -- Debug info.

Line 4055: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4051: WHEN fnd_api.g_exc_error THEN
4052: ROLLBACK TO create_telex_contact_point;
4053: x_return_status := fnd_api.g_ret_sts_error;
4054:
4055: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4056: p_count => x_msg_count,
4057: p_data => x_msg_data);
4058:
4059: -- Debug info.

Line 4079: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4075: WHEN fnd_api.g_exc_unexpected_error THEN
4076: ROLLBACK TO create_telex_contact_point;
4077: x_return_status := fnd_api.g_ret_sts_unexp_error;
4078:
4079: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4080: p_count => x_msg_count,
4081: p_data => x_msg_data);
4082:
4083: -- Debug info.

Line 4105: fnd_msg_pub.add;

4101: x_return_status := fnd_api.g_ret_sts_unexp_error;
4102:
4103: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4104: fnd_message.set_token('ERROR' ,SQLERRM);
4105: fnd_msg_pub.add;
4106:
4107: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4108: p_count => x_msg_count,
4109: p_data => x_msg_data);

Line 4107: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4103: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4104: fnd_message.set_token('ERROR' ,SQLERRM);
4105: fnd_msg_pub.add;
4106:
4107: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4108: p_count => x_msg_count,
4109: p_data => x_msg_data);
4110:
4111: -- Debug info.

Line 4222: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4218: WHEN fnd_api.g_exc_error THEN
4219: ROLLBACK TO create_email_contact_point;
4220: x_return_status := fnd_api.g_ret_sts_error;
4221:
4222: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4223: p_count => x_msg_count,
4224: p_data => x_msg_data);
4225:
4226: -- Debug info.

Line 4246: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4242: WHEN fnd_api.g_exc_unexpected_error THEN
4243: ROLLBACK TO create_email_contact_point;
4244: x_return_status := fnd_api.g_ret_sts_unexp_error;
4245:
4246: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4247: p_count => x_msg_count,
4248: p_data => x_msg_data);
4249:
4250: -- Debug info.

Line 4272: fnd_msg_pub.add;

4268: x_return_status := fnd_api.g_ret_sts_unexp_error;
4269:
4270: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4271: fnd_message.set_token('ERROR' ,SQLERRM);
4272: fnd_msg_pub.add;
4273:
4274: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4275: p_count => x_msg_count,
4276: p_data => x_msg_data);

Line 4274: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4270: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4271: fnd_message.set_token('ERROR' ,SQLERRM);
4272: fnd_msg_pub.add;
4273:
4274: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4275: p_count => x_msg_count,
4276: p_data => x_msg_data);
4277:
4278: -- Debug info.

Line 4404: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4400: ROLLBACK TO update_contact_point;
4401: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4402: x_return_status := fnd_api.g_ret_sts_error;
4403:
4404: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4405: p_count => x_msg_count,
4406: p_data => x_msg_data);
4407:
4408: -- Debug info.

Line 4429: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4425: ROLLBACK TO update_contact_point;
4426: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4427: x_return_status := fnd_api.g_ret_sts_unexp_error;
4428:
4429: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4430: p_count => x_msg_count,
4431: p_data => x_msg_data);
4432:
4433: -- Debug info.

Line 4456: fnd_msg_pub.add;

4452: x_return_status := fnd_api.g_ret_sts_unexp_error;
4453:
4454: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4455: fnd_message.set_token('ERROR' ,SQLERRM);
4456: fnd_msg_pub.add;
4457:
4458: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4459: p_count => x_msg_count,
4460: p_data => x_msg_data);

Line 4458: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4454: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4455: fnd_message.set_token('ERROR' ,SQLERRM);
4456: fnd_msg_pub.add;
4457:
4458: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4459: p_count => x_msg_count,
4460: p_data => x_msg_data);
4461:
4462: -- Debug info.

Line 4571: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4567: WHEN fnd_api.g_exc_error THEN
4568: ROLLBACK TO update_edi_contact_point;
4569: x_return_status := fnd_api.g_ret_sts_error;
4570:
4571: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4572: p_count => x_msg_count,
4573: p_data => x_msg_data);
4574:
4575: -- Debug info.

Line 4595: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4591: WHEN fnd_api.g_exc_unexpected_error THEN
4592: ROLLBACK TO update_edi_contact_point;
4593: x_return_status := fnd_api.g_ret_sts_unexp_error;
4594:
4595: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4596: p_count => x_msg_count,
4597: p_data => x_msg_data);
4598:
4599: -- Debug info.

Line 4621: fnd_msg_pub.add;

4617: x_return_status := fnd_api.g_ret_sts_unexp_error;
4618:
4619: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4620: fnd_message.set_token('ERROR' ,SQLERRM);
4621: fnd_msg_pub.add;
4622:
4623: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4624: p_count => x_msg_count,
4625: p_data => x_msg_data);

Line 4623: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4619: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4620: fnd_message.set_token('ERROR' ,SQLERRM);
4621: fnd_msg_pub.add;
4622:
4623: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4624: p_count => x_msg_count,
4625: p_data => x_msg_data);
4626:
4627: -- Debug info.

Line 4738: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4734: ROLLBACK TO update_web_contact_point;
4735: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4736: x_return_status := fnd_api.g_ret_sts_error;
4737:
4738: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4739: p_count => x_msg_count,
4740: p_data => x_msg_data);
4741:
4742: -- Debug info.

Line 4763: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4759: ROLLBACK TO update_web_contact_point;
4760: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4761: x_return_status := fnd_api.g_ret_sts_unexp_error;
4762:
4763: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4764: p_count => x_msg_count,
4765: p_data => x_msg_data);
4766:
4767: -- Debug info.

Line 4791: fnd_msg_pub.add;

4787: x_return_status := fnd_api.g_ret_sts_unexp_error;
4788:
4789: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4790: fnd_message.set_token('ERROR' ,SQLERRM);
4791: fnd_msg_pub.add;
4792:
4793: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4794: p_count => x_msg_count,
4795: p_data => x_msg_data);

Line 4793: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4789: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4790: fnd_message.set_token('ERROR' ,SQLERRM);
4791: fnd_msg_pub.add;
4792:
4793: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4794: p_count => x_msg_count,
4795: p_data => x_msg_data);
4796:
4797: -- Debug info.

Line 4909: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4905: WHEN fnd_api.g_exc_error THEN
4906: ROLLBACK TO update_eft_contact_point;
4907: x_return_status := fnd_api.g_ret_sts_error;
4908:
4909: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4910: p_count => x_msg_count,
4911: p_data => x_msg_data);
4912:
4913: -- Debug info.

Line 4933: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4929: WHEN fnd_api.g_exc_unexpected_error THEN
4930: ROLLBACK TO update_eft_contact_point;
4931: x_return_status := fnd_api.g_ret_sts_unexp_error;
4932:
4933: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4934: p_count => x_msg_count,
4935: p_data => x_msg_data);
4936:
4937: -- Debug info.

Line 4959: fnd_msg_pub.add;

4955: x_return_status := fnd_api.g_ret_sts_unexp_error;
4956:
4957: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4958: fnd_message.set_token('ERROR' ,SQLERRM);
4959: fnd_msg_pub.add;
4960:
4961: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4962: p_count => x_msg_count,
4963: p_data => x_msg_data);

Line 4961: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4957: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4958: fnd_message.set_token('ERROR' ,SQLERRM);
4959: fnd_msg_pub.add;
4960:
4961: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4962: p_count => x_msg_count,
4963: p_data => x_msg_data);
4964:
4965: -- Debug info.

Line 5077: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

5073: ROLLBACK TO update_phone_contact_point;
5074: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5075: x_return_status := fnd_api.g_ret_sts_error;
5076:
5077: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5078: p_count => x_msg_count,
5079: p_data => x_msg_data);
5080:
5081: -- Debug info.

Line 5102: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

5098: ROLLBACK TO update_phone_contact_point;
5099: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5100: x_return_status := fnd_api.g_ret_sts_unexp_error;
5101:
5102: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5103: p_count => x_msg_count,
5104: p_data => x_msg_data);
5105:
5106: -- Debug info.

Line 5129: fnd_msg_pub.add;

5125: x_return_status := fnd_api.g_ret_sts_unexp_error;
5126:
5127: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5128: fnd_message.set_token('ERROR' ,SQLERRM);
5129: fnd_msg_pub.add;
5130:
5131: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5132: p_count => x_msg_count,
5133: p_data => x_msg_data);

Line 5131: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

5127: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5128: fnd_message.set_token('ERROR' ,SQLERRM);
5129: fnd_msg_pub.add;
5130:
5131: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5132: p_count => x_msg_count,
5133: p_data => x_msg_data);
5134:
5135: -- Debug info.

Line 5247: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

5243: ROLLBACK TO update_telex_contact_point;
5244: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5245: x_return_status := fnd_api.g_ret_sts_error;
5246:
5247: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5248: p_count => x_msg_count,
5249: p_data => x_msg_data);
5250:
5251: -- Debug info.

Line 5274: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

5270: ROLLBACK TO update_telex_contact_point;
5271: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5272: x_return_status := fnd_api.g_ret_sts_unexp_error;
5273:
5274: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5275: p_count => x_msg_count,
5276: p_data => x_msg_data);
5277:
5278: -- Debug info.

Line 5301: fnd_msg_pub.add;

5297: x_return_status := fnd_api.g_ret_sts_unexp_error;
5298:
5299: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5300: fnd_message.set_token('ERROR' ,SQLERRM);
5301: fnd_msg_pub.add;
5302:
5303: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5304: p_count => x_msg_count,
5305: p_data => x_msg_data);

Line 5303: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

5299: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5300: fnd_message.set_token('ERROR' ,SQLERRM);
5301: fnd_msg_pub.add;
5302:
5303: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5304: p_count => x_msg_count,
5305: p_data => x_msg_data);
5306:
5307: -- Debug info.

Line 5418: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

5414: ROLLBACK TO update_email_contact_point;
5415: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5416: x_return_status := fnd_api.g_ret_sts_error;
5417:
5418: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5419: p_count => x_msg_count,
5420: p_data => x_msg_data);
5421:
5422: -- Debug info.

Line 5443: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

5439: ROLLBACK TO update_email_contact_point;
5440: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5441: x_return_status := fnd_api.g_ret_sts_unexp_error;
5442:
5443: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5444: p_count => x_msg_count,
5445: p_data => x_msg_data);
5446:
5447: -- Debug info.

Line 5470: fnd_msg_pub.add;

5466: x_return_status := fnd_api.g_ret_sts_unexp_error;
5467:
5468: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5469: fnd_message.set_token('ERROR' ,SQLERRM);
5470: fnd_msg_pub.add;
5471:
5472: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5473: p_count => x_msg_count,
5474: p_data => x_msg_data);

Line 5472: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

5468: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5469: fnd_message.set_token('ERROR' ,SQLERRM);
5470: fnd_msg_pub.add;
5471:
5472: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5473: p_count => x_msg_count,
5474: p_data => x_msg_data);
5475:
5476: -- Debug info.

Line 5577: fnd_msg_pub.initialize;

5573: END IF;
5574:
5575: -- Initialize message list if p_init_msg_list is set to TRUE.
5576: IF fnd_api.to_boolean(p_init_msg_list) THEN
5577: fnd_msg_pub.initialize;
5578: END IF;
5579:
5580: -- Initialize API return status to success.
5581: x_return_status := fnd_api.g_ret_sts_success;

Line 5604: fnd_msg_pub.add;

5600: IF (l_format_raw_phone AND l_format_area_phone) OR
5601: (NOT l_format_raw_phone AND NOT l_format_area_phone)
5602: THEN
5603: fnd_message.set_name('AR', 'HZ_INVALID_PHONE_PARAMETER');
5604: fnd_msg_pub.add;
5605: RAISE fnd_api.g_exc_error;
5606: END IF;
5607:
5608: -- If not format a raw phone number, then create a raw phone

Line 5675: | fnd_msg_pub.add;

5671:
5672: /* -- Cannot get territory code, error out NOCOPY
5673: | IF l_territory_code IS NULL THEN
5674: | fnd_message.set_name('AR', 'HZ_COUNTRY_CODE_NOT_DEFINED');
5675: | fnd_msg_pub.add;
5676: | RAISE fnd_api.g_exc_error;
5677: | END IF;
5678: |
5679: | -- Call subroutine to get the format style to be applied for the given

Line 5694: | fnd_msg_pub.add;

5690: |
5691: | -- Check for errors in identifying format style
5692: | IF l_msg_name IS NOT NULL THEN
5693: | fnd_message.set_name('AR', l_msg_name);
5694: | fnd_msg_pub.add;
5695: | RAISE fnd_api.g_exc_error;
5696: | END IF;
5697: |
5698: | -- Apply the format style and get translated number

Line 5724: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

5720: |
5721: | x_phone_country_code := l_phone_country_code; */
5722:
5723: -- Standard call to get message count and if count is 1, get message info.
5724: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5725: p_count => x_msg_count,
5726: p_data => x_msg_data);
5727:
5728: -- Debug info.

Line 5748: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

5744: EXCEPTION
5745: WHEN fnd_api.g_exc_error THEN
5746: x_return_status := fnd_api.g_ret_sts_error;
5747:
5748: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5749: p_count => x_msg_count,
5750: p_data => x_msg_data);
5751:
5752: -- Debug info.

Line 5771: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

5767:
5768: WHEN fnd_api.g_exc_unexpected_error THEN
5769: x_return_status := fnd_api.g_ret_sts_unexp_error;
5770:
5771: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5772: p_count => x_msg_count,
5773: p_data => x_msg_data);
5774:
5775: -- Debug info.

Line 5796: fnd_msg_pub.add;

5792: x_return_status := fnd_api.g_ret_sts_unexp_error;
5793:
5794: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5795: fnd_message.set_token('ERROR' ,SQLERRM);
5796: fnd_msg_pub.add;
5797:
5798: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5799: p_count => x_msg_count,
5800: p_data => x_msg_data);

Line 5798: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

5794: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5795: fnd_message.set_token('ERROR' ,SQLERRM);
5796: fnd_msg_pub.add;
5797:
5798: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5799: p_count => x_msg_count,
5800: p_data => x_msg_data);
5801:
5802: -- Debug info.

Line 5920: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

5916: EXCEPTION
5917: WHEN fnd_api.g_exc_error THEN
5918: x_return_status := fnd_api.g_ret_sts_error;
5919:
5920: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5921: p_count => x_msg_count,
5922: p_data => x_msg_data);
5923:
5924: -- Debug info.

Line 5943: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

5939:
5940: WHEN fnd_api.g_exc_unexpected_error THEN
5941: x_return_status := fnd_api.g_ret_sts_unexp_error;
5942:
5943: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5944: p_count => x_msg_count,
5945: p_data => x_msg_data);
5946:
5947: -- Debug info.

Line 5968: fnd_msg_pub.add;

5964: x_return_status := fnd_api.g_ret_sts_unexp_error;
5965:
5966: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5967: fnd_message.set_token('ERROR' ,SQLERRM);
5968: fnd_msg_pub.add;
5969:
5970: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5971: p_count => x_msg_count,
5972: p_data => x_msg_data);

Line 5970: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

5966: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5967: fnd_message.set_token('ERROR' ,SQLERRM);
5968: fnd_msg_pub.add;
5969:
5970: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5971: p_count => x_msg_count,
5972: p_data => x_msg_data);
5973:
5974: -- Debug info.

Line 6086: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

6082: EXCEPTION
6083: WHEN fnd_api.g_exc_error THEN
6084: x_return_status := fnd_api.g_ret_sts_error;
6085:
6086: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6087: p_count => x_msg_count,
6088: p_data => x_msg_data);
6089:
6090: -- Debug info.

Line 6109: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

6105:
6106: WHEN fnd_api.g_exc_unexpected_error THEN
6107: x_return_status := fnd_api.g_ret_sts_unexp_error;
6108:
6109: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6110: p_count => x_msg_count,
6111: p_data => x_msg_data);
6112:
6113: -- Debug info.

Line 6134: fnd_msg_pub.add;

6130: x_return_status := fnd_api.g_ret_sts_unexp_error;
6131:
6132: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6133: fnd_message.set_token('ERROR' ,SQLERRM);
6134: fnd_msg_pub.add;
6135:
6136: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6137: p_count => x_msg_count,
6138: p_data => x_msg_data);

Line 6136: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

6132: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6133: fnd_message.set_token('ERROR' ,SQLERRM);
6134: fnd_msg_pub.add;
6135:
6136: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6137: p_count => x_msg_count,
6138: p_data => x_msg_data);
6139:
6140: -- Debug info.

Line 6253: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

6249: EXCEPTION
6250: WHEN fnd_api.g_exc_error THEN
6251: x_return_status := fnd_api.g_ret_sts_error;
6252:
6253: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6254: p_count => x_msg_count,
6255: p_data => x_msg_data);
6256:
6257: -- Debug info.

Line 6276: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

6272:
6273: WHEN fnd_api.g_exc_unexpected_error THEN
6274: x_return_status := fnd_api.g_ret_sts_unexp_error;
6275:
6276: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6277: p_count => x_msg_count,
6278: p_data => x_msg_data);
6279:
6280: -- Debug info.

Line 6301: fnd_msg_pub.add;

6297: x_return_status := fnd_api.g_ret_sts_unexp_error;
6298:
6299: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6300: fnd_message.set_token('ERROR' ,SQLERRM);
6301: fnd_msg_pub.add;
6302:
6303: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6304: p_count => x_msg_count,
6305: p_data => x_msg_data);

Line 6303: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

6299: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6300: fnd_message.set_token('ERROR' ,SQLERRM);
6301: fnd_msg_pub.add;
6302:
6303: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6304: p_count => x_msg_count,
6305: p_data => x_msg_data);
6306:
6307: -- Debug info.

Line 6420: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

6416: EXCEPTION
6417: WHEN fnd_api.g_exc_error THEN
6418: x_return_status := fnd_api.g_ret_sts_error;
6419:
6420: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6421: p_count => x_msg_count,
6422: p_data => x_msg_data);
6423:
6424: -- Debug info.

Line 6443: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

6439:
6440: WHEN fnd_api.g_exc_unexpected_error THEN
6441: x_return_status := fnd_api.g_ret_sts_unexp_error;
6442:
6443: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6444: p_count => x_msg_count,
6445: p_data => x_msg_data);
6446:
6447: -- Debug info.

Line 6469: fnd_msg_pub.add;

6465: x_return_status := fnd_api.g_ret_sts_unexp_error;
6466:
6467: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6468: fnd_message.set_token('ERROR' ,SQLERRM);
6469: fnd_msg_pub.add;
6470:
6471: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6472: p_count => x_msg_count,
6473: p_data => x_msg_data);

Line 6471: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

6467: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6468: fnd_message.set_token('ERROR' ,SQLERRM);
6469: fnd_msg_pub.add;
6470:
6471: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6472: p_count => x_msg_count,
6473: p_data => x_msg_data);
6474:
6475: -- Debug info.

Line 6587: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

6583: EXCEPTION
6584: WHEN fnd_api.g_exc_error THEN
6585: x_return_status := fnd_api.g_ret_sts_error;
6586:
6587: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6588: p_count => x_msg_count,
6589: p_data => x_msg_data);
6590:
6591: -- Debug info.

Line 6610: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

6606:
6607: WHEN fnd_api.g_exc_unexpected_error THEN
6608: x_return_status := fnd_api.g_ret_sts_unexp_error;
6609:
6610: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6611: p_count => x_msg_count,
6612: p_data => x_msg_data);
6613:
6614: -- Debug info.

Line 6635: fnd_msg_pub.add;

6631: x_return_status := fnd_api.g_ret_sts_unexp_error;
6632:
6633: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6634: fnd_message.set_token('ERROR' ,SQLERRM);
6635: fnd_msg_pub.add;
6636:
6637: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6638: p_count => x_msg_count,
6639: p_data => x_msg_data);

Line 6637: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

6633: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6634: fnd_message.set_token('ERROR' ,SQLERRM);
6635: fnd_msg_pub.add;
6636:
6637: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6638: p_count => x_msg_count,
6639: p_data => x_msg_data);
6640:
6641: -- Debug info.

Line 6753: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

6749: EXCEPTION
6750: WHEN fnd_api.g_exc_error THEN
6751: x_return_status := fnd_api.g_ret_sts_error;
6752:
6753: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6754: p_count => x_msg_count,
6755: p_data => x_msg_data);
6756:
6757: -- Debug info.

Line 6776: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

6772:
6773: WHEN fnd_api.g_exc_unexpected_error THEN
6774: x_return_status := fnd_api.g_ret_sts_unexp_error;
6775:
6776: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6777: p_count => x_msg_count,
6778: p_data => x_msg_data);
6779:
6780: -- Debug info.

Line 6801: fnd_msg_pub.add;

6797: x_return_status := fnd_api.g_ret_sts_unexp_error;
6798:
6799: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6800: fnd_message.set_token('ERROR' ,SQLERRM);
6801: fnd_msg_pub.add;
6802:
6803: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6804: p_count => x_msg_count,
6805: p_data => x_msg_data);

Line 6803: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

6799: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6800: fnd_message.set_token('ERROR' ,SQLERRM);
6801: fnd_msg_pub.add;
6802:
6803: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6804: p_count => x_msg_count,
6805: p_data => x_msg_data);
6806:
6807: -- Debug info.

Line 6920: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

6916: EXCEPTION
6917: WHEN fnd_api.g_exc_error THEN
6918: x_return_status := fnd_api.g_ret_sts_error;
6919:
6920: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6921: p_count => x_msg_count,
6922: p_data => x_msg_data);
6923:
6924: -- Debug info.

Line 6943: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

6939:
6940: WHEN fnd_api.g_exc_unexpected_error THEN
6941: x_return_status := fnd_api.g_ret_sts_unexp_error;
6942:
6943: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6944: p_count => x_msg_count,
6945: p_data => x_msg_data);
6946:
6947: -- Debug info.

Line 6968: fnd_msg_pub.add;

6964: x_return_status := fnd_api.g_ret_sts_unexp_error;
6965:
6966: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6967: fnd_message.set_token('ERROR' ,SQLERRM);
6968: fnd_msg_pub.add;
6969:
6970: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6971: p_count => x_msg_count,
6972: p_data => x_msg_data);

Line 6970: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

6966: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6967: fnd_message.set_token('ERROR' ,SQLERRM);
6968: fnd_msg_pub.add;
6969:
6970: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6971: p_count => x_msg_count,
6972: p_data => x_msg_data);
6973:
6974: -- Debug info.