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 378: x_return_status := wsh_util_core.g_ret_sts_success;

374: --
375: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
376: END IF;
377: --
378: x_return_status := wsh_util_core.g_ret_sts_success;
379: --
380: IF ( p_entity_in_rec.entity_id_tbl.count > 0
381: AND p_entity_in_rec.ENTITY_TYPE = 'DELIVERY'
382: )

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

400: --
401: IF l_debug_on THEN
402: WSH_DEBUG_SV.log(l_module_name,'l_return_status after calling Convert_internal_cust_location',l_return_status);
403: WSH_DEBUG_SV.log(l_module_name,'l_internal_loc_id',l_internal_loc_id);
404: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
405: END IF;
406: --
407: wsh_util_core.api_post_call(
408: p_return_status => l_return_status,

Line 407: wsh_util_core.api_post_call(

403: WSH_DEBUG_SV.log(l_module_name,'l_internal_loc_id',l_internal_loc_id);
404: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
405: END IF;
406: --
407: wsh_util_core.api_post_call(
408: p_return_status => l_return_status,
409: x_num_warnings => l_num_warnings,
410: x_num_errors => l_num_errors);
411:

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

431: --
432: -- Debug Statements
433: --
434: IF l_debug_on THEN
435: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
436: END IF;
437: --
438: wsh_util_core.api_post_call(
439: p_return_status => l_return_status,

Line 438: wsh_util_core.api_post_call(

434: IF l_debug_on THEN
435: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
436: END IF;
437: --
438: wsh_util_core.api_post_call(
439: p_return_status => l_return_status,
440: x_num_warnings => l_num_warnings,
441: x_num_errors => l_num_errors);
442:

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

464: -- Debug Statements
465: --
466: IF l_debug_on THEN
467: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling INSERT_ROW_IN_LOC_GTMP is', l_return_status);
468: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
469: END IF;
470: --
471: wsh_util_core.api_post_call(
472: p_return_status => l_return_status,

Line 471: wsh_util_core.api_post_call(

467: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling INSERT_ROW_IN_LOC_GTMP is', l_return_status);
468: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
469: END IF;
470: --
471: wsh_util_core.api_post_call(
472: p_return_status => l_return_status,
473: x_num_warnings => l_num_warnings,
474: x_num_errors => l_num_errors);
475: --}

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

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

Line 507: wsh_util_core.api_post_call(

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

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

530: -- Debug Statements
531: --
532: IF l_debug_on THEN
533: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling INSERT_ROW_IN_LOC_GTMP is', l_return_status);
534: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
535: END IF;
536: --
537: wsh_util_core.api_post_call(
538: p_return_status => l_return_status,

Line 537: wsh_util_core.api_post_call(

533: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling INSERT_ROW_IN_LOC_GTMP is', l_return_status);
534: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
535: END IF;
536: --
537: wsh_util_core.api_post_call(
538: p_return_status => l_return_status,
539: x_num_warnings => l_num_warnings,
540: x_num_errors => l_num_errors);
541: --}

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

590: END LOOP;
591: --}
592: END IF;
593: --
594: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
595: --
596: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
597: --
598: ELSE

Line 596: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

592: END IF;
593: --
594: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
595: --
596: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
597: --
598: ELSE
599: --
600: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 600: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

596: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
597: --
598: ELSE
599: --
600: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
601: --
602: END IF;
603: --}
604: --

Line 695: x_return_status := wsh_util_core.g_ret_sts_success;

691: --
692: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
693: END IF;
694: --
695: x_return_status := wsh_util_core.g_ret_sts_success;
696: --
697: IF ( p_entity_in_rec.entity_id_tbl.count > 0
698: AND p_entity_in_rec.entity_type = 'TRIP'
699: )

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

728: --
729: -- Debug Statements
730: --
731: IF l_debug_on THEN
732: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
733: END IF;
734: --
735: wsh_util_core.api_post_call(
736: p_return_status => l_return_status,

Line 735: wsh_util_core.api_post_call(

731: IF l_debug_on THEN
732: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
733: END IF;
734: --
735: wsh_util_core.api_post_call(
736: p_return_status => l_return_status,
737: x_num_warnings => l_num_warnings,
738: x_num_errors => l_num_errors);
739: --}

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

772: --
773: -- Debug Statements
774: --
775: IF l_debug_on THEN
776: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
777: END IF;
778: --
779: wsh_util_core.api_post_call(
780: p_return_status => l_return_status,

Line 779: wsh_util_core.api_post_call(

775: IF l_debug_on THEN
776: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
777: END IF;
778: --
779: wsh_util_core.api_post_call(
780: p_return_status => l_return_status,
781: x_num_warnings => l_num_warnings,
782: x_num_errors => l_num_errors);
783:

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

787: END LOOP;
788: --}
789: END IF;
790: --
791: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
792: --
793: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
794: --
795: ELSE

Line 793: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

789: END IF;
790: --
791: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
792: --
793: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
794: --
795: ELSE
796: --
797: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 797: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

793: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
794: --
795: ELSE
796: --
797: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
798: --
799: END IF;
800: --
801: --}

Line 812: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

808: --
809: EXCEPTION
810: --{
811: WHEN FND_API.G_EXC_ERROR THEN
812: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
813: --
814: -- Debug Statements
815: --
816: IF l_debug_on THEN

Line 822: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

818: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
819: END IF;
820: --
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
822: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
823: --
824: -- Debug Statements
825: --
826: IF l_debug_on THEN

Line 832: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

828: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
829: END IF;
830: --
831: WHEN OTHERS THEN
832: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
833: --}
834: --
835: -- Debug Statements
836: --

Line 892: x_return_status := wsh_util_core.g_ret_sts_success;

888: --
889: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
890: END IF;
891: --
892: x_return_status := wsh_util_core.g_ret_sts_success;
893: --
894: IF ( p_entity_in_rec.entity_id_tbl.count > 0
895: AND p_entity_in_rec.entity_id_tbl.count = p_entity_in_rec.parent_entity_id_tbl.count
896: )

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

946: -- Debug Statements
947: --
948: IF l_debug_on THEN
949: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
950: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
951: END IF;
952: --
953: wsh_util_core.api_post_call(
954: p_return_status => l_return_status,

Line 953: wsh_util_core.api_post_call(

949: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
950: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
951: END IF;
952: --
953: wsh_util_core.api_post_call(
954: p_return_status => l_return_status,
955: x_num_warnings => l_num_warnings,
956: x_num_errors => l_num_errors);
957: --

Line 975: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

971: --
972: EXCEPTION
973: --{
974: WHEN OTHERS THEN
975: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
976: --
977: -- Debug Statements
978: --
979: IF l_debug_on THEN

Line 1037: x_return_status := wsh_util_core.g_ret_sts_success;

1033: --
1034: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
1035: END IF;
1036: --
1037: x_return_status := wsh_util_core.g_ret_sts_success;
1038: --
1039: IF ( p_entity_in_rec.entity_id_tbl.count > 0)
1040: THEN
1041: --{

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

1071: WSH_DEBUG_SV.log(l_module_name,'return status from insert into locGtmp ', l_return_status);
1072: WSH_DEBUG_SV.log(l_module_name,'org_id ('||i||')',p_entity_in_rec.entity_id_tbl(i));
1073: WSH_DEBUG_SV.log(l_module_name,'from_location_id', l_location_id);
1074: WSH_DEBUG_SV.log(l_module_name,'gtmp_location_id', l_gtmp_location_id);
1075: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1076: --
1077: END IF;
1078: --
1079: --

Line 1080: wsh_util_core.api_post_call(

1076: --
1077: END IF;
1078: --
1079: --
1080: wsh_util_core.api_post_call(
1081: p_return_status => l_return_status,
1082: x_num_warnings => l_num_warnings,
1083: x_num_errors => l_num_errors);
1084:

Line 1101: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1097: --
1098: EXCEPTION
1099: --{
1100: WHEN OTHERS THEN
1101: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1102: --
1103: IF l_get_org_loc_id_csr%ISOPEN THEN
1104: CLOSE l_get_org_loc_id_csr;
1105: END IF;

Line 1370: l_contact_ph_cntr_code_tbl wsh_util_core.Column_Tab_Type;

1366: --contact related variables
1367: TYPE char500_tab_type IS TABLE OF VARCHAR2(500) INDEX BY BINARY_INTEGER;
1368: l_contact_first_name_tbl char500_tab_type;
1369: l_contact_last_name_tbl char500_tab_type;
1370: l_contact_ph_cntr_code_tbl wsh_util_core.Column_Tab_Type;
1371: l_contact_ph_area_code_tbl wsh_util_core.Column_Tab_Type;
1372: l_contact_ph_number_tbl wsh_util_core.Column_Tab_Type;
1373: l_contact_email_addr_tbl char500_tab_type;
1374: l_contact_job_title_tbl char500_tab_type;

Line 1371: l_contact_ph_area_code_tbl wsh_util_core.Column_Tab_Type;

1367: TYPE char500_tab_type IS TABLE OF VARCHAR2(500) INDEX BY BINARY_INTEGER;
1368: l_contact_first_name_tbl char500_tab_type;
1369: l_contact_last_name_tbl char500_tab_type;
1370: l_contact_ph_cntr_code_tbl wsh_util_core.Column_Tab_Type;
1371: l_contact_ph_area_code_tbl wsh_util_core.Column_Tab_Type;
1372: l_contact_ph_number_tbl wsh_util_core.Column_Tab_Type;
1373: l_contact_email_addr_tbl char500_tab_type;
1374: l_contact_job_title_tbl char500_tab_type;
1375: l_contact_id_tbl wsh_util_core.id_tab_type;

Line 1372: l_contact_ph_number_tbl wsh_util_core.Column_Tab_Type;

1368: l_contact_first_name_tbl char500_tab_type;
1369: l_contact_last_name_tbl char500_tab_type;
1370: l_contact_ph_cntr_code_tbl wsh_util_core.Column_Tab_Type;
1371: l_contact_ph_area_code_tbl wsh_util_core.Column_Tab_Type;
1372: l_contact_ph_number_tbl wsh_util_core.Column_Tab_Type;
1373: l_contact_email_addr_tbl char500_tab_type;
1374: l_contact_job_title_tbl char500_tab_type;
1375: l_contact_id_tbl wsh_util_core.id_tab_type;
1376: l_contact_last_upd_date_tbl wsh_util_core.Date_Tab_Type;

Line 1375: l_contact_id_tbl wsh_util_core.id_tab_type;

1371: l_contact_ph_area_code_tbl wsh_util_core.Column_Tab_Type;
1372: l_contact_ph_number_tbl wsh_util_core.Column_Tab_Type;
1373: l_contact_email_addr_tbl char500_tab_type;
1374: l_contact_job_title_tbl char500_tab_type;
1375: l_contact_id_tbl wsh_util_core.id_tab_type;
1376: l_contact_last_upd_date_tbl wsh_util_core.Date_Tab_Type;
1377:
1378: -- eco 5381528
1379: l_dispatch_loc CONSTANT VARCHAR2(20) := 'DISPATCH LOCATION';

Line 1376: l_contact_last_upd_date_tbl wsh_util_core.Date_Tab_Type;

1372: l_contact_ph_number_tbl wsh_util_core.Column_Tab_Type;
1373: l_contact_email_addr_tbl char500_tab_type;
1374: l_contact_job_title_tbl char500_tab_type;
1375: l_contact_id_tbl wsh_util_core.id_tab_type;
1376: l_contact_last_upd_date_tbl wsh_util_core.Date_Tab_Type;
1377:
1378: -- eco 5381528
1379: l_dispatch_loc CONSTANT VARCHAR2(20) := 'DISPATCH LOCATION';
1380: l_supplier_site_ref_value VARCHAR2(1000);

Line 1594: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1590: --
1591: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
1592: END IF;
1593: --
1594: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1595:
1596: x_loc_xmission_rec := WSH_OTM_LOC_XMISSION_REC_TYPE(NULL, NULL,WSH_OTM_LOCATIONS_TBL_TYPE());
1597: --x_loc_xmission_rec.LOCATIONS_TBL := WSH_OTM_LOCATIONS_TBL_TYPE();
1598:

Line 1609: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;

1605:
1606: IF (l_domain_name is null) THEN
1607: --{
1608: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_DOMAIN_NOT_SET_ERR');
1609: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
1610: wsh_util_core.add_message(x_return_status, l_module_name);
1611: IF l_debug_on THEN
1612: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_DOMAIN_NAME is set to NULL. Please correct the profile value');
1613: END IF;

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

1606: IF (l_domain_name is null) THEN
1607: --{
1608: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_DOMAIN_NOT_SET_ERR');
1609: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
1610: wsh_util_core.add_message(x_return_status, l_module_name);
1611: IF l_debug_on THEN
1612: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_DOMAIN_NAME is set to NULL. Please correct the profile value');
1613: END IF;
1614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1621: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;

1617:
1618: IF (l_country_code is null) THEN
1619: --{
1620: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_CNTR_CODE_NOT_SET_ERR');
1621: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
1622: wsh_util_core.add_message(x_return_status, l_module_name);
1623: IF l_debug_on THEN
1624: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_CORP_COUNTRY_CODE is set to NULL. Please correct the profile value');
1625: END IF;

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

1618: IF (l_country_code is null) THEN
1619: --{
1620: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_CNTR_CODE_NOT_SET_ERR');
1621: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
1622: wsh_util_core.add_message(x_return_status, l_module_name);
1623: IF l_debug_on THEN
1624: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_CORP_COUNTRY_CODE is set to NULL. Please correct the profile value');
1625: END IF;
1626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1678: IF l_debug_on THEN
1679: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1680: WSH_DEBUG_SV.log(l_module_name,'Calling Entity Type from Send_LOcations', p_entity_type);
1681: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
1682: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1683: END IF;
1684: --
1685: wsh_util_core.api_post_call(
1686: p_return_status => l_return_status,

Line 1685: wsh_util_core.api_post_call(

1681: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
1682: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1683: END IF;
1684: --
1685: wsh_util_core.api_post_call(
1686: p_return_status => l_return_status,
1687: x_num_warnings => l_num_warnings,
1688: x_num_errors => l_num_errors);
1689: -- wms-otm-proj if the Call to Send_LOCATIONs is from Entity_type 'ORG_LOC' then

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

1893: --
1894: IF l_debug_on THEN
1895: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1896: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
1897: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1898: END IF;
1899: --
1900: wsh_util_core.api_post_call(
1901: p_return_status => l_return_status,

Line 1900: wsh_util_core.api_post_call(

1896: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
1897: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1898: END IF;
1899: --
1900: wsh_util_core.api_post_call(
1901: p_return_status => l_return_status,
1902: x_num_warnings => l_num_warnings,
1903: x_num_errors => l_num_errors);
1904:

Line 2174: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;

2170: IF (x_loc_xmission_rec.username is null) THEN
2171: --{
2172: FND_MESSAGE.SET_NAME('WSH','WSH_PROFILE_NOT_SET_ERR');
2173: FND_MESSAGE.SET_TOKEN('PRF_NAME','WSH_OTM_USER_ID');
2174: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2175: wsh_util_core.add_message(x_return_status, l_module_name);
2176: IF l_debug_on THEN
2177: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_USER_ID is set to NULL. Please correct the profile value');
2178: END IF;

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

2171: --{
2172: FND_MESSAGE.SET_NAME('WSH','WSH_PROFILE_NOT_SET_ERR');
2173: FND_MESSAGE.SET_TOKEN('PRF_NAME','WSH_OTM_USER_ID');
2174: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2175: wsh_util_core.add_message(x_return_status, l_module_name);
2176: IF l_debug_on THEN
2177: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_USER_ID is set to NULL. Please correct the profile value');
2178: END IF;
2179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2187: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;

2183: IF (x_loc_xmission_rec.password is null) THEN
2184: --{
2185: FND_MESSAGE.SET_NAME('WSH','WSH_PROFILE_NOT_SET_ERR');
2186: FND_MESSAGE.SET_TOKEN('PRF_NAME','WSH_OTM_PASSWORD');
2187: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2188: wsh_util_core.add_message(x_return_status, l_module_name);
2189: IF l_debug_on THEN
2190: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_PASSWORD is set to NULL. Please correct the profile value');
2191: END IF;

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

2184: --{
2185: FND_MESSAGE.SET_NAME('WSH','WSH_PROFILE_NOT_SET_ERR');
2186: FND_MESSAGE.SET_TOKEN('PRF_NAME','WSH_OTM_PASSWORD');
2187: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2188: wsh_util_core.add_message(x_return_status, l_module_name);
2189: IF l_debug_on THEN
2190: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_PASSWORD is set to NULL. Please correct the profile value');
2191: END IF;
2192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2224: --
2225: IF l_debug_on THEN
2226: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling IS_REF_DATA_SEND_REQD is', l_return_status);
2227: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
2228: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2229: END IF;
2230: --
2231: wsh_util_core.api_post_call(
2232: p_return_status => l_return_status,

Line 2231: wsh_util_core.api_post_call(

2227: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
2228: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2229: END IF;
2230: --
2231: wsh_util_core.api_post_call(
2232: p_return_status => l_return_status,
2233: x_num_warnings => l_num_warnings,
2234: x_num_errors => l_num_errors);
2235: */

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

2528: i := i + 1;
2529: --}
2530: END LOOP;
2531: --
2532: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2533: --
2534: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2535: --
2536: ELSE

Line 2534: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2530: END LOOP;
2531: --
2532: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2533: --
2534: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2535: --
2536: ELSE
2537: --
2538: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2538: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2534: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2535: --
2536: ELSE
2537: --
2538: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2539: --
2540: END IF;
2541: --
2542: --}

Line 2553: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2549: --
2550: EXCEPTION
2551: --{
2552: WHEN OTHERS THEN
2553: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2554: --}
2555: --
2556: -- Debug Statements
2557: --

Line 2615: x_return_status := wsh_util_core.g_ret_sts_success;

2611: WSH_DEBUG_SV.push(l_module_name);
2612: WSH_DEBUG_SV.log(l_module_name,'entity type is ', p_entity_in_rec.entity_type);
2613: END IF;
2614: --
2615: x_return_status := wsh_util_core.g_ret_sts_success;
2616:
2617: select WSH_OTM_SYNC_REF_DATA_LOG_S.nextval into l_transmission_id from dual;
2618: --
2619: IF (p_entity_in_rec.entity_type = 'TRIP') THEN

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

2628: --
2629: -- Debug Statements
2630: --
2631: IF l_debug_on THEN
2632: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2633: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_TRIP_INFO is', l_return_status);
2634: END IF;
2635: --
2636: wsh_util_core.api_post_call(

Line 2636: wsh_util_core.api_post_call(

2632: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2633: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_TRIP_INFO is', l_return_status);
2634: END IF;
2635: --
2636: wsh_util_core.api_post_call(
2637: p_return_status => l_return_status,
2638: x_num_warnings => l_num_warnings,
2639: x_num_errors => l_num_errors);
2640:

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

2652: --
2653: -- Debug Statements
2654: --
2655: IF l_debug_on THEN
2656: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2657: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_TRIP_INFO is', l_return_status);
2658: END IF;
2659: --
2660: wsh_util_core.api_post_call(

Line 2660: wsh_util_core.api_post_call(

2656: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2657: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_TRIP_INFO is', l_return_status);
2658: END IF;
2659: --
2660: wsh_util_core.api_post_call(
2661: p_return_status => l_return_status,
2662: x_num_warnings => l_num_warnings,
2663: x_num_errors => l_num_errors);
2664:

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

2679: -- Debug Statements
2680: --
2681: IF l_debug_on THEN
2682: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling VALIDATE_TKT is', l_return_status);
2683: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2684: END IF;
2685: --
2686: wsh_util_core.api_post_call(
2687: p_return_status => l_return_status,

Line 2686: wsh_util_core.api_post_call(

2682: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling VALIDATE_TKT is', l_return_status);
2683: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2684: END IF;
2685: --
2686: wsh_util_core.api_post_call(
2687: p_return_status => l_return_status,
2688: x_num_warnings => l_num_warnings,
2689: x_num_errors => l_num_errors);
2690:

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

2699: --
2700: -- Debug Statements
2701: --
2702: IF l_debug_on THEN
2703: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2704: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_CARRIER_INFO is', l_return_status);
2705: END IF;
2706: --
2707: wsh_util_core.api_post_call(

Line 2707: wsh_util_core.api_post_call(

2703: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2704: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_CARRIER_INFO is', l_return_status);
2705: END IF;
2706: --
2707: wsh_util_core.api_post_call(
2708: p_return_status => l_return_status,
2709: x_num_warnings => l_num_warnings,
2710: x_num_errors => l_num_errors);
2711:

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

2727: -- Debug Statements
2728: --
2729: IF l_debug_on THEN
2730: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling VALIDATE_TKT is', l_return_status);
2731: WSH_DEBUG_SV.logmsg(l_module_name,'calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2732: END IF;
2733: --
2734: wsh_util_core.api_post_call(
2735: p_return_status => l_return_status,

Line 2734: wsh_util_core.api_post_call(

2730: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling VALIDATE_TKT is', l_return_status);
2731: WSH_DEBUG_SV.logmsg(l_module_name,'calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2732: END IF;
2733: --
2734: wsh_util_core.api_post_call(
2735: p_return_status => l_return_status,
2736: x_num_warnings => l_num_warnings,
2737: x_num_errors => l_num_errors);
2738:

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

2747: --
2748: -- Debug Statements
2749: --
2750: IF l_debug_on THEN
2751: WSH_DEBUG_SV.logmsg(l_module_name,'OrgAfterCalling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2752: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_ORG_INFO is', l_return_status);
2753: END IF;
2754: --
2755: wsh_util_core.api_post_call(

Line 2755: wsh_util_core.api_post_call(

2751: WSH_DEBUG_SV.logmsg(l_module_name,'OrgAfterCalling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2752: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_ORG_INFO is', l_return_status);
2753: END IF;
2754: --
2755: wsh_util_core.api_post_call(
2756: p_return_status => l_return_status,
2757: x_num_warnings => l_num_warnings,
2758: x_num_errors => l_num_errors);
2759:

Line 2765: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;

2761: ELSE
2762: --{
2763: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_INVALID_ENTITY');
2764: FND_MESSAGE.SET_TOKEN('ENTITY',p_entity_in_rec.entity_type);
2765: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2766: wsh_util_core.add_message(x_return_status, l_module_name);
2767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2768: --}
2769: END IF;

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

2762: --{
2763: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_INVALID_ENTITY');
2764: FND_MESSAGE.SET_TOKEN('ENTITY',p_entity_in_rec.entity_type);
2765: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2766: wsh_util_core.add_message(x_return_status, l_module_name);
2767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2768: --}
2769: END IF;
2770:

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

2784: --
2785: IF l_debug_on THEN
2786: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_LOCATION_INFO is', l_return_status);
2787: WSH_DEBUG_SV.log(l_module_name,'Number of records finally being sent to GC3 is',x_loc_xmission_rec.LOCATIONS_TBL.count);
2788: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2789: END IF;
2790: --
2791: wsh_util_core.api_post_call(
2792: p_return_status => l_return_status,

Line 2791: wsh_util_core.api_post_call(

2787: WSH_DEBUG_SV.log(l_module_name,'Number of records finally being sent to GC3 is',x_loc_xmission_rec.LOCATIONS_TBL.count);
2788: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2789: END IF;
2790: --
2791: wsh_util_core.api_post_call(
2792: p_return_status => l_return_status,
2793: x_num_warnings => l_num_warnings,
2794: x_num_errors => l_num_errors);
2795:

Line 2796: WSH_UTIL_CORE.Get_Messages

2792: p_return_status => l_return_status,
2793: x_num_warnings => l_num_warnings,
2794: x_num_errors => l_num_errors);
2795:
2796: WSH_UTIL_CORE.Get_Messages
2797: (
2798: p_init_msg_list => 'T',
2799: x_summary => l_summary,
2800: x_details => l_details,

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

2807: x_transmission_id := l_transmission_id;
2808: END IF;
2809:
2810:
2811: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2812: --
2813: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2814: --
2815: ELSE

Line 2813: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2809:
2810:
2811: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2812: --
2813: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2814: --
2815: ELSE
2816: --
2817: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2817: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2813: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2814: --
2815: ELSE
2816: --
2817: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2818: --
2819: END IF;
2820:
2821: --

Line 2832: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2828: --}
2829: EXCEPTION
2830: --{
2831: WHEN FND_API.G_EXC_ERROR THEN
2832: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2833: --
2834: -- Debug Statements
2835: --
2836: WSH_UTIL_CORE.Get_Messages

Line 2836: WSH_UTIL_CORE.Get_Messages

2832: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2833: --
2834: -- Debug Statements
2835: --
2836: WSH_UTIL_CORE.Get_Messages
2837: (
2838: p_init_msg_list => 'T',
2839: x_summary => l_summary,
2840: x_details => l_details,

Line 2852: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

2848: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2849: END IF;
2850: --
2851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2852: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2853: --
2854: WSH_UTIL_CORE.Get_Messages
2855: (
2856: p_init_msg_list => 'T',

Line 2854: WSH_UTIL_CORE.Get_Messages

2850: --
2851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2852: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2853: --
2854: WSH_UTIL_CORE.Get_Messages
2855: (
2856: p_init_msg_list => 'T',
2857: x_summary => l_summary,
2858: x_details => l_details,

Line 2873: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2869: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2870: END IF;
2871: --
2872: WHEN OTHERS THEN
2873: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2874: --
2875: WSH_UTIL_CORE.Get_Messages
2876: (
2877: p_init_msg_list => 'T',

Line 2875: WSH_UTIL_CORE.Get_Messages

2871: --
2872: WHEN OTHERS THEN
2873: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
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 3020: x_return_status := wsh_util_core.G_RET_STS_SUCCESS;

3016: WSH_DEBUG_SV.log(l_module_name,'p_ticket',p_ticket);
3017: END IF;
3018: --
3019: x_tkt_valid := 'F';
3020: x_return_status := wsh_util_core.G_RET_STS_SUCCESS;
3021:
3022: IF l_debug_on THEN
3023: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FND_HTTP_TICKET.CHECK_TICKET',WSH_DEBUG_SV.C_PROC_LEVEL);
3024: END IF;

Line 3056: x_return_status := wsh_util_core.G_RET_STS_ERROR;

3052: END IF;
3053: x_tkt_valid := 'F';
3054: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_INVALID_TKT');
3055: FND_MESSAGE.SET_TOKEN('TICKET',p_ticket);
3056: x_return_status := wsh_util_core.G_RET_STS_ERROR;
3057: x_msg_data :=FND_MESSAGE.GET;
3058: --}
3059: END IF;
3060: --

Line 3072: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3068: EXCEPTION
3069: --{
3070: WHEN OTHERS THEN
3071: --
3072: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3073: x_tkt_valid := 'F';
3074: x_msg_data := SQLERRM;
3075:
3076: --

Line 3132: x_return_status := wsh_util_core.g_ret_sts_success;

3128: --
3129: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
3130: END IF;
3131: --
3132: x_return_status := wsh_util_core.g_ret_sts_success;
3133: --
3134: WSH_LOCATIONS_PKG.Convert_internal_cust_location(
3135: p_internal_cust_location_id => p_location_id,
3136: x_internal_org_location_id => l_int_location_id,

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

3140: --
3141: IF l_debug_on THEN
3142: WSH_DEBUG_SV.log(l_module_name,'l_return_status after calling Convert_internal_cust_location',l_return_status);
3143: WSH_DEBUG_SV.log(l_module_name,'l_int_location_id',l_int_location_id);
3144: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3145: END IF;
3146: --
3147: wsh_util_core.api_post_call(
3148: p_return_status => l_return_status,

Line 3147: wsh_util_core.api_post_call(

3143: WSH_DEBUG_SV.log(l_module_name,'l_int_location_id',l_int_location_id);
3144: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3145: END IF;
3146: --
3147: wsh_util_core.api_post_call(
3148: p_return_status => l_return_status,
3149: x_num_warnings => l_num_warnings,
3150: x_num_errors => l_num_errors);
3151:

Line 3186: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3182: EXCEPTION
3183: --{
3184: WHEN FND_API.G_EXC_ERROR THEN
3185: --
3186: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3187: --
3188:
3189: IF l_debug_on THEN
3190: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 3196: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

3192: END IF;
3193: --
3194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3195: --
3196: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3197: --
3198: -- Debug Statements
3199: --
3200: IF l_debug_on THEN

Line 3207: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3203: END IF;
3204: --
3205: WHEN OTHERS THEN
3206: --
3207: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3208: --
3209: -- Debug Statements
3210: --
3211: IF l_debug_on THEN