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: IF ( nvl(l_wh_type,'@') = 'TPW') THEN
816: -- l_tpw_org := 'Y';

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

891: WSH_DEBUG_SV.log(l_module_name,'l_custom_process_name',l_custom_process_name);
892: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
893: END IF;
894:
895: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
896: x_return_status := l_return_status;
897: IF l_debug_on THEN
898: WSH_DEBUG_SV.pop(l_module_name);
899: END IF;

Line 911: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

907:
908:
909: EXCEPTION
910: WHEN e_invalid_org THEN
911: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
912: IF l_debug_on THEN
913: WSH_DEBUG_SV.logmsg(l_module_name,'Invalid Organization Id passed',WSH_DEBUG_SV.C_EXCEP_LEVEL);
914: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_INVALID_ORG');
915: END IF;

Line 917: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

913: WSH_DEBUG_SV.logmsg(l_module_name,'Invalid Organization Id passed',WSH_DEBUG_SV.C_EXCEP_LEVEL);
914: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_INVALID_ORG');
915: END IF;
916: WHEN e_process_not_found 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,'Process not found for the current Setup parameters',
920: WSH_DEBUG_SV.C_EXCEP_LEVEL);
921: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_PROCESS_NOT_FOUND');

Line 924: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

920: WSH_DEBUG_SV.C_EXCEP_LEVEL);
921: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_PROCESS_NOT_FOUND');
922: END IF;
923: WHEN others THEN
924: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
925: IF l_debug_on THEN
926: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
927: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
928: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

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

Line 997: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

993: WSH_DEBUG_SV.log(l_module_name,'P_SEND_DATE',p_send_date);
994: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',p_organization_id);
995: END IF;
996:
997: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
998: l_raise_event := FALSE;
999:
1000: IF (p_entity_type IN ('DELIVERY','LINE') AND p_organization_id IS NULL ) THEN
1001: raise e_org_required;

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

1018: WSH_DEBUG_SV.log(l_module_name,'l_wf_process_exists',l_wf_process_exists);
1019: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1020: END IF;
1021:
1022: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1023: x_return_status := l_return_status;
1024: IF l_debug_on THEN
1025: WSH_DEBUG_SV.pop(l_module_name);
1026: END IF;

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

1045: IF l_debug_on THEN
1046: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1047: END IF;
1048:
1049: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1050: x_return_status := l_return_status;
1051: IF l_debug_on THEN
1052: WSH_DEBUG_SV.pop(l_module_name);
1053: END IF;

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

1075: IF l_debug_on THEN
1076: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1077: END IF;
1078:
1079: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1080: x_return_status := l_return_status;
1081: IF l_debug_on THEN
1082: WSH_DEBUG_SV.pop(l_module_name);
1083: END IF;

Line 1128: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

1124: END IF;
1125:
1126: EXCEPTION
1127: WHEN e_org_required THEN
1128: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1129: IF l_debug_on THEN
1130: WSH_DEBUG_SV.logmsg(l_module_name,'Organization Id Required.Oracle error message is '||
1131: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1132: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_ORG_REQUIRED');

Line 1136: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1132: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_ORG_REQUIRED');
1133: END IF;
1134:
1135: WHEN others THEN
1136: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1137: IF l_debug_on THEN
1138: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1139: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1140: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

1147: -- Parameters: p_entity_type - 'TRIP','DELIVERY'
1148: -- p_organization_id - The Organization Id
1149: --
1150: -- x_start_wf_process - Returns 'Y' if process can be started, else 'N'
1151: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
1152: --
1153: -- Description: This Procedure obtains the Global and Shipping parameter
1154: -- values for 'Enable Tracking Workflows' and determines
1155: -- if a process can be started by,

Line 1204: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1200: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',p_organization_id);
1201: END IF;
1202:
1203: x_start_wf_process := 'N';
1204: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1205:
1206: -- Get Global and Shipping event parameters and raise event accordingly
1207:
1208: IF (p_entity_type <> 'TRIP') THEN

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

1219: IF l_debug_on THEN
1220: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1221: END IF;
1222:
1223: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1224: x_return_status := l_return_status;
1225: IF l_debug_on THEN
1226: WSH_DEBUG_SV.pop(l_module_name);
1227: END IF;

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

1243: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1244: END IF;
1245:
1246:
1247: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1248: x_return_status := l_return_status;
1249: IF l_debug_on THEN
1250: WSH_DEBUG_SV.pop(l_module_name);
1251: END IF;

Line 1284: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1280: END IF;
1281:
1282: EXCEPTION
1283: WHEN others THEN
1284: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1285: IF l_debug_on THEN
1286: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1287: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1288: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

1295: -- p_entity_id - TRIP_ID or DELIVERY_ID
1296: --
1297: -- x_wf_process_exists - Returns 'Y' if Wf exists, else 'N'
1298: -- IF DELIVERY_C then returns 'Y' only if Cntll wf exists
1299: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
1300: --
1301: -- Description: This Procedure checks from WSH_NEW_DELIVERIES or WSH_TRIPS
1302: -- if a workflow process has been started for this entity.
1303: ---------------------------------------------------------------------------------------

Line 1344: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1340: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE',p_entity_type);
1341: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',p_entity_id);
1342: END IF;
1343:
1344: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1345:
1346: -- Get the Process name from Entity Tables
1347: IF (p_entity_type = 'TRIP') THEN
1348: OPEN get_trip_wf_name(p_entity_id);

Line 1383: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

1379: END IF;
1380:
1381: EXCEPTION
1382: WHEN e_invalid_type THEN
1383: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1384: IF l_debug_on THEN
1385: WSH_DEBUG_SV.logmsg(l_module_name,'Invalid Entity type passed.Oracle error message is '||
1386: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1387: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_INVALID_TYPE');

Line 1390: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

1386: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1387: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_INVALID_TYPE');
1388: END IF;
1389: WHEN no_data_found THEN
1390: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1391: IF l_debug_on THEN
1392: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for the entity.Oracle error message is '||
1393: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1394: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');

Line 1397: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1393: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1394: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
1395: END IF;
1396: WHEN others THEN
1397: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1398: IF l_debug_on THEN
1399: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1400: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1401: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

1427: -- p_org_code - The organization code
1428: --
1429: -- x_wf_process - Returns the custom process name specified
1430: -- with the lookups else the orginial process
1431: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
1432: --
1433: -- Description: This Procedure queries from the WSH_LOOKUPS for any custom
1434: -- process name specified by the User through the lookups for
1435: -- a particular process else returns the original process

Line 1478: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1474: WSH_DEBUG_SV.log(l_module_name,'P_WF_PROCESS',p_wf_process);
1475: WSH_DEBUG_SV.log(l_module_name,'P_ORG_CODE',p_org_code);
1476: END IF;
1477:
1478: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1479:
1480: OPEN get_custom_process;
1481: FETCH get_custom_process into l_custom_process;
1482:

Line 1504: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1500: END IF;
1501:
1502: EXCEPTION
1503: WHEN others THEN
1504: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1505: IF l_debug_on THEN
1506: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.
1507: Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1508: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

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

Line 1529: p_entity_ids IN WSH_UTIL_CORE.column_tab_type,

1525: -- If p_action is CLOSE alone then aborts the process if not completed.
1526: ---------------------------------------------------------------------------------------
1527: Procedure Purge_Entity(
1528: p_entity_type IN VARCHAR2,
1529: p_entity_ids IN WSH_UTIL_CORE.column_tab_type,
1530: p_action IN VARCHAR2 DEFAULT 'PURGE',
1531: p_docommit IN BOOLEAN DEFAULT FALSE,
1532: x_success_count OUT NOCOPY NUMBER,
1533: x_return_status OUT NOCOPY VARCHAR2) IS

Line 1539: l_suc_entity_ids WSH_UTIL_CORE.column_tab_type;

1535: l_wf_status VARCHAR2(30); -- COMPLETE/ERROR/SUSPENDED
1536: l_result VARCHAR2(30);
1537: l_itemtype VARCHAR2(30);
1538:
1539: l_suc_entity_ids WSH_UTIL_CORE.column_tab_type;
1540:
1541: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'PURGE_ENTITY';
1542: l_debug_on BOOLEAN;
1543:

Line 1562: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1558: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',p_action);
1559: WSH_DEBUG_SV.log(l_module_name,'P_DOCOMMIT',p_docommit);
1560: END IF;
1561:
1562: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1563: SAVEPOINT PURGE_ENTITY_UPDATE;
1564:
1565: IF (p_entity_type = 'TRIP') THEN
1566: l_itemtype := 'WSHTRIP';

Line 1634: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

1630:
1631: x_success_count := l_suc_entity_ids.count;
1632: /*
1633: IF (l_suc_entity_ids.count = 0) THEN
1634: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1635: ELSIF (p_entity_ids.count <> l_suc_entity_ids.count) THEN
1636: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;
1637: ELSIF (p_entity_ids.count = l_suc_entity_ids.count) THEN
1638: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1636: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;

1632: /*
1633: IF (l_suc_entity_ids.count = 0) THEN
1634: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1635: ELSIF (p_entity_ids.count <> l_suc_entity_ids.count) THEN
1636: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;
1637: ELSIF (p_entity_ids.count = l_suc_entity_ids.count) THEN
1638: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1639: END IF;
1640: */

Line 1638: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1634: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1635: ELSIF (p_entity_ids.count <> l_suc_entity_ids.count) THEN
1636: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;
1637: ELSIF (p_entity_ids.count = l_suc_entity_ids.count) THEN
1638: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1639: END IF;
1640: */
1641: IF l_debug_on THEN
1642: WSH_DEBUG_SV.pop(l_module_name);

Line 1648: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1644:
1645:
1646: EXCEPTION
1647: WHEN others THEN
1648: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1649: IF l_debug_on THEN
1650: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1651: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1652: END IF;

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

1662: -- p_ship_from_location_id - The Ship from Location Id
1663: -- p_exception_name WSH_LAUNCH_WF_FAILED
1664: -- WSH_DEL_SCPOD_PURGED
1665: --
1666: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
1667: --
1668: -- Description: This Procedure logs an exception against the specified Entity
1669: --
1670: --

Line 1759: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1755:
1756:
1757: EXCEPTION
1758: WHEN others THEN
1759: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1760: IF l_debug_on THEN
1761: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1762: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1763: END IF;

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

1967:
1968: END RESET_APPS_CONTEXT_OFF;
1969:
1970: /* CURRENTLY NOT IN USE
1971: PROCEDURE Get_Carrier(p_del_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
1972: x_del_old_carrier_ids OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
1973: x_return_status OUT NOCOPY VARCHAR2) IS
1974:
1975: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_CARRIER';

Line 1972: x_del_old_carrier_ids OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,

1968: END RESET_APPS_CONTEXT_OFF;
1969:
1970: /* CURRENTLY NOT IN USE
1971: PROCEDURE Get_Carrier(p_del_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
1972: x_del_old_carrier_ids OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
1973: x_return_status OUT NOCOPY VARCHAR2) IS
1974:
1975: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_CARRIER';
1976: l_debug_on BOOLEAN;

Line 2004: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2000: l_return_status VARCHAR2(1);
2001:
2002: BEGIN
2003:
2004: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2005: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2006:
2007: IF l_debug_on IS NULL THEN
2008: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

Line 2033: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

2029: END LOOP;
2030:
2031: EXCEPTION
2032: WHEN OTHERS THEN
2033: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2034: wsh_util_core.default_handler('WSH_WF_STD.GET_CARRIER');
2035: IF l_debug_on THEN
2036: --{
2037: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

2030:
2031: EXCEPTION
2032: WHEN OTHERS THEN
2033: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2034: wsh_util_core.default_handler('WSH_WF_STD.GET_CARRIER');
2035: IF l_debug_on THEN
2036: --{
2037: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2038: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2044: p_del_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,

2040: END IF;
2041: END Get_Carrier;
2042:
2043: PROCEDURE Handle_Trip_Carriers(p_trip_id IN NUMBER,
2044: p_del_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
2045: p_del_old_carrier_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
2046: x_return_status OUT NOCOPY VARCHAR2) IS
2047:
2048: l_del_new_carrier_ids WSH_UTIL_CORE.ID_TAB_TYPE;

Line 2045: p_del_old_carrier_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,

2041: END Get_Carrier;
2042:
2043: PROCEDURE Handle_Trip_Carriers(p_trip_id IN NUMBER,
2044: p_del_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
2045: p_del_old_carrier_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
2046: x_return_status OUT NOCOPY VARCHAR2) IS
2047:
2048: l_del_new_carrier_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2049: l_return_status VARCHAR2(1);

Line 2048: l_del_new_carrier_ids WSH_UTIL_CORE.ID_TAB_TYPE;

2044: p_del_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
2045: p_del_old_carrier_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
2046: x_return_status OUT NOCOPY VARCHAR2) IS
2047:
2048: l_del_new_carrier_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2049: l_return_status VARCHAR2(1);
2050:
2051: BEGIN
2052:

Line 2098: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2094: l_carrier_name VARCHAR2(360);
2095:
2096: BEGIN
2097:
2098: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2099:
2100: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2101:
2102: IF l_debug_on IS NULL THEN

Line 2165: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

2161: END IF; --Check for Delivery Workflow Name.
2162:
2163: EXCEPTION
2164: WHEN OTHERS THEN
2165: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2166: wsh_util_core.default_handler('WSH_WF_STD.Assign_Unassign_Carrier');
2167: IF l_debug_on THEN
2168: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2169: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

2162:
2163: EXCEPTION
2164: WHEN OTHERS THEN
2165: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2166: wsh_util_core.default_handler('WSH_WF_STD.Assign_Unassign_Carrier');
2167: IF l_debug_on THEN
2168: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2169: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2170: END IF;

Line 2175: x_del_ids OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,

2171: END Assign_Unassign_Carrier;
2172:
2173:
2174: PROCEDURE Get_Deliveries(p_trip_id IN NUMBER,
2175: x_del_ids OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
2176: x_return_status OUT NOCOPY VARCHAR2) IS
2177:
2178: CURSOR c_dels(p_trip_id IN NUMBER) IS
2179: SELECT