APPS.HZ_CONTACT_POINT_V2PUB dependencies on FND_MSG_PUB

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

507: ELSE
508: l_country_code := NULL;
509: END IF;
510:
511: l_message_count := fnd_msg_pub.count_msg();
512:
513: -- Since phone_format cannot format raw_phone_number and phone_number
514: -- at same time, the input value of phone_number and phone_area_code
515: -- should be NULL or G_MISS before the call.

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

541: RAISE fnd_api.g_exc_unexpected_error;
542: END IF;
543: ELSE
544: FOR i IN 1..(l_msg_count - l_message_count) LOOP
545: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);
546: END LOOP;
547: x_return_status := fnd_api.g_ret_sts_success;
548: END IF;
549: END IF;

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

694:
695: if l_phone_rec.phone_country_code IS NOT NULL AND
696: l_phone_rec.phone_country_code <> fnd_api.g_miss_char
697: then
698: l_message_count := fnd_msg_pub.count_msg();
699: hz_timezone_pub.get_phone_timezone_id(
700: p_api_version => 1.0,
701: p_init_msg_list => FND_API.G_FALSE,
702: p_phone_country_code => l_phone_rec.phone_country_code,

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

710: if l_return_status <> fnd_api.g_ret_sts_success
711: then -- we don't raise error
712: l_phone_rec.timezone_id := null;
713: FOR i IN 1..(l_msg_count - l_message_count) LOOP
714: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);
715: END LOOP;
716: l_return_status := FND_API.G_RET_STS_SUCCESS;
717: end if;
718: end if;

Line 1124: fnd_msg_pub.add;

1120: p_object_version_number = l_object_version_number))
1121: THEN
1122: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1123: fnd_message.set_token('TABLE', 'hz_contact_points');
1124: fnd_msg_pub.add;
1125: RAISE fnd_api.g_exc_error;
1126: END IF;
1127:
1128: p_object_version_number := NVL(l_object_version_number, 1) + 1;

Line 1136: fnd_msg_pub.add;

1132: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1133: fnd_message.set_token('RECORD', 'contact point');
1134: fnd_message.set_token('VALUE',
1135: NVL(TO_CHAR(p_contact_point_rec.contact_point_id), 'null'));
1136: fnd_msg_pub.add;
1137: RAISE fnd_api.g_exc_error;
1138: END;
1139:
1140: -- Debug info.

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

1312: -- Since phone_format cannot format raw_phone_number and phone_number
1313: -- at same time, the input value of phone_number and phone_area_code
1314: -- shoule be NULL or G_MISS before the call.
1315:
1316: l_message_count := fnd_msg_pub.count_msg();
1317:
1318: phone_format (
1319: p_raw_phone_number => l_phone_rec.raw_phone_number,
1320: p_territory_code => l_country_code,

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

1351: RAISE fnd_api.g_exc_unexpected_error;
1352: END IF;
1353: ELSE
1354: FOR i IN 1..(l_msg_count - l_message_count) LOOP
1355: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);
1356: END LOOP;
1357: x_return_status := fnd_api.g_ret_sts_success;
1358: END IF;
1359: ELSE

Line 2599: fnd_msg_pub.initialize;

2595: END IF;
2596:
2597: -- Initialize message list if p_init_msg_list is set to TRUE.
2598: IF fnd_api.to_boolean(p_init_msg_list) THEN
2599: fnd_msg_pub.initialize;
2600: END IF;
2601:
2602: -- Initialize API return status to success.
2603: x_return_status := fnd_api.g_ret_sts_success;

Line 2610: fnd_msg_pub.add;

2606: IF p_contact_point_id IS NULL OR
2607: p_contact_point_id = fnd_api.g_miss_num THEN
2608: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
2609: fnd_message.set_token('COLUMN', 'contact_point_id');
2610: fnd_msg_pub.add;
2611: RAISE fnd_api.g_exc_error;
2612: END IF;
2613:
2614: x_contact_point_rec.contact_point_id := p_contact_point_id;

Line 2696: fnd_msg_pub.count_and_get(

2692: p_msg_level=>fnd_log.level_procedure);
2693: END IF;
2694:
2695: -- Standard call to get message count and if count is 1, get message info.
2696: fnd_msg_pub.count_and_get(
2697: p_encoded => fnd_api.g_false,
2698: p_count => x_msg_count,
2699: p_data => x_msg_data);
2700:

Line 2792: fnd_msg_pub.initialize;

2788: END IF;
2789:
2790: -- Initialize message list if p_init_msg_list is set to TRUE.
2791: IF fnd_api.to_boolean(p_init_msg_list) THEN
2792: fnd_msg_pub.initialize;
2793: END IF;
2794:
2795: -- Initialize API return status to success.
2796: x_return_status := fnd_api.g_ret_sts_success;

Line 2877: FND_MSG_PUB.ADD;

2873: ELSIF l_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' THEN
2874: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2875: hz_dss_util_pub.get_display_name(null, 'PARTY_SITE_CONTACT_POINTS'));
2876: END IF;
2877: FND_MSG_PUB.ADD;
2878: RAISE FND_API.G_EXC_ERROR;
2879: end if;
2880: END IF;
2881:

Line 2921: fnd_msg_pub.count_and_get(

2917: */
2918: END IF;
2919:
2920: -- Standard call to get message count and if count is 1, get message info.
2921: fnd_msg_pub.count_and_get(
2922: p_encoded => fnd_api.g_false,
2923: p_count => x_msg_count,
2924: p_data => x_msg_data);
2925:

Line 3035: fnd_msg_pub.initialize;

3031: END IF;
3032:
3033: -- Initialize message list if p_init_msg_list is set to TRUE.
3034: IF fnd_api.to_boolean(p_init_msg_list) THEN
3035: fnd_msg_pub.initialize;
3036: END IF;
3037:
3038: -- Initialize API return status to success.
3039: x_return_status := fnd_api.g_ret_sts_success;

Line 3114: FND_MSG_PUB.ADD;

3110: ELSIF l_old_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' THEN
3111: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
3112: hz_dss_util_pub.get_display_name(null, 'PARTY_SITE_CONTACT_POINTS'));
3113: END IF;
3114: FND_MSG_PUB.ADD;
3115: RAISE FND_API.G_EXC_ERROR;
3116: end if;
3117: END IF;
3118:

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

3166: l_phone_area_code := l_old_phone_rec.phone_area_code;
3167: else
3168: l_phone_area_code := l_phone_rec.phone_area_code;
3169: end if;
3170: l_message_count := fnd_msg_pub.count_msg();
3171: hz_timezone_pub.get_phone_timezone_id(
3172: p_api_version => 1.0,
3173: p_init_msg_list => FND_API.G_FALSE,
3174: p_phone_country_code => l_phone_country_code,

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

3182: if l_return_status <> fnd_api.g_ret_sts_success
3183: then -- we don't raise error
3184: l_phone_rec.timezone_id := fnd_api.g_miss_num;
3185: FOR i IN 1..(l_msg_count - l_message_count) LOOP
3186: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);
3187: END LOOP;
3188: l_return_status := FND_API.G_RET_STS_SUCCESS;
3189: end if;
3190: end if;

Line 3252: fnd_msg_pub.count_and_get(

3248:
3249: END IF;
3250:
3251: -- Standard call to get message count and if count is 1, get message info.
3252: fnd_msg_pub.count_and_get(
3253: p_encoded => fnd_api.g_false,
3254: p_count => x_msg_count,
3255: p_data => x_msg_data);
3256:

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

3371: WHEN fnd_api.g_exc_error THEN
3372: ROLLBACK TO create_contact_point;
3373: x_return_status := fnd_api.g_ret_sts_error;
3374:
3375: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3376: p_count => x_msg_count,
3377: p_data => x_msg_data);
3378:
3379: -- Debug info.

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

3396: WHEN fnd_api.g_exc_unexpected_error THEN
3397: ROLLBACK TO create_contact_point;
3398: x_return_status := fnd_api.g_ret_sts_unexp_error;
3399:
3400: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3401: p_count => x_msg_count,
3402: p_data => x_msg_data);
3403:
3404: -- Debug info.

Line 3426: fnd_msg_pub.add;

3422: x_return_status := fnd_api.g_ret_sts_unexp_error;
3423:
3424: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3425: fnd_message.set_token('ERROR' ,SQLERRM);
3426: fnd_msg_pub.add;
3427:
3428: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3429: p_count => x_msg_count,
3430: p_data => x_msg_data);

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

3424: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3425: fnd_message.set_token('ERROR' ,SQLERRM);
3426: fnd_msg_pub.add;
3427:
3428: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3429: p_count => x_msg_count,
3430: p_data => x_msg_data);
3431:
3432: -- Debug info.

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

3538: WHEN fnd_api.g_exc_error THEN
3539: ROLLBACK TO create_edi_contact_point;
3540: x_return_status := fnd_api.g_ret_sts_error;
3541:
3542: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3543: p_count => x_msg_count,
3544: p_data => x_msg_data);
3545:
3546: -- Debug info.

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

3562: WHEN fnd_api.g_exc_unexpected_error THEN
3563: ROLLBACK TO create_edi_contact_point;
3564: x_return_status := fnd_api.g_ret_sts_unexp_error;
3565:
3566: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3567: p_count => x_msg_count,
3568: p_data => x_msg_data);
3569:
3570: -- Debug info.

Line 3592: fnd_msg_pub.add;

3588: x_return_status := fnd_api.g_ret_sts_unexp_error;
3589:
3590: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3591: fnd_message.set_token('ERROR' ,SQLERRM);
3592: fnd_msg_pub.add;
3593:
3594: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3595: p_count => x_msg_count,
3596: p_data => x_msg_data);

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

3590: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3591: fnd_message.set_token('ERROR' ,SQLERRM);
3592: fnd_msg_pub.add;
3593:
3594: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3595: p_count => x_msg_count,
3596: p_data => x_msg_data);
3597:
3598: -- Debug info.

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

3704: WHEN fnd_api.g_exc_error THEN
3705: ROLLBACK TO create_web_contact_point;
3706: x_return_status := fnd_api.g_ret_sts_error;
3707:
3708: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3709: p_count => x_msg_count,
3710: p_data => x_msg_data);
3711:
3712: -- Debug info.

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

3728: WHEN fnd_api.g_exc_unexpected_error THEN
3729: ROLLBACK TO create_web_contact_point;
3730: x_return_status := fnd_api.g_ret_sts_unexp_error;
3731:
3732: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3733: p_count => x_msg_count,
3734: p_data => x_msg_data);
3735:
3736: -- Debug info.

Line 3758: fnd_msg_pub.add;

3754: x_return_status := fnd_api.g_ret_sts_unexp_error;
3755:
3756: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3757: fnd_message.set_token('ERROR' ,SQLERRM);
3758: fnd_msg_pub.add;
3759:
3760: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3761: p_count => x_msg_count,
3762: p_data => x_msg_data);

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

3756: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3757: fnd_message.set_token('ERROR' ,SQLERRM);
3758: fnd_msg_pub.add;
3759:
3760: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3761: p_count => x_msg_count,
3762: p_data => x_msg_data);
3763:
3764: -- Debug info.

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

3873: WHEN fnd_api.g_exc_error THEN
3874: ROLLBACK TO create_eft_contact_point;
3875: x_return_status := fnd_api.g_ret_sts_error;
3876:
3877: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3878: p_count => x_msg_count,
3879: p_data => x_msg_data);
3880:
3881: -- Debug info.

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

3897: WHEN fnd_api.g_exc_unexpected_error THEN
3898: ROLLBACK TO create_eft_contact_point;
3899: x_return_status := fnd_api.g_ret_sts_unexp_error;
3900:
3901: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3902: p_count => x_msg_count,
3903: p_data => x_msg_data);
3904:
3905: -- Debug info.

Line 3927: fnd_msg_pub.add;

3923: x_return_status := fnd_api.g_ret_sts_unexp_error;
3924:
3925: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3926: fnd_message.set_token('ERROR' ,SQLERRM);
3927: fnd_msg_pub.add;
3928:
3929: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3930: p_count => x_msg_count,
3931: p_data => x_msg_data);

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

3925: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3926: fnd_message.set_token('ERROR' ,SQLERRM);
3927: fnd_msg_pub.add;
3928:
3929: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3930: p_count => x_msg_count,
3931: p_data => x_msg_data);
3932:
3933: -- Debug info.

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

4040: WHEN fnd_api.g_exc_error THEN
4041: ROLLBACK TO create_phone_contact_point;
4042: x_return_status := fnd_api.g_ret_sts_error;
4043:
4044: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4045: p_count => x_msg_count,
4046: p_data => x_msg_data);
4047:
4048: -- Debug info.

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

4064: WHEN fnd_api.g_exc_unexpected_error THEN
4065: ROLLBACK TO create_phone_contact_point;
4066: x_return_status := fnd_api.g_ret_sts_unexp_error;
4067:
4068: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4069: p_count => x_msg_count,
4070: p_data => x_msg_data);
4071:
4072: -- Debug info.

Line 4094: fnd_msg_pub.add;

4090: x_return_status := fnd_api.g_ret_sts_unexp_error;
4091:
4092: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4093: fnd_message.set_token('ERROR' ,SQLERRM);
4094: fnd_msg_pub.add;
4095:
4096: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4097: p_count => x_msg_count,
4098: p_data => x_msg_data);

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

4092: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4093: fnd_message.set_token('ERROR' ,SQLERRM);
4094: fnd_msg_pub.add;
4095:
4096: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4097: p_count => x_msg_count,
4098: p_data => x_msg_data);
4099:
4100: -- Debug info.

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

4207: WHEN fnd_api.g_exc_error THEN
4208: ROLLBACK TO create_telex_contact_point;
4209: x_return_status := fnd_api.g_ret_sts_error;
4210:
4211: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4212: p_count => x_msg_count,
4213: p_data => x_msg_data);
4214:
4215: -- Debug info.

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

4231: WHEN fnd_api.g_exc_unexpected_error THEN
4232: ROLLBACK TO create_telex_contact_point;
4233: x_return_status := fnd_api.g_ret_sts_unexp_error;
4234:
4235: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4236: p_count => x_msg_count,
4237: p_data => x_msg_data);
4238:
4239: -- Debug info.

Line 4261: fnd_msg_pub.add;

4257: x_return_status := fnd_api.g_ret_sts_unexp_error;
4258:
4259: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4260: fnd_message.set_token('ERROR' ,SQLERRM);
4261: fnd_msg_pub.add;
4262:
4263: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4264: p_count => x_msg_count,
4265: p_data => x_msg_data);

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

4259: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4260: fnd_message.set_token('ERROR' ,SQLERRM);
4261: fnd_msg_pub.add;
4262:
4263: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4264: p_count => x_msg_count,
4265: p_data => x_msg_data);
4266:
4267: -- Debug info.

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

4374: WHEN fnd_api.g_exc_error THEN
4375: ROLLBACK TO create_email_contact_point;
4376: x_return_status := fnd_api.g_ret_sts_error;
4377:
4378: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4379: p_count => x_msg_count,
4380: p_data => x_msg_data);
4381:
4382: -- Debug info.

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

4398: WHEN fnd_api.g_exc_unexpected_error THEN
4399: ROLLBACK TO create_email_contact_point;
4400: x_return_status := fnd_api.g_ret_sts_unexp_error;
4401:
4402: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4403: p_count => x_msg_count,
4404: p_data => x_msg_data);
4405:
4406: -- Debug info.

Line 4428: fnd_msg_pub.add;

4424: x_return_status := fnd_api.g_ret_sts_unexp_error;
4425:
4426: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4427: fnd_message.set_token('ERROR' ,SQLERRM);
4428: fnd_msg_pub.add;
4429:
4430: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4431: p_count => x_msg_count,
4432: p_data => x_msg_data);

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

4426: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4427: fnd_message.set_token('ERROR' ,SQLERRM);
4428: fnd_msg_pub.add;
4429:
4430: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4431: p_count => x_msg_count,
4432: p_data => x_msg_data);
4433:
4434: -- Debug info.

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

4556: ROLLBACK TO update_contact_point;
4557: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4558: x_return_status := fnd_api.g_ret_sts_error;
4559:
4560: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4561: p_count => x_msg_count,
4562: p_data => x_msg_data);
4563:
4564: -- Debug info.

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

4581: ROLLBACK TO update_contact_point;
4582: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4583: x_return_status := fnd_api.g_ret_sts_unexp_error;
4584:
4585: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4586: p_count => x_msg_count,
4587: p_data => x_msg_data);
4588:
4589: -- Debug info.

Line 4612: fnd_msg_pub.add;

4608: x_return_status := fnd_api.g_ret_sts_unexp_error;
4609:
4610: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4611: fnd_message.set_token('ERROR' ,SQLERRM);
4612: fnd_msg_pub.add;
4613:
4614: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4615: p_count => x_msg_count,
4616: p_data => x_msg_data);

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

4610: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4611: fnd_message.set_token('ERROR' ,SQLERRM);
4612: fnd_msg_pub.add;
4613:
4614: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4615: p_count => x_msg_count,
4616: p_data => x_msg_data);
4617:
4618: -- Debug info.

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

4723: WHEN fnd_api.g_exc_error THEN
4724: ROLLBACK TO update_edi_contact_point;
4725: x_return_status := fnd_api.g_ret_sts_error;
4726:
4727: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4728: p_count => x_msg_count,
4729: p_data => x_msg_data);
4730:
4731: -- Debug info.

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

4747: WHEN fnd_api.g_exc_unexpected_error THEN
4748: ROLLBACK TO update_edi_contact_point;
4749: x_return_status := fnd_api.g_ret_sts_unexp_error;
4750:
4751: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4752: p_count => x_msg_count,
4753: p_data => x_msg_data);
4754:
4755: -- Debug info.

Line 4777: fnd_msg_pub.add;

4773: x_return_status := fnd_api.g_ret_sts_unexp_error;
4774:
4775: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4776: fnd_message.set_token('ERROR' ,SQLERRM);
4777: fnd_msg_pub.add;
4778:
4779: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4780: p_count => x_msg_count,
4781: p_data => x_msg_data);

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

4775: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4776: fnd_message.set_token('ERROR' ,SQLERRM);
4777: fnd_msg_pub.add;
4778:
4779: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4780: p_count => x_msg_count,
4781: p_data => x_msg_data);
4782:
4783: -- Debug info.

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

4890: ROLLBACK TO update_web_contact_point;
4891: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4892: x_return_status := fnd_api.g_ret_sts_error;
4893:
4894: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4895: p_count => x_msg_count,
4896: p_data => x_msg_data);
4897:
4898: -- Debug info.

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

4915: ROLLBACK TO update_web_contact_point;
4916: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4917: x_return_status := fnd_api.g_ret_sts_unexp_error;
4918:
4919: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4920: p_count => x_msg_count,
4921: p_data => x_msg_data);
4922:
4923: -- Debug info.

Line 4947: fnd_msg_pub.add;

4943: x_return_status := fnd_api.g_ret_sts_unexp_error;
4944:
4945: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4946: fnd_message.set_token('ERROR' ,SQLERRM);
4947: fnd_msg_pub.add;
4948:
4949: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4950: p_count => x_msg_count,
4951: p_data => x_msg_data);

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

4945: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4946: fnd_message.set_token('ERROR' ,SQLERRM);
4947: fnd_msg_pub.add;
4948:
4949: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4950: p_count => x_msg_count,
4951: p_data => x_msg_data);
4952:
4953: -- Debug info.

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

5061: WHEN fnd_api.g_exc_error THEN
5062: ROLLBACK TO update_eft_contact_point;
5063: x_return_status := fnd_api.g_ret_sts_error;
5064:
5065: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5066: p_count => x_msg_count,
5067: p_data => x_msg_data);
5068:
5069: -- Debug info.

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

5085: WHEN fnd_api.g_exc_unexpected_error THEN
5086: ROLLBACK TO update_eft_contact_point;
5087: x_return_status := fnd_api.g_ret_sts_unexp_error;
5088:
5089: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5090: p_count => x_msg_count,
5091: p_data => x_msg_data);
5092:
5093: -- Debug info.

Line 5115: fnd_msg_pub.add;

5111: x_return_status := fnd_api.g_ret_sts_unexp_error;
5112:
5113: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5114: fnd_message.set_token('ERROR' ,SQLERRM);
5115: fnd_msg_pub.add;
5116:
5117: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5118: p_count => x_msg_count,
5119: p_data => x_msg_data);

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

5113: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5114: fnd_message.set_token('ERROR' ,SQLERRM);
5115: fnd_msg_pub.add;
5116:
5117: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5118: p_count => x_msg_count,
5119: p_data => x_msg_data);
5120:
5121: -- Debug info.

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

5229: ROLLBACK TO update_phone_contact_point;
5230: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5231: x_return_status := fnd_api.g_ret_sts_error;
5232:
5233: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5234: p_count => x_msg_count,
5235: p_data => x_msg_data);
5236:
5237: -- Debug info.

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

5254: ROLLBACK TO update_phone_contact_point;
5255: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5256: x_return_status := fnd_api.g_ret_sts_unexp_error;
5257:
5258: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5259: p_count => x_msg_count,
5260: p_data => x_msg_data);
5261:
5262: -- Debug info.

Line 5285: fnd_msg_pub.add;

5281: x_return_status := fnd_api.g_ret_sts_unexp_error;
5282:
5283: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5284: fnd_message.set_token('ERROR' ,SQLERRM);
5285: fnd_msg_pub.add;
5286:
5287: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5288: p_count => x_msg_count,
5289: p_data => x_msg_data);

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

5283: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5284: fnd_message.set_token('ERROR' ,SQLERRM);
5285: fnd_msg_pub.add;
5286:
5287: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5288: p_count => x_msg_count,
5289: p_data => x_msg_data);
5290:
5291: -- Debug info.

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

5399: ROLLBACK TO update_telex_contact_point;
5400: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5401: x_return_status := fnd_api.g_ret_sts_error;
5402:
5403: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5404: p_count => x_msg_count,
5405: p_data => x_msg_data);
5406:
5407: -- Debug info.

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

5426: ROLLBACK TO update_telex_contact_point;
5427: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5428: x_return_status := fnd_api.g_ret_sts_unexp_error;
5429:
5430: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5431: p_count => x_msg_count,
5432: p_data => x_msg_data);
5433:
5434: -- Debug info.

Line 5457: fnd_msg_pub.add;

5453: x_return_status := fnd_api.g_ret_sts_unexp_error;
5454:
5455: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5456: fnd_message.set_token('ERROR' ,SQLERRM);
5457: fnd_msg_pub.add;
5458:
5459: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5460: p_count => x_msg_count,
5461: p_data => x_msg_data);

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

5455: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5456: fnd_message.set_token('ERROR' ,SQLERRM);
5457: fnd_msg_pub.add;
5458:
5459: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5460: p_count => x_msg_count,
5461: p_data => x_msg_data);
5462:
5463: -- Debug info.

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

5570: ROLLBACK TO update_email_contact_point;
5571: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5572: x_return_status := fnd_api.g_ret_sts_error;
5573:
5574: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5575: p_count => x_msg_count,
5576: p_data => x_msg_data);
5577:
5578: -- Debug info.

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

5595: ROLLBACK TO update_email_contact_point;
5596: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5597: x_return_status := fnd_api.g_ret_sts_unexp_error;
5598:
5599: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5600: p_count => x_msg_count,
5601: p_data => x_msg_data);
5602:
5603: -- Debug info.

Line 5626: fnd_msg_pub.add;

5622: x_return_status := fnd_api.g_ret_sts_unexp_error;
5623:
5624: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5625: fnd_message.set_token('ERROR' ,SQLERRM);
5626: fnd_msg_pub.add;
5627:
5628: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5629: p_count => x_msg_count,
5630: p_data => x_msg_data);

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

5624: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5625: fnd_message.set_token('ERROR' ,SQLERRM);
5626: fnd_msg_pub.add;
5627:
5628: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5629: p_count => x_msg_count,
5630: p_data => x_msg_data);
5631:
5632: -- Debug info.

Line 5733: fnd_msg_pub.initialize;

5729: END IF;
5730:
5731: -- Initialize message list if p_init_msg_list is set to TRUE.
5732: IF fnd_api.to_boolean(p_init_msg_list) THEN
5733: fnd_msg_pub.initialize;
5734: END IF;
5735:
5736: -- Initialize API return status to success.
5737: x_return_status := fnd_api.g_ret_sts_success;

Line 5760: fnd_msg_pub.add;

5756: IF (l_format_raw_phone AND l_format_area_phone) OR
5757: (NOT l_format_raw_phone AND NOT l_format_area_phone)
5758: THEN
5759: fnd_message.set_name('AR', 'HZ_INVALID_PHONE_PARAMETER');
5760: fnd_msg_pub.add;
5761: RAISE fnd_api.g_exc_error;
5762: END IF;
5763:
5764: -- If not format a raw phone number, then create a raw phone

Line 5831: | fnd_msg_pub.add;

5827:
5828: /* -- Cannot get territory code, error out NOCOPY
5829: | IF l_territory_code IS NULL THEN
5830: | fnd_message.set_name('AR', 'HZ_COUNTRY_CODE_NOT_DEFINED');
5831: | fnd_msg_pub.add;
5832: | RAISE fnd_api.g_exc_error;
5833: | END IF;
5834: |
5835: | -- Call subroutine to get the format style to be applied for the given

Line 5850: | fnd_msg_pub.add;

5846: |
5847: | -- Check for errors in identifying format style
5848: | IF l_msg_name IS NOT NULL THEN
5849: | fnd_message.set_name('AR', l_msg_name);
5850: | fnd_msg_pub.add;
5851: | RAISE fnd_api.g_exc_error;
5852: | END IF;
5853: |
5854: | -- Apply the format style and get translated number

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

5876: |
5877: | x_phone_country_code := l_phone_country_code; */
5878:
5879: -- Standard call to get message count and if count is 1, get message info.
5880: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5881: p_count => x_msg_count,
5882: p_data => x_msg_data);
5883:
5884: -- Debug info.

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

5900: EXCEPTION
5901: WHEN fnd_api.g_exc_error THEN
5902: x_return_status := fnd_api.g_ret_sts_error;
5903:
5904: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5905: p_count => x_msg_count,
5906: p_data => x_msg_data);
5907:
5908: -- Debug info.

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

5923:
5924: WHEN fnd_api.g_exc_unexpected_error THEN
5925: x_return_status := fnd_api.g_ret_sts_unexp_error;
5926:
5927: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5928: p_count => x_msg_count,
5929: p_data => x_msg_data);
5930:
5931: -- Debug info.

Line 5952: fnd_msg_pub.add;

5948: x_return_status := fnd_api.g_ret_sts_unexp_error;
5949:
5950: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5951: fnd_message.set_token('ERROR' ,SQLERRM);
5952: fnd_msg_pub.add;
5953:
5954: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5955: p_count => x_msg_count,
5956: p_data => x_msg_data);

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

5950: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5951: fnd_message.set_token('ERROR' ,SQLERRM);
5952: fnd_msg_pub.add;
5953:
5954: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5955: p_count => x_msg_count,
5956: p_data => x_msg_data);
5957:
5958: -- Debug info.

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

6072: EXCEPTION
6073: WHEN fnd_api.g_exc_error THEN
6074: x_return_status := fnd_api.g_ret_sts_error;
6075:
6076: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6077: p_count => x_msg_count,
6078: p_data => x_msg_data);
6079:
6080: -- Debug info.

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

6095:
6096: WHEN fnd_api.g_exc_unexpected_error THEN
6097: x_return_status := fnd_api.g_ret_sts_unexp_error;
6098:
6099: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6100: p_count => x_msg_count,
6101: p_data => x_msg_data);
6102:
6103: -- Debug info.

Line 6124: fnd_msg_pub.add;

6120: x_return_status := fnd_api.g_ret_sts_unexp_error;
6121:
6122: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6123: fnd_message.set_token('ERROR' ,SQLERRM);
6124: fnd_msg_pub.add;
6125:
6126: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6127: p_count => x_msg_count,
6128: p_data => x_msg_data);

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

6122: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6123: fnd_message.set_token('ERROR' ,SQLERRM);
6124: fnd_msg_pub.add;
6125:
6126: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6127: p_count => x_msg_count,
6128: p_data => x_msg_data);
6129:
6130: -- Debug info.

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

6238: EXCEPTION
6239: WHEN fnd_api.g_exc_error THEN
6240: x_return_status := fnd_api.g_ret_sts_error;
6241:
6242: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6243: p_count => x_msg_count,
6244: p_data => x_msg_data);
6245:
6246: -- Debug info.

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

6261:
6262: WHEN fnd_api.g_exc_unexpected_error THEN
6263: x_return_status := fnd_api.g_ret_sts_unexp_error;
6264:
6265: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6266: p_count => x_msg_count,
6267: p_data => x_msg_data);
6268:
6269: -- Debug info.

Line 6290: fnd_msg_pub.add;

6286: x_return_status := fnd_api.g_ret_sts_unexp_error;
6287:
6288: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6289: fnd_message.set_token('ERROR' ,SQLERRM);
6290: fnd_msg_pub.add;
6291:
6292: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6293: p_count => x_msg_count,
6294: p_data => x_msg_data);

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

6288: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6289: fnd_message.set_token('ERROR' ,SQLERRM);
6290: fnd_msg_pub.add;
6291:
6292: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6293: p_count => x_msg_count,
6294: p_data => x_msg_data);
6295:
6296: -- Debug info.

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

6405: EXCEPTION
6406: WHEN fnd_api.g_exc_error THEN
6407: x_return_status := fnd_api.g_ret_sts_error;
6408:
6409: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6410: p_count => x_msg_count,
6411: p_data => x_msg_data);
6412:
6413: -- Debug info.

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

6428:
6429: WHEN fnd_api.g_exc_unexpected_error THEN
6430: x_return_status := fnd_api.g_ret_sts_unexp_error;
6431:
6432: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6433: p_count => x_msg_count,
6434: p_data => x_msg_data);
6435:
6436: -- Debug info.

Line 6457: fnd_msg_pub.add;

6453: x_return_status := fnd_api.g_ret_sts_unexp_error;
6454:
6455: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6456: fnd_message.set_token('ERROR' ,SQLERRM);
6457: fnd_msg_pub.add;
6458:
6459: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6460: p_count => x_msg_count,
6461: p_data => x_msg_data);

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

6455: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6456: fnd_message.set_token('ERROR' ,SQLERRM);
6457: fnd_msg_pub.add;
6458:
6459: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6460: p_count => x_msg_count,
6461: p_data => x_msg_data);
6462:
6463: -- Debug info.

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

6572: EXCEPTION
6573: WHEN fnd_api.g_exc_error THEN
6574: x_return_status := fnd_api.g_ret_sts_error;
6575:
6576: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6577: p_count => x_msg_count,
6578: p_data => x_msg_data);
6579:
6580: -- Debug info.

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

6595:
6596: WHEN fnd_api.g_exc_unexpected_error THEN
6597: x_return_status := fnd_api.g_ret_sts_unexp_error;
6598:
6599: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6600: p_count => x_msg_count,
6601: p_data => x_msg_data);
6602:
6603: -- Debug info.

Line 6625: fnd_msg_pub.add;

6621: x_return_status := fnd_api.g_ret_sts_unexp_error;
6622:
6623: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6624: fnd_message.set_token('ERROR' ,SQLERRM);
6625: fnd_msg_pub.add;
6626:
6627: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6628: p_count => x_msg_count,
6629: p_data => x_msg_data);

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

6623: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6624: fnd_message.set_token('ERROR' ,SQLERRM);
6625: fnd_msg_pub.add;
6626:
6627: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6628: p_count => x_msg_count,
6629: p_data => x_msg_data);
6630:
6631: -- Debug info.

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

6739: EXCEPTION
6740: WHEN fnd_api.g_exc_error THEN
6741: x_return_status := fnd_api.g_ret_sts_error;
6742:
6743: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6744: p_count => x_msg_count,
6745: p_data => x_msg_data);
6746:
6747: -- Debug info.

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

6762:
6763: WHEN fnd_api.g_exc_unexpected_error THEN
6764: x_return_status := fnd_api.g_ret_sts_unexp_error;
6765:
6766: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6767: p_count => x_msg_count,
6768: p_data => x_msg_data);
6769:
6770: -- Debug info.

Line 6791: fnd_msg_pub.add;

6787: x_return_status := fnd_api.g_ret_sts_unexp_error;
6788:
6789: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6790: fnd_message.set_token('ERROR' ,SQLERRM);
6791: fnd_msg_pub.add;
6792:
6793: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6794: p_count => x_msg_count,
6795: p_data => x_msg_data);

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

6789: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6790: fnd_message.set_token('ERROR' ,SQLERRM);
6791: fnd_msg_pub.add;
6792:
6793: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6794: p_count => x_msg_count,
6795: p_data => x_msg_data);
6796:
6797: -- Debug info.

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

6905: EXCEPTION
6906: WHEN fnd_api.g_exc_error THEN
6907: x_return_status := fnd_api.g_ret_sts_error;
6908:
6909: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6910: p_count => x_msg_count,
6911: p_data => x_msg_data);
6912:
6913: -- Debug info.

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

6928:
6929: WHEN fnd_api.g_exc_unexpected_error THEN
6930: x_return_status := fnd_api.g_ret_sts_unexp_error;
6931:
6932: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6933: p_count => x_msg_count,
6934: p_data => x_msg_data);
6935:
6936: -- Debug info.

Line 6957: fnd_msg_pub.add;

6953: x_return_status := fnd_api.g_ret_sts_unexp_error;
6954:
6955: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6956: fnd_message.set_token('ERROR' ,SQLERRM);
6957: fnd_msg_pub.add;
6958:
6959: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6960: p_count => x_msg_count,
6961: p_data => x_msg_data);

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

6955: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6956: fnd_message.set_token('ERROR' ,SQLERRM);
6957: fnd_msg_pub.add;
6958:
6959: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6960: p_count => x_msg_count,
6961: p_data => x_msg_data);
6962:
6963: -- Debug info.

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

7072: EXCEPTION
7073: WHEN fnd_api.g_exc_error THEN
7074: x_return_status := fnd_api.g_ret_sts_error;
7075:
7076: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
7077: p_count => x_msg_count,
7078: p_data => x_msg_data);
7079:
7080: -- Debug info.

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

7095:
7096: WHEN fnd_api.g_exc_unexpected_error THEN
7097: x_return_status := fnd_api.g_ret_sts_unexp_error;
7098:
7099: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
7100: p_count => x_msg_count,
7101: p_data => x_msg_data);
7102:
7103: -- Debug info.

Line 7124: fnd_msg_pub.add;

7120: x_return_status := fnd_api.g_ret_sts_unexp_error;
7121:
7122: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7123: fnd_message.set_token('ERROR' ,SQLERRM);
7124: fnd_msg_pub.add;
7125:
7126: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
7127: p_count => x_msg_count,
7128: p_data => x_msg_data);

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

7122: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7123: fnd_message.set_token('ERROR' ,SQLERRM);
7124: fnd_msg_pub.add;
7125:
7126: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
7127: p_count => x_msg_count,
7128: p_data => x_msg_data);
7129:
7130: -- Debug info.