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 1653: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

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

Line 2939: FND_MSG_PUB.count_and_get(

2935:
2936: WHEN FND_API.g_exc_error THEN
2937: ROLLBACK TO Create_Customer_pub;
2938: x_return_status := FND_API.g_ret_sts_error;
2939: FND_MSG_PUB.count_and_get(
2940: p_encoded => FND_API.g_false,
2941: p_count => x_msg_count,
2942: p_data => x_msg_data
2943: );

Line 2948: FND_MSG_PUB.count_and_get(

2944:
2945: WHEN FND_API.g_exc_unexpected_error THEN
2946: -- ROLLBACK TO Create_Customer_pub;
2947: x_return_status := FND_API.g_ret_sts_unexp_error ;
2948: FND_MSG_PUB.count_and_get(
2949: p_encoded => FND_API.g_false,
2950: p_count => x_msg_count,
2951: p_data => x_msg_data
2952: );

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

2954:
2955: WHEN OTHERS THEN
2956: -- ROLLBACK TO Create_Customer_pub;
2957: x_return_status := FND_API.g_ret_sts_unexp_error ;
2958: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2959: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2960: END IF;
2961:
2962: FND_MSG_PUB.count_and_get(

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

2955: WHEN OTHERS THEN
2956: -- ROLLBACK TO Create_Customer_pub;
2957: x_return_status := FND_API.g_ret_sts_unexp_error ;
2958: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2959: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2960: END IF;
2961:
2962: FND_MSG_PUB.count_and_get(
2963: p_encoded => FND_API.g_false,

Line 2962: FND_MSG_PUB.count_and_get(

2958: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2959: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2960: END IF;
2961:
2962: FND_MSG_PUB.count_and_get(
2963: p_encoded => FND_API.g_false,
2964: p_count => x_msg_count,
2965: p_data => x_msg_data
2966: );

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

3248:
3249: exception
3250: when others then
3251: x_return_status := FND_API.g_ret_sts_unexp_error ;
3252: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3253: FND_MSG_PUB.add_exc_msg(g_pkg_name,'party_echeck');
3254: END IF;
3255: FND_MSG_PUB.count_and_get(
3256: p_encoded => FND_API.g_false,

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

3249: exception
3250: when others then
3251: x_return_status := FND_API.g_ret_sts_unexp_error ;
3252: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3253: FND_MSG_PUB.add_exc_msg(g_pkg_name,'party_echeck');
3254: END IF;
3255: FND_MSG_PUB.count_and_get(
3256: p_encoded => FND_API.g_false,
3257: p_count => x_msg_count,

Line 3255: FND_MSG_PUB.count_and_get(

3251: x_return_status := FND_API.g_ret_sts_unexp_error ;
3252: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3253: FND_MSG_PUB.add_exc_msg(g_pkg_name,'party_echeck');
3254: END IF;
3255: FND_MSG_PUB.count_and_get(
3256: p_encoded => FND_API.g_false,
3257: p_count => x_msg_count,
3258: p_data => x_msg_data
3259: );

Line 3332: FND_MSG_PUB.initialize;

3328:
3329: SAVEPOINT error_capture_pub;
3330: -- initialize the message list;
3331: IF FND_API.to_boolean(p_init_msg_list) THEN
3332: FND_MSG_PUB.initialize;
3333: END IF;
3334: if nvl(p_component_name,'X') <> 'EVENTSUB' then
3335: open c_imp_type;
3336: fetch c_imp_type into l_imp_type, l_batch_id, L_ERROR_THRESHOLD;

Line 3550: FND_MSG_PUB.count_and_get(

3546:
3547: WHEN FND_API.g_exc_error THEN
3548: ROLLBACK TO error_capture_pub;
3549: x_return_status := FND_API.g_ret_sts_error;
3550: FND_MSG_PUB.count_and_get(
3551: p_encoded => FND_API.g_false,
3552: p_count => x_msg_count,
3553: p_data => x_msg_data
3554: );

Line 3559: FND_MSG_PUB.count_and_get(

3555:
3556: WHEN FND_API.g_exc_unexpected_error THEN
3557: ROLLBACK TO error_capture_pub;
3558: x_return_status := FND_API.g_ret_sts_unexp_error ;
3559: FND_MSG_PUB.count_and_get(
3560: p_encoded => FND_API.g_false,
3561: p_count => x_msg_count,
3562: p_data => x_msg_data
3563: );

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

3565: WHEN OTHERS THEN
3566: -- ROLLBACK TO error_capture_pub;
3567: x_return_status := FND_API.g_ret_sts_unexp_error ;
3568:
3569: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3570: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'error_capture');
3571: END IF;
3572:
3573: FND_MSG_PUB.count_and_get(

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

3566: -- ROLLBACK TO error_capture_pub;
3567: x_return_status := FND_API.g_ret_sts_unexp_error ;
3568:
3569: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3570: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'error_capture');
3571: END IF;
3572:
3573: FND_MSG_PUB.count_and_get(
3574: p_encoded => FND_API.g_false,

Line 3573: FND_MSG_PUB.count_and_get(

3569: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3570: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'error_capture');
3571: END IF;
3572:
3573: FND_MSG_PUB.count_and_get(
3574: p_encoded => FND_API.g_false,
3575: p_count => x_msg_count,
3576: p_data => x_msg_data
3577: );

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

3952:
3953: exception
3954: when others then
3955: x_return_status := FND_API.g_ret_sts_unexp_error ;
3956: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3957: FND_MSG_PUB.add_exc_msg(g_pkg_name,'contact_echeck');
3958: END IF;
3959: FND_MSG_PUB.count_and_get(
3960: p_encoded => FND_API.g_false,

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

3953: exception
3954: when others then
3955: x_return_status := FND_API.g_ret_sts_unexp_error ;
3956: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3957: FND_MSG_PUB.add_exc_msg(g_pkg_name,'contact_echeck');
3958: END IF;
3959: FND_MSG_PUB.count_and_get(
3960: p_encoded => FND_API.g_false,
3961: p_count => x_msg_count,

Line 3959: FND_MSG_PUB.count_and_get(

3955: x_return_status := FND_API.g_ret_sts_unexp_error ;
3956: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3957: FND_MSG_PUB.add_exc_msg(g_pkg_name,'contact_echeck');
3958: END IF;
3959: FND_MSG_PUB.count_and_get(
3960: p_encoded => FND_API.g_false,
3961: p_count => x_msg_count,
3962: p_data => x_msg_data
3963: );

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

4101:
4102: exception
4103: when others then
4104: x_return_status := FND_API.g_ret_sts_unexp_error ;
4105: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4106: FND_MSG_PUB.add_exc_msg(g_pkg_name,'contact_echeck');
4107: END IF;
4108: FND_MSG_PUB.count_and_get(
4109: p_encoded => FND_API.g_false,

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

4102: exception
4103: when others then
4104: x_return_status := FND_API.g_ret_sts_unexp_error ;
4105: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4106: FND_MSG_PUB.add_exc_msg(g_pkg_name,'contact_echeck');
4107: END IF;
4108: FND_MSG_PUB.count_and_get(
4109: p_encoded => FND_API.g_false,
4110: p_count => x_msg_count,

Line 4108: FND_MSG_PUB.count_and_get(

4104: x_return_status := FND_API.g_ret_sts_unexp_error ;
4105: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4106: FND_MSG_PUB.add_exc_msg(g_pkg_name,'contact_echeck');
4107: END IF;
4108: FND_MSG_PUB.count_and_get(
4109: p_encoded => FND_API.g_false,
4110: p_count => x_msg_count,
4111: p_data => x_msg_data
4112: );

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

4583: end if;
4584: exception
4585: when others then
4586: x_return_status := FND_API.g_ret_sts_unexp_error ;
4587: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4588: FND_MSG_PUB.add_exc_msg(g_pkg_name,'person_party_echeck');
4589: END IF;
4590: FND_MSG_PUB.count_and_get(
4591: p_encoded => FND_API.g_false,

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

4584: exception
4585: when others then
4586: x_return_status := FND_API.g_ret_sts_unexp_error ;
4587: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4588: FND_MSG_PUB.add_exc_msg(g_pkg_name,'person_party_echeck');
4589: END IF;
4590: FND_MSG_PUB.count_and_get(
4591: p_encoded => FND_API.g_false,
4592: p_count => x_msg_count,

Line 4590: FND_MSG_PUB.count_and_get(

4586: x_return_status := FND_API.g_ret_sts_unexp_error ;
4587: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4588: FND_MSG_PUB.add_exc_msg(g_pkg_name,'person_party_echeck');
4589: END IF;
4590: FND_MSG_PUB.count_and_get(
4591: p_encoded => FND_API.g_false,
4592: p_count => x_msg_count,
4593: p_data => x_msg_data
4594: );

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

4873: end if;
4874: exception
4875: when others then
4876: x_return_status := FND_API.g_ret_sts_unexp_error ;
4877: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4878: FND_MSG_PUB.add_exc_msg(g_pkg_name,'contact_person_party_echeck');
4879: END IF;
4880: FND_MSG_PUB.count_and_get(
4881: p_encoded => FND_API.g_false,

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

4874: exception
4875: when others then
4876: x_return_status := FND_API.g_ret_sts_unexp_error ;
4877: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4878: FND_MSG_PUB.add_exc_msg(g_pkg_name,'contact_person_party_echeck');
4879: END IF;
4880: FND_MSG_PUB.count_and_get(
4881: p_encoded => FND_API.g_false,
4882: p_count => x_msg_count,

Line 4880: FND_MSG_PUB.count_and_get(

4876: x_return_status := FND_API.g_ret_sts_unexp_error ;
4877: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4878: FND_MSG_PUB.add_exc_msg(g_pkg_name,'contact_person_party_echeck');
4879: END IF;
4880: FND_MSG_PUB.count_and_get(
4881: p_encoded => FND_API.g_false,
4882: p_count => x_msg_count,
4883: p_data => x_msg_data
4884: );

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

4991: end if;
4992: exception
4993: when others then
4994: x_return_status := FND_API.g_ret_sts_unexp_error ;
4995: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4996: FND_MSG_PUB.add_exc_msg(g_pkg_name,'person_party_echeck');
4997: END IF;
4998: FND_MSG_PUB.count_and_get(
4999: p_encoded => FND_API.g_false,

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

4992: exception
4993: when others then
4994: x_return_status := FND_API.g_ret_sts_unexp_error ;
4995: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4996: FND_MSG_PUB.add_exc_msg(g_pkg_name,'person_party_echeck');
4997: END IF;
4998: FND_MSG_PUB.count_and_get(
4999: p_encoded => FND_API.g_false,
5000: p_count => x_msg_count,

Line 4998: FND_MSG_PUB.count_and_get(

4994: x_return_status := FND_API.g_ret_sts_unexp_error ;
4995: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4996: FND_MSG_PUB.add_exc_msg(g_pkg_name,'person_party_echeck');
4997: END IF;
4998: FND_MSG_PUB.count_and_get(
4999: p_encoded => FND_API.g_false,
5000: p_count => x_msg_count,
5001: p_data => x_msg_data
5002: );

Line 5024: FND_MSG_PUB.initialize;

5020: BEGIN
5021: SAVEPOINT update_rented_list_party_pub;
5022: -- initialize the message list;
5023: IF FND_API.to_boolean(p_init_msg_list) THEN
5024: FND_MSG_PUB.initialize;
5025: END IF;
5026:
5027: --call private API procedure.
5028: AMS_ListImport_PVT.update_rented_list_party (

Line 5044: FND_MSG_PUB.count_and_get(

5040: IF FND_API.to_boolean(p_commit) THEN
5041: COMMIT;
5042: END IF;
5043: x_return_status := FND_API.g_ret_sts_success;
5044: FND_MSG_PUB.count_and_get(
5045: p_encoded => FND_API.g_false,
5046: p_count => x_msg_count,
5047: p_data => x_msg_data
5048: );

Line 5054: FND_MSG_PUB.count_and_get(

5050:
5051: WHEN FND_API.g_exc_error THEN
5052: ROLLBACK TO update_rented_list_party_pub;
5053: x_return_status := FND_API.g_ret_sts_error;
5054: FND_MSG_PUB.count_and_get(
5055: p_encoded => FND_API.g_false,
5056: p_count => x_msg_count,
5057: p_data => x_msg_data
5058: );

Line 5063: FND_MSG_PUB.count_and_get(

5059:
5060: WHEN FND_API.g_exc_unexpected_error THEN
5061: ROLLBACK TO update_rented_list_party_pub;
5062: x_return_status := FND_API.g_ret_sts_unexp_error ;
5063: FND_MSG_PUB.count_and_get(
5064: p_encoded => FND_API.g_false,
5065: p_count => x_msg_count,
5066: p_data => x_msg_data
5067: );

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

5069: WHEN OTHERS THEN
5070: ROLLBACK TO update_rented_list_party_pub;
5071: x_return_status := FND_API.g_ret_sts_unexp_error ;
5072:
5073: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5074: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'update_rented_list_party');
5075: END IF;
5076:
5077: FND_MSG_PUB.count_and_get(

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

5070: ROLLBACK TO update_rented_list_party_pub;
5071: x_return_status := FND_API.g_ret_sts_unexp_error ;
5072:
5073: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5074: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'update_rented_list_party');
5075: END IF;
5076:
5077: FND_MSG_PUB.count_and_get(
5078: p_encoded => FND_API.g_false,

Line 5077: FND_MSG_PUB.count_and_get(

5073: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5074: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'update_rented_list_party');
5075: END IF;
5076:
5077: FND_MSG_PUB.count_and_get(
5078: p_encoded => FND_API.g_false,
5079: p_count => x_msg_count,
5080: p_data => x_msg_data
5081: );