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.WSH_OTM_REF_DATA_GEN_PKG dependencies on WSH_UTIL_CORE

Line 51: x_return_status := wsh_util_core.g_ret_sts_success;

47: WSH_DEBUG_SV.log(l_module_name,'P_CORPORATION_ID',P_CORPORATION_ID);
48: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);
49: END IF;
50: --
51: x_return_status := wsh_util_core.g_ret_sts_success;
52: --
53: insert into WSH_OTM_LOCATIONS_GTMP
54: (location_id, corporation_id, location_type)
55: values( p_location_id,p_corporation_id,p_location_type);

Line 68: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

64: --
65: EXCEPTION
66: --{
67: WHEN OTHERS THEN
68: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
69: --}
70: --
71: -- Debug Statements
72: --

Line 408: x_return_status := wsh_util_core.g_ret_sts_success;

404: --
405: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
406: END IF;
407: --
408: x_return_status := wsh_util_core.g_ret_sts_success;
409: --
410: IF ( p_entity_in_rec.entity_id_tbl.count > 0
411: AND p_entity_in_rec.ENTITY_TYPE = 'DELIVERY'
412: )

Line 443: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

439: --
440: IF l_debug_on THEN
441: WSH_DEBUG_SV.log(l_module_name,'l_return_status after calling Convert_internal_cust_location',l_return_status);
442: WSH_DEBUG_SV.log(l_module_name,'l_internal_loc_id',l_internal_loc_id);
443: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
444: END IF;
445: --
446: wsh_util_core.api_post_call(
447: p_return_status => l_return_status,

Line 446: wsh_util_core.api_post_call(

442: WSH_DEBUG_SV.log(l_module_name,'l_internal_loc_id',l_internal_loc_id);
443: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
444: END IF;
445: --
446: wsh_util_core.api_post_call(
447: p_return_status => l_return_status,
448: x_num_warnings => l_num_warnings,
449: x_num_errors => l_num_errors);
450:

Line 474: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

470: --
471: -- Debug Statements
472: --
473: IF l_debug_on THEN
474: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
475: END IF;
476: --
477: wsh_util_core.api_post_call(
478: p_return_status => l_return_status,

Line 477: wsh_util_core.api_post_call(

473: IF l_debug_on THEN
474: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
475: END IF;
476: --
477: wsh_util_core.api_post_call(
478: p_return_status => l_return_status,
479: x_num_warnings => l_num_warnings,
480: x_num_errors => l_num_errors);
481:

Line 507: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

503: -- Debug Statements
504: --
505: IF l_debug_on THEN
506: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling INSERT_ROW_IN_LOC_GTMP is', l_return_status);
507: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
508: END IF;
509: --
510: wsh_util_core.api_post_call(
511: p_return_status => l_return_status,

Line 510: wsh_util_core.api_post_call(

506: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling INSERT_ROW_IN_LOC_GTMP is', l_return_status);
507: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
508: END IF;
509: --
510: wsh_util_core.api_post_call(
511: p_return_status => l_return_status,
512: x_num_warnings => l_num_warnings,
513: x_num_errors => l_num_errors);
514: --}

Line 543: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

539: -- Debug Statements
540: --
541: IF l_debug_on THEN
542: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling INSERT_ROW_IN_LOC_GTMP is', l_return_status);
543: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
544: END IF;
545: --
546: wsh_util_core.api_post_call(
547: p_return_status => l_return_status,

Line 546: wsh_util_core.api_post_call(

542: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling INSERT_ROW_IN_LOC_GTMP is', l_return_status);
543: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
544: END IF;
545: --
546: wsh_util_core.api_post_call(
547: p_return_status => l_return_status,
548: x_num_warnings => l_num_warnings,
549: x_num_errors => l_num_errors);
550: --}

Line 573: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

569: -- Debug Statements
570: --
571: IF l_debug_on THEN
572: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling INSERT_ROW_IN_LOC_GTMP is', l_return_status);
573: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
574: END IF;
575: --
576: wsh_util_core.api_post_call(
577: p_return_status => l_return_status,

Line 576: wsh_util_core.api_post_call(

572: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling INSERT_ROW_IN_LOC_GTMP is', l_return_status);
573: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
574: END IF;
575: --
576: wsh_util_core.api_post_call(
577: p_return_status => l_return_status,
578: x_num_warnings => l_num_warnings,
579: x_num_errors => l_num_errors);
580: --}

Line 633: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

629: END LOOP;
630: --}
631: END IF;
632: --
633: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
634: --
635: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
636: --
637: ELSE

Line 635: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

631: END IF;
632: --
633: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
634: --
635: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
636: --
637: ELSE
638: --
639: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 639: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

635: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
636: --
637: ELSE
638: --
639: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
640: --
641: END IF;
642: --}
643: --

Line 734: x_return_status := wsh_util_core.g_ret_sts_success;

730: --
731: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
732: END IF;
733: --
734: x_return_status := wsh_util_core.g_ret_sts_success;
735: --
736: IF ( p_entity_in_rec.entity_id_tbl.count > 0
737: AND p_entity_in_rec.entity_type = 'TRIP'
738: )

Line 771: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

767: --
768: -- Debug Statements
769: --
770: IF l_debug_on THEN
771: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
772: END IF;
773: --
774: wsh_util_core.api_post_call(
775: p_return_status => l_return_status,

Line 774: wsh_util_core.api_post_call(

770: IF l_debug_on THEN
771: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
772: END IF;
773: --
774: wsh_util_core.api_post_call(
775: p_return_status => l_return_status,
776: x_num_warnings => l_num_warnings,
777: x_num_errors => l_num_errors);
778: --}

Line 815: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

811: --
812: -- Debug Statements
813: --
814: IF l_debug_on THEN
815: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
816: END IF;
817: --
818: wsh_util_core.api_post_call(
819: p_return_status => l_return_status,

Line 818: wsh_util_core.api_post_call(

814: IF l_debug_on THEN
815: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
816: END IF;
817: --
818: wsh_util_core.api_post_call(
819: p_return_status => l_return_status,
820: x_num_warnings => l_num_warnings,
821: x_num_errors => l_num_errors);
822:

Line 830: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

826: END LOOP;
827: --}
828: END IF;
829: --
830: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
831: --
832: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
833: --
834: ELSE

Line 832: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

828: END IF;
829: --
830: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
831: --
832: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
833: --
834: ELSE
835: --
836: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 836: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

832: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
833: --
834: ELSE
835: --
836: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
837: --
838: END IF;
839: --
840: --}

Line 851: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

847: --
848: EXCEPTION
849: --{
850: WHEN FND_API.G_EXC_ERROR THEN
851: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
852: --
853: -- Debug Statements
854: --
855: IF l_debug_on THEN

Line 861: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

857: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
858: END IF;
859: --
860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
861: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
862: --
863: -- Debug Statements
864: --
865: IF l_debug_on THEN

Line 871: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

867: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
868: END IF;
869: --
870: WHEN OTHERS THEN
871: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
872: --}
873: --
874: -- Debug Statements
875: --

Line 931: x_return_status := wsh_util_core.g_ret_sts_success;

927: --
928: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
929: END IF;
930: --
931: x_return_status := wsh_util_core.g_ret_sts_success;
932: --
933: IF ( p_entity_in_rec.entity_id_tbl.count > 0
934: AND p_entity_in_rec.entity_id_tbl.count = p_entity_in_rec.parent_entity_id_tbl.count
935: )

Line 989: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

985: -- Debug Statements
986: --
987: IF l_debug_on THEN
988: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
989: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
990: END IF;
991: --
992: wsh_util_core.api_post_call(
993: p_return_status => l_return_status,

Line 992: wsh_util_core.api_post_call(

988: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
989: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
990: END IF;
991: --
992: wsh_util_core.api_post_call(
993: p_return_status => l_return_status,
994: x_num_warnings => l_num_warnings,
995: x_num_errors => l_num_errors);
996: --

Line 1014: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1010: --
1011: EXCEPTION
1012: --{
1013: WHEN OTHERS THEN
1014: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1015: --
1016: -- Debug Statements
1017: --
1018: IF l_debug_on THEN

Line 1076: x_return_status := wsh_util_core.g_ret_sts_success;

1072: --
1073: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
1074: END IF;
1075: --
1076: x_return_status := wsh_util_core.g_ret_sts_success;
1077: --
1078: IF ( p_entity_in_rec.entity_id_tbl.count > 0)
1079: THEN
1080: --{

Line 1114: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1110: WSH_DEBUG_SV.log(l_module_name,'return status from insert into locGtmp ', l_return_status);
1111: WSH_DEBUG_SV.log(l_module_name,'org_id ('||i||')',p_entity_in_rec.entity_id_tbl(i));
1112: WSH_DEBUG_SV.log(l_module_name,'from_location_id', l_location_id);
1113: WSH_DEBUG_SV.log(l_module_name,'gtmp_location_id', l_gtmp_location_id);
1114: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1115: --
1116: END IF;
1117: --
1118: --

Line 1119: wsh_util_core.api_post_call(

1115: --
1116: END IF;
1117: --
1118: --
1119: wsh_util_core.api_post_call(
1120: p_return_status => l_return_status,
1121: x_num_warnings => l_num_warnings,
1122: x_num_errors => l_num_errors);
1123:

Line 1140: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1136: --
1137: EXCEPTION
1138: --{
1139: WHEN OTHERS THEN
1140: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1141: --
1142: IF l_get_org_loc_id_csr%ISOPEN THEN
1143: CLOSE l_get_org_loc_id_csr;
1144: END IF;

Line 1409: l_contact_ph_cntr_code_tbl wsh_util_core.Column_Tab_Type;

1405: --contact related variables
1406: TYPE char500_tab_type IS TABLE OF VARCHAR2(500) INDEX BY BINARY_INTEGER;
1407: l_contact_first_name_tbl char500_tab_type;
1408: l_contact_last_name_tbl char500_tab_type;
1409: l_contact_ph_cntr_code_tbl wsh_util_core.Column_Tab_Type;
1410: l_contact_ph_area_code_tbl wsh_util_core.Column_Tab_Type;
1411: l_contact_ph_number_tbl wsh_util_core.Column_Tab_Type;
1412: l_contact_email_addr_tbl char500_tab_type;
1413: l_contact_job_title_tbl char500_tab_type;

Line 1410: l_contact_ph_area_code_tbl wsh_util_core.Column_Tab_Type;

1406: TYPE char500_tab_type IS TABLE OF VARCHAR2(500) INDEX BY BINARY_INTEGER;
1407: l_contact_first_name_tbl char500_tab_type;
1408: l_contact_last_name_tbl char500_tab_type;
1409: l_contact_ph_cntr_code_tbl wsh_util_core.Column_Tab_Type;
1410: l_contact_ph_area_code_tbl wsh_util_core.Column_Tab_Type;
1411: l_contact_ph_number_tbl wsh_util_core.Column_Tab_Type;
1412: l_contact_email_addr_tbl char500_tab_type;
1413: l_contact_job_title_tbl char500_tab_type;
1414: l_contact_id_tbl wsh_util_core.id_tab_type;

Line 1411: l_contact_ph_number_tbl wsh_util_core.Column_Tab_Type;

1407: l_contact_first_name_tbl char500_tab_type;
1408: l_contact_last_name_tbl char500_tab_type;
1409: l_contact_ph_cntr_code_tbl wsh_util_core.Column_Tab_Type;
1410: l_contact_ph_area_code_tbl wsh_util_core.Column_Tab_Type;
1411: l_contact_ph_number_tbl wsh_util_core.Column_Tab_Type;
1412: l_contact_email_addr_tbl char500_tab_type;
1413: l_contact_job_title_tbl char500_tab_type;
1414: l_contact_id_tbl wsh_util_core.id_tab_type;
1415: l_contact_last_upd_date_tbl wsh_util_core.Date_Tab_Type;

Line 1414: l_contact_id_tbl wsh_util_core.id_tab_type;

1410: l_contact_ph_area_code_tbl wsh_util_core.Column_Tab_Type;
1411: l_contact_ph_number_tbl wsh_util_core.Column_Tab_Type;
1412: l_contact_email_addr_tbl char500_tab_type;
1413: l_contact_job_title_tbl char500_tab_type;
1414: l_contact_id_tbl wsh_util_core.id_tab_type;
1415: l_contact_last_upd_date_tbl wsh_util_core.Date_Tab_Type;
1416:
1417: -- eco 5381528
1418: l_dispatch_loc CONSTANT VARCHAR2(20) := 'DISPATCH LOCATION';

Line 1415: l_contact_last_upd_date_tbl wsh_util_core.Date_Tab_Type;

1411: l_contact_ph_number_tbl wsh_util_core.Column_Tab_Type;
1412: l_contact_email_addr_tbl char500_tab_type;
1413: l_contact_job_title_tbl char500_tab_type;
1414: l_contact_id_tbl wsh_util_core.id_tab_type;
1415: l_contact_last_upd_date_tbl wsh_util_core.Date_Tab_Type;
1416:
1417: -- eco 5381528
1418: l_dispatch_loc CONSTANT VARCHAR2(20) := 'DISPATCH LOCATION';
1419: l_supplier_site_ref_value VARCHAR2(1000);

Line 1633: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1629: --
1630: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
1631: END IF;
1632: --
1633: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1634:
1635: x_loc_xmission_rec := WSH_OTM_LOC_XMISSION_REC_TYPE(NULL, NULL,WSH_OTM_LOCATIONS_TBL_TYPE());
1636: --x_loc_xmission_rec.LOCATIONS_TBL := WSH_OTM_LOCATIONS_TBL_TYPE();
1637:

Line 1648: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;

1644:
1645: IF (l_domain_name is null) THEN
1646: --{
1647: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_DOMAIN_NOT_SET_ERR');
1648: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
1649: wsh_util_core.add_message(x_return_status, l_module_name);
1650: IF l_debug_on THEN
1651: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_DOMAIN_NAME is set to NULL. Please correct the profile value');
1652: END IF;

Line 1649: wsh_util_core.add_message(x_return_status, l_module_name);

1645: IF (l_domain_name is null) THEN
1646: --{
1647: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_DOMAIN_NOT_SET_ERR');
1648: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
1649: wsh_util_core.add_message(x_return_status, l_module_name);
1650: IF l_debug_on THEN
1651: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_DOMAIN_NAME is set to NULL. Please correct the profile value');
1652: END IF;
1653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1660: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;

1656:
1657: IF (l_country_code is null) THEN
1658: --{
1659: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_CNTR_CODE_NOT_SET_ERR');
1660: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
1661: wsh_util_core.add_message(x_return_status, l_module_name);
1662: IF l_debug_on THEN
1663: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_CORP_COUNTRY_CODE is set to NULL. Please correct the profile value');
1664: END IF;

Line 1661: wsh_util_core.add_message(x_return_status, l_module_name);

1657: IF (l_country_code is null) THEN
1658: --{
1659: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_CNTR_CODE_NOT_SET_ERR');
1660: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
1661: wsh_util_core.add_message(x_return_status, l_module_name);
1662: IF l_debug_on THEN
1663: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_CORP_COUNTRY_CODE is set to NULL. Please correct the profile value');
1664: END IF;
1665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1721: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1717: IF l_debug_on THEN
1718: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1719: WSH_DEBUG_SV.log(l_module_name,'Calling Entity Type from Send_LOcations', p_entity_type);
1720: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
1721: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1722: END IF;
1723: --
1724: wsh_util_core.api_post_call(
1725: p_return_status => l_return_status,

Line 1724: wsh_util_core.api_post_call(

1720: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
1721: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1722: END IF;
1723: --
1724: wsh_util_core.api_post_call(
1725: p_return_status => l_return_status,
1726: x_num_warnings => l_num_warnings,
1727: x_num_errors => l_num_errors);
1728: -- wms-otm-proj if the Call to Send_LOCATIONs is from Entity_type 'ORG_LOC' then

Line 1936: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1932: --
1933: IF l_debug_on THEN
1934: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1935: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
1936: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1937: END IF;
1938: --
1939: wsh_util_core.api_post_call(
1940: p_return_status => l_return_status,

Line 1939: wsh_util_core.api_post_call(

1935: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
1936: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1937: END IF;
1938: --
1939: wsh_util_core.api_post_call(
1940: p_return_status => l_return_status,
1941: x_num_warnings => l_num_warnings,
1942: x_num_errors => l_num_errors);
1943:

Line 2213: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;

2209: IF (x_loc_xmission_rec.username is null) THEN
2210: --{
2211: FND_MESSAGE.SET_NAME('WSH','WSH_PROFILE_NOT_SET_ERR');
2212: FND_MESSAGE.SET_TOKEN('PRF_NAME','WSH_OTM_USER_ID');
2213: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2214: wsh_util_core.add_message(x_return_status, l_module_name);
2215: IF l_debug_on THEN
2216: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_USER_ID is set to NULL. Please correct the profile value');
2217: END IF;

Line 2214: wsh_util_core.add_message(x_return_status, l_module_name);

2210: --{
2211: FND_MESSAGE.SET_NAME('WSH','WSH_PROFILE_NOT_SET_ERR');
2212: FND_MESSAGE.SET_TOKEN('PRF_NAME','WSH_OTM_USER_ID');
2213: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2214: wsh_util_core.add_message(x_return_status, l_module_name);
2215: IF l_debug_on THEN
2216: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_USER_ID is set to NULL. Please correct the profile value');
2217: END IF;
2218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2226: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;

2222: IF (x_loc_xmission_rec.password is null) THEN
2223: --{
2224: FND_MESSAGE.SET_NAME('WSH','WSH_PROFILE_NOT_SET_ERR');
2225: FND_MESSAGE.SET_TOKEN('PRF_NAME','WSH_OTM_PASSWORD');
2226: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2227: wsh_util_core.add_message(x_return_status, l_module_name);
2228: IF l_debug_on THEN
2229: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_PASSWORD is set to NULL. Please correct the profile value');
2230: END IF;

Line 2227: wsh_util_core.add_message(x_return_status, l_module_name);

2223: --{
2224: FND_MESSAGE.SET_NAME('WSH','WSH_PROFILE_NOT_SET_ERR');
2225: FND_MESSAGE.SET_TOKEN('PRF_NAME','WSH_OTM_PASSWORD');
2226: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2227: wsh_util_core.add_message(x_return_status, l_module_name);
2228: IF l_debug_on THEN
2229: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_PASSWORD is set to NULL. Please correct the profile value');
2230: END IF;
2231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2267: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

2263: --
2264: IF l_debug_on THEN
2265: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling IS_REF_DATA_SEND_REQD is', l_return_status);
2266: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
2267: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2268: END IF;
2269: --
2270: wsh_util_core.api_post_call(
2271: p_return_status => l_return_status,

Line 2270: wsh_util_core.api_post_call(

2266: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
2267: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2268: END IF;
2269: --
2270: wsh_util_core.api_post_call(
2271: p_return_status => l_return_status,
2272: x_num_warnings => l_num_warnings,
2273: x_num_errors => l_num_errors);
2274: */

Line 2571: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

2567: i := i + 1;
2568: --}
2569: END LOOP;
2570: --
2571: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2572: --
2573: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2574: --
2575: ELSE

Line 2573: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2569: END LOOP;
2570: --
2571: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2572: --
2573: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2574: --
2575: ELSE
2576: --
2577: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2577: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2573: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2574: --
2575: ELSE
2576: --
2577: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2578: --
2579: END IF;
2580: --
2581: --}

Line 2592: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2588: --
2589: EXCEPTION
2590: --{
2591: WHEN OTHERS THEN
2592: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2593: --}
2594: --
2595: -- Debug Statements
2596: --

Line 2654: x_return_status := wsh_util_core.g_ret_sts_success;

2650: WSH_DEBUG_SV.push(l_module_name);
2651: WSH_DEBUG_SV.log(l_module_name,'entity type is ', p_entity_in_rec.entity_type);
2652: END IF;
2653: --
2654: x_return_status := wsh_util_core.g_ret_sts_success;
2655:
2656: select WSH_OTM_SYNC_REF_DATA_LOG_S.nextval into l_transmission_id from dual;
2657: --
2658: IF (p_entity_in_rec.entity_type = 'TRIP') THEN

Line 2671: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

2667: --
2668: -- Debug Statements
2669: --
2670: IF l_debug_on THEN
2671: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2672: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_TRIP_INFO is', l_return_status);
2673: END IF;
2674: --
2675: wsh_util_core.api_post_call(

Line 2675: wsh_util_core.api_post_call(

2671: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2672: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_TRIP_INFO is', l_return_status);
2673: END IF;
2674: --
2675: wsh_util_core.api_post_call(
2676: p_return_status => l_return_status,
2677: x_num_warnings => l_num_warnings,
2678: x_num_errors => l_num_errors);
2679:

Line 2695: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

2691: --
2692: -- Debug Statements
2693: --
2694: IF l_debug_on THEN
2695: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2696: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_TRIP_INFO is', l_return_status);
2697: END IF;
2698: --
2699: wsh_util_core.api_post_call(

Line 2699: wsh_util_core.api_post_call(

2695: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2696: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_TRIP_INFO is', l_return_status);
2697: END IF;
2698: --
2699: wsh_util_core.api_post_call(
2700: p_return_status => l_return_status,
2701: x_num_warnings => l_num_warnings,
2702: x_num_errors => l_num_errors);
2703:

Line 2722: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

2718: -- Debug Statements
2719: --
2720: IF l_debug_on THEN
2721: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling VALIDATE_TKT is', l_return_status);
2722: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2723: END IF;
2724: --
2725: wsh_util_core.api_post_call(
2726: p_return_status => l_return_status,

Line 2725: wsh_util_core.api_post_call(

2721: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling VALIDATE_TKT is', l_return_status);
2722: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2723: END IF;
2724: --
2725: wsh_util_core.api_post_call(
2726: p_return_status => l_return_status,
2727: x_num_warnings => l_num_warnings,
2728: x_num_errors => l_num_errors);
2729:

Line 2742: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

2738: --
2739: -- Debug Statements
2740: --
2741: IF l_debug_on THEN
2742: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2743: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_CARRIER_INFO is', l_return_status);
2744: END IF;
2745: --
2746: wsh_util_core.api_post_call(

Line 2746: wsh_util_core.api_post_call(

2742: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2743: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_CARRIER_INFO is', l_return_status);
2744: END IF;
2745: --
2746: wsh_util_core.api_post_call(
2747: p_return_status => l_return_status,
2748: x_num_warnings => l_num_warnings,
2749: x_num_errors => l_num_errors);
2750:

Line 2770: WSH_DEBUG_SV.logmsg(l_module_name,'calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

2766: -- Debug Statements
2767: --
2768: IF l_debug_on THEN
2769: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling VALIDATE_TKT is', l_return_status);
2770: WSH_DEBUG_SV.logmsg(l_module_name,'calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2771: END IF;
2772: --
2773: wsh_util_core.api_post_call(
2774: p_return_status => l_return_status,

Line 2773: wsh_util_core.api_post_call(

2769: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling VALIDATE_TKT is', l_return_status);
2770: WSH_DEBUG_SV.logmsg(l_module_name,'calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2771: END IF;
2772: --
2773: wsh_util_core.api_post_call(
2774: p_return_status => l_return_status,
2775: x_num_warnings => l_num_warnings,
2776: x_num_errors => l_num_errors);
2777:

Line 2790: WSH_DEBUG_SV.logmsg(l_module_name,'OrgAfterCalling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

2786: --
2787: -- Debug Statements
2788: --
2789: IF l_debug_on THEN
2790: WSH_DEBUG_SV.logmsg(l_module_name,'OrgAfterCalling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2791: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_ORG_INFO is', l_return_status);
2792: END IF;
2793: --
2794: wsh_util_core.api_post_call(

Line 2794: wsh_util_core.api_post_call(

2790: WSH_DEBUG_SV.logmsg(l_module_name,'OrgAfterCalling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2791: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_ORG_INFO is', l_return_status);
2792: END IF;
2793: --
2794: wsh_util_core.api_post_call(
2795: p_return_status => l_return_status,
2796: x_num_warnings => l_num_warnings,
2797: x_num_errors => l_num_errors);
2798:

Line 2804: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;

2800: ELSE
2801: --{
2802: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_INVALID_ENTITY');
2803: FND_MESSAGE.SET_TOKEN('ENTITY',p_entity_in_rec.entity_type);
2804: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2805: wsh_util_core.add_message(x_return_status, l_module_name);
2806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2807: --}
2808: END IF;

Line 2805: wsh_util_core.add_message(x_return_status, l_module_name);

2801: --{
2802: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_INVALID_ENTITY');
2803: FND_MESSAGE.SET_TOKEN('ENTITY',p_entity_in_rec.entity_type);
2804: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2805: wsh_util_core.add_message(x_return_status, l_module_name);
2806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2807: --}
2808: END IF;
2809:

Line 2827: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

2823: --
2824: IF l_debug_on THEN
2825: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_LOCATION_INFO is', l_return_status);
2826: WSH_DEBUG_SV.log(l_module_name,'Number of records finally being sent to GC3 is',x_loc_xmission_rec.LOCATIONS_TBL.count);
2827: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2828: END IF;
2829: --
2830: wsh_util_core.api_post_call(
2831: p_return_status => l_return_status,

Line 2830: wsh_util_core.api_post_call(

2826: WSH_DEBUG_SV.log(l_module_name,'Number of records finally being sent to GC3 is',x_loc_xmission_rec.LOCATIONS_TBL.count);
2827: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2828: END IF;
2829: --
2830: wsh_util_core.api_post_call(
2831: p_return_status => l_return_status,
2832: x_num_warnings => l_num_warnings,
2833: x_num_errors => l_num_errors);
2834:

Line 2835: WSH_UTIL_CORE.Get_Messages

2831: p_return_status => l_return_status,
2832: x_num_warnings => l_num_warnings,
2833: x_num_errors => l_num_errors);
2834:
2835: WSH_UTIL_CORE.Get_Messages
2836: (
2837: p_init_msg_list => 'T',
2838: x_summary => l_summary,
2839: x_details => l_details,

Line 2850: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

2846: x_transmission_id := l_transmission_id;
2847: END IF;
2848:
2849:
2850: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2851: --
2852: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2853: --
2854: ELSE

Line 2852: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2848:
2849:
2850: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2851: --
2852: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2853: --
2854: ELSE
2855: --
2856: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2856: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2852: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2853: --
2854: ELSE
2855: --
2856: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2857: --
2858: END IF;
2859:
2860: --

Line 2871: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2867: --}
2868: EXCEPTION
2869: --{
2870: WHEN FND_API.G_EXC_ERROR THEN
2871: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2872: --
2873: -- Debug Statements
2874: --
2875: WSH_UTIL_CORE.Get_Messages

Line 2875: WSH_UTIL_CORE.Get_Messages

2871: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2872: --
2873: -- Debug Statements
2874: --
2875: WSH_UTIL_CORE.Get_Messages
2876: (
2877: p_init_msg_list => 'T',
2878: x_summary => l_summary,
2879: x_details => l_details,

Line 2891: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

2887: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2888: END IF;
2889: --
2890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2891: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2892: --
2893: WSH_UTIL_CORE.Get_Messages
2894: (
2895: p_init_msg_list => 'T',

Line 2893: WSH_UTIL_CORE.Get_Messages

2889: --
2890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2891: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2892: --
2893: WSH_UTIL_CORE.Get_Messages
2894: (
2895: p_init_msg_list => 'T',
2896: x_summary => l_summary,
2897: x_details => l_details,

Line 2912: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2908: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2909: END IF;
2910: --
2911: WHEN OTHERS THEN
2912: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2913: --
2914: WSH_UTIL_CORE.Get_Messages
2915: (
2916: p_init_msg_list => 'T',

Line 2914: WSH_UTIL_CORE.Get_Messages

2910: --
2911: WHEN OTHERS THEN
2912: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2913: --
2914: WSH_UTIL_CORE.Get_Messages
2915: (
2916: p_init_msg_list => 'T',
2917: x_summary => l_summary,
2918: x_details => l_details,

Line 3059: x_return_status := wsh_util_core.G_RET_STS_SUCCESS;

3055: WSH_DEBUG_SV.log(l_module_name,'p_ticket',p_ticket);
3056: END IF;
3057: --
3058: x_tkt_valid := 'F';
3059: x_return_status := wsh_util_core.G_RET_STS_SUCCESS;
3060:
3061: IF l_debug_on THEN
3062: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FND_HTTP_TICKET.CHECK_TICKET',WSH_DEBUG_SV.C_PROC_LEVEL);
3063: END IF;

Line 3095: x_return_status := wsh_util_core.G_RET_STS_ERROR;

3091: END IF;
3092: x_tkt_valid := 'F';
3093: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_INVALID_TKT');
3094: FND_MESSAGE.SET_TOKEN('TICKET',p_ticket);
3095: x_return_status := wsh_util_core.G_RET_STS_ERROR;
3096: x_msg_data :=FND_MESSAGE.GET;
3097: --}
3098: END IF;
3099: --

Line 3111: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3107: EXCEPTION
3108: --{
3109: WHEN OTHERS THEN
3110: --
3111: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3112: x_tkt_valid := 'F';
3113: x_msg_data := SQLERRM;
3114:
3115: --

Line 3171: x_return_status := wsh_util_core.g_ret_sts_success;

3167: --
3168: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
3169: END IF;
3170: --
3171: x_return_status := wsh_util_core.g_ret_sts_success;
3172: --
3173: WSH_LOCATIONS_PKG.Convert_internal_cust_location(
3174: p_internal_cust_location_id => p_location_id,
3175: x_internal_org_location_id => l_int_location_id,

Line 3183: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

3179: --
3180: IF l_debug_on THEN
3181: WSH_DEBUG_SV.log(l_module_name,'l_return_status after calling Convert_internal_cust_location',l_return_status);
3182: WSH_DEBUG_SV.log(l_module_name,'l_int_location_id',l_int_location_id);
3183: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3184: END IF;
3185: --
3186: wsh_util_core.api_post_call(
3187: p_return_status => l_return_status,

Line 3186: wsh_util_core.api_post_call(

3182: WSH_DEBUG_SV.log(l_module_name,'l_int_location_id',l_int_location_id);
3183: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3184: END IF;
3185: --
3186: wsh_util_core.api_post_call(
3187: p_return_status => l_return_status,
3188: x_num_warnings => l_num_warnings,
3189: x_num_errors => l_num_errors);
3190:

Line 3225: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3221: EXCEPTION
3222: --{
3223: WHEN FND_API.G_EXC_ERROR THEN
3224: --
3225: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3226: --
3227:
3228: IF l_debug_on THEN
3229: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 3235: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

3231: END IF;
3232: --
3233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3234: --
3235: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3236: --
3237: -- Debug Statements
3238: --
3239: IF l_debug_on THEN

Line 3246: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3242: END IF;
3243: --
3244: WHEN OTHERS THEN
3245: --
3246: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3247: --
3248: -- Debug Statements
3249: --
3250: IF l_debug_on THEN