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_WF_STD dependencies on WSH_UTIL_CORE

Line 107: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success

103: --
104: -- x_process_started - 'Y' Process started;
105: -- 'E' Process already exists
106: -- 'N' Process not started
107: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
108:
109: -- Description: This Procedure selects and starts a Tracking Workflow process
110: -- for an entity - Trip/Delivery after checking if it is eligible.
111: -- i.e.1) No Process exists already for the Entity

Line 173: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;

169: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',p_organization_id);
170: END IF;
171:
172: x_process_started := 'N';
173: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;
174: SAVEPOINT START_WF_PROCESS_UPDATE;
175:
176: IF l_debug_on THEN
177: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.CHECK_WF_EXISTS',

Line 191: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

187: WSH_DEBUG_SV.log(l_module_name,'l_wf_process_exists',l_wf_process_exists);
188: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
189: END IF;
190:
191: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
192: x_return_status := l_return_status;
193: IF l_debug_on THEN
194: WSH_DEBUG_SV.pop(l_module_name);
195: END IF;

Line 221: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

217: WSH_DEBUG_SV.log(l_module_name,'l_start_wf_process',l_start_wf_process);
218: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
219: END IF;
220:
221: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
222: x_return_status := l_return_status;
223: IF l_debug_on THEN
224: WSH_DEBUG_SV.pop(l_module_name);
225: END IF;

Line 254: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

250: WSH_DEBUG_SV.log(l_module_name,'l_process_name',l_process_name);
251: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
252: END IF;
253:
254: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
255: x_return_status := l_return_status;
256: IF l_debug_on THEN
257: WSH_DEBUG_SV.pop(l_module_name);
258: END IF;

Line 350: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

346:
347:
348: EXCEPTION
349: WHEN no_data_found THEN
350: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
351: IF l_debug_on THEN
352: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for the entity.Oracle error message is '||
353: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
354: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');

Line 357: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

353: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
354: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
355: END IF;
356: WHEN others THEN
357: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
358: IF l_debug_on THEN
359: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
360: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
361: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 374: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success

370: --
371: -- x_process_started - 'Y' Process started;
372: -- 'E' Process already exists
373: -- 'N' Process not started
374: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
375: --
376: -- Description: This Procedure starts the 'Ship to Deliver' controlling
377: -- Workflow process for the Delivery after checking
378: -- if it is eligible.

Line 452: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

448:
449: l_itemtype := 'WSHDEL';
450: l_itemkey := p_entity_id;
451: x_process_started := 'N';
452: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
453:
454: l_override_wf:= fnd_profile.value('WSH_OVERRIDE_SCPOD_WF');
455: IF l_debug_on THEN
456: WSH_DEBUG_SV.log(l_module_name,'L_OVERRIDE_WF',l_override_wf);

Line 480: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

476: WSH_DEBUG_SV.log(l_module_name,'L_SCPOD_WF_PROCESS_EXISTS',l_scpod_wf_process_exists);
477: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
478: END IF;
479:
480: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
481: x_return_status := l_return_status;
482: IF l_debug_on THEN
483: WSH_DEBUG_SV.pop(l_module_name);
484: END IF;

Line 509: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

505: IF l_debug_on THEN
506: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
507: END IF;
508:
509: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
510: x_return_status := l_return_status;
511: IF l_debug_on THEN
512: WSH_DEBUG_SV.pop(l_module_name);
513: END IF;

Line 529: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

525: IF l_debug_on THEN
526: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
527: END IF;
528:
529: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
530: x_return_status := l_return_status;
531: IF l_debug_on THEN
532: WSH_DEBUG_SV.pop(l_module_name);
533: END IF;

Line 557: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

553: WSH_DEBUG_SV.log(l_module_name,'l_custom_process_name',l_custom_process_name);
554: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
555: END IF;
556:
557: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
558: x_return_status := l_return_status;
559: IF l_debug_on THEN
560: WSH_DEBUG_SV.pop(l_module_name);
561: END IF;

Line 629: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

625: p_logging_entity => 'SHIPPER',
626: p_exception_name => 'WSH_LAUNCH_WF_FAILED',
627: x_return_status => l_return_status);
628:
629: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
630: IF l_debug_on THEN
631: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
632: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
633: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 645: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success

641: -- p_entity_id - TRIP_ID or DELIVERY_ID
642: -- p_organization_id - The Organization Id
643: --
644: -- x_wf_process - Returns the process selected for the Entity
645: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
646: --
647: -- Description: This Procedure selects the process for the entities based on the
648: -- various criteria
649: -- Delivery:

Line 736: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;

732: -- l_screening_req := 'N';
733: -- l_tpw_org := 'N';
734: -- l_picking_req := 'N';
735:
736: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;
737: -- CHECK IF FTE INSTALLED
738: IF (WSH_UTIL_CORE.FTE_IS_INSTALLED = 'Y') THEN
739: l_fte_installed := 'Y';
740: END IF;

Line 738: IF (WSH_UTIL_CORE.FTE_IS_INSTALLED = 'Y') THEN

734: -- l_picking_req := 'N';
735:
736: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;
737: -- CHECK IF FTE INSTALLED
738: IF (WSH_UTIL_CORE.FTE_IS_INSTALLED = 'Y') THEN
739: l_fte_installed := 'Y';
740: END IF;
741:
742: IF (p_entity_type = 'TRIP') THEN

Line 783: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

779: IF l_debug_on THEN
780: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
781: END IF;
782:
783: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
784: x_return_status := l_return_status;
785: IF l_debug_on THEN
786: WSH_DEBUG_SV.pop(l_module_name);
787: END IF;

Line 812: IF ( l_return_status <> WSH_UTIL_CORE.g_ret_sts_success) THEN

808: IF l_debug_on THEN
809: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
810: END IF;
811:
812: IF ( l_return_status <> WSH_UTIL_CORE.g_ret_sts_success) THEN
813: raise e_invalid_org; -- the api returns error when no org id is sent; unexp error
814: END IF;
815: -- TPW - Distributed Organization Changes
816: -- Arcsing the file in R12.0 branchline even though this project is done in 12.1 branch

Line 901: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

897: WSH_DEBUG_SV.log(l_module_name,'l_custom_process_name',l_custom_process_name);
898: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
899: END IF;
900:
901: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
902: x_return_status := l_return_status;
903: IF l_debug_on THEN
904: WSH_DEBUG_SV.pop(l_module_name);
905: END IF;

Line 917: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

913:
914:
915: EXCEPTION
916: WHEN e_invalid_org THEN
917: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
918: IF l_debug_on THEN
919: WSH_DEBUG_SV.logmsg(l_module_name,'Invalid Organization Id passed',WSH_DEBUG_SV.C_EXCEP_LEVEL);
920: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_INVALID_ORG');
921: END IF;

Line 923: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

919: WSH_DEBUG_SV.logmsg(l_module_name,'Invalid Organization Id passed',WSH_DEBUG_SV.C_EXCEP_LEVEL);
920: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_INVALID_ORG');
921: END IF;
922: WHEN e_process_not_found THEN
923: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
924: IF l_debug_on THEN
925: WSH_DEBUG_SV.logmsg(l_module_name,'Process not found for the current Setup parameters',
926: WSH_DEBUG_SV.C_EXCEP_LEVEL);
927: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_PROCESS_NOT_FOUND');

Line 930: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

926: WSH_DEBUG_SV.C_EXCEP_LEVEL);
927: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_PROCESS_NOT_FOUND');
928: END IF;
929: WHEN others THEN
930: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
931: IF l_debug_on THEN
932: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
933: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
934: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 951: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success

947: -- p_send_date - Optional date to indicate when the event should
948: -- become available for subscription processing.
949: -- p_organization_id - The Organization Id
950: --
951: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
952: --
953: -- Description: This Procedure raises the event in the following scenario
954: -- 1) If a Process already exists for this Entity
955: -- 2) If no process exists, checks the Global and Shipping parameters

Line 1003: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

999: WSH_DEBUG_SV.log(l_module_name,'P_SEND_DATE',p_send_date);
1000: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',p_organization_id);
1001: END IF;
1002:
1003: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1004: l_raise_event := FALSE;
1005:
1006: IF (p_entity_type IN ('DELIVERY','LINE') AND p_organization_id IS NULL ) THEN
1007: raise e_org_required;

Line 1028: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1024: WSH_DEBUG_SV.log(l_module_name,'l_wf_process_exists',l_wf_process_exists);
1025: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1026: END IF;
1027:
1028: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1029: x_return_status := l_return_status;
1030: IF l_debug_on THEN
1031: WSH_DEBUG_SV.pop(l_module_name);
1032: END IF;

Line 1055: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1051: IF l_debug_on THEN
1052: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1053: END IF;
1054:
1055: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1056: x_return_status := l_return_status;
1057: IF l_debug_on THEN
1058: WSH_DEBUG_SV.pop(l_module_name);
1059: END IF;

Line 1085: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1081: IF l_debug_on THEN
1082: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1083: END IF;
1084:
1085: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1086: x_return_status := l_return_status;
1087: IF l_debug_on THEN
1088: WSH_DEBUG_SV.pop(l_module_name);
1089: END IF;

Line 1134: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

1130: END IF;
1131:
1132: EXCEPTION
1133: WHEN e_org_required THEN
1134: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1135: IF l_debug_on THEN
1136: WSH_DEBUG_SV.logmsg(l_module_name,'Organization Id Required.Oracle error message is '||
1137: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1138: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_ORG_REQUIRED');

Line 1142: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1138: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_ORG_REQUIRED');
1139: END IF;
1140:
1141: WHEN others THEN
1142: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1143: IF l_debug_on THEN
1144: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1145: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1146: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1157: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success

1153: -- Parameters: p_entity_type - 'TRIP','DELIVERY'
1154: -- p_organization_id - The Organization Id
1155: --
1156: -- x_start_wf_process - Returns 'Y' if process can be started, else 'N'
1157: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
1158: --
1159: -- Description: This Procedure obtains the Global and Shipping parameter
1160: -- values for 'Enable Tracking Workflows' and determines
1161: -- if a process can be started by,

Line 1210: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1206: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',p_organization_id);
1207: END IF;
1208:
1209: x_start_wf_process := 'N';
1210: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1211:
1212: -- Get Global and Shipping event parameters and raise event accordingly
1213:
1214: IF (p_entity_type <> 'TRIP') THEN

Line 1229: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1225: IF l_debug_on THEN
1226: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1227: END IF;
1228:
1229: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1230: x_return_status := l_return_status;
1231: IF l_debug_on THEN
1232: WSH_DEBUG_SV.pop(l_module_name);
1233: END IF;

Line 1253: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1249: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1250: END IF;
1251:
1252:
1253: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1254: x_return_status := l_return_status;
1255: IF l_debug_on THEN
1256: WSH_DEBUG_SV.pop(l_module_name);
1257: END IF;

Line 1290: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1286: END IF;
1287:
1288: EXCEPTION
1289: WHEN others THEN
1290: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1291: IF l_debug_on THEN
1292: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1293: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1294: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1305: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success

1301: -- p_entity_id - TRIP_ID or DELIVERY_ID
1302: --
1303: -- x_wf_process_exists - Returns 'Y' if Wf exists, else 'N'
1304: -- IF DELIVERY_C then returns 'Y' only if Cntll wf exists
1305: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
1306: --
1307: -- Description: This Procedure checks from WSH_NEW_DELIVERIES or WSH_TRIPS
1308: -- if a workflow process has been started for this entity.
1309: ---------------------------------------------------------------------------------------

Line 1350: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1346: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE',p_entity_type);
1347: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',p_entity_id);
1348: END IF;
1349:
1350: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1351:
1352: -- Get the Process name from Entity Tables
1353: IF (p_entity_type = 'TRIP') THEN
1354: OPEN get_trip_wf_name(p_entity_id);

Line 1389: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

1385: END IF;
1386:
1387: EXCEPTION
1388: WHEN e_invalid_type THEN
1389: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1390: IF l_debug_on THEN
1391: WSH_DEBUG_SV.logmsg(l_module_name,'Invalid Entity type passed.Oracle error message is '||
1392: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1393: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_INVALID_TYPE');

Line 1396: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

1392: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1393: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_INVALID_TYPE');
1394: END IF;
1395: WHEN no_data_found THEN
1396: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1397: IF l_debug_on THEN
1398: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for the entity.Oracle error message is '||
1399: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1400: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');

Line 1403: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1399: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1400: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
1401: END IF;
1402: WHEN others THEN
1403: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1404: IF l_debug_on THEN
1405: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1406: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1407: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1437: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success

1433: -- p_org_code - The organization code
1434: --
1435: -- x_wf_process - Returns the custom process name specified
1436: -- with the lookups else the orginial process
1437: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
1438: --
1439: -- Description: This Procedure queries from the WSH_LOOKUPS for any custom
1440: -- process name specified by the User through the lookups for
1441: -- a particular process else returns the original process

Line 1484: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1480: WSH_DEBUG_SV.log(l_module_name,'P_WF_PROCESS',p_wf_process);
1481: WSH_DEBUG_SV.log(l_module_name,'P_ORG_CODE',p_org_code);
1482: END IF;
1483:
1484: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1485:
1486: OPEN get_custom_process;
1487: FETCH get_custom_process into l_custom_process;
1488:

Line 1510: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1506: END IF;
1507:
1508: EXCEPTION
1509: WHEN others THEN
1510: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1511: IF l_debug_on THEN
1512: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.
1513: Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1514: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1526: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success

1522: -- p_docommit - Specify TRUE/FALSE to indicate whether
1523: -- to commit data while purging.
1524: --
1525: -- x_purged_count - No. of entities successfully purged/closed
1526: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
1527: --
1528: -- Description: This Procedure finds out the Item status for every entity id.
1529: -- If it is complete then purges it, if not complete aborts the process
1530: -- and then purges the item.

Line 1535: p_entity_ids IN WSH_UTIL_CORE.column_tab_type,

1531: -- If p_action is CLOSE alone then aborts the process if not completed.
1532: ---------------------------------------------------------------------------------------
1533: Procedure Purge_Entity(
1534: p_entity_type IN VARCHAR2,
1535: p_entity_ids IN WSH_UTIL_CORE.column_tab_type,
1536: p_action IN VARCHAR2 DEFAULT 'PURGE',
1537: p_docommit IN BOOLEAN DEFAULT FALSE,
1538: x_success_count OUT NOCOPY NUMBER,
1539: x_return_status OUT NOCOPY VARCHAR2) IS

Line 1545: l_suc_entity_ids WSH_UTIL_CORE.column_tab_type;

1541: l_wf_status VARCHAR2(30); -- COMPLETE/ERROR/SUSPENDED
1542: l_result VARCHAR2(30);
1543: l_itemtype VARCHAR2(30);
1544:
1545: l_suc_entity_ids WSH_UTIL_CORE.column_tab_type;
1546:
1547: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'PURGE_ENTITY';
1548: l_debug_on BOOLEAN;
1549:

Line 1568: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1564: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',p_action);
1565: WSH_DEBUG_SV.log(l_module_name,'P_DOCOMMIT',p_docommit);
1566: END IF;
1567:
1568: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1569: SAVEPOINT PURGE_ENTITY_UPDATE;
1570:
1571: IF (p_entity_type = 'TRIP') THEN
1572: l_itemtype := 'WSHTRIP';

Line 1640: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

1636:
1637: x_success_count := l_suc_entity_ids.count;
1638: /*
1639: IF (l_suc_entity_ids.count = 0) THEN
1640: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1641: ELSIF (p_entity_ids.count <> l_suc_entity_ids.count) THEN
1642: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;
1643: ELSIF (p_entity_ids.count = l_suc_entity_ids.count) THEN
1644: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1642: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;

1638: /*
1639: IF (l_suc_entity_ids.count = 0) THEN
1640: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1641: ELSIF (p_entity_ids.count <> l_suc_entity_ids.count) THEN
1642: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;
1643: ELSIF (p_entity_ids.count = l_suc_entity_ids.count) THEN
1644: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1645: END IF;
1646: */

Line 1644: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1640: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1641: ELSIF (p_entity_ids.count <> l_suc_entity_ids.count) THEN
1642: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;
1643: ELSIF (p_entity_ids.count = l_suc_entity_ids.count) THEN
1644: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1645: END IF;
1646: */
1647: IF l_debug_on THEN
1648: WSH_DEBUG_SV.pop(l_module_name);

Line 1654: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1650:
1651:
1652: EXCEPTION
1653: WHEN others THEN
1654: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1655: IF l_debug_on THEN
1656: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1657: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1658: END IF;

Line 1672: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success

1668: -- p_ship_from_location_id - The Ship from Location Id
1669: -- p_exception_name WSH_LAUNCH_WF_FAILED
1670: -- WSH_DEL_SCPOD_PURGED
1671: --
1672: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
1673: --
1674: -- Description: This Procedure logs an exception against the specified Entity
1675: --
1676: --

Line 1765: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1761:
1762:
1763: EXCEPTION
1764: WHEN others THEN
1765: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1766: IF l_debug_on THEN
1767: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1768: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1769: END IF;

Line 2276: PROCEDURE Get_Carrier(p_del_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,

2272:
2273: END RESET_APPS_CONTEXT_OFF;
2274:
2275: /* CURRENTLY NOT IN USE
2276: PROCEDURE Get_Carrier(p_del_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
2277: x_del_old_carrier_ids OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
2278: x_return_status OUT NOCOPY VARCHAR2) IS
2279:
2280: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_CARRIER';

Line 2277: x_del_old_carrier_ids OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,

2273: END RESET_APPS_CONTEXT_OFF;
2274:
2275: /* CURRENTLY NOT IN USE
2276: PROCEDURE Get_Carrier(p_del_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
2277: x_del_old_carrier_ids OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
2278: x_return_status OUT NOCOPY VARCHAR2) IS
2279:
2280: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_CARRIER';
2281: l_debug_on BOOLEAN;

Line 2309: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2305: l_return_status VARCHAR2(1);
2306:
2307: BEGIN
2308:
2309: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2310: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2311:
2312: IF l_debug_on IS NULL THEN
2313: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

Line 2338: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

2334: END LOOP;
2335:
2336: EXCEPTION
2337: WHEN OTHERS THEN
2338: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2339: wsh_util_core.default_handler('WSH_WF_STD.GET_CARRIER');
2340: IF l_debug_on THEN
2341: --{
2342: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2339: wsh_util_core.default_handler('WSH_WF_STD.GET_CARRIER');

2335:
2336: EXCEPTION
2337: WHEN OTHERS THEN
2338: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2339: wsh_util_core.default_handler('WSH_WF_STD.GET_CARRIER');
2340: IF l_debug_on THEN
2341: --{
2342: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2343: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2349: p_del_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,

2345: END IF;
2346: END Get_Carrier;
2347:
2348: PROCEDURE Handle_Trip_Carriers(p_trip_id IN NUMBER,
2349: p_del_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
2350: p_del_old_carrier_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
2351: x_return_status OUT NOCOPY VARCHAR2) IS
2352:
2353: l_del_new_carrier_ids WSH_UTIL_CORE.ID_TAB_TYPE;

Line 2350: p_del_old_carrier_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,

2346: END Get_Carrier;
2347:
2348: PROCEDURE Handle_Trip_Carriers(p_trip_id IN NUMBER,
2349: p_del_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
2350: p_del_old_carrier_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
2351: x_return_status OUT NOCOPY VARCHAR2) IS
2352:
2353: l_del_new_carrier_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2354: l_return_status VARCHAR2(1);

Line 2353: l_del_new_carrier_ids WSH_UTIL_CORE.ID_TAB_TYPE;

2349: p_del_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
2350: p_del_old_carrier_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
2351: x_return_status OUT NOCOPY VARCHAR2) IS
2352:
2353: l_del_new_carrier_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2354: l_return_status VARCHAR2(1);
2355:
2356: BEGIN
2357:

Line 2403: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2399: l_carrier_name VARCHAR2(360);
2400:
2401: BEGIN
2402:
2403: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2404:
2405: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2406:
2407: IF l_debug_on IS NULL THEN

Line 2470: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

2466: END IF; --Check for Delivery Workflow Name.
2467:
2468: EXCEPTION
2469: WHEN OTHERS THEN
2470: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2471: wsh_util_core.default_handler('WSH_WF_STD.Assign_Unassign_Carrier');
2472: IF l_debug_on THEN
2473: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2474: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2471: wsh_util_core.default_handler('WSH_WF_STD.Assign_Unassign_Carrier');

2467:
2468: EXCEPTION
2469: WHEN OTHERS THEN
2470: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2471: wsh_util_core.default_handler('WSH_WF_STD.Assign_Unassign_Carrier');
2472: IF l_debug_on THEN
2473: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2474: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2475: END IF;

Line 2480: x_del_ids OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,

2476: END Assign_Unassign_Carrier;
2477:
2478:
2479: PROCEDURE Get_Deliveries(p_trip_id IN NUMBER,
2480: x_del_ids OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
2481: x_return_status OUT NOCOPY VARCHAR2) IS
2482:
2483: CURSOR c_dels(p_trip_id IN NUMBER) IS
2484: SELECT