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.

[Home] [Help]

APPS.CSF_RESOURCE_ADDRESS_PVT dependencies on FND_LOG

Line 132: g_debug_level := NVL(fnd_profile.value('AFLOG_LEVEL'), fnd_log.level_event);

128:
129: PROCEDURE init_package IS
130: BEGIN
131: g_debug := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
132: g_debug_level := NVL(fnd_profile.value('AFLOG_LEVEL'), fnd_log.level_event);
133: END init_package;
134:
135: PROCEDURE debug(p_message VARCHAR2, p_module VARCHAR2, p_level NUMBER) IS
136: BEGIN

Line 145: fnd_log.string(p_level, 'csf.plsql.CSF_RESOURCE_ADDRESS_PVT.' || p_module, p_message);

141: ELSE
142: fnd_file.put_line(fnd_file.log, rpad(p_module, 20) || ': ' || p_message);
143: END IF;
144: ELSE
145: fnd_log.string(p_level, 'csf.plsql.CSF_RESOURCE_ADDRESS_PVT.' || p_module, p_message);
146: END IF;
147: END IF;
148: --dbms_output.put_line(rpad(p_module, 20) || ': ' || p_message);
149: END debug;

Line 343: debug('Resolving Address at this time: ' || to_char(sysdate, 'YYYYMMDD HH24:MI:SS '), l_api_name, fnd_log.level_procedure);

339: FETCH c_location_locking_info INTO l_location_ovn, l_geometry, l_geom_status_code ;
340: CLOSE c_location_locking_info;
341:
342: IF l_debug THEN
343: debug('Resolving Address at this time: ' || to_char(sysdate, 'YYYYMMDD HH24:MI:SS '), l_api_name, fnd_log.level_procedure);
344: debug('Resolving the Address corresponding to Location #' || p_location_id, l_api_name, fnd_log.level_procedure);
345: debug(' --> Address1 = ' || p_address1, l_api_name, fnd_log.level_statement);
346: debug(' --> City = ' || p_city, l_api_name, fnd_log.level_statement);
347: debug(' --> State = ' || p_state, l_api_name, fnd_log.level_statement);

Line 344: debug('Resolving the Address corresponding to Location #' || p_location_id, l_api_name, fnd_log.level_procedure);

340: CLOSE c_location_locking_info;
341:
342: IF l_debug THEN
343: debug('Resolving Address at this time: ' || to_char(sysdate, 'YYYYMMDD HH24:MI:SS '), l_api_name, fnd_log.level_procedure);
344: debug('Resolving the Address corresponding to Location #' || p_location_id, l_api_name, fnd_log.level_procedure);
345: debug(' --> Address1 = ' || p_address1, l_api_name, fnd_log.level_statement);
346: debug(' --> City = ' || p_city, l_api_name, fnd_log.level_statement);
347: debug(' --> State = ' || p_state, l_api_name, fnd_log.level_statement);
348: debug(' --> Zip = ' || p_postalcode, l_api_name, fnd_log.level_statement);

Line 345: debug(' --> Address1 = ' || p_address1, l_api_name, fnd_log.level_statement);

341:
342: IF l_debug THEN
343: debug('Resolving Address at this time: ' || to_char(sysdate, 'YYYYMMDD HH24:MI:SS '), l_api_name, fnd_log.level_procedure);
344: debug('Resolving the Address corresponding to Location #' || p_location_id, l_api_name, fnd_log.level_procedure);
345: debug(' --> Address1 = ' || p_address1, l_api_name, fnd_log.level_statement);
346: debug(' --> City = ' || p_city, l_api_name, fnd_log.level_statement);
347: debug(' --> State = ' || p_state, l_api_name, fnd_log.level_statement);
348: debug(' --> Zip = ' || p_postalcode, l_api_name, fnd_log.level_statement);
349: debug(' --> Country = ' || p_country, l_api_name, fnd_log.level_statement);

Line 346: debug(' --> City = ' || p_city, l_api_name, fnd_log.level_statement);

342: IF l_debug THEN
343: debug('Resolving Address at this time: ' || to_char(sysdate, 'YYYYMMDD HH24:MI:SS '), l_api_name, fnd_log.level_procedure);
344: debug('Resolving the Address corresponding to Location #' || p_location_id, l_api_name, fnd_log.level_procedure);
345: debug(' --> Address1 = ' || p_address1, l_api_name, fnd_log.level_statement);
346: debug(' --> City = ' || p_city, l_api_name, fnd_log.level_statement);
347: debug(' --> State = ' || p_state, l_api_name, fnd_log.level_statement);
348: debug(' --> Zip = ' || p_postalcode, l_api_name, fnd_log.level_statement);
349: debug(' --> Country = ' || p_country, l_api_name, fnd_log.level_statement);
350: debug(' --> Country Code = ' || p_country_code, l_api_name, fnd_log.level_statement);

Line 347: debug(' --> State = ' || p_state, l_api_name, fnd_log.level_statement);

343: debug('Resolving Address at this time: ' || to_char(sysdate, 'YYYYMMDD HH24:MI:SS '), l_api_name, fnd_log.level_procedure);
344: debug('Resolving the Address corresponding to Location #' || p_location_id, l_api_name, fnd_log.level_procedure);
345: debug(' --> Address1 = ' || p_address1, l_api_name, fnd_log.level_statement);
346: debug(' --> City = ' || p_city, l_api_name, fnd_log.level_statement);
347: debug(' --> State = ' || p_state, l_api_name, fnd_log.level_statement);
348: debug(' --> Zip = ' || p_postalcode, l_api_name, fnd_log.level_statement);
349: debug(' --> Country = ' || p_country, l_api_name, fnd_log.level_statement);
350: debug(' --> Country Code = ' || p_country_code, l_api_name, fnd_log.level_statement);
351: debug(' --> Update Addr = ' || p_update_address, l_api_name, fnd_log.level_statement);

Line 348: debug(' --> Zip = ' || p_postalcode, l_api_name, fnd_log.level_statement);

344: debug('Resolving the Address corresponding to Location #' || p_location_id, l_api_name, fnd_log.level_procedure);
345: debug(' --> Address1 = ' || p_address1, l_api_name, fnd_log.level_statement);
346: debug(' --> City = ' || p_city, l_api_name, fnd_log.level_statement);
347: debug(' --> State = ' || p_state, l_api_name, fnd_log.level_statement);
348: debug(' --> Zip = ' || p_postalcode, l_api_name, fnd_log.level_statement);
349: debug(' --> Country = ' || p_country, l_api_name, fnd_log.level_statement);
350: debug(' --> Country Code = ' || p_country_code, l_api_name, fnd_log.level_statement);
351: debug(' --> Update Addr = ' || p_update_address, l_api_name, fnd_log.level_statement);
352: debug(' --> Existing SegId = ' || csf_locus_pub.get_locus_segmentid(l_geometry), l_api_name, fnd_log.level_statement);

Line 349: debug(' --> Country = ' || p_country, l_api_name, fnd_log.level_statement);

345: debug(' --> Address1 = ' || p_address1, l_api_name, fnd_log.level_statement);
346: debug(' --> City = ' || p_city, l_api_name, fnd_log.level_statement);
347: debug(' --> State = ' || p_state, l_api_name, fnd_log.level_statement);
348: debug(' --> Zip = ' || p_postalcode, l_api_name, fnd_log.level_statement);
349: debug(' --> Country = ' || p_country, l_api_name, fnd_log.level_statement);
350: debug(' --> Country Code = ' || p_country_code, l_api_name, fnd_log.level_statement);
351: debug(' --> Update Addr = ' || p_update_address, l_api_name, fnd_log.level_statement);
352: debug(' --> Existing SegId = ' || csf_locus_pub.get_locus_segmentid(l_geometry), l_api_name, fnd_log.level_statement);
353: debug(' --> Existing Lon = ' || csf_locus_pub.get_locus_lon(l_geometry), l_api_name, fnd_log.level_statement);

Line 350: debug(' --> Country Code = ' || p_country_code, l_api_name, fnd_log.level_statement);

346: debug(' --> City = ' || p_city, l_api_name, fnd_log.level_statement);
347: debug(' --> State = ' || p_state, l_api_name, fnd_log.level_statement);
348: debug(' --> Zip = ' || p_postalcode, l_api_name, fnd_log.level_statement);
349: debug(' --> Country = ' || p_country, l_api_name, fnd_log.level_statement);
350: debug(' --> Country Code = ' || p_country_code, l_api_name, fnd_log.level_statement);
351: debug(' --> Update Addr = ' || p_update_address, l_api_name, fnd_log.level_statement);
352: debug(' --> Existing SegId = ' || csf_locus_pub.get_locus_segmentid(l_geometry), l_api_name, fnd_log.level_statement);
353: debug(' --> Existing Lon = ' || csf_locus_pub.get_locus_lon(l_geometry), l_api_name, fnd_log.level_statement);
354: debug(' --> Existing Lat = ' || csf_locus_pub.get_locus_lat(l_geometry), l_api_name, fnd_log.level_statement);

Line 351: debug(' --> Update Addr = ' || p_update_address, l_api_name, fnd_log.level_statement);

347: debug(' --> State = ' || p_state, l_api_name, fnd_log.level_statement);
348: debug(' --> Zip = ' || p_postalcode, l_api_name, fnd_log.level_statement);
349: debug(' --> Country = ' || p_country, l_api_name, fnd_log.level_statement);
350: debug(' --> Country Code = ' || p_country_code, l_api_name, fnd_log.level_statement);
351: debug(' --> Update Addr = ' || p_update_address, l_api_name, fnd_log.level_statement);
352: debug(' --> Existing SegId = ' || csf_locus_pub.get_locus_segmentid(l_geometry), l_api_name, fnd_log.level_statement);
353: debug(' --> Existing Lon = ' || csf_locus_pub.get_locus_lon(l_geometry), l_api_name, fnd_log.level_statement);
354: debug(' --> Existing Lat = ' || csf_locus_pub.get_locus_lat(l_geometry), l_api_name, fnd_log.level_statement);
355: IF csf_locus_pub.is_manual_geometry(l_geometry)

Line 352: debug(' --> Existing SegId = ' || csf_locus_pub.get_locus_segmentid(l_geometry), l_api_name, fnd_log.level_statement);

348: debug(' --> Zip = ' || p_postalcode, l_api_name, fnd_log.level_statement);
349: debug(' --> Country = ' || p_country, l_api_name, fnd_log.level_statement);
350: debug(' --> Country Code = ' || p_country_code, l_api_name, fnd_log.level_statement);
351: debug(' --> Update Addr = ' || p_update_address, l_api_name, fnd_log.level_statement);
352: debug(' --> Existing SegId = ' || csf_locus_pub.get_locus_segmentid(l_geometry), l_api_name, fnd_log.level_statement);
353: debug(' --> Existing Lon = ' || csf_locus_pub.get_locus_lon(l_geometry), l_api_name, fnd_log.level_statement);
354: debug(' --> Existing Lat = ' || csf_locus_pub.get_locus_lat(l_geometry), l_api_name, fnd_log.level_statement);
355: IF csf_locus_pub.is_manual_geometry(l_geometry)
356: THEN

Line 353: debug(' --> Existing Lon = ' || csf_locus_pub.get_locus_lon(l_geometry), l_api_name, fnd_log.level_statement);

349: debug(' --> Country = ' || p_country, l_api_name, fnd_log.level_statement);
350: debug(' --> Country Code = ' || p_country_code, l_api_name, fnd_log.level_statement);
351: debug(' --> Update Addr = ' || p_update_address, l_api_name, fnd_log.level_statement);
352: debug(' --> Existing SegId = ' || csf_locus_pub.get_locus_segmentid(l_geometry), l_api_name, fnd_log.level_statement);
353: debug(' --> Existing Lon = ' || csf_locus_pub.get_locus_lon(l_geometry), l_api_name, fnd_log.level_statement);
354: debug(' --> Existing Lat = ' || csf_locus_pub.get_locus_lat(l_geometry), l_api_name, fnd_log.level_statement);
355: IF csf_locus_pub.is_manual_geometry(l_geometry)
356: THEN
357: debug(' --> Its a Manual Geometry', l_api_name, fnd_log.level_statement);

Line 354: debug(' --> Existing Lat = ' || csf_locus_pub.get_locus_lat(l_geometry), l_api_name, fnd_log.level_statement);

350: debug(' --> Country Code = ' || p_country_code, l_api_name, fnd_log.level_statement);
351: debug(' --> Update Addr = ' || p_update_address, l_api_name, fnd_log.level_statement);
352: debug(' --> Existing SegId = ' || csf_locus_pub.get_locus_segmentid(l_geometry), l_api_name, fnd_log.level_statement);
353: debug(' --> Existing Lon = ' || csf_locus_pub.get_locus_lon(l_geometry), l_api_name, fnd_log.level_statement);
354: debug(' --> Existing Lat = ' || csf_locus_pub.get_locus_lat(l_geometry), l_api_name, fnd_log.level_statement);
355: IF csf_locus_pub.is_manual_geometry(l_geometry)
356: THEN
357: debug(' --> Its a Manual Geometry', l_api_name, fnd_log.level_statement);
358: ELSE

Line 357: debug(' --> Its a Manual Geometry', l_api_name, fnd_log.level_statement);

353: debug(' --> Existing Lon = ' || csf_locus_pub.get_locus_lon(l_geometry), l_api_name, fnd_log.level_statement);
354: debug(' --> Existing Lat = ' || csf_locus_pub.get_locus_lat(l_geometry), l_api_name, fnd_log.level_statement);
355: IF csf_locus_pub.is_manual_geometry(l_geometry)
356: THEN
357: debug(' --> Its a Manual Geometry', l_api_name, fnd_log.level_statement);
358: ELSE
359: debug(' --> Its a NAVTEQ Geometry', l_api_name, fnd_log.level_statement);
360: END IF;
361: END IF;

Line 359: debug(' --> Its a NAVTEQ Geometry', l_api_name, fnd_log.level_statement);

355: IF csf_locus_pub.is_manual_geometry(l_geometry)
356: THEN
357: debug(' --> Its a Manual Geometry', l_api_name, fnd_log.level_statement);
358: ELSE
359: debug(' --> Its a NAVTEQ Geometry', l_api_name, fnd_log.level_statement);
360: END IF;
361: END IF;
362:
363: --Update the address details only when address is valid

Line 368: debug('CSF: Location Finder Installed = ' || fnd_profile.VALUE('CSF_LF_INSTALLED'), l_api_name, fnd_log.level_statement);

364: l_update_addr := NVL(fnd_api.to_boolean(p_update_address), FALSE);
365:
366: -- Location Finder Profiles. Check whether Resolve Address needs to be called.
367: IF l_debug THEN
368: debug('CSF: Location Finder Installed = ' || fnd_profile.VALUE('CSF_LF_INSTALLED'), l_api_name, fnd_log.level_statement);
369: debug('CSR: Create Location = ' || fnd_profile.VALUE('CREATELOCATION'), l_api_name, fnd_log.level_statement);
370: END IF;
371:
372: l_call_lf := (NVL(fnd_profile.VALUE('CSF_LF_INSTALLED'),'N') = 'Y');

Line 369: debug('CSR: Create Location = ' || fnd_profile.VALUE('CREATELOCATION'), l_api_name, fnd_log.level_statement);

365:
366: -- Location Finder Profiles. Check whether Resolve Address needs to be called.
367: IF l_debug THEN
368: debug('CSF: Location Finder Installed = ' || fnd_profile.VALUE('CSF_LF_INSTALLED'), l_api_name, fnd_log.level_statement);
369: debug('CSR: Create Location = ' || fnd_profile.VALUE('CREATELOCATION'), l_api_name, fnd_log.level_statement);
370: END IF;
371:
372: l_call_lf := (NVL(fnd_profile.VALUE('CSF_LF_INSTALLED'),'N') = 'Y');
373: -- AND (NVL(fnd_profile.VALUE('CREATELOCATION'),'N') = 'Y'); -- Create Location profile is no more used.

Line 396: debug('Before call to csf_lf_pub.csf_lf_resolveaddress ', l_api_name, fnd_log.level_statement);

392: WHEN 'ADDR4' THEN p_address4
393: END;
394:
395: IF l_debug THEN
396: debug('Before call to csf_lf_pub.csf_lf_resolveaddress ', l_api_name, fnd_log.level_statement);
397: END IF;
398:
399: csf_lf_pub.csf_lf_resolveaddress(
400: p_api_version => l_api_version

Line 417: debug('After call to csf_lf_pub.csf_lf_resolveaddress ', l_api_name, fnd_log.level_statement);

413: , x_resultsarray => l_resultarray
414: );
415:
416: IF l_debug THEN
417: debug('After call to csf_lf_pub.csf_lf_resolveaddress ', l_api_name, fnd_log.level_statement);
418: END IF;
419:
420: IF l_resultarray IS NOT NULL THEN
421: x_geometry := l_resultarray(1).locus;

Line 431: debug('Inside l_resultarray IS NOT NULL ', l_api_name, fnd_log.level_statement);

427: ELSE
428: l_road := l_resultarray(1).buildingnum || ' ' || initcap(l_resultarray(1).road);
429: END IF;
430: IF l_debug THEN
431: debug('Inside l_resultarray IS NOT NULL ', l_api_name, fnd_log.level_statement);
432: debug('l_road = ' || l_road, l_api_name, fnd_log.level_statement);
433: END IF;
434: END IF;
435:

Line 432: debug('l_road = ' || l_road, l_api_name, fnd_log.level_statement);

428: l_road := l_resultarray(1).buildingnum || ' ' || initcap(l_resultarray(1).road);
429: END IF;
430: IF l_debug THEN
431: debug('Inside l_resultarray IS NOT NULL ', l_api_name, fnd_log.level_statement);
432: debug('l_road = ' || l_road, l_api_name, fnd_log.level_statement);
433: END IF;
434: END IF;
435:
436: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 438: debug('Error: ' || x_msg_data, l_api_name, fnd_log.level_error);

434: END IF;
435:
436: IF x_return_status <> fnd_api.g_ret_sts_success THEN
437: x_msg_data := l_msg_data;
438: debug('Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
439: fnd_message.set_name ('CSF', 'CSF_LF_RAISED_ERROR');
440: fnd_message.set_token ('LOCATION_ID',p_location_id);
441: END IF;
442:

Line 445: debug(' --> Longitude = ' || x_geometry.sdo_ordinates(1), l_api_name, fnd_log.level_statement);

441: END IF;
442:
443:
444: IF l_debug and x_geometry is not null THEN
445: debug(' --> Longitude = ' || x_geometry.sdo_ordinates(1), l_api_name, fnd_log.level_statement);
446: debug(' --> Latitude = ' || x_geometry.sdo_ordinates(2), l_api_name, fnd_log.level_statement);
447: debug(' --> Segment = ' || x_geometry.sdo_ordinates(5), l_api_name, fnd_log.level_statement);
448: END IF;
449: ELSE

Line 446: debug(' --> Latitude = ' || x_geometry.sdo_ordinates(2), l_api_name, fnd_log.level_statement);

442:
443:
444: IF l_debug and x_geometry is not null THEN
445: debug(' --> Longitude = ' || x_geometry.sdo_ordinates(1), l_api_name, fnd_log.level_statement);
446: debug(' --> Latitude = ' || x_geometry.sdo_ordinates(2), l_api_name, fnd_log.level_statement);
447: debug(' --> Segment = ' || x_geometry.sdo_ordinates(5), l_api_name, fnd_log.level_statement);
448: END IF;
449: ELSE
450: l_roadname := p_address1;

Line 447: debug(' --> Segment = ' || x_geometry.sdo_ordinates(5), l_api_name, fnd_log.level_statement);

443:
444: IF l_debug and x_geometry is not null THEN
445: debug(' --> Longitude = ' || x_geometry.sdo_ordinates(1), l_api_name, fnd_log.level_statement);
446: debug(' --> Latitude = ' || x_geometry.sdo_ordinates(2), l_api_name, fnd_log.level_statement);
447: debug(' --> Segment = ' || x_geometry.sdo_ordinates(5), l_api_name, fnd_log.level_statement);
448: END IF;
449: ELSE
450: l_roadname := p_address1;
451: l_road := p_address1;

Line 453: debug('Considering the l_roadname and l_road as same as p_address1 = ' || l_roadname, l_api_name, fnd_log.level_procedure);

449: ELSE
450: l_roadname := p_address1;
451: l_road := p_address1;
452: IF l_debug THEN
453: debug('Considering the l_roadname and l_road as same as p_address1 = ' || l_roadname, l_api_name, fnd_log.level_procedure);
454: END IF;
455: END IF;
456:
457: IF l_update_addr THEN

Line 461: debug('Considering the address1 for resolving street. Modified address1 = ' || l_location_rec.address1, l_api_name, fnd_log.level_procedure);

457: IF l_update_addr THEN
458: IF p_address1 = l_roadname THEN
459: l_location_rec.address1 := l_road;
460: IF l_debug THEN
461: debug('Considering the address1 for resolving street. Modified address1 = ' || l_location_rec.address1, l_api_name, fnd_log.level_procedure);
462: END IF;
463: ELSIF p_address2 = l_roadname THEN
464: l_location_rec.address2 := l_road;
465: IF l_debug THEN

Line 466: debug('Considering the address2 for resolving street. Modified address2 = ' || l_location_rec.address2, l_api_name, fnd_log.level_procedure);

462: END IF;
463: ELSIF p_address2 = l_roadname THEN
464: l_location_rec.address2 := l_road;
465: IF l_debug THEN
466: debug('Considering the address2 for resolving street. Modified address2 = ' || l_location_rec.address2, l_api_name, fnd_log.level_procedure);
467: END IF;
468: ELSIF p_address3 = l_roadname THEN
469: l_location_rec.address3 := l_road;
470: IF l_debug THEN

Line 471: debug('Considering the address3 for resolving street. Modified address3 = ' || l_location_rec.address3, l_api_name, fnd_log.level_procedure);

467: END IF;
468: ELSIF p_address3 = l_roadname THEN
469: l_location_rec.address3 := l_road;
470: IF l_debug THEN
471: debug('Considering the address3 for resolving street. Modified address3 = ' || l_location_rec.address3, l_api_name, fnd_log.level_procedure);
472: END IF;
473: ELSIF p_address4 = l_roadname THEN
474: l_location_rec.address4 := l_road;
475: IF l_debug THEN

Line 476: debug('Considering the address4 for resolving street. Modified address4 = ' || l_location_rec.address4, l_api_name, fnd_log.level_procedure);

472: END IF;
473: ELSIF p_address4 = l_roadname THEN
474: l_location_rec.address4 := l_road;
475: IF l_debug THEN
476: debug('Considering the address4 for resolving street. Modified address4 = ' || l_location_rec.address4, l_api_name, fnd_log.level_procedure);
477: END IF;
478: END IF;
479: IF p_city = '_' THEN
480: l_location_rec.city := '';

Line 508: debug('Assigned Geometry Status = ' || l_location_rec.geometry_status_code, l_api_name, fnd_log.level_procedure);

504: l_update_geo := TRUE;
505: END IF;
506:
507: IF l_debug THEN
508: debug('Assigned Geometry Status = ' || l_location_rec.geometry_status_code, l_api_name, fnd_log.level_procedure);
509: END IF;
510:
511: IF l_debug THEN
512: debug('Existing geometry status code - ' || l_geom_status_code , l_api_name, fnd_log.level_procedure);

Line 512: debug('Existing geometry status code - ' || l_geom_status_code , l_api_name, fnd_log.level_procedure);

508: debug('Assigned Geometry Status = ' || l_location_rec.geometry_status_code, l_api_name, fnd_log.level_procedure);
509: END IF;
510:
511: IF l_debug THEN
512: debug('Existing geometry status code - ' || l_geom_status_code , l_api_name, fnd_log.level_procedure);
513: END IF;
514:
515:
516: IF l_update_geo THEN

Line 518: debug('LF is installed..Assigning resolved geometry for updation', l_api_name, fnd_log.level_procedure);

514:
515:
516: IF l_update_geo THEN
517: IF l_debug THEN
518: debug('LF is installed..Assigning resolved geometry for updation', l_api_name, fnd_log.level_procedure);
519: END IF;
520: l_location_rec.geometry := x_geometry;
521: ELSE
522: IF l_debug THEN

Line 523: debug('Geometry should not be updated..Need to retain existing geometry', l_api_name, fnd_log.level_procedure);

519: END IF;
520: l_location_rec.geometry := x_geometry;
521: ELSE
522: IF l_debug THEN
523: debug('Geometry should not be updated..Need to retain existing geometry', l_api_name, fnd_log.level_procedure);
524: END IF;
525: l_location_rec.geometry := l_geometry;
526: l_location_rec.geometry_status_code := l_geom_status_code;
527: END IF;

Line 532: debug('Updating Address ', l_api_name, fnd_log.level_statement);

528:
529:
530: IF l_update_addr OR l_update_geo THEN
531: IF l_debug THEN
532: debug('Updating Address ', l_api_name, fnd_log.level_statement);
533: END IF;
534:
535: l_location_rec.location_id := p_location_id;
536: l_location_rec.created_by_module := null;

Line 551: debug('Error: ' || x_msg_data, l_api_name, fnd_log.level_error);

547: END IF;
548:
549: if x_return_status <> fnd_api.g_ret_sts_success then
550: x_msg_data := l_msg_data;
551: debug('Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
552: fnd_message.set_name ('CSF', 'CSF_HZ_UPD_LOC_ERROR');
553: fnd_message.set_token ('LOCATION_ID', p_location_id);
554: END IF;
555:

Line 558: debug('CSF_LF_PUB.RESOLVE didnt return proper result.. So Error', l_api_name, fnd_log.level_error);

554: END IF;
555:
556: IF (l_resultarray IS NULL OR l_resultarray.COUNT > 1) THEN
557: IF l_debug THEN
558: debug('CSF_LF_PUB.RESOLVE didnt return proper result.. So Error', l_api_name, fnd_log.level_error);
559: END IF;
560: RAISE fnd_api.g_exc_error;
561: END IF;
562:

Line 568: debug('Resolving Address at this time: ' || to_char(sysdate, 'YYYYMMDD HH24:MI:SS '), l_api_name, fnd_log.level_procedure);

564: COMMIT;
565: END IF;
566:
567: IF l_debug THEN
568: debug('Resolving Address at this time: ' || to_char(sysdate, 'YYYYMMDD HH24:MI:SS '), l_api_name, fnd_log.level_procedure);
569: debug('Resolve address API completed with:' || x_return_status, l_api_name, fnd_log.level_procedure);
570: END IF;
571:
572: EXCEPTION

Line 569: debug('Resolve address API completed with:' || x_return_status, l_api_name, fnd_log.level_procedure);

565: END IF;
566:
567: IF l_debug THEN
568: debug('Resolving Address at this time: ' || to_char(sysdate, 'YYYYMMDD HH24:MI:SS '), l_api_name, fnd_log.level_procedure);
569: debug('Resolve address API completed with:' || x_return_status, l_api_name, fnd_log.level_procedure);
570: END IF;
571:
572: EXCEPTION
573: WHEN fnd_api.g_exc_error THEN

Line 575: debug('Expected Error: ' || fnd_message.get, l_api_name, fnd_log.level_error);

571:
572: EXCEPTION
573: WHEN fnd_api.g_exc_error THEN
574: if l_debug then
575: debug('Expected Error: ' || fnd_message.get, l_api_name, fnd_log.level_error);
576: END IF;
577: ROLLBACK TO resolve_address_pub;
578: x_return_status := fnd_api.g_ret_sts_error;
579: WHEN fnd_api.g_exc_unexpected_error THEN

Line 581: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);

577: ROLLBACK TO resolve_address_pub;
578: x_return_status := fnd_api.g_ret_sts_error;
579: WHEN fnd_api.g_exc_unexpected_error THEN
580: IF l_debug THEN
581: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
582: END IF;
583: ROLLBACK TO resolve_address_pub;
584: x_return_status := fnd_api.g_ret_sts_unexp_error;
585: WHEN OTHERS THEN

Line 587: debug('Exception: SQLCODE = ' || SQLCODE || ' : SQLERRM = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

583: ROLLBACK TO resolve_address_pub;
584: x_return_status := fnd_api.g_ret_sts_unexp_error;
585: WHEN OTHERS THEN
586: IF l_debug THEN
587: debug('Exception: SQLCODE = ' || SQLCODE || ' : SQLERRM = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
588: END IF;
589: x_return_status := fnd_api.g_ret_sts_unexp_error;
590: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
591: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 606: debug('Checking for the Equality of two addresses', l_api_name, fnd_log.level_procedure);

602: l_api_name CONSTANT VARCHAR2(50) := 'ARE_ADDRESSES_EQUAL';
603: l_debug CONSTANT BOOLEAN := g_debug = 'Y';
604: BEGIN
605: IF l_debug THEN
606: debug('Checking for the Equality of two addresses', l_api_name, fnd_log.level_procedure);
607: debug('Address#1', l_api_name, fnd_log.level_statement);
608: debug(' --> Street : ' || p_address1.street, l_api_name, fnd_log.level_statement);
609: debug(' --> City : ' || p_address1.city, l_api_name, fnd_log.level_statement);
610: debug(' --> State : ' || p_address1.state, l_api_name, fnd_log.level_statement);

Line 607: debug('Address#1', l_api_name, fnd_log.level_statement);

603: l_debug CONSTANT BOOLEAN := g_debug = 'Y';
604: BEGIN
605: IF l_debug THEN
606: debug('Checking for the Equality of two addresses', l_api_name, fnd_log.level_procedure);
607: debug('Address#1', l_api_name, fnd_log.level_statement);
608: debug(' --> Street : ' || p_address1.street, l_api_name, fnd_log.level_statement);
609: debug(' --> City : ' || p_address1.city, l_api_name, fnd_log.level_statement);
610: debug(' --> State : ' || p_address1.state, l_api_name, fnd_log.level_statement);
611: debug(' --> Zip : ' || p_address1.postal_code, l_api_name, fnd_log.level_statement);

Line 608: debug(' --> Street : ' || p_address1.street, l_api_name, fnd_log.level_statement);

604: BEGIN
605: IF l_debug THEN
606: debug('Checking for the Equality of two addresses', l_api_name, fnd_log.level_procedure);
607: debug('Address#1', l_api_name, fnd_log.level_statement);
608: debug(' --> Street : ' || p_address1.street, l_api_name, fnd_log.level_statement);
609: debug(' --> City : ' || p_address1.city, l_api_name, fnd_log.level_statement);
610: debug(' --> State : ' || p_address1.state, l_api_name, fnd_log.level_statement);
611: debug(' --> Zip : ' || p_address1.postal_code, l_api_name, fnd_log.level_statement);
612: debug(' --> Country : ' || p_address1.country, l_api_name, fnd_log.level_statement);

Line 609: debug(' --> City : ' || p_address1.city, l_api_name, fnd_log.level_statement);

605: IF l_debug THEN
606: debug('Checking for the Equality of two addresses', l_api_name, fnd_log.level_procedure);
607: debug('Address#1', l_api_name, fnd_log.level_statement);
608: debug(' --> Street : ' || p_address1.street, l_api_name, fnd_log.level_statement);
609: debug(' --> City : ' || p_address1.city, l_api_name, fnd_log.level_statement);
610: debug(' --> State : ' || p_address1.state, l_api_name, fnd_log.level_statement);
611: debug(' --> Zip : ' || p_address1.postal_code, l_api_name, fnd_log.level_statement);
612: debug(' --> Country : ' || p_address1.country, l_api_name, fnd_log.level_statement);
613: debug(' --> Terr SN : ' || p_address1.territory_short_name, l_api_name, fnd_log.level_statement);

Line 610: debug(' --> State : ' || p_address1.state, l_api_name, fnd_log.level_statement);

606: debug('Checking for the Equality of two addresses', l_api_name, fnd_log.level_procedure);
607: debug('Address#1', l_api_name, fnd_log.level_statement);
608: debug(' --> Street : ' || p_address1.street, l_api_name, fnd_log.level_statement);
609: debug(' --> City : ' || p_address1.city, l_api_name, fnd_log.level_statement);
610: debug(' --> State : ' || p_address1.state, l_api_name, fnd_log.level_statement);
611: debug(' --> Zip : ' || p_address1.postal_code, l_api_name, fnd_log.level_statement);
612: debug(' --> Country : ' || p_address1.country, l_api_name, fnd_log.level_statement);
613: debug(' --> Terr SN : ' || p_address1.territory_short_name, l_api_name, fnd_log.level_statement);
614: debug('Address#2', l_api_name, fnd_log.level_statement);

Line 611: debug(' --> Zip : ' || p_address1.postal_code, l_api_name, fnd_log.level_statement);

607: debug('Address#1', l_api_name, fnd_log.level_statement);
608: debug(' --> Street : ' || p_address1.street, l_api_name, fnd_log.level_statement);
609: debug(' --> City : ' || p_address1.city, l_api_name, fnd_log.level_statement);
610: debug(' --> State : ' || p_address1.state, l_api_name, fnd_log.level_statement);
611: debug(' --> Zip : ' || p_address1.postal_code, l_api_name, fnd_log.level_statement);
612: debug(' --> Country : ' || p_address1.country, l_api_name, fnd_log.level_statement);
613: debug(' --> Terr SN : ' || p_address1.territory_short_name, l_api_name, fnd_log.level_statement);
614: debug('Address#2', l_api_name, fnd_log.level_statement);
615: debug(' --> Street : ' || p_address2.street, l_api_name, fnd_log.level_statement);

Line 612: debug(' --> Country : ' || p_address1.country, l_api_name, fnd_log.level_statement);

608: debug(' --> Street : ' || p_address1.street, l_api_name, fnd_log.level_statement);
609: debug(' --> City : ' || p_address1.city, l_api_name, fnd_log.level_statement);
610: debug(' --> State : ' || p_address1.state, l_api_name, fnd_log.level_statement);
611: debug(' --> Zip : ' || p_address1.postal_code, l_api_name, fnd_log.level_statement);
612: debug(' --> Country : ' || p_address1.country, l_api_name, fnd_log.level_statement);
613: debug(' --> Terr SN : ' || p_address1.territory_short_name, l_api_name, fnd_log.level_statement);
614: debug('Address#2', l_api_name, fnd_log.level_statement);
615: debug(' --> Street : ' || p_address2.street, l_api_name, fnd_log.level_statement);
616: debug(' --> City : ' || p_address2.city, l_api_name, fnd_log.level_statement);

Line 613: debug(' --> Terr SN : ' || p_address1.territory_short_name, l_api_name, fnd_log.level_statement);

609: debug(' --> City : ' || p_address1.city, l_api_name, fnd_log.level_statement);
610: debug(' --> State : ' || p_address1.state, l_api_name, fnd_log.level_statement);
611: debug(' --> Zip : ' || p_address1.postal_code, l_api_name, fnd_log.level_statement);
612: debug(' --> Country : ' || p_address1.country, l_api_name, fnd_log.level_statement);
613: debug(' --> Terr SN : ' || p_address1.territory_short_name, l_api_name, fnd_log.level_statement);
614: debug('Address#2', l_api_name, fnd_log.level_statement);
615: debug(' --> Street : ' || p_address2.street, l_api_name, fnd_log.level_statement);
616: debug(' --> City : ' || p_address2.city, l_api_name, fnd_log.level_statement);
617: debug(' --> State : ' || p_address2.state, l_api_name, fnd_log.level_statement);

Line 614: debug('Address#2', l_api_name, fnd_log.level_statement);

610: debug(' --> State : ' || p_address1.state, l_api_name, fnd_log.level_statement);
611: debug(' --> Zip : ' || p_address1.postal_code, l_api_name, fnd_log.level_statement);
612: debug(' --> Country : ' || p_address1.country, l_api_name, fnd_log.level_statement);
613: debug(' --> Terr SN : ' || p_address1.territory_short_name, l_api_name, fnd_log.level_statement);
614: debug('Address#2', l_api_name, fnd_log.level_statement);
615: debug(' --> Street : ' || p_address2.street, l_api_name, fnd_log.level_statement);
616: debug(' --> City : ' || p_address2.city, l_api_name, fnd_log.level_statement);
617: debug(' --> State : ' || p_address2.state, l_api_name, fnd_log.level_statement);
618: debug(' --> Zip : ' || p_address2.postal_code, l_api_name, fnd_log.level_statement);

Line 615: debug(' --> Street : ' || p_address2.street, l_api_name, fnd_log.level_statement);

611: debug(' --> Zip : ' || p_address1.postal_code, l_api_name, fnd_log.level_statement);
612: debug(' --> Country : ' || p_address1.country, l_api_name, fnd_log.level_statement);
613: debug(' --> Terr SN : ' || p_address1.territory_short_name, l_api_name, fnd_log.level_statement);
614: debug('Address#2', l_api_name, fnd_log.level_statement);
615: debug(' --> Street : ' || p_address2.street, l_api_name, fnd_log.level_statement);
616: debug(' --> City : ' || p_address2.city, l_api_name, fnd_log.level_statement);
617: debug(' --> State : ' || p_address2.state, l_api_name, fnd_log.level_statement);
618: debug(' --> Zip : ' || p_address2.postal_code, l_api_name, fnd_log.level_statement);
619: debug(' --> Country : ' || p_address2.country, l_api_name, fnd_log.level_statement);

Line 616: debug(' --> City : ' || p_address2.city, l_api_name, fnd_log.level_statement);

612: debug(' --> Country : ' || p_address1.country, l_api_name, fnd_log.level_statement);
613: debug(' --> Terr SN : ' || p_address1.territory_short_name, l_api_name, fnd_log.level_statement);
614: debug('Address#2', l_api_name, fnd_log.level_statement);
615: debug(' --> Street : ' || p_address2.street, l_api_name, fnd_log.level_statement);
616: debug(' --> City : ' || p_address2.city, l_api_name, fnd_log.level_statement);
617: debug(' --> State : ' || p_address2.state, l_api_name, fnd_log.level_statement);
618: debug(' --> Zip : ' || p_address2.postal_code, l_api_name, fnd_log.level_statement);
619: debug(' --> Country : ' || p_address2.country, l_api_name, fnd_log.level_statement);
620: debug(' --> Terr SN : ' || p_address2.territory_short_name, l_api_name, fnd_log.level_statement);

Line 617: debug(' --> State : ' || p_address2.state, l_api_name, fnd_log.level_statement);

613: debug(' --> Terr SN : ' || p_address1.territory_short_name, l_api_name, fnd_log.level_statement);
614: debug('Address#2', l_api_name, fnd_log.level_statement);
615: debug(' --> Street : ' || p_address2.street, l_api_name, fnd_log.level_statement);
616: debug(' --> City : ' || p_address2.city, l_api_name, fnd_log.level_statement);
617: debug(' --> State : ' || p_address2.state, l_api_name, fnd_log.level_statement);
618: debug(' --> Zip : ' || p_address2.postal_code, l_api_name, fnd_log.level_statement);
619: debug(' --> Country : ' || p_address2.country, l_api_name, fnd_log.level_statement);
620: debug(' --> Terr SN : ' || p_address2.territory_short_name, l_api_name, fnd_log.level_statement);
621: END IF;

Line 618: debug(' --> Zip : ' || p_address2.postal_code, l_api_name, fnd_log.level_statement);

614: debug('Address#2', l_api_name, fnd_log.level_statement);
615: debug(' --> Street : ' || p_address2.street, l_api_name, fnd_log.level_statement);
616: debug(' --> City : ' || p_address2.city, l_api_name, fnd_log.level_statement);
617: debug(' --> State : ' || p_address2.state, l_api_name, fnd_log.level_statement);
618: debug(' --> Zip : ' || p_address2.postal_code, l_api_name, fnd_log.level_statement);
619: debug(' --> Country : ' || p_address2.country, l_api_name, fnd_log.level_statement);
620: debug(' --> Terr SN : ' || p_address2.territory_short_name, l_api_name, fnd_log.level_statement);
621: END IF;
622:

Line 619: debug(' --> Country : ' || p_address2.country, l_api_name, fnd_log.level_statement);

615: debug(' --> Street : ' || p_address2.street, l_api_name, fnd_log.level_statement);
616: debug(' --> City : ' || p_address2.city, l_api_name, fnd_log.level_statement);
617: debug(' --> State : ' || p_address2.state, l_api_name, fnd_log.level_statement);
618: debug(' --> Zip : ' || p_address2.postal_code, l_api_name, fnd_log.level_statement);
619: debug(' --> Country : ' || p_address2.country, l_api_name, fnd_log.level_statement);
620: debug(' --> Terr SN : ' || p_address2.territory_short_name, l_api_name, fnd_log.level_statement);
621: END IF;
622:
623: IF NVL(UPPER(p_address1.street), '@#$') <> NVL(UPPER(p_address2.street), '@#$') THEN

Line 620: debug(' --> Terr SN : ' || p_address2.territory_short_name, l_api_name, fnd_log.level_statement);

616: debug(' --> City : ' || p_address2.city, l_api_name, fnd_log.level_statement);
617: debug(' --> State : ' || p_address2.state, l_api_name, fnd_log.level_statement);
618: debug(' --> Zip : ' || p_address2.postal_code, l_api_name, fnd_log.level_statement);
619: debug(' --> Country : ' || p_address2.country, l_api_name, fnd_log.level_statement);
620: debug(' --> Terr SN : ' || p_address2.territory_short_name, l_api_name, fnd_log.level_statement);
621: END IF;
622:
623: IF NVL(UPPER(p_address1.street), '@#$') <> NVL(UPPER(p_address2.street), '@#$') THEN
624: RETURN FALSE;

Line 649: debug('Addresses are equal', l_api_name, fnd_log.level_statement);

645: RETURN FALSE;
646: END IF;
647:
648: IF l_debug THEN
649: debug('Addresses are equal', l_api_name, fnd_log.level_statement);
650: END IF;
651: RETURN TRUE;
652: END are_addresses_equal;
653:

Line 671: debug('Finding the Parties associated with Resource ID = ' || p_resource_id, l_api_name, fnd_log.level_procedure);

667: c_parties ref_cursor_type;
668: l_address_rec address_rec_type;
669: BEGIN
670: IF l_debug THEN
671: debug('Finding the Parties associated with Resource ID = ' || p_resource_id, l_api_name, fnd_log.level_procedure);
672: END IF;
673:
674: x_address_tbl := address_tbl_type();
675: IF g_res_add_prof is null

Line 701: debug(' Number of Parties found = ' || x_address_tbl.COUNT, l_api_name, fnd_log.level_statement);

697: END LOOP;
698: CLOSE c_parties;
699: END IF;
700: IF l_debug THEN
701: debug(' Number of Parties found = ' || x_address_tbl.COUNT, l_api_name, fnd_log.level_statement);
702: END IF;
703:
704: END IF;
705:

Line 723: debug(' Number of Parties found upon retrying = ' || x_address_tbl.COUNT, l_api_name, fnd_log.level_statement);

719: END LOOP;
720: CLOSE c_parties;
721:
722: IF l_debug THEN
723: debug(' Number of Parties found upon retrying = ' || x_address_tbl.COUNT, l_api_name, fnd_log.level_statement);
724: END IF;
725:
726: END get_party_addresses;
727:

Line 764: debug('Finding the addresses associated with Resource ID = ' || p_resource_id, l_api_name, fnd_log.level_procedure);

760:
761: l_home_address c_home_addresses%ROWTYPE;
762: BEGIN
763: IF l_debug THEN
764: debug('Finding the addresses associated with Resource ID = ' || p_resource_id, l_api_name, fnd_log.level_procedure);
765: END IF;
766:
767: OPEN c_home_addresses (p_resource_id, p_date);
768: FETCH c_home_addresses INTO l_home_address;

Line 784: debug(' Found a Address: Address ID = ' || x_address.address_id, l_api_name, fnd_log.level_statement);

780:
781:
782: IF l_debug THEN
783: IF x_address.address_id IS NOT NULL THEN
784: debug(' Found a Address: Address ID = ' || x_address.address_id, l_api_name, fnd_log.level_statement);
785: ELSE
786: debug(' Found no Home Address', l_api_name, fnd_log.level_statement);
787: END IF;
788: END IF;

Line 786: debug(' Found no Home Address', l_api_name, fnd_log.level_statement);

782: IF l_debug THEN
783: IF x_address.address_id IS NOT NULL THEN
784: debug(' Found a Address: Address ID = ' || x_address.address_id, l_api_name, fnd_log.level_statement);
785: ELSE
786: debug(' Found no Home Address', l_api_name, fnd_log.level_statement);
787: END IF;
788: END IF;
789: END get_home_addresses;
790:

Line 820: debug('Best Address ID (#' || p_home_addr_rec.address_id || ') doesnt match with any Party Site', l_api_name, fnd_log.level_statement);

816: END LOOP;
817:
818: IF l_debug THEN
819: IF x_matched_address_rec.party_site_id IS NULL THEN
820: debug('Best Address ID (#' || p_home_addr_rec.address_id || ') doesnt match with any Party Site', l_api_name, fnd_log.level_statement);
821: ELSE
822: debug('Best Address ID (#' || p_home_addr_rec.address_id || ') matches with Party Site ID = ' || x_matched_address_rec.party_site_id, l_api_name, fnd_log.level_statement);
823: END IF;
824: END IF;

Line 822: debug('Best Address ID (#' || p_home_addr_rec.address_id || ') matches with Party Site ID = ' || x_matched_address_rec.party_site_id, l_api_name, fnd_log.level_statement);

818: IF l_debug THEN
819: IF x_matched_address_rec.party_site_id IS NULL THEN
820: debug('Best Address ID (#' || p_home_addr_rec.address_id || ') doesnt match with any Party Site', l_api_name, fnd_log.level_statement);
821: ELSE
822: debug('Best Address ID (#' || p_home_addr_rec.address_id || ') matches with Party Site ID = ' || x_matched_address_rec.party_site_id, l_api_name, fnd_log.level_statement);
823: END IF;
824: END IF;
825: END match_home_to_party;
826:

Line 855: debug('Creating the Resource Party Link for Resource ID = ' || p_resource_id, l_api_name, fnd_log.level_procedure);

851: CURSOR c_terr IS
852: SELECT territory_code FROM fnd_territories WHERE ROWNUM = 1;
853: BEGIN
854: IF l_debug THEN
855: debug('Creating the Resource Party Link for Resource ID = ' || p_resource_id, l_api_name, fnd_log.level_procedure);
856: END IF;
857:
858: -- Check for API Compatibility
859: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 894: debug('Creating Location Record in HZ_LOCATIONS', l_api_name, fnd_log.level_statement);

890: -- l_location_rec.province := p_address.province;
891: END IF;
892:
893: IF l_debug THEN
894: debug('Creating Location Record in HZ_LOCATIONS', l_api_name, fnd_log.level_statement);
895: debug(' --> Address1 = ' || l_location_rec.address1, l_api_name, fnd_log.level_statement);
896: debug(' --> City = ' || l_location_rec.city, l_api_name, fnd_log.level_statement);
897: debug(' --> State = ' || l_location_rec.state, l_api_name, fnd_log.level_statement);
898: debug(' --> Zip = ' || l_location_rec.postal_code, l_api_name, fnd_log.level_statement);

Line 895: debug(' --> Address1 = ' || l_location_rec.address1, l_api_name, fnd_log.level_statement);

891: END IF;
892:
893: IF l_debug THEN
894: debug('Creating Location Record in HZ_LOCATIONS', l_api_name, fnd_log.level_statement);
895: debug(' --> Address1 = ' || l_location_rec.address1, l_api_name, fnd_log.level_statement);
896: debug(' --> City = ' || l_location_rec.city, l_api_name, fnd_log.level_statement);
897: debug(' --> State = ' || l_location_rec.state, l_api_name, fnd_log.level_statement);
898: debug(' --> Zip = ' || l_location_rec.postal_code, l_api_name, fnd_log.level_statement);
899: debug(' --> Country = ' || l_location_rec.country, l_api_name, fnd_log.level_statement);

Line 896: debug(' --> City = ' || l_location_rec.city, l_api_name, fnd_log.level_statement);

892:
893: IF l_debug THEN
894: debug('Creating Location Record in HZ_LOCATIONS', l_api_name, fnd_log.level_statement);
895: debug(' --> Address1 = ' || l_location_rec.address1, l_api_name, fnd_log.level_statement);
896: debug(' --> City = ' || l_location_rec.city, l_api_name, fnd_log.level_statement);
897: debug(' --> State = ' || l_location_rec.state, l_api_name, fnd_log.level_statement);
898: debug(' --> Zip = ' || l_location_rec.postal_code, l_api_name, fnd_log.level_statement);
899: debug(' --> Country = ' || l_location_rec.country, l_api_name, fnd_log.level_statement);
900: END IF;

Line 897: debug(' --> State = ' || l_location_rec.state, l_api_name, fnd_log.level_statement);

893: IF l_debug THEN
894: debug('Creating Location Record in HZ_LOCATIONS', l_api_name, fnd_log.level_statement);
895: debug(' --> Address1 = ' || l_location_rec.address1, l_api_name, fnd_log.level_statement);
896: debug(' --> City = ' || l_location_rec.city, l_api_name, fnd_log.level_statement);
897: debug(' --> State = ' || l_location_rec.state, l_api_name, fnd_log.level_statement);
898: debug(' --> Zip = ' || l_location_rec.postal_code, l_api_name, fnd_log.level_statement);
899: debug(' --> Country = ' || l_location_rec.country, l_api_name, fnd_log.level_statement);
900: END IF;
901:

Line 898: debug(' --> Zip = ' || l_location_rec.postal_code, l_api_name, fnd_log.level_statement);

894: debug('Creating Location Record in HZ_LOCATIONS', l_api_name, fnd_log.level_statement);
895: debug(' --> Address1 = ' || l_location_rec.address1, l_api_name, fnd_log.level_statement);
896: debug(' --> City = ' || l_location_rec.city, l_api_name, fnd_log.level_statement);
897: debug(' --> State = ' || l_location_rec.state, l_api_name, fnd_log.level_statement);
898: debug(' --> Zip = ' || l_location_rec.postal_code, l_api_name, fnd_log.level_statement);
899: debug(' --> Country = ' || l_location_rec.country, l_api_name, fnd_log.level_statement);
900: END IF;
901:
902: l_location_rec.created_by_module := 'CSFDEAR'; -- Calling Module 'CSF: Departure Arrival'

Line 899: debug(' --> Country = ' || l_location_rec.country, l_api_name, fnd_log.level_statement);

895: debug(' --> Address1 = ' || l_location_rec.address1, l_api_name, fnd_log.level_statement);
896: debug(' --> City = ' || l_location_rec.city, l_api_name, fnd_log.level_statement);
897: debug(' --> State = ' || l_location_rec.state, l_api_name, fnd_log.level_statement);
898: debug(' --> Zip = ' || l_location_rec.postal_code, l_api_name, fnd_log.level_statement);
899: debug(' --> Country = ' || l_location_rec.country, l_api_name, fnd_log.level_statement);
900: END IF;
901:
902: l_location_rec.created_by_module := 'CSFDEAR'; -- Calling Module 'CSF: Departure Arrival'
903:

Line 915: debug('HZ_LOCATION_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);

911: );
912: IF x_return_status <> fnd_api.g_ret_sts_success THEN
913: IF l_debug THEN
914: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
915: debug('HZ_LOCATION_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
916: END IF;
917: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
918: RAISE fnd_api.g_exc_unexpected_error;
919: END IF;

Line 923: debug('HZ_LOCATION_V2PUB.CREATE was successful. Location ID = ' || p_address.location_id, l_api_name, fnd_log.level_statement);

919: END IF;
920: RAISE fnd_api.g_exc_error;
921: ELSE
922: IF l_debug THEN
923: debug('HZ_LOCATION_V2PUB.CREATE was successful. Location ID = ' || p_address.location_id, l_api_name, fnd_log.level_statement);
924: END IF;
925: END IF;
926:
927: IF p_address.party_id IS NULL THEN

Line 941: debug('Creating Party Record in HZ_PARTIES', l_api_name, fnd_log.level_statement);

937: FROM dual;
938: END IF;
939:
940: IF l_debug THEN
941: debug('Creating Party Record in HZ_PARTIES', l_api_name, fnd_log.level_statement);
942: debug(' --> Party Number = ' || l_person_rec.party_rec.party_number, l_api_name, fnd_log.level_statement);
943: debug(' --> First Name = ' || l_person_rec.person_first_name, l_api_name, fnd_log.level_statement);
944: debug(' --> Last Name = ' || l_person_rec.person_last_name, l_api_name, fnd_log.level_statement);
945: END IF;

Line 942: debug(' --> Party Number = ' || l_person_rec.party_rec.party_number, l_api_name, fnd_log.level_statement);

938: END IF;
939:
940: IF l_debug THEN
941: debug('Creating Party Record in HZ_PARTIES', l_api_name, fnd_log.level_statement);
942: debug(' --> Party Number = ' || l_person_rec.party_rec.party_number, l_api_name, fnd_log.level_statement);
943: debug(' --> First Name = ' || l_person_rec.person_first_name, l_api_name, fnd_log.level_statement);
944: debug(' --> Last Name = ' || l_person_rec.person_last_name, l_api_name, fnd_log.level_statement);
945: END IF;
946:

Line 943: debug(' --> First Name = ' || l_person_rec.person_first_name, l_api_name, fnd_log.level_statement);

939:
940: IF l_debug THEN
941: debug('Creating Party Record in HZ_PARTIES', l_api_name, fnd_log.level_statement);
942: debug(' --> Party Number = ' || l_person_rec.party_rec.party_number, l_api_name, fnd_log.level_statement);
943: debug(' --> First Name = ' || l_person_rec.person_first_name, l_api_name, fnd_log.level_statement);
944: debug(' --> Last Name = ' || l_person_rec.person_last_name, l_api_name, fnd_log.level_statement);
945: END IF;
946:
947: hz_party_v2pub.create_person(

Line 944: debug(' --> Last Name = ' || l_person_rec.person_last_name, l_api_name, fnd_log.level_statement);

940: IF l_debug THEN
941: debug('Creating Party Record in HZ_PARTIES', l_api_name, fnd_log.level_statement);
942: debug(' --> Party Number = ' || l_person_rec.party_rec.party_number, l_api_name, fnd_log.level_statement);
943: debug(' --> First Name = ' || l_person_rec.person_first_name, l_api_name, fnd_log.level_statement);
944: debug(' --> Last Name = ' || l_person_rec.person_last_name, l_api_name, fnd_log.level_statement);
945: END IF;
946:
947: hz_party_v2pub.create_person(
948: p_init_msg_list => fnd_api.g_false

Line 961: debug('HZ_PARTY_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);

957:
958: IF x_return_status <> fnd_api.g_ret_sts_success THEN
959: IF l_debug THEN
960: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
961: debug('HZ_PARTY_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
962: END IF;
963: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
964: RAISE fnd_api.g_exc_unexpected_error;
965: END IF;

Line 969: debug('HZ_PARTY_V2PUB.CREATE_P was successful: Party ID = ' || p_address.party_id, l_api_name, fnd_log.level_statement);

965: END IF;
966: RAISE fnd_api.g_exc_error;
967: ELSE
968: IF l_debug THEN
969: debug('HZ_PARTY_V2PUB.CREATE_P was successful: Party ID = ' || p_address.party_id, l_api_name, fnd_log.level_statement);
970: END IF;
971: END IF;
972: ELSE
973: IF l_debug THEN

Line 974: debug('Party already exists. Using it. Party ID = ' || p_address.party_id, l_api_name, fnd_log.level_statement);

970: END IF;
971: END IF;
972: ELSE
973: IF l_debug THEN
974: debug('Party already exists. Using it. Party ID = ' || p_address.party_id, l_api_name, fnd_log.level_statement);
975: END IF;
976: END IF;
977:
978: l_party_site_rec.location_id := p_address.location_id;

Line 990: debug('Creating Party Site Record in HZ_PARTY_SITES', l_api_name, fnd_log.level_statement);

986: FROM dual;
987: END IF;
988:
989: IF l_debug THEN
990: debug('Creating Party Site Record in HZ_PARTY_SITES', l_api_name, fnd_log.level_statement);
991: debug(' --> Party Site Number = ' || l_party_site_rec.party_site_number, l_api_name, fnd_log.level_statement);
992: debug(' --> Party ID = ' || l_party_site_rec.party_id, l_api_name, fnd_log.level_statement);
993: debug(' --> Location ID = ' || l_party_site_rec.location_id, l_api_name, fnd_log.level_statement);
994: END IF;

Line 991: debug(' --> Party Site Number = ' || l_party_site_rec.party_site_number, l_api_name, fnd_log.level_statement);

987: END IF;
988:
989: IF l_debug THEN
990: debug('Creating Party Site Record in HZ_PARTY_SITES', l_api_name, fnd_log.level_statement);
991: debug(' --> Party Site Number = ' || l_party_site_rec.party_site_number, l_api_name, fnd_log.level_statement);
992: debug(' --> Party ID = ' || l_party_site_rec.party_id, l_api_name, fnd_log.level_statement);
993: debug(' --> Location ID = ' || l_party_site_rec.location_id, l_api_name, fnd_log.level_statement);
994: END IF;
995:

Line 992: debug(' --> Party ID = ' || l_party_site_rec.party_id, l_api_name, fnd_log.level_statement);

988:
989: IF l_debug THEN
990: debug('Creating Party Site Record in HZ_PARTY_SITES', l_api_name, fnd_log.level_statement);
991: debug(' --> Party Site Number = ' || l_party_site_rec.party_site_number, l_api_name, fnd_log.level_statement);
992: debug(' --> Party ID = ' || l_party_site_rec.party_id, l_api_name, fnd_log.level_statement);
993: debug(' --> Location ID = ' || l_party_site_rec.location_id, l_api_name, fnd_log.level_statement);
994: END IF;
995:
996: hz_party_site_v2pub.create_party_site(

Line 993: debug(' --> Location ID = ' || l_party_site_rec.location_id, l_api_name, fnd_log.level_statement);

989: IF l_debug THEN
990: debug('Creating Party Site Record in HZ_PARTY_SITES', l_api_name, fnd_log.level_statement);
991: debug(' --> Party Site Number = ' || l_party_site_rec.party_site_number, l_api_name, fnd_log.level_statement);
992: debug(' --> Party ID = ' || l_party_site_rec.party_id, l_api_name, fnd_log.level_statement);
993: debug(' --> Location ID = ' || l_party_site_rec.location_id, l_api_name, fnd_log.level_statement);
994: END IF;
995:
996: hz_party_site_v2pub.create_party_site(
997: p_init_msg_list => fnd_api.g_false

Line 1009: debug('HZ_PARTY_SITE_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);

1005:
1006: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1007: IF l_debug THEN
1008: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1009: debug('HZ_PARTY_SITE_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
1010: END IF;
1011: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1012: RAISE fnd_api.g_exc_unexpected_error;
1013: END IF;

Line 1017: debug('HZ_PARTY_SITE_V2PUB.CREATE_PS was successful. Party Site ID = ' || p_address.party_site_id, l_api_name, fnd_log.level_error);

1013: END IF;
1014: RAISE fnd_api.g_exc_error;
1015: ELSE
1016: IF l_debug THEN
1017: debug('HZ_PARTY_SITE_V2PUB.CREATE_PS was successful. Party Site ID = ' || p_address.party_site_id, l_api_name, fnd_log.level_error);
1018: END IF;
1019: END IF;
1020:
1021: IF fnd_api.to_boolean(p_commit) THEN

Line 1028: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);

1024: EXCEPTION
1025: WHEN fnd_api.g_exc_error THEN
1026: IF l_debug THEN
1027: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1028: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
1029: END IF;
1030:
1031: -- ROLLBACK TO create_party;
1032: x_return_status := fnd_api.g_ret_sts_error;

Line 1037: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);

1033: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1034: WHEN fnd_api.g_exc_unexpected_error THEN
1035: IF l_debug THEN
1036: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1037: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
1038: END IF;
1039:
1040: -- ROLLBACK TO create_party;
1041: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1045: debug('Exception: SQLCODE = ' || SQLCODE || ' : SQLERRM = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

1041: x_return_status := fnd_api.g_ret_sts_unexp_error;
1042: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1043: WHEN OTHERS THEN
1044: IF l_debug THEN
1045: debug('Exception: SQLCODE = ' || SQLCODE || ' : SQLERRM = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1046: END IF;
1047:
1048: -- ROLLBACK TO create_party;
1049: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1085: , l_api_name, fnd_log.level_procedure);

1081:
1082: IF l_debug THEN
1083: debug( 'Getting the Party Information for Resource ID = '
1084: || p_resource_id || '( ' || p_resource_type || ') on ' || p_date
1085: , l_api_name, fnd_log.level_procedure);
1086: END IF;
1087:
1088: -- Check for API Compatibility
1089: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 1166: debug('No Home Address found. But found a Party. Using it', l_api_name, fnd_log.level_statement);

1162: );
1163:
1164: ELSIF l_party_addresses_tbl IS NOT NULL AND l_party_addresses_tbl.COUNT > 0 THEN
1165: IF l_debug THEN
1166: debug('No Home Address found. But found a Party. Using it', l_api_name, fnd_log.level_statement);
1167: END IF;
1168:
1169: -- There is no home address. Pick the first Party Fetched.
1170: x_address_rec := l_party_addresses_tbl(1);

Line 1176: debug('Since Location is not created.... Creating it', l_api_name, fnd_log.level_statement);

1172:
1173: -- If there is no Location created for the Address, create it.
1174: IF x_address_rec.location_id IS NULL THEN
1175: IF l_debug THEN
1176: debug('Since Location is not created.... Creating it', l_api_name, fnd_log.level_statement);
1177: END IF;
1178:
1179: create_resource_party_link(
1180: p_api_version => l_api_version

Line 1201: debug('Location is already created.... Needs Updation', l_api_name, fnd_log.level_statement);

1197:
1198: l_validate_address := TRUE;
1199: ELSIF l_home_address.address_id IS NOT NULL AND NOT are_addresses_equal(l_home_address, x_address_rec) THEN
1200: IF l_debug THEN
1201: debug('Location is already created.... Needs Updation', l_api_name, fnd_log.level_statement);
1202: END IF;
1203: l_change_address := fnd_api.g_true;
1204: l_validate_address := TRUE;
1205:

Line 1214: debug('Location is already created.... Needs Geocoding', l_api_name, fnd_log.level_statement);

1210: x_address_rec.territory_short_name := l_home_address.territory_short_name;
1211: x_address_rec.country := l_home_address.country;
1212: ELSIF x_address_rec.geometry IS NULL THEN
1213: IF l_debug THEN
1214: debug('Location is already created.... Needs Geocoding', l_api_name, fnd_log.level_statement);
1215: END IF;
1216: l_validate_address := TRUE;
1217: END IF;
1218:

Line 1223: debug('Resolving the Address again', l_api_name, fnd_log.level_statement);

1219: -- Resolve the address if its a new Resource or Address has changed.
1220: -- Right now only Employee Resource / Party Resource can have an Address. So Resolving only for them.
1221: IF l_validate_address AND p_resource_type IN ('RS_EMPLOYEE', 'RS_PARTY') THEN
1222: IF l_debug THEN
1223: debug('Resolving the Address again', l_api_name, fnd_log.level_statement);
1224: END IF;
1225: l_call_lf := (NVL(fnd_profile.VALUE('CSF_LF_INSTALLED'),'N') = 'Y');
1226: l_skip_eloc := (NVL(fnd_profile.VALUE('CSF_SPATIAL_SKIP_ELOCATION'),'N') = 'N');
1227: IF(l_call_lf OR l_skip_eloc) THEN

Line 1249: debug('Returning Resource Party Info', l_api_name, fnd_log.level_statement);

1245: x_return_status := fnd_api.g_ret_sts_success;
1246: END IF;
1247:
1248: IF l_debug THEN
1249: debug('Returning Resource Party Info', l_api_name, fnd_log.level_statement);
1250: debug(' --> Party Site ID = ' || x_address_rec.party_site_id, l_api_name, fnd_log.level_statement);
1251: END IF;
1252:
1253: IF fnd_api.to_boolean(p_commit) THEN

Line 1250: debug(' --> Party Site ID = ' || x_address_rec.party_site_id, l_api_name, fnd_log.level_statement);

1246: END IF;
1247:
1248: IF l_debug THEN
1249: debug('Returning Resource Party Info', l_api_name, fnd_log.level_statement);
1250: debug(' --> Party Site ID = ' || x_address_rec.party_site_id, l_api_name, fnd_log.level_statement);
1251: END IF;
1252:
1253: IF fnd_api.to_boolean(p_commit) THEN
1254: COMMIT;

Line 1260: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);

1256: EXCEPTION
1257: WHEN fnd_api.g_exc_error THEN
1258: IF l_debug THEN
1259: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1260: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
1261: END IF;
1262:
1263: -- ROLLBACK TO resource_party_info;
1264: x_return_status := fnd_api.g_ret_sts_error;

Line 1269: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);

1265: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1266: WHEN fnd_api.g_exc_unexpected_error THEN
1267: IF l_debug THEN
1268: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1269: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
1270: END IF;
1271:
1272: -- ROLLBACK TO resource_party_info;
1273: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1277: debug('Exception: SQLCODE = ' || SQLCODE || ' : SQLERRM = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

1273: x_return_status := fnd_api.g_ret_sts_unexp_error;
1274: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1275: WHEN OTHERS THEN
1276: IF l_debug THEN
1277: debug('Exception: SQLCODE = ' || SQLCODE || ' : SQLERRM = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1278: END IF;
1279:
1280: -- ROLLBACK TO resource_party_info;
1281: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1356: debug('Creating the Resource Party Link for Resource ID = ' || p_resource_id, l_api_name, fnd_log.level_procedure);

1352:
1353:
1354: BEGIN
1355: IF l_debug THEN
1356: debug('Creating the Resource Party Link for Resource ID = ' || p_resource_id, l_api_name, fnd_log.level_procedure);
1357: END IF;
1358:
1359:
1360: -- Check for API Compatibility

Line 1406: debug('Creating Location Record in HZ_LOCATIONS', l_api_name, fnd_log.level_statement);

1402:
1403: END IF;
1404:
1405: IF l_debug THEN
1406: debug('Creating Location Record in HZ_LOCATIONS', l_api_name, fnd_log.level_statement);
1407: debug(' --> Address1 = ' || l_location_rec.address1, l_api_name, fnd_log.level_statement);
1408: debug(' --> City = ' || l_location_rec.city, l_api_name, fnd_log.level_statement);
1409: debug(' --> State = ' || l_location_rec.state, l_api_name, fnd_log.level_statement);
1410: debug(' --> Zip = ' || l_location_rec.postal_code, l_api_name, fnd_log.level_statement);

Line 1407: debug(' --> Address1 = ' || l_location_rec.address1, l_api_name, fnd_log.level_statement);

1403: END IF;
1404:
1405: IF l_debug THEN
1406: debug('Creating Location Record in HZ_LOCATIONS', l_api_name, fnd_log.level_statement);
1407: debug(' --> Address1 = ' || l_location_rec.address1, l_api_name, fnd_log.level_statement);
1408: debug(' --> City = ' || l_location_rec.city, l_api_name, fnd_log.level_statement);
1409: debug(' --> State = ' || l_location_rec.state, l_api_name, fnd_log.level_statement);
1410: debug(' --> Zip = ' || l_location_rec.postal_code, l_api_name, fnd_log.level_statement);
1411: debug(' --> Country = ' || l_location_rec.country, l_api_name, fnd_log.level_statement);

Line 1408: debug(' --> City = ' || l_location_rec.city, l_api_name, fnd_log.level_statement);

1404:
1405: IF l_debug THEN
1406: debug('Creating Location Record in HZ_LOCATIONS', l_api_name, fnd_log.level_statement);
1407: debug(' --> Address1 = ' || l_location_rec.address1, l_api_name, fnd_log.level_statement);
1408: debug(' --> City = ' || l_location_rec.city, l_api_name, fnd_log.level_statement);
1409: debug(' --> State = ' || l_location_rec.state, l_api_name, fnd_log.level_statement);
1410: debug(' --> Zip = ' || l_location_rec.postal_code, l_api_name, fnd_log.level_statement);
1411: debug(' --> Country = ' || l_location_rec.country, l_api_name, fnd_log.level_statement);
1412: END IF;

Line 1409: debug(' --> State = ' || l_location_rec.state, l_api_name, fnd_log.level_statement);

1405: IF l_debug THEN
1406: debug('Creating Location Record in HZ_LOCATIONS', l_api_name, fnd_log.level_statement);
1407: debug(' --> Address1 = ' || l_location_rec.address1, l_api_name, fnd_log.level_statement);
1408: debug(' --> City = ' || l_location_rec.city, l_api_name, fnd_log.level_statement);
1409: debug(' --> State = ' || l_location_rec.state, l_api_name, fnd_log.level_statement);
1410: debug(' --> Zip = ' || l_location_rec.postal_code, l_api_name, fnd_log.level_statement);
1411: debug(' --> Country = ' || l_location_rec.country, l_api_name, fnd_log.level_statement);
1412: END IF;
1413:

Line 1410: debug(' --> Zip = ' || l_location_rec.postal_code, l_api_name, fnd_log.level_statement);

1406: debug('Creating Location Record in HZ_LOCATIONS', l_api_name, fnd_log.level_statement);
1407: debug(' --> Address1 = ' || l_location_rec.address1, l_api_name, fnd_log.level_statement);
1408: debug(' --> City = ' || l_location_rec.city, l_api_name, fnd_log.level_statement);
1409: debug(' --> State = ' || l_location_rec.state, l_api_name, fnd_log.level_statement);
1410: debug(' --> Zip = ' || l_location_rec.postal_code, l_api_name, fnd_log.level_statement);
1411: debug(' --> Country = ' || l_location_rec.country, l_api_name, fnd_log.level_statement);
1412: END IF;
1413:
1414: l_location_rec.created_by_module := 'CSFDEAR'; -- Calling Module 'CSF: Departure Arrival'

Line 1411: debug(' --> Country = ' || l_location_rec.country, l_api_name, fnd_log.level_statement);

1407: debug(' --> Address1 = ' || l_location_rec.address1, l_api_name, fnd_log.level_statement);
1408: debug(' --> City = ' || l_location_rec.city, l_api_name, fnd_log.level_statement);
1409: debug(' --> State = ' || l_location_rec.state, l_api_name, fnd_log.level_statement);
1410: debug(' --> Zip = ' || l_location_rec.postal_code, l_api_name, fnd_log.level_statement);
1411: debug(' --> Country = ' || l_location_rec.country, l_api_name, fnd_log.level_statement);
1412: END IF;
1413:
1414: l_location_rec.created_by_module := 'CSFDEAR'; -- Calling Module 'CSF: Departure Arrival'
1415:

Line 1428: debug('HZ_LOCATION_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);

1424:
1425: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1426: IF l_debug THEN
1427: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1428: debug('HZ_LOCATION_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
1429: END IF;
1430:
1431: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1432:

Line 1438: debug('HZ_LOCATION_V2PUB.CREATE was successful. Location ID = ' || p_address.location_id, l_api_name, fnd_log.level_statement);

1434: END IF;
1435: RAISE fnd_api.g_exc_error;
1436: ELSE
1437: IF l_debug THEN
1438: debug('HZ_LOCATION_V2PUB.CREATE was successful. Location ID = ' || p_address.location_id, l_api_name, fnd_log.level_statement);
1439: END IF;
1440: END IF;
1441:
1442: IF p_address.party_id IS NULL THEN

Line 1456: debug('Creating Party Record in HZ_PARTIES', l_api_name, fnd_log.level_statement);

1452: FROM dual;
1453: END IF;
1454:
1455: IF l_debug THEN
1456: debug('Creating Party Record in HZ_PARTIES', l_api_name, fnd_log.level_statement);
1457: debug(' --> Party Number = ' || l_person_rec.party_rec.party_number, l_api_name, fnd_log.level_statement);
1458: debug(' --> First Name = ' || l_person_rec.person_first_name, l_api_name, fnd_log.level_statement);
1459: debug(' --> Last Name = ' || l_person_rec.person_last_name, l_api_name, fnd_log.level_statement);
1460: END IF;

Line 1457: debug(' --> Party Number = ' || l_person_rec.party_rec.party_number, l_api_name, fnd_log.level_statement);

1453: END IF;
1454:
1455: IF l_debug THEN
1456: debug('Creating Party Record in HZ_PARTIES', l_api_name, fnd_log.level_statement);
1457: debug(' --> Party Number = ' || l_person_rec.party_rec.party_number, l_api_name, fnd_log.level_statement);
1458: debug(' --> First Name = ' || l_person_rec.person_first_name, l_api_name, fnd_log.level_statement);
1459: debug(' --> Last Name = ' || l_person_rec.person_last_name, l_api_name, fnd_log.level_statement);
1460: END IF;
1461:

Line 1458: debug(' --> First Name = ' || l_person_rec.person_first_name, l_api_name, fnd_log.level_statement);

1454:
1455: IF l_debug THEN
1456: debug('Creating Party Record in HZ_PARTIES', l_api_name, fnd_log.level_statement);
1457: debug(' --> Party Number = ' || l_person_rec.party_rec.party_number, l_api_name, fnd_log.level_statement);
1458: debug(' --> First Name = ' || l_person_rec.person_first_name, l_api_name, fnd_log.level_statement);
1459: debug(' --> Last Name = ' || l_person_rec.person_last_name, l_api_name, fnd_log.level_statement);
1460: END IF;
1461:
1462: hz_party_v2pub.create_person(

Line 1459: debug(' --> Last Name = ' || l_person_rec.person_last_name, l_api_name, fnd_log.level_statement);

1455: IF l_debug THEN
1456: debug('Creating Party Record in HZ_PARTIES', l_api_name, fnd_log.level_statement);
1457: debug(' --> Party Number = ' || l_person_rec.party_rec.party_number, l_api_name, fnd_log.level_statement);
1458: debug(' --> First Name = ' || l_person_rec.person_first_name, l_api_name, fnd_log.level_statement);
1459: debug(' --> Last Name = ' || l_person_rec.person_last_name, l_api_name, fnd_log.level_statement);
1460: END IF;
1461:
1462: hz_party_v2pub.create_person(
1463: p_init_msg_list => fnd_api.g_false

Line 1476: debug('HZ_PARTY_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);

1472:
1473: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1474: IF l_debug THEN
1475: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1476: debug('HZ_PARTY_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
1477: END IF;
1478: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1479: RAISE fnd_api.g_exc_unexpected_error;
1480: END IF;

Line 1484: debug('HZ_PARTY_V2PUB.CREATE_P was successful: Party ID = ' || p_address.party_id, l_api_name, fnd_log.level_statement);

1480: END IF;
1481: RAISE fnd_api.g_exc_error;
1482: ELSE
1483: IF l_debug THEN
1484: debug('HZ_PARTY_V2PUB.CREATE_P was successful: Party ID = ' || p_address.party_id, l_api_name, fnd_log.level_statement);
1485: END IF;
1486: END IF;
1487: ELSE
1488: IF l_debug THEN

Line 1489: debug('Party already exists. Using it. Party ID = ' || p_address.party_id, l_api_name, fnd_log.level_statement);

1485: END IF;
1486: END IF;
1487: ELSE
1488: IF l_debug THEN
1489: debug('Party already exists. Using it. Party ID = ' || p_address.party_id, l_api_name, fnd_log.level_statement);
1490: END IF;
1491: END IF;
1492:
1493: l_party_site_rec.location_id := p_address.location_id;

Line 1505: debug('Creating Party Site Record in HZ_PARTY_SITES', l_api_name, fnd_log.level_statement);

1501: FROM dual;
1502: END IF;
1503:
1504: IF l_debug THEN
1505: debug('Creating Party Site Record in HZ_PARTY_SITES', l_api_name, fnd_log.level_statement);
1506: debug(' --> Party Site Number = ' || l_party_site_rec.party_site_number, l_api_name, fnd_log.level_statement);
1507: debug(' --> Party ID = ' || l_party_site_rec.party_id, l_api_name, fnd_log.level_statement);
1508: debug(' --> Location ID = ' || l_party_site_rec.location_id, l_api_name, fnd_log.level_statement);
1509: END IF;

Line 1506: debug(' --> Party Site Number = ' || l_party_site_rec.party_site_number, l_api_name, fnd_log.level_statement);

1502: END IF;
1503:
1504: IF l_debug THEN
1505: debug('Creating Party Site Record in HZ_PARTY_SITES', l_api_name, fnd_log.level_statement);
1506: debug(' --> Party Site Number = ' || l_party_site_rec.party_site_number, l_api_name, fnd_log.level_statement);
1507: debug(' --> Party ID = ' || l_party_site_rec.party_id, l_api_name, fnd_log.level_statement);
1508: debug(' --> Location ID = ' || l_party_site_rec.location_id, l_api_name, fnd_log.level_statement);
1509: END IF;
1510:

Line 1507: debug(' --> Party ID = ' || l_party_site_rec.party_id, l_api_name, fnd_log.level_statement);

1503:
1504: IF l_debug THEN
1505: debug('Creating Party Site Record in HZ_PARTY_SITES', l_api_name, fnd_log.level_statement);
1506: debug(' --> Party Site Number = ' || l_party_site_rec.party_site_number, l_api_name, fnd_log.level_statement);
1507: debug(' --> Party ID = ' || l_party_site_rec.party_id, l_api_name, fnd_log.level_statement);
1508: debug(' --> Location ID = ' || l_party_site_rec.location_id, l_api_name, fnd_log.level_statement);
1509: END IF;
1510:
1511: hz_party_site_v2pub.create_party_site(

Line 1508: debug(' --> Location ID = ' || l_party_site_rec.location_id, l_api_name, fnd_log.level_statement);

1504: IF l_debug THEN
1505: debug('Creating Party Site Record in HZ_PARTY_SITES', l_api_name, fnd_log.level_statement);
1506: debug(' --> Party Site Number = ' || l_party_site_rec.party_site_number, l_api_name, fnd_log.level_statement);
1507: debug(' --> Party ID = ' || l_party_site_rec.party_id, l_api_name, fnd_log.level_statement);
1508: debug(' --> Location ID = ' || l_party_site_rec.location_id, l_api_name, fnd_log.level_statement);
1509: END IF;
1510:
1511: hz_party_site_v2pub.create_party_site(
1512: p_init_msg_list => fnd_api.g_false

Line 1524: debug('HZ_PARTY_SITE_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);

1520:
1521: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1522: IF l_debug THEN
1523: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1524: debug('HZ_PARTY_SITE_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
1525: END IF;
1526: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1527: RAISE fnd_api.g_exc_unexpected_error;
1528: END IF;

Line 1532: debug('HZ_PARTY_SITE_V2PUB.CREATE_PS was successful. Party Site ID = ' || p_address.party_site_id, l_api_name, fnd_log.level_error);

1528: END IF;
1529: RAISE fnd_api.g_exc_error;
1530: ELSE
1531: IF l_debug THEN
1532: debug('HZ_PARTY_SITE_V2PUB.CREATE_PS was successful. Party Site ID = ' || p_address.party_site_id, l_api_name, fnd_log.level_error);
1533: END IF;
1534: END IF;
1535:
1536: IF fnd_api.to_boolean(p_commit) THEN

Line 1545: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);

1541: EXCEPTION
1542: WHEN fnd_api.g_exc_error THEN
1543: IF l_debug THEN
1544: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1545: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
1546: END IF;
1547:
1548: ROLLBACK TO create_party;
1549: x_return_status := fnd_api.g_ret_sts_error;

Line 1554: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);

1550: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1551: WHEN fnd_api.g_exc_unexpected_error THEN
1552: IF l_debug THEN
1553: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1554: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
1555: END IF;
1556:
1557: ROLLBACK TO create_party;
1558: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1562: debug('Exception: SQLCODE = ' || SQLCODE || ' : SQLERRM = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

1558: x_return_status := fnd_api.g_ret_sts_unexp_error;
1559: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1560: WHEN OTHERS THEN
1561: IF l_debug THEN
1562: debug('Exception: SQLCODE = ' || SQLCODE || ' : SQLERRM = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1563: END IF;
1564:
1565: ROLLBACK TO create_party;
1566: x_return_status := fnd_api.g_ret_sts_unexp_error;