1: PACKAGE BODY CSP_SHIP_TO_ADDRESS_PVT AS
2: /*$Header: cspvstab.pls 120.20.12020000.6 2013/02/21 10:01:40 vmandava ship $*/
3: ------------------------------------------------------------------------------------------------------------------------
4: --
5: -- Procedure Name : Main procedure name is ship_to_address_handler. All calling programs should call it directly.
82: from csp_rs_cust_relations
83: where resource_type = p_resource_type and resource_id = p_resource_id;
84:
85: BEGIN
86: csp_ship_to_address_pvt.g_rs_cust_relation_id := null;
87: OPEN l_rs_relation_csr;
88: FETCH l_rs_relation_csr INTO l_rs_cust_relation_id,
89: l_customer_id,
90: l_created_by,
164: p_ATTRIBUTE14 => NULL,
165: p_ATTRIBUTE15 => NULL);
166:
167: END IF;
168: csp_ship_to_address_pvt.g_rs_cust_relation_id := l_rs_cust_relation_id;
169:
170: END do_rs_cust_relations;
171:
172:
257: BEGIN
258:
259: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
260: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
261: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
262: 'Begin...');
263: end if;
264:
265: SAVEPOINT do_create_ship_to_location_PUB;
269: select userenv('LANG') into l_language from dual;
270:
271: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
272: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
273: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
274: 'l_language = ' || l_language);
275: end if;
276:
277: -- Assign location code
279: l_location_code := 'CSP' || l_location_code;
280:
281: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
282: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
283: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
284: 'l_location_code = ' || l_location_code);
285: end if;
286:
287: -- Default location description to address 1.
345: l_in_hr_loc_hook_rec.attribute_category := p_attribute_category;
346:
347: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
348: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
349: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
350: 'Before calling CSP_HR_LOC_CUST.user_hook...');
351: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
352: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
353: 'l_in_hr_loc_hook_rec.location_code = ' || l_in_hr_loc_hook_rec.location_code);
348: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
349: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
350: 'Before calling CSP_HR_LOC_CUST.user_hook...');
351: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
352: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
353: 'l_in_hr_loc_hook_rec.location_code = ' || l_in_hr_loc_hook_rec.location_code);
354: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
355: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
356: 'l_in_hr_loc_hook_rec.description = ' || l_in_hr_loc_hook_rec.description);
351: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
352: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
353: 'l_in_hr_loc_hook_rec.location_code = ' || l_in_hr_loc_hook_rec.location_code);
354: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
355: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
356: 'l_in_hr_loc_hook_rec.description = ' || l_in_hr_loc_hook_rec.description);
357: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
358: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
359: 'l_in_hr_loc_hook_rec.tp_header_id = ' || l_in_hr_loc_hook_rec.tp_header_id);
354: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
355: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
356: 'l_in_hr_loc_hook_rec.description = ' || l_in_hr_loc_hook_rec.description);
357: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
358: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
359: 'l_in_hr_loc_hook_rec.tp_header_id = ' || l_in_hr_loc_hook_rec.tp_header_id);
360: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
361: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
362: 'l_in_hr_loc_hook_rec.ece_tp_location_code = ' || l_in_hr_loc_hook_rec.ece_tp_location_code);
357: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
358: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
359: 'l_in_hr_loc_hook_rec.tp_header_id = ' || l_in_hr_loc_hook_rec.tp_header_id);
360: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
361: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
362: 'l_in_hr_loc_hook_rec.ece_tp_location_code = ' || l_in_hr_loc_hook_rec.ece_tp_location_code);
363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
364: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
365: 'l_in_hr_loc_hook_rec.address_line_1 = ' || l_in_hr_loc_hook_rec.address_line_1);
360: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
361: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
362: 'l_in_hr_loc_hook_rec.ece_tp_location_code = ' || l_in_hr_loc_hook_rec.ece_tp_location_code);
363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
364: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
365: 'l_in_hr_loc_hook_rec.address_line_1 = ' || l_in_hr_loc_hook_rec.address_line_1);
366: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
367: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
368: 'l_in_hr_loc_hook_rec.address_line_2 = ' || l_in_hr_loc_hook_rec.address_line_2);
363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
364: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
365: 'l_in_hr_loc_hook_rec.address_line_1 = ' || l_in_hr_loc_hook_rec.address_line_1);
366: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
367: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
368: 'l_in_hr_loc_hook_rec.address_line_2 = ' || l_in_hr_loc_hook_rec.address_line_2);
369: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
370: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
371: 'l_in_hr_loc_hook_rec.address_line_3 = ' || l_in_hr_loc_hook_rec.address_line_3);
366: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
367: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
368: 'l_in_hr_loc_hook_rec.address_line_2 = ' || l_in_hr_loc_hook_rec.address_line_2);
369: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
370: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
371: 'l_in_hr_loc_hook_rec.address_line_3 = ' || l_in_hr_loc_hook_rec.address_line_3);
372: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
373: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
374: 'l_in_hr_loc_hook_rec.bill_to_site_flag = ' || l_in_hr_loc_hook_rec.bill_to_site_flag);
369: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
370: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
371: 'l_in_hr_loc_hook_rec.address_line_3 = ' || l_in_hr_loc_hook_rec.address_line_3);
372: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
373: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
374: 'l_in_hr_loc_hook_rec.bill_to_site_flag = ' || l_in_hr_loc_hook_rec.bill_to_site_flag);
375: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
376: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
377: 'l_in_hr_loc_hook_rec.country = ' || l_in_hr_loc_hook_rec.country);
372: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
373: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
374: 'l_in_hr_loc_hook_rec.bill_to_site_flag = ' || l_in_hr_loc_hook_rec.bill_to_site_flag);
375: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
376: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
377: 'l_in_hr_loc_hook_rec.country = ' || l_in_hr_loc_hook_rec.country);
378: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
379: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
380: 'l_in_hr_loc_hook_rec.designated_receiver_id = ' || l_in_hr_loc_hook_rec.designated_receiver_id);
375: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
376: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
377: 'l_in_hr_loc_hook_rec.country = ' || l_in_hr_loc_hook_rec.country);
378: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
379: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
380: 'l_in_hr_loc_hook_rec.designated_receiver_id = ' || l_in_hr_loc_hook_rec.designated_receiver_id);
381: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
382: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
383: 'l_in_hr_loc_hook_rec.in_organization_flag = ' || l_in_hr_loc_hook_rec.in_organization_flag);
378: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
379: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
380: 'l_in_hr_loc_hook_rec.designated_receiver_id = ' || l_in_hr_loc_hook_rec.designated_receiver_id);
381: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
382: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
383: 'l_in_hr_loc_hook_rec.in_organization_flag = ' || l_in_hr_loc_hook_rec.in_organization_flag);
384: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
385: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
386: 'l_in_hr_loc_hook_rec.inactive_date = ' || l_in_hr_loc_hook_rec.inactive_date);
381: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
382: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
383: 'l_in_hr_loc_hook_rec.in_organization_flag = ' || l_in_hr_loc_hook_rec.in_organization_flag);
384: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
385: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
386: 'l_in_hr_loc_hook_rec.inactive_date = ' || l_in_hr_loc_hook_rec.inactive_date);
387: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
388: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
389: 'l_in_hr_loc_hook_rec.inventory_organization_id = ' || l_in_hr_loc_hook_rec.inventory_organization_id);
384: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
385: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
386: 'l_in_hr_loc_hook_rec.inactive_date = ' || l_in_hr_loc_hook_rec.inactive_date);
387: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
388: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
389: 'l_in_hr_loc_hook_rec.inventory_organization_id = ' || l_in_hr_loc_hook_rec.inventory_organization_id);
390: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
391: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
392: 'l_in_hr_loc_hook_rec.office_site_flag = ' || l_in_hr_loc_hook_rec.office_site_flag);
387: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
388: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
389: 'l_in_hr_loc_hook_rec.inventory_organization_id = ' || l_in_hr_loc_hook_rec.inventory_organization_id);
390: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
391: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
392: 'l_in_hr_loc_hook_rec.office_site_flag = ' || l_in_hr_loc_hook_rec.office_site_flag);
393: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
394: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
395: 'l_in_hr_loc_hook_rec.postal_code = ' || l_in_hr_loc_hook_rec.postal_code);
390: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
391: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
392: 'l_in_hr_loc_hook_rec.office_site_flag = ' || l_in_hr_loc_hook_rec.office_site_flag);
393: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
394: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
395: 'l_in_hr_loc_hook_rec.postal_code = ' || l_in_hr_loc_hook_rec.postal_code);
396: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
397: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
398: 'l_in_hr_loc_hook_rec.receiving_site_flag = ' || l_in_hr_loc_hook_rec.receiving_site_flag);
393: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
394: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
395: 'l_in_hr_loc_hook_rec.postal_code = ' || l_in_hr_loc_hook_rec.postal_code);
396: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
397: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
398: 'l_in_hr_loc_hook_rec.receiving_site_flag = ' || l_in_hr_loc_hook_rec.receiving_site_flag);
399: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
400: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
401: 'l_in_hr_loc_hook_rec.region_1 = ' || l_in_hr_loc_hook_rec.region_1);
396: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
397: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
398: 'l_in_hr_loc_hook_rec.receiving_site_flag = ' || l_in_hr_loc_hook_rec.receiving_site_flag);
399: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
400: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
401: 'l_in_hr_loc_hook_rec.region_1 = ' || l_in_hr_loc_hook_rec.region_1);
402: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
403: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
404: 'l_in_hr_loc_hook_rec.region_2 = ' || l_in_hr_loc_hook_rec.region_2);
399: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
400: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
401: 'l_in_hr_loc_hook_rec.region_1 = ' || l_in_hr_loc_hook_rec.region_1);
402: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
403: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
404: 'l_in_hr_loc_hook_rec.region_2 = ' || l_in_hr_loc_hook_rec.region_2);
405: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
406: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
407: 'l_in_hr_loc_hook_rec.region_3 = ' || l_in_hr_loc_hook_rec.region_3);
402: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
403: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
404: 'l_in_hr_loc_hook_rec.region_2 = ' || l_in_hr_loc_hook_rec.region_2);
405: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
406: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
407: 'l_in_hr_loc_hook_rec.region_3 = ' || l_in_hr_loc_hook_rec.region_3);
408: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
409: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
410: 'l_in_hr_loc_hook_rec.ship_to_location_id = ' || l_in_hr_loc_hook_rec.ship_to_location_id);
405: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
406: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
407: 'l_in_hr_loc_hook_rec.region_3 = ' || l_in_hr_loc_hook_rec.region_3);
408: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
409: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
410: 'l_in_hr_loc_hook_rec.ship_to_location_id = ' || l_in_hr_loc_hook_rec.ship_to_location_id);
411: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
412: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
413: 'l_in_hr_loc_hook_rec.ship_to_site_flag = ' || l_in_hr_loc_hook_rec.ship_to_site_flag);
408: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
409: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
410: 'l_in_hr_loc_hook_rec.ship_to_location_id = ' || l_in_hr_loc_hook_rec.ship_to_location_id);
411: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
412: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
413: 'l_in_hr_loc_hook_rec.ship_to_site_flag = ' || l_in_hr_loc_hook_rec.ship_to_site_flag);
414: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
415: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
416: 'l_in_hr_loc_hook_rec.style = ' || l_in_hr_loc_hook_rec.style);
411: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
412: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
413: 'l_in_hr_loc_hook_rec.ship_to_site_flag = ' || l_in_hr_loc_hook_rec.ship_to_site_flag);
414: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
415: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
416: 'l_in_hr_loc_hook_rec.style = ' || l_in_hr_loc_hook_rec.style);
417: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
418: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
419: 'l_in_hr_loc_hook_rec.tax_name = ' || l_in_hr_loc_hook_rec.tax_name);
414: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
415: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
416: 'l_in_hr_loc_hook_rec.style = ' || l_in_hr_loc_hook_rec.style);
417: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
418: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
419: 'l_in_hr_loc_hook_rec.tax_name = ' || l_in_hr_loc_hook_rec.tax_name);
420: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
421: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
422: 'l_in_hr_loc_hook_rec.telephone_number_1 = ' || l_in_hr_loc_hook_rec.telephone_number_1);
417: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
418: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
419: 'l_in_hr_loc_hook_rec.tax_name = ' || l_in_hr_loc_hook_rec.tax_name);
420: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
421: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
422: 'l_in_hr_loc_hook_rec.telephone_number_1 = ' || l_in_hr_loc_hook_rec.telephone_number_1);
423: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
424: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
425: 'l_in_hr_loc_hook_rec.telephone_number_2 = ' || l_in_hr_loc_hook_rec.telephone_number_2);
420: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
421: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
422: 'l_in_hr_loc_hook_rec.telephone_number_1 = ' || l_in_hr_loc_hook_rec.telephone_number_1);
423: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
424: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
425: 'l_in_hr_loc_hook_rec.telephone_number_2 = ' || l_in_hr_loc_hook_rec.telephone_number_2);
426: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
427: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
428: 'l_in_hr_loc_hook_rec.telephone_number_3 = ' || l_in_hr_loc_hook_rec.telephone_number_3);
423: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
424: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
425: 'l_in_hr_loc_hook_rec.telephone_number_2 = ' || l_in_hr_loc_hook_rec.telephone_number_2);
426: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
427: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
428: 'l_in_hr_loc_hook_rec.telephone_number_3 = ' || l_in_hr_loc_hook_rec.telephone_number_3);
429: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
430: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
431: 'l_in_hr_loc_hook_rec.town_or_city = ' || l_in_hr_loc_hook_rec.town_or_city);
426: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
427: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
428: 'l_in_hr_loc_hook_rec.telephone_number_3 = ' || l_in_hr_loc_hook_rec.telephone_number_3);
429: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
430: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
431: 'l_in_hr_loc_hook_rec.town_or_city = ' || l_in_hr_loc_hook_rec.town_or_city);
432: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
433: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
434: 'l_in_hr_loc_hook_rec.loc_information13 = ' || l_in_hr_loc_hook_rec.loc_information13);
429: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
430: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
431: 'l_in_hr_loc_hook_rec.town_or_city = ' || l_in_hr_loc_hook_rec.town_or_city);
432: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
433: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
434: 'l_in_hr_loc_hook_rec.loc_information13 = ' || l_in_hr_loc_hook_rec.loc_information13);
435: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
436: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
437: 'l_in_hr_loc_hook_rec.loc_information14 = ' || l_in_hr_loc_hook_rec.loc_information14);
432: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
433: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
434: 'l_in_hr_loc_hook_rec.loc_information13 = ' || l_in_hr_loc_hook_rec.loc_information13);
435: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
436: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
437: 'l_in_hr_loc_hook_rec.loc_information14 = ' || l_in_hr_loc_hook_rec.loc_information14);
438: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
439: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
440: 'l_in_hr_loc_hook_rec.loc_information15 = ' || l_in_hr_loc_hook_rec.loc_information15);
435: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
436: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
437: 'l_in_hr_loc_hook_rec.loc_information14 = ' || l_in_hr_loc_hook_rec.loc_information14);
438: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
439: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
440: 'l_in_hr_loc_hook_rec.loc_information15 = ' || l_in_hr_loc_hook_rec.loc_information15);
441: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
442: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
443: 'l_in_hr_loc_hook_rec.loc_information16 = ' || l_in_hr_loc_hook_rec.loc_information16);
438: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
439: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
440: 'l_in_hr_loc_hook_rec.loc_information15 = ' || l_in_hr_loc_hook_rec.loc_information15);
441: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
442: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
443: 'l_in_hr_loc_hook_rec.loc_information16 = ' || l_in_hr_loc_hook_rec.loc_information16);
444: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
445: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
446: 'l_in_hr_loc_hook_rec.loc_information17 = ' || l_in_hr_loc_hook_rec.loc_information17);
441: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
442: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
443: 'l_in_hr_loc_hook_rec.loc_information16 = ' || l_in_hr_loc_hook_rec.loc_information16);
444: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
445: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
446: 'l_in_hr_loc_hook_rec.loc_information17 = ' || l_in_hr_loc_hook_rec.loc_information17);
447: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
448: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
449: 'l_in_hr_loc_hook_rec.loc_information18 = ' || l_in_hr_loc_hook_rec.loc_information18);
444: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
445: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
446: 'l_in_hr_loc_hook_rec.loc_information17 = ' || l_in_hr_loc_hook_rec.loc_information17);
447: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
448: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
449: 'l_in_hr_loc_hook_rec.loc_information18 = ' || l_in_hr_loc_hook_rec.loc_information18);
450: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
451: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
452: 'l_in_hr_loc_hook_rec.loc_information19 = ' || l_in_hr_loc_hook_rec.loc_information19);
447: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
448: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
449: 'l_in_hr_loc_hook_rec.loc_information18 = ' || l_in_hr_loc_hook_rec.loc_information18);
450: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
451: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
452: 'l_in_hr_loc_hook_rec.loc_information19 = ' || l_in_hr_loc_hook_rec.loc_information19);
453: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
454: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
455: 'l_in_hr_loc_hook_rec.loc_information20 = ' || l_in_hr_loc_hook_rec.loc_information20);
450: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
451: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
452: 'l_in_hr_loc_hook_rec.loc_information19 = ' || l_in_hr_loc_hook_rec.loc_information19);
453: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
454: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
455: 'l_in_hr_loc_hook_rec.loc_information20 = ' || l_in_hr_loc_hook_rec.loc_information20);
456: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
457: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
458: 'l_in_hr_loc_hook_rec.attribute1 = ' || l_in_hr_loc_hook_rec.attribute1);
453: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
454: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
455: 'l_in_hr_loc_hook_rec.loc_information20 = ' || l_in_hr_loc_hook_rec.loc_information20);
456: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
457: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
458: 'l_in_hr_loc_hook_rec.attribute1 = ' || l_in_hr_loc_hook_rec.attribute1);
459: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
460: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
461: 'l_in_hr_loc_hook_rec.attribute2 = ' || l_in_hr_loc_hook_rec.attribute2);
456: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
457: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
458: 'l_in_hr_loc_hook_rec.attribute1 = ' || l_in_hr_loc_hook_rec.attribute1);
459: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
460: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
461: 'l_in_hr_loc_hook_rec.attribute2 = ' || l_in_hr_loc_hook_rec.attribute2);
462: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
463: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
464: 'l_in_hr_loc_hook_rec.attribute3 = ' || l_in_hr_loc_hook_rec.attribute3);
459: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
460: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
461: 'l_in_hr_loc_hook_rec.attribute2 = ' || l_in_hr_loc_hook_rec.attribute2);
462: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
463: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
464: 'l_in_hr_loc_hook_rec.attribute3 = ' || l_in_hr_loc_hook_rec.attribute3);
465: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
466: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
467: 'l_in_hr_loc_hook_rec.attribute4 = ' || l_in_hr_loc_hook_rec.attribute4);
462: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
463: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
464: 'l_in_hr_loc_hook_rec.attribute3 = ' || l_in_hr_loc_hook_rec.attribute3);
465: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
466: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
467: 'l_in_hr_loc_hook_rec.attribute4 = ' || l_in_hr_loc_hook_rec.attribute4);
468: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
469: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
470: 'l_in_hr_loc_hook_rec.attribute5 = ' || l_in_hr_loc_hook_rec.attribute5);
465: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
466: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
467: 'l_in_hr_loc_hook_rec.attribute4 = ' || l_in_hr_loc_hook_rec.attribute4);
468: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
469: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
470: 'l_in_hr_loc_hook_rec.attribute5 = ' || l_in_hr_loc_hook_rec.attribute5);
471: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
472: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
473: 'l_in_hr_loc_hook_rec.attribute6 = ' || l_in_hr_loc_hook_rec.attribute6);
468: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
469: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
470: 'l_in_hr_loc_hook_rec.attribute5 = ' || l_in_hr_loc_hook_rec.attribute5);
471: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
472: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
473: 'l_in_hr_loc_hook_rec.attribute6 = ' || l_in_hr_loc_hook_rec.attribute6);
474: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
475: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
476: 'l_in_hr_loc_hook_rec.attribute7 = ' || l_in_hr_loc_hook_rec.attribute7);
471: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
472: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
473: 'l_in_hr_loc_hook_rec.attribute6 = ' || l_in_hr_loc_hook_rec.attribute6);
474: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
475: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
476: 'l_in_hr_loc_hook_rec.attribute7 = ' || l_in_hr_loc_hook_rec.attribute7);
477: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
478: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
479: 'l_in_hr_loc_hook_rec.attribute8 = ' || l_in_hr_loc_hook_rec.attribute8);
474: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
475: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
476: 'l_in_hr_loc_hook_rec.attribute7 = ' || l_in_hr_loc_hook_rec.attribute7);
477: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
478: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
479: 'l_in_hr_loc_hook_rec.attribute8 = ' || l_in_hr_loc_hook_rec.attribute8);
480: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
481: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
482: 'l_in_hr_loc_hook_rec.attribute9 = ' || l_in_hr_loc_hook_rec.attribute9);
477: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
478: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
479: 'l_in_hr_loc_hook_rec.attribute8 = ' || l_in_hr_loc_hook_rec.attribute8);
480: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
481: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
482: 'l_in_hr_loc_hook_rec.attribute9 = ' || l_in_hr_loc_hook_rec.attribute9);
483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
484: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
485: 'l_in_hr_loc_hook_rec.attribute10 = ' || l_in_hr_loc_hook_rec.attribute10);
480: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
481: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
482: 'l_in_hr_loc_hook_rec.attribute9 = ' || l_in_hr_loc_hook_rec.attribute9);
483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
484: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
485: 'l_in_hr_loc_hook_rec.attribute10 = ' || l_in_hr_loc_hook_rec.attribute10);
486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
487: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
488: 'l_in_hr_loc_hook_rec.attribute11 = ' || l_in_hr_loc_hook_rec.attribute11);
483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
484: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
485: 'l_in_hr_loc_hook_rec.attribute10 = ' || l_in_hr_loc_hook_rec.attribute10);
486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
487: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
488: 'l_in_hr_loc_hook_rec.attribute11 = ' || l_in_hr_loc_hook_rec.attribute11);
489: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
490: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
491: 'l_in_hr_loc_hook_rec.attribute12 = ' || l_in_hr_loc_hook_rec.attribute12);
486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
487: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
488: 'l_in_hr_loc_hook_rec.attribute11 = ' || l_in_hr_loc_hook_rec.attribute11);
489: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
490: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
491: 'l_in_hr_loc_hook_rec.attribute12 = ' || l_in_hr_loc_hook_rec.attribute12);
492: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
493: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
494: 'l_in_hr_loc_hook_rec.attribute13 = ' || l_in_hr_loc_hook_rec.attribute13);
489: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
490: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
491: 'l_in_hr_loc_hook_rec.attribute12 = ' || l_in_hr_loc_hook_rec.attribute12);
492: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
493: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
494: 'l_in_hr_loc_hook_rec.attribute13 = ' || l_in_hr_loc_hook_rec.attribute13);
495: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
496: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
497: 'l_in_hr_loc_hook_rec.attribute14 = ' || l_in_hr_loc_hook_rec.attribute14);
492: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
493: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
494: 'l_in_hr_loc_hook_rec.attribute13 = ' || l_in_hr_loc_hook_rec.attribute13);
495: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
496: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
497: 'l_in_hr_loc_hook_rec.attribute14 = ' || l_in_hr_loc_hook_rec.attribute14);
498: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
499: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
500: 'l_in_hr_loc_hook_rec.attribute15 = ' || l_in_hr_loc_hook_rec.attribute15);
495: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
496: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
497: 'l_in_hr_loc_hook_rec.attribute14 = ' || l_in_hr_loc_hook_rec.attribute14);
498: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
499: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
500: 'l_in_hr_loc_hook_rec.attribute15 = ' || l_in_hr_loc_hook_rec.attribute15);
501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
502: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
503: 'l_in_hr_loc_hook_rec.attribute16 = ' || l_in_hr_loc_hook_rec.attribute16);
498: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
499: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
500: 'l_in_hr_loc_hook_rec.attribute15 = ' || l_in_hr_loc_hook_rec.attribute15);
501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
502: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
503: 'l_in_hr_loc_hook_rec.attribute16 = ' || l_in_hr_loc_hook_rec.attribute16);
504: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
505: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
506: 'l_in_hr_loc_hook_rec.attribute17 = ' || l_in_hr_loc_hook_rec.attribute17);
501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
502: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
503: 'l_in_hr_loc_hook_rec.attribute16 = ' || l_in_hr_loc_hook_rec.attribute16);
504: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
505: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
506: 'l_in_hr_loc_hook_rec.attribute17 = ' || l_in_hr_loc_hook_rec.attribute17);
507: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
508: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
509: 'l_in_hr_loc_hook_rec.attribute18 = ' || l_in_hr_loc_hook_rec.attribute18);
504: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
505: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
506: 'l_in_hr_loc_hook_rec.attribute17 = ' || l_in_hr_loc_hook_rec.attribute17);
507: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
508: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
509: 'l_in_hr_loc_hook_rec.attribute18 = ' || l_in_hr_loc_hook_rec.attribute18);
510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
511: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
512: 'l_in_hr_loc_hook_rec.attribute19 = ' || l_in_hr_loc_hook_rec.attribute19);
507: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
508: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
509: 'l_in_hr_loc_hook_rec.attribute18 = ' || l_in_hr_loc_hook_rec.attribute18);
510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
511: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
512: 'l_in_hr_loc_hook_rec.attribute19 = ' || l_in_hr_loc_hook_rec.attribute19);
513: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
514: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
515: 'l_in_hr_loc_hook_rec.attribute20 = ' || l_in_hr_loc_hook_rec.attribute20);
510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
511: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
512: 'l_in_hr_loc_hook_rec.attribute19 = ' || l_in_hr_loc_hook_rec.attribute19);
513: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
514: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
515: 'l_in_hr_loc_hook_rec.attribute20 = ' || l_in_hr_loc_hook_rec.attribute20);
516: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
517: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
518: 'l_in_hr_loc_hook_rec.attribute_category = ' || l_in_hr_loc_hook_rec.attribute_category);
513: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
514: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
515: 'l_in_hr_loc_hook_rec.attribute20 = ' || l_in_hr_loc_hook_rec.attribute20);
516: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
517: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
518: 'l_in_hr_loc_hook_rec.attribute_category = ' || l_in_hr_loc_hook_rec.attribute_category);
519: end if;
520:
521: l_out_hr_loc_hook_rec := CSP_HR_LOC_CUST.user_hook(l_in_hr_loc_hook_rec);
521: l_out_hr_loc_hook_rec := CSP_HR_LOC_CUST.user_hook(l_in_hr_loc_hook_rec);
522:
523: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
524: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
525: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
526: 'After calling CSP_HR_LOC_CUST.user_hook...');
527: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
528: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
529: 'l_out_hr_loc_hook_rec.location_code = ' || l_out_hr_loc_hook_rec.location_code);
524: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
525: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
526: 'After calling CSP_HR_LOC_CUST.user_hook...');
527: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
528: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
529: 'l_out_hr_loc_hook_rec.location_code = ' || l_out_hr_loc_hook_rec.location_code);
530: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
531: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
532: 'l_out_hr_loc_hook_rec.description = ' || l_out_hr_loc_hook_rec.description);
527: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
528: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
529: 'l_out_hr_loc_hook_rec.location_code = ' || l_out_hr_loc_hook_rec.location_code);
530: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
531: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
532: 'l_out_hr_loc_hook_rec.description = ' || l_out_hr_loc_hook_rec.description);
533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
534: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
535: 'l_out_hr_loc_hook_rec.tp_header_id = ' || l_out_hr_loc_hook_rec.tp_header_id);
530: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
531: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
532: 'l_out_hr_loc_hook_rec.description = ' || l_out_hr_loc_hook_rec.description);
533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
534: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
535: 'l_out_hr_loc_hook_rec.tp_header_id = ' || l_out_hr_loc_hook_rec.tp_header_id);
536: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
537: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
538: 'l_out_hr_loc_hook_rec.ece_tp_location_code = ' || l_out_hr_loc_hook_rec.ece_tp_location_code);
533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
534: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
535: 'l_out_hr_loc_hook_rec.tp_header_id = ' || l_out_hr_loc_hook_rec.tp_header_id);
536: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
537: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
538: 'l_out_hr_loc_hook_rec.ece_tp_location_code = ' || l_out_hr_loc_hook_rec.ece_tp_location_code);
539: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
540: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
541: 'l_out_hr_loc_hook_rec.address_line_1 = ' || l_out_hr_loc_hook_rec.address_line_1);
536: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
537: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
538: 'l_out_hr_loc_hook_rec.ece_tp_location_code = ' || l_out_hr_loc_hook_rec.ece_tp_location_code);
539: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
540: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
541: 'l_out_hr_loc_hook_rec.address_line_1 = ' || l_out_hr_loc_hook_rec.address_line_1);
542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
543: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
544: 'l_out_hr_loc_hook_rec.address_line_2 = ' || l_out_hr_loc_hook_rec.address_line_2);
539: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
540: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
541: 'l_out_hr_loc_hook_rec.address_line_1 = ' || l_out_hr_loc_hook_rec.address_line_1);
542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
543: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
544: 'l_out_hr_loc_hook_rec.address_line_2 = ' || l_out_hr_loc_hook_rec.address_line_2);
545: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
546: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
547: 'l_out_hr_loc_hook_rec.address_line_3 = ' || l_out_hr_loc_hook_rec.address_line_3);
542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
543: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
544: 'l_out_hr_loc_hook_rec.address_line_2 = ' || l_out_hr_loc_hook_rec.address_line_2);
545: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
546: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
547: 'l_out_hr_loc_hook_rec.address_line_3 = ' || l_out_hr_loc_hook_rec.address_line_3);
548: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
549: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
550: 'l_out_hr_loc_hook_rec.bill_to_site_flag = ' || l_out_hr_loc_hook_rec.bill_to_site_flag);
545: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
546: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
547: 'l_out_hr_loc_hook_rec.address_line_3 = ' || l_out_hr_loc_hook_rec.address_line_3);
548: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
549: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
550: 'l_out_hr_loc_hook_rec.bill_to_site_flag = ' || l_out_hr_loc_hook_rec.bill_to_site_flag);
551: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
552: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
553: 'l_out_hr_loc_hook_rec.country = ' || l_out_hr_loc_hook_rec.country);
548: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
549: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
550: 'l_out_hr_loc_hook_rec.bill_to_site_flag = ' || l_out_hr_loc_hook_rec.bill_to_site_flag);
551: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
552: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
553: 'l_out_hr_loc_hook_rec.country = ' || l_out_hr_loc_hook_rec.country);
554: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
555: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
556: 'l_out_hr_loc_hook_rec.designated_receiver_id = ' || l_out_hr_loc_hook_rec.designated_receiver_id);
551: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
552: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
553: 'l_out_hr_loc_hook_rec.country = ' || l_out_hr_loc_hook_rec.country);
554: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
555: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
556: 'l_out_hr_loc_hook_rec.designated_receiver_id = ' || l_out_hr_loc_hook_rec.designated_receiver_id);
557: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
558: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
559: 'l_out_hr_loc_hook_rec.in_organization_flag = ' || l_out_hr_loc_hook_rec.in_organization_flag);
554: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
555: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
556: 'l_out_hr_loc_hook_rec.designated_receiver_id = ' || l_out_hr_loc_hook_rec.designated_receiver_id);
557: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
558: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
559: 'l_out_hr_loc_hook_rec.in_organization_flag = ' || l_out_hr_loc_hook_rec.in_organization_flag);
560: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
561: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
562: 'l_out_hr_loc_hook_rec.inactive_date = ' || l_out_hr_loc_hook_rec.inactive_date);
557: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
558: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
559: 'l_out_hr_loc_hook_rec.in_organization_flag = ' || l_out_hr_loc_hook_rec.in_organization_flag);
560: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
561: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
562: 'l_out_hr_loc_hook_rec.inactive_date = ' || l_out_hr_loc_hook_rec.inactive_date);
563: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
564: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
565: 'l_out_hr_loc_hook_rec.inventory_organization_id = ' || l_out_hr_loc_hook_rec.inventory_organization_id);
560: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
561: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
562: 'l_out_hr_loc_hook_rec.inactive_date = ' || l_out_hr_loc_hook_rec.inactive_date);
563: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
564: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
565: 'l_out_hr_loc_hook_rec.inventory_organization_id = ' || l_out_hr_loc_hook_rec.inventory_organization_id);
566: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
567: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
568: 'l_out_hr_loc_hook_rec.office_site_flag = ' || l_out_hr_loc_hook_rec.office_site_flag);
563: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
564: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
565: 'l_out_hr_loc_hook_rec.inventory_organization_id = ' || l_out_hr_loc_hook_rec.inventory_organization_id);
566: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
567: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
568: 'l_out_hr_loc_hook_rec.office_site_flag = ' || l_out_hr_loc_hook_rec.office_site_flag);
569: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
570: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
571: 'l_out_hr_loc_hook_rec.postal_code = ' || l_out_hr_loc_hook_rec.postal_code);
566: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
567: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
568: 'l_out_hr_loc_hook_rec.office_site_flag = ' || l_out_hr_loc_hook_rec.office_site_flag);
569: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
570: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
571: 'l_out_hr_loc_hook_rec.postal_code = ' || l_out_hr_loc_hook_rec.postal_code);
572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
573: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
574: 'l_out_hr_loc_hook_rec.receiving_site_flag = ' || l_out_hr_loc_hook_rec.receiving_site_flag);
569: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
570: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
571: 'l_out_hr_loc_hook_rec.postal_code = ' || l_out_hr_loc_hook_rec.postal_code);
572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
573: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
574: 'l_out_hr_loc_hook_rec.receiving_site_flag = ' || l_out_hr_loc_hook_rec.receiving_site_flag);
575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
576: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
577: 'l_out_hr_loc_hook_rec.region_1 = ' || l_out_hr_loc_hook_rec.region_1);
572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
573: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
574: 'l_out_hr_loc_hook_rec.receiving_site_flag = ' || l_out_hr_loc_hook_rec.receiving_site_flag);
575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
576: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
577: 'l_out_hr_loc_hook_rec.region_1 = ' || l_out_hr_loc_hook_rec.region_1);
578: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
579: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
580: 'l_out_hr_loc_hook_rec.region_2 = ' || l_out_hr_loc_hook_rec.region_2);
575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
576: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
577: 'l_out_hr_loc_hook_rec.region_1 = ' || l_out_hr_loc_hook_rec.region_1);
578: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
579: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
580: 'l_out_hr_loc_hook_rec.region_2 = ' || l_out_hr_loc_hook_rec.region_2);
581: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
582: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
583: 'l_out_hr_loc_hook_rec.region_3 = ' || l_out_hr_loc_hook_rec.region_3);
578: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
579: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
580: 'l_out_hr_loc_hook_rec.region_2 = ' || l_out_hr_loc_hook_rec.region_2);
581: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
582: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
583: 'l_out_hr_loc_hook_rec.region_3 = ' || l_out_hr_loc_hook_rec.region_3);
584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
585: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
586: 'l_out_hr_loc_hook_rec.ship_to_location_id = ' || l_out_hr_loc_hook_rec.ship_to_location_id);
581: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
582: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
583: 'l_out_hr_loc_hook_rec.region_3 = ' || l_out_hr_loc_hook_rec.region_3);
584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
585: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
586: 'l_out_hr_loc_hook_rec.ship_to_location_id = ' || l_out_hr_loc_hook_rec.ship_to_location_id);
587: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
588: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
589: 'l_out_hr_loc_hook_rec.ship_to_site_flag = ' || l_out_hr_loc_hook_rec.ship_to_site_flag);
584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
585: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
586: 'l_out_hr_loc_hook_rec.ship_to_location_id = ' || l_out_hr_loc_hook_rec.ship_to_location_id);
587: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
588: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
589: 'l_out_hr_loc_hook_rec.ship_to_site_flag = ' || l_out_hr_loc_hook_rec.ship_to_site_flag);
590: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
591: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
592: 'l_out_hr_loc_hook_rec.style = ' || l_out_hr_loc_hook_rec.style);
587: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
588: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
589: 'l_out_hr_loc_hook_rec.ship_to_site_flag = ' || l_out_hr_loc_hook_rec.ship_to_site_flag);
590: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
591: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
592: 'l_out_hr_loc_hook_rec.style = ' || l_out_hr_loc_hook_rec.style);
593: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
594: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
595: 'l_out_hr_loc_hook_rec.tax_name = ' || l_out_hr_loc_hook_rec.tax_name);
590: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
591: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
592: 'l_out_hr_loc_hook_rec.style = ' || l_out_hr_loc_hook_rec.style);
593: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
594: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
595: 'l_out_hr_loc_hook_rec.tax_name = ' || l_out_hr_loc_hook_rec.tax_name);
596: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
597: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
598: 'l_out_hr_loc_hook_rec.telephone_number_1 = ' || l_out_hr_loc_hook_rec.telephone_number_1);
593: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
594: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
595: 'l_out_hr_loc_hook_rec.tax_name = ' || l_out_hr_loc_hook_rec.tax_name);
596: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
597: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
598: 'l_out_hr_loc_hook_rec.telephone_number_1 = ' || l_out_hr_loc_hook_rec.telephone_number_1);
599: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
600: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
601: 'l_out_hr_loc_hook_rec.telephone_number_2 = ' || l_out_hr_loc_hook_rec.telephone_number_2);
596: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
597: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
598: 'l_out_hr_loc_hook_rec.telephone_number_1 = ' || l_out_hr_loc_hook_rec.telephone_number_1);
599: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
600: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
601: 'l_out_hr_loc_hook_rec.telephone_number_2 = ' || l_out_hr_loc_hook_rec.telephone_number_2);
602: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
603: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
604: 'l_out_hr_loc_hook_rec.telephone_number_3 = ' || l_out_hr_loc_hook_rec.telephone_number_3);
599: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
600: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
601: 'l_out_hr_loc_hook_rec.telephone_number_2 = ' || l_out_hr_loc_hook_rec.telephone_number_2);
602: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
603: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
604: 'l_out_hr_loc_hook_rec.telephone_number_3 = ' || l_out_hr_loc_hook_rec.telephone_number_3);
605: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
606: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
607: 'l_out_hr_loc_hook_rec.town_or_city = ' || l_out_hr_loc_hook_rec.town_or_city);
602: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
603: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
604: 'l_out_hr_loc_hook_rec.telephone_number_3 = ' || l_out_hr_loc_hook_rec.telephone_number_3);
605: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
606: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
607: 'l_out_hr_loc_hook_rec.town_or_city = ' || l_out_hr_loc_hook_rec.town_or_city);
608: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
609: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
610: 'l_out_hr_loc_hook_rec.loc_information13 = ' || l_out_hr_loc_hook_rec.loc_information13);
605: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
606: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
607: 'l_out_hr_loc_hook_rec.town_or_city = ' || l_out_hr_loc_hook_rec.town_or_city);
608: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
609: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
610: 'l_out_hr_loc_hook_rec.loc_information13 = ' || l_out_hr_loc_hook_rec.loc_information13);
611: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
612: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
613: 'l_out_hr_loc_hook_rec.loc_information14 = ' || l_out_hr_loc_hook_rec.loc_information14);
608: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
609: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
610: 'l_out_hr_loc_hook_rec.loc_information13 = ' || l_out_hr_loc_hook_rec.loc_information13);
611: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
612: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
613: 'l_out_hr_loc_hook_rec.loc_information14 = ' || l_out_hr_loc_hook_rec.loc_information14);
614: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
615: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
616: 'l_out_hr_loc_hook_rec.loc_information15 = ' || l_out_hr_loc_hook_rec.loc_information15);
611: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
612: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
613: 'l_out_hr_loc_hook_rec.loc_information14 = ' || l_out_hr_loc_hook_rec.loc_information14);
614: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
615: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
616: 'l_out_hr_loc_hook_rec.loc_information15 = ' || l_out_hr_loc_hook_rec.loc_information15);
617: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
618: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
619: 'l_out_hr_loc_hook_rec.loc_information16 = ' || l_out_hr_loc_hook_rec.loc_information16);
614: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
615: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
616: 'l_out_hr_loc_hook_rec.loc_information15 = ' || l_out_hr_loc_hook_rec.loc_information15);
617: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
618: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
619: 'l_out_hr_loc_hook_rec.loc_information16 = ' || l_out_hr_loc_hook_rec.loc_information16);
620: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
621: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
622: 'l_out_hr_loc_hook_rec.loc_information17 = ' || l_out_hr_loc_hook_rec.loc_information17);
617: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
618: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
619: 'l_out_hr_loc_hook_rec.loc_information16 = ' || l_out_hr_loc_hook_rec.loc_information16);
620: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
621: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
622: 'l_out_hr_loc_hook_rec.loc_information17 = ' || l_out_hr_loc_hook_rec.loc_information17);
623: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
624: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
625: 'l_out_hr_loc_hook_rec.loc_information18 = ' || l_out_hr_loc_hook_rec.loc_information18);
620: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
621: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
622: 'l_out_hr_loc_hook_rec.loc_information17 = ' || l_out_hr_loc_hook_rec.loc_information17);
623: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
624: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
625: 'l_out_hr_loc_hook_rec.loc_information18 = ' || l_out_hr_loc_hook_rec.loc_information18);
626: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
627: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
628: 'l_out_hr_loc_hook_rec.loc_information19 = ' || l_out_hr_loc_hook_rec.loc_information19);
623: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
624: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
625: 'l_out_hr_loc_hook_rec.loc_information18 = ' || l_out_hr_loc_hook_rec.loc_information18);
626: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
627: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
628: 'l_out_hr_loc_hook_rec.loc_information19 = ' || l_out_hr_loc_hook_rec.loc_information19);
629: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
630: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
631: 'l_out_hr_loc_hook_rec.loc_information20 = ' || l_out_hr_loc_hook_rec.loc_information20);
626: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
627: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
628: 'l_out_hr_loc_hook_rec.loc_information19 = ' || l_out_hr_loc_hook_rec.loc_information19);
629: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
630: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
631: 'l_out_hr_loc_hook_rec.loc_information20 = ' || l_out_hr_loc_hook_rec.loc_information20);
632: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
633: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
634: 'l_out_hr_loc_hook_rec.attribute1 = ' || l_out_hr_loc_hook_rec.attribute1);
629: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
630: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
631: 'l_out_hr_loc_hook_rec.loc_information20 = ' || l_out_hr_loc_hook_rec.loc_information20);
632: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
633: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
634: 'l_out_hr_loc_hook_rec.attribute1 = ' || l_out_hr_loc_hook_rec.attribute1);
635: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
636: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
637: 'l_out_hr_loc_hook_rec.attribute2 = ' || l_out_hr_loc_hook_rec.attribute2);
632: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
633: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
634: 'l_out_hr_loc_hook_rec.attribute1 = ' || l_out_hr_loc_hook_rec.attribute1);
635: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
636: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
637: 'l_out_hr_loc_hook_rec.attribute2 = ' || l_out_hr_loc_hook_rec.attribute2);
638: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
639: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
640: 'l_out_hr_loc_hook_rec.attribute3 = ' || l_out_hr_loc_hook_rec.attribute3);
635: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
636: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
637: 'l_out_hr_loc_hook_rec.attribute2 = ' || l_out_hr_loc_hook_rec.attribute2);
638: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
639: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
640: 'l_out_hr_loc_hook_rec.attribute3 = ' || l_out_hr_loc_hook_rec.attribute3);
641: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
642: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
643: 'l_out_hr_loc_hook_rec.attribute4 = ' || l_out_hr_loc_hook_rec.attribute4);
638: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
639: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
640: 'l_out_hr_loc_hook_rec.attribute3 = ' || l_out_hr_loc_hook_rec.attribute3);
641: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
642: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
643: 'l_out_hr_loc_hook_rec.attribute4 = ' || l_out_hr_loc_hook_rec.attribute4);
644: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
645: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
646: 'l_out_hr_loc_hook_rec.attribute5 = ' || l_out_hr_loc_hook_rec.attribute5);
641: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
642: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
643: 'l_out_hr_loc_hook_rec.attribute4 = ' || l_out_hr_loc_hook_rec.attribute4);
644: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
645: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
646: 'l_out_hr_loc_hook_rec.attribute5 = ' || l_out_hr_loc_hook_rec.attribute5);
647: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
648: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
649: 'l_out_hr_loc_hook_rec.attribute6 = ' || l_out_hr_loc_hook_rec.attribute6);
644: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
645: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
646: 'l_out_hr_loc_hook_rec.attribute5 = ' || l_out_hr_loc_hook_rec.attribute5);
647: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
648: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
649: 'l_out_hr_loc_hook_rec.attribute6 = ' || l_out_hr_loc_hook_rec.attribute6);
650: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
651: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
652: 'l_out_hr_loc_hook_rec.attribute7 = ' || l_out_hr_loc_hook_rec.attribute7);
647: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
648: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
649: 'l_out_hr_loc_hook_rec.attribute6 = ' || l_out_hr_loc_hook_rec.attribute6);
650: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
651: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
652: 'l_out_hr_loc_hook_rec.attribute7 = ' || l_out_hr_loc_hook_rec.attribute7);
653: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
654: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
655: 'l_out_hr_loc_hook_rec.attribute8 = ' || l_out_hr_loc_hook_rec.attribute8);
650: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
651: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
652: 'l_out_hr_loc_hook_rec.attribute7 = ' || l_out_hr_loc_hook_rec.attribute7);
653: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
654: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
655: 'l_out_hr_loc_hook_rec.attribute8 = ' || l_out_hr_loc_hook_rec.attribute8);
656: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
657: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
658: 'l_out_hr_loc_hook_rec.attribute9 = ' || l_out_hr_loc_hook_rec.attribute9);
653: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
654: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
655: 'l_out_hr_loc_hook_rec.attribute8 = ' || l_out_hr_loc_hook_rec.attribute8);
656: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
657: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
658: 'l_out_hr_loc_hook_rec.attribute9 = ' || l_out_hr_loc_hook_rec.attribute9);
659: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
660: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
661: 'l_out_hr_loc_hook_rec.attribute10 = ' || l_out_hr_loc_hook_rec.attribute10);
656: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
657: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
658: 'l_out_hr_loc_hook_rec.attribute9 = ' || l_out_hr_loc_hook_rec.attribute9);
659: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
660: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
661: 'l_out_hr_loc_hook_rec.attribute10 = ' || l_out_hr_loc_hook_rec.attribute10);
662: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
663: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
664: 'l_out_hr_loc_hook_rec.attribute11 = ' || l_out_hr_loc_hook_rec.attribute11);
659: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
660: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
661: 'l_out_hr_loc_hook_rec.attribute10 = ' || l_out_hr_loc_hook_rec.attribute10);
662: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
663: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
664: 'l_out_hr_loc_hook_rec.attribute11 = ' || l_out_hr_loc_hook_rec.attribute11);
665: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
666: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
667: 'l_out_hr_loc_hook_rec.attribute12 = ' || l_out_hr_loc_hook_rec.attribute12);
662: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
663: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
664: 'l_out_hr_loc_hook_rec.attribute11 = ' || l_out_hr_loc_hook_rec.attribute11);
665: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
666: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
667: 'l_out_hr_loc_hook_rec.attribute12 = ' || l_out_hr_loc_hook_rec.attribute12);
668: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
669: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
670: 'l_out_hr_loc_hook_rec.attribute13 = ' || l_out_hr_loc_hook_rec.attribute13);
665: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
666: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
667: 'l_out_hr_loc_hook_rec.attribute12 = ' || l_out_hr_loc_hook_rec.attribute12);
668: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
669: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
670: 'l_out_hr_loc_hook_rec.attribute13 = ' || l_out_hr_loc_hook_rec.attribute13);
671: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
672: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
673: 'l_out_hr_loc_hook_rec.attribute14 = ' || l_out_hr_loc_hook_rec.attribute14);
668: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
669: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
670: 'l_out_hr_loc_hook_rec.attribute13 = ' || l_out_hr_loc_hook_rec.attribute13);
671: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
672: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
673: 'l_out_hr_loc_hook_rec.attribute14 = ' || l_out_hr_loc_hook_rec.attribute14);
674: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
675: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
676: 'l_out_hr_loc_hook_rec.attribute15 = ' || l_out_hr_loc_hook_rec.attribute15);
671: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
672: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
673: 'l_out_hr_loc_hook_rec.attribute14 = ' || l_out_hr_loc_hook_rec.attribute14);
674: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
675: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
676: 'l_out_hr_loc_hook_rec.attribute15 = ' || l_out_hr_loc_hook_rec.attribute15);
677: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
678: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
679: 'l_out_hr_loc_hook_rec.attribute16 = ' || l_out_hr_loc_hook_rec.attribute16);
674: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
675: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
676: 'l_out_hr_loc_hook_rec.attribute15 = ' || l_out_hr_loc_hook_rec.attribute15);
677: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
678: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
679: 'l_out_hr_loc_hook_rec.attribute16 = ' || l_out_hr_loc_hook_rec.attribute16);
680: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
681: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
682: 'l_out_hr_loc_hook_rec.attribute17 = ' || l_out_hr_loc_hook_rec.attribute17);
677: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
678: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
679: 'l_out_hr_loc_hook_rec.attribute16 = ' || l_out_hr_loc_hook_rec.attribute16);
680: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
681: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
682: 'l_out_hr_loc_hook_rec.attribute17 = ' || l_out_hr_loc_hook_rec.attribute17);
683: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
684: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
685: 'l_out_hr_loc_hook_rec.attribute18 = ' || l_out_hr_loc_hook_rec.attribute18);
680: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
681: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
682: 'l_out_hr_loc_hook_rec.attribute17 = ' || l_out_hr_loc_hook_rec.attribute17);
683: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
684: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
685: 'l_out_hr_loc_hook_rec.attribute18 = ' || l_out_hr_loc_hook_rec.attribute18);
686: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
687: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
688: 'l_out_hr_loc_hook_rec.attribute19 = ' || l_out_hr_loc_hook_rec.attribute19);
683: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
684: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
685: 'l_out_hr_loc_hook_rec.attribute18 = ' || l_out_hr_loc_hook_rec.attribute18);
686: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
687: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
688: 'l_out_hr_loc_hook_rec.attribute19 = ' || l_out_hr_loc_hook_rec.attribute19);
689: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
690: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
691: 'l_out_hr_loc_hook_rec.attribute20 = ' || l_out_hr_loc_hook_rec.attribute20);
686: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
687: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
688: 'l_out_hr_loc_hook_rec.attribute19 = ' || l_out_hr_loc_hook_rec.attribute19);
689: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
690: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
691: 'l_out_hr_loc_hook_rec.attribute20 = ' || l_out_hr_loc_hook_rec.attribute20);
692: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
693: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
694: 'l_out_hr_loc_hook_rec.attribute_category = ' || l_out_hr_loc_hook_rec.attribute_category);
689: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
690: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
691: 'l_out_hr_loc_hook_rec.attribute20 = ' || l_out_hr_loc_hook_rec.attribute20);
692: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
693: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
694: 'l_out_hr_loc_hook_rec.attribute_category = ' || l_out_hr_loc_hook_rec.attribute_category);
695: end if;
696:
697: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
695: end if;
696:
697: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
698: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
699: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
700: 'Before calling hr_location_api.create_location...');
701: end if;
702:
703: hr_location_api.create_location(
764: );
765:
766: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
767: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
768: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
769: 'After calling hr_location_api.create_location...');
770: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
771: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
772: 'x_msg_count=' || x_msg_count || ', x_msg_data=' || x_msg_data);
767: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
768: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
769: 'After calling hr_location_api.create_location...');
770: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
771: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
772: 'x_msg_count=' || x_msg_count || ', x_msg_data=' || x_msg_data);
773: end if;
774:
775: fnd_msg_pub.count_and_get
777: , p_data => x_msg_data);
778:
779: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
780: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
781: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
782: 'x_msg_count=' || x_msg_count || ', x_msg_data=' || x_msg_data);
783: end if;
784:
785: -- Exception Block
787: WHEN EXCP_USER_DEFINED THEN
788:
789: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
790: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
791: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
792: 'In EXCP_USER_DEFINED block');
793: end if;
794:
795: Rollback to do_create_ship_to_location_PUB;
805: WHEN FND_API.G_EXC_ERROR THEN
806:
807: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
808: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
809: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
810: 'In FND_API.G_EXC_ERROR block');
811: end if;
812:
813: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
822:
823: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
824: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
825: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
826: 'In FND_API.G_EXC_UNEXPECTED_ERROR block');
827: end if;
828:
829: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
837: WHEN OTHERS THEN
838:
839: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
840: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
841: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
842: 'In OTHERS block');
843: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
844: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
845: 'sqlerrm = ' || sqlerrm);
840: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
841: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
842: 'In OTHERS block');
843: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
844: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',
845: 'sqlerrm = ' || sqlerrm);
846: end if;
847:
848: Rollback to do_create_ship_to_location_PUB;
3129:
3130: BEGIN
3131: SAVEPOINT ship_to_address_handler_PUB;
3132:
3133: l_module_name := 'csp.plsql.csp_ship_to_address_pvt.ship_to_address_handler1';
3134:
3135: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3136: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3137: l_module_name,
3155: END IF;
3156:
3157: x_return_status := FND_API.G_RET_STS_SUCCESS;
3158: select userenv('LANG') into s_language from dual;
3159: csp_ship_to_address_pvt.g_rs_cust_relation_id := null;
3160: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','SHIP_TO_ADDRESS_HANDLER','B',x_return_status);
3161:
3162: -- If task assignment id and addresses are both null, return error.
3163: IF (p_task_assignment_id IS NULL) and (p_country IS NULL) THEN
3156:
3157: x_return_status := FND_API.G_RET_STS_SUCCESS;
3158: select userenv('LANG') into s_language from dual;
3159: csp_ship_to_address_pvt.g_rs_cust_relation_id := null;
3160: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','SHIP_TO_ADDRESS_HANDLER','B',x_return_status);
3161:
3162: -- If task assignment id and addresses are both null, return error.
3163: IF (p_task_assignment_id IS NULL) and (p_country IS NULL) THEN
3164: FND_MESSAGE.SET_NAME ('CSP', 'CSP_TSK_ASSGN_ID_OR_ADDR_REQD');
3361: -- Retrieve customer_id from CSP_RS_CUST_RELATIONS
3362: -- If found, no need to create new customer account for this resource
3363: OPEN l_customer_id_csr;
3364: FETCH l_customer_id_csr INTO l_rs_cust_relation_id,l_customer_id;
3365: csp_ship_to_address_pvt.g_rs_cust_relation_id := l_rs_cust_relation_id;
3366: IF l_customer_id_csr%FOUND and l_customer_id IS NOT NULL THEN
3367: CLOSE l_customer_id_csr;
3368:
3369: -- Use the customer_id to retrieve party_id from hz_cust_accounts
4288: p_customer_id := l_customer_id;
4289:
4290: -- -- Create or update resource/customer relationship record in csp_rs_cust_relations
4291: -- do_rs_cust_relations(l_resource_type, l_resource_id, l_resource_name, l_customer_id);
4292: csp_ship_to_address_pvt.g_inv_loc_id := l_inv_location_id;
4293: IF l_process_type = 'INSERT' THEN
4294: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','SHIP_TO_ADDRESS_HANDLER','A',x_return_status);
4295: ELSIF l_process_type = 'UPDATE' THEN
4296: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','UPDATE_LOCATION','A',x_return_status);
4290: -- -- Create or update resource/customer relationship record in csp_rs_cust_relations
4291: -- do_rs_cust_relations(l_resource_type, l_resource_id, l_resource_name, l_customer_id);
4292: csp_ship_to_address_pvt.g_inv_loc_id := l_inv_location_id;
4293: IF l_process_type = 'INSERT' THEN
4294: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','SHIP_TO_ADDRESS_HANDLER','A',x_return_status);
4295: ELSIF l_process_type = 'UPDATE' THEN
4296: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','UPDATE_LOCATION','A',x_return_status);
4297: END IF;
4298: -- If no error occurs, commit.
4292: csp_ship_to_address_pvt.g_inv_loc_id := l_inv_location_id;
4293: IF l_process_type = 'INSERT' THEN
4294: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','SHIP_TO_ADDRESS_HANDLER','A',x_return_status);
4295: ELSIF l_process_type = 'UPDATE' THEN
4296: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','UPDATE_LOCATION','A',x_return_status);
4297: END IF;
4298: -- If no error occurs, commit.
4299: IF p_commit = FND_API.G_TRUE THEN
4300: COMMIT;
4643: BEGIN
4644:
4645: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4646: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4647: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4648: 'Begin');
4649: end if;
4650:
4651: SAVEPOINT site_to_invloc_linkage_PUB;
4659: G_PKG_NAME) THEN
4660:
4661: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4662: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4663: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4664: 'In FND_API.Compatible_API_Call');
4665: end if;
4666:
4667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4674: FND_MESSAGE.SET_NAME ('CSP', 'CSP_SITE_USE_ID_REQD');
4675: FND_MSG_PUB.ADD;
4676: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4677: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4678: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4679: 'In CSP_SITE_USE_ID_REQD error');
4680: end if;
4681: RAISE EXCP_USER_DEFINED;
4682: END IF;
4682: END IF;
4683: IF fnd_profile.value('CSP_INTRANSIT_LOCATION_USED') = 'Y' THEN
4684: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4685: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4686: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4687: 'In CSP_INTRANSIT_LOCATION_USED condition');
4688: end if;
4689: -- If address fields are not null, create a new inventory location. Otherwise, return error.
4690: IF p_country IS NOT NULL THEN
4689: -- If address fields are not null, create a new inventory location. Otherwise, return error.
4690: IF p_country IS NOT NULL THEN
4691: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4692: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4693: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4694: 'In CSP_INTRANSIT_LOCATION_USED : p_country condition');
4695: end if;
4696: if p_country = 'US' THEN
4697: l_town_or_city := initcap(p_town_or_city);
4701: l_region_1 :=p_region_1;
4702: end if;
4703: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4704: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4705: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4706: 'l_town_or_city = ' || l_town_or_city
4707: || ', l_region_1' || l_region_1);
4708: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4709: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4705: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4706: 'l_town_or_city = ' || l_town_or_city
4707: || ', l_region_1' || l_region_1);
4708: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4709: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4710: 'Before calling do_create_ship_to_location');
4711: end if;
4712: do_create_ship_to_location(
4713: p_location_id => p_location_id,
4760: x_msg_data => x_msg_data);
4761:
4762: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4763: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4764: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4765: 'After do_create_ship_to_location... x_return_status = ' || x_return_status);
4766: end if;
4767:
4768: l_inv_loc_id := p_location_id;
4775: ELSE
4776:
4777: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4778: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4779: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4780: 'p_address_id = ' || p_address_id);
4781: end if;
4782:
4783: SELECT org_id
4786: WHERE cust_acct_site_id = p_address_id;
4787:
4788: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4789: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4790: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4791: 'l_org_id = ' || l_org_id);
4792: end if;
4793:
4794: /*
4800: l_ou_id := l_org_id;
4801:
4802: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4803: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4804: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4805: 'l_ou_id = ' || l_ou_id);
4806: end if;
4807:
4808: SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10)))
4810: FROM dual;
4811:
4812: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4813: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4814: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4815: 'l_org_id = ' || l_org_id);
4816: end if;
4817:
4818: mo_global.set_policy_context('S', l_ou_id);
4818: mo_global.set_policy_context('S', l_ou_id);
4819:
4820: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4821: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4822: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4823: 'Before calling arp_clas_pkg.insert_po_loc_associations');
4824: end if;
4825:
4826: select cust_account_id into l_cust_acct_id
4828: where cust_acct_site_id = p_address_id;
4829:
4830: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4831: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4832: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4833: 'l_cust_acct_id = ' || l_cust_acct_id);
4834: end if;
4835:
4836: -- Create the linkage between the site use and the inventory location.
4847: mo_global.set_policy_context('S', l_org_id);
4848:
4849: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4850: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4851: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4852: 'After calling arp_clas_pkg.insert_po_loc_associations');
4853: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4854: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4855: 'x_return_status = ' || x_return_status);
4850: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4851: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4852: 'After calling arp_clas_pkg.insert_po_loc_associations');
4853: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4854: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4855: 'x_return_status = ' || x_return_status);
4856: end if;
4857:
4858: IF x_return_status in ('E','U') THEN
4864: ELSE
4865: Rollback to site_to_invloc_linkage_PUB;
4866: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4867: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4868: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4869: 'p_country is NULL');
4870: end if;
4871: FND_MESSAGE.SET_NAME ('CSP', 'CSP_ADDRESS_REQD');
4872: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
4875: END IF;
4876: ELSE
4877: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4878: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4879: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4880: 'Else part : CSP_INTRANSIT_LOCATION_USED is N');
4881: end if;
4882:
4883: OPEN get_csp_location;
4885: CLOSE get_csp_location;
4886:
4887: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4888: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4889: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4890: 'csp_location_rec.country = ' || csp_location_rec.country);
4891: end if;
4892:
4893: IF csp_location_rec.country IS NULL THEN
4901: IF p_country IS NOT NULL THEN
4902:
4903: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4904: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4905: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4906: 'p_country is NOT NULL and p_country = ' || p_country);
4907: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4908: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4909: 'Before calling do_create_ship_to_location...');
4904: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4905: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4906: 'p_country is NOT NULL and p_country = ' || p_country);
4907: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4908: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4909: 'Before calling do_create_ship_to_location...');
4910: end if;
4911:
4912: do_create_ship_to_location(
4960: x_msg_data => x_msg_data);
4961:
4962: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4963: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4964: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4965: 'After do_create_ship_to_location... with x_return_status = ' || x_return_status);
4966: end if;
4967:
4968: l_inv_loc_id := p_location_id;
4975: ELSE
4976:
4977: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4978: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4979: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4980: 'p_address_id = ' || p_address_id);
4981: end if;
4982:
4983: SELECT org_id
4986: WHERE cust_acct_site_id = p_address_id;
4987:
4988: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4989: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4990: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4991: 'l_org_id = ' || l_org_id);
4992: end if;
4993:
4994: /*
5000: l_ou_id := l_org_id;
5001:
5002: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5003: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5004: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
5005: 'l_ou_id = ' || l_ou_id);
5006: end if;
5007:
5008: SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10)))
5010: FROM dual;
5011:
5012: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5013: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5014: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
5015: 'l_org_id = ' || l_org_id);
5016: end if;
5017:
5018: mo_global.set_policy_context('S', l_ou_id);
5018: mo_global.set_policy_context('S', l_ou_id);
5019:
5020: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5021: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5022: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
5023: 'Before arp_clas_pkg.insert_po_loc_associations...');
5024: end if;
5025:
5026: -- Create the linkage between the site use and the inventory location.
5037: mo_global.set_policy_context('S', l_org_id);
5038:
5039: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5040: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5041: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
5042: 'After arp_clas_pkg.insert_po_loc_associations...');
5043: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5044: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
5045: 'x_return_status = ' || x_return_status);
5040: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5041: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
5042: 'After arp_clas_pkg.insert_po_loc_associations...');
5043: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5044: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
5045: 'x_return_status = ' || x_return_status);
5046: end if;
5047:
5048: IF x_return_status in ('E','U') THEN
5054: ELSE
5055: Rollback to site_to_invloc_linkage_PUB;
5056: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5058: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
5059: 'p_country is NULL...');
5060: end if;
5061: /*FND_MESSAGE.SET_NAME ('CSP', 'CSP_ADDRESS_REQD');
5062: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
5071: ( p_count => x_msg_count
5072: , p_data => x_msg_data);
5073: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5074: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5075: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
5076: 'In EXCP_USER_DEFINED block');
5077: end if;
5078: WHEN FND_API.G_EXC_ERROR THEN
5079: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
5085: ,X_MSG_DATA => x_MSG_DATA
5086: ,X_RETURN_STATUS => x_RETURN_STATUS);
5087: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5088: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5089: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
5090: 'In FND_API.G_EXC_ERROR block');
5091: end if;
5092: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5093: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
5099: ,X_MSG_DATA => x_MSG_DATA
5100: ,X_RETURN_STATUS => x_RETURN_STATUS);
5101: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5102: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5103: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
5104: 'In FND_API.G_EXC_UNEXPECTED_ERROR block');
5105: end if;
5106: WHEN OTHERS THEN
5107: Rollback to site_to_invloc_linkage_PUB;
5106: WHEN OTHERS THEN
5107: Rollback to site_to_invloc_linkage_PUB;
5108: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5109: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5110: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
5111: 'In Others block... sqlerrm = ' || sqlerrm);
5112: end if;
5113: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
5114: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
5139:
5140: v_cursorid INTEGER;
5141: v_blockstr VARCHAR2(2000);
5142: v_dummy INTEGER;
5143: l_module_name VARCHAR2(100) := 'csp.plsql.csp_ship_to_address_pvt.call_internal_hook';
5144: BEGIN
5145:
5146: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5147: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5330: l_org_id := mo_global.get_current_org_id;
5331:
5332: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5333: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5334: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.cust_inv_loc_link',
5335: 'l_org_id = ' || l_org_id);
5336: end if;
5337:
5338: if l_org_id is null then
5345: END;
5346:
5347: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5348: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5349: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.cust_inv_loc_link',
5350: 'l_org_id = ' || l_org_id);
5351: end if;
5352:
5353: OPEN site_use_cur;
5355: CLOSE site_use_cur;
5356:
5357: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5358: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5359: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.cust_inv_loc_link',
5360: 'l_site_use_id = ' || l_site_use_id);
5361: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5362: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.cust_inv_loc_link',
5363: 'l_address_id = ' || l_address_id);
5358: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5359: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.cust_inv_loc_link',
5360: 'l_site_use_id = ' || l_site_use_id);
5361: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5362: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.cust_inv_loc_link',
5363: 'l_address_id = ' || l_address_id);
5364: end if;
5365:
5366: -- do a check to see if inventory location already exists, execute foll.code
5396: END IF;
5397:
5398: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5399: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5400: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.cust_inv_loc_link',
5401: 'Before calling site_to_invloc_linkage...');
5402: end if;
5403:
5404: site_to_invloc_linkage(
5808: ,x_return_status OUT NOCOPY VARCHAR2
5809: ,x_msg_count OUT NOCOPY NUMBER
5810: ,x_msg_data OUT NOCOPY VARCHAR2
5811: ) IS
5812: l_module_name VARCHAR2(100) := 'csp.plsql.csp_ship_to_address_pvt.copy_hz_cust_site';
5813: l_current_org_id NUMBER;
5814: l_msg varchar2(2000);
5815: v_cust_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
5816: x_cust_acct_site_id NUMBER;
6345: hra.attribute20
6346: FROM hr_locations_all hra
6347: where hra.location_id = p_location_id;
6348: BEGIN
6349: l_module_name := 'csp.plsql.csp_ship_to_address_pvt.ship_to_address_handler2';
6350: v_location_id := p_location_id;
6351:
6352: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6353: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6487: end if;
6488:
6489: END;
6490:
6491: END CSP_SHIP_TO_ADDRESS_PVT;