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

APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on FND_LOG

Line 259: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

255: l_out_hr_loc_hook_rec hr_location_record.location_rectype;
256:
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;

Line 260: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

Line 271: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

267: -- Initialize
268: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 272: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

268: x_return_status := FND_API.G_RET_STS_SUCCESS;
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:

Line 281: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

277: -- Assign location code
278: select csp_location_id_s1.NEXTVAL into l_location_code from dual;
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;

Line 282: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

278: select csp_location_id_s1.NEXTVAL into l_location_code from dual;
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:

Line 347: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

343: l_in_hr_loc_hook_rec.attribute19 := p_attribute19;
344: l_in_hr_loc_hook_rec.attribute20 := p_attribute20;
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,

Line 348: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

344: l_in_hr_loc_hook_rec.attribute20 := p_attribute20;
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',

Line 351: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
354: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
355: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 354: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
357: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
358: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 357: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
360: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
361: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 360: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
364: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
366: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
367: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 366: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
369: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
370: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 369: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
372: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
373: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 372: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
375: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
376: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 375: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
378: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
379: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 378: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
381: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
382: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 381: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
384: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
385: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 384: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
387: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
388: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 387: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
390: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
391: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 390: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
393: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
394: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 393: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
396: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
397: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 396: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
399: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
400: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 399: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
402: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
403: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 402: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
405: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
406: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 405: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
408: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
409: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 408: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
411: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
412: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 411: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
414: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
415: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 414: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
417: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
418: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 417: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
420: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
421: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 420: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
423: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
424: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 423: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
426: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
427: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 426: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
429: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
430: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 429: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
432: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
433: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 432: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
435: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
436: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 435: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
438: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
439: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 438: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
441: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
442: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 441: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
444: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
445: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 444: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
447: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
448: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 447: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
450: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
451: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 450: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
453: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
454: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 453: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
456: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
457: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 456: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
459: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
460: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 459: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
462: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
463: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 462: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
465: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
466: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 465: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
468: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
469: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 468: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
471: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
472: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 471: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
474: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
475: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 474: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
477: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
478: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 477: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
480: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
481: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 480: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
484: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
487: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
489: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
490: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 489: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
492: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
493: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 492: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
495: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
496: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 495: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
498: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
499: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 498: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
502: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
504: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
505: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 504: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
507: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
508: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 507: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
511: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
513: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
514: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 513: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
516: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
517: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 516: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
519: end if;
520:

Line 523: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

519: end if;
520:
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,

Line 524: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

520:
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',

Line 527: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
530: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
531: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 530: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
534: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
536: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
537: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 536: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
539: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
540: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 539: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
543: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
545: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
546: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 545: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
548: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
549: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 548: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
551: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
552: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 551: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
554: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
555: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 554: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
557: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
558: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 557: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
560: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
561: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 560: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
563: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
564: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 563: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
566: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
567: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 566: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
569: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
570: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 569: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
573: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
576: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
578: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
579: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 578: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
581: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
582: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 581: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
585: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
587: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
588: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 587: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
590: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
591: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 590: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
593: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
594: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 593: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
596: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
597: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 596: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
599: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
600: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 599: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
602: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
603: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 602: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
605: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
606: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 605: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
608: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
609: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 608: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
611: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
612: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 611: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
614: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
615: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 614: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
617: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
618: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 617: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
620: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
621: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 620: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
623: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
624: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 623: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
626: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
627: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 626: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
629: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
630: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 629: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
632: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
633: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 632: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
635: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
636: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 635: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
638: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
639: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 638: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
641: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
642: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 641: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
644: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
645: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 644: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
647: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
648: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 647: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
650: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
651: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 650: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
653: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
654: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 653: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
656: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
657: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 656: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
659: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
660: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 659: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
662: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
663: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 662: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
665: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
666: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 665: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
668: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
669: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 668: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
671: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
672: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 671: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
674: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
675: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 674: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
677: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
678: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 677: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
680: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
681: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 680: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
683: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
684: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 683: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
686: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
687: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 686: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
689: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
690: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 689: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
692: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
693: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 692: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
695: end if;
696:

Line 697: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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
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;

Line 698: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

Line 766: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

762: p_attribute20 => l_out_hr_loc_hook_rec.attribute20,
763: p_attribute_category => l_out_hr_loc_hook_rec.attribute_category
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,

Line 767: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

763: p_attribute_category => l_out_hr_loc_hook_rec.attribute_category
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',

Line 770: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
773: end if;
774:

Line 779: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

775: fnd_msg_pub.count_and_get
776: ( p_count => x_msg_count
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;

Line 780: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

776: ( p_count => x_msg_count
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:

Line 789: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

785: -- Exception Block
786: EXCEPTION
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;

Line 790: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

Line 807: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

803: ,X_MSG_DATA => x_MSG_DATA
804: ,X_RETURN_STATUS => x_RETURN_STATUS);
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;

Line 808: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

804: ,X_RETURN_STATUS => x_RETURN_STATUS);
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:

Line 823: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

819: ,X_MSG_DATA => x_MSG_DATA
820: ,X_RETURN_STATUS => x_RETURN_STATUS);
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;

Line 824: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

820: ,X_RETURN_STATUS => x_RETURN_STATUS);
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:

Line 839: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

835: ,X_MSG_DATA => x_MSG_DATA
836: ,X_RETURN_STATUS => x_RETURN_STATUS);
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,

Line 840: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

836: ,X_RETURN_STATUS => x_RETURN_STATUS);
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',

Line 843: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
846: end if;
847:

Line 3135: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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,
3138: 'Begin... p_resource_type=' || p_resource_type
3139: || ', p_resource_id=' || p_resource_id

Line 3136: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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,
3138: 'Begin... p_resource_type=' || p_resource_type
3139: || ', p_resource_id=' || p_resource_id
3140: || ', p_location_id=' || p_location_id

Line 4645: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4641: l_ou_id number;
4642: l_cust_acct_id number; -- bug # 12545721
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;

Line 4646: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4642: l_cust_acct_id number; -- bug # 12545721
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:

Line 4661: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4657: p_api_version_number,
4658: l_api_name,
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;

Line 4662: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4658: l_api_name,
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:

Line 4676: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4672: -- If site use id is null, return error.
4673: IF p_site_use_id IS NULL THEN
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;

Line 4677: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4673: IF p_site_use_id IS NULL THEN
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;

Line 4684: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4680: end if;
4681: RAISE EXCP_USER_DEFINED;
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;

Line 4685: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4681: RAISE EXCP_USER_DEFINED;
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.

Line 4691: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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
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;

Line 4692: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

Line 4703: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4699: else
4700: l_town_or_city := 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);

Line 4704: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4700: l_town_or_city := 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,

Line 4708: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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',
4710: 'Before calling do_create_ship_to_location');
4711: end if;
4712: do_create_ship_to_location(

Line 4762: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4758: x_return_status => x_return_status,
4759: x_msg_count => x_msg_count,
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;

Line 4763: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4759: x_msg_count => x_msg_count,
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:

Line 4777: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4773: FND_MSG_PUB.ADD;*/
4774: RAISE EXCP_USER_DEFINED;
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;

Line 4778: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4774: RAISE EXCP_USER_DEFINED;
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:

Line 4788: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4784: INTO l_org_id
4785: FROM HZ_CUST_ACCT_SITES_ALL
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;

Line 4789: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4785: FROM HZ_CUST_ACCT_SITES_ALL
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:

Line 4802: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4798: where organization_id = l_org_id;
4799: */
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;

Line 4803: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4799: */
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:

Line 4812: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4808: SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10)))
4809: INTO l_org_id
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;

Line 4813: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4809: INTO l_org_id
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:

Line 4820: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4816: end if;
4817:
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;

Line 4821: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

Line 4830: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4826: select cust_account_id into l_cust_acct_id
4827: from hz_cust_acct_sites_all
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;

Line 4831: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4827: from hz_cust_acct_sites_all
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:

Line 4849: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4845: x_msg_data => x_msg_data);
4846:
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,

Line 4850: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4846:
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',

Line 4853: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
4856: end if;
4857:

Line 4866: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4862:
4863: END IF;
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;

Line 4867: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4863: END IF;
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');

Line 4877: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4873: FND_MSG_PUB.ADD;
4874: RAISE EXCP_USER_DEFINED;
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;

Line 4878: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4874: RAISE EXCP_USER_DEFINED;
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:

Line 4887: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4883: OPEN get_csp_location;
4884: FETCH get_csp_location INTO csp_location_rec;
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;

Line 4888: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4884: FETCH get_csp_location INTO csp_location_rec;
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:

Line 4903: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4899:
4900: -- If address fields are not null, create a new inventory location. Otherwise, return error.
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,

Line 4904: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4900: -- If address fields are not null, create a new inventory location. Otherwise, return error.
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',

Line 4907: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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...');
4910: end if;
4911:

Line 4962: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4958: x_return_status => x_return_status,
4959: x_msg_count => x_msg_count,
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;

Line 4963: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4959: x_msg_count => x_msg_count,
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:

Line 4977: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4973: FND_MSG_PUB.ADD;*/
4974: RAISE EXCP_USER_DEFINED;
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;

Line 4978: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4974: RAISE EXCP_USER_DEFINED;
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:

Line 4988: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4984: INTO l_org_id
4985: FROM HZ_CUST_ACCT_SITES_ALL
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;

Line 4989: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4985: FROM HZ_CUST_ACCT_SITES_ALL
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:

Line 5002: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4998: where organization_id = l_org_id;
4999: */
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;

Line 5003: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4999: */
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:

Line 5012: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5008: SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10)))
5009: INTO l_org_id
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;

Line 5013: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5009: INTO l_org_id
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:

Line 5020: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5016: end if;
5017:
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;

Line 5021: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

Line 5039: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5035: x_msg_data => x_msg_data);
5036:
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,

Line 5040: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5036:
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',

Line 5043: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
5046: end if;
5047:

Line 5056: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5052:
5053: END IF;
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;

Line 5057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5053: END IF;
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');

Line 5073: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5069: x_return_status := FND_API.G_RET_STS_ERROR;
5070: fnd_msg_pub.count_and_get
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;

Line 5074: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5070: fnd_msg_pub.count_and_get
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

Line 5087: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5083: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
5084: ,X_MSG_COUNT => x_MSG_COUNT
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;

Line 5088: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5084: ,X_MSG_COUNT => x_MSG_COUNT
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

Line 5101: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5097: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
5098: ,X_MSG_COUNT => x_MSG_COUNT
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;

Line 5102: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5098: ,X_MSG_COUNT => x_MSG_COUNT
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

Line 5108: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5104: 'In FND_API.G_EXC_UNEXPECTED_ERROR block');
5105: end if;
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;

Line 5109: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5105: end if;
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');

Line 5146: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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,
5148: l_module_name,
5149: 'BEGIN...');
5150: end if;

Line 5147: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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,
5148: l_module_name,
5149: 'BEGIN...');
5150: end if;
5151:

Line 5160: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5156: v_cursorid := DBMS_SQL.open_cursor;
5157: v_blockstr :=
5158: ' begin ' || i.hook_package || '.' || i.hook_api || '(:1); end; ';
5159:
5160: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5161: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5162: l_module_name,
5163: 'calling hook API...');
5164: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 5161: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5157: v_blockstr :=
5158: ' begin ' || i.hook_package || '.' || i.hook_api || '(:1); end; ';
5159:
5160: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5161: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5162: l_module_name,
5163: 'calling hook API...');
5164: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5165: l_module_name,

Line 5164: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5160: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5161: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5162: l_module_name,
5163: 'calling hook API...');
5164: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5165: l_module_name,
5166: 'i.hook_package = ' || i.hook_package);
5167: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5168: l_module_name,

Line 5167: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5163: 'calling hook API...');
5164: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5165: l_module_name,
5166: 'i.hook_package = ' || i.hook_package);
5167: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5168: l_module_name,
5169: 'i.hook_api = ' || i.hook_api);
5170: end if;
5171:

Line 5178: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5174: v_dummy := DBMS_SQL.execute (v_cursorid);
5175: DBMS_SQL.variable_value (v_cursorid, ':1', x_return_status);
5176: DBMS_SQL.close_cursor (v_cursorid);
5177:
5178: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5179: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5180: l_module_name,
5181: 'x_return_status = ' || x_return_status);
5182: end if;

Line 5179: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5175: DBMS_SQL.variable_value (v_cursorid, ':1', x_return_status);
5176: DBMS_SQL.close_cursor (v_cursorid);
5177:
5178: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5179: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5180: l_module_name,
5181: 'x_return_status = ' || x_return_status);
5182: end if;
5183:

Line 5332: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5328: INTO l_org_id
5329: FROM DUAL;*/
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;

Line 5333: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5329: FROM DUAL;*/
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:

Line 5347: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5343: l_org_id := p_org_id;
5344: end if;
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;

Line 5348: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

Line 5357: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5353: OPEN site_use_cur;
5354: FETCH site_use_cur INTO l_site_use_id, l_address_id;
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,

Line 5358: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5354: FETCH site_use_cur INTO l_site_use_id, l_address_id;
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',

Line 5361: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
5364: end if;
5365:

Line 5398: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5394: END;
5395:
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;

Line 5399: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

Line 5551: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5547: AND site_use_id = p_rs_site_use_id;
5548:
5549: BEGIN
5550:
5551: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5552: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5553: 'csp.plsql.'|| G_PKG_NAME ||'.rs_primary_ship_to_addr',
5554: 'Begin');
5555:

Line 5552: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5548:
5549: BEGIN
5550:
5551: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5552: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5553: 'csp.plsql.'|| G_PKG_NAME ||'.rs_primary_ship_to_addr',
5554: 'Begin');
5555:
5556: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 5556: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5552: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5553: 'csp.plsql.'|| G_PKG_NAME ||'.rs_primary_ship_to_addr',
5554: 'Begin');
5555:
5556: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5557: 'csp.plsql.'|| G_PKG_NAME ||'.rs_primary_ship_to_addr',
5558: 'Parameters are: '
5559: || 'p_api_version=' || p_api_version
5560: || ',p_Init_Msg_List=' || p_Init_Msg_List

Line 5594: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5590: l_old_inv_loc_id,
5591: l_old_status;
5592: close rs_current_primary_addr;
5593:
5594: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5595: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5596: 'csp.plsql.'|| G_PKG_NAME ||'.rs_primary_ship_to_addr',
5597: 'l_old_site_use_id=' || l_old_site_use_id
5598: || ',l_customer_id=' || l_customer_id

Line 5595: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5591: l_old_status;
5592: close rs_current_primary_addr;
5593:
5594: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5595: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5596: 'csp.plsql.'|| G_PKG_NAME ||'.rs_primary_ship_to_addr',
5597: 'l_old_site_use_id=' || l_old_site_use_id
5598: || ',l_customer_id=' || l_customer_id
5599: || ',l_old_inv_loc_id=' || l_old_inv_loc_id

Line 5620: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5616: X_MSG_COUNT => x_msg_count,
5617: X_MSG_DATA => x_msg_data
5618: );
5619:
5620: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5621: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5622: 'csp.plsql.'|| G_PKG_NAME ||'.rs_primary_ship_to_addr',
5623: 'x_return_status=' || x_return_status
5624: || ',x_msg_count=' || x_msg_count

Line 5621: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5617: X_MSG_DATA => x_msg_data
5618: );
5619:
5620: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5621: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5622: 'csp.plsql.'|| G_PKG_NAME ||'.rs_primary_ship_to_addr',
5623: 'x_return_status=' || x_return_status
5624: || ',x_msg_count=' || x_msg_count
5625: || ',x_msg_data=' || x_msg_data);

Line 5648: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5644: l_new_inv_loc_id,
5645: l_new_status;
5646: close rs_get_ship_to_addr;
5647:
5648: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5649: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5650: 'csp.plsql.'|| G_PKG_NAME ||'.rs_primary_ship_to_addr',
5651: 'p_rs_site_use_id=' || p_rs_site_use_id
5652: || ',l_customer_id=' || l_customer_id

Line 5649: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5645: l_new_status;
5646: close rs_get_ship_to_addr;
5647:
5648: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5649: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5650: 'csp.plsql.'|| G_PKG_NAME ||'.rs_primary_ship_to_addr',
5651: 'p_rs_site_use_id=' || p_rs_site_use_id
5652: || ',l_customer_id=' || l_customer_id
5653: || ',l_new_inv_loc_id=' || l_new_inv_loc_id

Line 5668: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5664: X_MSG_COUNT => x_msg_count,
5665: X_MSG_DATA => x_msg_data
5666: );
5667:
5668: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5669: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5670: 'csp.plsql.'|| G_PKG_NAME ||'.rs_primary_ship_to_addr',
5671: 'x_return_status=' || x_return_status
5672: || ',x_msg_count=' || x_msg_count

Line 5669: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5665: X_MSG_DATA => x_msg_data
5666: );
5667:
5668: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5669: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5670: 'csp.plsql.'|| G_PKG_NAME ||'.rs_primary_ship_to_addr',
5671: 'x_return_status=' || x_return_status
5672: || ',x_msg_count=' || x_msg_count
5673: || ',x_msg_data=' || x_msg_data);

Line 5727: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5723: AND site_use_id = p_rs_site_use_id;
5724:
5725: BEGIN
5726:
5727: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5728: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5729: 'csp.plsql.'|| G_PKG_NAME ||'.rs_inactivate_ship_to',
5730: 'Begin');
5731:

Line 5728: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5724:
5725: BEGIN
5726:
5727: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5728: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5729: 'csp.plsql.'|| G_PKG_NAME ||'.rs_inactivate_ship_to',
5730: 'Begin');
5731:
5732: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 5732: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5728: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5729: 'csp.plsql.'|| G_PKG_NAME ||'.rs_inactivate_ship_to',
5730: 'Begin');
5731:
5732: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5733: 'csp.plsql.'|| G_PKG_NAME ||'.rs_inactivate_ship_to',
5734: 'Parameters are: '
5735: || 'p_api_version=' || p_api_version
5736: || ',p_Init_Msg_List=' || p_Init_Msg_List

Line 5764: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5760: l_inv_loc_id,
5761: l_primary_flag;
5762: close rs_get_ship_to_addr;
5763:
5764: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5765: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5766: 'csp.plsql.'|| G_PKG_NAME ||'.rs_primary_ship_to_addr',
5767: 'p_rs_site_use_id=' || p_rs_site_use_id
5768: || ',l_customer_id=' || l_customer_id

Line 5765: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5761: l_primary_flag;
5762: close rs_get_ship_to_addr;
5763:
5764: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5765: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5766: 'csp.plsql.'|| G_PKG_NAME ||'.rs_primary_ship_to_addr',
5767: 'p_rs_site_use_id=' || p_rs_site_use_id
5768: || ',l_customer_id=' || l_customer_id
5769: || ',l_inv_loc_id=' || l_inv_loc_id

Line 5785: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5781: X_MSG_COUNT => x_msg_count,
5782: X_MSG_DATA => x_msg_data
5783: );
5784:
5785: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5786: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5787: 'csp.plsql.'|| G_PKG_NAME ||'.rs_primary_ship_to_addr',
5788: 'x_return_status=' || x_return_status
5789: || ',x_msg_count=' || x_msg_count

Line 5786: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5782: X_MSG_DATA => x_msg_data
5783: );
5784:
5785: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5786: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5787: 'csp.plsql.'|| G_PKG_NAME ||'.rs_primary_ship_to_addr',
5788: 'x_return_status=' || x_return_status
5789: || ',x_msg_count=' || x_msg_count
5790: || ',x_msg_data=' || x_msg_data);

Line 5859: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5855: and news.org_id = p_dest_org_id;
5856:
5857: BEGIN
5858:
5859: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5860: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5861: l_module_name,
5862: 'Begin... p_src_org_id=' || p_src_org_id
5863: || ', p_dest_org_id=' || p_dest_org_id

Line 5860: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5856:
5857: BEGIN
5858:
5859: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5860: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5861: l_module_name,
5862: 'Begin... p_src_org_id=' || p_src_org_id
5863: || ', p_dest_org_id=' || p_dest_org_id
5864: || ', p_cust_site_id=' || p_cust_site_id

Line 5872: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5868:
5869: x_return_status := FND_API.G_RET_STS_SUCCESS;
5870: l_current_org_id := mo_global.get_current_org_id;
5871:
5872: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5873: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5874: l_module_name,
5875: 'l_current_org_id = ' || l_current_org_id);
5876: end if;

Line 5873: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5869: x_return_status := FND_API.G_RET_STS_SUCCESS;
5870: l_current_org_id := mo_global.get_current_org_id;
5871:
5872: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5873: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5874: l_module_name,
5875: 'l_current_org_id = ' || l_current_org_id);
5876: end if;
5877:

Line 5901: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5897: x_return_status := FND_API.G_RET_STS_ERROR;
5898: RAISE FND_API.G_EXC_ERROR;
5899: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5900:
5901: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5903: l_module_name,
5904: 'populated v_cust_acct_site_rec');
5905: end if;

Line 5902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5898: RAISE FND_API.G_EXC_ERROR;
5899: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5900:
5901: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5903: l_module_name,
5904: 'populated v_cust_acct_site_rec');
5905: end if;
5906:

Line 5936: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5932: x_return_status := FND_API.G_RET_STS_ERROR;
5933: RAISE FND_API.G_EXC_ERROR;
5934: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5935:
5936: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5937: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5938: l_module_name,
5939: 'x_cust_acct_site_id=' || x_cust_acct_site_id);
5940: end if;

Line 5937: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5933: RAISE FND_API.G_EXC_ERROR;
5934: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5935:
5936: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5937: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5938: l_module_name,
5939: 'x_cust_acct_site_id=' || x_cust_acct_site_id);
5940: end if;
5941:

Line 5971: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5967: x_return_status := FND_API.G_RET_STS_ERROR;
5968: RAISE FND_API.G_EXC_ERROR;
5969: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5970:
5971: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5972: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5973: l_module_name,
5974: 'populated v_cust_site_use_rec');
5975: end if;

Line 5972: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5968: RAISE FND_API.G_EXC_ERROR;
5969: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5970:
5971: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5972: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5973: l_module_name,
5974: 'populated v_cust_site_use_rec');
5975: end if;
5976:

Line 5991: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5987: open get_bill_site_id;
5988: fetch get_bill_site_id into v_bill_site_id;
5989: close get_bill_site_id;
5990:
5991: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5992: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5993: l_module_name,
5994: 'v_bill_site_id = ' || v_bill_site_id);
5995: end if;

Line 5992: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5988: fetch get_bill_site_id into v_bill_site_id;
5989: close get_bill_site_id;
5990:
5991: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5992: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5993: l_module_name,
5994: 'v_bill_site_id = ' || v_bill_site_id);
5995: end if;
5996:

Line 6028: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

6024: x_return_status := FND_API.G_RET_STS_ERROR;
6025: RAISE FND_API.G_EXC_ERROR;
6026: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6027:
6028: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6029: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6030: l_module_name,
6031: 'populated v_bill_acct_site_rec');
6032: end if;

Line 6029: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

6025: RAISE FND_API.G_EXC_ERROR;
6026: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6027:
6028: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6029: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6030: l_module_name,
6031: 'populated v_bill_acct_site_rec');
6032: end if;
6033:

Line 6063: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

6059: x_return_status := FND_API.G_RET_STS_ERROR;
6060: RAISE FND_API.G_EXC_ERROR;
6061: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6062:
6063: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6064: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6065: l_module_name,
6066: 'x_bill_acct_site_id=' || x_bill_acct_site_id);
6067: end if;

Line 6064: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

6060: RAISE FND_API.G_EXC_ERROR;
6061: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6062:
6063: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6064: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6065: l_module_name,
6066: 'x_bill_acct_site_id=' || x_bill_acct_site_id);
6067: end if;
6068:

Line 6094: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

6090: x_return_status := FND_API.G_RET_STS_ERROR;
6091: RAISE FND_API.G_EXC_ERROR;
6092: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6093:
6094: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6095: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6096: l_module_name,
6097: 'populated v_bill_site_use_rec');
6098: end if;

Line 6095: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

6091: RAISE FND_API.G_EXC_ERROR;
6092: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6093:
6094: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6095: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6096: l_module_name,
6097: 'populated v_bill_site_use_rec');
6098: end if;
6099:

Line 6132: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

6128: po_moac_utils_pvt.set_org_context(l_current_org_id);
6129: RAISE FND_API.G_EXC_ERROR;
6130: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6131:
6132: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6133: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6134: l_module_name,
6135: 'x_site_use_id=' || x_site_use_id);
6136: end if;

Line 6133: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

6129: RAISE FND_API.G_EXC_ERROR;
6130: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6131:
6132: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6133: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6134: l_module_name,
6135: 'x_site_use_id=' || x_site_use_id);
6136: end if;
6137:

Line 6149: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

6145: end if;
6146: end if;
6147: end if;
6148:
6149: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6150: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6151: l_module_name,
6152: 'v_cust_site_use_rec.site_use_code=' || v_cust_site_use_rec.site_use_code
6153: || ', v_cust_site_use_rec.bill_to_site_use_id=' || v_cust_site_use_rec.bill_to_site_use_id);

Line 6150: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

6146: end if;
6147: end if;
6148:
6149: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6150: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6151: l_module_name,
6152: 'v_cust_site_use_rec.site_use_code=' || v_cust_site_use_rec.site_use_code
6153: || ', v_cust_site_use_rec.bill_to_site_use_id=' || v_cust_site_use_rec.bill_to_site_use_id);
6154: end if;

Line 6182: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

6178: po_moac_utils_pvt.set_org_context(l_current_org_id);
6179: RAISE FND_API.G_EXC_ERROR;
6180: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6181:
6182: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6184: l_module_name,
6185: 'x_site_use_id=' || x_site_use_id);
6186: end if;

Line 6183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

6179: RAISE FND_API.G_EXC_ERROR;
6180: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6181:
6182: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6184: l_module_name,
6185: 'x_site_use_id=' || x_site_use_id);
6186: end if;
6187:

Line 6195: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

6191:
6192: END LOOP;
6193: close get_cust_acct_site_uses;
6194:
6195: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6196: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6197: l_module_name,
6198: 'x_cust_acct_site_id=' || x_cust_acct_site_id
6199: || ', temp_ship_to_use_id=' || temp_ship_to_use_id);

Line 6196: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

6192: END LOOP;
6193: close get_cust_acct_site_uses;
6194:
6195: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6196: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6197: l_module_name,
6198: 'x_cust_acct_site_id=' || x_cust_acct_site_id
6199: || ', temp_ship_to_use_id=' || temp_ship_to_use_id);
6200: end if;

Line 6215: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

6211: x_msg_count => x_msg_count,
6212: x_msg_data => x_msg_data);
6213: po_moac_utils_pvt.set_org_context(l_current_org_id);
6214:
6215: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6216: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6217: l_module_name,
6218: 'arp_clas_pkg.insert_po_loc_associations... x_return_status=' || x_return_status);
6219: end if;

Line 6216: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

6212: x_msg_data => x_msg_data);
6213: po_moac_utils_pvt.set_org_context(l_current_org_id);
6214:
6215: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6216: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6217: l_module_name,
6218: 'arp_clas_pkg.insert_po_loc_associations... x_return_status=' || x_return_status);
6219: end if;
6220:

Line 6233: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

6229: x_return_status := FND_API.G_RET_STS_ERROR;
6230: RAISE FND_API.G_EXC_ERROR;
6231: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6232:
6233: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6234: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6235: l_module_name,
6236: 'Done!!!');
6237: end if;

Line 6234: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

6230: RAISE FND_API.G_EXC_ERROR;
6231: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6232:
6233: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6234: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6235: l_module_name,
6236: 'Done!!!');
6237: end if;
6238: END;

Line 6352: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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,
6354: l_module_name,
6355: 'Begin... p_resource_type=' || p_resource_type
6356: || ', p_resource_id=' || p_resource_id

Line 6353: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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,
6354: l_module_name,
6355: 'Begin... p_resource_type=' || p_resource_type
6356: || ', p_resource_id=' || p_resource_id
6357: || ', v_location_id=' || v_location_id

Line 6475: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

6471: x_msg_count => x_msg_count,
6472: x_msg_data => x_msg_data
6473: );
6474:
6475: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6477: l_module_name,
6478: 'x_return_status=' || x_return_status);
6479: end if;

Line 6476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

6472: x_msg_data => x_msg_data
6473: );
6474:
6475: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6477: l_module_name,
6478: 'x_return_status=' || x_return_status);
6479: end if;
6480:

Line 6483: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

6479: end if;
6480:
6481: end if;
6482:
6483: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6484: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6485: l_module_name,
6486: 'Done!!!');
6487: end if;

Line 6484: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

6480:
6481: end if;
6482:
6483: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6484: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6485: l_module_name,
6486: 'Done!!!');
6487: end if;
6488: