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

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

Line 1278: FND_API.G_FALSE,

1274:
1275: language_rec.language_use_reference_id := l_language_use_reference_id;
1276:
1277: HZ_PERSON_INFO_V2PUB.update_person_language(
1278: FND_API.G_FALSE,
1279: language_rec,
1280: l_language_obj_number,
1281: x_return_status ,
1282: x_msg_count ,

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

2433: language_rec.party_id := x_per_party_id;
2434: if (l_rec_update_flag = 'N' or (l_rec_update_flag = 'Y' and x_location_id is NULL)) then
2435:
2436: HZ_PERSON_INFO_V2PUB.create_person_language(
2437: FND_API.G_FALSE,
2438: language_rec,
2439: x_language_use_reference_id,
2440: x_return_status,
2441: x_msg_count,

Line 2469: FND_API.G_FALSE,

2465:
2466: language_rec.language_use_reference_id := l_language_use_reference_id;
2467:
2468: HZ_PERSON_INFO_V2PUB.update_person_language(
2469: FND_API.G_FALSE,
2470: language_rec,
2471: l_language_obj_number,
2472: x_return_status ,
2473: x_msg_count ,

Line 2929: WHEN FND_API.g_exc_error THEN

2925: end if; -- x_b2b = 'N'
2926:
2927: EXCEPTION
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,

Line 2931: x_return_status := FND_API.g_ret_sts_error;

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

Line 2933: p_encoded => FND_API.g_false,

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

Line 2938: WHEN FND_API.g_exc_unexpected_error THEN

2934: p_count => x_msg_count,
2935: p_data => x_msg_data
2936: );
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,

Line 2940: x_return_status := FND_API.g_ret_sts_unexp_error ;

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

Line 2942: p_encoded => FND_API.g_false,

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

Line 2950: x_return_status := FND_API.g_ret_sts_unexp_error ;

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

Line 2956: p_encoded => FND_API.g_false,

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

Line 3079: x_return_status := FND_API.g_ret_sts_success;

3075:
3076: --
3077: -- Generates the customer key for ORGANIZATION
3078: --
3079: x_return_status := FND_API.g_ret_sts_success;
3080: if p_org_name is not null then
3081: l_party_key := hz_fuzzy_pub.Generate_Key (
3082: p_key_type => 'ORGANIZATION',
3083: p_party_name => p_org_name

Line 3244: x_return_status := FND_API.g_ret_sts_unexp_error ;

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

Line 3249: p_encoded => FND_API.g_false,

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

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

3257: --
3258:
3259: procedure error_capture (
3260: p_api_version IN NUMBER,
3261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3263: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
3264: x_return_status OUT NOCOPY VARCHAR2,
3265: x_msg_count OUT NOCOPY NUMBER,

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

3258:
3259: procedure error_capture (
3260: p_api_version IN NUMBER,
3261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3263: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
3264: x_return_status OUT NOCOPY VARCHAR2,
3265: x_msg_count OUT NOCOPY NUMBER,
3266: x_msg_data OUT NOCOPY VARCHAR2,

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

3259: procedure error_capture (
3260: p_api_version IN NUMBER,
3261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3263: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
3264: x_return_status OUT NOCOPY VARCHAR2,
3265: x_msg_count OUT NOCOPY NUMBER,
3266: x_msg_data OUT NOCOPY VARCHAR2,
3267: p_import_list_header_id IN NUMBER,

Line 3324: IF FND_API.to_boolean(p_init_msg_list) THEN

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

Line 3533: IF FND_API.to_boolean(p_commit) THEN

3529:
3530: end if;
3531:
3532:
3533: IF FND_API.to_boolean(p_commit) THEN
3534: COMMIT;
3535: END IF;
3536: x_return_status := FND_API.g_ret_sts_success;
3537:

Line 3536: x_return_status := FND_API.g_ret_sts_success;

3532:
3533: IF FND_API.to_boolean(p_commit) THEN
3534: COMMIT;
3535: END IF;
3536: x_return_status := FND_API.g_ret_sts_success;
3537:
3538: EXCEPTION
3539:
3540: WHEN FND_API.g_exc_error THEN

Line 3540: WHEN FND_API.g_exc_error THEN

3536: x_return_status := FND_API.g_ret_sts_success;
3537:
3538: EXCEPTION
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,

Line 3542: x_return_status := FND_API.g_ret_sts_error;

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

Line 3544: p_encoded => FND_API.g_false,

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

Line 3549: WHEN FND_API.g_exc_unexpected_error THEN

3545: p_count => x_msg_count,
3546: p_data => x_msg_data
3547: );
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,

Line 3551: x_return_status := FND_API.g_ret_sts_unexp_error ;

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

Line 3553: p_encoded => FND_API.g_false,

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

Line 3560: x_return_status := FND_API.g_ret_sts_unexp_error ;

3556: );
3557:
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;

Line 3567: p_encoded => FND_API.g_false,

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

Line 3822: x_return_status := FND_API.g_ret_sts_success;

3818: and cpoint.status = 'A';
3819:
3820:
3821: begin
3822: x_return_status := FND_API.g_ret_sts_success;
3823: --
3824: -- Generates the customer key for PERSON
3825: --
3826: if p_per_last_name is not null and p_per_first_name is not null then

Line 3948: x_return_status := FND_API.g_ret_sts_unexp_error ;

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

Line 3953: p_encoded => FND_API.g_false,

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

Line 4036: x_return_status := FND_API.g_ret_sts_success;

4032: and COL29 = p_phone_number
4033: and COL30 = p_phone_extension;
4034:
4035: begin
4036: x_return_status := FND_API.g_ret_sts_success;
4037: --
4038: -- Generates the customer key for PERSON
4039: --
4040: if p_per_last_name is not null and p_per_first_name is not null then

Line 4097: x_return_status := FND_API.g_ret_sts_unexp_error ;

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

Line 4102: p_encoded => FND_API.g_false,

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

Line 4466: x_return_status := FND_API.g_ret_sts_success;

4462:
4463:
4464: begin
4465:
4466: x_return_status := FND_API.g_ret_sts_success;
4467: --
4468: -- Generates the customer key for PERSON
4469: --
4470: if p_per_last_name is not null and p_per_first_name is not null then

Line 4579: x_return_status := FND_API.g_ret_sts_unexp_error ;

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

Line 4584: p_encoded => FND_API.g_false,

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

Line 4756: x_return_status := FND_API.g_ret_sts_success;

4752: where hr.party_id = c_rel_party_id
4753: and hr.relationship_code = 'CONTACT_OF';
4754: begin
4755:
4756: x_return_status := FND_API.g_ret_sts_success;
4757: --
4758: -- Generates the customer key for PERSON
4759: --
4760: if p_per_last_name is not null and p_per_first_name is not null then

Line 4869: x_return_status := FND_API.g_ret_sts_unexp_error ;

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

Line 4874: p_encoded => FND_API.g_false,

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

Line 4931: x_return_status := FND_API.g_ret_sts_success;

4927: where customer_key = l_party_key
4928: and party_type = 'PERSON';
4929: begin
4930:
4931: x_return_status := FND_API.g_ret_sts_success;
4932: --
4933: -- Generates the customer key for PERSON
4934: --
4935: if p_per_last_name is not null and p_per_first_name is not null then

Line 4987: x_return_status := FND_API.g_ret_sts_unexp_error ;

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

Line 4992: p_encoded => FND_API.g_false,

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

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

5000: -- This progam updates the party for the rented list
5001: --
5002: PROCEDURE update_rented_list_party (
5003: p_api_version IN NUMBER,
5004: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5005: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5006: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
5007: x_return_status OUT NOCOPY VARCHAR2,
5008: x_msg_count OUT NOCOPY NUMBER,

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

5001: --
5002: PROCEDURE update_rented_list_party (
5003: p_api_version IN NUMBER,
5004: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5005: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5006: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
5007: x_return_status OUT NOCOPY VARCHAR2,
5008: x_msg_count OUT NOCOPY NUMBER,
5009: x_msg_data OUT NOCOPY VARCHAR2,

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

5002: PROCEDURE update_rented_list_party (
5003: p_api_version IN NUMBER,
5004: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5005: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5006: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
5007: x_return_status OUT NOCOPY VARCHAR2,
5008: x_msg_count OUT NOCOPY NUMBER,
5009: x_msg_data OUT NOCOPY VARCHAR2,
5010: p_party_id IN NUMBER

Line 5016: IF FND_API.to_boolean(p_init_msg_list) THEN

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

Line 5027: IF x_return_status = FND_API.g_ret_sts_error THEN

5023: p_return_status => x_return_status,
5024: p_msg_count => x_msg_count,
5025: p_msg_data => x_msg_data);
5026:
5027: IF x_return_status = FND_API.g_ret_sts_error THEN
5028: RAISE FND_API.g_exc_error;
5029: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5030: RAISE FND_API.g_exc_unexpected_error;
5031: END IF;

Line 5028: RAISE FND_API.g_exc_error;

5024: p_msg_count => x_msg_count,
5025: p_msg_data => x_msg_data);
5026:
5027: IF x_return_status = FND_API.g_ret_sts_error THEN
5028: RAISE FND_API.g_exc_error;
5029: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5030: RAISE FND_API.g_exc_unexpected_error;
5031: END IF;
5032:

Line 5029: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

5025: p_msg_data => x_msg_data);
5026:
5027: IF x_return_status = FND_API.g_ret_sts_error THEN
5028: RAISE FND_API.g_exc_error;
5029: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5030: RAISE FND_API.g_exc_unexpected_error;
5031: END IF;
5032:
5033: IF FND_API.to_boolean(p_commit) THEN

Line 5030: RAISE FND_API.g_exc_unexpected_error;

5026:
5027: IF x_return_status = FND_API.g_ret_sts_error THEN
5028: RAISE FND_API.g_exc_error;
5029: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5030: RAISE FND_API.g_exc_unexpected_error;
5031: END IF;
5032:
5033: IF FND_API.to_boolean(p_commit) THEN
5034: COMMIT;

Line 5033: IF FND_API.to_boolean(p_commit) THEN

5029: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5030: RAISE FND_API.g_exc_unexpected_error;
5031: END IF;
5032:
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(

Line 5036: x_return_status := FND_API.g_ret_sts_success;

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

Line 5038: p_encoded => FND_API.g_false,

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

Line 5044: WHEN FND_API.g_exc_error THEN

5040: p_data => x_msg_data
5041: );
5042: EXCEPTION
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,

Line 5046: x_return_status := FND_API.g_ret_sts_error;

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

Line 5048: p_encoded => FND_API.g_false,

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

Line 5053: WHEN FND_API.g_exc_unexpected_error THEN

5049: p_count => x_msg_count,
5050: p_data => x_msg_data
5051: );
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,

Line 5055: x_return_status := FND_API.g_ret_sts_unexp_error ;

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

Line 5057: p_encoded => FND_API.g_false,

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

Line 5064: x_return_status := FND_API.g_ret_sts_unexp_error ;

5060: );
5061:
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;

Line 5071: p_encoded => FND_API.g_false,

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