[Home] [Help]
PACKAGE BODY: APPS.CSC_RESPONSE_CENTER_PKG_V2
Source
1 PACKAGE BODY CSC_RESPONSE_CENTER_PKG_V2 AS
5 FUNCTION G_MISS_NUM RETURN NUMBER IS
2 /* $Header: CSCV2RCB.pls 120.12 2011/08/19 05:07:06 spamujul ship $ */
3
4 -- Local Function. Returns the Value of the Constant FND_API.G_MISS_NUM
6 BEGIN
7 RETURN FND_API.G_MISS_NUM ;
8 END G_MISS_NUM ;
9
10 -- Local Function. Returns the Value of the Constant FND_API.G_MISS_CHAR to the caller
11 FUNCTION G_MISS_CHAR RETURN VARCHAR2 IS
12 BEGIN
13 RETURN FND_API.G_MISS_CHAR ;
14 END G_MISS_CHAR ;
15
16 -- Local Function. REturns the Value of the Constant FND_API.G_MISS_DATE to the caller
17 FUNCTION G_MISS_DATE RETURN DATE IS
18 BEGIN
19 RETURN FND_API.G_MISS_DATE ;
20 END G_MISS_DATE ;
21
22 FUNCTION GET_ORG_REC_TYPE RETURN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE IS
23 TMP_ORG_REC_TYPE HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE;
24 BEGIN
25 RETURN TMP_ORG_REC_TYPE;
26 END GET_ORG_REC_TYPE;
27
28 -- hbchung
29 FUNCTION GET_ORG_CONTACT_REC_TYPE RETURN HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE IS
30 TMP_ORG_CONTACT_REC_TYPE HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE;
31 BEGIN
32 RETURN TMP_ORG_CONTACT_REC_TYPE;
33 END GET_ORG_CONTACT_REC_TYPE;
34 -- hbchung
35
36 -- hbchung
37 FUNCTION GET_RELATIONSHIP_REC_TYPE RETURN HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE IS
38 TMP_RELATIONSHIP_REC_TYPE HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE;
39 BEGIN
40 RETURN TMP_RELATIONSHIP_REC_TYPE;
41 END GET_RELATIONSHIP_REC_TYPE;
42 -- hbchung
43
44 -- hbchung
45 FUNCTION GET_PER_LANG_REC_TYPE RETURN HZ_PERSON_INFO_V2PUB.PERSON_LANGUAGE_REC_TYPE IS
46 TMP_PER_LANG_REC_TYPE HZ_PERSON_INFO_V2PUB.PERSON_LANGUAGE_REC_TYPE;
47 BEGIN
48 RETURN TMP_PER_LANG_REC_TYPE;
49 END GET_PER_LANG_REC_TYPE;
50 -- hbchung
51
52 -- hbchung
53 FUNCTION GET_EDUCATION_REC_TYPE RETURN HZ_PERSON_INFO_V2PUB.EDUCATION_REC_TYPE IS
54 TMP_EDU_REC_TYPE HZ_PERSON_INFO_V2PUB.EDUCATION_REC_TYPE;
55 BEGIN
56 RETURN TMP_EDU_REC_TYPE;
57 END GET_EDUCATION_REC_TYPE;
58 -- hbchung
59
60 -- hbchung
61 FUNCTION GET_EMP_HISTORY_REC_TYPE RETURN HZ_PERSON_INFO_V2PUB.EMPLOYMENT_HISTORY_REC_TYPE IS
62 TMP_EMP_HIST_REC_TYPE HZ_PERSON_INFO_V2PUB.EMPLOYMENT_HISTORY_REC_TYPE;
63 BEGIN
64 RETURN TMP_EMP_HIST_REC_TYPE;
65 END GET_EMP_HISTORY_REC_TYPE;
66 -- hbchung
67
68 -- hbchung
69 FUNCTION GET_PER_INTEREST_REC_TYPE RETURN HZ_PERSON_INFO_V2PUB.PERSON_INTEREST_REC_TYPE IS
70 TMP_PER_INT_REC_TYPE HZ_PERSON_INFO_V2PUB.PERSON_INTEREST_REC_TYPE;
71 BEGIN
72 RETURN TMP_PER_INT_REC_TYPE;
73 END GET_PER_INTEREST_REC_TYPE;
74 -- hbchung
75
76 FUNCTION GET_PERSON_REC_TYPE RETURN HZ_PARTY_V2PUB.PERSON_REC_TYPE IS
77 TMP_PERSON_REC_TYPE HZ_PARTY_V2PUB.PERSON_REC_TYPE;
78 BEGIN
79 RETURN TMP_PERSON_REC_TYPE;
80 END GET_PERSON_REC_TYPE;
81
82
83 FUNCTION GET_ACCOUNT_REC_TYPE RETURN HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE IS
84 TMP_ACCOUNT_REC_TYPE HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE;
85 BEGIN
86 RETURN TMP_ACCOUNT_REC_TYPE;
87 END GET_ACCOUNT_REC_TYPE;
88
89 FUNCTION GET_CUST_ACCT_ROLES_REC_TYPE RETURN HZ_CUST_ACCOUNT_ROLE_V2PUB.CUST_ACCOUNT_ROLE_REC_TYPE IS
90 TMP_REC HZ_CUST_ACCOUNT_ROLE_V2PUB.CUST_ACCOUNT_ROLE_REC_TYPE;
91 BEGIN
92 RETURN TMP_REC;
93 END GET_CUST_ACCT_ROLES_REC_TYPE;
94
95 FUNCTION GET_ACCT_SITE_REC_TYPE RETURN HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE IS
96 TMP_REC HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE;
97 BEGIN
98 RETURN TMP_REC;
99 END GET_ACCT_SITE_REC_TYPE;
100
101
102 FUNCTION GET_ACCT_SITE_USES_REC_TYPE RETURN HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE IS
103 TMP_REC HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE;
104 BEGIN
105 RETURN TMP_REC;
106 END GET_ACCT_SITE_USES_REC_TYPE;
107
108
109 FUNCTION GET_CUST_ACCT_RELATE_REC_TYPE RETURN HZ_CUST_ACCOUNT_V2PUB.CUST_ACCT_RELATE_REC_TYPE IS
110 TMP_REC HZ_CUST_ACCOUNT_V2PUB.CUST_ACCT_RELATE_REC_TYPE;
111 BEGIN
112 RETURN TMP_REC;
113 END GET_CUST_ACCT_RELATE_REC_TYPE;
114
115
116 FUNCTION GET_CUST_PROFILE_REC_TYPE RETURN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE IS
117 TMP_CUST_PROFILE_REC_TYPE HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
118 BEGIN
119 RETURN TMP_CUST_PROFILE_REC_TYPE;
120 END GET_CUST_PROFILE_REC_TYPE;
121
122 FUNCTION GET_PARTY_REC_TYPE RETURN HZ_PARTY_V2PUB.PARTY_REC_TYPE IS
123 TMP_PARTY_REC_TYPE HZ_PARTY_V2PUB.PARTY_REC_TYPE;
124 BEGIN
125 RETURN TMP_PARTY_REC_TYPE;
126 END GET_PARTY_REC_TYPE;
127
128 FUNCTION GET_PHONE_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE IS
129 TMP_PHONE_REC_TYPE HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
130 BEGIN
131 RETURN TMP_PHONE_REC_TYPE;
132 END GET_PHONE_REC_TYPE;
133
134 FUNCTION GET_EMAIL_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE IS
135 TMP_EMAIL_REC_TYPE HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
136 BEGIN
137 RETURN TMP_EMAIL_REC_TYPE;
138 END GET_EMAIL_REC_TYPE;
139
140 FUNCTION GET_WEB_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE IS
141 TMP_WEB_REC_TYPE HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
142 BEGIN
143 RETURN TMP_WEB_REC_TYPE;
144 END GET_WEB_REC_TYPE;
145
146 FUNCTION GET_EDI_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE IS
150 END GET_EDI_REC_TYPE;
147 TMP_EDI_REC_TYPE HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
148 BEGIN
149 RETURN TMP_EDI_REC_TYPE;
151
152 FUNCTION GET_TELEX_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE IS
153 TMP_TELEX_REC_TYPE HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
154 BEGIN
155 RETURN TMP_TELEX_REC_TYPE;
156 END GET_TELEX_REC_TYPE;
157
158 FUNCTION GET_CONTACT_POINTS_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE IS
159 TMP_CONTACT_POINTS_REC_TYPE HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
160 BEGIN
161 RETURN TMP_CONTACT_POINTS_REC_TYPE;
162 END GET_CONTACT_POINTS_REC_TYPE;
163
164 FUNCTION GET_CONT_POINTS_PREF_REC_TYPE RETURN HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE IS
165 TMP_CONTACT_POINTS_REC_TYPE HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
166 BEGIN
167 RETURN TMP_CONTACT_POINTS_REC_TYPE;
168 END GET_CONT_POINTS_PREF_REC_TYPE;
169
170 FUNCTION GET_ADDRESS_REC_TYPE RETURN CSC_RESPONSE_CENTER_PKG_V2.ADDRESS_REC_TYPE IS
171 TMP_ADDRESS_REC_TYPE CSC_RESPONSE_CENTER_PKG_V2.ADDRESS_REC_TYPE;
172 BEGIN
173 RETURN TMP_ADDRESS_REC_TYPE;
174 END GET_ADDRESS_REC_TYPE;
175
176 FUNCTION GET_PARTY_SITE_REC_TYPE RETURN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE IS
177 TMP_PARTY_SITE_REC_TYPE HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
178 BEGIN
179 RETURN TMP_PARTY_SITE_REC_TYPE;
180 END GET_PARTY_SITE_REC_TYPE;
181
182 FUNCTION GET_PARTY_SITE_USE_REC_TYPE RETURN HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE IS
183 TMP_PARTY_SITE_USE_REC_TYPE HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
184 BEGIN
185 RETURN TMP_PARTY_SITE_USE_REC_TYPE;
186 END GET_PARTY_SITE_USE_REC_TYPE;
187
188 /* Returns CSC application_id passed to TCA V2 APIs */
189 FUNCTION get_csc_application_id RETURN NUMBER
190 IS
191 csc_application_id CONSTANT NUMBER := 511;
192 BEGIN
193 RETURN csc_application_id;
194 END;
195
196
197 PROCEDURE Create_Address ( p_address_rec IN ADDRESS_REC_TYPE,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_location_id OUT NOCOPY NUMBER,
202 x_addr_val_status OUT NOCOPY VARCHAR2,
203 x_addr_warn_msg OUT NOCOPY VARCHAR2)
204 IS
205 l_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
206 l_return_status VARCHAR2(1);
207 l_msg_count NUMBER;
208 l_msg_data VARCHAR2(2000);
209 l_location_id NUMBER;
210
211 /* For NCR July'09 Bug 8435112 */
212 l_do_addr_val VARCHAR2(10);
213 l_addr_val_status VARCHAR2(10);
214 l_addr_warn_msg VARCHAR2(2000);
215 /* End of NCR July'09 Bug 8435112 */
216 BEGIN
217 l_location_rec.address1 := p_address_rec.address1;
218 l_location_rec.address2 := p_address_rec.address2;
219 l_location_rec.address3 := p_address_rec.address3;
220 l_location_rec.address4 := p_address_rec.address4;
221 l_location_rec.address_lines_phonetic := p_address_rec.address_lines_phonetic;
222 l_location_rec.city := p_address_rec.city;
223 l_location_rec.state := p_address_rec.state;
224 l_location_rec.county := p_address_rec.county;
225 l_location_rec.country := p_address_rec.country;
226 l_location_rec.postal_code := p_address_rec.postal_code;
227 l_location_rec.province := p_address_rec.province;
228 l_location_rec.county := p_address_rec.county;
229 l_location_rec.language := p_address_rec.language;
230 l_location_rec.po_box_number := p_address_rec.po_box_number;
231 l_location_rec.street := p_address_rec.street;
232 l_location_rec.house_number := p_address_rec.house_number;
233 l_location_rec.position := p_address_rec.position;
234 l_location_rec.address_key := p_address_rec.address_key;
235 l_location_rec.street_suffix := p_address_rec.street_suffix;
236 l_location_rec.street_number := p_address_rec.street_number;
237 l_location_rec.floor := p_address_rec.floor;
238 l_location_rec.suite := p_address_rec.suite;
239 l_location_rec.postal_plus4_code := p_address_rec.postal_plus4_code;
240 l_location_rec.delivery_point_code := p_address_rec.delivery_point_code;
241 l_location_rec.location_directions := p_address_rec.location_directions;
242 l_location_rec.clli_code := p_address_rec.clli_code;
243 l_location_rec.short_description := p_address_rec.short_description;
244 l_location_rec.description := p_address_rec.description;
245 l_location_rec.sales_tax_geocode := p_address_rec.sales_tax_geocode;
246 l_location_rec.sales_tax_inside_city_limits := p_address_rec.sales_tax_inside_city_limits;
247 l_location_rec.timezone_id := p_address_rec.timezone_id;
248 l_location_rec.created_by_module := p_address_rec.created_by_module;
249 l_location_rec.application_id := p_address_rec.application_id;
250 -- Begin fix by spamujul for Bug 12849575
251 l_location_rec.attribute1 := p_address_rec.attribute1;
252 l_location_rec.attribute2 := p_address_rec.attribute2;
253 l_location_rec.attribute3 := p_address_rec.attribute3;
254 l_location_rec.attribute4 := p_address_rec.attribute4;
255 l_location_rec.attribute5 := p_address_rec.attribute5;
256 l_location_rec.attribute6 := p_address_rec.attribute6;
257 l_location_rec.attribute7 := p_address_rec.attribute7;
258 l_location_rec.attribute8 := p_address_rec.attribute8;
259 l_location_rec.attribute9 := p_address_rec.attribute9;
260 l_location_rec.attribute10 := p_address_rec.attribute10;
264 l_location_rec.attribute14 := p_address_rec.attribute14;
261 l_location_rec.attribute11 := p_address_rec.attribute11;
262 l_location_rec.attribute12 := p_address_rec.attribute12;
263 l_location_rec.attribute13 := p_address_rec.attribute13;
265 l_location_rec.attribute15 := p_address_rec.attribute15;
266 l_location_rec.attribute16 := p_address_rec.attribute16;
267 l_location_rec.attribute17 := p_address_rec.attribute17;
268 l_location_rec.attribute18 := p_address_rec.attribute18;
269 l_location_rec.attribute19 := p_address_rec.attribute19;
270 l_location_rec.attribute20 := p_address_rec.attribute20;
271 -- End fix by spamujul for Bug 12849575
272
273 /* For NCR Jul'09 Bug 8435112 */
274
275 IF Fnd_Profile.value('CS_VALIDATE_ADDRESS') = 'Y' then
276 l_do_addr_val := 'Y';
277 ELSE
278 l_do_addr_val := 'N';
279 END IF;
280
281 /* End of NCR Jul'09 Bug 8435112 */
282
283 --HZ_LOCATION_V2PUB.create_location ( p_init_msg_list => FND_API.G_FALSE, -- commented to fix bug# 9570086 by mpathani
284 HZ_LOCATION_V2PUB.create_location ( p_init_msg_list => FND_API.G_TRUE, -- To initialize the Message List on each call
285 p_location_rec => l_location_rec,
286 x_return_status => l_return_status,
287 x_msg_count => l_msg_count,
288 x_msg_data => l_msg_data,
289 x_location_id => l_location_id,
290 p_do_addr_val => l_do_addr_val,
291 x_addr_val_status => l_addr_val_status,
292 x_addr_warn_msg => l_addr_warn_msg);
293
294 x_return_status := l_return_status;
295 x_msg_count := l_msg_count;
296 x_msg_data := l_msg_data;
297
298 /*For NCR Jul'09 Bug 8435112 */
299 x_addr_val_status := l_addr_val_status;
300 x_addr_warn_msg := l_addr_warn_msg;
301 /* End of NCR Jul'09 Bug 8435112 */
302
303 If x_return_status = CSC_CORE_UTILS_PVT.G_RET_STS_SUCCESS Then
304 x_location_id := l_location_id;
305 End If;
306
307 End Create_Address;
308
309 PROCEDURE Update_Address ( p_address_rec IN ADDRESS_REC_TYPE,
310 x_msg_count OUT NOCOPY NUMBER,
311 x_msg_data OUT NOCOPY VARCHAR2,
312 x_object_version_number IN OUT NOCOPY NUMBER,
313 x_return_status OUT NOCOPY VARCHAR2,
314 x_addr_val_status OUT NOCOPY VARCHAR2,
315 x_addr_warn_msg OUT NOCOPY VARCHAR2)
316 IS
317 l_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
318 l_return_status VARCHAR2(1);
319 l_msg_count NUMBER;
320 l_msg_data VARCHAR2(2000);
321
322 /* For NCR July'09 Bug 8435112 */
323 l_do_addr_val VARCHAR2(10);
324 l_addr_val_status VARCHAR2(10);
325 l_addr_warn_msg VARCHAR2(2000);
326 /* End of NCR July'09 Bug 8435112 */
327
328 BEGIN
329 l_location_rec.address1 := Nvl(p_address_rec.address1, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
330 l_location_rec.address2 := Nvl(p_address_rec.address2, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
331 l_location_rec.address3 := Nvl(p_address_rec.address3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
332 l_location_rec.address4 := Nvl(p_address_rec.address4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
333 l_location_rec.address_lines_phonetic := Nvl(p_address_rec.address_lines_phonetic, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
334 l_location_rec.city := Nvl(p_address_rec.city, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
335 l_location_rec.state := Nvl(p_address_rec.state, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
336 l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
337 l_location_rec.country := Nvl(p_address_rec.country, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
338 l_location_rec.postal_code := Nvl(p_address_rec.postal_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
339 l_location_rec.province := Nvl(p_address_rec.province, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
340 l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
341 l_location_rec.language := Nvl(p_address_rec.language, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
342 l_location_rec.po_box_number := Nvl(p_address_rec.po_box_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
343 l_location_rec.street := Nvl(p_address_rec.street, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
344 l_location_rec.house_number := Nvl(p_address_rec.house_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
345 l_location_rec.position := Nvl(p_address_rec.position, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
346 l_location_rec.address_key := Nvl(p_address_rec.address_key, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
347 l_location_rec.street_suffix := Nvl(p_address_rec.street_suffix, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
348 l_location_rec.street_number := Nvl(p_address_rec.street_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
349 l_location_rec.floor := Nvl(p_address_rec.floor, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
350 l_location_rec.suite := Nvl(p_address_rec.suite, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
351 l_location_rec.postal_plus4_code := Nvl(p_address_rec.postal_plus4_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
352 l_location_rec.delivery_point_code := Nvl(p_address_rec.delivery_point_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
353 l_location_rec.location_directions := Nvl(p_address_rec.location_directions, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
354 l_location_rec.clli_code := Nvl(p_address_rec.clli_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
355 l_location_rec.short_description := Nvl(p_address_rec.short_description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
356 l_location_rec.description := Nvl(p_address_rec.description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
357 l_location_rec.sales_tax_geocode := Nvl(p_address_rec.sales_tax_geocode, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
358 l_location_rec.sales_tax_inside_city_limits := Nvl(p_address_rec.sales_tax_inside_city_limits, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
359 --Begin Fix for Bug 7033623 by spamujul
360 -- l_location_rec.timezone_id := Nvl(p_address_rec.timezone_id, CSC_RESPONSE_CENTER_PKG_V2.g_miss_num);
361 -- Added the following condition by spamujul for Bug 10276829
362 IF NVL(p_address_rec.timezone_id,CSC_RESPONSE_CENTER_PKG_V2.g_miss_num) <> CSC_RESPONSE_CENTER_PKG_V2.g_miss_num THEN
363 -- if l_location_rec.timezone_id <> CSC_RESPONSE_CENTER_PKG_V2.g_miss_num then -- Commented it by spamujul for Bug 9375543
364 l_location_rec.timezone_id := p_address_rec.timezone_id;
365 else
366 l_location_rec.timezone_id := CSC_RESPONSE_CENTER_PKG_V2.g_miss_num;
367 end if;
368 --End Fix for Bug 7033623 by spamujul
369 l_location_rec.location_id := p_address_rec.location_id;
370
371 /* For NCR Jul'09 Bug 8435112 */
372 IF Fnd_Profile.value('CS_VALIDATE_ADDRESS') = 'Y' then
373 l_do_addr_val := 'Y';
374 ELSE
375 l_do_addr_val := 'N';
376 END IF;
377 /* End of NCR Jul'09 Bug 8435112 */
378 --End Fix for Bug 7033623 by spamujul
379 l_location_rec.location_id := p_address_rec.location_id;
380 -- Begin fix by spamujul for Bug 12849575
381 l_location_rec.attribute1 := Nvl(p_address_rec.attribute1, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
382 l_location_rec.attribute2 := Nvl(p_address_rec.attribute2, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
383 l_location_rec.attribute3 := Nvl(p_address_rec.attribute3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
384 l_location_rec.attribute4 := Nvl(p_address_rec.attribute4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
385 l_location_rec.attribute5 := Nvl(p_address_rec.attribute5, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
386 l_location_rec.attribute6 := Nvl(p_address_rec.attribute6, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
387 l_location_rec.attribute7 := Nvl(p_address_rec.attribute7, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
388 l_location_rec.attribute8 := Nvl(p_address_rec.attribute8, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
389 l_location_rec.attribute9 := Nvl(p_address_rec.attribute9, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
390 l_location_rec.attribute10 := Nvl(p_address_rec.attribute10, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
391 l_location_rec.attribute11 := Nvl(p_address_rec.attribute11, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
392 l_location_rec.attribute12 := Nvl(p_address_rec.attribute12, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
393 l_location_rec.attribute13 := Nvl(p_address_rec.attribute13, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
394 l_location_rec.attribute14 := Nvl(p_address_rec.attribute14, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
395 l_location_rec.attribute15 := Nvl(p_address_rec.attribute15, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
396 l_location_rec.attribute16 := Nvl(p_address_rec.attribute16, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
397 l_location_rec.attribute17 := Nvl(p_address_rec.attribute17, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
398 l_location_rec.attribute18 := Nvl(p_address_rec.attribute18, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
399 l_location_rec.attribute19 := Nvl(p_address_rec.attribute19, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
400 l_location_rec.attribute20 := Nvl(p_address_rec.attribute20, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
401 -- End fix by spamujul for Bug 12849575
402
403 --HZ_LOCATION_V2PUB.update_location ( p_init_msg_list => FND_API.G_FALSE, -- commented to fix bug# 9570086 by mpathani
404 HZ_LOCATION_V2PUB.update_location ( p_init_msg_list => FND_API.G_TRUE, -- To initialize the Message List on each call
405 p_location_rec => l_location_rec,
406 p_object_version_number => x_object_version_number,
407 x_return_status => l_return_status,
408 x_msg_count => l_msg_count,
409 x_msg_data => l_msg_data,
410 p_do_addr_val => l_do_addr_val,
411 x_addr_val_status => l_addr_val_status,
412 x_addr_warn_msg => l_addr_warn_msg);
413
414 x_return_status := l_return_status;
415 x_msg_count := l_msg_count;
416 x_msg_data := l_msg_data;
417
418 /*For NCR Jul'09 Bug 8435112 */
419 x_addr_val_status := l_addr_val_status;
420 x_addr_warn_msg := l_addr_warn_msg;
421 /* End of NCR Jul'09 Bug 8435112 */
422
423 End Update_Address;
424
425 END CSC_RESPONSE_CENTER_PKG_V2;
426