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.IGI_STP_TABLE_HANDLER_PKG dependencies on FND_API

Line 134: p_init_msg_list => fnd_api.g_false,

130:
131:
132: hz_location_v2pub.create_location
133: (
134: p_init_msg_list => fnd_api.g_false,
135: p_location_rec => l_location_rec,
136: x_location_id => l_loc_id,
137: x_return_status => l_return_status,
138: x_msg_count => l_msg_count,

Line 157: p_init_msg_list => fnd_api.g_false,

153: -- Bug 2037659 Fix
154: /*
155: hz_tax_assignment_v2pub.create_loc_assignment
156: (
157: p_init_msg_list => fnd_api.g_false,
158: p_location_id => l_loc_id,
159: p_lock_flag => fnd_api.g_false,
160: p_created_by_module => 'IGI_STP',
161: p_application_id => l_application_id,

Line 159: p_lock_flag => fnd_api.g_false,

155: hz_tax_assignment_v2pub.create_loc_assignment
156: (
157: p_init_msg_list => fnd_api.g_false,
158: p_location_id => l_loc_id,
159: p_lock_flag => fnd_api.g_false,
160: p_created_by_module => 'IGI_STP',
161: p_application_id => l_application_id,
162: x_return_status => l_return_status,
163: x_msg_count => l_msg_count,

Line 201: p_init_msg_list => fnd_api.g_true,

197: l_party_site_rec.created_by_module := 'IGI_STP';
198:
199: hz_party_site_v2pub.create_party_site
200: (
201: p_init_msg_list => fnd_api.g_true,
202: p_party_site_rec => l_party_site_rec,
203: x_party_site_id => l_party_site_id,
204: x_party_site_number => l_party_site_number,
205: x_return_status => l_return_status,

Line 221: p_init_msg_list => fnd_api.g_false,

217:
218:
219: hz_cust_account_site_v2pub.create_cust_acct_site
220: (
221: p_init_msg_list => fnd_api.g_false,
222: p_cust_acct_site_rec => l_cust_acct_site_rec,
223: x_cust_acct_site_id => l_cust_acct_site_id,
224: x_return_status => l_return_status,
225: x_msg_count => l_msg_count,

Line 373: l_location_rec.address2 := NVL(x_address2, fnd_api.g_miss_char);

369: --Modified for bug # 5263736
370: l_location_rec.location_id := l_location_id;
371: l_location_rec.country := x_country;
372: l_location_rec.address1 := x_address1;
373: l_location_rec.address2 := NVL(x_address2, fnd_api.g_miss_char);
374: l_location_rec.address3 := NVL(x_address3, fnd_api.g_miss_char);
375: l_location_rec.address4 := NVL(x_address4, fnd_api.g_miss_char);
376: l_location_rec.city := NVL(x_city, fnd_api.g_miss_char);
377: l_location_rec.postal_code := NVL(x_postal_code, fnd_api.g_miss_char);

Line 374: l_location_rec.address3 := NVL(x_address3, fnd_api.g_miss_char);

370: l_location_rec.location_id := l_location_id;
371: l_location_rec.country := x_country;
372: l_location_rec.address1 := x_address1;
373: l_location_rec.address2 := NVL(x_address2, fnd_api.g_miss_char);
374: l_location_rec.address3 := NVL(x_address3, fnd_api.g_miss_char);
375: l_location_rec.address4 := NVL(x_address4, fnd_api.g_miss_char);
376: l_location_rec.city := NVL(x_city, fnd_api.g_miss_char);
377: l_location_rec.postal_code := NVL(x_postal_code, fnd_api.g_miss_char);
378: l_location_rec.state := NVL(x_state, fnd_api.g_miss_char);

Line 375: l_location_rec.address4 := NVL(x_address4, fnd_api.g_miss_char);

371: l_location_rec.country := x_country;
372: l_location_rec.address1 := x_address1;
373: l_location_rec.address2 := NVL(x_address2, fnd_api.g_miss_char);
374: l_location_rec.address3 := NVL(x_address3, fnd_api.g_miss_char);
375: l_location_rec.address4 := NVL(x_address4, fnd_api.g_miss_char);
376: l_location_rec.city := NVL(x_city, fnd_api.g_miss_char);
377: l_location_rec.postal_code := NVL(x_postal_code, fnd_api.g_miss_char);
378: l_location_rec.state := NVL(x_state, fnd_api.g_miss_char);
379: l_location_rec.province := NVL(x_province, fnd_api.g_miss_char);

Line 376: l_location_rec.city := NVL(x_city, fnd_api.g_miss_char);

372: l_location_rec.address1 := x_address1;
373: l_location_rec.address2 := NVL(x_address2, fnd_api.g_miss_char);
374: l_location_rec.address3 := NVL(x_address3, fnd_api.g_miss_char);
375: l_location_rec.address4 := NVL(x_address4, fnd_api.g_miss_char);
376: l_location_rec.city := NVL(x_city, fnd_api.g_miss_char);
377: l_location_rec.postal_code := NVL(x_postal_code, fnd_api.g_miss_char);
378: l_location_rec.state := NVL(x_state, fnd_api.g_miss_char);
379: l_location_rec.province := NVL(x_province, fnd_api.g_miss_char);
380: l_location_rec.county := NVL(x_county, fnd_api.g_miss_char);

Line 377: l_location_rec.postal_code := NVL(x_postal_code, fnd_api.g_miss_char);

373: l_location_rec.address2 := NVL(x_address2, fnd_api.g_miss_char);
374: l_location_rec.address3 := NVL(x_address3, fnd_api.g_miss_char);
375: l_location_rec.address4 := NVL(x_address4, fnd_api.g_miss_char);
376: l_location_rec.city := NVL(x_city, fnd_api.g_miss_char);
377: l_location_rec.postal_code := NVL(x_postal_code, fnd_api.g_miss_char);
378: l_location_rec.state := NVL(x_state, fnd_api.g_miss_char);
379: l_location_rec.province := NVL(x_province, fnd_api.g_miss_char);
380: l_location_rec.county := NVL(x_county, fnd_api.g_miss_char);
381: l_location_rec.language := NVL(x_language, fnd_api.g_miss_char);

Line 378: l_location_rec.state := NVL(x_state, fnd_api.g_miss_char);

374: l_location_rec.address3 := NVL(x_address3, fnd_api.g_miss_char);
375: l_location_rec.address4 := NVL(x_address4, fnd_api.g_miss_char);
376: l_location_rec.city := NVL(x_city, fnd_api.g_miss_char);
377: l_location_rec.postal_code := NVL(x_postal_code, fnd_api.g_miss_char);
378: l_location_rec.state := NVL(x_state, fnd_api.g_miss_char);
379: l_location_rec.province := NVL(x_province, fnd_api.g_miss_char);
380: l_location_rec.county := NVL(x_county, fnd_api.g_miss_char);
381: l_location_rec.language := NVL(x_language, fnd_api.g_miss_char);
382: l_location_rec.address_lines_phonetic := NVL(x_address_lines_phonetic, fnd_api.g_miss_char);

Line 379: l_location_rec.province := NVL(x_province, fnd_api.g_miss_char);

375: l_location_rec.address4 := NVL(x_address4, fnd_api.g_miss_char);
376: l_location_rec.city := NVL(x_city, fnd_api.g_miss_char);
377: l_location_rec.postal_code := NVL(x_postal_code, fnd_api.g_miss_char);
378: l_location_rec.state := NVL(x_state, fnd_api.g_miss_char);
379: l_location_rec.province := NVL(x_province, fnd_api.g_miss_char);
380: l_location_rec.county := NVL(x_county, fnd_api.g_miss_char);
381: l_location_rec.language := NVL(x_language, fnd_api.g_miss_char);
382: l_location_rec.address_lines_phonetic := NVL(x_address_lines_phonetic, fnd_api.g_miss_char);
383: --Modified for bug # 5263736

Line 380: l_location_rec.county := NVL(x_county, fnd_api.g_miss_char);

376: l_location_rec.city := NVL(x_city, fnd_api.g_miss_char);
377: l_location_rec.postal_code := NVL(x_postal_code, fnd_api.g_miss_char);
378: l_location_rec.state := NVL(x_state, fnd_api.g_miss_char);
379: l_location_rec.province := NVL(x_province, fnd_api.g_miss_char);
380: l_location_rec.county := NVL(x_county, fnd_api.g_miss_char);
381: l_location_rec.language := NVL(x_language, fnd_api.g_miss_char);
382: l_location_rec.address_lines_phonetic := NVL(x_address_lines_phonetic, fnd_api.g_miss_char);
383: --Modified for bug # 5263736
384:

Line 381: l_location_rec.language := NVL(x_language, fnd_api.g_miss_char);

377: l_location_rec.postal_code := NVL(x_postal_code, fnd_api.g_miss_char);
378: l_location_rec.state := NVL(x_state, fnd_api.g_miss_char);
379: l_location_rec.province := NVL(x_province, fnd_api.g_miss_char);
380: l_location_rec.county := NVL(x_county, fnd_api.g_miss_char);
381: l_location_rec.language := NVL(x_language, fnd_api.g_miss_char);
382: l_location_rec.address_lines_phonetic := NVL(x_address_lines_phonetic, fnd_api.g_miss_char);
383: --Modified for bug # 5263736
384:
385:

Line 382: l_location_rec.address_lines_phonetic := NVL(x_address_lines_phonetic, fnd_api.g_miss_char);

378: l_location_rec.state := NVL(x_state, fnd_api.g_miss_char);
379: l_location_rec.province := NVL(x_province, fnd_api.g_miss_char);
380: l_location_rec.county := NVL(x_county, fnd_api.g_miss_char);
381: l_location_rec.language := NVL(x_language, fnd_api.g_miss_char);
382: l_location_rec.address_lines_phonetic := NVL(x_address_lines_phonetic, fnd_api.g_miss_char);
383: --Modified for bug # 5263736
384:
385:
386: OPEN C_PARTY;

Line 408: l_cust_acct_site_rec.cust_acct_site_id := NVL(l_cust_acct_site_id, fnd_api.g_miss_num);

404: END IF;
405: CLOSE C_CUST_ACCT;
406:
407: --Modified for bug # 5263736
408: l_cust_acct_site_rec.cust_acct_site_id := NVL(l_cust_acct_site_id, fnd_api.g_miss_num);
409: l_cust_acct_site_rec.status := X_status;
410: l_cust_acct_site_rec.language := NVL(X_language, fnd_api.g_miss_char);
411: l_cust_acct_site_rec.customer_category_code := NVL(X_customer_category_code, fnd_api.g_miss_char);
412: l_cust_acct_site_rec.ece_tp_location_code := NVL(X_ece_tp_location_code, fnd_api.g_miss_char);

Line 410: l_cust_acct_site_rec.language := NVL(X_language, fnd_api.g_miss_char);

406:
407: --Modified for bug # 5263736
408: l_cust_acct_site_rec.cust_acct_site_id := NVL(l_cust_acct_site_id, fnd_api.g_miss_num);
409: l_cust_acct_site_rec.status := X_status;
410: l_cust_acct_site_rec.language := NVL(X_language, fnd_api.g_miss_char);
411: l_cust_acct_site_rec.customer_category_code := NVL(X_customer_category_code, fnd_api.g_miss_char);
412: l_cust_acct_site_rec.ece_tp_location_code := NVL(X_ece_tp_location_code, fnd_api.g_miss_char);
413: --Modified for bug # 5263736
414:

Line 411: l_cust_acct_site_rec.customer_category_code := NVL(X_customer_category_code, fnd_api.g_miss_char);

407: --Modified for bug # 5263736
408: l_cust_acct_site_rec.cust_acct_site_id := NVL(l_cust_acct_site_id, fnd_api.g_miss_num);
409: l_cust_acct_site_rec.status := X_status;
410: l_cust_acct_site_rec.language := NVL(X_language, fnd_api.g_miss_char);
411: l_cust_acct_site_rec.customer_category_code := NVL(X_customer_category_code, fnd_api.g_miss_char);
412: l_cust_acct_site_rec.ece_tp_location_code := NVL(X_ece_tp_location_code, fnd_api.g_miss_char);
413: --Modified for bug # 5263736
414:
415: OPEN c_obj_version_loc (l_location_id);

Line 412: l_cust_acct_site_rec.ece_tp_location_code := NVL(X_ece_tp_location_code, fnd_api.g_miss_char);

408: l_cust_acct_site_rec.cust_acct_site_id := NVL(l_cust_acct_site_id, fnd_api.g_miss_num);
409: l_cust_acct_site_rec.status := X_status;
410: l_cust_acct_site_rec.language := NVL(X_language, fnd_api.g_miss_char);
411: l_cust_acct_site_rec.customer_category_code := NVL(X_customer_category_code, fnd_api.g_miss_char);
412: l_cust_acct_site_rec.ece_tp_location_code := NVL(X_ece_tp_location_code, fnd_api.g_miss_char);
413: --Modified for bug # 5263736
414:
415: OPEN c_obj_version_loc (l_location_id);
416: FETCH c_obj_version_loc INTO l_object_version_number;

Line 424: p_init_msg_list => fnd_api.g_false,

420:
421:
422: hz_location_v2pub.update_location
423: (
424: p_init_msg_list => fnd_api.g_false,
425: p_location_rec => l_location_rec,
426: p_object_version_number => l_object_version_number,
427: X_return_status => l_return_status,
428: X_msg_count => l_msg_count,

Line 437: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

433:
434:
435:
436: --Added for bug 5263736
437: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
438: RETURN;
439: END IF;
440: --Added for bug 5263736
441: /* Since the same local variable is used for capturing object version numbers of hz_locations and hz_party_sites first nullify it */

Line 451: p_init_msg_list => fnd_api.g_false,

447: CLOSE c_obj_version_site;
448:
449: hz_party_site_v2pub.update_party_site
450: (
451: p_init_msg_list => fnd_api.g_false,
452: p_party_site_rec => l_party_site_rec,
453: p_object_version_number => l_object_version_number,
454: x_return_status => l_return_status,
455: x_msg_count => l_msg_count,

Line 469: p_init_msg_list => fnd_api.g_false,

465: CLOSE c_obj_version_cust_acct;
466:
467: hz_cust_account_site_v2pub.update_cust_acct_site
468: (
469: p_init_msg_list => fnd_api.g_false,
470: p_cust_acct_site_rec => l_cust_acct_site_rec,
471: p_object_version_number => l_object_version_number,
472: x_return_status => l_return_status,
473: x_msg_count => l_msg_count,

Line 795: p_init_msg_list => FND_API.G_TRUE,

791:
792:
793: AP_VENDOR_PUB_PKG.Create_Vendor_Site
794: (p_api_version => 1.0,
795: p_init_msg_list => FND_API.G_TRUE,
796: p_commit =>FND_API.G_FALSE,
797: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
798: x_return_status => l_return_status,
799: x_msg_count => l_msg_count,

Line 796: p_commit =>FND_API.G_FALSE,

792:
793: AP_VENDOR_PUB_PKG.Create_Vendor_Site
794: (p_api_version => 1.0,
795: p_init_msg_list => FND_API.G_TRUE,
796: p_commit =>FND_API.G_FALSE,
797: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
798: x_return_status => l_return_status,
799: x_msg_count => l_msg_count,
800: x_msg_data => l_msg_data,

Line 797: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

793: AP_VENDOR_PUB_PKG.Create_Vendor_Site
794: (p_api_version => 1.0,
795: p_init_msg_list => FND_API.G_TRUE,
796: p_commit =>FND_API.G_FALSE,
797: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
798: x_return_status => l_return_status,
799: x_msg_count => l_msg_count,
800: x_msg_data => l_msg_data,
801: p_vendor_site_rec => l_vendor_site_rec,

Line 895: l_location_rec.country := NVL(X_country,fnd_api.g_miss_char);

891: CLOSE C_LOC;
892:
893:
894: l_location_rec.location_id := l_location_id;
895: l_location_rec.country := NVL(X_country,fnd_api.g_miss_char);
896: l_location_rec.address1 := NVL(X_address_line1,fnd_api.g_miss_char);
897: l_location_rec.address2 := NVL(X_address_line2,fnd_api.g_miss_char);
898: l_location_rec.address3 := NVL(X_address_line3,fnd_api.g_miss_char);
899: l_location_rec.address4 := NVL(X_address_line4,fnd_api.g_miss_char);

Line 896: l_location_rec.address1 := NVL(X_address_line1,fnd_api.g_miss_char);

892:
893:
894: l_location_rec.location_id := l_location_id;
895: l_location_rec.country := NVL(X_country,fnd_api.g_miss_char);
896: l_location_rec.address1 := NVL(X_address_line1,fnd_api.g_miss_char);
897: l_location_rec.address2 := NVL(X_address_line2,fnd_api.g_miss_char);
898: l_location_rec.address3 := NVL(X_address_line3,fnd_api.g_miss_char);
899: l_location_rec.address4 := NVL(X_address_line4,fnd_api.g_miss_char);
900: l_location_rec.city := NVL(x_city,fnd_api.g_miss_char);

Line 897: l_location_rec.address2 := NVL(X_address_line2,fnd_api.g_miss_char);

893:
894: l_location_rec.location_id := l_location_id;
895: l_location_rec.country := NVL(X_country,fnd_api.g_miss_char);
896: l_location_rec.address1 := NVL(X_address_line1,fnd_api.g_miss_char);
897: l_location_rec.address2 := NVL(X_address_line2,fnd_api.g_miss_char);
898: l_location_rec.address3 := NVL(X_address_line3,fnd_api.g_miss_char);
899: l_location_rec.address4 := NVL(X_address_line4,fnd_api.g_miss_char);
900: l_location_rec.city := NVL(x_city,fnd_api.g_miss_char);
901: l_location_rec.postal_code := NVL(X_zip,fnd_api.g_miss_char);

Line 898: l_location_rec.address3 := NVL(X_address_line3,fnd_api.g_miss_char);

894: l_location_rec.location_id := l_location_id;
895: l_location_rec.country := NVL(X_country,fnd_api.g_miss_char);
896: l_location_rec.address1 := NVL(X_address_line1,fnd_api.g_miss_char);
897: l_location_rec.address2 := NVL(X_address_line2,fnd_api.g_miss_char);
898: l_location_rec.address3 := NVL(X_address_line3,fnd_api.g_miss_char);
899: l_location_rec.address4 := NVL(X_address_line4,fnd_api.g_miss_char);
900: l_location_rec.city := NVL(x_city,fnd_api.g_miss_char);
901: l_location_rec.postal_code := NVL(X_zip,fnd_api.g_miss_char);
902: l_location_rec.state := NVL(x_state,fnd_api.g_miss_char);

Line 899: l_location_rec.address4 := NVL(X_address_line4,fnd_api.g_miss_char);

895: l_location_rec.country := NVL(X_country,fnd_api.g_miss_char);
896: l_location_rec.address1 := NVL(X_address_line1,fnd_api.g_miss_char);
897: l_location_rec.address2 := NVL(X_address_line2,fnd_api.g_miss_char);
898: l_location_rec.address3 := NVL(X_address_line3,fnd_api.g_miss_char);
899: l_location_rec.address4 := NVL(X_address_line4,fnd_api.g_miss_char);
900: l_location_rec.city := NVL(x_city,fnd_api.g_miss_char);
901: l_location_rec.postal_code := NVL(X_zip,fnd_api.g_miss_char);
902: l_location_rec.state := NVL(x_state,fnd_api.g_miss_char);
903: l_location_rec.province := NVL(x_province,fnd_api.g_miss_char);

Line 900: l_location_rec.city := NVL(x_city,fnd_api.g_miss_char);

896: l_location_rec.address1 := NVL(X_address_line1,fnd_api.g_miss_char);
897: l_location_rec.address2 := NVL(X_address_line2,fnd_api.g_miss_char);
898: l_location_rec.address3 := NVL(X_address_line3,fnd_api.g_miss_char);
899: l_location_rec.address4 := NVL(X_address_line4,fnd_api.g_miss_char);
900: l_location_rec.city := NVL(x_city,fnd_api.g_miss_char);
901: l_location_rec.postal_code := NVL(X_zip,fnd_api.g_miss_char);
902: l_location_rec.state := NVL(x_state,fnd_api.g_miss_char);
903: l_location_rec.province := NVL(x_province,fnd_api.g_miss_char);
904: l_location_rec.county := NVL(x_county,fnd_api.g_miss_char);

Line 901: l_location_rec.postal_code := NVL(X_zip,fnd_api.g_miss_char);

897: l_location_rec.address2 := NVL(X_address_line2,fnd_api.g_miss_char);
898: l_location_rec.address3 := NVL(X_address_line3,fnd_api.g_miss_char);
899: l_location_rec.address4 := NVL(X_address_line4,fnd_api.g_miss_char);
900: l_location_rec.city := NVL(x_city,fnd_api.g_miss_char);
901: l_location_rec.postal_code := NVL(X_zip,fnd_api.g_miss_char);
902: l_location_rec.state := NVL(x_state,fnd_api.g_miss_char);
903: l_location_rec.province := NVL(x_province,fnd_api.g_miss_char);
904: l_location_rec.county := NVL(x_county,fnd_api.g_miss_char);
905: l_location_rec.language := NVL(x_language,fnd_api.g_miss_char);

Line 902: l_location_rec.state := NVL(x_state,fnd_api.g_miss_char);

898: l_location_rec.address3 := NVL(X_address_line3,fnd_api.g_miss_char);
899: l_location_rec.address4 := NVL(X_address_line4,fnd_api.g_miss_char);
900: l_location_rec.city := NVL(x_city,fnd_api.g_miss_char);
901: l_location_rec.postal_code := NVL(X_zip,fnd_api.g_miss_char);
902: l_location_rec.state := NVL(x_state,fnd_api.g_miss_char);
903: l_location_rec.province := NVL(x_province,fnd_api.g_miss_char);
904: l_location_rec.county := NVL(x_county,fnd_api.g_miss_char);
905: l_location_rec.language := NVL(x_language,fnd_api.g_miss_char);
906: --l_location_rec.address_lines_phonetic := NVL(x_address_lines_phonetic,fnd_api.g_miss_char);

Line 903: l_location_rec.province := NVL(x_province,fnd_api.g_miss_char);

899: l_location_rec.address4 := NVL(X_address_line4,fnd_api.g_miss_char);
900: l_location_rec.city := NVL(x_city,fnd_api.g_miss_char);
901: l_location_rec.postal_code := NVL(X_zip,fnd_api.g_miss_char);
902: l_location_rec.state := NVL(x_state,fnd_api.g_miss_char);
903: l_location_rec.province := NVL(x_province,fnd_api.g_miss_char);
904: l_location_rec.county := NVL(x_county,fnd_api.g_miss_char);
905: l_location_rec.language := NVL(x_language,fnd_api.g_miss_char);
906: --l_location_rec.address_lines_phonetic := NVL(x_address_lines_phonetic,fnd_api.g_miss_char);
907:

Line 904: l_location_rec.county := NVL(x_county,fnd_api.g_miss_char);

900: l_location_rec.city := NVL(x_city,fnd_api.g_miss_char);
901: l_location_rec.postal_code := NVL(X_zip,fnd_api.g_miss_char);
902: l_location_rec.state := NVL(x_state,fnd_api.g_miss_char);
903: l_location_rec.province := NVL(x_province,fnd_api.g_miss_char);
904: l_location_rec.county := NVL(x_county,fnd_api.g_miss_char);
905: l_location_rec.language := NVL(x_language,fnd_api.g_miss_char);
906: --l_location_rec.address_lines_phonetic := NVL(x_address_lines_phonetic,fnd_api.g_miss_char);
907:
908:

Line 905: l_location_rec.language := NVL(x_language,fnd_api.g_miss_char);

901: l_location_rec.postal_code := NVL(X_zip,fnd_api.g_miss_char);
902: l_location_rec.state := NVL(x_state,fnd_api.g_miss_char);
903: l_location_rec.province := NVL(x_province,fnd_api.g_miss_char);
904: l_location_rec.county := NVL(x_county,fnd_api.g_miss_char);
905: l_location_rec.language := NVL(x_language,fnd_api.g_miss_char);
906: --l_location_rec.address_lines_phonetic := NVL(x_address_lines_phonetic,fnd_api.g_miss_char);
907:
908:
909: OPEN C_PARTY;

Line 906: --l_location_rec.address_lines_phonetic := NVL(x_address_lines_phonetic,fnd_api.g_miss_char);

902: l_location_rec.state := NVL(x_state,fnd_api.g_miss_char);
903: l_location_rec.province := NVL(x_province,fnd_api.g_miss_char);
904: l_location_rec.county := NVL(x_county,fnd_api.g_miss_char);
905: l_location_rec.language := NVL(x_language,fnd_api.g_miss_char);
906: --l_location_rec.address_lines_phonetic := NVL(x_address_lines_phonetic,fnd_api.g_miss_char);
907:
908:
909: OPEN C_PARTY;
910: FETCH C_PARTY INTO l_party_site_id;

Line 944: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

940: commit;
941:
942:
943:
944: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
945: RETURN;
946: END IF;
947:
948: l_object_version_number := NULL;

Line 957: p_init_msg_list => fnd_api.g_false,

953:
954:
955: hz_party_site_v2pub.update_party_site
956: (
957: p_init_msg_list => fnd_api.g_false,
958: p_party_site_rec => l_party_site_rec,
959: p_object_version_number => l_object_version_number,
960: x_return_status => l_return_status,
961: x_msg_count => l_msg_count,

Line 972: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

968:
969:
970:
971: l_object_version_number := NULL;
972: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
973: RETURN;
974: END IF;
975:
976:

Line 979: l_vendor_site_rec.ADDRESS_LINE1 := NVL(X_address_line1, fnd_api.g_miss_char);

975:
976:
977:
978: /* l_vendor_site_rec.VENDOR_SITE_CODE := x_vendor_site_code ;
979: l_vendor_site_rec.ADDRESS_LINE1 := NVL(X_address_line1, fnd_api.g_miss_char);
980: l_vendor_site_rec.ADDRESS_LINE2 := NVL(X_address_line2, fnd_api.g_miss_char);
981: l_vendor_site_rec.ADDRESS_LINE3 := NVL(X_address_line3, fnd_api.g_miss_char);
982: l_vendor_site_rec.CITY:= NVL(x_city, fnd_api.g_miss_char);
983: l_vendor_site_rec.STATE := NVL(x_state, fnd_api.g_miss_char);

Line 980: l_vendor_site_rec.ADDRESS_LINE2 := NVL(X_address_line2, fnd_api.g_miss_char);

976:
977:
978: /* l_vendor_site_rec.VENDOR_SITE_CODE := x_vendor_site_code ;
979: l_vendor_site_rec.ADDRESS_LINE1 := NVL(X_address_line1, fnd_api.g_miss_char);
980: l_vendor_site_rec.ADDRESS_LINE2 := NVL(X_address_line2, fnd_api.g_miss_char);
981: l_vendor_site_rec.ADDRESS_LINE3 := NVL(X_address_line3, fnd_api.g_miss_char);
982: l_vendor_site_rec.CITY:= NVL(x_city, fnd_api.g_miss_char);
983: l_vendor_site_rec.STATE := NVL(x_state, fnd_api.g_miss_char);
984: l_vendor_site_rec.ZIP := NVL(X_zip, fnd_api.g_miss_char);

Line 981: l_vendor_site_rec.ADDRESS_LINE3 := NVL(X_address_line3, fnd_api.g_miss_char);

977:
978: /* l_vendor_site_rec.VENDOR_SITE_CODE := x_vendor_site_code ;
979: l_vendor_site_rec.ADDRESS_LINE1 := NVL(X_address_line1, fnd_api.g_miss_char);
980: l_vendor_site_rec.ADDRESS_LINE2 := NVL(X_address_line2, fnd_api.g_miss_char);
981: l_vendor_site_rec.ADDRESS_LINE3 := NVL(X_address_line3, fnd_api.g_miss_char);
982: l_vendor_site_rec.CITY:= NVL(x_city, fnd_api.g_miss_char);
983: l_vendor_site_rec.STATE := NVL(x_state, fnd_api.g_miss_char);
984: l_vendor_site_rec.ZIP := NVL(X_zip, fnd_api.g_miss_char);
985: l_vendor_site_rec.PROVINCE := NVL(x_state, fnd_api.g_miss_char);

Line 982: l_vendor_site_rec.CITY:= NVL(x_city, fnd_api.g_miss_char);

978: /* l_vendor_site_rec.VENDOR_SITE_CODE := x_vendor_site_code ;
979: l_vendor_site_rec.ADDRESS_LINE1 := NVL(X_address_line1, fnd_api.g_miss_char);
980: l_vendor_site_rec.ADDRESS_LINE2 := NVL(X_address_line2, fnd_api.g_miss_char);
981: l_vendor_site_rec.ADDRESS_LINE3 := NVL(X_address_line3, fnd_api.g_miss_char);
982: l_vendor_site_rec.CITY:= NVL(x_city, fnd_api.g_miss_char);
983: l_vendor_site_rec.STATE := NVL(x_state, fnd_api.g_miss_char);
984: l_vendor_site_rec.ZIP := NVL(X_zip, fnd_api.g_miss_char);
985: l_vendor_site_rec.PROVINCE := NVL(x_state, fnd_api.g_miss_char);
986: l_vendor_site_rec.COUNTRY := x_country ;

Line 983: l_vendor_site_rec.STATE := NVL(x_state, fnd_api.g_miss_char);

979: l_vendor_site_rec.ADDRESS_LINE1 := NVL(X_address_line1, fnd_api.g_miss_char);
980: l_vendor_site_rec.ADDRESS_LINE2 := NVL(X_address_line2, fnd_api.g_miss_char);
981: l_vendor_site_rec.ADDRESS_LINE3 := NVL(X_address_line3, fnd_api.g_miss_char);
982: l_vendor_site_rec.CITY:= NVL(x_city, fnd_api.g_miss_char);
983: l_vendor_site_rec.STATE := NVL(x_state, fnd_api.g_miss_char);
984: l_vendor_site_rec.ZIP := NVL(X_zip, fnd_api.g_miss_char);
985: l_vendor_site_rec.PROVINCE := NVL(x_state, fnd_api.g_miss_char);
986: l_vendor_site_rec.COUNTRY := x_country ;
987: l_vendor_site_rec.INACTIVE_DATE := x_inactive_date ;

Line 984: l_vendor_site_rec.ZIP := NVL(X_zip, fnd_api.g_miss_char);

980: l_vendor_site_rec.ADDRESS_LINE2 := NVL(X_address_line2, fnd_api.g_miss_char);
981: l_vendor_site_rec.ADDRESS_LINE3 := NVL(X_address_line3, fnd_api.g_miss_char);
982: l_vendor_site_rec.CITY:= NVL(x_city, fnd_api.g_miss_char);
983: l_vendor_site_rec.STATE := NVL(x_state, fnd_api.g_miss_char);
984: l_vendor_site_rec.ZIP := NVL(X_zip, fnd_api.g_miss_char);
985: l_vendor_site_rec.PROVINCE := NVL(x_state, fnd_api.g_miss_char);
986: l_vendor_site_rec.COUNTRY := x_country ;
987: l_vendor_site_rec.INACTIVE_DATE := x_inactive_date ;
988: l_vendor_site_rec.ORG_ID := X_org_id ;

Line 985: l_vendor_site_rec.PROVINCE := NVL(x_state, fnd_api.g_miss_char);

981: l_vendor_site_rec.ADDRESS_LINE3 := NVL(X_address_line3, fnd_api.g_miss_char);
982: l_vendor_site_rec.CITY:= NVL(x_city, fnd_api.g_miss_char);
983: l_vendor_site_rec.STATE := NVL(x_state, fnd_api.g_miss_char);
984: l_vendor_site_rec.ZIP := NVL(X_zip, fnd_api.g_miss_char);
985: l_vendor_site_rec.PROVINCE := NVL(x_state, fnd_api.g_miss_char);
986: l_vendor_site_rec.COUNTRY := x_country ;
987: l_vendor_site_rec.INACTIVE_DATE := x_inactive_date ;
988: l_vendor_site_rec.ORG_ID := X_org_id ;
989: l_vendor_site_rec.ADDRESS_LINE4 := NVL(X_address_line4, fnd_api.g_miss_char);

Line 989: l_vendor_site_rec.ADDRESS_LINE4 := NVL(X_address_line4, fnd_api.g_miss_char);

985: l_vendor_site_rec.PROVINCE := NVL(x_state, fnd_api.g_miss_char);
986: l_vendor_site_rec.COUNTRY := x_country ;
987: l_vendor_site_rec.INACTIVE_DATE := x_inactive_date ;
988: l_vendor_site_rec.ORG_ID := X_org_id ;
989: l_vendor_site_rec.ADDRESS_LINE4 := NVL(X_address_line4, fnd_api.g_miss_char);
990: l_vendor_site_rec.COUNTY := NVL(x_county, fnd_api.g_miss_char);
991: l_vendor_site_rec.ADDRESS_STYLE := X_address_style;
992: l_vendor_site_rec.LANGUAGE := NVL(x_language, fnd_api.g_miss_char);
993: l_vendor_site_rec.VENDOR_SITE_CODE := x_vendor_site_code ;

Line 990: l_vendor_site_rec.COUNTY := NVL(x_county, fnd_api.g_miss_char);

986: l_vendor_site_rec.COUNTRY := x_country ;
987: l_vendor_site_rec.INACTIVE_DATE := x_inactive_date ;
988: l_vendor_site_rec.ORG_ID := X_org_id ;
989: l_vendor_site_rec.ADDRESS_LINE4 := NVL(X_address_line4, fnd_api.g_miss_char);
990: l_vendor_site_rec.COUNTY := NVL(x_county, fnd_api.g_miss_char);
991: l_vendor_site_rec.ADDRESS_STYLE := X_address_style;
992: l_vendor_site_rec.LANGUAGE := NVL(x_language, fnd_api.g_miss_char);
993: l_vendor_site_rec.VENDOR_SITE_CODE := x_vendor_site_code ;
994: l_vendor_site_rec.ADDRESS_LINES_ALT:= X_address_lines_alt;

Line 992: l_vendor_site_rec.LANGUAGE := NVL(x_language, fnd_api.g_miss_char);

988: l_vendor_site_rec.ORG_ID := X_org_id ;
989: l_vendor_site_rec.ADDRESS_LINE4 := NVL(X_address_line4, fnd_api.g_miss_char);
990: l_vendor_site_rec.COUNTY := NVL(x_county, fnd_api.g_miss_char);
991: l_vendor_site_rec.ADDRESS_STYLE := X_address_style;
992: l_vendor_site_rec.LANGUAGE := NVL(x_language, fnd_api.g_miss_char);
993: l_vendor_site_rec.VENDOR_SITE_CODE := x_vendor_site_code ;
994: l_vendor_site_rec.ADDRESS_LINES_ALT:= X_address_lines_alt;
995: l_vendor_site_rec.BANK_CHARGE_BEARER := x_bank_charge_bearer ;
996: l_vendor_site_rec.ECE_TP_LOCATION_CODE := x_ece_tp_location_code;

Line 1006: p_init_msg_list => FND_API.G_TRUE,

1002:
1003:
1004: AP_VENDOR_PUB_PKG.update_Vendor_Site
1005: (p_api_version => 1.0,
1006: p_init_msg_list => FND_API.G_TRUE,
1007: p_commit =>FND_API.G_FALSE,
1008: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1009: x_return_status => l_return_status,
1010: x_msg_count => l_msg_count,

Line 1007: p_commit =>FND_API.G_FALSE,

1003:
1004: AP_VENDOR_PUB_PKG.update_Vendor_Site
1005: (p_api_version => 1.0,
1006: p_init_msg_list => FND_API.G_TRUE,
1007: p_commit =>FND_API.G_FALSE,
1008: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1009: x_return_status => l_return_status,
1010: x_msg_count => l_msg_count,
1011: x_msg_data => l_msg_data,

Line 1008: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1004: AP_VENDOR_PUB_PKG.update_Vendor_Site
1005: (p_api_version => 1.0,
1006: p_init_msg_list => FND_API.G_TRUE,
1007: p_commit =>FND_API.G_FALSE,
1008: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1009: x_return_status => l_return_status,
1010: x_msg_count => l_msg_count,
1011: x_msg_data => l_msg_data,
1012: p_vendor_site_rec => l_vendor_site_rec,

Line 1254: p_init_msg_list => fnd_api.g_true,

1250:
1251:
1252: hz_party_v2pub.create_organization
1253: (
1254: p_init_msg_list => fnd_api.g_true,
1255: p_organization_rec => l_organization_rec,
1256: x_return_status => l_return_status,
1257: x_msg_count => l_msg_count,
1258: x_msg_data => l_msg_data,

Line 1279: p_init_msg_list => fnd_api.g_true,

1275:
1276:
1277: hz_cust_account_v2pub.create_cust_account
1278: (
1279: p_init_msg_list => fnd_api.g_true,
1280: p_cust_account_rec => l_cust_account_rec,
1281: p_organization_rec => l_organization_rec,
1282: p_customer_profile_rec => l_customer_profile_rec,
1283: p_create_profile_amt => fnd_api.g_true,

Line 1283: p_create_profile_amt => fnd_api.g_true,

1279: p_init_msg_list => fnd_api.g_true,
1280: p_cust_account_rec => l_cust_account_rec,
1281: p_organization_rec => l_organization_rec,
1282: p_customer_profile_rec => l_customer_profile_rec,
1283: p_create_profile_amt => fnd_api.g_true,
1284: x_cust_account_id => l_cust_account_id,
1285: x_account_number => l_account_number,
1286: x_party_id => l_party_id,
1287: x_party_number => l_party_number,

Line 1398: SELECT nvl(a.object_version_number,fnd_api.G_NULL_NUM),a.party_id,a.cust_account_id,nvl(p.object_version_number,fnd_api.G_NULL_NUM)

1394: --Bug 3902175
1395: l_object_cust_version_number NUMBER;
1396:
1397: CURSOR c_all IS
1398: SELECT nvl(a.object_version_number,fnd_api.G_NULL_NUM),a.party_id,a.cust_account_id,nvl(p.object_version_number,fnd_api.G_NULL_NUM)
1399: FROM hz_cust_accounts a,hz_parties p
1400: WHERE a.party_id = p.party_id
1401: AND a.rowid = X_rowid;
1402:

Line 1416: l_party_rec.orig_system_reference := nvl(X_orig_system_reference,fnd_api.G_NULL_CHAR);

1412: CLOSE C_ALL;
1413:
1414:
1415: l_party_rec.party_id := l_party_id;
1416: l_party_rec.orig_system_reference := nvl(X_orig_system_reference,fnd_api.G_NULL_CHAR);
1417: l_party_rec.status := nvl(X_status,fnd_api.G_NULL_CHAR);
1418:
1419: l_organization_rec.organization_name := nvl(X_customer_name,fnd_api.G_NULL_CHAR);
1420: l_organization_rec.tax_reference := nvl(X_tax_reference,fnd_api.G_NULL_CHAR);

Line 1417: l_party_rec.status := nvl(X_status,fnd_api.G_NULL_CHAR);

1413:
1414:
1415: l_party_rec.party_id := l_party_id;
1416: l_party_rec.orig_system_reference := nvl(X_orig_system_reference,fnd_api.G_NULL_CHAR);
1417: l_party_rec.status := nvl(X_status,fnd_api.G_NULL_CHAR);
1418:
1419: l_organization_rec.organization_name := nvl(X_customer_name,fnd_api.G_NULL_CHAR);
1420: l_organization_rec.tax_reference := nvl(X_tax_reference,fnd_api.G_NULL_CHAR);
1421: l_organization_rec.jgzz_fiscal_code := nvl(X_jgzz_fiscal_code,fnd_api.G_NULL_CHAR);

Line 1419: l_organization_rec.organization_name := nvl(X_customer_name,fnd_api.G_NULL_CHAR);

1415: l_party_rec.party_id := l_party_id;
1416: l_party_rec.orig_system_reference := nvl(X_orig_system_reference,fnd_api.G_NULL_CHAR);
1417: l_party_rec.status := nvl(X_status,fnd_api.G_NULL_CHAR);
1418:
1419: l_organization_rec.organization_name := nvl(X_customer_name,fnd_api.G_NULL_CHAR);
1420: l_organization_rec.tax_reference := nvl(X_tax_reference,fnd_api.G_NULL_CHAR);
1421: l_organization_rec.jgzz_fiscal_code := nvl(X_jgzz_fiscal_code,fnd_api.G_NULL_CHAR);
1422: l_organization_rec.content_source_type := 'USER_ENTERED';
1423: l_organization_rec.party_rec := l_party_rec;

Line 1420: l_organization_rec.tax_reference := nvl(X_tax_reference,fnd_api.G_NULL_CHAR);

1416: l_party_rec.orig_system_reference := nvl(X_orig_system_reference,fnd_api.G_NULL_CHAR);
1417: l_party_rec.status := nvl(X_status,fnd_api.G_NULL_CHAR);
1418:
1419: l_organization_rec.organization_name := nvl(X_customer_name,fnd_api.G_NULL_CHAR);
1420: l_organization_rec.tax_reference := nvl(X_tax_reference,fnd_api.G_NULL_CHAR);
1421: l_organization_rec.jgzz_fiscal_code := nvl(X_jgzz_fiscal_code,fnd_api.G_NULL_CHAR);
1422: l_organization_rec.content_source_type := 'USER_ENTERED';
1423: l_organization_rec.party_rec := l_party_rec;
1424:

Line 1421: l_organization_rec.jgzz_fiscal_code := nvl(X_jgzz_fiscal_code,fnd_api.G_NULL_CHAR);

1417: l_party_rec.status := nvl(X_status,fnd_api.G_NULL_CHAR);
1418:
1419: l_organization_rec.organization_name := nvl(X_customer_name,fnd_api.G_NULL_CHAR);
1420: l_organization_rec.tax_reference := nvl(X_tax_reference,fnd_api.G_NULL_CHAR);
1421: l_organization_rec.jgzz_fiscal_code := nvl(X_jgzz_fiscal_code,fnd_api.G_NULL_CHAR);
1422: l_organization_rec.content_source_type := 'USER_ENTERED';
1423: l_organization_rec.party_rec := l_party_rec;
1424:
1425:

Line 1427: l_cust_account_rec.status := nvl(X_status,fnd_api.G_NULL_CHAR);

1423: l_organization_rec.party_rec := l_party_rec;
1424:
1425:
1426: l_cust_account_rec.cust_account_id := l_cust_account_id;
1427: l_cust_account_rec.status := nvl(X_status,fnd_api.G_NULL_CHAR);
1428:
1429:
1430: hz_party_v2pub.update_organization
1431: (

Line 1432: p_init_msg_list => fnd_api.g_false,

1428:
1429:
1430: hz_party_v2pub.update_organization
1431: (
1432: p_init_msg_list => fnd_api.g_false,
1433: p_organization_rec => l_organization_rec,
1434: p_party_object_version_number => l_object_version_number,
1435: x_profile_id => l_profile_id,
1436: x_return_status => l_return_status,

Line 1445: p_init_msg_list => fnd_api.g_false,

1441:
1442:
1443: hz_cust_account_v2pub.update_cust_account
1444: (
1445: p_init_msg_list => fnd_api.g_false,
1446: p_cust_account_rec => l_cust_account_rec,
1447: p_object_version_number => l_object_cust_version_number,
1448: x_return_status => l_return_status,
1449: x_msg_count => l_msg_count,

Line 1705: (p_init_msg_list => fnd_api.g_true,

1701:
1702:
1703:
1704: ap_vendor_pub_pkg.create_vendor
1705: (p_init_msg_list => fnd_api.g_true,
1706: p_api_version => 1.0,
1707: p_commit => FND_API.G_FALSE,
1708: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1709: p_vendor_rec => l_vendor_rec,

Line 1707: p_commit => FND_API.G_FALSE,

1703:
1704: ap_vendor_pub_pkg.create_vendor
1705: (p_init_msg_list => fnd_api.g_true,
1706: p_api_version => 1.0,
1707: p_commit => FND_API.G_FALSE,
1708: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1709: p_vendor_rec => l_vendor_rec,
1710: x_return_status => l_return_status,
1711: x_msg_count => l_msg_count,

Line 1708: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1704: ap_vendor_pub_pkg.create_vendor
1705: (p_init_msg_list => fnd_api.g_true,
1706: p_api_version => 1.0,
1707: p_commit => FND_API.G_FALSE,
1708: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1709: p_vendor_rec => l_vendor_rec,
1710: x_return_status => l_return_status,
1711: x_msg_count => l_msg_count,
1712: x_msg_data => l_msg_data,

Line 1784: select party_id,nvl(object_version_number,fnd_api.G_NULL_NUM) into l_party_id,l_object_version_number from hz_parties where party_name = X_vendor_name and created_by_module = 'AP_SUPPLIERS_API';

1780: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE;
1781: l_organization_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE;
1782: BEGIN
1783:
1784: select party_id,nvl(object_version_number,fnd_api.G_NULL_NUM) into l_party_id,l_object_version_number from hz_parties where party_name = X_vendor_name and created_by_module = 'AP_SUPPLIERS_API';
1785:
1786: l_party_rec.party_id := l_party_id;
1787: --l_party_rec.orig_system_reference := nvl(X_orig_system_reference,fnd_api.G_NULL_CHAR);
1788: l_party_rec.status := nvl(X_status,fnd_api.G_NULL_CHAR);

Line 1787: --l_party_rec.orig_system_reference := nvl(X_orig_system_reference,fnd_api.G_NULL_CHAR);

1783:
1784: select party_id,nvl(object_version_number,fnd_api.G_NULL_NUM) into l_party_id,l_object_version_number from hz_parties where party_name = X_vendor_name and created_by_module = 'AP_SUPPLIERS_API';
1785:
1786: l_party_rec.party_id := l_party_id;
1787: --l_party_rec.orig_system_reference := nvl(X_orig_system_reference,fnd_api.G_NULL_CHAR);
1788: l_party_rec.status := nvl(X_status,fnd_api.G_NULL_CHAR);
1789:
1790:
1791: l_organization_rec.organization_name := nvl(X_vendor_name,fnd_api.G_NULL_CHAR);

Line 1788: l_party_rec.status := nvl(X_status,fnd_api.G_NULL_CHAR);

1784: select party_id,nvl(object_version_number,fnd_api.G_NULL_NUM) into l_party_id,l_object_version_number from hz_parties where party_name = X_vendor_name and created_by_module = 'AP_SUPPLIERS_API';
1785:
1786: l_party_rec.party_id := l_party_id;
1787: --l_party_rec.orig_system_reference := nvl(X_orig_system_reference,fnd_api.G_NULL_CHAR);
1788: l_party_rec.status := nvl(X_status,fnd_api.G_NULL_CHAR);
1789:
1790:
1791: l_organization_rec.organization_name := nvl(X_vendor_name,fnd_api.G_NULL_CHAR);
1792: l_organization_rec.tax_reference := nvl(X_vat_registration_num,fnd_api.G_NULL_CHAR);

Line 1791: l_organization_rec.organization_name := nvl(X_vendor_name,fnd_api.G_NULL_CHAR);

1787: --l_party_rec.orig_system_reference := nvl(X_orig_system_reference,fnd_api.G_NULL_CHAR);
1788: l_party_rec.status := nvl(X_status,fnd_api.G_NULL_CHAR);
1789:
1790:
1791: l_organization_rec.organization_name := nvl(X_vendor_name,fnd_api.G_NULL_CHAR);
1792: l_organization_rec.tax_reference := nvl(X_vat_registration_num,fnd_api.G_NULL_CHAR);
1793: l_organization_rec.jgzz_fiscal_code := nvl(X_num_1099,fnd_api.G_NULL_CHAR);
1794: l_organization_rec.content_source_type := 'USER_ENTERED';
1795: l_organization_rec.party_rec := l_party_rec;

Line 1792: l_organization_rec.tax_reference := nvl(X_vat_registration_num,fnd_api.G_NULL_CHAR);

1788: l_party_rec.status := nvl(X_status,fnd_api.G_NULL_CHAR);
1789:
1790:
1791: l_organization_rec.organization_name := nvl(X_vendor_name,fnd_api.G_NULL_CHAR);
1792: l_organization_rec.tax_reference := nvl(X_vat_registration_num,fnd_api.G_NULL_CHAR);
1793: l_organization_rec.jgzz_fiscal_code := nvl(X_num_1099,fnd_api.G_NULL_CHAR);
1794: l_organization_rec.content_source_type := 'USER_ENTERED';
1795: l_organization_rec.party_rec := l_party_rec;
1796:

Line 1793: l_organization_rec.jgzz_fiscal_code := nvl(X_num_1099,fnd_api.G_NULL_CHAR);

1789:
1790:
1791: l_organization_rec.organization_name := nvl(X_vendor_name,fnd_api.G_NULL_CHAR);
1792: l_organization_rec.tax_reference := nvl(X_vat_registration_num,fnd_api.G_NULL_CHAR);
1793: l_organization_rec.jgzz_fiscal_code := nvl(X_num_1099,fnd_api.G_NULL_CHAR);
1794: l_organization_rec.content_source_type := 'USER_ENTERED';
1795: l_organization_rec.party_rec := l_party_rec;
1796:
1797:

Line 1800: p_init_msg_list => fnd_api.g_false,

1796:
1797:
1798: hz_party_v2pub.update_organization
1799: (
1800: p_init_msg_list => fnd_api.g_false,
1801: p_organization_rec => l_organization_rec,
1802: p_party_object_version_number => l_object_version_number,
1803: x_profile_id => l_profile_id,
1804: x_return_status => l_return_status,

Line 1817: l_vendor_rec.JGZZ_FISCAL_CODE := nvl(X_num_1099,fnd_api.G_NULL_CHAR);

1813:
1814:
1815:
1816: /* l_vendor_rec.VENDOR_NAME := X_vendor_name;
1817: l_vendor_rec.JGZZ_FISCAL_CODE := nvl(X_num_1099,fnd_api.G_NULL_CHAR);
1818: l_vendor_rec.TAX_REFERENCE := nvl(X_vat_registration_num,fnd_api.G_NULL_CHAR);
1819: l_vendor_rec.VENDOR_NAME_ALT := X_vendor_name_alt;
1820: l_vendor_rec.END_DATE_ACTIVE := X_end_date_active;
1821:

Line 1818: l_vendor_rec.TAX_REFERENCE := nvl(X_vat_registration_num,fnd_api.G_NULL_CHAR);

1814:
1815:
1816: /* l_vendor_rec.VENDOR_NAME := X_vendor_name;
1817: l_vendor_rec.JGZZ_FISCAL_CODE := nvl(X_num_1099,fnd_api.G_NULL_CHAR);
1818: l_vendor_rec.TAX_REFERENCE := nvl(X_vat_registration_num,fnd_api.G_NULL_CHAR);
1819: l_vendor_rec.VENDOR_NAME_ALT := X_vendor_name_alt;
1820: l_vendor_rec.END_DATE_ACTIVE := X_end_date_active;
1821:
1822:

Line 1827: p_init_msg_list => FND_API.G_TRUE,

1823:
1824:
1825: AP_VENDOR_PUB_PKG.Update_Vendor(
1826: p_api_version => 1.0,
1827: p_init_msg_list => FND_API.G_TRUE,
1828: p_commit => FND_API.G_FALSE,
1829: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1830: x_return_status => l_return_status,
1831: x_msg_count => l_msg_count,

Line 1828: p_commit => FND_API.G_FALSE,

1824:
1825: AP_VENDOR_PUB_PKG.Update_Vendor(
1826: p_api_version => 1.0,
1827: p_init_msg_list => FND_API.G_TRUE,
1828: p_commit => FND_API.G_FALSE,
1829: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1830: x_return_status => l_return_status,
1831: x_msg_count => l_msg_count,
1832: x_msg_data => l_msg_data,

Line 1829: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1825: AP_VENDOR_PUB_PKG.Update_Vendor(
1826: p_api_version => 1.0,
1827: p_init_msg_list => FND_API.G_TRUE,
1828: p_commit => FND_API.G_FALSE,
1829: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1830: x_return_status => l_return_status,
1831: x_msg_count => l_msg_count,
1832: x_msg_data => l_msg_data,
1833: p_vendor_rec => l_vendor_rec,