DBA Data[Home] [Help]

APPS.AMS_LIST_IMPORT_PUB dependencies on FND_MSG_PUB

Line 42: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

38: --
39: -- This procedure is used for existence checking for party.
40: --
41: --
42: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
43: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
44: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
45:
46:

Line 43: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

39: -- This procedure is used for existence checking for party.
40: --
41: --
42: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
43: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
44: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
45:
46:
47: PROCEDURE party_echeck(

Line 44: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

40: --
41: --
42: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
43: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
44: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
45:
46:
47: PROCEDURE party_echeck(
48: p_party_id IN OUT NOCOPY NUMBER,

Line 609: FND_MSG_PUB.initialize;

605:
606: SAVEPOINT create_customer_pub;
607: --Initialize message list if p_init_msg_list is set to TRUE.
608: IF FND_API.to_boolean(p_init_msg_list) THEN
609: FND_MSG_PUB.initialize;
610: END IF;
611: --Initialize API return status to success.
612: x_return_status := FND_API.G_RET_STS_SUCCESS;
613: x_generate_party_number := fnd_profile.value('HZ_GENERATE_PARTY_NUMBER');

Line 1649: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1645: x_msg_count,
1646: x_msg_data);
1647: if x_msg_count > 1 then
1648: FOR i IN 1..x_msg_count LOOP
1649: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1650: x_tmp_var1 := substrb(x_tmp_var1 || ' '|| x_tmp_var,1,4000);
1651: END LOOP;
1652: x_msg_data := x_tmp_var1;
1653: END IF;

Line 2932: FND_MSG_PUB.count_and_get(

2928:
2929: WHEN FND_API.g_exc_error THEN
2930: ROLLBACK TO Create_Customer_pub;
2931: x_return_status := FND_API.g_ret_sts_error;
2932: FND_MSG_PUB.count_and_get(
2933: p_encoded => FND_API.g_false,
2934: p_count => x_msg_count,
2935: p_data => x_msg_data
2936: );

Line 2941: FND_MSG_PUB.count_and_get(

2937:
2938: WHEN FND_API.g_exc_unexpected_error THEN
2939: -- ROLLBACK TO Create_Customer_pub;
2940: x_return_status := FND_API.g_ret_sts_unexp_error ;
2941: FND_MSG_PUB.count_and_get(
2942: p_encoded => FND_API.g_false,
2943: p_count => x_msg_count,
2944: p_data => x_msg_data
2945: );

Line 2951: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

2947:
2948: WHEN OTHERS THEN
2949: -- ROLLBACK TO Create_Customer_pub;
2950: x_return_status := FND_API.g_ret_sts_unexp_error ;
2951: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2952: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2953: END IF;
2954:
2955: FND_MSG_PUB.count_and_get(

Line 2952: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2948: WHEN OTHERS THEN
2949: -- ROLLBACK TO Create_Customer_pub;
2950: x_return_status := FND_API.g_ret_sts_unexp_error ;
2951: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2952: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2953: END IF;
2954:
2955: FND_MSG_PUB.count_and_get(
2956: p_encoded => FND_API.g_false,

Line 2955: FND_MSG_PUB.count_and_get(

2951: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2952: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2953: END IF;
2954:
2955: FND_MSG_PUB.count_and_get(
2956: p_encoded => FND_API.g_false,
2957: p_count => x_msg_count,
2958: p_data => x_msg_data
2959: );

Line 3245: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3241:
3242: exception
3243: when others then
3244: x_return_status := FND_API.g_ret_sts_unexp_error ;
3245: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3246: FND_MSG_PUB.add_exc_msg(g_pkg_name,'party_echeck');
3247: END IF;
3248: FND_MSG_PUB.count_and_get(
3249: p_encoded => FND_API.g_false,

Line 3246: FND_MSG_PUB.add_exc_msg(g_pkg_name,'party_echeck');

3242: exception
3243: when others then
3244: x_return_status := FND_API.g_ret_sts_unexp_error ;
3245: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3246: FND_MSG_PUB.add_exc_msg(g_pkg_name,'party_echeck');
3247: END IF;
3248: FND_MSG_PUB.count_and_get(
3249: p_encoded => FND_API.g_false,
3250: p_count => x_msg_count,

Line 3248: FND_MSG_PUB.count_and_get(

3244: x_return_status := FND_API.g_ret_sts_unexp_error ;
3245: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3246: FND_MSG_PUB.add_exc_msg(g_pkg_name,'party_echeck');
3247: END IF;
3248: FND_MSG_PUB.count_and_get(
3249: p_encoded => FND_API.g_false,
3250: p_count => x_msg_count,
3251: p_data => x_msg_data
3252: );

Line 3325: FND_MSG_PUB.initialize;

3321:
3322: SAVEPOINT error_capture_pub;
3323: -- initialize the message list;
3324: IF FND_API.to_boolean(p_init_msg_list) THEN
3325: FND_MSG_PUB.initialize;
3326: END IF;
3327: if nvl(p_component_name,'X') <> 'EVENTSUB' then
3328: open c_imp_type;
3329: fetch c_imp_type into l_imp_type, l_batch_id, L_ERROR_THRESHOLD;

Line 3543: FND_MSG_PUB.count_and_get(

3539:
3540: WHEN FND_API.g_exc_error THEN
3541: ROLLBACK TO error_capture_pub;
3542: x_return_status := FND_API.g_ret_sts_error;
3543: FND_MSG_PUB.count_and_get(
3544: p_encoded => FND_API.g_false,
3545: p_count => x_msg_count,
3546: p_data => x_msg_data
3547: );

Line 3552: FND_MSG_PUB.count_and_get(

3548:
3549: WHEN FND_API.g_exc_unexpected_error THEN
3550: ROLLBACK TO error_capture_pub;
3551: x_return_status := FND_API.g_ret_sts_unexp_error ;
3552: FND_MSG_PUB.count_and_get(
3553: p_encoded => FND_API.g_false,
3554: p_count => x_msg_count,
3555: p_data => x_msg_data
3556: );

Line 3562: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3558: WHEN OTHERS THEN
3559: -- ROLLBACK TO error_capture_pub;
3560: x_return_status := FND_API.g_ret_sts_unexp_error ;
3561:
3562: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3563: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'error_capture');
3564: END IF;
3565:
3566: FND_MSG_PUB.count_and_get(

Line 3563: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'error_capture');

3559: -- ROLLBACK TO error_capture_pub;
3560: x_return_status := FND_API.g_ret_sts_unexp_error ;
3561:
3562: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3563: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'error_capture');
3564: END IF;
3565:
3566: FND_MSG_PUB.count_and_get(
3567: p_encoded => FND_API.g_false,

Line 3566: FND_MSG_PUB.count_and_get(

3562: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3563: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'error_capture');
3564: END IF;
3565:
3566: FND_MSG_PUB.count_and_get(
3567: p_encoded => FND_API.g_false,
3568: p_count => x_msg_count,
3569: p_data => x_msg_data
3570: );

Line 3949: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3945:
3946: exception
3947: when others then
3948: x_return_status := FND_API.g_ret_sts_unexp_error ;
3949: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3950: FND_MSG_PUB.add_exc_msg(g_pkg_name,'contact_echeck');
3951: END IF;
3952: FND_MSG_PUB.count_and_get(
3953: p_encoded => FND_API.g_false,

Line 3950: FND_MSG_PUB.add_exc_msg(g_pkg_name,'contact_echeck');

3946: exception
3947: when others then
3948: x_return_status := FND_API.g_ret_sts_unexp_error ;
3949: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3950: FND_MSG_PUB.add_exc_msg(g_pkg_name,'contact_echeck');
3951: END IF;
3952: FND_MSG_PUB.count_and_get(
3953: p_encoded => FND_API.g_false,
3954: p_count => x_msg_count,

Line 3952: FND_MSG_PUB.count_and_get(

3948: x_return_status := FND_API.g_ret_sts_unexp_error ;
3949: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3950: FND_MSG_PUB.add_exc_msg(g_pkg_name,'contact_echeck');
3951: END IF;
3952: FND_MSG_PUB.count_and_get(
3953: p_encoded => FND_API.g_false,
3954: p_count => x_msg_count,
3955: p_data => x_msg_data
3956: );

Line 4098: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

4094:
4095: exception
4096: when others then
4097: x_return_status := FND_API.g_ret_sts_unexp_error ;
4098: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4099: FND_MSG_PUB.add_exc_msg(g_pkg_name,'contact_echeck');
4100: END IF;
4101: FND_MSG_PUB.count_and_get(
4102: p_encoded => FND_API.g_false,

Line 4099: FND_MSG_PUB.add_exc_msg(g_pkg_name,'contact_echeck');

4095: exception
4096: when others then
4097: x_return_status := FND_API.g_ret_sts_unexp_error ;
4098: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4099: FND_MSG_PUB.add_exc_msg(g_pkg_name,'contact_echeck');
4100: END IF;
4101: FND_MSG_PUB.count_and_get(
4102: p_encoded => FND_API.g_false,
4103: p_count => x_msg_count,

Line 4101: FND_MSG_PUB.count_and_get(

4097: x_return_status := FND_API.g_ret_sts_unexp_error ;
4098: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4099: FND_MSG_PUB.add_exc_msg(g_pkg_name,'contact_echeck');
4100: END IF;
4101: FND_MSG_PUB.count_and_get(
4102: p_encoded => FND_API.g_false,
4103: p_count => x_msg_count,
4104: p_data => x_msg_data
4105: );

Line 4580: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

4576: end if;
4577: exception
4578: when others then
4579: x_return_status := FND_API.g_ret_sts_unexp_error ;
4580: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4581: FND_MSG_PUB.add_exc_msg(g_pkg_name,'person_party_echeck');
4582: END IF;
4583: FND_MSG_PUB.count_and_get(
4584: p_encoded => FND_API.g_false,

Line 4581: FND_MSG_PUB.add_exc_msg(g_pkg_name,'person_party_echeck');

4577: exception
4578: when others then
4579: x_return_status := FND_API.g_ret_sts_unexp_error ;
4580: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4581: FND_MSG_PUB.add_exc_msg(g_pkg_name,'person_party_echeck');
4582: END IF;
4583: FND_MSG_PUB.count_and_get(
4584: p_encoded => FND_API.g_false,
4585: p_count => x_msg_count,

Line 4583: FND_MSG_PUB.count_and_get(

4579: x_return_status := FND_API.g_ret_sts_unexp_error ;
4580: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4581: FND_MSG_PUB.add_exc_msg(g_pkg_name,'person_party_echeck');
4582: END IF;
4583: FND_MSG_PUB.count_and_get(
4584: p_encoded => FND_API.g_false,
4585: p_count => x_msg_count,
4586: p_data => x_msg_data
4587: );

Line 4870: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

4866: end if;
4867: exception
4868: when others then
4869: x_return_status := FND_API.g_ret_sts_unexp_error ;
4870: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4871: FND_MSG_PUB.add_exc_msg(g_pkg_name,'contact_person_party_echeck');
4872: END IF;
4873: FND_MSG_PUB.count_and_get(
4874: p_encoded => FND_API.g_false,

Line 4871: FND_MSG_PUB.add_exc_msg(g_pkg_name,'contact_person_party_echeck');

4867: exception
4868: when others then
4869: x_return_status := FND_API.g_ret_sts_unexp_error ;
4870: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4871: FND_MSG_PUB.add_exc_msg(g_pkg_name,'contact_person_party_echeck');
4872: END IF;
4873: FND_MSG_PUB.count_and_get(
4874: p_encoded => FND_API.g_false,
4875: p_count => x_msg_count,

Line 4873: FND_MSG_PUB.count_and_get(

4869: x_return_status := FND_API.g_ret_sts_unexp_error ;
4870: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4871: FND_MSG_PUB.add_exc_msg(g_pkg_name,'contact_person_party_echeck');
4872: END IF;
4873: FND_MSG_PUB.count_and_get(
4874: p_encoded => FND_API.g_false,
4875: p_count => x_msg_count,
4876: p_data => x_msg_data
4877: );

Line 4988: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

4984: end if;
4985: exception
4986: when others then
4987: x_return_status := FND_API.g_ret_sts_unexp_error ;
4988: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4989: FND_MSG_PUB.add_exc_msg(g_pkg_name,'person_party_echeck');
4990: END IF;
4991: FND_MSG_PUB.count_and_get(
4992: p_encoded => FND_API.g_false,

Line 4989: FND_MSG_PUB.add_exc_msg(g_pkg_name,'person_party_echeck');

4985: exception
4986: when others then
4987: x_return_status := FND_API.g_ret_sts_unexp_error ;
4988: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4989: FND_MSG_PUB.add_exc_msg(g_pkg_name,'person_party_echeck');
4990: END IF;
4991: FND_MSG_PUB.count_and_get(
4992: p_encoded => FND_API.g_false,
4993: p_count => x_msg_count,

Line 4991: FND_MSG_PUB.count_and_get(

4987: x_return_status := FND_API.g_ret_sts_unexp_error ;
4988: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4989: FND_MSG_PUB.add_exc_msg(g_pkg_name,'person_party_echeck');
4990: END IF;
4991: FND_MSG_PUB.count_and_get(
4992: p_encoded => FND_API.g_false,
4993: p_count => x_msg_count,
4994: p_data => x_msg_data
4995: );

Line 5017: FND_MSG_PUB.initialize;

5013: BEGIN
5014: SAVEPOINT update_rented_list_party_pub;
5015: -- initialize the message list;
5016: IF FND_API.to_boolean(p_init_msg_list) THEN
5017: FND_MSG_PUB.initialize;
5018: END IF;
5019:
5020: --call private API procedure.
5021: AMS_ListImport_PVT.update_rented_list_party (

Line 5037: FND_MSG_PUB.count_and_get(

5033: IF FND_API.to_boolean(p_commit) THEN
5034: COMMIT;
5035: END IF;
5036: x_return_status := FND_API.g_ret_sts_success;
5037: FND_MSG_PUB.count_and_get(
5038: p_encoded => FND_API.g_false,
5039: p_count => x_msg_count,
5040: p_data => x_msg_data
5041: );

Line 5047: FND_MSG_PUB.count_and_get(

5043:
5044: WHEN FND_API.g_exc_error THEN
5045: ROLLBACK TO update_rented_list_party_pub;
5046: x_return_status := FND_API.g_ret_sts_error;
5047: FND_MSG_PUB.count_and_get(
5048: p_encoded => FND_API.g_false,
5049: p_count => x_msg_count,
5050: p_data => x_msg_data
5051: );

Line 5056: FND_MSG_PUB.count_and_get(

5052:
5053: WHEN FND_API.g_exc_unexpected_error THEN
5054: ROLLBACK TO update_rented_list_party_pub;
5055: x_return_status := FND_API.g_ret_sts_unexp_error ;
5056: FND_MSG_PUB.count_and_get(
5057: p_encoded => FND_API.g_false,
5058: p_count => x_msg_count,
5059: p_data => x_msg_data
5060: );

Line 5066: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

5062: WHEN OTHERS THEN
5063: ROLLBACK TO update_rented_list_party_pub;
5064: x_return_status := FND_API.g_ret_sts_unexp_error ;
5065:
5066: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5067: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'update_rented_list_party');
5068: END IF;
5069:
5070: FND_MSG_PUB.count_and_get(

Line 5067: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'update_rented_list_party');

5063: ROLLBACK TO update_rented_list_party_pub;
5064: x_return_status := FND_API.g_ret_sts_unexp_error ;
5065:
5066: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5067: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'update_rented_list_party');
5068: END IF;
5069:
5070: FND_MSG_PUB.count_and_get(
5071: p_encoded => FND_API.g_false,

Line 5070: FND_MSG_PUB.count_and_get(

5066: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5067: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'update_rented_list_party');
5068: END IF;
5069:
5070: FND_MSG_PUB.count_and_get(
5071: p_encoded => FND_API.g_false,
5072: p_count => x_msg_count,
5073: p_data => x_msg_data
5074: );