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.WMS_WORKFLOW_WRAPPERS dependencies on WF_ENGINE

Line 998: wf_engine.CreateProcess(itemtype => l_workflow_name,

994: mdebug('Item key is: '|| l_item_key);
995: END IF;
996:
997: -- initialize workflow
998: wf_engine.CreateProcess(itemtype => l_workflow_name,
999: itemkey => l_item_key,
1000: process => l_workflow_process);
1001:
1002: -- set the attribute values of workflow with the local parameters

Line 1003: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

999: itemkey => l_item_key,
1000: process => l_workflow_process);
1001:
1002: -- set the attribute values of workflow with the local parameters
1003: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1004: itemkey => l_item_key,
1005: aname => 'PW_REASON_ID',
1006: avalue => P_REASON_ID);
1007:

Line 1008: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1004: itemkey => l_item_key,
1005: aname => 'PW_REASON_ID',
1006: avalue => P_REASON_ID);
1007:
1008: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1009: itemkey => l_item_key,
1010: aname => 'PW_CALLING_PROGRAM_NAME',
1011: avalue => P_CALLING_PROGRAM_NAME);
1012:

Line 1013: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1009: itemkey => l_item_key,
1010: aname => 'PW_CALLING_PROGRAM_NAME',
1011: avalue => P_CALLING_PROGRAM_NAME);
1012:
1013: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1014: itemkey => l_item_key,
1015: aname => 'PW_SOURCE_ORGANIZATION_ID',
1016: avalue => P_SOURCE_ORGANIZATION_ID);
1017: l_error:=100;

Line 1018: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1014: itemkey => l_item_key,
1015: aname => 'PW_SOURCE_ORGANIZATION_ID',
1016: avalue => P_SOURCE_ORGANIZATION_ID);
1017: l_error:=100;
1018: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1019: itemkey => l_item_key,
1020: aname => 'PW_SOURCE_ORGANIZATION_N',
1021: avalue => L_SOURCE_ORGANIZATION_N);
1022: l_error:=101;

Line 1023: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1019: itemkey => l_item_key,
1020: aname => 'PW_SOURCE_ORGANIZATION_N',
1021: avalue => L_SOURCE_ORGANIZATION_N);
1022: l_error:=101;
1023: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1024: itemkey => l_item_key,
1025: aname => 'PW_REASON_NAME',
1026: avalue => L_REASON_NAME);
1027:

Line 1028: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1024: itemkey => l_item_key,
1025: aname => 'PW_REASON_NAME',
1026: avalue => L_REASON_NAME);
1027:
1028: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1029: itemkey => l_item_key,
1030: aname => 'PW_DESTINATION_ORGANIZATION_ID',
1031: avalue => L_DESTINATION_ORGANIZATION_ID);
1032:

Line 1033: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1029: itemkey => l_item_key,
1030: aname => 'PW_DESTINATION_ORGANIZATION_ID',
1031: avalue => L_DESTINATION_ORGANIZATION_ID);
1032:
1033: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1034: itemkey => l_item_key,
1035: aname => 'PW_SOURCE_SUBINVENTORY',
1036: avalue => L_SOURCE_SUBINVENTORY);
1037:

Line 1038: wf_engine.setitemattrNumber(itemtype => l_workflow_name,

1034: itemkey => l_item_key,
1035: aname => 'PW_SOURCE_SUBINVENTORY',
1036: avalue => L_SOURCE_SUBINVENTORY);
1037:
1038: wf_engine.setitemattrNumber(itemtype => l_workflow_name,
1039: itemkey => l_item_key,
1040: aname => 'PW_SOURCE_SUBINVENTORY_STATUS',
1041: avalue => L_SOURCE_SUBINVENTORY_STATUS);
1042:

Line 1043: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1039: itemkey => l_item_key,
1040: aname => 'PW_SOURCE_SUBINVENTORY_STATUS',
1041: avalue => L_SOURCE_SUBINVENTORY_STATUS);
1042:
1043: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1044: itemkey => l_item_key,
1045: aname => 'PW_DESTINATION_SUBINVENTORY',
1046: avalue => L_DESTINATION_SUBINVENTORY);
1047:

Line 1048: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1044: itemkey => l_item_key,
1045: aname => 'PW_DESTINATION_SUBINVENTORY',
1046: avalue => L_DESTINATION_SUBINVENTORY);
1047:
1048: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1049: itemkey => l_item_key,
1050: aname => 'PW_DESTINATION_SUBINVENTORY_ST',
1051: avalue => L_DESTINATION_SUBINVENTORY_ST);
1052:

Line 1053: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1049: itemkey => l_item_key,
1050: aname => 'PW_DESTINATION_SUBINVENTORY_ST',
1051: avalue => L_DESTINATION_SUBINVENTORY_ST);
1052:
1053: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1054: itemkey => l_item_key,
1055: aname => 'PW_SOURCE_LOCATOR',
1056: avalue => L_SOURCE_LOCATOR);
1057:

Line 1058: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1054: itemkey => l_item_key,
1055: aname => 'PW_SOURCE_LOCATOR',
1056: avalue => L_SOURCE_LOCATOR);
1057:
1058: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1059: itemkey => l_item_key,
1060: aname => 'PW_SOURCE_LOCATOR_N',
1061: avalue => L_SOURCE_LOCATOR_N);
1062:

Line 1063: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1059: itemkey => l_item_key,
1060: aname => 'PW_SOURCE_LOCATOR_N',
1061: avalue => L_SOURCE_LOCATOR_N);
1062:
1063: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1064: itemkey => l_item_key,
1065: aname => 'PW_SOURCE_LOCATOR_STATUS',
1066: avalue => L_SOURCE_LOCATOR_STATUS);
1067:

Line 1068: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1064: itemkey => l_item_key,
1065: aname => 'PW_SOURCE_LOCATOR_STATUS',
1066: avalue => L_SOURCE_LOCATOR_STATUS);
1067:
1068: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1069: itemkey => l_item_key,
1070: aname => 'PW_DESTINATION_LOCATOR',
1071: avalue => L_DESTINATION_LOCATOR);
1072:

Line 1073: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1069: itemkey => l_item_key,
1070: aname => 'PW_DESTINATION_LOCATOR',
1071: avalue => L_DESTINATION_LOCATOR);
1072:
1073: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1074: itemkey => l_item_key,
1075: aname => 'PW_DESTINATION_LOCATOR_STATUS',
1076: avalue => L_DESTINATION_LOCATOR_STATUS);
1077:

Line 1078: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1074: itemkey => l_item_key,
1075: aname => 'PW_DESTINATION_LOCATOR_STATUS',
1076: avalue => L_DESTINATION_LOCATOR_STATUS);
1077:
1078: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1079: itemkey => l_item_key,
1080: aname => 'PW_LPN_ID',
1081: avalue => L_LPN_ID);
1082:

Line 1083: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1079: itemkey => l_item_key,
1080: aname => 'PW_LPN_ID',
1081: avalue => L_LPN_ID);
1082:
1083: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1084: itemkey => l_item_key,
1085: aname => 'PW_LPN_N',
1086: avalue => L_LPN_N);
1087:

Line 1088: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1084: itemkey => l_item_key,
1085: aname => 'PW_LPN_N',
1086: avalue => L_LPN_N);
1087:
1088: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1089: itemkey => l_item_key,
1090: aname => 'PW_LPN_STATUS',
1091: avalue => L_LPN_STATUS);
1092:

Line 1093: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1089: itemkey => l_item_key,
1090: aname => 'PW_LPN_STATUS',
1091: avalue => L_LPN_STATUS);
1092:
1093: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1094: itemkey => l_item_key,
1095: aname => 'PW_CONTENT_LPN_ID',
1096: avalue => L_CONTENT_LPN_ID);
1097:

Line 1098: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1094: itemkey => l_item_key,
1095: aname => 'PW_CONTENT_LPN_ID',
1096: avalue => L_CONTENT_LPN_ID);
1097:
1098: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1099: itemkey => l_item_key,
1100: aname => 'PW_CONTENT_LPN_STATUS',
1101: avalue => L_CONTENT_LPN_STATUS);
1102:

Line 1103: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1099: itemkey => l_item_key,
1100: aname => 'PW_CONTENT_LPN_STATUS',
1101: avalue => L_CONTENT_LPN_STATUS);
1102:
1103: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1104: itemkey => l_item_key,
1105: aname => 'PW_SOURCE_PARENT_LPN_ID',
1106: avalue => L_SOURCE_PARENT_LPN_ID);
1107:

Line 1108: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1104: itemkey => l_item_key,
1105: aname => 'PW_SOURCE_PARENT_LPN_ID',
1106: avalue => L_SOURCE_PARENT_LPN_ID);
1107:
1108: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1109: itemkey => l_item_key,
1110: aname => 'PW_SOURCE_PARENT_LPN_STATUS',
1111: avalue => L_SOURCE_PARENT_LPN_STATUS);
1112:

Line 1113: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1109: itemkey => l_item_key,
1110: aname => 'PW_SOURCE_PARENT_LPN_STATUS',
1111: avalue => L_SOURCE_PARENT_LPN_STATUS);
1112:
1113: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1114: itemkey => l_item_key,
1115: aname => 'PW_SOURCE_OUTERMOST_LPN_ID',
1116: avalue => L_SOURCE_OUTERMOST_LPN_ID);
1117:

Line 1118: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1114: itemkey => l_item_key,
1115: aname => 'PW_SOURCE_OUTERMOST_LPN_ID',
1116: avalue => L_SOURCE_OUTERMOST_LPN_ID);
1117:
1118: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1119: itemkey => l_item_key,
1120: aname => 'PW_SOURCE_OUTERMOST_LPN_STATUS',
1121: avalue => L_SOURCE_OUTERMOST_LPN_STATUS);
1122:

Line 1123: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1119: itemkey => l_item_key,
1120: aname => 'PW_SOURCE_OUTERMOST_LPN_STATUS',
1121: avalue => L_SOURCE_OUTERMOST_LPN_STATUS);
1122:
1123: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1124: itemkey => l_item_key,
1125: aname => 'PW_DEST_LPN_ID',
1126: avalue => L_DEST_LPN_ID);
1127:

Line 1128: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1124: itemkey => l_item_key,
1125: aname => 'PW_DEST_LPN_ID',
1126: avalue => L_DEST_LPN_ID);
1127:
1128: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1129: itemkey => l_item_key,
1130: aname => 'PW_DEST_LPN_STATUS',
1131: avalue => L_DEST_LPN_STATUS);
1132:

Line 1133: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1129: itemkey => l_item_key,
1130: aname => 'PW_DEST_LPN_STATUS',
1131: avalue => L_DEST_LPN_STATUS);
1132:
1133: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1134: itemkey => l_item_key,
1135: aname => 'PW_DEST_PARENT_LPN_ID',
1136: avalue => L_DEST_PARENT_LPN_ID);
1137:

Line 1138: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1134: itemkey => l_item_key,
1135: aname => 'PW_DEST_PARENT_LPN_ID',
1136: avalue => L_DEST_PARENT_LPN_ID);
1137:
1138: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1139: itemkey => l_item_key,
1140: aname => 'PW_DEST_PARENT_LPN_STATUS',
1141: avalue => L_DEST_PARENT_LPN_STATUS);
1142:

Line 1143: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1139: itemkey => l_item_key,
1140: aname => 'PW_DEST_PARENT_LPN_STATUS',
1141: avalue => L_DEST_PARENT_LPN_STATUS);
1142:
1143: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1144: itemkey => l_item_key,
1145: aname => 'PW_DEST_OUTERMOST_LPN_ID',
1146: avalue => L_DEST_OUTERMOST_LPN_ID);
1147:

Line 1148: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1144: itemkey => l_item_key,
1145: aname => 'PW_DEST_OUTERMOST_LPN_ID',
1146: avalue => L_DEST_OUTERMOST_LPN_ID);
1147:
1148: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1149: itemkey => l_item_key,
1150: aname => 'PW_DEST_OUTERMOST_LPN_STATUS',
1151: avalue => L_DEST_OUTERMOST_LPN_STATUS);
1152:

Line 1154: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1150: aname => 'PW_DEST_OUTERMOST_LPN_STATUS',
1151: avalue => L_DEST_OUTERMOST_LPN_STATUS);
1152:
1153: --Bug 7504490 l_allocated_lpn_id
1154: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1155: itemkey => l_item_key,
1156: aname => 'PW_ALLOCATED_LPN_ID',
1157: avalue => l_allocated_lpn_id);
1158:

Line 1159: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1155: itemkey => l_item_key,
1156: aname => 'PW_ALLOCATED_LPN_ID',
1157: avalue => l_allocated_lpn_id);
1158:
1159: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1160: itemkey => l_item_key,
1161: aname => 'PW_INVENTORY_ITEM_ID',
1162: avalue => L_INVENTORY_ITEM_ID);
1163:

Line 1164: wf_engine.setitemattrtext(itemtype => l_workflow_name,

1160: itemkey => l_item_key,
1161: aname => 'PW_INVENTORY_ITEM_ID',
1162: avalue => L_INVENTORY_ITEM_ID);
1163:
1164: wf_engine.setitemattrtext(itemtype => l_workflow_name,
1165: itemkey => l_item_key,
1166: aname => 'PW_INVENTORY_ITEM_NAME',
1167: avalue => L_INVENTORY_ITEM_NAME);
1168:

Line 1169: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1165: itemkey => l_item_key,
1166: aname => 'PW_INVENTORY_ITEM_NAME',
1167: avalue => L_INVENTORY_ITEM_NAME);
1168:
1169: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1170: itemkey => l_item_key,
1171: aname => 'PW_REVISION',
1172: avalue => L_REVISION);
1173:

Line 1174: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1170: itemkey => l_item_key,
1171: aname => 'PW_REVISION',
1172: avalue => L_REVISION);
1173:
1174: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1175: itemkey => l_item_key,
1176: aname => 'PW_LOT_NUMBER',
1177: avalue => L_LOT_NUMBER);
1178:

Line 1179: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1175: itemkey => l_item_key,
1176: aname => 'PW_LOT_NUMBER',
1177: avalue => L_LOT_NUMBER);
1178:
1179: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1180: itemkey => l_item_key,
1181: aname => 'PW_TO_LOT_NUMBER',
1182: avalue => L_TO_LOT_NUMBER);
1183:

Line 1184: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1180: itemkey => l_item_key,
1181: aname => 'PW_TO_LOT_NUMBER',
1182: avalue => L_TO_LOT_NUMBER);
1183:
1184: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1185: itemkey => l_item_key,
1186: aname => 'PW_LOT_STATUS',
1187: avalue => L_LOT_STATUS);
1188:

Line 1189: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1185: itemkey => l_item_key,
1186: aname => 'PW_LOT_STATUS',
1187: avalue => L_LOT_STATUS);
1188:
1189: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1190: itemkey => l_item_key,
1191: aname => 'PW_SERIAL_NUMBER',
1192: avalue => L_SERIAL_NUMBER);
1193:

Line 1194: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1190: itemkey => l_item_key,
1191: aname => 'PW_SERIAL_NUMBER',
1192: avalue => L_SERIAL_NUMBER);
1193:
1194: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1195: itemkey => l_item_key,
1196: aname => 'PW_TO_SERIAL_NUMBER',
1197: avalue => L_TO_SERIAL_NUMBER);
1198:

Line 1199: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1195: itemkey => l_item_key,
1196: aname => 'PW_TO_SERIAL_NUMBER',
1197: avalue => L_TO_SERIAL_NUMBER);
1198:
1199: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1200: itemkey => l_item_key,
1201: aname => 'PW_SERIAL_NUMBER_STATUS',
1202: avalue => L_SERIAL_NUMBER_STATUS);
1203:

Line 1204: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1200: itemkey => l_item_key,
1201: aname => 'PW_SERIAL_NUMBER_STATUS',
1202: avalue => L_SERIAL_NUMBER_STATUS);
1203:
1204: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1205: itemkey => l_item_key,
1206: aname => 'PW_PRIMARY_UOM',
1207: avalue => L_PRIMARY_UOM);
1208:

Line 1209: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1205: itemkey => l_item_key,
1206: aname => 'PW_PRIMARY_UOM',
1207: avalue => L_PRIMARY_UOM);
1208:
1209: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1210: itemkey => l_item_key,
1211: aname => 'PW_TRANSACTION_UOM',
1212: avalue => L_TRANSACTION_UOM);
1213:

Line 1214: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1210: itemkey => l_item_key,
1211: aname => 'PW_TRANSACTION_UOM',
1212: avalue => L_TRANSACTION_UOM);
1213:
1214: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1215: itemkey => l_item_key,
1216: aname => 'PW_PRIMARY_QUANTITY',
1217: avalue => L_PRIMARY_QUANTITY);
1218:

Line 1219: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1215: itemkey => l_item_key,
1216: aname => 'PW_PRIMARY_QUANTITY',
1217: avalue => L_PRIMARY_QUANTITY);
1218:
1219: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1220: itemkey => l_item_key,
1221: aname => 'PW_TRANSACTION_QUANTITY',
1222: avalue => L_TRANSACTION_QUANTITY);
1223:

Line 1224: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1220: itemkey => l_item_key,
1221: aname => 'PW_TRANSACTION_QUANTITY',
1222: avalue => L_TRANSACTION_QUANTITY);
1223:
1224: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1225: itemkey => l_item_key,
1226: aname => 'PW_TRANSACTION_HEADER_ID',
1227: avalue => L_TRANSACTION_HEADER_ID);
1228:

Line 1229: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1225: itemkey => l_item_key,
1226: aname => 'PW_TRANSACTION_HEADER_ID',
1227: avalue => L_TRANSACTION_HEADER_ID);
1228:
1229: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1230: itemkey => l_item_key,
1231: aname => 'PW_TRANSACTION_MO_LINE_ID',
1232: avalue => L_MO_LINE_ID);
1233:

Line 1234: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1230: itemkey => l_item_key,
1231: aname => 'PW_TRANSACTION_MO_LINE_ID',
1232: avalue => L_MO_LINE_ID);
1233:
1234: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1235: itemkey => l_item_key,
1236: aname => 'PW_TRANSACTION_ACTION_ID',
1237: avalue => L_TRANSACTION_ACTION_ID);
1238:

Line 1239: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1235: itemkey => l_item_key,
1236: aname => 'PW_TRANSACTION_ACTION_ID',
1237: avalue => L_TRANSACTION_ACTION_ID);
1238:
1239: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1240: itemkey => l_item_key,
1241: aname => 'PW_TRANSACTION_SOURCE_TYPE_ID',
1242: avalue => L_TRANSACTION_SOURCE_TYPE_ID);
1243:

Line 1244: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1240: itemkey => l_item_key,
1241: aname => 'PW_TRANSACTION_SOURCE_TYPE_ID',
1242: avalue => L_TRANSACTION_SOURCE_TYPE_ID);
1243:
1244: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1245: itemkey => l_item_key,
1246: aname => 'PW_TRANSACTION_SOURCE',
1247: avalue => L_TRANSACTION_SOURCE);
1248:

Line 1249: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1245: itemkey => l_item_key,
1246: aname => 'PW_TRANSACTION_SOURCE',
1247: avalue => L_TRANSACTION_SOURCE);
1248:
1249: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1250: itemkey => l_item_key,
1251: aname => 'PW_RESERVATION_ID',
1252: avalue => L_RESERVATION_ID);
1253:

Line 1254: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1250: itemkey => l_item_key,
1251: aname => 'PW_RESERVATION_ID',
1252: avalue => L_RESERVATION_ID);
1253:
1254: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1255: itemkey => l_item_key,
1256: aname => 'PW_EQUIPMENT_ID',
1257: avalue => L_EQUIPMENT_ID);
1258:

Line 1259: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1255: itemkey => l_item_key,
1256: aname => 'PW_EQUIPMENT_ID',
1257: avalue => L_EQUIPMENT_ID);
1258:
1259: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1260: itemkey => l_item_key,
1261: aname => 'PW_USER_ID',
1262: avalue => L_USER_ID);
1263:

Line 1264: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1260: itemkey => l_item_key,
1261: aname => 'PW_USER_ID',
1262: avalue => L_USER_ID);
1263:
1264: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1265: itemkey => l_item_key,
1266: aname => 'PW_USER_NAME',
1267: avalue => L_USER_NAME);
1268:

Line 1269: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1265: itemkey => l_item_key,
1266: aname => 'PW_USER_NAME',
1267: avalue => L_USER_NAME);
1268:
1269: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1270: itemkey => l_item_key,
1271: aname => 'PW_TASK_TYPE_ID',
1272: avalue => L_TASK_TYPE_ID);
1273:

Line 1274: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1270: itemkey => l_item_key,
1271: aname => 'PW_TASK_TYPE_ID',
1272: avalue => L_TASK_TYPE_ID);
1273:
1274: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1275: itemkey => l_item_key,
1276: aname => 'PW_TASK_ID',
1277: avalue => L_TASK_ID);
1278:

Line 1279: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1275: itemkey => l_item_key,
1276: aname => 'PW_TASK_ID',
1277: avalue => L_TASK_ID);
1278:
1279: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1280: itemkey => l_item_key,
1281: aname => 'PW_TXN_TEMP_ID',
1282: avalue => L_transaction_temp_id);
1283:

Line 1284: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1280: itemkey => l_item_key,
1281: aname => 'PW_TXN_TEMP_ID',
1282: avalue => L_transaction_temp_id);
1283:
1284: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1285: itemkey => l_item_key,
1286: aname => 'PW_UPDATE_STATUS_METHOD',
1287: avalue => L_UPDATE_STATUS_METHOD);
1288:

Line 1289: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1285: itemkey => l_item_key,
1286: aname => 'PW_UPDATE_STATUS_METHOD',
1287: avalue => L_UPDATE_STATUS_METHOD);
1288:
1289: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1290: itemkey => l_item_key,
1291: aname => 'PW_PROGRAM_CONTROL_ARG1',
1292: avalue => L_PROGRAM_CONTROL_ARG1);
1293:

Line 1294: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1290: itemkey => l_item_key,
1291: aname => 'PW_PROGRAM_CONTROL_ARG1',
1292: avalue => L_PROGRAM_CONTROL_ARG1);
1293:
1294: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1295: itemkey => l_item_key,
1296: aname => 'PW_PROGRAM_CONTROL_ARG2',
1297: avalue => L_PROGRAM_CONTROL_ARG2);
1298:

Line 1299: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1295: itemkey => l_item_key,
1296: aname => 'PW_PROGRAM_CONTROL_ARG2',
1297: avalue => L_PROGRAM_CONTROL_ARG2);
1298:
1299: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1300: itemkey => l_item_key,
1301: aname => 'PW_PROGRAM_CONTROL_ARG3',
1302: avalue => L_PROGRAM_CONTROL_ARG3);
1303:

Line 1304: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1300: itemkey => l_item_key,
1301: aname => 'PW_PROGRAM_CONTROL_ARG3',
1302: avalue => L_PROGRAM_CONTROL_ARG3);
1303:
1304: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1305: itemkey => l_item_key,
1306: aname => 'PW_PROGRAM_CONTROL_ARG4',
1307: avalue => L_PROGRAM_CONTROL_ARG4);
1308:

Line 1309: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1305: itemkey => l_item_key,
1306: aname => 'PW_PROGRAM_CONTROL_ARG4',
1307: avalue => L_PROGRAM_CONTROL_ARG4);
1308:
1309: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1310: itemkey => l_item_key,
1311: aname => 'PW_PROGRAM_CONTROL_ARG5',
1312: avalue => L_PROGRAM_CONTROL_ARG5);
1313:

Line 1314: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1310: itemkey => l_item_key,
1311: aname => 'PW_PROGRAM_CONTROL_ARG5',
1312: avalue => L_PROGRAM_CONTROL_ARG5);
1313:
1314: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1315: itemkey => l_item_key,
1316: aname => 'PW_PROGRAM_CONTROL_ARG6',
1317: avalue => L_PROGRAM_CONTROL_ARG6);
1318:

Line 1321: mdebug('Before wf_engine.StartProcess of: ' || l_workflow_name);

1317: avalue => L_PROGRAM_CONTROL_ARG6);
1318:
1319: -- start workflow
1320: IF (l_debug = 1) THEN
1321: mdebug('Before wf_engine.StartProcess of: ' || l_workflow_name);
1322: END IF;
1323: wf_engine.StartProcess (itemtype => l_workflow_name,
1324: itemkey => l_item_key);
1325:

Line 1323: wf_engine.StartProcess (itemtype => l_workflow_name,

1319: -- start workflow
1320: IF (l_debug = 1) THEN
1321: mdebug('Before wf_engine.StartProcess of: ' || l_workflow_name);
1322: END IF;
1323: wf_engine.StartProcess (itemtype => l_workflow_name,
1324: itemkey => l_item_key);
1325:
1326:
1327:

Line 1330: X_RETURN_STATUS := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

1326:
1327:
1328: -- on completion of the workflow, the output parameters are populated with the
1329: -- workflow attribute values
1330: X_RETURN_STATUS := wf_engine.GetItemAttrText(itemtype => l_workflow_name,
1331: itemkey => l_item_key,
1332: aname => 'XW_RETURN_STATUS');
1333:
1334: X_MSG_DATA := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

Line 1334: X_MSG_DATA := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

1330: X_RETURN_STATUS := wf_engine.GetItemAttrText(itemtype => l_workflow_name,
1331: itemkey => l_item_key,
1332: aname => 'XW_RETURN_STATUS');
1333:
1334: X_MSG_DATA := wf_engine.GetItemAttrText(itemtype => l_workflow_name,
1335: itemkey => l_item_key,
1336: aname => 'XW_MSG_DATA');
1337:
1338: X_MSG_COUNT := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

Line 1338: X_MSG_COUNT := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

1334: X_MSG_DATA := wf_engine.GetItemAttrText(itemtype => l_workflow_name,
1335: itemkey => l_item_key,
1336: aname => 'XW_MSG_DATA');
1337:
1338: X_MSG_COUNT := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1339: itemkey => l_item_key,
1340: aname => 'XW_MSG_COUNT');
1341:
1342: X_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype=> l_workflow_name,

Line 1342: X_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype=> l_workflow_name,

1338: X_MSG_COUNT := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1339: itemkey => l_item_key,
1340: aname => 'XW_MSG_COUNT');
1341:
1342: X_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype=> l_workflow_name,
1343: itemkey => l_item_key,
1344: aname => 'XW_ORGANIZATION_ID');
1345:
1346: X_SUBINVENTORY := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

Line 1346: X_SUBINVENTORY := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

1342: X_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype=> l_workflow_name,
1343: itemkey => l_item_key,
1344: aname => 'XW_ORGANIZATION_ID');
1345:
1346: X_SUBINVENTORY := wf_engine.GetItemAttrText(itemtype => l_workflow_name,
1347: itemkey => l_item_key,
1348: aname => 'XW_SUBINVENTORY');
1349:
1350: X_SUBINVENTORY_STATUS:=wf_engine.GetItemAttrNumber(itemtype=> l_workflow_name,

Line 1350: X_SUBINVENTORY_STATUS:=wf_engine.GetItemAttrNumber(itemtype=> l_workflow_name,

1346: X_SUBINVENTORY := wf_engine.GetItemAttrText(itemtype => l_workflow_name,
1347: itemkey => l_item_key,
1348: aname => 'XW_SUBINVENTORY');
1349:
1350: X_SUBINVENTORY_STATUS:=wf_engine.GetItemAttrNumber(itemtype=> l_workflow_name,
1351: itemkey => l_item_key,
1352: aname => 'XW_SUBINVENTORY_STATUS');
1353:
1354: X_LOCATOR := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

Line 1354: X_LOCATOR := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

1350: X_SUBINVENTORY_STATUS:=wf_engine.GetItemAttrNumber(itemtype=> l_workflow_name,
1351: itemkey => l_item_key,
1352: aname => 'XW_SUBINVENTORY_STATUS');
1353:
1354: X_LOCATOR := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1355: itemkey => l_item_key,
1356: aname => 'XW_LOCATOR');
1357:
1358: X_LOCATOR_STATUS:= wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

Line 1358: X_LOCATOR_STATUS:= wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

1354: X_LOCATOR := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1355: itemkey => l_item_key,
1356: aname => 'XW_LOCATOR');
1357:
1358: X_LOCATOR_STATUS:= wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1359: itemkey => l_item_key,
1360: aname => 'XW_LOCATOR_STATUS');
1361:
1362: X_LPN_ID := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

Line 1362: X_LPN_ID := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

1358: X_LOCATOR_STATUS:= wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1359: itemkey => l_item_key,
1360: aname => 'XW_LOCATOR_STATUS');
1361:
1362: X_LPN_ID := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1363: itemkey => l_item_key,
1364: aname => 'XW_LPN_ID');
1365:
1366: X_LPN_STATUS := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

Line 1366: X_LPN_STATUS := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

1362: X_LPN_ID := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1363: itemkey => l_item_key,
1364: aname => 'XW_LPN_ID');
1365:
1366: X_LPN_STATUS := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1367: itemkey => l_item_key,
1368: aname => 'XW_LPN_STATUS');
1369:
1370: X_INVENTORY_ITEM_ID:=wf_engine.GetItemAttrNumber(itemtype=> l_workflow_name,

Line 1370: X_INVENTORY_ITEM_ID:=wf_engine.GetItemAttrNumber(itemtype=> l_workflow_name,

1366: X_LPN_STATUS := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1367: itemkey => l_item_key,
1368: aname => 'XW_LPN_STATUS');
1369:
1370: X_INVENTORY_ITEM_ID:=wf_engine.GetItemAttrNumber(itemtype=> l_workflow_name,
1371: itemkey => l_item_key,
1372: aname => 'XW_INVENTORY_ITEM_ID');
1373:
1374: X_REVISION := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

Line 1374: X_REVISION := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

1370: X_INVENTORY_ITEM_ID:=wf_engine.GetItemAttrNumber(itemtype=> l_workflow_name,
1371: itemkey => l_item_key,
1372: aname => 'XW_INVENTORY_ITEM_ID');
1373:
1374: X_REVISION := wf_engine.GetItemAttrText(itemtype => l_workflow_name,
1375: itemkey => l_item_key,
1376: aname => 'XW_REVISION');
1377:
1378: X_LOT_NUMBER := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

Line 1378: X_LOT_NUMBER := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

1374: X_REVISION := wf_engine.GetItemAttrText(itemtype => l_workflow_name,
1375: itemkey => l_item_key,
1376: aname => 'XW_REVISION');
1377:
1378: X_LOT_NUMBER := wf_engine.GetItemAttrText(itemtype => l_workflow_name,
1379: itemkey => l_item_key,
1380: aname => 'XW_LOT_NUMBER');
1381:
1382: X_LOT_STATUS := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

Line 1382: X_LOT_STATUS := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

1378: X_LOT_NUMBER := wf_engine.GetItemAttrText(itemtype => l_workflow_name,
1379: itemkey => l_item_key,
1380: aname => 'XW_LOT_NUMBER');
1381:
1382: X_LOT_STATUS := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1383: itemkey => l_item_key,
1384: aname => 'XW_LOT_STATUS');
1385:
1386: X_QUANTITY := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

Line 1386: X_QUANTITY := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

1382: X_LOT_STATUS := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1383: itemkey => l_item_key,
1384: aname => 'XW_LOT_STATUS');
1385:
1386: X_QUANTITY := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1387: itemkey => l_item_key,
1388: aname => 'XW_QUANTITY');
1389:
1390: X_UOM_CODE := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

Line 1390: X_UOM_CODE := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

1386: X_QUANTITY := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1387: itemkey => l_item_key,
1388: aname => 'XW_QUANTITY');
1389:
1390: X_UOM_CODE := wf_engine.GetItemAttrText(itemtype => l_workflow_name,
1391: itemkey => l_item_key,
1392: aname => 'XW_UOM_CODE');
1393:
1394: X_PRIMARY_QUANTITY:=wf_engine.GetItemAttrNumber(itemtype=> l_workflow_name,

Line 1394: X_PRIMARY_QUANTITY:=wf_engine.GetItemAttrNumber(itemtype=> l_workflow_name,

1390: X_UOM_CODE := wf_engine.GetItemAttrText(itemtype => l_workflow_name,
1391: itemkey => l_item_key,
1392: aname => 'XW_UOM_CODE');
1393:
1394: X_PRIMARY_QUANTITY:=wf_engine.GetItemAttrNumber(itemtype=> l_workflow_name,
1395: itemkey => l_item_key,
1396: aname => 'XW_PRIMARY_QUANTITY');
1397:
1398: X_TRANSACTION_QUANTITY:=wf_engine.GetItemAttrNumber(itemtype=> l_workflow_name,

Line 1398: X_TRANSACTION_QUANTITY:=wf_engine.GetItemAttrNumber(itemtype=> l_workflow_name,

1394: X_PRIMARY_QUANTITY:=wf_engine.GetItemAttrNumber(itemtype=> l_workflow_name,
1395: itemkey => l_item_key,
1396: aname => 'XW_PRIMARY_QUANTITY');
1397:
1398: X_TRANSACTION_QUANTITY:=wf_engine.GetItemAttrNumber(itemtype=> l_workflow_name,
1399: itemkey => l_item_key,
1400: aname => 'XW_TRANSACTION_QUANTITY');
1401:
1402: X_RESERVATION_ID := wf_engine.GetItemAttrNumber(itemtype=> l_workflow_name,

Line 1402: X_RESERVATION_ID := wf_engine.GetItemAttrNumber(itemtype=> l_workflow_name,

1398: X_TRANSACTION_QUANTITY:=wf_engine.GetItemAttrNumber(itemtype=> l_workflow_name,
1399: itemkey => l_item_key,
1400: aname => 'XW_TRANSACTION_QUANTITY');
1401:
1402: X_RESERVATION_ID := wf_engine.GetItemAttrNumber(itemtype=> l_workflow_name,
1403: itemkey => l_item_key,
1404: aname => 'XW_RESERVATION_ID');
1405: BEGIN
1406: UPDATE wms_exceptions

Line 1493: lp_organization_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

1489: l_item_key := itemkey;
1490:
1491:
1492: -- populating the local procedure variables with the corresponding attributes from workflow
1493: lp_organization_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1494: itemkey => l_item_key,
1495: aname => 'PW_SOURCE_ORGANIZATION_ID');
1496:
1497: lp_task_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

Line 1497: lp_task_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

1493: lp_organization_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1494: itemkey => l_item_key,
1495: aname => 'PW_SOURCE_ORGANIZATION_ID');
1496:
1497: lp_task_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1498: itemkey => l_item_key,
1499: aname => 'PW_TASK_ID');
1500:
1501: -- MRANA: added this to get the temp_id instead of querying WDT to get it

Line 1503: lp_mmtt_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

1499: aname => 'PW_TASK_ID');
1500:
1501: -- MRANA: added this to get the temp_id instead of querying WDT to get it
1502: -- ALSO ,. deleted the query to wdt to get the temp_id based on task_id (pw_task_id)
1503: lp_mmtt_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1504: itemkey => l_item_key,
1505: aname => 'PW_TXN_TEMP_ID');
1506:
1507: lp_qty_picked := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

Line 1507: lp_qty_picked := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

1503: lp_mmtt_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1504: itemkey => l_item_key,
1505: aname => 'PW_TXN_TEMP_ID');
1506:
1507: lp_qty_picked := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1508: itemkey => l_item_key,
1509: aname => 'PW_TRANSACTION_QUANTITY');
1510:
1511: lp_qty_uom := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

Line 1511: lp_qty_uom := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

1507: lp_qty_picked := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1508: itemkey => l_item_key,
1509: aname => 'PW_TRANSACTION_QUANTITY');
1510:
1511: lp_qty_uom := wf_engine.GetItemAttrText(itemtype => l_workflow_name,
1512: itemkey => l_item_key,
1513: aname => 'PW_TRANSACTION_UOM');
1514:
1515: lp_carton_id := wf_engine.getItemAttrText(itemtype => l_workflow_name,

Line 1515: lp_carton_id := wf_engine.getItemAttrText(itemtype => l_workflow_name,

1511: lp_qty_uom := wf_engine.GetItemAttrText(itemtype => l_workflow_name,
1512: itemkey => l_item_key,
1513: aname => 'PW_TRANSACTION_UOM');
1514:
1515: lp_carton_id := wf_engine.getItemAttrText(itemtype => l_workflow_name,
1516: itemkey => l_item_key,
1517: aname => 'PW_LPN_ID');
1518:
1519: lp_user_id := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

Line 1519: lp_user_id := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

1515: lp_carton_id := wf_engine.getItemAttrText(itemtype => l_workflow_name,
1516: itemkey => l_item_key,
1517: aname => 'PW_LPN_ID');
1518:
1519: lp_user_id := wf_engine.GetItemAttrText(itemtype => l_workflow_name,
1520: itemkey => l_item_key,
1521: aname => 'PW_USER_ID');
1522:
1523: lp_reason_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

Line 1523: lp_reason_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

1519: lp_user_id := wf_engine.GetItemAttrText(itemtype => l_workflow_name,
1520: itemkey => l_item_key,
1521: aname => 'PW_USER_ID');
1522:
1523: lp_reason_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1524: itemkey => l_item_key,
1525: aname => 'PW_REASON_NAME');
1526: IF (l_debug = 1) THEN
1527: mdebug('before select temp id');

Line 1564: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1560: mdebug('After calling wms_txnrsn_actions_pub.suggest_alternate_location');
1561: END IF;
1562: -- setting the workflow attributes with the output results of
1563: -- the API wms_txnrsn_actions_pub.Inadequate_Qty
1564: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1565: itemkey => l_item_key,
1566: aname => 'XW_RETURN_STATUS',
1567: avalue => lx_return_status);
1568:

Line 1569: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1565: itemkey => l_item_key,
1566: aname => 'XW_RETURN_STATUS',
1567: avalue => lx_return_status);
1568:
1569: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1570: itemkey => l_item_key,
1571: aname => 'XW_MSG_COUNT',
1572: avalue => lx_msg_count);
1573:

Line 1574: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1570: itemkey => l_item_key,
1571: aname => 'XW_MSG_COUNT',
1572: avalue => lx_msg_count);
1573:
1574: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1575: itemkey => l_item_key,
1576: aname => 'XW_MSG_DATA',
1577: avalue => lx_msg_data);
1578:

Line 1615: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1611:
1612: mdebug('exception: fnd_api.g_exc_error');
1613: mdebug('wf_suggest_alt_loc lx_return_status to ' || lx_return_status);
1614:
1615: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1616: itemkey => l_item_key,
1617: aname => 'XW_RETURN_STATUS',
1618: avalue => lx_return_status);
1619:

Line 1620: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1616: itemkey => l_item_key,
1617: aname => 'XW_RETURN_STATUS',
1618: avalue => lx_return_status);
1619:
1620: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1621: itemkey => l_item_key,
1622: aname => 'XW_MSG_COUNT',
1623: avalue => lx_msg_count);
1624:

Line 1625: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1621: itemkey => l_item_key,
1622: aname => 'XW_MSG_COUNT',
1623: avalue => lx_msg_count);
1624:
1625: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1626: itemkey => l_item_key,
1627: aname => 'XW_MSG_DATA',
1628: avalue => lx_msg_data);
1629:

Line 1672: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1668:
1669: mdebug('exception: fnd_api.g_exc_unexpected_error');
1670: mdebug('wf_suggest_alt_loc lx_return_status to ' || lx_return_status);
1671:
1672: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1673: itemkey => l_item_key,
1674: aname => 'XW_RETURN_STATUS',
1675: avalue => lx_return_status);
1676:

Line 1677: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1673: itemkey => l_item_key,
1674: aname => 'XW_RETURN_STATUS',
1675: avalue => lx_return_status);
1676:
1677: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1678: itemkey => l_item_key,
1679: aname => 'XW_MSG_COUNT',
1680: avalue => lx_msg_count);
1681:

Line 1682: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1678: itemkey => l_item_key,
1679: aname => 'XW_MSG_COUNT',
1680: avalue => lx_msg_count);
1681:
1682: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1683: itemkey => l_item_key,
1684: aname => 'XW_MSG_DATA',
1685: avalue => lx_msg_data);
1686:

Line 1733: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1729:
1730: mdebug('exception: fnd_api.g_exc_unexpected_error');
1731: mdebug('wf_suggest_alt_loc lx_return_status to ' || lx_return_status);
1732: g_return_status := fnd_api.g_ret_sts_unexp_error; --Bug 6116046
1733: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1734: itemkey => l_item_key,
1735: aname => 'XW_RETURN_STATUS',
1736: avalue => lx_return_status);
1737:

Line 1738: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1734: itemkey => l_item_key,
1735: aname => 'XW_RETURN_STATUS',
1736: avalue => lx_return_status);
1737:
1738: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1739: itemkey => l_item_key,
1740: aname => 'XW_MSG_COUNT',
1741: avalue => lx_msg_count);
1742:

Line 1743: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1739: itemkey => l_item_key,
1740: aname => 'XW_MSG_COUNT',
1741: avalue => lx_msg_count);
1742:
1743: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1744: itemkey => l_item_key,
1745: aname => 'XW_MSG_DATA',
1746: avalue => lx_msg_data);
1747:

Line 1829: l_organization_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

1825: l_item_key := itemkey;
1826:
1827:
1828: -- set workflow attributes to local parameters
1829: l_organization_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1830: itemkey => l_item_key,
1831: aname => 'PW_SOURCE_ORGANIZATION_ID');
1832:
1833: l_subinventory_code := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

Line 1833: l_subinventory_code := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

1829: l_organization_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1830: itemkey => l_item_key,
1831: aname => 'PW_SOURCE_ORGANIZATION_ID');
1832:
1833: l_subinventory_code := wf_engine.GetItemAttrText(itemtype => l_workflow_name,
1834: itemkey => l_item_key,
1835: aname => 'PW_SOURCE_SUBINVENTORY');
1836:
1837:

Line 1838: l_locator_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

1834: itemkey => l_item_key,
1835: aname => 'PW_SOURCE_SUBINVENTORY');
1836:
1837:
1838: l_locator_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1839: itemkey => l_item_key,
1840: aname => 'PW_SOURCE_LOCATOR');
1841: --BUG #2867331
1842: l_inventory_item_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

Line 1842: l_inventory_item_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

1838: l_locator_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1839: itemkey => l_item_key,
1840: aname => 'PW_SOURCE_LOCATOR');
1841: --BUG #2867331
1842: l_inventory_item_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1843: itemkey => l_item_key,
1844: aname => 'PW_INVENTORY_ITEM_ID');
1845: --Bug 7504490 l_allocated_lpn_id
1846: l_allocated_lpn_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

Line 1846: l_allocated_lpn_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

1842: l_inventory_item_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1843: itemkey => l_item_key,
1844: aname => 'PW_INVENTORY_ITEM_ID');
1845: --Bug 7504490 l_allocated_lpn_id
1846: l_allocated_lpn_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1847: itemkey => l_item_key,
1848: aname => 'PW_ALLOCATED_LPN_ID');
1849:
1850: l_revision := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

Line 1850: l_revision := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

1846: l_allocated_lpn_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
1847: itemkey => l_item_key,
1848: aname => 'PW_ALLOCATED_LPN_ID');
1849:
1850: l_revision := wf_engine.GetItemAttrText(itemtype => l_workflow_name,
1851: itemkey => l_item_key,
1852: aname => 'PW_REVISION');
1853:
1854: --Bug 6116046 Begin

Line 1911: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1907: END IF;
1908: end loop;
1909:
1910: -- set outputs
1911: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1912: itemkey => l_item_key,
1913: aname => 'XW_RETURN_STATUS',
1914: avalue => x_return_status);
1915:

Line 1916: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1912: itemkey => l_item_key,
1913: aname => 'XW_RETURN_STATUS',
1914: avalue => x_return_status);
1915:
1916: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1917: itemkey => l_item_key,
1918: aname => 'XW_MSG_COUNT',
1919: avalue => x_msg_count);
1920:

Line 1921: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1917: itemkey => l_item_key,
1918: aname => 'XW_MSG_COUNT',
1919: avalue => x_msg_count);
1920:
1921: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1922: itemkey => l_item_key,
1923: aname => 'XW_MSG_DATA',
1924: avalue => x_msg_data);
1925:

Line 1939: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1935: p_data => x_msg_data
1936: );
1937:
1938: --Bug 6116046 Begin
1939: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1940: itemkey => l_item_key,
1941: aname => 'XW_RETURN_STATUS',
1942: avalue => x_return_status);
1943:

Line 1944: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1940: itemkey => l_item_key,
1941: aname => 'XW_RETURN_STATUS',
1942: avalue => x_return_status);
1943:
1944: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1945: itemkey => l_item_key,
1946: aname => 'XW_MSG_COUNT',
1947: avalue => x_msg_count);
1948:

Line 1949: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1945: itemkey => l_item_key,
1946: aname => 'XW_MSG_COUNT',
1947: avalue => x_msg_count);
1948:
1949: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1950: itemkey => l_item_key,
1951: aname => 'XW_MSG_DATA',
1952: avalue => x_msg_data);
1953: --Bug 6116046 End

Line 1965: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1961: ( p_count => x_msg_count,
1962: p_data => x_msg_data
1963: );
1964: --Bug 6116046 Begin
1965: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1966: itemkey => l_item_key,
1967: aname => 'XW_RETURN_STATUS',
1968: avalue => x_return_status);
1969:

Line 1970: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

1966: itemkey => l_item_key,
1967: aname => 'XW_RETURN_STATUS',
1968: avalue => x_return_status);
1969:
1970: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
1971: itemkey => l_item_key,
1972: aname => 'XW_MSG_COUNT',
1973: avalue => x_msg_count);
1974:

Line 1975: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1971: itemkey => l_item_key,
1972: aname => 'XW_MSG_COUNT',
1973: avalue => x_msg_count);
1974:
1975: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1976: itemkey => l_item_key,
1977: aname => 'XW_MSG_DATA',
1978: avalue => x_msg_data);
1979: --Bug 6116046 End

Line 1999: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

1995: ( p_count => x_msg_count,
1996: p_data => x_msg_data
1997: );
1998: --Bug 6116046 Begin
1999: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
2000: itemkey => l_item_key,
2001: aname => 'XW_RETURN_STATUS',
2002: avalue => x_return_status);
2003:

Line 2004: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

2000: itemkey => l_item_key,
2001: aname => 'XW_RETURN_STATUS',
2002: avalue => x_return_status);
2003:
2004: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
2005: itemkey => l_item_key,
2006: aname => 'XW_MSG_COUNT',
2007: avalue => x_msg_count);
2008:

Line 2009: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

2005: itemkey => l_item_key,
2006: aname => 'XW_MSG_COUNT',
2007: avalue => x_msg_count);
2008:
2009: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
2010: itemkey => l_item_key,
2011: aname => 'XW_MSG_DATA',
2012: avalue => x_msg_data);
2013: --Bug 6116046 End

Line 2054: l_txn_header_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

2050: l_item_key := itemkey;
2051:
2052: lx_return_status := FND_API.G_RET_STS_SUCCESS;
2053:
2054: l_txn_header_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
2055: itemkey => l_item_key,
2056: aname => 'PW_TRANSACTION_HEADER_ID');
2057:
2058: IF (l_debug = 1) THEN

Line 2077: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

2073: lx_return_status:= FND_API.G_RET_STS_ERROR ;
2074: END IF;
2075:
2076: -- workflow will check whether x_processed is either 'Y','N' or 'E'
2077: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
2078: itemkey => l_item_key,
2079: aname => 'XW_RETURN_STATUS',
2080: avalue => lx_return_status);
2081:

Line 2083: result :=wf_engine.eng_completed||':IS_TASK_PROCESS_YES';

2079: aname => 'XW_RETURN_STATUS',
2080: avalue => lx_return_status);
2081:
2082: IF (Upper(lx_processed) = 'Y') THEN
2083: result :=wf_engine.eng_completed||':IS_TASK_PROCESS_YES';
2084:
2085: ELSIF (Upper(lx_processed) = 'N') THEN
2086: result :=wf_engine.eng_completed||':IS_TASK_PROCESS_NO';
2087:

Line 2086: result :=wf_engine.eng_completed||':IS_TASK_PROCESS_NO';

2082: IF (Upper(lx_processed) = 'Y') THEN
2083: result :=wf_engine.eng_completed||':IS_TASK_PROCESS_YES';
2084:
2085: ELSIF (Upper(lx_processed) = 'N') THEN
2086: result :=wf_engine.eng_completed||':IS_TASK_PROCESS_NO';
2087:
2088: ELSE
2089: result :=wf_engine.eng_completed||':IS_TASK_PROCESS_ERROR';
2090: RAISE fnd_api.g_exc_error;

Line 2089: result :=wf_engine.eng_completed||':IS_TASK_PROCESS_ERROR';

2085: ELSIF (Upper(lx_processed) = 'N') THEN
2086: result :=wf_engine.eng_completed||':IS_TASK_PROCESS_NO';
2087:
2088: ELSE
2089: result :=wf_engine.eng_completed||':IS_TASK_PROCESS_ERROR';
2090: RAISE fnd_api.g_exc_error;
2091: END IF;
2092:
2093: EXCEPTION

Line 2164: l_header_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

2160: -- set itemtype and itemkey to local variables
2161: l_workflow_name := itemtype;
2162: l_item_key := itemkey;
2163:
2164: l_header_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
2165: itemkey => l_item_key,
2166: aname =>
2167: 'PW_TRANSACTION_HEADER_ID');
2168:

Line 2169: l_mo_line_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

2165: itemkey => l_item_key,
2166: aname =>
2167: 'PW_TRANSACTION_HEADER_ID');
2168:
2169: l_mo_line_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
2170: itemkey => l_item_key,
2171: aname =>
2172: 'PW_TRANSACTION_MO_LINE_ID');
2173:

Line 2174: l_old_sub_code := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

2170: itemkey => l_item_key,
2171: aname =>
2172: 'PW_TRANSACTION_MO_LINE_ID');
2173:
2174: l_old_sub_code := wf_engine.GetItemAttrText(itemtype => l_workflow_name,
2175: itemkey => l_item_key,
2176: aname =>
2177: 'PW_SOURCE_SUBINVENTORY');
2178:

Line 2179: l_old_loc_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

2175: itemkey => l_item_key,
2176: aname =>
2177: 'PW_SOURCE_SUBINVENTORY');
2178:
2179: l_old_loc_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
2180: itemkey => l_item_key,
2181: aname =>
2182: 'PW_SOURCE_LOCATOR');
2183:

Line 2184: l_task_type_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

2180: itemkey => l_item_key,
2181: aname =>
2182: 'PW_SOURCE_LOCATOR');
2183:
2184: l_task_type_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
2185: itemkey => l_item_key,
2186: aname => 'PW_TASK_TYPE_ID');
2187:
2188: -- call generate_next_task

Line 2212: result :=wf_engine.eng_completed||':GEN_NEXT_TASK_YES';

2208: mdebug('x_ret_code: '||lx_ret_code);
2209: END IF;
2210:
2211: IF (lx_return_status = fnd_api.g_ret_sts_success) THEN
2212: result :=wf_engine.eng_completed||':GEN_NEXT_TASK_YES';
2213: IF (l_debug = 1) THEN
2214: mdebug('In Generate Next Task -> Success');
2215: END IF;
2216: ELSE

Line 2218: result :=wf_engine.eng_completed||':GEN_NEXT_TASK_NO_QTY';

2214: mdebug('In Generate Next Task -> Success');
2215: END IF;
2216: ELSE
2217: IF (Upper(lx_ret_code) = 'QTY_NOT_AVAIL') THEN
2218: result :=wf_engine.eng_completed||':GEN_NEXT_TASK_NO_QTY';
2219: IF (l_debug = 1) THEN
2220: mdebug('In Generate Next Task -> No Available Qty');
2221: END IF;
2222: ELSE

Line 2223: result :=wf_engine.eng_completed||':GEN_NEXT_TASK_ERROR';

2219: IF (l_debug = 1) THEN
2220: mdebug('In Generate Next Task -> No Available Qty');
2221: END IF;
2222: ELSE
2223: result :=wf_engine.eng_completed||':GEN_NEXT_TASK_ERROR';
2224: IF (l_debug = 1) THEN
2225: mdebug('In Generate Next Task -> Error');
2226: END IF;
2227: END IF;

Line 2555: lp_organization_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

2551: l_workflow_name := itemtype;
2552: l_item_key := itemkey;
2553:
2554: -- populating the local procedure variables with the corresponding attributes from workflow
2555: lp_organization_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
2556: itemkey => l_item_key,
2557: aname => 'PW_SOURCE_ORGANIZATION_ID');
2558:
2559: lp_task_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

Line 2559: lp_task_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

2555: lp_organization_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
2556: itemkey => l_item_key,
2557: aname => 'PW_SOURCE_ORGANIZATION_ID');
2558:
2559: lp_task_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
2560: itemkey => l_item_key,
2561: aname => 'PW_TASK_ID');
2562:
2563: lp_qty_picked := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

Line 2563: lp_qty_picked := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

2559: lp_task_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
2560: itemkey => l_item_key,
2561: aname => 'PW_TASK_ID');
2562:
2563: lp_qty_picked := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
2564: itemkey => l_item_key,
2565: aname => 'PW_TRANSACTION_QUANTITY');
2566:
2567: lp_qty_uom := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

Line 2567: lp_qty_uom := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

2563: lp_qty_picked := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
2564: itemkey => l_item_key,
2565: aname => 'PW_TRANSACTION_QUANTITY');
2566:
2567: lp_qty_uom := wf_engine.GetItemAttrText(itemtype => l_workflow_name,
2568: itemkey => l_item_key,
2569: aname => 'PW_TRANSACTION_UOM');
2570:
2571: lp_carton_id := wf_engine.getItemAttrText(itemtype => l_workflow_name,

Line 2571: lp_carton_id := wf_engine.getItemAttrText(itemtype => l_workflow_name,

2567: lp_qty_uom := wf_engine.GetItemAttrText(itemtype => l_workflow_name,
2568: itemkey => l_item_key,
2569: aname => 'PW_TRANSACTION_UOM');
2570:
2571: lp_carton_id := wf_engine.getItemAttrText(itemtype => l_workflow_name,
2572: itemkey => l_item_key,
2573: aname => 'PW_LPN_ID');
2574:
2575: lp_user_id := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

Line 2575: lp_user_id := wf_engine.GetItemAttrText(itemtype => l_workflow_name,

2571: lp_carton_id := wf_engine.getItemAttrText(itemtype => l_workflow_name,
2572: itemkey => l_item_key,
2573: aname => 'PW_LPN_ID');
2574:
2575: lp_user_id := wf_engine.GetItemAttrText(itemtype => l_workflow_name,
2576: itemkey => l_item_key,
2577: aname => 'PW_EMPLOYEE_ID');
2578:
2579: lp_reason_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

Line 2579: lp_reason_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,

2575: lp_user_id := wf_engine.GetItemAttrText(itemtype => l_workflow_name,
2576: itemkey => l_item_key,
2577: aname => 'PW_EMPLOYEE_ID');
2578:
2579: lp_reason_id := wf_engine.GetItemAttrNumber(itemtype => l_workflow_name,
2580: itemkey => l_item_key,
2581: aname => 'PW_REASON_NAME');
2582:
2583:

Line 2627: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

2623: mdebug('After calling wms_txnrsn_actions_pub.suggest_alternate_location');
2624: END IF;
2625: -- setting the workflow attributes with the output results of
2626: -- the API wms_txnrsn_actions_pub.Inadequate_Qty
2627: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
2628: itemkey => l_item_key,
2629: aname => 'XW_RETURN_STATUS',
2630: avalue => lx_return_status);
2631:

Line 2632: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,

2628: itemkey => l_item_key,
2629: aname => 'XW_RETURN_STATUS',
2630: avalue => lx_return_status);
2631:
2632: wf_engine.SetItemAttrNumber(itemtype => l_workflow_name,
2633: itemkey => l_item_key,
2634: aname => 'XW_MSG_COUNT',
2635: avalue => lx_msg_count);
2636:

Line 2637: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

2633: itemkey => l_item_key,
2634: aname => 'XW_MSG_COUNT',
2635: avalue => lx_msg_count);
2636:
2637: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
2638: itemkey => l_item_key,
2639: aname => 'XW_MSG_DATA',
2640: avalue => lx_msg_data);
2641:

Line 2671: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

2667:
2668: -- if successful, populate the workflow attribute XW_IS_RESERVATION_SUCCESSFUL
2669: -- with 'Y', otherwise populate with 'N'
2670: if (lx_return_status = fnd_api.g_ret_sts_success) then
2671: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
2672: itemkey => l_item_key,
2673: aname => 'XW_IS_RESERVATION_SUCCESSFUL',
2674: avalue => 'YES');
2675: else

Line 2676: wf_engine.SetItemAttrText(itemtype => l_workflow_name,

2672: itemkey => l_item_key,
2673: aname => 'XW_IS_RESERVATION_SUCCESSFUL',
2674: avalue => 'YES');
2675: else
2676: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
2677: itemkey => l_item_key,
2678: aname => 'XW_IS_RESERVATION_SUCCESSFUL',
2679: avalue => 'NO');
2680: end if;