eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_LIST_IMPORT_PUB dependencies on FND_API

Line 194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

190:
191:
192: PROCEDURE Create_Customer
193: ( p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
195: p_commit IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,

Line 195: p_commit IN VARCHAR2 := FND_API.G_FALSE,

191:
192: PROCEDURE Create_Customer
193: ( p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
195: p_commit IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,

Line 196: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

192: PROCEDURE Create_Customer
193: ( p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
195: p_commit IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,
200: p_party_id IN OUT NOCOPY NUMBER,

Line 608: IF FND_API.to_boolean(p_init_msg_list) THEN

604: begin
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;

Line 612: x_return_status := FND_API.G_RET_STS_SUCCESS;

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');
614: x_gen_contact_number := fnd_profile.value('HZ_GENERATE_CONTACT_NUMBER');
615: x_gen_party_site_number := fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER');
616: x_hz_dup_check := fnd_profile.value('AMS_HZ_DEDUPE_RULE');

Line 1258: FND_API.G_FALSE,

1254: language_rec.application_id := 530;
1255: language_rec.party_id := x_per_party_id;
1256: if (l_rec_update_flag = 'N' or (l_rec_update_flag = 'Y' and x_language_use_reference_id is NULL)) then
1257: HZ_PERSON_INFO_V2PUB.create_person_language(
1258: FND_API.G_FALSE,
1259: language_rec,
1260: x_language_use_reference_id,
1261: x_return_status,
1262: x_msg_count,

Line 1282: FND_API.G_FALSE,

1278:
1279: language_rec.language_use_reference_id := l_language_use_reference_id;
1280:
1281: HZ_PERSON_INFO_V2PUB.update_person_language(
1282: FND_API.G_FALSE,
1283: language_rec,
1284: l_language_obj_number,
1285: x_return_status ,
1286: x_msg_count ,

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 2444: FND_API.G_FALSE,

2440: language_rec.party_id := x_per_party_id;
2441: if (l_rec_update_flag = 'N' or (l_rec_update_flag = 'Y' and x_location_id is NULL)) then
2442:
2443: HZ_PERSON_INFO_V2PUB.create_person_language(
2444: FND_API.G_FALSE,
2445: language_rec,
2446: x_language_use_reference_id,
2447: x_return_status,
2448: x_msg_count,

Line 2476: FND_API.G_FALSE,

2472:
2473: language_rec.language_use_reference_id := l_language_use_reference_id;
2474:
2475: HZ_PERSON_INFO_V2PUB.update_person_language(
2476: FND_API.G_FALSE,
2477: language_rec,
2478: l_language_obj_number,
2479: x_return_status ,
2480: x_msg_count ,

Line 2936: WHEN FND_API.g_exc_error THEN

2932: end if; -- x_b2b = 'N'
2933:
2934: EXCEPTION
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,

Line 2938: x_return_status := FND_API.g_ret_sts_error;

2934: EXCEPTION
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

Line 2940: p_encoded => FND_API.g_false,

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: );
2944:

Line 2945: WHEN FND_API.g_exc_unexpected_error THEN

2941: p_count => x_msg_count,
2942: p_data => x_msg_data
2943: );
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,

Line 2947: x_return_status := FND_API.g_ret_sts_unexp_error ;

2943: );
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

Line 2949: p_encoded => FND_API.g_false,

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: );
2953:

Line 2957: x_return_status := FND_API.g_ret_sts_unexp_error ;

2953:
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:

Line 2963: p_encoded => FND_API.g_false,

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: );
2967:

Line 3086: x_return_status := FND_API.g_ret_sts_success;

3082:
3083: --
3084: -- Generates the customer key for ORGANIZATION
3085: --
3086: x_return_status := FND_API.g_ret_sts_success;
3087: if p_org_name is not null then
3088: l_party_key := hz_fuzzy_pub.Generate_Key (
3089: p_key_type => 'ORGANIZATION',
3090: p_party_name => p_org_name

Line 3251: x_return_status := FND_API.g_ret_sts_unexp_error ;

3247: end if;
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(

Line 3256: p_encoded => FND_API.g_false,

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: );
3260: end party_echeck;

Line 3268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3264: --
3265:
3266: procedure error_capture (
3267: p_api_version IN NUMBER,
3268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3269: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3270: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
3271: x_return_status OUT NOCOPY VARCHAR2,
3272: x_msg_count OUT NOCOPY NUMBER,

Line 3269: p_commit IN VARCHAR2 := FND_API.G_FALSE,

3265:
3266: procedure error_capture (
3267: p_api_version IN NUMBER,
3268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3269: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3270: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
3271: x_return_status OUT NOCOPY VARCHAR2,
3272: x_msg_count OUT NOCOPY NUMBER,
3273: x_msg_data OUT NOCOPY VARCHAR2,

Line 3270: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

3266: procedure error_capture (
3267: p_api_version IN NUMBER,
3268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3269: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3270: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
3271: x_return_status OUT NOCOPY VARCHAR2,
3272: x_msg_count OUT NOCOPY NUMBER,
3273: x_msg_data OUT NOCOPY VARCHAR2,
3274: p_import_list_header_id IN NUMBER,

Line 3331: IF FND_API.to_boolean(p_init_msg_list) THEN

3327: begin
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;

Line 3540: IF FND_API.to_boolean(p_commit) THEN

3536:
3537: end if;
3538:
3539:
3540: IF FND_API.to_boolean(p_commit) THEN
3541: COMMIT;
3542: END IF;
3543: x_return_status := FND_API.g_ret_sts_success;
3544:

Line 3543: x_return_status := FND_API.g_ret_sts_success;

3539:
3540: IF FND_API.to_boolean(p_commit) THEN
3541: COMMIT;
3542: END IF;
3543: x_return_status := FND_API.g_ret_sts_success;
3544:
3545: EXCEPTION
3546:
3547: WHEN FND_API.g_exc_error THEN

Line 3547: WHEN FND_API.g_exc_error THEN

3543: x_return_status := FND_API.g_ret_sts_success;
3544:
3545: EXCEPTION
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,

Line 3549: x_return_status := FND_API.g_ret_sts_error;

3545: EXCEPTION
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

Line 3551: p_encoded => FND_API.g_false,

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: );
3555:

Line 3556: WHEN FND_API.g_exc_unexpected_error THEN

3552: p_count => x_msg_count,
3553: p_data => x_msg_data
3554: );
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,

Line 3558: x_return_status := FND_API.g_ret_sts_unexp_error ;

3554: );
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

Line 3560: p_encoded => FND_API.g_false,

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: );
3564:

Line 3567: x_return_status := FND_API.g_ret_sts_unexp_error ;

3563: );
3564:
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;

Line 3574: p_encoded => FND_API.g_false,

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: );
3578:

Line 3829: x_return_status := FND_API.g_ret_sts_success;

3825: and cpoint.status = 'A';
3826:
3827:
3828: begin
3829: x_return_status := FND_API.g_ret_sts_success;
3830: --
3831: -- Generates the customer key for PERSON
3832: --
3833: if p_per_last_name is not null and p_per_first_name is not null then

Line 3955: x_return_status := FND_API.g_ret_sts_unexp_error ;

3951:
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(

Line 3960: p_encoded => FND_API.g_false,

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: );
3964:

Line 4043: x_return_status := FND_API.g_ret_sts_success;

4039: and COL29 = p_phone_number
4040: and COL30 = p_phone_extension;
4041:
4042: begin
4043: x_return_status := FND_API.g_ret_sts_success;
4044: --
4045: -- Generates the customer key for PERSON
4046: --
4047: if p_per_last_name is not null and p_per_first_name is not null then

Line 4104: x_return_status := FND_API.g_ret_sts_unexp_error ;

4100:
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(

Line 4109: p_encoded => FND_API.g_false,

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: );
4113:

Line 4473: x_return_status := FND_API.g_ret_sts_success;

4469:
4470:
4471: begin
4472:
4473: x_return_status := FND_API.g_ret_sts_success;
4474: --
4475: -- Generates the customer key for PERSON
4476: --
4477: if p_per_last_name is not null and p_per_first_name is not null then

Line 4586: x_return_status := FND_API.g_ret_sts_unexp_error ;

4582: end if;
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(

Line 4591: p_encoded => FND_API.g_false,

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: );
4595:

Line 4763: x_return_status := FND_API.g_ret_sts_success;

4759: where hr.party_id = c_rel_party_id
4760: and hr.relationship_code = 'CONTACT_OF';
4761: begin
4762:
4763: x_return_status := FND_API.g_ret_sts_success;
4764: --
4765: -- Generates the customer key for PERSON
4766: --
4767: if p_per_last_name is not null and p_per_first_name is not null then

Line 4876: x_return_status := FND_API.g_ret_sts_unexp_error ;

4872: end if;
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(

Line 4881: p_encoded => FND_API.g_false,

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: );
4885:

Line 4938: x_return_status := FND_API.g_ret_sts_success;

4934: where customer_key = l_party_key
4935: and party_type = 'PERSON';
4936: begin
4937:
4938: x_return_status := FND_API.g_ret_sts_success;
4939: --
4940: -- Generates the customer key for PERSON
4941: --
4942: if p_per_last_name is not null and p_per_first_name is not null then

Line 4994: x_return_status := FND_API.g_ret_sts_unexp_error ;

4990: end if;
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(

Line 4999: p_encoded => FND_API.g_false,

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: );
5003:

Line 5011: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

5007: -- This progam updates the party for the rented list
5008: --
5009: PROCEDURE update_rented_list_party (
5010: p_api_version IN NUMBER,
5011: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5012: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5013: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
5014: x_return_status OUT NOCOPY VARCHAR2,
5015: x_msg_count OUT NOCOPY NUMBER,

Line 5012: p_commit IN VARCHAR2 := FND_API.G_FALSE,

5008: --
5009: PROCEDURE update_rented_list_party (
5010: p_api_version IN NUMBER,
5011: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5012: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5013: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
5014: x_return_status OUT NOCOPY VARCHAR2,
5015: x_msg_count OUT NOCOPY NUMBER,
5016: x_msg_data OUT NOCOPY VARCHAR2,

Line 5013: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

5009: PROCEDURE update_rented_list_party (
5010: p_api_version IN NUMBER,
5011: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5012: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5013: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
5014: x_return_status OUT NOCOPY VARCHAR2,
5015: x_msg_count OUT NOCOPY NUMBER,
5016: x_msg_data OUT NOCOPY VARCHAR2,
5017: p_party_id IN NUMBER

Line 5023: IF FND_API.to_boolean(p_init_msg_list) THEN

5019:
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.

Line 5034: IF x_return_status = FND_API.g_ret_sts_error THEN

5030: p_return_status => x_return_status,
5031: p_msg_count => x_msg_count,
5032: p_msg_data => x_msg_data);
5033:
5034: IF x_return_status = FND_API.g_ret_sts_error THEN
5035: RAISE FND_API.g_exc_error;
5036: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5037: RAISE FND_API.g_exc_unexpected_error;
5038: END IF;

Line 5035: RAISE FND_API.g_exc_error;

5031: p_msg_count => x_msg_count,
5032: p_msg_data => x_msg_data);
5033:
5034: IF x_return_status = FND_API.g_ret_sts_error THEN
5035: RAISE FND_API.g_exc_error;
5036: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5037: RAISE FND_API.g_exc_unexpected_error;
5038: END IF;
5039:

Line 5036: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

5032: p_msg_data => x_msg_data);
5033:
5034: IF x_return_status = FND_API.g_ret_sts_error THEN
5035: RAISE FND_API.g_exc_error;
5036: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5037: RAISE FND_API.g_exc_unexpected_error;
5038: END IF;
5039:
5040: IF FND_API.to_boolean(p_commit) THEN

Line 5037: RAISE FND_API.g_exc_unexpected_error;

5033:
5034: IF x_return_status = FND_API.g_ret_sts_error THEN
5035: RAISE FND_API.g_exc_error;
5036: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5037: RAISE FND_API.g_exc_unexpected_error;
5038: END IF;
5039:
5040: IF FND_API.to_boolean(p_commit) THEN
5041: COMMIT;

Line 5040: IF FND_API.to_boolean(p_commit) THEN

5036: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5037: RAISE FND_API.g_exc_unexpected_error;
5038: END IF;
5039:
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(

Line 5043: x_return_status := FND_API.g_ret_sts_success;

5039:
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

Line 5045: p_encoded => FND_API.g_false,

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: );
5049: EXCEPTION

Line 5051: WHEN FND_API.g_exc_error THEN

5047: p_data => x_msg_data
5048: );
5049: EXCEPTION
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,

Line 5053: x_return_status := FND_API.g_ret_sts_error;

5049: EXCEPTION
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

Line 5055: p_encoded => FND_API.g_false,

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: );
5059:

Line 5060: WHEN FND_API.g_exc_unexpected_error THEN

5056: p_count => x_msg_count,
5057: p_data => x_msg_data
5058: );
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,

Line 5062: x_return_status := FND_API.g_ret_sts_unexp_error ;

5058: );
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

Line 5064: p_encoded => FND_API.g_false,

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: );
5068:

Line 5071: x_return_status := FND_API.g_ret_sts_unexp_error ;

5067: );
5068:
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;

Line 5078: p_encoded => FND_API.g_false,

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: );
5082: